History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scallop"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 980 | 2025-10-29 07:32:55 | scallop | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 979 | 2025-09-19 00:14:53 | scallop | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 978 | 2025-08-27 12:29:21 | scallop | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 977 | 2025-08-24 20:29:57 | scallop | 1 | 69583 | 5 | 5.436 | 12800.4 |
| 976 | 2025-08-24 19:21:57 | scallop | 1 | 69583 | 5 | 2.966 | 23460.2 |
| 975 | 2025-08-21 00:26:38 | scallop | 1 | 69583 | 5 | 8.466 | 8219.1 |
| 974 | 2025-08-09 12:43:32 | scallop | 1 | 69583 | 5 | 5.923 | 11747.9 |
| 973 | 2025-08-03 09:49:29 | scallop | 3 | 134027 | 170 | 27.283 | 4912.5 |
| 972 | 2025-07-29 17:51:22 | scallop | 1 | 69583 | 5 | 6.186 | 11248.5 |
| 971 | 2025-07-28 13:38:22 | scallop | 3 | 134027 | 170 | 22.390 | 5986.0 |
| 970 | 2025-07-27 16:15:41 | scallop | 2 | 107671 | 25 | 8.203 | 13125.8 |
| 969 | 2025-07-26 12:39:02 | scallop | 1 | 69583 | 5 | 1.300 | 53525.4 |
| 968 | 2025-07-25 20:07:26 | scallop | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 967 | 2025-07-24 22:34:06 | scallop | 1 | 69583 | 5 | 2.986 | 23303.1 |
| 966 | 2025-07-24 15:17:44 | scallop | 1 | 69583 | 5 | 5.513 | 12621.6 |
| 965 | 2025-07-23 23:02:11 | scallop | 1 | 69583 | 5 | 4.283 | 16246.3 |
| 964 | 2025-07-22 19:26:48 | scallop | 1 | 69583 | 5 | 5.673 | 12265.6 |
| 963 | 2025-07-22 17:36:56 | scallop | 1 | 69583 | 5 | 4.813 | 14457.3 |
| 962 | 2025-07-21 08:29:23 | scallop | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 961 | 2025-07-18 22:31:13 | scallop | 1 | 69583 | 5 | 1.766 | 39401.5 |
| 960 | 2025-07-15 23:14:23 | scallop | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 959 | 2025-07-15 17:13:22 | scallop | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 958 | 2025-07-15 02:02:29 | scallop | 1 | 69583 | 5 | 7.796 | 8925.5 |
| 957 | 2025-07-13 00:34:00 | scallop | 1 | 69583 | 5 | 5.330 | 13055.0 |
| 956 | 2025-07-10 07:19:32 | scallop | 1 | 69583 | 5 | 2.860 | 24329.7 |
| 955 | 2025-06-26 12:10:59 | scallop | 3 | 134027 | 170 | 36.550 | 3666.9 |
| 954 | 2025-06-26 08:23:32 | scallop | 2 | 107671 | 25 | 8.766 | 12282.8 |
| 953 | 2025-06-24 20:47:48 | scallop | 3 | 134027 | 170 | 7.360 | 18210.2 |
| 952 | 2025-06-23 03:59:24 | scallop | 2 | 107671 | 25 | 3.843 | 28017.4 |
| 951 | 2025-06-22 22:11:32 | scallop | 3 | 134027 | 170 | 10.296 | 13017.4 |
| 950 | 2025-06-21 22:04:09 | scallop | 1 | 69583 | 5 | 3.643 | 19100.5 |
| 949 | 2025-06-21 20:12:02 | scallop | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 948 | 2025-06-18 14:59:57 | scallop | 1 | 69583 | 5 | 2.890 | 24077.2 |
| 947 | 2025-06-08 00:44:21 | scallop | 1 | 69583 | 5 | 5.970 | 11655.4 |
| 946 | 2025-06-02 11:20:35 | scallop | 1 | 69583 | 5 | 7.300 | 9531.9 |
| 945 | 2025-05-21 22:03:27 | scallop | 1 | 69583 | 5 | 3.436 | 20251.2 |
| 944 | 2025-05-21 20:27:40 | scallop | 1 | 69583 | 5 | 6.046 | 11508.9 |
| 943 | 2025-05-21 00:06:06 | scallop | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 942 | 2025-05-20 18:36:10 | scallop | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 941 | 2025-05-16 15:21:58 | scallop | 1 | 69583 | 5 | 6.046 | 11508.9 |
| 940 | 2025-05-07 13:20:30 | scallop | 1 | 69583 | 5 | 1.376 | 50569.0 |
| 939 | 2025-05-06 00:45:49 | scallop | 1 | 69583 | 5 | 8.153 | 8534.6 |
| 938 | 2025-05-04 23:24:24 | scallop | 1 | 69583 | 5 | 8.940 | 7783.3 |
| 937 | 2025-05-01 23:23:25 | scallop | 1 | 69583 | 5 | 2.890 | 24077.2 |
| 936 | 2025-05-01 03:26:29 | scallop | 1 | 69583 | 5 | 6.656 | 10454.2 |
| 935 | 2025-04-27 08:43:20 | scallop | 3 | 134027 | 170 | 7.453 | 17983.0 |
| 934 | 2025-04-25 05:14:53 | scallop | 3 | 134027 | 170 | 11.346 | 11812.7 |
| 933 | 2025-04-24 12:49:05 | scallop | 1 | 69583 | 5 | 2.966 | 23460.2 |
| 932 | 2025-04-21 02:32:29 | scallop | 3 | 134027 | 170 | 21.610 | 6202.1 |
| 931 | 2025-04-20 20:00:34 | scallop | 2 | 107671 | 25 | 17.563 | 6130.6 |
| 930 | 2025-04-20 19:21:35 | scallop | 3 | 134027 | 170 | 29.923 | 4479.1 |
| 929 | 2025-04-18 03:02:15 | scallop | 2 | 107671 | 25 | 8.296 | 12978.7 |
| 928 | 2025-04-17 21:33:20 | scallop | 3 | 134027 | 170 | 38.903 | 3445.2 |
| 927 | 2025-04-16 20:00:16 | scallop | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 926 | 2025-04-16 13:53:24 | scallop | 1 | 69583 | 5 | 3.296 | 21111.3 |
| 925 | 2025-04-14 12:08:48 | scallop | 1 | 69583 | 5 | 4.190 | 16606.9 |
| 924 | 2025-04-04 00:42:01 | scallop | 1 | 69583 | 5 | 9.033 | 7703.2 |
| 923 | 2025-03-27 20:45:22 | scallop | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 922 | 2025-03-27 13:28:25 | scallop | 1 | 69583 | 5 | 8.593 | 8097.6 |
| 921 | 2025-03-19 22:06:04 | scallop | 1 | 69583 | 5 | 3.733 | 18640.0 |
| 920 | 2025-03-12 19:13:46 | scallop | 1 | 69583 | 5 | 6.376 | 10913.3 |
| 919 | 2025-03-12 04:24:44 | scallop | 1 | 69583 | 5 | 2.986 | 23303.1 |
| 918 | 2025-02-27 15:34:32 | scallop | 1 | 69583 | 5 | 5.610 | 12403.4 |
| 917 | 2025-02-25 08:53:45 | scallop | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 916 | 2025-02-24 03:20:08 | scallop | 1 | 69583 | 5 | 5.623 | 12374.7 |
| 915 | 2025-02-13 09:01:20 | scallop | 1 | 69583 | 5 | 3.360 | 20709.2 |
| 914 | 2025-02-10 14:36:58 | scallop | 1 | 69583 | 5 | 3.596 | 19350.1 |
| 913 | 2025-01-25 01:55:30 | scallop | 1 | 69583 | 5 | 5.716 | 12173.4 |
| 912 | 2025-01-25 01:16:13 | scallop | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 911 | 2025-01-24 19:20:57 | scallop | 1 | 69583 | 5 | 6.203 | 11217.6 |
| 910 | 2025-01-17 10:51:53 | scallop | 3 | 134027 | 170 | 26.866 | 4988.7 |
| 909 | 2025-01-11 22:11:27 | scallop | 2 | 107671 | 25 | 8.953 | 12026.2 |
| 908 | 2025-01-09 14:45:55 | scallop | 2 | 107671 | 25 | 12.593 | 8550.1 |
| 907 | 2025-01-09 14:45:51 | scallop | 1 | 69583 | 5 | 5.156 | 13495.5 |
| 906 | 2024-12-30 15:50:07 | scallop | 2 | 107671 | 25 | 17.343 | 6208.3 |
| 905 | 2024-12-26 09:14:26 | scallop | 3 | 134027 | 170 | 32.860 | 4078.7 |
| 904 | 2024-12-25 10:11:41 | scallop | 3 | 134027 | 170 | 35.673 | 3757.1 |
| 903 | 2024-12-24 23:22:11 | scallop | 3 | 134027 | 170 | 33.020 | 4059.0 |
| 902 | 2024-12-24 23:22:10 | scallop | 2 | 107671 | 25 | 15.796 | 6816.3 |
| 901 | 2024-12-22 20:18:24 | scallop | 3 | 134027 | 170 | 34.390 | 3897.3 |
| 900 | 2024-12-22 20:18:33 | scallop | 2 | 107671 | 25 | 16.813 | 6404.0 |
| 899 | 2024-12-22 20:16:52 | scallop | 1 | 69583 | 5 | 2.250 | 30925.8 |
| 898 | 2024-12-22 04:58:44 | scallop | 1 | 69583 | 5 | 3.953 | 17602.6 |
| 897 | 2024-12-10 01:15:57 | scallop | 1 | 69583 | 5 | 5.283 | 13171.1 |
| 896 | 2024-12-09 23:05:48 | scallop | 1 | 69583 | 5 | 5.966 | 11663.3 |
| 895 | 2024-11-19 04:00:30 | scallop | 1 | 69583 | 5 | 8.686 | 8010.9 |
| 894 | 2024-11-11 00:25:53 | scallop | 3 | 134027 | 170 | 23.890 | 5610.2 |
| 893 | 2024-11-10 11:50:15 | scallop | 3 | 134027 | 170 | 41.926 | 3196.8 |
| 892 | 2024-11-09 23:21:14 | scallop | 3 | 134027 | 170 | 14.046 | 9542.0 |
| 891 | 2024-11-09 23:21:15 | scallop | 2 | 107671 | 25 | 5.263 | 20458.1 |
| 890 | 2024-11-09 23:17:27 | scallop | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 889 | 2024-11-09 20:25:06 | scallop | 1 | 69583 | 5 | 7.640 | 9107.7 |
| 888 | 2024-10-13 09:29:58 | scallop | 1 | 69583 | 5 | 4.860 | 14317.5 |
| 887 | 2024-10-10 17:26:11 | scallop | 1 | 69583 | 5 | 5.733 | 12137.3 |
| 886 | 2024-10-10 06:17:11 | scallop | 1 | 69583 | 5 | 5.616 | 12390.1 |
| 885 | 2024-10-10 02:02:26 | scallop | 1 | 69583 | 5 | 3.063 | 22717.3 |
| 884 | 2024-09-21 01:19:52 | scallop | 3 | 134027 | 170 | 64.783 | 2068.9 |
| 883 | 2024-09-12 02:23:07 | scallop | 3 | 134027 | 170 | 47.156 | 2842.2 |
| 882 | 2024-09-12 02:23:13 | scallop | 2 | 107671 | 25 | 13.580 | 7928.6 |
| 881 | 2024-09-12 02:20:36 | scallop | 1 | 69583 | 5 | 8.343 | 8340.3 |