History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
645 | 2024-04-26 22:30:31 | sparer | 1 | 48755 | 18 | 0.940 | 51867.0 |
644 | 2024-04-03 04:55:23 | sparer | 1 | 48755 | 18 | 2.716 | 17951.0 |
643 | 2024-03-31 17:56:20 | sparer | 1 | 48755 | 18 | 2.000 | 24377.5 |
642 | 2024-03-04 04:11:56 | sparer | 1 | 48755 | 18 | 3.626 | 13445.9 |
641 | 2024-02-28 10:30:00 | sparer | 1 | 48755 | 18 | 1.920 | 25393.2 |
640 | 2024-02-28 02:04:05 | sparer | 2 | 82551 | 202 | 2.906 | 28407.1 |
639 | 2024-02-28 02:04:03 | sparer | 1 | 48755 | 18 | 0.846 | 57630.0 |
638 | 2024-02-20 13:40:57 | sparer | 1 | 48755 | 18 | 0.873 | 55847.7 |
637 | 2024-02-02 21:56:20 | sparer | 1 | 48755 | 18 | 0.860 | 56691.9 |
636 | 2024-01-29 11:28:21 | sparer | 2 | 82551 | 202 | 2.720 | 30349.6 |
635 | 2023-12-18 04:38:47 | sparer | 1 | 48755 | 18 | 0.766 | 63648.8 |
634 | 2023-12-05 12:05:50 | sparer | 1 | 48755 | 18 | 1.876 | 25988.8 |
633 | 2023-11-28 16:58:24 | sparer | 2 | 82551 | 202 | 2.550 | 32372.9 |
632 | 2023-11-17 16:41:00 | sparer | 2 | 82551 | 202 | 2.766 | 29844.9 |
631 | 2023-11-17 12:00:38 | sparer | 1 | 48755 | 18 | 0.783 | 62266.9 |
630 | 2023-11-10 23:26:37 | sparer | 1 | 48755 | 18 | 0.826 | 59025.4 |
629 | 2023-11-07 13:39:31 | sparer | 2 | 82551 | 202 | 2.440 | 33832.4 |
628 | 2023-11-06 10:35:55 | sparer | 1 | 48755 | 18 | 0.763 | 63899.1 |
627 | 2023-10-25 15:48:32 | sparer | 1 | 48755 | 18 | 0.830 | 58741.0 |
626 | 2023-10-24 04:29:02 | sparer | 1 | 48755 | 18 | 0.830 | 58741.0 |
625 | 2023-10-22 00:33:41 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
624 | 2023-10-20 16:50:13 | sparer | 1 | 48755 | 18 | 0.780 | 62506.4 |
623 | 2023-10-13 14:40:37 | sparer | 1 | 48755 | 18 | 0.906 | 53813.5 |
622 | 2023-10-08 16:20:06 | sparer | 1 | 48755 | 18 | 0.766 | 63648.8 |
621 | 2023-09-26 19:24:51 | sparer | 1 | 48755 | 18 | 0.780 | 62506.4 |
620 | 2023-09-19 13:28:35 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
619 | 2023-09-14 08:05:19 | sparer | 1 | 48755 | 18 | 0.766 | 63648.8 |
618 | 2023-08-11 11:11:25 | sparer | 2 | 82551 | 202 | 2.236 | 36919.1 |
617 | 2023-07-05 04:11:24 | sparer | 1 | 48755 | 18 | 0.873 | 55847.7 |
616 | 2023-07-01 10:44:05 | sparer | 1 | 48755 | 18 | 0.846 | 57630.0 |
615 | 2023-04-23 01:59:27 | sparer | 2 | 82551 | 202 | 2.173 | 37989.4 |
614 | 2023-03-24 23:54:34 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
613 | 2023-02-03 05:16:04 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
612 | 2023-02-03 03:47:51 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
611 | 2023-01-24 18:13:13 | sparer | 2 | 82551 | 202 | 2.170 | 38041.9 |
610 | 2022-12-07 12:59:01 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
609 | 2022-12-06 21:03:18 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
608 | 2022-11-05 07:43:31 | sparer | 2 | 82551 | 202 | 2.423 | 34069.7 |
607 | 2022-08-09 12:38:20 | sparer | 1 | 48755 | 18 | 0.780 | 62506.4 |
606 | 2022-07-30 21:16:03 | sparer | 1 | 48755 | 18 | 0.780 | 62506.4 |
605 | 2022-05-18 12:38:00 | sparer | 2 | 82551 | 202 | 2.140 | 38575.2 |
604 | 2022-05-11 13:58:55 | sparer | 1 | 48755 | 18 | 0.813 | 59969.2 |
603 | 2022-05-11 00:30:16 | sparer | 1 | 48755 | 18 | 0.906 | 53813.5 |
602 | 2022-05-10 16:21:39 | sparer | 1 | 48755 | 18 | 1.076 | 45311.3 |
601 | 2022-05-10 05:13:33 | sparer | 1 | 48755 | 18 | 0.843 | 57835.1 |
600 | 2022-05-09 12:35:11 | sparer | 1 | 48755 | 18 | 0.920 | 52994.6 |
599 | 2022-05-08 08:10:38 | sparer | 1 | 48755 | 18 | 0.766 | 63648.8 |
598 | 2022-05-07 16:52:41 | sparer | 1 | 48755 | 18 | 0.843 | 57835.1 |
597 | 2022-04-03 04:53:14 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
596 | 2022-03-29 10:47:52 | sparer | 1 | 48755 | 18 | 1.080 | 45143.5 |
595 | 2022-02-25 23:27:44 | sparer | 1 | 48755 | 18 | 0.873 | 55847.7 |
594 | 2022-02-08 04:32:20 | sparer | 1 | 48755 | 18 | 0.780 | 62506.4 |
593 | 2022-01-21 12:43:01 | sparer | 1 | 48755 | 18 | 1.736 | 28084.7 |
592 | 2022-01-21 06:03:45 | sparer | 1 | 48755 | 18 | 0.843 | 57835.1 |
591 | 2022-01-21 02:28:52 | sparer | 1 | 48755 | 18 | 0.890 | 54780.9 |
590 | 2022-01-20 15:45:19 | sparer | 1 | 48755 | 18 | 1.843 | 26454.2 |
589 | 2022-01-20 08:00:43 | sparer | 1 | 48755 | 18 | 0.873 | 55847.7 |
588 | 2022-01-20 04:45:33 | sparer | 1 | 48755 | 18 | 0.826 | 59025.4 |
587 | 2022-01-19 14:53:53 | sparer | 1 | 48755 | 18 | 0.810 | 60191.4 |
586 | 2022-01-19 07:55:36 | sparer | 1 | 48755 | 18 | 0.970 | 50262.9 |
585 | 2022-01-18 22:58:22 | sparer | 1 | 48755 | 18 | 0.830 | 58741.0 |
584 | 2022-01-18 12:32:35 | sparer | 1 | 48755 | 18 | 0.856 | 56956.8 |
583 | 2022-01-18 07:44:31 | sparer | 1 | 48755 | 18 | 1.813 | 26891.9 |
582 | 2022-01-17 23:08:35 | sparer | 1 | 48755 | 18 | 0.923 | 52822.3 |
581 | 2022-01-13 04:38:44 | sparer | 1 | 48755 | 18 | 0.856 | 56956.8 |
580 | 2022-01-12 19:46:38 | sparer | 1 | 48755 | 18 | 0.826 | 59025.4 |
579 | 2022-01-12 02:58:09 | sparer | 1 | 48755 | 18 | 0.876 | 55656.4 |
578 | 2022-01-11 13:04:28 | sparer | 1 | 48755 | 18 | 0.890 | 54780.9 |
577 | 2022-01-10 22:04:52 | sparer | 1 | 48755 | 18 | 0.860 | 56691.9 |
576 | 2022-01-10 11:02:29 | sparer | 1 | 48755 | 18 | 0.763 | 63899.1 |
575 | 2022-01-09 15:06:33 | sparer | 1 | 48755 | 18 | 0.893 | 54596.9 |
574 | 2022-01-06 23:39:29 | sparer | 1 | 48755 | 18 | 0.860 | 56691.9 |
573 | 2021-12-21 11:55:33 | sparer | 1 | 48755 | 18 | 0.890 | 54780.9 |
572 | 2021-12-19 07:57:52 | sparer | 1 | 48755 | 18 | 0.766 | 63648.8 |
571 | 2021-12-18 21:17:20 | sparer | 1 | 48755 | 18 | 0.903 | 53992.2 |
570 | 2021-12-18 03:32:40 | sparer | 1 | 48755 | 18 | 0.890 | 54780.9 |
569 | 2021-12-17 15:56:03 | sparer | 1 | 48755 | 18 | 0.860 | 56691.9 |
568 | 2021-12-08 04:52:14 | sparer | 1 | 48755 | 18 | 0.860 | 56691.9 |
567 | 2021-12-07 18:35:55 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
566 | 2021-12-07 09:43:56 | sparer | 1 | 48755 | 18 | 0.860 | 56691.9 |
565 | 2021-12-06 21:22:59 | sparer | 1 | 48755 | 18 | 0.763 | 63899.1 |
564 | 2021-12-06 02:21:11 | sparer | 1 | 48755 | 18 | 0.856 | 56956.8 |
563 | 2021-12-05 14:36:36 | sparer | 1 | 48755 | 18 | 0.890 | 54780.9 |
562 | 2021-12-04 22:47:04 | sparer | 1 | 48755 | 18 | 0.830 | 58741.0 |
561 | 2021-12-04 13:17:23 | sparer | 1 | 48755 | 18 | 0.860 | 56691.9 |
560 | 2021-12-04 03:11:11 | sparer | 1 | 48755 | 18 | 0.780 | 62506.4 |
559 | 2021-12-03 09:06:18 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
558 | 2021-12-02 22:32:46 | sparer | 1 | 48755 | 18 | 0.843 | 57835.1 |
557 | 2021-12-02 12:38:35 | sparer | 1 | 48755 | 18 | 1.173 | 41564.4 |
556 | 2021-11-28 23:28:39 | sparer | 1 | 48755 | 18 | 0.856 | 56956.8 |
555 | 2021-11-28 16:00:56 | sparer | 1 | 48755 | 18 | 1.093 | 44606.6 |
554 | 2021-11-28 03:03:02 | sparer | 1 | 48755 | 18 | 1.313 | 37132.5 |
553 | 2021-11-27 10:17:38 | sparer | 1 | 48755 | 18 | 0.780 | 62506.4 |
552 | 2021-11-27 01:46:20 | sparer | 1 | 48755 | 18 | 0.826 | 59025.4 |
551 | 2021-11-26 15:34:59 | sparer | 1 | 48755 | 18 | 0.813 | 59969.2 |
550 | 2021-11-25 09:24:35 | sparer | 1 | 48755 | 18 | 0.813 | 59969.2 |
549 | 2021-11-19 04:23:39 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |
548 | 2021-11-10 19:58:25 | sparer | 1 | 48755 | 18 | 0.766 | 63648.8 |
547 | 2021-11-10 06:39:49 | sparer | 1 | 48755 | 18 | 0.826 | 59025.4 |
546 | 2021-11-09 20:19:40 | sparer | 1 | 48755 | 18 | 0.750 | 65006.7 |