History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sprats"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
507 | 2024-04-27 15:46:17 | sprats | 1 | 48755 | 8 | 2.123 | 22965.1 |
506 | 2024-03-03 23:38:18 | sprats | 1 | 48755 | 8 | 0.983 | 49598.2 |
505 | 2024-02-28 04:53:57 | sprats | 1 | 48755 | 8 | 1.423 | 34262.1 |
504 | 2024-02-26 13:08:55 | sprats | 2 | 82551 | 113 | 2.766 | 29844.9 |
503 | 2024-02-22 04:55:06 | sprats | 2 | 82551 | 113 | 8.673 | 9518.2 |
502 | 2024-02-21 01:35:30 | sprats | 2 | 82551 | 113 | 5.376 | 15355.5 |
501 | 2024-01-25 12:39:05 | sprats | 1 | 48755 | 8 | 0.750 | 65006.7 |
500 | 2024-01-15 00:28:25 | sprats | 2 | 82551 | 113 | 2.593 | 31836.1 |
499 | 2023-12-14 23:39:30 | sprats | 2 | 82551 | 113 | 2.560 | 32246.5 |
498 | 2023-12-12 09:25:49 | sprats | 2 | 82551 | 113 | 2.360 | 34979.2 |
497 | 2023-11-21 05:52:23 | sprats | 1 | 48755 | 8 | 0.920 | 52994.6 |
496 | 2023-11-20 00:28:11 | sprats | 1 | 48755 | 8 | 0.783 | 62266.9 |
495 | 2023-11-18 00:43:32 | sprats | 2 | 82551 | 113 | 2.326 | 35490.5 |
494 | 2023-11-11 11:29:41 | sprats | 1 | 48755 | 8 | 0.826 | 59025.4 |
493 | 2023-11-09 05:24:42 | sprats | 1 | 48755 | 8 | 0.830 | 58741.0 |
492 | 2023-11-05 21:13:45 | sprats | 1 | 48755 | 8 | 0.843 | 57835.1 |
491 | 2023-10-28 14:49:44 | sprats | 1 | 48755 | 8 | 0.830 | 58741.0 |
490 | 2023-10-24 22:31:57 | sprats | 1 | 48755 | 8 | 1.516 | 32160.3 |
489 | 2023-10-20 05:19:25 | sprats | 1 | 48755 | 8 | 0.783 | 62266.9 |
488 | 2023-10-13 05:25:53 | sprats | 2 | 82551 | 113 | 4.503 | 18332.4 |
487 | 2023-10-10 14:26:10 | sprats | 1 | 48755 | 8 | 0.843 | 57835.1 |
486 | 2023-09-26 19:25:53 | sprats | 1 | 48755 | 8 | 0.940 | 51867.0 |
485 | 2023-09-23 14:15:35 | sprats | 1 | 48755 | 8 | 0.780 | 62506.4 |
484 | 2023-09-17 00:23:18 | sprats | 1 | 48755 | 8 | 0.783 | 62266.9 |
483 | 2023-09-09 08:25:36 | sprats | 1 | 48755 | 8 | 0.750 | 65006.7 |
482 | 2023-08-18 11:42:59 | sprats | 2 | 82551 | 113 | 2.173 | 37989.4 |
481 | 2023-07-06 18:30:59 | sprats | 1 | 48755 | 8 | 0.843 | 57835.1 |
480 | 2023-06-10 20:36:49 | sprats | 1 | 48755 | 8 | 1.483 | 32875.9 |
479 | 2023-04-30 21:34:53 | sprats | 2 | 82551 | 113 | 2.173 | 37989.4 |
478 | 2023-03-30 22:42:08 | sprats | 1 | 48755 | 8 | 0.736 | 66243.2 |
477 | 2023-03-13 06:37:07 | sprats | 1 | 48755 | 8 | 0.843 | 57835.1 |
476 | 2023-02-08 00:39:26 | sprats | 2 | 82551 | 113 | 4.216 | 19580.4 |
475 | 2023-01-13 18:41:34 | sprats | 1 | 48755 | 8 | 0.750 | 65006.7 |
474 | 2022-11-19 22:07:42 | sprats | 2 | 82551 | 113 | 2.326 | 35490.5 |
473 | 2022-11-14 14:39:08 | sprats | 1 | 48755 | 8 | 0.733 | 66514.3 |
472 | 2022-11-02 15:47:42 | sprats | 1 | 48755 | 8 | 0.920 | 52994.6 |
471 | 2022-09-01 11:06:06 | sprats | 2 | 82551 | 113 | 2.390 | 34540.2 |
470 | 2022-08-28 13:44:33 | sprats | 2 | 82551 | 113 | 2.170 | 38041.9 |
469 | 2022-08-28 13:07:50 | sprats | 2 | 82551 | 113 | 2.110 | 39123.7 |
468 | 2022-07-27 05:11:14 | sprats | 2 | 82551 | 113 | 2.143 | 38521.2 |
467 | 2022-07-25 10:27:59 | sprats | 1 | 48755 | 8 | 0.923 | 52822.3 |
466 | 2022-06-23 10:21:12 | sprats | 2 | 82551 | 113 | 2.173 | 37989.4 |
465 | 2022-06-22 00:26:24 | sprats | 1 | 48755 | 8 | 0.763 | 63899.1 |
464 | 2022-06-07 08:49:16 | sprats | 1 | 48755 | 8 | 0.750 | 65006.7 |
463 | 2022-03-30 22:33:57 | sprats | 1 | 48755 | 8 | 0.750 | 65006.7 |
462 | 2022-02-25 02:30:41 | sprats | 1 | 48755 | 8 | 0.890 | 54780.9 |
461 | 2021-12-16 05:31:46 | sprats | 1 | 48755 | 8 | 0.843 | 57835.1 |
460 | 2021-12-10 00:35:19 | sprats | 1 | 48755 | 8 | 0.780 | 62506.4 |
459 | 2021-12-06 17:59:55 | sprats | 1 | 48755 | 8 | 0.830 | 58741.0 |
458 | 2021-10-23 11:31:16 | sprats | 1 | 48755 | 8 | 0.860 | 56691.9 |
457 | 2021-09-11 09:06:59 | sprats | 1 | 48755 | 8 | 0.750 | 65006.7 |
456 | 2021-08-30 09:41:47 | sprats | 1 | 48755 | 8 | 0.783 | 62266.9 |
455 | 2021-08-22 13:39:16 | sprats | 1 | 48755 | 8 | 0.750 | 65006.7 |
454 | 2021-07-27 00:48:07 | sprats | 1 | 48755 | 8 | 0.750 | 65006.7 |
453 | 2021-06-21 18:35:34 | sprats | 2 | 82551 | 113 | 2.470 | 33421.5 |
452 | 2021-05-29 16:57:34 | sprats | 1 | 48755 | 8 | 0.906 | 53813.5 |
451 | 2021-05-25 15:03:01 | sprats | 2 | 82551 | 113 | 2.393 | 34496.9 |
450 | 2021-05-17 18:54:53 | sprats | 1 | 48755 | 8 | 0.783 | 62266.9 |
449 | 2021-05-04 18:54:42 | sprats | 1 | 48755 | 8 | 0.840 | 58041.7 |
448 | 2021-04-24 02:00:05 | sprats | 2 | 82551 | 113 | 2.733 | 30205.3 |
447 | 2021-04-17 19:54:08 | sprats | 1 | 48755 | 8 | 0.890 | 54780.9 |
446 | 2021-04-02 07:26:13 | sprats | 2 | 82551 | 113 | 2.423 | 34069.7 |
445 | 2021-03-20 15:39:11 | sprats | 1 | 48755 | 8 | 1.780 | 27390.4 |
444 | 2021-02-26 22:37:46 | sprats | 1 | 48755 | 8 | 0.923 | 52822.3 |
443 | 2021-01-17 08:05:10 | sprats | 2 | 82551 | 113 | 2.123 | 38884.1 |
442 | 2021-01-02 03:18:55 | sprats | 1 | 48755 | 8 | 0.750 | 65006.7 |
441 | 2020-11-23 02:16:31 | sprats | 2 | 82551 | 113 | 2.173 | 37989.4 |
440 | 2020-11-22 05:24:46 | sprats | 1 | 48755 | 8 | 0.813 | 59969.2 |
439 | 2020-11-10 20:26:16 | sprats | 1 | 48755 | 8 | 0.830 | 58741.0 |
438 | 2020-11-01 13:21:00 | sprats | 2 | 82551 | 113 | 2.423 | 34069.7 |
437 | 2020-10-29 02:17:13 | sprats | 1 | 48755 | 8 | 0.860 | 56691.9 |
436 | 2020-10-24 08:45:11 | sprats | 1 | 48755 | 8 | 0.860 | 56691.9 |
435 | 2020-10-17 09:16:33 | sprats | 1 | 48755 | 8 | 0.843 | 57835.1 |
434 | 2020-09-16 22:26:36 | sprats | 2 | 82551 | 113 | 2.200 | 37523.2 |
433 | 2020-08-19 17:15:15 | sprats | 2 | 82551 | 113 | 2.313 | 35690.0 |
432 | 2020-08-14 21:49:23 | sprats | 1 | 48755 | 8 | 0.843 | 57835.1 |
431 | 2020-08-01 08:17:15 | sprats | 1 | 48755 | 8 | 0.796 | 61250.0 |
430 | 2020-07-29 00:10:17 | sprats | 1 | 48755 | 8 | 0.830 | 58741.0 |
429 | 2020-05-07 18:33:23 | sprats | 1 | 48755 | 8 | 0.796 | 61250.0 |
428 | 2020-05-01 08:15:59 | sprats | 1 | 48755 | 8 | 0.843 | 57835.1 |
427 | 2020-03-27 14:22:24 | sprats | 1 | 48755 | 8 | 0.906 | 53813.5 |
426 | 2020-03-27 07:18:04 | sprats | 1 | 48755 | 8 | 0.936 | 52088.7 |
425 | 2020-03-25 13:00:57 | sprats | 1 | 48755 | 8 | 0.843 | 57835.1 |
424 | 2020-03-22 17:28:35 | sprats | 1 | 48755 | 8 | 0.873 | 55847.7 |
423 | 2020-03-22 13:53:00 | sprats | 1 | 48755 | 8 | 0.970 | 50262.9 |
422 | 2020-03-18 20:44:40 | sprats | 1 | 48755 | 8 | 0.826 | 59025.4 |
421 | 2020-02-25 14:54:58 | sprats | 1 | 48755 | 8 | 0.826 | 59025.4 |
420 | 2020-02-25 13:35:54 | sprats | 1 | 48755 | 8 | 2.110 | 23106.6 |
419 | 2020-02-24 12:08:46 | sprats | 1 | 48755 | 8 | 1.826 | 26700.4 |
418 | 2020-02-24 09:58:26 | sprats | 1 | 48755 | 8 | 0.923 | 52822.3 |
417 | 2020-02-20 14:10:46 | sprats | 1 | 48755 | 8 | 1.890 | 25796.3 |
416 | 2020-02-18 17:34:52 | sprats | 1 | 48755 | 8 | 1.623 | 30040.0 |
415 | 2020-02-13 15:35:32 | sprats | 1 | 48755 | 8 | 0.860 | 56691.9 |
414 | 2020-02-10 17:24:09 | sprats | 1 | 48755 | 8 | 1.830 | 26642.1 |
413 | 2020-02-05 04:34:45 | sprats | 1 | 48755 | 8 | 0.953 | 51159.5 |
412 | 2020-01-30 11:19:36 | sprats | 1 | 48755 | 8 | 0.936 | 52088.7 |
411 | 2020-01-29 17:17:07 | sprats | 1 | 48755 | 8 | 0.936 | 52088.7 |
410 | 2020-01-29 07:19:51 | sprats | 1 | 48755 | 8 | 0.953 | 51159.5 |
409 | 2020-01-25 16:23:52 | sprats | 1 | 48755 | 8 | 1.533 | 31803.7 |
408 | 2020-01-24 21:40:41 | sprats | 1 | 48755 | 8 | 1.876 | 25988.8 |