History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shanks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
412 | 2024-04-27 16:52:09 | shanks | 1 | 48755 | 10 | 0.923 | 52822.3 |
411 | 2024-04-20 06:50:01 | shanks | 1 | 48755 | 10 | 0.936 | 52088.7 |
410 | 2024-03-31 13:54:04 | shanks | 1 | 48755 | 10 | 3.046 | 16006.2 |
409 | 2024-03-31 13:53:43 | shanks | 2 | 82551 | 139 | 6.123 | 13482.1 |
408 | 2024-03-31 09:38:22 | shanks | 2 | 82551 | 139 | 9.030 | 9141.9 |
407 | 2024-03-31 09:38:10 | shanks | 1 | 48755 | 10 | 2.670 | 18260.3 |
406 | 2024-03-30 13:20:07 | shanks | 1 | 48755 | 10 | 0.893 | 54596.9 |
405 | 2024-02-29 06:53:00 | shanks | 1 | 48755 | 10 | 1.813 | 26891.9 |
404 | 2024-01-19 06:53:59 | shanks | 2 | 82551 | 139 | 2.483 | 33246.5 |
403 | 2024-01-05 16:47:14 | shanks | 2 | 82551 | 139 | 2.436 | 33887.9 |
402 | 2024-01-03 07:31:00 | shanks | 1 | 48755 | 10 | 0.826 | 59025.4 |
401 | 2023-12-22 01:34:57 | shanks | 1 | 48755 | 10 | 0.780 | 62506.4 |
400 | 2023-12-15 10:12:55 | shanks | 1 | 48755 | 10 | 0.860 | 56691.9 |
399 | 2023-12-12 07:38:31 | shanks | 2 | 82551 | 139 | 2.376 | 34743.7 |
398 | 2023-12-08 04:28:07 | shanks | 1 | 48755 | 10 | 0.860 | 56691.9 |
397 | 2023-12-07 13:48:22 | shanks | 1 | 48755 | 10 | 0.950 | 51321.1 |
396 | 2023-12-07 13:48:20 | shanks | 1 | 48755 | 10 | 0.953 | 51159.5 |
395 | 2023-12-07 13:20:46 | shanks | 1 | 48755 | 10 | 0.876 | 55656.4 |
394 | 2023-11-30 21:29:01 | shanks | 2 | 82551 | 139 | 2.173 | 37989.4 |
393 | 2023-11-27 07:12:37 | shanks | 1 | 48755 | 10 | 0.763 | 63899.1 |
392 | 2023-11-18 04:44:44 | shanks | 1 | 48755 | 10 | 0.843 | 57835.1 |
391 | 2023-11-13 15:34:50 | shanks | 2 | 82551 | 139 | 2.390 | 34540.2 |
390 | 2023-11-10 03:07:42 | shanks | 1 | 48755 | 10 | 0.750 | 65006.7 |
389 | 2023-11-04 05:10:37 | shanks | 1 | 48755 | 10 | 0.890 | 54780.9 |
388 | 2023-10-31 22:54:58 | shanks | 1 | 48755 | 10 | 0.860 | 56691.9 |
387 | 2023-10-31 07:49:00 | shanks | 1 | 48755 | 10 | 0.796 | 61250.0 |
386 | 2023-10-29 19:45:31 | shanks | 2 | 82551 | 139 | 5.343 | 15450.3 |
385 | 2023-10-28 14:43:59 | shanks | 1 | 48755 | 10 | 0.830 | 58741.0 |
384 | 2023-10-22 03:04:04 | shanks | 1 | 48755 | 10 | 0.856 | 56956.8 |
383 | 2023-10-13 21:11:14 | shanks | 1 | 48755 | 10 | 0.750 | 65006.7 |
382 | 2023-10-09 12:40:20 | shanks | 1 | 48755 | 10 | 0.810 | 60191.4 |
381 | 2023-10-07 20:26:21 | shanks | 1 | 48755 | 10 | 0.873 | 55847.7 |
380 | 2023-09-26 07:24:12 | shanks | 1 | 48755 | 10 | 0.783 | 62266.9 |
379 | 2023-09-14 11:28:31 | shanks | 1 | 48755 | 10 | 0.783 | 62266.9 |
378 | 2023-08-06 21:42:33 | shanks | 2 | 82551 | 139 | 2.123 | 38884.1 |
377 | 2023-08-05 17:19:18 | shanks | 1 | 48755 | 10 | 0.766 | 63648.8 |
376 | 2023-07-12 07:14:17 | shanks | 1 | 48755 | 10 | 0.780 | 62506.4 |
375 | 2023-04-30 23:16:43 | shanks | 1 | 48755 | 10 | 0.766 | 63648.8 |
374 | 2023-04-22 02:31:20 | shanks | 2 | 82551 | 139 | 2.156 | 38289.0 |
373 | 2023-03-28 07:31:19 | shanks | 1 | 48755 | 10 | 0.830 | 58741.0 |
372 | 2023-02-23 17:09:44 | shanks | 1 | 48755 | 10 | 0.766 | 63648.8 |
371 | 2023-01-25 18:51:56 | shanks | 2 | 82551 | 139 | 2.330 | 35429.6 |
370 | 2022-12-20 23:37:40 | shanks | 1 | 48755 | 10 | 0.826 | 59025.4 |
369 | 2022-12-13 01:40:41 | shanks | 1 | 48755 | 10 | 0.783 | 62266.9 |
368 | 2022-12-02 10:52:29 | shanks | 2 | 82551 | 139 | 2.250 | 36689.3 |
367 | 2022-11-05 23:58:24 | shanks | 2 | 82551 | 139 | 2.483 | 33246.5 |
366 | 2022-11-04 19:30:05 | shanks | 2 | 82551 | 139 | 2.483 | 33246.5 |
365 | 2022-09-14 21:13:55 | shanks | 1 | 48755 | 10 | 0.750 | 65006.7 |
364 | 2022-09-03 03:55:10 | shanks | 2 | 82551 | 139 | 2.146 | 38467.4 |
363 | 2022-08-31 08:22:37 | shanks | 1 | 48755 | 10 | 0.766 | 63648.8 |
362 | 2022-08-19 09:35:01 | shanks | 1 | 48755 | 10 | 0.763 | 63899.1 |
361 | 2022-08-03 10:33:16 | shanks | 2 | 82551 | 139 | 2.123 | 38884.1 |
360 | 2022-07-19 08:27:24 | shanks | 2 | 82551 | 139 | 2.143 | 38521.2 |
359 | 2022-06-06 22:35:21 | shanks | 2 | 82551 | 139 | 2.160 | 38218.1 |
358 | 2022-04-15 18:59:52 | shanks | 1 | 48755 | 10 | 0.783 | 62266.9 |
357 | 2022-04-15 10:50:11 | shanks | 1 | 48755 | 10 | 0.920 | 52994.6 |
356 | 2022-01-28 09:05:37 | shanks | 2 | 82551 | 139 | 2.436 | 33887.9 |
355 | 2022-01-26 03:09:11 | shanks | 2 | 82551 | 139 | 2.173 | 37989.4 |
354 | 2022-01-09 08:31:11 | shanks | 1 | 48755 | 10 | 0.890 | 54780.9 |
353 | 2021-12-27 12:25:32 | shanks | 1 | 48755 | 10 | 0.860 | 56691.9 |
352 | 2021-11-11 15:22:18 | shanks | 1 | 48755 | 10 | 0.826 | 59025.4 |
351 | 2021-10-27 19:14:12 | shanks | 2 | 82551 | 139 | 2.156 | 38289.0 |
350 | 2021-09-27 03:27:03 | shanks | 1 | 48755 | 10 | 0.970 | 50262.9 |
349 | 2021-09-20 10:13:51 | shanks | 1 | 48755 | 10 | 0.890 | 54780.9 |
348 | 2021-08-27 07:14:24 | shanks | 2 | 82551 | 139 | 2.190 | 37694.5 |
347 | 2021-08-25 13:24:51 | shanks | 1 | 48755 | 10 | 0.953 | 51159.5 |
346 | 2021-08-23 09:29:08 | shanks | 1 | 48755 | 10 | 0.843 | 57835.1 |
345 | 2021-06-17 06:41:56 | shanks | 1 | 48755 | 10 | 0.813 | 59969.2 |
344 | 2021-05-20 02:12:05 | shanks | 1 | 48755 | 10 | 0.766 | 63648.8 |
343 | 2021-04-20 05:33:48 | shanks | 1 | 48755 | 10 | 0.766 | 63648.8 |
342 | 2021-03-14 11:47:20 | shanks | 1 | 48755 | 10 | 0.766 | 63648.8 |
341 | 2021-01-04 20:54:29 | shanks | 1 | 48755 | 10 | 0.750 | 65006.7 |
340 | 2020-12-11 11:20:34 | shanks | 1 | 48755 | 10 | 0.750 | 65006.7 |
339 | 2020-10-25 02:49:13 | shanks | 2 | 82551 | 139 | 2.500 | 33020.4 |
338 | 2020-10-16 11:14:03 | shanks | 1 | 48755 | 10 | 0.830 | 58741.0 |
337 | 2020-10-16 11:13:12 | shanks | 1 | 48755 | 10 | 0.766 | 63648.8 |
336 | 2020-10-06 00:42:58 | shanks | 1 | 48755 | 10 | 0.873 | 55847.7 |
335 | 2020-09-23 22:10:24 | shanks | 1 | 48755 | 10 | 0.876 | 55656.4 |
334 | 2020-09-17 19:02:28 | shanks | 1 | 48755 | 10 | 0.923 | 52822.3 |
333 | 2020-09-04 17:13:45 | shanks | 1 | 48755 | 10 | 0.750 | 65006.7 |
332 | 2020-09-04 08:54:49 | shanks | 1 | 48755 | 10 | 0.780 | 62506.4 |
331 | 2020-08-05 21:19:58 | shanks | 1 | 48755 | 10 | 0.780 | 62506.4 |
330 | 2020-08-02 14:40:23 | shanks | 1 | 48755 | 10 | 0.796 | 61250.0 |
329 | 2020-07-30 05:44:07 | shanks | 1 | 48755 | 10 | 0.810 | 60191.4 |
328 | 2020-07-21 23:23:33 | shanks | 1 | 48755 | 10 | 0.906 | 53813.5 |
327 | 2020-07-20 12:31:12 | shanks | 1 | 48755 | 10 | 0.860 | 56691.9 |
326 | 2020-05-30 13:09:09 | shanks | 1 | 48755 | 10 | 0.750 | 65006.7 |
325 | 2020-04-16 17:35:39 | shanks | 1 | 48755 | 10 | 0.830 | 58741.0 |
324 | 2020-03-26 08:39:16 | shanks | 1 | 48755 | 10 | 1.780 | 27390.4 |
323 | 2020-03-25 20:38:51 | shanks | 1 | 48755 | 10 | 0.766 | 63648.8 |
322 | 2020-03-24 18:13:18 | shanks | 1 | 48755 | 10 | 0.763 | 63899.1 |
321 | 2020-03-23 06:09:19 | shanks | 1 | 48755 | 10 | 0.906 | 53813.5 |
320 | 2020-03-22 00:50:42 | shanks | 1 | 48755 | 10 | 0.860 | 56691.9 |
319 | 2020-03-18 15:34:31 | shanks | 1 | 48755 | 10 | 0.873 | 55847.7 |
318 | 2020-02-27 18:37:08 | shanks | 2 | 82551 | 139 | 2.766 | 29844.9 |
317 | 2020-02-27 17:21:41 | shanks | 2 | 82551 | 139 | 6.033 | 13683.2 |
316 | 2020-02-27 06:02:00 | shanks | 1 | 48755 | 10 | 0.830 | 58741.0 |
315 | 2020-02-26 06:05:49 | shanks | 1 | 48755 | 10 | 0.843 | 57835.1 |
314 | 2020-02-22 20:22:15 | shanks | 1 | 48755 | 10 | 1.423 | 34262.1 |
313 | 2020-02-21 02:24:12 | shanks | 1 | 48755 | 10 | 0.936 | 52088.7 |