History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nana"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
638 | 2024-04-27 10:07:22 | nana | 2 | 29872 | 255 | 0.920 | 32469.6 |
637 | 2024-04-24 10:54:48 | nana | 1 | 13983 | 14 | 0.580 | 24108.6 |
636 | 2024-04-24 05:11:10 | nana | 1 | 13983 | 14 | 0.280 | 49939.3 |
635 | 2024-04-20 15:30:48 | nana | 1 | 13983 | 14 | 0.813 | 17199.3 |
634 | 2024-04-13 14:54:03 | nana | 1 | 13983 | 14 | 0.236 | 59250.0 |
633 | 2024-04-13 14:23:29 | nana | 1 | 13983 | 14 | 0.310 | 45106.5 |
632 | 2024-04-13 14:06:52 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
631 | 2024-04-13 14:06:07 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
630 | 2024-04-04 22:41:21 | nana | 1 | 13983 | 14 | 0.860 | 16259.3 |
629 | 2024-04-02 18:45:35 | nana | 2 | 29872 | 255 | 1.033 | 28917.7 |
628 | 2024-04-02 18:36:12 | nana | 1 | 13983 | 14 | 0.470 | 29751.1 |
627 | 2024-03-30 20:40:31 | nana | 2 | 29872 | 255 | 1.046 | 28558.3 |
626 | 2024-03-30 20:35:44 | nana | 1 | 13983 | 14 | 0.266 | 52567.7 |
625 | 2024-03-29 07:27:22 | nana | 2 | 29872 | 255 | 2.063 | 14479.9 |
624 | 2024-03-29 04:49:57 | nana | 2 | 29872 | 255 | 0.983 | 30388.6 |
623 | 2024-03-28 19:50:31 | nana | 2 | 29872 | 255 | 3.063 | 9752.5 |
622 | 2024-03-28 19:25:20 | nana | 1 | 13983 | 14 | 0.266 | 52567.7 |
621 | 2024-03-28 04:23:18 | nana | 1 | 13983 | 14 | 0.206 | 67878.6 |
620 | 2024-03-05 19:45:11 | nana | 1 | 13983 | 14 | 0.826 | 16928.6 |
619 | 2024-02-26 08:41:49 | nana | 1 | 13983 | 14 | 0.203 | 68881.8 |
618 | 2024-02-03 00:46:42 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
617 | 2024-01-27 06:51:41 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
616 | 2024-01-04 21:37:08 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |
615 | 2023-12-24 02:23:08 | nana | 2 | 29872 | 255 | 0.780 | 38297.4 |
614 | 2023-12-16 13:39:35 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
613 | 2023-12-04 06:10:34 | nana | 2 | 29872 | 255 | 0.843 | 35435.3 |
612 | 2023-11-25 11:19:29 | nana | 2 | 29872 | 255 | 0.750 | 39829.3 |
611 | 2023-11-12 21:50:30 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
610 | 2023-11-09 14:32:26 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |
609 | 2023-11-07 11:03:08 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
608 | 2023-10-31 09:09:57 | nana | 2 | 29872 | 255 | 2.046 | 14600.2 |
607 | 2023-10-26 13:25:48 | nana | 2 | 29872 | 255 | 0.763 | 39150.7 |
606 | 2023-10-26 00:02:28 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
605 | 2023-10-24 18:04:18 | nana | 1 | 13983 | 14 | 0.216 | 64736.1 |
604 | 2023-10-24 11:01:49 | nana | 1 | 13983 | 14 | 0.280 | 49939.3 |
603 | 2023-10-20 04:48:39 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
602 | 2023-10-17 03:52:38 | nana | 1 | 13983 | 14 | 0.236 | 59250.0 |
601 | 2023-10-12 21:08:11 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
600 | 2023-10-03 20:29:53 | nana | 1 | 13983 | 14 | 0.216 | 64736.1 |
599 | 2023-10-01 01:45:28 | nana | 2 | 29872 | 255 | 0.953 | 31345.2 |
598 | 2023-09-28 01:37:44 | nana | 2 | 29872 | 255 | 0.890 | 33564.0 |
597 | 2023-09-22 16:58:53 | nana | 1 | 13983 | 14 | 0.216 | 64736.1 |
596 | 2023-09-21 19:37:22 | nana | 1 | 13983 | 14 | 0.233 | 60012.9 |
595 | 2023-09-02 00:34:54 | nana | 2 | 29872 | 255 | 0.893 | 33451.3 |
594 | 2023-08-23 16:05:26 | nana | 1 | 13983 | 14 | 0.236 | 59250.0 |
593 | 2023-08-21 12:08:44 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
592 | 2023-07-16 04:03:07 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |
591 | 2023-05-19 11:31:40 | nana | 1 | 13983 | 14 | 0.203 | 68881.8 |
590 | 2023-05-17 03:32:38 | nana | 2 | 29872 | 255 | 0.780 | 38297.4 |
589 | 2023-05-13 14:08:31 | nana | 1 | 13983 | 14 | 0.216 | 64736.1 |
588 | 2023-03-27 13:18:13 | nana | 1 | 13983 | 14 | 0.203 | 68881.8 |
587 | 2023-03-27 12:58:02 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |
586 | 2023-03-15 04:22:17 | nana | 1 | 13983 | 14 | 0.203 | 68881.8 |
585 | 2023-02-25 02:33:36 | nana | 2 | 29872 | 255 | 0.826 | 36164.6 |
584 | 2023-01-31 06:21:15 | nana | 1 | 13983 | 14 | 0.203 | 68881.8 |
583 | 2023-01-03 19:15:09 | nana | 1 | 13983 | 14 | 0.203 | 68881.8 |
582 | 2022-12-05 19:24:19 | nana | 2 | 29872 | 255 | 0.736 | 40587.0 |
581 | 2022-11-26 10:58:08 | nana | 1 | 13983 | 14 | 0.200 | 69915.0 |
580 | 2022-10-17 05:46:08 | nana | 1 | 13983 | 14 | 0.203 | 68881.8 |
579 | 2022-09-26 10:30:49 | nana | 1 | 13983 | 14 | 0.203 | 68881.8 |
578 | 2022-07-09 08:02:25 | nana | 1 | 13983 | 14 | 0.233 | 60012.9 |
577 | 2022-05-09 18:16:25 | nana | 1 | 13983 | 14 | 0.233 | 60012.9 |
576 | 2022-05-07 14:49:53 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |
575 | 2022-04-09 22:34:28 | nana | 2 | 29872 | 255 | 0.750 | 39829.3 |
574 | 2022-03-24 06:08:15 | nana | 1 | 13983 | 14 | 0.203 | 68881.8 |
573 | 2022-01-24 10:20:02 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
572 | 2022-01-22 06:52:16 | nana | 1 | 13983 | 14 | 0.216 | 64736.1 |
571 | 2022-01-20 02:07:23 | nana | 1 | 13983 | 14 | 0.423 | 33056.7 |
570 | 2021-12-10 04:53:59 | nana | 1 | 13983 | 14 | 0.216 | 64736.1 |
569 | 2021-12-06 22:10:04 | nana | 1 | 13983 | 14 | 0.233 | 60012.9 |
568 | 2021-12-02 06:16:41 | nana | 1 | 13983 | 14 | 0.236 | 59250.0 |
567 | 2021-11-15 18:20:48 | nana | 1 | 13983 | 14 | 0.233 | 60012.9 |
566 | 2021-11-15 10:42:02 | nana | 1 | 13983 | 14 | 0.313 | 44674.1 |
565 | 2021-10-03 11:55:43 | nana | 1 | 13983 | 14 | 0.233 | 60012.9 |
564 | 2021-10-01 08:55:31 | nana | 1 | 13983 | 14 | 0.203 | 68881.8 |
563 | 2021-09-02 20:30:36 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
562 | 2021-08-25 13:14:15 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |
561 | 2021-08-21 04:14:09 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
560 | 2021-07-22 10:09:58 | nana | 1 | 13983 | 14 | 0.393 | 35580.2 |
559 | 2021-06-28 20:22:13 | nana | 1 | 13983 | 14 | 0.483 | 28950.3 |
558 | 2021-05-29 20:47:57 | nana | 1 | 13983 | 14 | 0.233 | 60012.9 |
557 | 2021-04-24 22:24:14 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
556 | 2021-03-14 21:58:41 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
555 | 2021-02-27 04:19:57 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |
554 | 2020-11-29 23:45:38 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |
553 | 2020-11-27 06:27:07 | nana | 1 | 13983 | 14 | 0.216 | 64736.1 |
552 | 2020-10-24 23:59:33 | nana | 1 | 13983 | 14 | 0.263 | 53167.3 |
551 | 2020-10-20 15:51:39 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
550 | 2020-08-27 10:46:10 | nana | 1 | 13983 | 14 | 0.236 | 59250.0 |
549 | 2020-08-21 08:47:04 | nana | 1 | 13983 | 14 | 0.263 | 53167.3 |
548 | 2020-08-09 03:14:50 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
547 | 2020-08-07 06:13:36 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |
546 | 2020-08-05 21:47:28 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |
545 | 2020-08-04 23:40:48 | nana | 1 | 13983 | 14 | 0.216 | 64736.1 |
544 | 2020-08-04 17:23:55 | nana | 1 | 13983 | 14 | 0.233 | 60012.9 |
543 | 2020-07-28 05:56:24 | nana | 1 | 13983 | 14 | 0.233 | 60012.9 |
542 | 2020-07-28 04:44:28 | nana | 1 | 13983 | 14 | 0.250 | 55932.0 |
541 | 2020-07-20 11:03:10 | nana | 1 | 13983 | 14 | 0.233 | 60012.9 |
540 | 2020-05-20 01:03:54 | nana | 1 | 13983 | 14 | 0.216 | 64736.1 |
539 | 2020-05-15 05:17:26 | nana | 1 | 13983 | 14 | 0.220 | 63559.1 |