History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shothole"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 398 | 2025-10-11 05:44:26 | shothole | 1 | 82945 | 2 | 3.263 | 25419.9 |
| 397 | 2025-09-10 04:05:47 | shothole | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 396 | 2025-09-08 06:12:09 | shothole | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 395 | 2025-08-28 01:31:35 | shothole | 1 | 82945 | 2 | 1.563 | 53067.8 |
| 394 | 2025-08-11 01:56:57 | shothole | 1 | 82945 | 2 | 7.216 | 11494.6 |
| 393 | 2025-08-09 11:08:51 | shothole | 1 | 82945 | 2 | 5.173 | 16034.2 |
| 392 | 2025-08-09 03:39:38 | shothole | 1 | 82945 | 2 | 6.920 | 11986.3 |
| 391 | 2025-07-30 21:43:19 | shothole | 1 | 82945 | 2 | 5.356 | 15486.4 |
| 390 | 2025-07-27 00:19:14 | shothole | 1 | 82945 | 2 | 3.593 | 23085.2 |
| 389 | 2025-07-23 11:18:49 | shothole | 1 | 82945 | 2 | 3.266 | 25396.5 |
| 388 | 2025-07-23 00:46:09 | shothole | 1 | 82945 | 2 | 6.440 | 12879.7 |
| 387 | 2025-07-21 03:23:49 | shothole | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 386 | 2025-07-20 22:02:47 | shothole | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 385 | 2025-07-13 09:02:12 | shothole | 1 | 82945 | 2 | 3.173 | 26140.9 |
| 384 | 2025-06-16 13:07:31 | shothole | 3 | 146162 | 38 | 24.580 | 5946.4 |
| 383 | 2025-06-16 02:34:50 | shothole | 1 | 82945 | 2 | 6.890 | 12038.5 |
| 382 | 2025-06-15 08:21:15 | shothole | 1 | 82945 | 2 | 2.780 | 29836.3 |
| 381 | 2025-05-27 02:59:53 | shothole | 1 | 82945 | 2 | 3.830 | 21656.7 |
| 380 | 2025-05-17 23:26:28 | shothole | 1 | 82945 | 2 | 4.250 | 19516.5 |
| 379 | 2025-05-17 13:30:28 | shothole | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 378 | 2025-05-15 15:09:07 | shothole | 1 | 82945 | 2 | 7.313 | 11342.1 |
| 377 | 2025-05-15 02:02:02 | shothole | 4 | 161609 | 456 | 42.833 | 3773.0 |
| 376 | 2025-05-13 00:49:15 | shothole | 3 | 146162 | 38 | 29.050 | 5031.4 |
| 375 | 2025-05-12 13:23:58 | shothole | 3 | 146162 | 38 | 38.750 | 3771.9 |
| 374 | 2025-05-12 12:00:22 | shothole | 2 | 121059 | 4 | 16.750 | 7227.4 |
| 373 | 2025-05-08 16:25:14 | shothole | 1 | 82945 | 2 | 3.576 | 23194.9 |
| 372 | 2025-05-06 11:43:54 | shothole | 3 | 146162 | 38 | 45.406 | 3219.0 |
| 371 | 2025-05-06 02:47:35 | shothole | 3 | 146162 | 38 | 37.720 | 3874.9 |
| 370 | 2025-05-04 17:17:42 | shothole | 3 | 146162 | 38 | 27.190 | 5375.6 |
| 369 | 2025-05-04 13:17:21 | shothole | 3 | 146162 | 38 | 52.480 | 2785.1 |
| 368 | 2025-05-02 20:57:13 | shothole | 4 | 161609 | 456 | 47.780 | 3382.4 |
| 367 | 2025-05-02 18:55:52 | shothole | 3 | 146162 | 38 | 7.423 | 19690.4 |
| 366 | 2025-05-02 15:16:53 | shothole | 3 | 146162 | 38 | 37.156 | 3933.7 |
| 365 | 2025-05-01 19:05:20 | shothole | 2 | 121059 | 4 | 3.690 | 32807.3 |
| 364 | 2025-04-20 03:29:32 | shothole | 1 | 82945 | 2 | 4.813 | 17233.5 |
| 363 | 2025-04-11 14:59:24 | shothole | 1 | 82945 | 2 | 9.750 | 8507.2 |
| 362 | 2025-03-31 09:19:38 | shothole | 3 | 146162 | 38 | 30.600 | 4776.5 |
| 361 | 2025-03-30 19:55:10 | shothole | 2 | 121059 | 4 | 10.373 | 11670.6 |
| 360 | 2025-03-30 02:41:53 | shothole | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 359 | 2025-03-28 17:20:00 | shothole | 4 | 161609 | 456 | 29.470 | 5483.8 |
| 358 | 2025-03-27 13:55:14 | shothole | 4 | 161609 | 456 | 51.643 | 3129.3 |
| 357 | 2025-03-27 05:18:49 | shothole | 4 | 161609 | 456 | 66.550 | 2428.4 |
| 356 | 2025-03-26 20:10:09 | shothole | 3 | 146162 | 38 | 9.813 | 14894.7 |
| 355 | 2025-03-25 11:05:01 | shothole | 4 | 161609 | 456 | 63.816 | 2532.4 |
| 354 | 2025-03-24 18:32:43 | shothole | 3 | 146162 | 38 | 7.606 | 19216.7 |
| 353 | 2025-03-24 06:44:27 | shothole | 2 | 121059 | 4 | 17.643 | 6861.6 |
| 352 | 2025-03-24 04:40:54 | shothole | 3 | 146162 | 38 | 30.813 | 4743.5 |
| 351 | 2025-03-22 18:23:48 | shothole | 4 | 161609 | 456 | 64.380 | 2510.2 |
| 350 | 2025-03-16 11:53:37 | shothole | 1 | 82945 | 2 | 8.296 | 9998.2 |
| 349 | 2025-03-13 22:55:27 | shothole | 1 | 82945 | 2 | 6.263 | 13243.7 |
| 348 | 2025-03-10 17:20:52 | shothole | 1 | 82945 | 2 | 6.456 | 12847.7 |
| 347 | 2025-03-06 12:11:49 | shothole | 4 | 161609 | 456 | 46.390 | 3483.7 |
| 346 | 2025-03-06 05:14:37 | shothole | 4 | 161609 | 456 | 71.783 | 2251.4 |
| 345 | 2025-02-27 05:51:15 | shothole | 2 | 121059 | 4 | 9.140 | 13245.0 |
| 344 | 2025-02-27 05:50:45 | shothole | 1 | 82945 | 2 | 3.343 | 24811.5 |
| 343 | 2025-02-24 00:50:43 | shothole | 4 | 161609 | 456 | 60.033 | 2692.0 |
| 342 | 2025-02-23 08:23:01 | shothole | 4 | 161609 | 456 | 64.536 | 2504.2 |
| 341 | 2025-02-23 05:00:13 | shothole | 4 | 161609 | 456 | 65.460 | 2468.8 |
| 340 | 2025-02-22 16:32:43 | shothole | 4 | 161609 | 456 | 68.070 | 2374.2 |
| 339 | 2025-02-08 14:44:49 | shothole | 1 | 82945 | 2 | 6.190 | 13399.8 |
| 338 | 2025-01-31 13:59:01 | shothole | 3 | 146162 | 38 | 18.613 | 7852.7 |
| 337 | 2025-01-28 16:06:22 | shothole | 3 | 146162 | 38 | 41.010 | 3564.1 |
| 336 | 2025-01-28 00:05:44 | shothole | 3 | 146162 | 38 | 33.623 | 4347.1 |
| 335 | 2025-01-24 20:32:24 | shothole | 3 | 146162 | 38 | 23.623 | 6187.3 |
| 334 | 2025-01-23 09:32:51 | shothole | 3 | 146162 | 38 | 43.016 | 3397.9 |
| 333 | 2025-01-22 17:09:35 | shothole | 3 | 146162 | 38 | 38.466 | 3799.8 |
| 332 | 2025-01-21 19:10:39 | shothole | 3 | 146162 | 38 | 30.126 | 4851.7 |
| 331 | 2025-01-21 07:42:04 | shothole | 2 | 121059 | 4 | 18.813 | 6434.9 |
| 330 | 2025-01-21 07:39:33 | shothole | 4 | 161609 | 456 | 56.206 | 2875.3 |
| 329 | 2025-01-21 07:39:38 | shothole | 3 | 146162 | 38 | 31.456 | 4646.6 |
| 328 | 2025-01-21 07:39:19 | shothole | 1 | 82945 | 2 | 7.343 | 11295.8 |
| 327 | 2025-01-20 16:39:50 | shothole | 1 | 82945 | 2 | 6.686 | 12405.8 |
| 326 | 2025-01-08 12:32:00 | shothole | 2 | 121059 | 4 | 3.766 | 32145.2 |
| 325 | 2025-01-08 12:31:49 | shothole | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 324 | 2024-12-30 18:24:16 | shothole | 3 | 146162 | 38 | 6.373 | 22934.6 |
| 323 | 2024-12-28 03:11:11 | shothole | 3 | 146162 | 38 | 41.626 | 3511.3 |
| 322 | 2024-12-27 18:35:11 | shothole | 3 | 146162 | 38 | 6.330 | 23090.4 |
| 321 | 2024-12-23 22:30:24 | shothole | 3 | 146162 | 38 | 38.406 | 3805.7 |
| 320 | 2024-12-23 15:14:42 | shothole | 3 | 146162 | 38 | 35.243 | 4147.3 |
| 319 | 2024-12-21 08:48:27 | shothole | 3 | 146162 | 38 | 8.720 | 16761.7 |
| 318 | 2024-12-21 08:48:24 | shothole | 3 | 146162 | 38 | 8.470 | 17256.4 |
| 317 | 2024-12-21 08:48:28 | shothole | 2 | 121059 | 4 | 4.390 | 27576.1 |
| 316 | 2024-12-21 08:48:19 | shothole | 1 | 82945 | 2 | 1.280 | 64800.8 |
| 315 | 2024-12-15 23:13:18 | shothole | 1 | 82945 | 2 | 10.733 | 7728.0 |
| 314 | 2024-12-07 12:21:11 | shothole | 2 | 121059 | 4 | 6.236 | 19412.9 |
| 313 | 2024-12-07 12:21:01 | shothole | 1 | 82945 | 2 | 3.266 | 25396.5 |
| 312 | 2024-11-28 17:44:22 | shothole | 2 | 121059 | 4 | 19.316 | 6267.3 |
| 311 | 2024-11-28 02:29:23 | shothole | 3 | 146162 | 38 | 30.686 | 4763.1 |
| 310 | 2024-11-27 08:38:45 | shothole | 3 | 146162 | 38 | 42.443 | 3443.7 |
| 309 | 2024-11-25 04:41:44 | shothole | 1 | 82945 | 2 | 7.250 | 11440.7 |
| 308 | 2024-11-25 03:30:40 | shothole | 4 | 161609 | 456 | 64.710 | 2497.4 |
| 307 | 2024-11-22 20:07:57 | shothole | 4 | 161609 | 456 | 65.456 | 2469.0 |
| 306 | 2024-11-21 18:02:35 | shothole | 4 | 161609 | 456 | 63.613 | 2540.5 |
| 305 | 2024-11-21 02:42:38 | shothole | 4 | 161609 | 456 | 73.500 | 2198.8 |
| 304 | 2024-11-20 17:25:36 | shothole | 4 | 161609 | 456 | 24.096 | 6706.9 |
| 303 | 2024-11-20 17:25:35 | shothole | 3 | 146162 | 38 | 13.360 | 10940.3 |
| 302 | 2024-11-20 17:25:34 | shothole | 2 | 121059 | 4 | 7.233 | 16737.0 |
| 301 | 2024-11-20 17:23:44 | shothole | 1 | 82945 | 2 | 1.626 | 51011.7 |
| 300 | 2024-11-03 22:38:06 | shothole | 1 | 82945 | 2 | 6.016 | 13787.4 |
| 299 | 2024-10-21 02:24:28 | shothole | 4 | 161609 | 456 | 54.520 | 2964.2 |