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 |
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 |
392 | 2025-01-23 09:31:55 | coliform | 1 | 82945 | 2 | 4.250 | 19516.5 |
391 | 2025-01-19 13:59:16 | coliform | 4 | 161609 | 350 | 43.926 | 3679.1 |
390 | 2025-01-10 12:04:54 | coliform | 2 | 121059 | 12 | 3.906 | 30993.1 |
389 | 2025-01-09 16:21:23 | coliform | 2 | 121059 | 12 | 18.940 | 6391.7 |
388 | 2025-01-07 22:17:52 | coliform | 4 | 161609 | 350 | 68.616 | 2355.3 |
387 | 2025-01-02 18:24:43 | coliform | 4 | 161609 | 350 | 61.443 | 2630.2 |
386 | 2025-01-02 04:46:00 | coliform | 4 | 161609 | 350 | 65.186 | 2479.2 |