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 |
| 766 | 2025-10-24 06:07:23 | gallons | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 765 | 2025-10-24 06:06:52 | gallons | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 764 | 2025-10-20 14:43:05 | gallons | 1 | 69583 | 8 | 1.236 | 56296.9 |
| 763 | 2025-10-09 06:43:34 | gallons | 1 | 69583 | 8 | 1.263 | 55093.4 |
| 762 | 2025-10-03 19:12:57 | gallons | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 761 | 2025-09-25 21:05:03 | gallons | 1 | 69583 | 8 | 5.983 | 11630.1 |
| 760 | 2025-09-20 18:52:24 | gallons | 1 | 69583 | 8 | 1.123 | 61961.7 |
| 759 | 2025-09-15 05:20:28 | gallons | 1 | 69583 | 8 | 1.173 | 59320.5 |
| 758 | 2025-09-05 01:17:56 | gallons | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 757 | 2025-09-02 16:14:32 | gallons | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 756 | 2025-08-28 04:19:58 | gallons | 1 | 69583 | 8 | 1.236 | 56296.9 |
| 755 | 2025-08-27 01:29:49 | gallons | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 754 | 2025-08-25 23:42:23 | gallons | 1 | 69583 | 8 | 2.970 | 23428.6 |
| 753 | 2025-08-25 11:37:43 | gallons | 1 | 69583 | 8 | 3.346 | 20795.9 |
| 752 | 2025-08-22 18:56:25 | gallons | 1 | 69583 | 8 | 2.750 | 25302.9 |
| 751 | 2025-08-19 16:17:45 | gallons | 1 | 69583 | 8 | 4.203 | 16555.6 |
| 750 | 2025-08-17 19:22:21 | gallons | 1 | 69583 | 8 | 5.156 | 13495.5 |
| 749 | 2025-08-17 01:38:49 | gallons | 1 | 69583 | 8 | 1.953 | 35628.8 |
| 748 | 2025-08-06 10:29:21 | gallons | 3 | 134027 | 537 | 35.516 | 3773.7 |
| 747 | 2025-08-05 15:29:50 | gallons | 1 | 69583 | 8 | 4.593 | 15149.8 |
| 746 | 2025-08-04 08:20:47 | gallons | 1 | 69583 | 8 | 4.343 | 16021.9 |
| 745 | 2025-08-01 23:16:02 | gallons | 1 | 69583 | 8 | 2.563 | 27149.0 |
| 744 | 2025-07-29 07:28:36 | gallons | 2 | 107671 | 66 | 10.093 | 10667.9 |
| 743 | 2025-07-29 07:18:16 | gallons | 3 | 134027 | 537 | 16.236 | 8254.9 |
| 742 | 2025-07-27 06:31:55 | gallons | 1 | 69583 | 8 | 2.500 | 27833.2 |
| 741 | 2025-07-26 23:28:28 | gallons | 1 | 69583 | 8 | 2.076 | 33517.8 |
| 740 | 2025-07-25 06:17:07 | gallons | 1 | 69583 | 8 | 5.330 | 13055.0 |
| 739 | 2025-07-24 18:01:45 | gallons | 1 | 69583 | 8 | 2.906 | 23944.6 |
| 738 | 2025-07-24 11:30:26 | gallons | 3 | 134027 | 537 | 34.550 | 3879.2 |
| 737 | 2025-07-24 06:56:39 | gallons | 1 | 69583 | 8 | 2.940 | 23667.7 |
| 736 | 2025-07-24 03:51:59 | gallons | 1 | 69583 | 8 | 4.733 | 14701.7 |
| 735 | 2025-07-23 13:12:26 | gallons | 3 | 134027 | 537 | 20.406 | 6568.0 |
| 734 | 2025-07-23 01:24:50 | gallons | 1 | 69583 | 8 | 4.440 | 15671.8 |
| 733 | 2025-07-19 13:19:38 | gallons | 3 | 134027 | 537 | 6.093 | 21996.9 |
| 732 | 2025-07-19 04:15:00 | gallons | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 731 | 2025-07-18 04:25:46 | gallons | 2 | 107671 | 66 | 12.220 | 8811.0 |
| 730 | 2025-07-18 03:34:34 | gallons | 3 | 134027 | 537 | 36.813 | 3640.8 |
| 729 | 2025-07-16 17:45:34 | gallons | 1 | 69583 | 8 | 1.470 | 47335.4 |
| 728 | 2025-07-16 06:03:26 | gallons | 1 | 69583 | 8 | 1.313 | 52995.4 |
| 727 | 2025-07-15 02:50:01 | gallons | 1 | 69583 | 8 | 2.873 | 24219.6 |
| 726 | 2025-07-07 09:03:36 | gallons | 1 | 69583 | 8 | 8.283 | 8400.7 |
| 725 | 2025-07-06 06:30:24 | gallons | 1 | 69583 | 8 | 4.653 | 14954.4 |
| 724 | 2025-07-04 23:08:32 | gallons | 3 | 134027 | 537 | 31.283 | 4284.3 |
| 723 | 2025-07-04 12:51:43 | gallons | 2 | 107671 | 66 | 16.846 | 6391.5 |
| 722 | 2025-07-04 02:09:29 | gallons | 3 | 134027 | 537 | 35.046 | 3824.3 |
| 721 | 2025-07-03 08:14:33 | gallons | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 720 | 2025-06-20 11:33:29 | gallons | 1 | 69583 | 8 | 3.610 | 19275.1 |
| 719 | 2025-06-20 03:18:02 | gallons | 1 | 69583 | 8 | 6.280 | 11080.1 |
| 718 | 2025-06-18 00:54:46 | gallons | 2 | 107671 | 66 | 21.923 | 4911.3 |
| 717 | 2025-06-16 16:43:22 | gallons | 1 | 69583 | 8 | 5.186 | 13417.5 |
| 716 | 2025-06-16 16:30:54 | gallons | 2 | 107671 | 66 | 16.110 | 6683.5 |
| 715 | 2025-06-16 11:50:22 | gallons | 3 | 134027 | 537 | 28.423 | 4715.4 |
| 714 | 2025-06-15 11:24:54 | gallons | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 713 | 2025-06-14 00:25:50 | gallons | 1 | 69583 | 8 | 5.970 | 11655.4 |
| 712 | 2025-06-12 00:05:25 | gallons | 3 | 134027 | 537 | 43.850 | 3056.5 |
| 711 | 2025-06-05 20:51:19 | gallons | 3 | 134027 | 537 | 6.423 | 20866.7 |
| 710 | 2025-06-03 00:52:42 | gallons | 3 | 134027 | 537 | 31.373 | 4272.0 |
| 709 | 2025-06-02 10:15:15 | gallons | 3 | 134027 | 537 | 62.566 | 2142.2 |
| 708 | 2025-06-01 01:48:13 | gallons | 3 | 134027 | 537 | 29.423 | 4555.2 |
| 707 | 2025-05-29 04:14:03 | gallons | 3 | 134027 | 537 | 23.720 | 5650.4 |
| 706 | 2025-05-28 12:03:31 | gallons | 2 | 107671 | 66 | 3.500 | 30763.1 |
| 705 | 2025-05-24 22:04:10 | gallons | 2 | 107671 | 66 | 10.720 | 10043.9 |
| 704 | 2025-05-24 21:46:29 | gallons | 3 | 134027 | 537 | 5.796 | 23124.1 |
| 703 | 2025-05-20 08:08:00 | gallons | 1 | 69583 | 8 | 3.250 | 21410.2 |
| 702 | 2025-05-20 03:07:23 | gallons | 1 | 69583 | 8 | 6.360 | 10940.7 |
| 701 | 2025-05-16 17:08:03 | gallons | 1 | 69583 | 8 | 7.876 | 8834.8 |
| 700 | 2025-05-16 16:19:11 | gallons | 2 | 107671 | 66 | 25.576 | 4209.8 |
| 699 | 2025-05-16 12:30:33 | gallons | 3 | 134027 | 537 | 34.736 | 3858.4 |
| 698 | 2025-05-15 12:51:36 | gallons | 1 | 69583 | 8 | 5.550 | 12537.5 |
| 697 | 2025-05-14 00:37:43 | gallons | 1 | 69583 | 8 | 9.703 | 7171.3 |
| 696 | 2025-05-14 00:31:06 | gallons | 1 | 69583 | 8 | 5.623 | 12374.7 |
| 695 | 2025-05-09 12:28:58 | gallons | 3 | 134027 | 537 | 12.483 | 10736.8 |
| 694 | 2025-05-08 21:34:58 | gallons | 3 | 134027 | 537 | 40.113 | 3341.2 |
| 693 | 2025-05-07 09:04:27 | gallons | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 692 | 2025-05-06 18:34:23 | gallons | 2 | 107671 | 66 | 16.736 | 6433.5 |
| 691 | 2025-05-03 01:19:06 | gallons | 3 | 134027 | 537 | 38.766 | 3457.3 |
| 690 | 2025-04-30 08:27:53 | gallons | 1 | 69583 | 8 | 5.623 | 12374.7 |
| 689 | 2025-04-29 23:02:22 | gallons | 3 | 134027 | 537 | 32.346 | 4143.5 |
| 688 | 2025-04-27 18:17:35 | gallons | 2 | 107671 | 66 | 3.423 | 31455.2 |
| 687 | 2025-04-25 21:52:18 | gallons | 3 | 134027 | 537 | 26.220 | 5111.6 |
| 686 | 2025-04-24 10:02:22 | gallons | 3 | 134027 | 537 | 36.546 | 3667.4 |
| 685 | 2025-04-23 01:36:01 | gallons | 3 | 134027 | 537 | 35.036 | 3825.4 |
| 684 | 2025-04-22 05:26:07 | gallons | 3 | 134027 | 537 | 9.563 | 14015.2 |
| 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 |