History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coliform"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 492 | 2025-10-29 01:56:16 | coliform | 4 | 161609 | 350 | 13.080 | 12355.4 |
| 491 | 2025-10-18 13:11:53 | coliform | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 490 | 2025-10-14 17:41:31 | coliform | 1 | 82945 | 2 | 1.360 | 60989.0 |
| 489 | 2025-10-10 04:28:54 | coliform | 4 | 161609 | 350 | 13.080 | 12355.4 |
| 488 | 2025-09-19 12:07:53 | coliform | 4 | 161609 | 350 | 13.983 | 11557.5 |
| 487 | 2025-09-19 07:33:34 | coliform | 1 | 82945 | 2 | 1.420 | 58412.0 |
| 486 | 2025-09-09 16:44:33 | coliform | 1 | 82945 | 2 | 1.513 | 54821.5 |
| 485 | 2025-08-18 21:04:47 | coliform | 1 | 82945 | 2 | 7.530 | 11015.3 |
| 484 | 2025-08-17 15:41:21 | coliform | 4 | 161609 | 350 | 31.783 | 5084.8 |
| 483 | 2025-08-17 06:57:00 | coliform | 4 | 161609 | 350 | 51.986 | 3108.7 |
| 482 | 2025-08-15 16:40:29 | coliform | 4 | 161609 | 350 | 67.940 | 2378.7 |
| 481 | 2025-08-15 09:53:08 | coliform | 2 | 121059 | 12 | 9.970 | 12142.3 |
| 480 | 2025-08-14 13:50:42 | coliform | 1 | 82945 | 2 | 1.643 | 50483.9 |
| 479 | 2025-08-13 14:21:57 | coliform | 1 | 82945 | 2 | 1.360 | 60989.0 |
| 478 | 2025-08-11 04:24:42 | coliform | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 477 | 2025-08-09 10:31:01 | coliform | 1 | 82945 | 2 | 3.626 | 22875.1 |
| 476 | 2025-07-27 03:56:15 | coliform | 1 | 82945 | 2 | 4.530 | 18310.2 |
| 475 | 2025-07-24 20:36:19 | coliform | 1 | 82945 | 2 | 3.970 | 20892.9 |
| 474 | 2025-07-19 22:32:31 | coliform | 3 | 146162 | 73 | 7.736 | 18893.7 |
| 473 | 2025-07-16 20:13:47 | coliform | 1 | 82945 | 2 | 3.936 | 21073.4 |
| 472 | 2025-07-07 09:20:15 | coliform | 1 | 82945 | 2 | 3.780 | 21943.1 |
| 471 | 2025-07-03 03:17:59 | coliform | 1 | 82945 | 2 | 9.813 | 8452.6 |
| 470 | 2025-06-28 20:47:07 | coliform | 1 | 82945 | 2 | 1.560 | 53169.9 |
| 469 | 2025-06-27 17:40:35 | coliform | 4 | 161609 | 350 | 58.133 | 2780.0 |
| 468 | 2025-06-26 03:44:13 | coliform | 1 | 82945 | 2 | 4.173 | 19876.6 |
| 467 | 2025-06-25 03:19:44 | coliform | 4 | 161609 | 350 | 63.613 | 2540.5 |
| 466 | 2025-06-23 15:40:09 | coliform | 4 | 161609 | 350 | 12.983 | 12447.7 |
| 465 | 2025-06-20 09:24:17 | coliform | 1 | 82945 | 2 | 4.203 | 19734.7 |
| 464 | 2025-06-20 00:37:49 | coliform | 4 | 161609 | 350 | 56.050 | 2883.3 |
| 463 | 2025-06-18 17:08:23 | coliform | 1 | 82945 | 2 | 6.953 | 11929.4 |
| 462 | 2025-06-18 15:07:40 | coliform | 4 | 161609 | 350 | 41.723 | 3873.4 |
| 461 | 2025-06-17 02:55:15 | coliform | 4 | 161609 | 350 | 77.100 | 2096.1 |
| 460 | 2025-06-16 07:16:29 | coliform | 4 | 161609 | 350 | 87.423 | 1848.6 |
| 459 | 2025-06-15 05:59:58 | coliform | 4 | 161609 | 350 | 11.390 | 14188.7 |
| 458 | 2025-06-11 16:18:31 | coliform | 1 | 82945 | 2 | 3.233 | 25655.7 |
| 457 | 2025-06-11 12:53:42 | coliform | 1 | 82945 | 2 | 3.000 | 27648.3 |
| 456 | 2025-06-10 15:26:15 | coliform | 1 | 82945 | 2 | 7.703 | 10767.9 |
| 455 | 2025-06-06 14:14:50 | coliform | 3 | 146162 | 73 | 26.550 | 5505.2 |
| 454 | 2025-06-06 02:23:44 | coliform | 2 | 121059 | 12 | 18.753 | 6455.4 |
| 453 | 2025-06-05 11:14:38 | coliform | 1 | 82945 | 2 | 4.826 | 17187.1 |
| 452 | 2025-06-05 08:57:46 | coliform | 1 | 82945 | 2 | 1.596 | 51970.6 |
| 451 | 2025-05-31 20:52:45 | coliform | 1 | 82945 | 2 | 5.173 | 16034.2 |
| 450 | 2025-05-31 04:36:42 | coliform | 1 | 82945 | 2 | 6.423 | 12913.7 |
| 449 | 2025-05-27 17:21:19 | coliform | 4 | 161609 | 350 | 82.740 | 1953.2 |
| 448 | 2025-05-26 03:58:51 | coliform | 1 | 82945 | 2 | 5.236 | 15841.3 |
| 447 | 2025-05-25 03:27:40 | coliform | 4 | 161609 | 350 | 64.843 | 2492.3 |
| 446 | 2025-05-23 11:55:03 | coliform | 4 | 161609 | 350 | 74.880 | 2158.2 |
| 445 | 2025-05-16 15:34:09 | coliform | 4 | 161609 | 350 | 75.286 | 2146.6 |
| 444 | 2025-05-14 08:17:41 | coliform | 4 | 161609 | 350 | 63.396 | 2549.2 |
| 443 | 2025-05-12 06:24:29 | coliform | 4 | 161609 | 350 | 83.926 | 1925.6 |
| 442 | 2025-05-10 12:07:44 | coliform | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 441 | 2025-05-09 17:41:45 | coliform | 3 | 146162 | 73 | 11.750 | 12439.3 |
| 440 | 2025-05-09 13:22:37 | coliform | 3 | 146162 | 73 | 7.140 | 20470.9 |
| 439 | 2025-05-06 16:29:17 | coliform | 1 | 82945 | 2 | 3.906 | 21235.3 |
| 438 | 2025-05-04 23:24:30 | coliform | 3 | 146162 | 73 | 33.330 | 4385.3 |
| 437 | 2025-04-30 03:28:22 | coliform | 3 | 146162 | 73 | 33.503 | 4362.7 |
| 436 | 2025-04-28 13:10:56 | coliform | 1 | 82945 | 2 | 4.656 | 17814.6 |
| 435 | 2025-04-20 23:19:55 | coliform | 4 | 161609 | 350 | 100.036 | 1615.5 |
| 434 | 2025-04-16 14:03:56 | coliform | 4 | 161609 | 350 | 62.630 | 2580.4 |
| 433 | 2025-04-15 23:16:36 | coliform | 4 | 161609 | 350 | 60.253 | 2682.2 |
| 432 | 2025-04-15 20:45:49 | coliform | 1 | 82945 | 2 | 4.590 | 18070.8 |
| 431 | 2025-04-14 17:42:43 | coliform | 4 | 161609 | 350 | 79.630 | 2029.5 |
| 430 | 2025-04-12 06:59:53 | coliform | 4 | 161609 | 350 | 46.876 | 3447.6 |
| 429 | 2025-04-10 16:14:56 | coliform | 4 | 161609 | 350 | 13.406 | 12055.0 |
| 428 | 2025-04-10 15:47:59 | coliform | 3 | 146162 | 73 | 8.203 | 17818.1 |
| 427 | 2025-03-30 10:56:35 | coliform | 1 | 82945 | 2 | 6.796 | 12205.0 |
| 426 | 2025-03-25 22:01:51 | coliform | 3 | 146162 | 73 | 12.483 | 11708.9 |
| 425 | 2025-03-24 02:28:40 | coliform | 2 | 121059 | 12 | 18.720 | 6466.8 |
| 424 | 2025-03-23 15:54:38 | coliform | 3 | 146162 | 73 | 37.360 | 3912.3 |
| 423 | 2025-03-23 05:13:57 | coliform | 1 | 82945 | 2 | 9.923 | 8358.9 |
| 422 | 2025-03-22 02:56:13 | coliform | 3 | 146162 | 73 | 16.436 | 8892.8 |
| 421 | 2025-03-21 12:29:17 | coliform | 3 | 146162 | 73 | 36.533 | 4000.8 |
| 420 | 2025-03-20 17:21:40 | coliform | 1 | 82945 | 2 | 7.563 | 10967.2 |
| 419 | 2025-03-17 19:13:53 | coliform | 3 | 146162 | 73 | 24.796 | 5894.6 |
| 418 | 2025-03-17 05:56:17 | coliform | 3 | 146162 | 73 | 39.443 | 3705.7 |
| 417 | 2025-03-15 08:47:00 | coliform | 1 | 82945 | 2 | 6.470 | 12819.9 |
| 416 | 2025-03-14 01:07:09 | coliform | 3 | 146162 | 73 | 40.780 | 3584.2 |
| 415 | 2025-03-12 19:08:07 | coliform | 4 | 161609 | 350 | 63.023 | 2564.3 |
| 414 | 2025-03-12 05:56:23 | coliform | 4 | 161609 | 350 | 62.283 | 2594.8 |
| 413 | 2025-03-09 12:07:29 | coliform | 4 | 161609 | 350 | 50.906 | 3174.7 |
| 412 | 2025-03-08 19:04:15 | coliform | 1 | 82945 | 2 | 8.800 | 9425.6 |
| 411 | 2025-03-05 08:54:39 | coliform | 4 | 161609 | 350 | 59.526 | 2714.9 |
| 410 | 2025-02-28 20:37:35 | coliform | 1 | 82945 | 2 | 6.593 | 12580.8 |
| 409 | 2025-02-28 04:20:29 | coliform | 1 | 82945 | 2 | 7.660 | 10828.3 |
| 408 | 2025-02-24 05:21:52 | coliform | 4 | 161609 | 350 | 82.833 | 1951.0 |
| 407 | 2025-02-10 13:12:19 | coliform | 4 | 161609 | 350 | 50.753 | 3184.2 |
| 406 | 2025-02-10 05:39:59 | coliform | 4 | 161609 | 350 | 69.190 | 2335.7 |
| 405 | 2025-02-09 23:11:39 | coliform | 4 | 161609 | 350 | 73.360 | 2203.0 |
| 404 | 2025-02-09 23:11:37 | coliform | 2 | 121059 | 12 | 25.720 | 4706.8 |
| 403 | 2025-02-08 16:56:33 | coliform | 3 | 146162 | 73 | 13.923 | 10497.9 |
| 402 | 2025-02-06 19:06:28 | coliform | 3 | 146162 | 73 | 35.906 | 4070.7 |
| 401 | 2025-02-05 04:08:53 | coliform | 1 | 82945 | 2 | 5.686 | 14587.6 |
| 400 | 2025-02-01 01:46:52 | coliform | 3 | 146162 | 73 | 49.393 | 2959.2 |
| 399 | 2025-02-01 01:46:27 | coliform | 1 | 82945 | 2 | 3.656 | 22687.4 |
| 398 | 2025-01-30 22:30:07 | coliform | 3 | 146162 | 73 | 35.893 | 4072.2 |
| 397 | 2025-01-29 18:47:36 | coliform | 3 | 146162 | 73 | 43.473 | 3362.1 |
| 396 | 2025-01-29 18:47:35 | coliform | 2 | 121059 | 12 | 20.610 | 5873.8 |
| 395 | 2025-01-28 22:58:42 | coliform | 3 | 146162 | 73 | 40.533 | 3606.0 |
| 394 | 2025-01-28 22:58:42 | coliform | 2 | 121059 | 12 | 21.736 | 5569.5 |
| 393 | 2025-01-28 22:58:35 | coliform | 1 | 82945 | 2 | 5.360 | 15474.8 |