History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gallons"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
683 | 2025-04-20 07:13:40 | gallons | 1 | 69583 | 8 | 7.310 | 9518.9 |
682 | 2025-04-19 01:53:15 | gallons | 1 | 69583 | 8 | 5.750 | 12101.4 |
681 | 2025-04-16 15:23:57 | gallons | 1 | 69583 | 8 | 6.780 | 10263.0 |
680 | 2025-04-15 11:39:05 | gallons | 1 | 69583 | 8 | 1.080 | 64428.7 |
679 | 2025-04-12 00:24:17 | gallons | 1 | 69583 | 8 | 5.623 | 12374.7 |
678 | 2025-03-28 07:35:54 | gallons | 2 | 107671 | 66 | 3.310 | 32529.0 |
677 | 2025-03-22 19:28:02 | gallons | 1 | 69583 | 8 | 2.796 | 24886.6 |
676 | 2025-03-20 10:39:00 | gallons | 1 | 69583 | 8 | 5.516 | 12614.8 |
675 | 2025-03-20 09:08:04 | gallons | 1 | 69583 | 8 | 5.750 | 12101.4 |
674 | 2025-03-19 02:17:31 | gallons | 1 | 69583 | 8 | 1.063 | 65459.1 |
673 | 2025-03-16 13:16:13 | gallons | 3 | 134027 | 537 | 26.140 | 5127.3 |
672 | 2025-03-16 06:53:13 | gallons | 3 | 134027 | 537 | 34.593 | 3874.4 |
671 | 2025-03-13 14:02:51 | gallons | 1 | 69583 | 8 | 3.110 | 22374.0 |
670 | 2025-03-13 03:00:27 | gallons | 1 | 69583 | 8 | 5.516 | 12614.8 |
669 | 2025-03-13 02:58:47 | gallons | 2 | 107671 | 66 | 19.156 | 5620.7 |
668 | 2025-03-12 19:21:22 | gallons | 1 | 69583 | 8 | 8.080 | 8611.8 |
667 | 2025-03-12 19:12:30 | gallons | 2 | 107671 | 66 | 17.363 | 6201.2 |
666 | 2025-03-12 12:32:29 | gallons | 1 | 69583 | 8 | 3.780 | 18408.2 |
665 | 2025-03-12 12:32:10 | gallons | 2 | 107671 | 66 | 22.596 | 4765.0 |
664 | 2025-03-02 23:40:19 | gallons | 3 | 134027 | 537 | 48.536 | 2761.4 |
663 | 2025-03-02 18:34:40 | gallons | 3 | 134027 | 537 | 33.533 | 3996.9 |
662 | 2025-03-01 00:43:25 | gallons | 3 | 134027 | 537 | 28.863 | 4643.6 |
661 | 2025-02-28 03:50:41 | gallons | 3 | 134027 | 537 | 35.076 | 3821.0 |
660 | 2025-02-27 19:13:13 | gallons | 3 | 134027 | 537 | 36.533 | 3668.7 |
659 | 2025-02-27 16:50:34 | gallons | 3 | 134027 | 537 | 33.923 | 3950.9 |
658 | 2025-02-10 16:41:04 | gallons | 1 | 69583 | 8 | 3.733 | 18640.0 |
657 | 2025-02-09 04:18:55 | gallons | 1 | 69583 | 8 | 6.546 | 10629.9 |
656 | 2025-02-08 22:30:09 | gallons | 1 | 69583 | 8 | 8.420 | 8264.0 |
655 | 2025-02-03 20:22:06 | gallons | 1 | 69583 | 8 | 5.940 | 11714.3 |
654 | 2025-01-28 17:36:03 | gallons | 1 | 69583 | 8 | 4.280 | 16257.7 |
653 | 2025-01-10 05:00:42 | gallons | 2 | 107671 | 66 | 7.923 | 13589.7 |
652 | 2025-01-09 14:18:48 | gallons | 3 | 134027 | 537 | 21.513 | 6230.0 |
651 | 2025-01-09 13:55:32 | gallons | 3 | 134027 | 537 | 37.000 | 3622.4 |
650 | 2025-01-09 13:10:59 | gallons | 1 | 69583 | 8 | 6.063 | 11476.7 |
649 | 2025-01-09 12:38:21 | gallons | 3 | 134027 | 537 | 32.986 | 4063.1 |
648 | 2025-01-09 11:47:19 | gallons | 3 | 134027 | 537 | 39.720 | 3374.3 |
647 | 2025-01-09 11:47:18 | gallons | 2 | 107671 | 66 | 21.906 | 4915.1 |
646 | 2025-01-09 11:46:44 | gallons | 1 | 69583 | 8 | 3.266 | 21305.3 |
645 | 2024-12-11 09:57:36 | gallons | 1 | 69583 | 8 | 5.873 | 11847.9 |
644 | 2024-12-10 01:16:07 | gallons | 1 | 69583 | 8 | 2.533 | 27470.6 |
643 | 2024-11-27 01:39:49 | gallons | 1 | 69583 | 8 | 5.423 | 12831.1 |
642 | 2024-11-09 20:26:15 | gallons | 1 | 69583 | 8 | 6.093 | 11420.2 |
641 | 2024-11-09 10:37:07 | gallons | 1 | 69583 | 8 | 3.376 | 20611.1 |
640 | 2024-11-08 20:16:19 | gallons | 1 | 69583 | 8 | 3.046 | 22844.1 |
639 | 2024-10-26 11:11:33 | gallons | 1 | 69583 | 8 | 5.123 | 13582.5 |
638 | 2024-10-20 04:29:29 | gallons | 1 | 69583 | 8 | 5.266 | 13213.6 |
637 | 2024-10-08 05:24:58 | gallons | 1 | 69583 | 8 | 9.153 | 7602.2 |
636 | 2024-09-16 10:08:27 | gallons | 1 | 69583 | 8 | 11.106 | 6265.4 |
635 | 2024-09-16 10:01:43 | gallons | 3 | 134027 | 537 | 22.376 | 5989.8 |
634 | 2024-09-14 19:08:21 | gallons | 3 | 134027 | 537 | 67.003 | 2000.3 |
633 | 2024-09-14 10:27:46 | gallons | 3 | 134027 | 537 | 15.126 | 8860.7 |
632 | 2024-09-13 12:51:42 | gallons | 3 | 134027 | 537 | 38.036 | 3523.7 |
631 | 2024-09-13 05:24:48 | gallons | 3 | 134027 | 537 | 32.203 | 4161.9 |
630 | 2024-09-08 17:07:05 | gallons | 1 | 69583 | 8 | 10.003 | 6956.2 |
629 | 2024-09-07 13:28:58 | gallons | 1 | 69583 | 8 | 11.046 | 6299.4 |
628 | 2024-09-05 23:09:26 | gallons | 1 | 69583 | 8 | 12.393 | 5614.7 |
627 | 2024-09-05 06:53:03 | gallons | 1 | 69583 | 8 | 9.953 | 6991.2 |
626 | 2024-08-17 22:00:32 | gallons | 1 | 69583 | 8 | 8.343 | 8340.3 |
625 | 2024-08-12 18:48:31 | gallons | 1 | 69583 | 8 | 12.530 | 5553.3 |
624 | 2024-08-05 01:50:57 | gallons | 1 | 69583 | 8 | 2.656 | 26198.4 |
623 | 2024-08-03 02:07:37 | gallons | 1 | 69583 | 8 | 6.873 | 10124.1 |
622 | 2024-08-02 00:07:24 | gallons | 1 | 69583 | 8 | 2.826 | 24622.4 |
621 | 2024-08-01 09:59:46 | gallons | 1 | 69583 | 8 | 5.846 | 11902.7 |
620 | 2024-07-26 18:03:07 | gallons | 1 | 69583 | 8 | 6.060 | 11482.3 |
619 | 2024-07-26 18:02:37 | gallons | 1 | 69583 | 8 | 4.376 | 15901.1 |
618 | 2024-07-20 12:36:10 | gallons | 1 | 69583 | 8 | 4.670 | 14900.0 |
617 | 2024-07-20 02:08:38 | gallons | 3 | 134027 | 537 | 9.580 | 13990.3 |
616 | 2024-07-13 04:47:23 | gallons | 1 | 69583 | 8 | 2.580 | 26970.2 |
615 | 2024-07-05 09:57:33 | gallons | 1 | 69583 | 8 | 2.920 | 23829.8 |
614 | 2024-07-05 06:40:26 | gallons | 3 | 134027 | 537 | 16.406 | 8169.4 |
613 | 2024-07-04 16:25:01 | gallons | 3 | 134027 | 537 | 24.906 | 5381.3 |
612 | 2024-07-04 15:49:29 | gallons | 1 | 69583 | 8 | 5.780 | 12038.6 |
611 | 2024-07-04 00:52:30 | gallons | 2 | 107671 | 66 | 16.483 | 6532.2 |
610 | 2024-07-03 06:03:44 | gallons | 2 | 107671 | 66 | 16.596 | 6487.8 |
609 | 2024-07-03 05:04:33 | gallons | 2 | 107671 | 66 | 3.453 | 31181.9 |
608 | 2024-07-02 20:05:33 | gallons | 1 | 69583 | 8 | 4.203 | 16555.6 |
607 | 2024-07-02 19:44:58 | gallons | 3 | 134027 | 537 | 14.983 | 8945.3 |
606 | 2024-07-02 19:29:47 | gallons | 3 | 134027 | 537 | 29.033 | 4616.4 |
605 | 2024-07-02 01:39:44 | gallons | 3 | 134027 | 537 | 26.706 | 5018.6 |
604 | 2024-07-02 01:24:41 | gallons | 3 | 134027 | 537 | 30.906 | 4336.6 |
603 | 2024-07-02 00:31:28 | gallons | 3 | 134027 | 537 | 19.300 | 6944.4 |
602 | 2024-07-01 17:31:25 | gallons | 3 | 134027 | 537 | 33.063 | 4053.7 |
601 | 2024-07-01 16:55:07 | gallons | 3 | 134027 | 537 | 42.266 | 3171.0 |
600 | 2024-07-01 16:55:04 | gallons | 2 | 107671 | 66 | 19.670 | 5473.9 |
599 | 2024-07-01 16:52:22 | gallons | 1 | 69583 | 8 | 6.096 | 11414.5 |
598 | 2024-07-01 16:26:07 | gallons | 1 | 69583 | 8 | 4.140 | 16807.5 |
597 | 2024-07-01 14:13:41 | gallons | 1 | 69583 | 8 | 5.203 | 13373.6 |
596 | 2024-06-12 21:36:02 | gallons | 1 | 69583 | 8 | 1.343 | 51811.6 |
595 | 2024-06-08 17:49:19 | gallons | 1 | 69583 | 8 | 3.373 | 20629.4 |
594 | 2024-06-07 15:38:07 | gallons | 1 | 69583 | 8 | 1.983 | 35089.8 |
593 | 2024-05-28 21:46:24 | gallons | 1 | 69583 | 8 | 6.563 | 10602.3 |
592 | 2024-05-14 03:47:19 | gallons | 1 | 69583 | 8 | 1.143 | 60877.5 |
591 | 2024-05-09 07:50:04 | gallons | 1 | 69583 | 8 | 1.593 | 43680.5 |
590 | 2024-05-01 01:13:34 | gallons | 1 | 69583 | 8 | 1.283 | 54234.6 |
589 | 2024-04-23 03:36:44 | gallons | 3 | 134027 | 537 | 12.813 | 10460.2 |
588 | 2024-04-22 15:49:38 | gallons | 3 | 134027 | 537 | 26.906 | 4981.3 |
587 | 2024-04-20 16:05:34 | gallons | 3 | 134027 | 537 | 23.080 | 5807.1 |
586 | 2024-04-19 10:15:31 | gallons | 2 | 107671 | 66 | 11.656 | 9237.4 |
585 | 2024-04-19 08:58:33 | gallons | 3 | 134027 | 537 | 8.030 | 16690.8 |
584 | 2024-04-17 02:50:05 | gallons | 3 | 134027 | 537 | 5.796 | 23124.1 |