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 |
| 556 | 2026-04-07 20:42:13 | coliform | 1 | 82945 | 2 | 8.690 | 9544.9 |
| 555 | 2026-04-06 11:00:28 | coliform | 4 | 161609 | 350 | 34.643 | 4665.0 |
| 554 | 2026-04-05 22:41:56 | coliform | 3 | 146162 | 73 | 7.330 | 19940.2 |
| 553 | 2026-04-04 19:57:27 | coliform | 3 | 146162 | 73 | 37.193 | 3929.8 |
| 552 | 2026-04-03 19:33:15 | coliform | 3 | 146162 | 73 | 37.376 | 3910.6 |
| 551 | 2026-04-02 21:20:10 | coliform | 4 | 161609 | 350 | 71.486 | 2260.7 |
| 550 | 2026-04-02 09:30:49 | coliform | 4 | 161609 | 350 | 49.943 | 3235.9 |
| 549 | 2026-04-01 11:01:16 | coliform | 1 | 82945 | 2 | 9.093 | 9121.9 |
| 548 | 2026-04-01 02:05:51 | coliform | 1 | 82945 | 2 | 6.813 | 12174.5 |
| 547 | 2026-03-28 09:02:13 | coliform | 4 | 161609 | 350 | 86.146 | 1876.0 |
| 546 | 2026-03-28 09:02:01 | coliform | 4 | 161609 | 350 | 83.523 | 1934.9 |
| 545 | 2026-03-27 17:33:10 | coliform | 1 | 82945 | 2 | 7.266 | 11415.5 |
| 544 | 2026-03-24 18:17:55 | coliform | 2 | 121059 | 12 | 19.703 | 6144.2 |
| 543 | 2026-03-24 18:17:43 | coliform | 2 | 121059 | 12 | 19.423 | 6232.8 |
| 542 | 2026-03-24 10:03:57 | coliform | 2 | 121059 | 12 | 17.983 | 6731.9 |
| 541 | 2026-03-21 11:53:52 | coliform | 1 | 82945 | 2 | 2.906 | 28542.7 |
| 540 | 2026-03-21 10:56:14 | coliform | 1 | 82945 | 2 | 4.906 | 16906.8 |
| 539 | 2026-03-20 23:29:01 | coliform | 1 | 82945 | 2 | 7.216 | 11494.6 |
| 538 | 2026-03-18 17:57:57 | coliform | 1 | 82945 | 2 | 1.750 | 47397.1 |
| 537 | 2026-03-11 06:05:36 | coliform | 4 | 161609 | 350 | 13.420 | 12042.4 |
| 536 | 2026-03-09 16:49:59 | coliform | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 535 | 2026-03-01 10:44:54 | coliform | 4 | 161609 | 350 | 13.110 | 12327.2 |
| 534 | 2026-03-01 07:36:23 | coliform | 3 | 146162 | 73 | 9.376 | 15589.0 |
| 533 | 2026-02-27 18:40:07 | coliform | 3 | 146162 | 73 | 39.160 | 3732.4 |
| 532 | 2026-02-27 16:33:38 | coliform | 3 | 146162 | 73 | 32.033 | 4562.9 |
| 531 | 2026-02-24 15:45:14 | coliform | 4 | 161609 | 350 | 13.886 | 11638.3 |
| 530 | 2026-02-23 23:09:28 | coliform | 4 | 161609 | 350 | 54.846 | 2946.6 |
| 529 | 2026-02-22 16:13:59 | coliform | 3 | 146162 | 73 | 8.046 | 18165.8 |
| 528 | 2026-02-21 13:56:09 | coliform | 4 | 161609 | 350 | 33.876 | 4770.6 |
| 527 | 2026-02-20 22:14:27 | coliform | 4 | 161609 | 350 | 14.830 | 10897.4 |
| 526 | 2026-02-14 07:45:22 | coliform | 1 | 82945 | 2 | 9.876 | 8398.6 |
| 525 | 2026-02-12 07:06:28 | coliform | 1 | 82945 | 2 | 1.513 | 54821.5 |
| 524 | 2026-02-09 08:11:53 | coliform | 1 | 82945 | 2 | 3.830 | 21656.7 |
| 523 | 2026-02-09 08:11:41 | coliform | 1 | 82945 | 2 | 3.716 | 22321.0 |
| 522 | 2026-02-08 22:54:34 | coliform | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 521 | 2026-02-07 01:59:33 | coliform | 2 | 121059 | 12 | 7.843 | 15435.3 |
| 520 | 2026-02-05 06:02:30 | coliform | 4 | 161609 | 350 | 13.483 | 11986.1 |
| 519 | 2026-01-30 15:48:20 | coliform | 4 | 161609 | 350 | 13.610 | 11874.3 |
| 518 | 2026-01-28 17:04:50 | coliform | 2 | 121059 | 12 | 3.546 | 34139.6 |
| 517 | 2026-01-19 09:03:05 | coliform | 1 | 82945 | 2 | 3.500 | 23698.6 |
| 516 | 2026-01-19 09:02:54 | coliform | 1 | 82945 | 2 | 5.940 | 13963.8 |
| 515 | 2026-01-03 21:47:08 | coliform | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 514 | 2026-01-02 03:08:56 | coliform | 1 | 82945 | 2 | 1.626 | 51011.7 |
| 513 | 2026-01-02 00:28:38 | coliform | 4 | 161609 | 350 | 12.096 | 13360.5 |
| 512 | 2025-12-30 18:58:57 | coliform | 1 | 82945 | 2 | 1.410 | 58826.2 |
| 511 | 2025-12-28 01:06:19 | coliform | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 510 | 2025-12-25 13:09:26 | coliform | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 509 | 2025-12-14 02:22:22 | coliform | 1 | 82945 | 2 | 3.360 | 24686.0 |
| 508 | 2025-12-13 14:13:27 | coliform | 1 | 82945 | 2 | 1.440 | 57600.7 |
| 507 | 2025-12-13 07:51:14 | coliform | 1 | 82945 | 2 | 1.563 | 53067.8 |
| 506 | 2025-12-11 17:24:04 | coliform | 4 | 161609 | 350 | 66.266 | 2438.8 |
| 505 | 2025-12-09 09:01:07 | coliform | 4 | 161609 | 350 | 14.126 | 11440.5 |
| 504 | 2025-12-08 14:11:29 | coliform | 4 | 161609 | 350 | 12.233 | 13210.9 |
| 503 | 2025-12-07 23:32:18 | coliform | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 502 | 2025-12-07 11:56:25 | coliform | 4 | 161609 | 350 | 11.860 | 13626.4 |
| 501 | 2025-12-05 15:46:39 | coliform | 4 | 161609 | 350 | 22.393 | 7216.9 |
| 500 | 2025-12-04 07:11:23 | coliform | 2 | 121059 | 12 | 3.326 | 36397.8 |
| 499 | 2025-12-04 04:15:30 | coliform | 4 | 161609 | 350 | 12.906 | 12522.0 |
| 498 | 2025-11-27 01:45:06 | coliform | 4 | 161609 | 350 | 15.970 | 10119.5 |
| 497 | 2025-11-14 15:48:05 | coliform | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 496 | 2025-11-12 07:23:40 | coliform | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 495 | 2025-11-09 04:46:19 | coliform | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 494 | 2025-11-06 14:50:37 | coliform | 4 | 161609 | 350 | 12.470 | 12959.8 |
| 493 | 2025-11-06 01:44:54 | coliform | 1 | 82945 | 2 | 1.843 | 45005.4 |
| 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 |