History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
609 | 2024-05-01 15:47:09 | sparry | 1 | 48755 | 6 | 0.876 | 55656.4 |
608 | 2024-04-30 01:25:20 | sparry | 1 | 48755 | 6 | 2.920 | 16696.9 |
607 | 2024-04-29 10:23:44 | sparry | 2 | 82551 | 61 | 2.873 | 28733.4 |
606 | 2024-04-29 10:23:18 | sparry | 3 | 112716 | 613 | 6.060 | 18600.0 |
605 | 2024-04-29 01:22:14 | sparry | 2 | 82551 | 61 | 2.720 | 30349.6 |
604 | 2024-04-29 01:21:31 | sparry | 2 | 82551 | 61 | 2.906 | 28407.1 |
603 | 2024-04-29 01:21:27 | sparry | 3 | 112716 | 613 | 6.220 | 18121.5 |
602 | 2024-04-29 01:21:23 | sparry | 1 | 48755 | 6 | 0.923 | 52822.3 |
601 | 2024-04-29 01:21:01 | sparry | 3 | 112716 | 613 | 6.190 | 18209.4 |
600 | 2024-04-28 10:56:49 | sparry | 3 | 112716 | 613 | 7.923 | 14226.4 |
599 | 2024-04-28 09:16:21 | sparry | 2 | 82551 | 61 | 2.873 | 28733.4 |
598 | 2024-04-27 09:22:27 | sparry | 1 | 48755 | 6 | 0.936 | 52088.7 |
597 | 2024-03-31 17:56:17 | sparry | 1 | 48755 | 6 | 2.280 | 21383.8 |
596 | 2024-03-30 20:06:24 | sparry | 3 | 112716 | 613 | 19.470 | 5789.2 |
595 | 2024-03-30 01:08:40 | sparry | 3 | 112716 | 613 | 7.076 | 15929.3 |
594 | 2024-03-29 05:11:05 | sparry | 3 | 112716 | 613 | 19.830 | 5684.1 |
593 | 2024-03-29 05:10:37 | sparry | 3 | 112716 | 613 | 9.953 | 11324.8 |
592 | 2024-03-29 05:10:39 | sparry | 2 | 82551 | 61 | 7.483 | 11031.8 |
591 | 2024-03-29 05:10:35 | sparry | 1 | 48755 | 6 | 3.796 | 12843.8 |
590 | 2024-03-05 15:18:31 | sparry | 1 | 48755 | 6 | 0.893 | 54596.9 |
589 | 2024-01-10 00:23:21 | sparry | 1 | 48755 | 6 | 0.923 | 52822.3 |
588 | 2023-11-28 12:33:15 | sparry | 1 | 48755 | 6 | 0.750 | 65006.7 |
587 | 2023-11-28 02:34:32 | sparry | 1 | 48755 | 6 | 0.923 | 52822.3 |
586 | 2023-11-19 21:15:08 | sparry | 1 | 48755 | 6 | 0.750 | 65006.7 |
585 | 2023-11-04 13:38:57 | sparry | 1 | 48755 | 6 | 0.860 | 56691.9 |
584 | 2023-10-24 05:02:19 | sparry | 1 | 48755 | 6 | 0.906 | 53813.5 |
583 | 2023-10-20 16:50:34 | sparry | 1 | 48755 | 6 | 1.953 | 24964.2 |
582 | 2023-10-14 00:43:00 | sparry | 1 | 48755 | 6 | 0.843 | 57835.1 |
581 | 2023-10-02 20:10:06 | sparry | 1 | 48755 | 6 | 0.763 | 63899.1 |
580 | 2023-09-26 11:43:50 | sparry | 1 | 48755 | 6 | 0.876 | 55656.4 |
579 | 2023-09-13 11:53:29 | sparry | 1 | 48755 | 6 | 0.906 | 53813.5 |
578 | 2023-08-27 11:16:02 | sparry | 1 | 48755 | 6 | 0.856 | 56956.8 |
577 | 2023-05-30 11:29:50 | sparry | 1 | 48755 | 6 | 0.733 | 66514.3 |
576 | 2023-05-29 05:37:38 | sparry | 1 | 48755 | 6 | 0.750 | 65006.7 |
575 | 2023-03-23 08:25:30 | sparry | 1 | 48755 | 6 | 0.856 | 56956.8 |
574 | 2023-01-31 07:32:55 | sparry | 1 | 48755 | 6 | 0.826 | 59025.4 |
573 | 2023-01-27 19:09:31 | sparry | 1 | 48755 | 6 | 0.826 | 59025.4 |
572 | 2023-01-09 12:32:20 | sparry | 1 | 48755 | 6 | 0.733 | 66514.3 |
571 | 2022-10-06 01:53:03 | sparry | 1 | 48755 | 6 | 0.750 | 65006.7 |
570 | 2022-09-18 06:23:26 | sparry | 1 | 48755 | 6 | 0.780 | 62506.4 |
569 | 2022-05-21 08:46:32 | sparry | 1 | 48755 | 6 | 0.796 | 61250.0 |
568 | 2022-05-19 05:02:00 | sparry | 1 | 48755 | 6 | 0.843 | 57835.1 |
567 | 2022-05-12 10:58:33 | sparry | 1 | 48755 | 6 | 1.030 | 47335.0 |
566 | 2022-02-23 09:06:09 | sparry | 1 | 48755 | 6 | 0.843 | 57835.1 |
565 | 2022-01-16 11:08:21 | sparry | 1 | 48755 | 6 | 0.830 | 58741.0 |
564 | 2022-01-11 07:15:35 | sparry | 1 | 48755 | 6 | 0.766 | 63648.8 |
563 | 2021-11-12 06:28:32 | sparry | 1 | 48755 | 6 | 0.766 | 63648.8 |
562 | 2021-10-14 12:15:16 | sparry | 1 | 48755 | 6 | 0.873 | 55847.7 |
561 | 2021-09-25 10:53:18 | sparry | 1 | 48755 | 6 | 0.813 | 59969.2 |
560 | 2021-09-23 13:24:45 | sparry | 1 | 48755 | 6 | 0.780 | 62506.4 |
559 | 2021-09-01 19:02:18 | sparry | 1 | 48755 | 6 | 0.750 | 65006.7 |
558 | 2021-06-22 10:03:31 | sparry | 1 | 48755 | 6 | 0.890 | 54780.9 |
557 | 2021-06-14 08:43:56 | sparry | 2 | 82551 | 61 | 2.173 | 37989.4 |
556 | 2021-03-24 16:01:50 | sparry | 2 | 82551 | 61 | 2.140 | 38575.2 |
555 | 2021-03-20 04:52:56 | sparry | 1 | 48755 | 6 | 0.923 | 52822.3 |
554 | 2021-02-02 23:46:35 | sparry | 2 | 82551 | 61 | 2.190 | 37694.5 |
553 | 2021-01-31 20:49:17 | sparry | 1 | 48755 | 6 | 0.890 | 54780.9 |
552 | 2020-12-17 07:30:15 | sparry | 1 | 48755 | 6 | 0.890 | 54780.9 |
551 | 2020-10-26 14:37:05 | sparry | 1 | 48755 | 6 | 0.936 | 52088.7 |
550 | 2020-10-16 17:34:34 | sparry | 1 | 48755 | 6 | 0.766 | 63648.8 |
549 | 2020-10-08 03:14:45 | sparry | 1 | 48755 | 6 | 0.750 | 65006.7 |
548 | 2020-09-13 09:44:18 | sparry | 1 | 48755 | 6 | 0.766 | 63648.8 |
547 | 2020-09-04 08:15:29 | sparry | 1 | 48755 | 6 | 0.766 | 63648.8 |
546 | 2020-08-16 00:41:59 | sparry | 1 | 48755 | 6 | 0.766 | 63648.8 |
545 | 2020-07-23 23:22:54 | sparry | 1 | 48755 | 6 | 0.780 | 62506.4 |
544 | 2020-05-26 20:21:12 | sparry | 1 | 48755 | 6 | 0.830 | 58741.0 |
543 | 2020-05-23 05:13:01 | sparry | 1 | 48755 | 6 | 0.783 | 62266.9 |
542 | 2020-05-19 06:23:57 | sparry | 1 | 48755 | 6 | 0.750 | 65006.7 |
541 | 2020-05-18 17:42:59 | sparry | 1 | 48755 | 6 | 0.860 | 56691.9 |
540 | 2020-05-17 16:37:32 | sparry | 1 | 48755 | 6 | 0.813 | 59969.2 |
539 | 2020-05-14 18:37:28 | sparry | 1 | 48755 | 6 | 0.796 | 61250.0 |
538 | 2020-05-14 05:47:05 | sparry | 1 | 48755 | 6 | 0.780 | 62506.4 |
537 | 2020-03-27 14:49:50 | sparry | 1 | 48755 | 6 | 0.876 | 55656.4 |
536 | 2020-03-27 04:32:04 | sparry | 1 | 48755 | 6 | 0.970 | 50262.9 |
535 | 2020-03-25 00:32:52 | sparry | 1 | 48755 | 6 | 0.846 | 57630.0 |
534 | 2020-03-22 21:44:50 | sparry | 1 | 48755 | 6 | 0.796 | 61250.0 |
533 | 2020-03-22 12:23:43 | sparry | 1 | 48755 | 6 | 0.796 | 61250.0 |
532 | 2020-03-18 20:58:16 | sparry | 1 | 48755 | 6 | 0.856 | 56956.8 |
531 | 2020-03-04 23:23:46 | sparry | 3 | 112716 | 613 | 12.236 | 9211.8 |
530 | 2020-03-01 04:48:03 | sparry | 3 | 112716 | 613 | 5.970 | 18880.4 |
529 | 2020-02-24 17:52:58 | sparry | 1 | 48755 | 6 | 1.876 | 25988.8 |
528 | 2020-02-23 11:49:22 | sparry | 1 | 48755 | 6 | 0.986 | 49447.3 |
527 | 2020-02-14 23:42:51 | sparry | 3 | 112716 | 613 | 5.890 | 19136.8 |
526 | 2020-02-14 20:35:36 | sparry | 3 | 112716 | 613 | 7.813 | 14426.7 |
525 | 2020-02-14 20:27:46 | sparry | 3 | 112716 | 613 | 5.826 | 19347.1 |
524 | 2020-02-14 14:08:39 | sparry | 3 | 112716 | 613 | 14.846 | 7592.3 |
523 | 2020-02-13 15:00:57 | sparry | 1 | 48755 | 6 | 1.016 | 47987.2 |
522 | 2020-02-11 07:02:29 | sparry | 1 | 48755 | 6 | 0.830 | 58741.0 |
521 | 2020-02-07 04:10:45 | sparry | 1 | 48755 | 6 | 0.920 | 52994.6 |
520 | 2020-02-04 15:14:35 | sparry | 1 | 48755 | 6 | 1.000 | 48755.0 |
519 | 2020-02-01 10:41:23 | sparry | 1 | 48755 | 6 | 1.736 | 28084.7 |
518 | 2020-01-31 06:38:16 | sparry | 1 | 48755 | 6 | 1.736 | 28084.7 |
517 | 2020-01-26 22:28:21 | sparry | 1 | 48755 | 6 | 2.813 | 17332.0 |
516 | 2020-01-22 07:04:15 | sparry | 1 | 48755 | 6 | 1.783 | 27344.4 |
515 | 2020-01-18 17:16:37 | sparry | 3 | 112716 | 613 | 5.763 | 19558.6 |
514 | 2020-01-18 09:25:03 | sparry | 3 | 112716 | 613 | 6.640 | 16975.3 |
513 | 2020-01-15 11:47:33 | sparry | 1 | 48755 | 6 | 0.873 | 55847.7 |
512 | 2020-01-14 06:17:10 | sparry | 1 | 48755 | 6 | 0.906 | 53813.5 |
511 | 2020-01-10 21:27:05 | sparry | 2 | 82551 | 61 | 2.860 | 28864.0 |
510 | 2020-01-10 17:14:37 | sparry | 1 | 48755 | 6 | 0.920 | 52994.6 |