History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"giants"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 882 | 2024-04-27 11:36:55 | giants | 1 | 48755 | 3 | 1.873 | 26030.4 |
| 881 | 2024-04-26 23:00:31 | giants | 3 | 112716 | 1014 | 19.156 | 5884.1 |
| 880 | 2024-04-11 20:29:01 | giants | 3 | 112716 | 1014 | 9.450 | 11927.6 |
| 879 | 2024-04-11 20:27:51 | giants | 3 | 112716 | 1014 | 11.686 | 9645.4 |
| 878 | 2024-04-11 14:22:57 | giants | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 877 | 2024-04-11 06:49:12 | giants | 3 | 112716 | 1014 | 4.826 | 23356.0 |
| 876 | 2024-04-06 03:20:15 | giants | 2 | 82551 | 72 | 5.826 | 14169.4 |
| 875 | 2024-04-06 03:19:56 | giants | 1 | 48755 | 3 | 1.830 | 26642.1 |
| 874 | 2024-04-01 05:45:28 | giants | 3 | 112716 | 1014 | 5.686 | 19823.4 |
| 873 | 2024-03-30 15:57:34 | giants | 3 | 112716 | 1014 | 11.513 | 9790.3 |
| 872 | 2024-03-30 12:37:22 | giants | 3 | 112716 | 1014 | 12.796 | 8808.7 |
| 871 | 2024-03-28 11:32:15 | giants | 2 | 82551 | 72 | 2.436 | 33887.9 |
| 870 | 2024-03-28 11:32:14 | giants | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 869 | 2024-03-28 11:31:37 | giants | 3 | 112716 | 1014 | 8.173 | 13791.3 |
| 868 | 2024-03-27 03:35:01 | giants | 3 | 112716 | 1014 | 13.173 | 8556.6 |
| 867 | 2024-03-04 09:10:56 | giants | 1 | 48755 | 3 | 1.783 | 27344.4 |
| 866 | 2024-02-29 21:44:00 | giants | 3 | 112716 | 1014 | 7.983 | 14119.5 |
| 865 | 2024-02-29 08:32:46 | giants | 2 | 82551 | 72 | 2.640 | 31269.3 |
| 864 | 2024-02-29 08:30:43 | giants | 3 | 112716 | 1014 | 8.313 | 13559.0 |
| 863 | 2024-02-29 00:49:47 | giants | 3 | 112716 | 1014 | 5.560 | 20272.7 |
| 862 | 2024-02-28 14:14:55 | giants | 3 | 112716 | 1014 | 9.360 | 12042.3 |
| 861 | 2024-02-27 16:17:25 | giants | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 860 | 2024-02-27 08:32:46 | giants | 2 | 82551 | 72 | 2.656 | 31080.9 |
| 859 | 2024-02-27 08:32:21 | giants | 3 | 112716 | 1014 | 6.843 | 16471.7 |
| 858 | 2024-02-26 15:15:11 | giants | 3 | 112716 | 1014 | 8.453 | 13334.4 |
| 857 | 2024-02-25 18:11:13 | giants | 3 | 112716 | 1014 | 8.016 | 14061.4 |
| 856 | 2024-02-24 23:59:19 | giants | 3 | 112716 | 1014 | 5.736 | 19650.6 |
| 855 | 2024-02-23 22:05:30 | giants | 3 | 112716 | 1014 | 6.503 | 17332.9 |
| 854 | 2024-02-18 01:26:05 | giants | 1 | 48755 | 3 | 1.656 | 29441.4 |
| 853 | 2024-02-12 23:37:36 | giants | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 852 | 2024-02-04 03:35:03 | giants | 3 | 112716 | 1014 | 4.953 | 22757.1 |
| 851 | 2024-01-31 01:35:59 | giants | 2 | 82551 | 72 | 2.220 | 37185.1 |
| 850 | 2024-01-31 01:34:43 | giants | 3 | 112716 | 1014 | 5.906 | 19085.0 |
| 849 | 2024-01-30 04:08:50 | giants | 2 | 82551 | 72 | 2.390 | 34540.2 |
| 848 | 2024-01-30 04:06:18 | giants | 3 | 112716 | 1014 | 5.076 | 22205.7 |
| 847 | 2024-01-29 23:33:29 | giants | 3 | 112716 | 1014 | 5.423 | 20784.8 |
| 846 | 2024-01-21 21:20:12 | giants | 2 | 82551 | 72 | 2.090 | 39498.1 |
| 845 | 2024-01-21 01:58:08 | giants | 3 | 112716 | 1014 | 4.610 | 24450.3 |
| 844 | 2024-01-21 01:58:06 | giants | 2 | 82551 | 72 | 2.140 | 38575.2 |
| 843 | 2024-01-17 07:30:19 | giants | 2 | 82551 | 72 | 2.296 | 35954.3 |
| 842 | 2024-01-15 15:04:53 | giants | 3 | 112716 | 1014 | 6.576 | 17140.5 |
| 841 | 2024-01-15 10:44:55 | giants | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 840 | 2023-12-31 14:21:12 | giants | 3 | 112716 | 1014 | 4.703 | 23966.8 |
| 839 | 2023-12-31 14:21:10 | giants | 2 | 82551 | 72 | 2.156 | 38289.0 |
| 838 | 2023-12-15 18:08:54 | giants | 3 | 112716 | 1014 | 5.076 | 22205.7 |
| 837 | 2023-12-10 03:35:47 | giants | 3 | 112716 | 1014 | 5.093 | 22131.6 |
| 836 | 2023-11-27 12:42:01 | giants | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 835 | 2023-11-17 16:42:56 | giants | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 834 | 2023-11-13 22:31:00 | giants | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 833 | 2023-11-11 05:52:42 | giants | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 832 | 2023-11-02 17:36:28 | giants | 2 | 82551 | 72 | 2.330 | 35429.6 |
| 831 | 2023-11-02 07:33:06 | giants | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 830 | 2023-10-29 22:28:03 | giants | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 829 | 2023-10-29 20:40:59 | giants | 3 | 112716 | 1014 | 6.733 | 16740.8 |
| 828 | 2023-10-28 06:47:58 | giants | 3 | 112716 | 1014 | 5.203 | 21663.7 |
| 827 | 2023-10-26 12:51:35 | giants | 3 | 112716 | 1014 | 5.186 | 21734.7 |
| 826 | 2023-10-24 10:31:09 | giants | 3 | 112716 | 1014 | 4.763 | 23664.9 |
| 825 | 2023-10-20 11:45:52 | giants | 3 | 112716 | 1014 | 4.780 | 23580.8 |
| 824 | 2023-10-18 15:47:47 | giants | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 823 | 2023-10-13 23:52:48 | giants | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 822 | 2023-10-08 08:48:08 | giants | 3 | 112716 | 1014 | 4.763 | 23664.9 |
| 821 | 2023-10-07 19:11:30 | giants | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 820 | 2023-10-04 11:44:57 | giants | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 819 | 2023-09-28 04:56:36 | giants | 1 | 48755 | 3 | 1.640 | 29728.7 |
| 818 | 2023-09-26 21:36:55 | giants | 2 | 82551 | 72 | 2.123 | 38884.1 |
| 817 | 2023-09-12 18:43:36 | giants | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 816 | 2023-09-11 01:42:22 | giants | 3 | 112716 | 1014 | 5.220 | 21593.1 |
| 815 | 2023-09-08 18:11:00 | giants | 3 | 112716 | 1014 | 4.656 | 24208.8 |
| 814 | 2023-08-29 19:35:36 | giants | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 813 | 2023-08-13 15:08:32 | giants | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 812 | 2023-08-09 20:39:13 | giants | 2 | 82551 | 72 | 2.123 | 38884.1 |
| 811 | 2023-08-08 02:00:43 | giants | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 810 | 2023-07-09 16:29:04 | giants | 3 | 112716 | 1014 | 5.610 | 20092.0 |
| 809 | 2023-07-08 09:25:27 | giants | 3 | 112716 | 1014 | 6.720 | 16773.2 |
| 808 | 2023-07-07 15:31:20 | giants | 3 | 112716 | 1014 | 4.796 | 23502.1 |
| 807 | 2023-07-06 15:32:03 | giants | 3 | 112716 | 1014 | 4.703 | 23966.8 |
| 806 | 2023-07-04 09:55:26 | giants | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 805 | 2023-06-23 02:58:28 | giants | 3 | 112716 | 1014 | 5.186 | 21734.7 |
| 804 | 2023-06-17 05:02:52 | giants | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 803 | 2023-06-13 01:14:08 | giants | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 802 | 2023-06-03 20:06:35 | giants | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 801 | 2023-05-29 06:28:01 | giants | 3 | 112716 | 1014 | 4.936 | 22835.5 |
| 800 | 2023-05-11 19:12:04 | giants | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 799 | 2023-04-30 11:30:55 | giants | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 798 | 2023-04-28 23:18:43 | giants | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 797 | 2023-04-24 14:37:48 | giants | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 796 | 2023-04-20 18:03:10 | giants | 2 | 82551 | 72 | 2.436 | 33887.9 |
| 795 | 2023-03-25 22:26:53 | giants | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 794 | 2023-03-21 23:39:10 | giants | 1 | 48755 | 3 | 0.800 | 60943.8 |
| 793 | 2023-03-07 05:05:43 | giants | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 792 | 2023-03-07 04:30:23 | giants | 3 | 112716 | 1014 | 5.343 | 21096.0 |
| 791 | 2023-03-02 14:53:39 | giants | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 790 | 2023-01-28 00:30:46 | giants | 2 | 82551 | 72 | 2.110 | 39123.7 |
| 789 | 2023-01-26 06:25:55 | giants | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 788 | 2023-01-18 04:45:36 | giants | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 787 | 2023-01-14 15:35:52 | giants | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 786 | 2023-01-10 14:44:26 | giants | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 785 | 2023-01-09 23:52:09 | giants | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 784 | 2022-12-12 07:50:04 | giants | 3 | 112716 | 1014 | 4.826 | 23356.0 |
| 783 | 2022-12-12 02:44:38 | giants | 1 | 48755 | 3 | 0.830 | 58741.0 |