History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knifers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
386 | 2024-03-29 00:17:11 | knifers | 1 | 69583 | 3 | 4.330 | 16070.0 |
385 | 2024-03-02 15:56:17 | knifers | 2 | 107671 | 24 | 5.800 | 18564.0 |
384 | 2024-03-02 15:55:57 | knifers | 3 | 134027 | 409 | 8.703 | 15400.1 |
383 | 2024-02-28 15:26:46 | knifers | 2 | 107671 | 24 | 7.110 | 15143.6 |
382 | 2024-02-28 08:17:14 | knifers | 3 | 134027 | 409 | 16.970 | 7897.9 |
381 | 2024-02-27 00:17:20 | knifers | 3 | 134027 | 409 | 6.783 | 19759.3 |
380 | 2024-02-27 00:17:19 | knifers | 2 | 107671 | 24 | 6.576 | 16373.3 |
379 | 2024-02-27 00:17:21 | knifers | 1 | 69583 | 3 | 2.420 | 28753.3 |
378 | 2024-01-22 11:26:19 | knifers | 1 | 69583 | 3 | 2.313 | 30083.4 |
377 | 2023-12-15 06:56:21 | knifers | 1 | 69583 | 3 | 1.123 | 61961.7 |
376 | 2023-12-12 01:53:06 | knifers | 3 | 134027 | 409 | 13.783 | 9724.1 |
375 | 2023-12-11 21:01:02 | knifers | 1 | 69583 | 3 | 1.123 | 61961.7 |
374 | 2023-12-10 10:02:23 | knifers | 3 | 134027 | 409 | 6.580 | 20368.8 |
373 | 2023-12-10 10:02:20 | knifers | 2 | 107671 | 24 | 2.813 | 38276.2 |
372 | 2023-11-28 17:21:01 | knifers | 3 | 134027 | 409 | 6.513 | 20578.4 |
371 | 2023-11-28 17:20:59 | knifers | 2 | 107671 | 24 | 9.250 | 11640.1 |
370 | 2023-11-23 13:14:34 | knifers | 3 | 134027 | 409 | 5.593 | 23963.3 |
369 | 2023-11-23 13:14:32 | knifers | 2 | 107671 | 24 | 2.766 | 38926.6 |
368 | 2023-11-18 22:43:46 | knifers | 1 | 69583 | 3 | 1.186 | 58670.3 |
367 | 2023-11-12 00:39:21 | knifers | 3 | 134027 | 409 | 6.750 | 19855.9 |
366 | 2023-11-12 00:39:19 | knifers | 2 | 107671 | 24 | 3.453 | 31181.9 |
365 | 2023-11-11 00:19:10 | knifers | 1 | 69583 | 3 | 1.000 | 69583.0 |
364 | 2023-11-09 13:45:04 | knifers | 1 | 69583 | 3 | 1.030 | 67556.3 |
363 | 2023-10-27 15:17:05 | knifers | 1 | 69583 | 3 | 1.140 | 61037.7 |
362 | 2023-10-21 08:37:14 | knifers | 1 | 69583 | 3 | 1.110 | 62687.4 |
361 | 2023-10-17 20:06:04 | knifers | 1 | 69583 | 3 | 1.140 | 61037.7 |
360 | 2023-10-14 05:37:12 | knifers | 1 | 69583 | 3 | 1.263 | 55093.4 |
359 | 2023-10-04 11:08:22 | knifers | 1 | 69583 | 3 | 1.046 | 66522.9 |
358 | 2023-09-26 03:20:50 | knifers | 3 | 134027 | 409 | 6.720 | 19944.5 |
357 | 2023-09-26 03:20:51 | knifers | 2 | 107671 | 24 | 3.283 | 32796.5 |
356 | 2023-09-19 15:01:59 | knifers | 1 | 69583 | 3 | 1.016 | 68487.2 |
355 | 2023-09-12 10:20:24 | knifers | 3 | 134027 | 409 | 6.796 | 19721.5 |
354 | 2023-09-12 10:18:10 | knifers | 1 | 69583 | 3 | 1.000 | 69583.0 |
353 | 2023-09-10 09:59:52 | knifers | 3 | 134027 | 409 | 5.360 | 25005.0 |
352 | 2023-09-05 23:11:53 | knifers | 1 | 69583 | 3 | 1.046 | 66522.9 |
351 | 2023-08-25 21:39:54 | knifers | 3 | 134027 | 409 | 6.610 | 20276.4 |
350 | 2023-08-12 10:43:01 | knifers | 1 | 69583 | 3 | 1.093 | 63662.4 |
349 | 2023-06-08 20:49:27 | knifers | 1 | 69583 | 3 | 2.156 | 32274.1 |
348 | 2023-05-31 13:03:05 | knifers | 3 | 134027 | 409 | 5.843 | 22938.0 |
347 | 2023-04-23 21:05:22 | knifers | 1 | 69583 | 3 | 1.126 | 61796.6 |
346 | 2023-03-28 13:31:37 | knifers | 1 | 69583 | 3 | 1.093 | 63662.4 |
345 | 2023-03-09 03:58:19 | knifers | 3 | 134027 | 409 | 5.593 | 23963.3 |
344 | 2023-01-11 16:21:22 | knifers | 1 | 69583 | 3 | 1.000 | 69583.0 |
343 | 2023-01-07 18:55:36 | knifers | 1 | 69583 | 3 | 1.203 | 57841.2 |
342 | 2023-01-01 16:11:37 | knifers | 3 | 134027 | 409 | 5.373 | 24944.5 |
341 | 2022-12-15 01:19:10 | knifers | 3 | 134027 | 409 | 5.390 | 24865.9 |
340 | 2022-11-24 11:26:29 | knifers | 3 | 134027 | 409 | 5.403 | 24806.0 |
339 | 2022-11-17 07:52:19 | knifers | 3 | 134027 | 409 | 5.953 | 22514.2 |
338 | 2022-11-01 19:41:24 | knifers | 3 | 134027 | 409 | 5.360 | 25005.0 |
337 | 2022-11-01 10:37:34 | knifers | 3 | 134027 | 409 | 6.766 | 19808.9 |
336 | 2022-10-29 04:07:04 | knifers | 3 | 134027 | 409 | 5.610 | 23890.7 |
335 | 2022-10-16 11:08:49 | knifers | 1 | 69583 | 3 | 1.013 | 68690.0 |
334 | 2022-10-02 02:47:48 | knifers | 3 | 134027 | 409 | 5.610 | 23890.7 |
333 | 2022-09-16 20:01:26 | knifers | 3 | 134027 | 409 | 5.420 | 24728.2 |
332 | 2022-09-09 15:11:40 | knifers | 1 | 69583 | 3 | 1.310 | 53116.8 |
331 | 2022-08-30 12:51:25 | knifers | 3 | 134027 | 409 | 5.686 | 23571.4 |
330 | 2022-08-27 16:02:22 | knifers | 3 | 134027 | 409 | 5.593 | 23963.3 |
329 | 2022-08-03 03:53:45 | knifers | 3 | 134027 | 409 | 5.406 | 24792.3 |
328 | 2022-06-06 08:24:43 | knifers | 1 | 69583 | 3 | 1.030 | 67556.3 |
327 | 2022-06-04 09:33:21 | knifers | 3 | 134027 | 409 | 5.390 | 24865.9 |
326 | 2022-05-07 14:55:20 | knifers | 1 | 69583 | 3 | 1.076 | 64668.2 |
325 | 2022-04-24 21:53:31 | knifers | 3 | 134027 | 409 | 5.936 | 22578.7 |
324 | 2022-03-26 09:04:24 | knifers | 3 | 134027 | 409 | 6.346 | 21119.9 |
323 | 2022-03-13 08:48:40 | knifers | 3 | 134027 | 409 | 5.376 | 24930.6 |
322 | 2022-02-16 03:27:34 | knifers | 1 | 69583 | 3 | 1.030 | 67556.3 |
321 | 2022-01-23 07:04:00 | knifers | 1 | 69583 | 3 | 1.063 | 65459.1 |
320 | 2021-12-03 09:38:55 | knifers | 1 | 69583 | 3 | 1.080 | 64428.7 |
319 | 2021-12-01 08:28:54 | knifers | 1 | 69583 | 3 | 1.266 | 54962.9 |
318 | 2021-10-10 05:01:45 | knifers | 1 | 69583 | 3 | 1.030 | 67556.3 |
317 | 2021-07-31 00:55:31 | knifers | 1 | 69583 | 3 | 1.173 | 59320.5 |
316 | 2021-07-08 09:03:35 | knifers | 1 | 69583 | 3 | 1.140 | 61037.7 |
315 | 2021-04-29 15:02:51 | knifers | 1 | 69583 | 3 | 1.016 | 68487.2 |
314 | 2021-04-08 13:40:26 | knifers | 1 | 69583 | 3 | 1.143 | 60877.5 |
313 | 2021-04-04 09:45:34 | knifers | 1 | 69583 | 3 | 1.140 | 61037.7 |
312 | 2021-03-29 04:22:57 | knifers | 1 | 69583 | 3 | 1.143 | 60877.5 |
311 | 2021-03-03 04:39:30 | knifers | 1 | 69583 | 3 | 1.046 | 66522.9 |
310 | 2021-02-23 10:01:43 | knifers | 1 | 69583 | 3 | 1.013 | 68690.0 |
309 | 2021-02-03 12:24:21 | knifers | 1 | 69583 | 3 | 1.220 | 57035.2 |
308 | 2021-01-30 07:37:48 | knifers | 1 | 69583 | 3 | 1.063 | 65459.1 |
307 | 2020-12-30 10:10:11 | knifers | 1 | 69583 | 3 | 1.016 | 68487.2 |
306 | 2020-10-17 19:12:49 | knifers | 1 | 69583 | 3 | 1.156 | 60192.9 |
305 | 2020-10-01 10:18:24 | knifers | 1 | 69583 | 3 | 1.000 | 69583.0 |
304 | 2020-09-28 05:16:31 | knifers | 1 | 69583 | 3 | 0.986 | 70571.0 |
303 | 2020-09-06 20:17:07 | knifers | 1 | 69583 | 3 | 1.016 | 68487.2 |
302 | 2020-07-25 06:47:12 | knifers | 1 | 69583 | 3 | 1.156 | 60192.9 |
301 | 2020-06-18 05:12:32 | knifers | 1 | 69583 | 3 | 1.000 | 69583.0 |
300 | 2020-06-15 02:54:39 | knifers | 1 | 69583 | 3 | 1.190 | 58473.1 |
299 | 2020-04-24 22:04:50 | knifers | 1 | 69583 | 3 | 1.156 | 60192.9 |
298 | 2020-03-28 07:02:38 | knifers | 1 | 69583 | 3 | 1.203 | 57841.2 |
297 | 2020-03-27 21:49:29 | knifers | 3 | 134027 | 409 | 11.126 | 12046.3 |
296 | 2020-03-25 21:47:43 | knifers | 3 | 134027 | 409 | 6.890 | 19452.4 |
295 | 2020-03-25 06:37:51 | knifers | 3 | 134027 | 409 | 7.656 | 17506.1 |
294 | 2020-03-25 02:26:24 | knifers | 3 | 134027 | 409 | 7.063 | 18975.9 |
293 | 2020-03-25 00:52:14 | knifers | 3 | 134027 | 409 | 7.233 | 18529.9 |
292 | 2020-03-24 21:30:18 | knifers | 1 | 69583 | 3 | 1.123 | 61961.7 |
291 | 2020-03-24 12:54:37 | knifers | 3 | 134027 | 409 | 8.296 | 16155.6 |
290 | 2020-03-21 09:05:44 | knifers | 1 | 69583 | 3 | 1.200 | 57985.8 |
289 | 2020-03-04 03:47:04 | knifers | 1 | 69583 | 3 | 1.173 | 59320.5 |
288 | 2020-03-01 19:52:19 | knifers | 1 | 69583 | 3 | 1.186 | 58670.3 |
287 | 2020-02-27 15:40:39 | knifers | 3 | 134027 | 409 | 10.936 | 12255.6 |