History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"desirables"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
249 | 2024-04-19 06:50:29 | desirables | 3 | 140603 | 25 | 26.500 | 5305.8 |
248 | 2024-04-19 06:50:31 | desirables | 2 | 108824 | 4 | 10.770 | 10104.4 |
247 | 2024-04-19 06:14:33 | desirables | 1 | 67641 | 2 | 1.190 | 56841.2 |
246 | 2024-04-16 13:07:08 | desirables | 2 | 108824 | 4 | 13.813 | 7878.4 |
245 | 2024-04-12 06:37:22 | desirables | 1 | 67641 | 2 | 3.143 | 21521.2 |
244 | 2024-04-12 06:32:24 | desirables | 2 | 108824 | 4 | 3.626 | 30012.1 |
243 | 2024-04-12 06:30:32 | desirables | 1 | 67641 | 2 | 1.340 | 50478.4 |
242 | 2024-04-07 21:52:33 | desirables | 4 | 161450 | 247 | 39.563 | 4080.8 |
241 | 2024-04-07 13:39:47 | desirables | 1 | 67641 | 2 | 1.736 | 38963.7 |
240 | 2024-04-07 03:57:07 | desirables | 4 | 161450 | 247 | 38.016 | 4246.9 |
239 | 2024-04-06 23:05:07 | desirables | 4 | 161450 | 247 | 46.206 | 3494.1 |
238 | 2024-04-06 20:00:48 | desirables | 3 | 140603 | 25 | 16.546 | 8497.7 |
237 | 2024-04-06 04:11:24 | desirables | 3 | 140603 | 25 | 15.313 | 9181.9 |
236 | 2024-04-06 04:11:24 | desirables | 2 | 108824 | 4 | 8.360 | 13017.2 |
235 | 2024-04-05 18:54:47 | desirables | 1 | 67641 | 2 | 1.263 | 53555.8 |
234 | 2024-04-04 02:58:27 | desirables | 4 | 161450 | 247 | 41.970 | 3846.8 |
233 | 2024-04-03 00:52:17 | desirables | 4 | 161450 | 247 | 38.470 | 4196.8 |
232 | 2024-04-03 00:51:53 | desirables | 3 | 140603 | 25 | 21.220 | 6626.0 |
231 | 2024-04-02 13:55:29 | desirables | 4 | 161450 | 247 | 38.813 | 4159.7 |
230 | 2024-04-02 13:55:31 | desirables | 3 | 140603 | 25 | 23.126 | 6079.9 |
229 | 2024-04-02 13:55:34 | desirables | 2 | 108824 | 4 | 9.500 | 11455.2 |
228 | 2024-04-02 13:49:08 | desirables | 1 | 67641 | 2 | 1.173 | 57665.0 |
227 | 2024-03-25 20:22:51 | desirables | 1 | 67641 | 2 | 2.656 | 25467.2 |
226 | 2024-03-15 11:17:47 | desirables | 2 | 108824 | 4 | 3.233 | 33660.4 |
225 | 2024-03-08 16:35:38 | desirables | 2 | 108824 | 4 | 11.440 | 9512.6 |
224 | 2024-03-08 16:27:16 | desirables | 1 | 67641 | 2 | 1.296 | 52192.1 |
223 | 2024-03-08 16:23:20 | desirables | 3 | 140603 | 25 | 24.376 | 5768.1 |
222 | 2024-03-07 06:11:40 | desirables | 4 | 161450 | 247 | 27.893 | 5788.2 |
221 | 2024-03-07 06:11:41 | desirables | 3 | 140603 | 25 | 15.830 | 8882.1 |
220 | 2024-03-07 06:11:42 | desirables | 2 | 108824 | 4 | 5.110 | 21296.3 |
219 | 2024-03-07 05:19:09 | desirables | 1 | 67641 | 2 | 2.610 | 25916.1 |
218 | 2024-03-04 18:50:15 | desirables | 4 | 161450 | 247 | 50.503 | 3196.8 |
217 | 2024-03-02 19:32:12 | desirables | 4 | 161450 | 247 | 39.066 | 4132.7 |
216 | 2024-03-02 19:32:13 | desirables | 3 | 140603 | 25 | 16.830 | 8354.3 |
215 | 2024-03-02 19:32:12 | desirables | 2 | 108824 | 4 | 3.843 | 28317.5 |
214 | 2024-03-02 19:30:07 | desirables | 1 | 67641 | 2 | 1.300 | 52031.5 |
213 | 2024-02-28 23:04:58 | desirables | 1 | 67641 | 2 | 1.186 | 57032.9 |
212 | 2024-02-16 09:31:51 | desirables | 1 | 67641 | 2 | 1.063 | 63632.2 |
211 | 2024-02-15 03:01:12 | desirables | 3 | 140603 | 25 | 8.390 | 16758.4 |
210 | 2024-02-15 03:01:11 | desirables | 2 | 108824 | 4 | 3.703 | 29388.1 |
209 | 2024-02-13 14:30:05 | desirables | 4 | 161450 | 247 | 37.376 | 4319.6 |
208 | 2024-02-13 14:30:07 | desirables | 2 | 108824 | 4 | 7.643 | 14238.4 |
207 | 2024-02-13 14:30:05 | desirables | 3 | 140603 | 25 | 7.656 | 18365.1 |
206 | 2024-02-13 11:49:23 | desirables | 1 | 67641 | 2 | 1.060 | 63812.3 |
205 | 2024-02-04 23:49:53 | desirables | 1 | 67641 | 2 | 1.190 | 56841.2 |
204 | 2024-02-03 08:32:22 | desirables | 1 | 67641 | 2 | 1.013 | 66773.0 |
203 | 2024-01-30 20:21:23 | desirables | 1 | 67641 | 2 | 1.236 | 54725.7 |
202 | 2024-01-16 07:02:03 | desirables | 1 | 67641 | 2 | 1.203 | 56226.9 |
201 | 2024-01-11 20:49:13 | desirables | 1 | 67641 | 2 | 1.170 | 57812.8 |
200 | 2023-12-07 02:47:03 | desirables | 1 | 67641 | 2 | 1.123 | 60232.4 |
199 | 2023-11-26 02:05:48 | desirables | 1 | 67641 | 2 | 1.203 | 56226.9 |
198 | 2023-11-25 02:50:53 | desirables | 2 | 108824 | 4 | 2.780 | 39145.3 |
197 | 2023-11-17 04:34:56 | desirables | 1 | 67641 | 2 | 1.110 | 60937.8 |
196 | 2023-11-12 17:02:24 | desirables | 1 | 67641 | 2 | 1.016 | 66575.8 |
195 | 2023-10-15 10:08:15 | desirables | 1 | 67641 | 2 | 1.140 | 59334.2 |
194 | 2023-09-08 22:52:54 | desirables | 1 | 67641 | 2 | 1.106 | 61158.2 |
193 | 2023-08-31 08:02:26 | desirables | 1 | 67641 | 2 | 1.140 | 59334.2 |
192 | 2023-08-25 04:15:32 | desirables | 2 | 108824 | 4 | 6.440 | 16898.1 |
191 | 2023-06-05 05:46:13 | desirables | 1 | 67641 | 2 | 0.983 | 68810.8 |
190 | 2023-05-12 14:13:10 | desirables | 1 | 67641 | 2 | 1.013 | 66773.0 |
189 | 2023-05-08 12:41:18 | desirables | 2 | 108824 | 4 | 2.703 | 40260.5 |
188 | 2023-03-27 04:07:47 | desirables | 1 | 67641 | 2 | 1.016 | 66575.8 |
187 | 2023-02-14 05:48:54 | desirables | 2 | 108824 | 4 | 2.700 | 40305.2 |
186 | 2023-01-19 09:16:18 | desirables | 1 | 67641 | 2 | 1.030 | 65670.9 |
185 | 2023-01-15 15:52:00 | desirables | 1 | 67641 | 2 | 1.016 | 66575.8 |
184 | 2023-01-12 05:17:25 | desirables | 1 | 67641 | 2 | 1.013 | 66773.0 |
183 | 2022-11-25 13:06:14 | desirables | 2 | 108824 | 4 | 2.796 | 38921.3 |
182 | 2022-10-26 14:24:38 | desirables | 1 | 67641 | 2 | 1.123 | 60232.4 |
181 | 2022-09-13 15:47:49 | desirables | 1 | 67641 | 2 | 1.000 | 67641.0 |
180 | 2022-06-16 09:38:34 | desirables | 1 | 67641 | 2 | 1.000 | 67641.0 |
179 | 2022-05-05 12:14:50 | desirables | 2 | 108824 | 4 | 2.983 | 36481.4 |
178 | 2022-04-27 02:15:56 | desirables | 1 | 67641 | 2 | 1.123 | 60232.4 |
177 | 2022-02-26 01:20:32 | desirables | 1 | 67641 | 2 | 1.060 | 63812.3 |
176 | 2022-01-18 01:19:14 | desirables | 2 | 108824 | 4 | 2.750 | 39572.4 |
175 | 2021-12-31 18:10:42 | desirables | 1 | 67641 | 2 | 1.096 | 61716.2 |
174 | 2021-12-15 01:03:32 | desirables | 1 | 67641 | 2 | 1.156 | 58513.0 |
173 | 2021-11-09 16:40:19 | desirables | 1 | 67641 | 2 | 1.063 | 63632.2 |
172 | 2021-09-18 05:56:37 | desirables | 1 | 67641 | 2 | 1.093 | 61885.6 |
171 | 2021-06-15 00:34:32 | desirables | 1 | 67641 | 2 | 1.220 | 55443.4 |
170 | 2021-05-03 05:38:46 | desirables | 1 | 67641 | 2 | 1.046 | 64666.3 |
169 | 2021-04-01 11:54:56 | desirables | 1 | 67641 | 2 | 1.046 | 64666.3 |
168 | 2021-03-15 14:52:26 | desirables | 1 | 67641 | 2 | 1.046 | 64666.3 |
167 | 2021-02-03 06:21:56 | desirables | 1 | 67641 | 2 | 1.033 | 65480.2 |
166 | 2021-01-16 14:24:41 | desirables | 1 | 67641 | 2 | 1.033 | 65480.2 |
165 | 2020-12-12 15:28:18 | desirables | 1 | 67641 | 2 | 1.033 | 65480.2 |
164 | 2020-12-09 16:38:57 | desirables | 1 | 67641 | 2 | 1.033 | 65480.2 |
163 | 2020-11-20 20:10:50 | desirables | 1 | 67641 | 2 | 1.050 | 64420.0 |
162 | 2020-11-04 22:35:18 | desirables | 1 | 67641 | 2 | 1.110 | 60937.8 |
161 | 2020-10-28 03:19:47 | desirables | 1 | 67641 | 2 | 1.126 | 60071.9 |
160 | 2020-10-26 02:50:04 | desirables | 1 | 67641 | 2 | 1.173 | 57665.0 |
159 | 2020-09-12 05:12:50 | desirables | 1 | 67641 | 2 | 1.046 | 64666.3 |
158 | 2020-08-12 12:45:54 | desirables | 1 | 67641 | 2 | 1.080 | 62630.6 |
157 | 2020-06-16 13:44:11 | desirables | 1 | 67641 | 2 | 1.143 | 59178.5 |
156 | 2020-05-25 11:06:01 | desirables | 1 | 67641 | 2 | 2.033 | 33271.5 |
155 | 2020-03-27 23:53:59 | desirables | 4 | 161450 | 247 | 12.766 | 12646.9 |
154 | 2020-03-26 03:34:09 | desirables | 4 | 161450 | 247 | 14.016 | 11519.0 |
153 | 2020-03-25 20:10:19 | desirables | 4 | 161450 | 247 | 12.003 | 13450.8 |
152 | 2020-03-24 20:24:42 | desirables | 4 | 161450 | 247 | 23.753 | 6797.0 |
151 | 2020-03-22 17:32:53 | desirables | 1 | 67641 | 2 | 1.170 | 57812.8 |
150 | 2020-02-28 07:30:29 | desirables | 4 | 161450 | 247 | 17.843 | 9048.4 |