History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sundries"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
319 | 2024-04-27 15:39:18 | sundries | 1 | 82945 | 1 | 1.796 | 46183.2 |
318 | 2024-04-08 16:19:47 | sundries | 1 | 82945 | 1 | 1.516 | 54713.1 |
317 | 2024-04-08 09:18:37 | sundries | 1 | 82945 | 1 | 6.873 | 12068.2 |
316 | 2024-03-31 18:46:08 | sundries | 1 | 82945 | 1 | 3.330 | 24908.4 |
315 | 2024-03-30 01:28:10 | sundries | 1 | 82945 | 1 | 4.983 | 16645.6 |
314 | 2024-03-28 23:54:11 | sundries | 1 | 82945 | 1 | 3.326 | 24938.4 |
313 | 2024-03-04 21:17:20 | sundries | 1 | 82945 | 1 | 3.173 | 26140.9 |
312 | 2024-03-01 13:41:51 | sundries | 1 | 82945 | 1 | 1.623 | 51106.0 |
311 | 2024-03-01 13:25:23 | sundries | 3 | 146162 | 223 | 19.470 | 7507.0 |
310 | 2024-02-29 05:40:16 | sundries | 2 | 121059 | 14 | 3.500 | 34588.3 |
309 | 2024-02-29 05:37:21 | sundries | 3 | 146162 | 223 | 8.453 | 17291.1 |
308 | 2024-02-27 22:28:32 | sundries | 2 | 121059 | 14 | 10.326 | 11723.7 |
307 | 2024-02-27 22:28:19 | sundries | 3 | 146162 | 223 | 8.936 | 16356.5 |
306 | 2024-02-27 20:26:44 | sundries | 3 | 146162 | 223 | 6.720 | 21750.3 |
305 | 2024-02-27 20:26:43 | sundries | 1 | 82945 | 1 | 1.483 | 55930.5 |
304 | 2024-02-22 11:58:58 | sundries | 2 | 121059 | 14 | 12.830 | 9435.6 |
303 | 2024-02-20 03:43:24 | sundries | 2 | 121059 | 14 | 10.390 | 11651.5 |
302 | 2024-02-18 04:03:47 | sundries | 2 | 121059 | 14 | 4.093 | 29577.1 |
301 | 2024-02-07 10:55:07 | sundries | 1 | 82945 | 1 | 1.500 | 55296.7 |
300 | 2024-01-12 07:57:43 | sundries | 2 | 121059 | 14 | 3.936 | 30756.9 |
299 | 2024-01-05 19:15:22 | sundries | 3 | 146162 | 223 | 7.610 | 19206.6 |
298 | 2023-12-25 02:37:46 | sundries | 1 | 82945 | 1 | 1.436 | 57761.1 |
297 | 2023-12-09 23:36:33 | sundries | 1 | 82945 | 1 | 1.453 | 57085.3 |
296 | 2023-12-08 13:43:12 | sundries | 1 | 82945 | 1 | 1.440 | 57600.7 |
295 | 2023-11-30 03:53:19 | sundries | 1 | 82945 | 1 | 1.483 | 55930.5 |
294 | 2023-11-16 18:56:57 | sundries | 2 | 121059 | 14 | 3.186 | 37997.2 |
293 | 2023-11-04 12:16:20 | sundries | 1 | 82945 | 1 | 1.453 | 57085.3 |
292 | 2023-11-01 05:52:23 | sundries | 1 | 82945 | 1 | 1.300 | 63803.8 |
291 | 2023-10-13 03:41:43 | sundries | 3 | 146162 | 223 | 6.436 | 22710.1 |
290 | 2023-09-29 20:54:19 | sundries | 1 | 82945 | 1 | 1.423 | 58288.8 |
289 | 2023-09-29 15:52:25 | sundries | 1 | 82945 | 1 | 1.330 | 62364.7 |
288 | 2023-09-14 23:10:13 | sundries | 1 | 82945 | 1 | 1.313 | 63172.1 |
287 | 2023-08-18 03:44:14 | sundries | 2 | 121059 | 14 | 3.236 | 37410.1 |
286 | 2023-07-24 04:42:24 | sundries | 3 | 146162 | 223 | 10.826 | 13501.0 |
285 | 2023-07-08 20:49:45 | sundries | 1 | 82945 | 1 | 1.466 | 56579.1 |
284 | 2023-07-07 04:48:26 | sundries | 1 | 82945 | 1 | 1.326 | 62552.8 |
283 | 2023-05-05 11:30:43 | sundries | 2 | 121059 | 14 | 3.200 | 37830.9 |
282 | 2023-04-16 14:36:17 | sundries | 1 | 82945 | 1 | 1.470 | 56425.2 |
281 | 2023-04-05 20:14:22 | sundries | 3 | 146162 | 223 | 7.016 | 20832.7 |
280 | 2023-03-18 08:40:05 | sundries | 1 | 82945 | 1 | 1.300 | 63803.8 |
279 | 2023-02-13 19:56:21 | sundries | 2 | 121059 | 14 | 3.170 | 38189.0 |
278 | 2023-02-08 17:20:05 | sundries | 1 | 82945 | 1 | 1.280 | 64800.8 |
277 | 2023-01-04 08:17:58 | sundries | 3 | 146162 | 223 | 6.220 | 23498.7 |
276 | 2022-12-21 01:02:31 | sundries | 3 | 146162 | 223 | 6.593 | 22169.3 |
275 | 2022-12-05 18:43:46 | sundries | 1 | 82945 | 1 | 1.280 | 64800.8 |
274 | 2022-11-25 10:03:54 | sundries | 2 | 121059 | 14 | 3.313 | 36540.6 |
273 | 2022-11-23 16:32:39 | sundries | 1 | 82945 | 1 | 1.420 | 58412.0 |
272 | 2022-11-23 12:16:32 | sundries | 3 | 146162 | 223 | 7.203 | 20291.8 |
271 | 2022-09-12 08:10:30 | sundries | 3 | 146162 | 223 | 6.300 | 23200.3 |
270 | 2022-08-04 05:47:00 | sundries | 1 | 82945 | 1 | 1.313 | 63172.1 |
269 | 2022-07-23 17:59:31 | sundries | 1 | 82945 | 1 | 1.313 | 63172.1 |
268 | 2022-05-01 16:52:33 | sundries | 2 | 121059 | 14 | 3.623 | 33414.0 |
267 | 2022-03-29 10:12:27 | sundries | 1 | 82945 | 1 | 1.376 | 60279.8 |
266 | 2022-03-19 02:32:34 | sundries | 1 | 82945 | 1 | 1.406 | 58993.6 |
265 | 2022-01-04 07:23:41 | sundries | 1 | 82945 | 1 | 1.390 | 59672.7 |
264 | 2022-01-02 03:57:24 | sundries | 1 | 82945 | 1 | 1.420 | 58412.0 |
263 | 2021-11-28 12:26:58 | sundries | 1 | 82945 | 1 | 1.313 | 63172.1 |
262 | 2021-11-02 13:44:43 | sundries | 1 | 82945 | 1 | 1.313 | 63172.1 |
261 | 2021-10-31 11:25:00 | sundries | 1 | 82945 | 1 | 1.313 | 63172.1 |
260 | 2021-10-30 22:45:56 | sundries | 1 | 82945 | 1 | 1.546 | 53651.4 |
259 | 2021-10-29 21:27:47 | sundries | 1 | 82945 | 1 | 1.296 | 64000.8 |
258 | 2021-09-30 13:09:27 | sundries | 1 | 82945 | 1 | 1.313 | 63172.1 |
257 | 2021-09-21 09:49:35 | sundries | 1 | 82945 | 1 | 1.440 | 57600.7 |
256 | 2021-09-20 14:40:26 | sundries | 1 | 82945 | 1 | 1.453 | 57085.3 |
255 | 2021-09-13 22:18:34 | sundries | 1 | 82945 | 1 | 1.436 | 57761.1 |
254 | 2021-08-12 06:17:23 | sundries | 1 | 82945 | 1 | 1.296 | 64000.8 |
253 | 2021-08-08 20:59:10 | sundries | 1 | 82945 | 1 | 1.296 | 64000.8 |
252 | 2021-06-06 07:19:50 | sundries | 2 | 121059 | 14 | 3.220 | 37596.0 |
251 | 2021-05-12 07:43:07 | sundries | 2 | 121059 | 14 | 3.766 | 32145.2 |
250 | 2021-05-01 07:13:51 | sundries | 1 | 82945 | 1 | 1.623 | 51106.0 |
249 | 2021-04-24 07:20:01 | sundries | 1 | 82945 | 1 | 1.360 | 60989.0 |
248 | 2021-03-26 06:15:37 | sundries | 1 | 82945 | 1 | 1.436 | 57761.1 |
247 | 2021-03-15 02:46:47 | sundries | 2 | 121059 | 14 | 3.610 | 33534.3 |
246 | 2021-02-18 04:40:03 | sundries | 2 | 121059 | 14 | 3.750 | 32282.4 |
245 | 2021-01-28 20:22:25 | sundries | 1 | 82945 | 1 | 1.283 | 64649.3 |
244 | 2021-01-26 16:14:50 | sundries | 1 | 82945 | 1 | 1.296 | 64000.8 |
243 | 2021-01-10 16:42:16 | sundries | 1 | 82945 | 1 | 1.266 | 65517.4 |
242 | 2021-01-09 12:17:12 | sundries | 1 | 82945 | 1 | 2.580 | 32149.2 |
241 | 2020-10-28 21:58:54 | sundries | 1 | 82945 | 1 | 1.700 | 48791.2 |
240 | 2020-10-26 00:52:53 | sundries | 1 | 82945 | 1 | 1.470 | 56425.2 |
239 | 2020-10-21 21:03:47 | sundries | 1 | 82945 | 1 | 1.720 | 48223.8 |
238 | 2020-07-22 11:08:29 | sundries | 1 | 82945 | 1 | 1.390 | 59672.7 |
237 | 2020-04-20 13:08:41 | sundries | 1 | 82945 | 1 | 1.423 | 58288.8 |
236 | 2020-03-28 20:15:27 | sundries | 1 | 82945 | 1 | 2.923 | 28376.7 |
235 | 2020-03-21 08:30:42 | sundries | 1 | 82945 | 1 | 1.610 | 51518.6 |
234 | 2020-03-02 11:38:08 | sundries | 1 | 82945 | 1 | 3.156 | 26281.7 |
233 | 2020-02-29 00:34:00 | sundries | 3 | 146162 | 223 | 15.220 | 9603.3 |
232 | 2020-02-28 20:44:06 | sundries | 3 | 146162 | 223 | 17.596 | 8306.5 |
231 | 2020-02-28 19:52:13 | sundries | 3 | 146162 | 223 | 9.656 | 15136.9 |
230 | 2020-02-28 15:19:19 | sundries | 3 | 146162 | 223 | 7.096 | 20597.8 |
229 | 2020-02-28 01:19:48 | sundries | 3 | 146162 | 223 | 9.470 | 15434.2 |
228 | 2020-02-27 01:35:00 | sundries | 1 | 82945 | 1 | 1.686 | 49196.3 |
227 | 2020-02-17 16:28:17 | sundries | 1 | 82945 | 1 | 3.393 | 24445.9 |
226 | 2020-02-09 14:48:59 | sundries | 1 | 82945 | 1 | 1.610 | 51518.6 |
225 | 2020-02-04 16:25:47 | sundries | 1 | 82945 | 1 | 1.533 | 54106.3 |
224 | 2020-02-02 11:31:55 | sundries | 1 | 82945 | 1 | 2.953 | 28088.4 |
223 | 2020-02-02 09:06:46 | sundries | 1 | 82945 | 1 | 1.500 | 55296.7 |
222 | 2020-01-30 20:07:38 | sundries | 1 | 82945 | 1 | 1.590 | 52166.7 |
221 | 2020-01-25 00:52:04 | sundries | 1 | 82945 | 1 | 1.703 | 48705.2 |
220 | 2020-01-20 02:47:18 | sundries | 1 | 82945 | 1 | 1.310 | 63316.8 |