History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pier"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1292 | 2026-04-18 17:42:29 | pier | 2 | 29872 | 380 | 2.266 | 13182.7 |
| 1291 | 2026-04-16 20:45:16 | pier | 1 | 13983 | 17 | 0.903 | 15485.0 |
| 1290 | 2026-04-15 23:11:33 | pier | 1 | 13983 | 17 | 0.470 | 29751.1 |
| 1289 | 2026-04-14 05:37:21 | pier | 1 | 13983 | 17 | 0.216 | 64736.1 |
| 1288 | 2026-04-12 03:58:31 | pier | 1 | 13983 | 17 | 0.640 | 21848.4 |
| 1287 | 2026-04-10 23:01:26 | pier | 1 | 13983 | 17 | 0.940 | 14875.5 |
| 1286 | 2026-04-07 23:16:56 | pier | 1 | 13983 | 17 | 1.326 | 10545.2 |
| 1285 | 2026-04-06 08:31:30 | pier | 1 | 13983 | 17 | 0.546 | 25609.9 |
| 1284 | 2026-04-04 12:27:54 | pier | 1 | 13983 | 17 | 1.000 | 13983.0 |
| 1283 | 2026-04-02 12:47:44 | pier | 2 | 29872 | 380 | 2.186 | 13665.1 |
| 1282 | 2026-04-02 09:53:03 | pier | 2 | 29872 | 380 | 1.813 | 16476.6 |
| 1281 | 2026-04-01 07:07:54 | pier | 1 | 13983 | 17 | 1.030 | 13575.7 |
| 1280 | 2026-04-01 05:13:24 | pier | 1 | 13983 | 17 | 0.983 | 14224.8 |
| 1279 | 2026-04-01 04:03:29 | pier | 1 | 13983 | 17 | 1.516 | 9223.6 |
| 1278 | 2026-03-31 09:55:38 | pier | 2 | 29872 | 380 | 3.576 | 8353.5 |
| 1277 | 2026-03-29 18:25:57 | pier | 2 | 29872 | 380 | 0.783 | 38150.7 |
| 1276 | 2026-03-28 13:07:37 | pier | 2 | 29872 | 380 | 4.033 | 7406.9 |
| 1275 | 2026-03-26 23:21:42 | pier | 1 | 13983 | 17 | 0.953 | 14672.6 |
| 1274 | 2026-03-23 05:02:28 | pier | 1 | 13983 | 17 | 0.670 | 20870.1 |
| 1273 | 2026-03-21 21:45:42 | pier | 2 | 29872 | 380 | 0.876 | 34100.5 |
| 1272 | 2026-03-21 14:51:57 | pier | 2 | 29872 | 380 | 4.076 | 7328.8 |
| 1271 | 2026-03-20 13:00:06 | pier | 1 | 13983 | 17 | 1.250 | 11186.4 |
| 1270 | 2026-03-19 09:57:16 | pier | 1 | 13983 | 17 | 1.233 | 11340.6 |
| 1269 | 2026-03-10 00:55:20 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1268 | 2026-03-08 17:09:30 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1267 | 2026-03-07 02:14:52 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1266 | 2026-03-06 10:31:30 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1265 | 2026-02-22 01:07:53 | pier | 2 | 29872 | 380 | 0.923 | 32364.0 |
| 1264 | 2026-02-20 18:17:05 | pier | 1 | 13983 | 17 | 0.986 | 14181.5 |
| 1263 | 2026-02-20 10:08:29 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1262 | 2026-02-20 02:00:23 | pier | 1 | 13983 | 17 | 0.656 | 21315.5 |
| 1261 | 2026-02-18 19:22:10 | pier | 1 | 13983 | 17 | 0.280 | 49939.3 |
| 1260 | 2026-02-18 10:07:45 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1259 | 2026-02-17 11:57:05 | pier | 1 | 13983 | 17 | 0.236 | 59250.0 |
| 1258 | 2026-02-16 23:13:59 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1257 | 2026-02-16 07:25:02 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1256 | 2026-02-12 06:09:02 | pier | 1 | 13983 | 17 | 0.906 | 15433.8 |
| 1255 | 2026-02-12 06:08:11 | pier | 1 | 13983 | 17 | 0.280 | 49939.3 |
| 1254 | 2026-01-31 07:00:32 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1253 | 2026-01-31 03:57:54 | pier | 1 | 13983 | 17 | 1.513 | 9241.9 |
| 1252 | 2026-01-30 05:46:09 | pier | 1 | 13983 | 17 | 0.283 | 49409.9 |
| 1251 | 2026-01-28 20:39:47 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1250 | 2026-01-28 20:04:50 | pier | 1 | 13983 | 17 | 0.263 | 53167.3 |
| 1249 | 2026-01-28 12:33:20 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1248 | 2026-01-28 10:35:09 | pier | 1 | 13983 | 17 | 0.263 | 53167.3 |
| 1247 | 2026-01-28 09:55:32 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1246 | 2026-01-28 09:24:03 | pier | 1 | 13983 | 17 | 0.236 | 59250.0 |
| 1245 | 2026-01-28 06:10:24 | pier | 1 | 13983 | 17 | 0.860 | 16259.3 |
| 1244 | 2026-01-28 05:34:30 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1243 | 2026-01-28 01:24:20 | pier | 1 | 13983 | 17 | 0.530 | 26383.0 |
| 1242 | 2026-01-27 23:10:23 | pier | 1 | 13983 | 17 | 0.470 | 29751.1 |
| 1241 | 2026-01-27 21:39:00 | pier | 1 | 13983 | 17 | 0.763 | 18326.3 |
| 1240 | 2026-01-27 19:14:07 | pier | 1 | 13983 | 17 | 0.263 | 53167.3 |
| 1239 | 2026-01-27 13:08:42 | pier | 1 | 13983 | 17 | 0.470 | 29751.1 |
| 1238 | 2026-01-25 11:13:25 | pier | 2 | 29872 | 380 | 0.940 | 31778.7 |
| 1237 | 2026-01-25 02:51:11 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1236 | 2026-01-25 02:44:51 | pier | 1 | 13983 | 17 | 0.283 | 49409.9 |
| 1235 | 2026-01-20 20:04:08 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1234 | 2026-01-20 20:00:24 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1233 | 2026-01-20 20:00:08 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1232 | 2026-01-16 19:17:30 | pier | 1 | 13983 | 17 | 0.563 | 24836.6 |
| 1231 | 2026-01-16 09:23:22 | pier | 1 | 13983 | 17 | 0.296 | 47239.9 |
| 1230 | 2026-01-16 09:12:22 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1229 | 2026-01-16 08:57:18 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1228 | 2026-01-06 18:43:13 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1227 | 2026-01-03 03:44:22 | pier | 1 | 13983 | 17 | 0.216 | 64736.1 |
| 1226 | 2026-01-01 12:50:16 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1225 | 2026-01-01 09:29:21 | pier | 1 | 13983 | 17 | 0.470 | 29751.1 |
| 1224 | 2025-12-31 22:05:52 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1223 | 2025-12-29 06:57:25 | pier | 1 | 13983 | 17 | 0.263 | 53167.3 |
| 1222 | 2025-12-28 22:34:17 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1221 | 2025-12-26 04:45:53 | pier | 1 | 13983 | 17 | 0.326 | 42892.6 |
| 1220 | 2025-12-24 20:36:09 | pier | 1 | 13983 | 17 | 0.296 | 47239.9 |
| 1219 | 2025-12-22 20:51:01 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1218 | 2025-12-18 10:57:56 | pier | 1 | 13983 | 17 | 0.470 | 29751.1 |
| 1217 | 2025-12-17 01:00:27 | pier | 1 | 13983 | 17 | 1.236 | 11313.1 |
| 1216 | 2025-12-15 15:33:23 | pier | 2 | 29872 | 380 | 3.936 | 7589.4 |
| 1215 | 2025-12-13 21:00:53 | pier | 1 | 13983 | 17 | 0.263 | 53167.3 |
| 1214 | 2025-12-10 13:28:01 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1213 | 2025-12-09 14:14:41 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1212 | 2025-12-07 13:11:50 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1211 | 2025-12-04 06:47:14 | pier | 1 | 13983 | 17 | 0.300 | 46610.0 |
| 1210 | 2025-11-28 14:53:36 | pier | 2 | 29872 | 380 | 3.953 | 7556.8 |
| 1209 | 2025-11-24 16:11:27 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1208 | 2025-11-24 02:47:22 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1207 | 2025-11-21 15:27:04 | pier | 2 | 29872 | 380 | 0.873 | 34217.6 |
| 1206 | 2025-11-20 23:08:41 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1205 | 2025-11-19 21:18:42 | pier | 1 | 13983 | 17 | 0.846 | 16528.4 |
| 1204 | 2025-11-19 11:56:04 | pier | 1 | 13983 | 17 | 0.656 | 21315.5 |
| 1203 | 2025-11-19 06:03:45 | pier | 1 | 13983 | 17 | 0.530 | 26383.0 |
| 1202 | 2025-11-18 11:01:56 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1201 | 2025-11-18 06:30:34 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1200 | 2025-11-17 06:58:07 | pier | 2 | 29872 | 380 | 0.906 | 32971.3 |
| 1199 | 2025-11-16 23:01:16 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1198 | 2025-11-16 14:15:31 | pier | 1 | 13983 | 17 | 0.216 | 64736.1 |
| 1197 | 2025-11-14 13:19:48 | pier | 2 | 29872 | 380 | 0.920 | 32469.6 |
| 1196 | 2025-11-14 09:27:52 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1195 | 2025-11-13 16:31:08 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1194 | 2025-11-13 04:44:20 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1193 | 2025-11-12 14:15:47 | pier | 1 | 13983 | 17 | 0.216 | 64736.1 |