History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"melons"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1071 | 2024-04-28 18:15:32 | melons | 1 | 48755 | 7 | 0.923 | 52822.3 |
| 1070 | 2024-04-27 02:39:22 | melons | 1 | 48755 | 7 | 2.406 | 20263.9 |
| 1069 | 2024-04-24 07:54:26 | melons | 1 | 48755 | 7 | 2.966 | 16438.0 |
| 1068 | 2024-04-12 10:01:31 | melons | 3 | 112716 | 976 | 19.970 | 5644.3 |
| 1067 | 2024-04-08 22:18:30 | melons | 2 | 82551 | 83 | 9.250 | 8924.4 |
| 1066 | 2024-04-08 22:17:59 | melons | 3 | 112716 | 976 | 7.813 | 14426.7 |
| 1065 | 2024-04-08 08:22:42 | melons | 2 | 82551 | 83 | 2.716 | 30394.3 |
| 1064 | 2024-04-08 08:21:58 | melons | 3 | 112716 | 976 | 6.343 | 17770.1 |
| 1063 | 2024-04-08 02:46:20 | melons | 1 | 48755 | 7 | 2.940 | 16583.3 |
| 1062 | 2024-04-07 11:53:49 | melons | 3 | 112716 | 976 | 21.706 | 5192.8 |
| 1061 | 2024-04-07 10:48:54 | melons | 3 | 112716 | 976 | 14.686 | 7675.1 |
| 1060 | 2024-04-06 15:48:50 | melons | 3 | 112716 | 976 | 5.830 | 19333.8 |
| 1059 | 2024-04-05 21:10:31 | melons | 3 | 112716 | 976 | 20.780 | 5424.3 |
| 1058 | 2024-04-04 19:57:33 | melons | 3 | 112716 | 976 | 7.203 | 15648.5 |
| 1057 | 2024-04-04 06:19:44 | melons | 3 | 112716 | 976 | 10.406 | 10831.8 |
| 1056 | 2024-04-03 19:45:39 | melons | 3 | 112716 | 976 | 11.580 | 9733.7 |
| 1055 | 2024-04-03 17:30:52 | melons | 3 | 112716 | 976 | 20.593 | 5473.5 |
| 1054 | 2024-04-02 22:12:46 | melons | 1 | 48755 | 7 | 2.873 | 16970.1 |
| 1053 | 2024-03-31 14:20:17 | melons | 1 | 48755 | 7 | 3.000 | 16251.7 |
| 1052 | 2024-03-28 05:54:23 | melons | 1 | 48755 | 7 | 0.873 | 55847.7 |
| 1051 | 2024-03-07 07:42:02 | melons | 2 | 82551 | 83 | 2.953 | 27955.0 |
| 1050 | 2024-03-07 03:33:24 | melons | 2 | 82551 | 83 | 9.063 | 9108.6 |
| 1049 | 2024-03-07 00:07:55 | melons | 3 | 112716 | 976 | 8.860 | 12721.9 |
| 1048 | 2024-03-06 23:01:20 | melons | 3 | 112716 | 976 | 10.173 | 11079.9 |
| 1047 | 2024-03-06 12:40:38 | melons | 2 | 82551 | 83 | 10.580 | 7802.6 |
| 1046 | 2024-03-06 12:40:02 | melons | 3 | 112716 | 976 | 6.876 | 16392.7 |
| 1045 | 2024-03-05 18:09:36 | melons | 3 | 112716 | 976 | 20.096 | 5608.9 |
| 1044 | 2024-03-05 16:27:47 | melons | 2 | 82551 | 83 | 2.546 | 32423.8 |
| 1043 | 2024-03-05 16:27:01 | melons | 3 | 112716 | 976 | 7.690 | 14657.5 |
| 1042 | 2024-03-05 12:04:53 | melons | 3 | 112716 | 976 | 5.686 | 19823.4 |
| 1041 | 2024-03-02 18:04:41 | melons | 1 | 48755 | 7 | 0.970 | 50262.9 |
| 1040 | 2024-02-28 07:43:03 | melons | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 1039 | 2024-02-15 13:46:44 | melons | 3 | 112716 | 976 | 12.533 | 8993.5 |
| 1038 | 2024-02-09 16:33:07 | melons | 3 | 112716 | 976 | 13.296 | 8477.4 |
| 1037 | 2024-02-07 23:07:16 | melons | 3 | 112716 | 976 | 19.940 | 5652.8 |
| 1036 | 2024-02-01 05:49:32 | melons | 2 | 82551 | 83 | 2.436 | 33887.9 |
| 1035 | 2024-02-01 05:48:48 | melons | 3 | 112716 | 976 | 5.766 | 19548.4 |
| 1034 | 2024-01-31 10:19:55 | melons | 2 | 82551 | 83 | 2.373 | 34787.6 |
| 1033 | 2024-01-31 10:19:27 | melons | 3 | 112716 | 976 | 5.766 | 19548.4 |
| 1032 | 2024-01-31 10:18:11 | melons | 2 | 82551 | 83 | 2.343 | 35233.0 |
| 1031 | 2024-01-31 10:17:28 | melons | 3 | 112716 | 976 | 4.923 | 22895.8 |
| 1030 | 2024-01-31 08:21:14 | melons | 3 | 112716 | 976 | 5.876 | 19182.4 |
| 1029 | 2024-01-15 18:29:29 | melons | 2 | 82551 | 83 | 2.470 | 33421.5 |
| 1028 | 2024-01-10 08:07:59 | melons | 3 | 112716 | 976 | 5.876 | 19182.4 |
| 1027 | 2024-01-05 01:29:22 | melons | 3 | 112716 | 976 | 5.720 | 19705.6 |
| 1026 | 2024-01-05 01:29:23 | melons | 2 | 82551 | 83 | 2.516 | 32810.4 |
| 1025 | 2023-12-28 17:57:45 | melons | 3 | 112716 | 976 | 5.186 | 21734.7 |
| 1024 | 2023-12-28 17:57:46 | melons | 2 | 82551 | 83 | 2.500 | 33020.4 |
| 1023 | 2023-12-27 14:39:02 | melons | 1 | 48755 | 7 | 0.950 | 51321.1 |
| 1022 | 2023-12-26 04:28:06 | melons | 3 | 112716 | 976 | 4.890 | 23050.3 |
| 1021 | 2023-11-26 10:09:29 | melons | 3 | 112716 | 976 | 4.923 | 22895.8 |
| 1020 | 2023-11-24 22:35:12 | melons | 3 | 112716 | 976 | 5.266 | 21404.5 |
| 1019 | 2023-11-23 19:05:38 | melons | 3 | 112716 | 976 | 4.780 | 23580.8 |
| 1018 | 2023-11-14 09:13:16 | melons | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 1017 | 2023-11-13 21:35:03 | melons | 1 | 48755 | 7 | 0.890 | 54780.9 |
| 1016 | 2023-11-07 01:26:02 | melons | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 1015 | 2023-11-06 19:21:04 | melons | 1 | 48755 | 7 | 0.856 | 56956.8 |
| 1014 | 2023-10-30 03:41:50 | melons | 2 | 82551 | 83 | 2.203 | 37472.1 |
| 1013 | 2023-10-25 01:45:54 | melons | 2 | 82551 | 83 | 2.470 | 33421.5 |
| 1012 | 2023-10-24 05:10:28 | melons | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 1011 | 2023-10-23 11:56:07 | melons | 1 | 48755 | 7 | 1.093 | 44606.6 |
| 1010 | 2023-10-16 06:22:16 | melons | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1009 | 2023-10-12 07:27:29 | melons | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 1008 | 2023-09-24 00:36:09 | melons | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 1007 | 2023-09-13 15:27:53 | melons | 1 | 48755 | 7 | 0.783 | 62266.9 |
| 1006 | 2023-08-24 22:17:07 | melons | 3 | 112716 | 976 | 4.970 | 22679.3 |
| 1005 | 2023-08-12 12:09:03 | melons | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1004 | 2023-08-03 02:06:06 | melons | 2 | 82551 | 83 | 4.326 | 19082.5 |
| 1003 | 2023-07-23 08:52:53 | melons | 3 | 112716 | 976 | 4.846 | 23259.6 |
| 1002 | 2023-07-15 10:25:52 | melons | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 1001 | 2023-06-23 02:03:19 | melons | 3 | 112716 | 976 | 5.376 | 20966.5 |
| 1000 | 2023-06-20 02:12:01 | melons | 3 | 112716 | 976 | 5.563 | 20261.7 |
| 999 | 2023-06-15 09:42:05 | melons | 3 | 112716 | 976 | 5.610 | 20092.0 |
| 998 | 2023-06-14 11:36:34 | melons | 3 | 112716 | 976 | 4.780 | 23580.8 |
| 997 | 2023-06-13 10:46:23 | melons | 3 | 112716 | 976 | 5.203 | 21663.7 |
| 996 | 2023-06-11 11:43:34 | melons | 3 | 112716 | 976 | 5.190 | 21717.9 |
| 995 | 2023-06-10 20:21:59 | melons | 3 | 112716 | 976 | 5.283 | 21335.6 |
| 994 | 2023-06-09 03:25:50 | melons | 3 | 112716 | 976 | 4.626 | 24365.8 |
| 993 | 2023-06-05 09:32:00 | melons | 3 | 112716 | 976 | 4.703 | 23966.8 |
| 992 | 2023-05-11 13:54:13 | melons | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 991 | 2023-05-10 11:45:10 | melons | 3 | 112716 | 976 | 5.233 | 21539.5 |
| 990 | 2023-04-17 09:47:27 | melons | 2 | 82551 | 83 | 2.093 | 39441.5 |
| 989 | 2023-04-04 01:18:06 | melons | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 988 | 2023-03-20 10:52:40 | melons | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 987 | 2023-03-05 21:23:08 | melons | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 986 | 2023-02-15 12:11:50 | melons | 3 | 112716 | 976 | 4.703 | 23966.8 |
| 985 | 2023-01-24 09:26:23 | melons | 2 | 82551 | 83 | 2.313 | 35690.0 |
| 984 | 2023-01-18 08:24:45 | melons | 3 | 112716 | 976 | 8.486 | 13282.6 |
| 983 | 2022-12-29 14:31:02 | melons | 1 | 48755 | 7 | 0.810 | 60191.4 |
| 982 | 2022-12-25 10:26:25 | melons | 3 | 112716 | 976 | 4.640 | 24292.2 |
| 981 | 2022-12-22 10:55:21 | melons | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 980 | 2022-12-02 22:03:31 | melons | 3 | 112716 | 976 | 4.753 | 23714.7 |
| 979 | 2022-12-01 22:51:07 | melons | 3 | 112716 | 976 | 5.716 | 19719.4 |
| 978 | 2022-11-29 23:40:47 | melons | 3 | 112716 | 976 | 5.156 | 21861.1 |
| 977 | 2022-11-27 23:34:32 | melons | 3 | 112716 | 976 | 5.330 | 21147.5 |
| 976 | 2022-11-26 14:06:09 | melons | 3 | 112716 | 976 | 4.673 | 24120.7 |
| 975 | 2022-11-05 20:25:32 | melons | 2 | 82551 | 83 | 2.096 | 39385.0 |
| 974 | 2022-09-17 08:14:25 | melons | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 973 | 2022-09-08 05:54:38 | melons | 1 | 48755 | 7 | 0.846 | 57630.0 |
| 972 | 2022-08-07 17:47:24 | melons | 1 | 48755 | 7 | 0.766 | 63648.8 |