History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gunman"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
655 | 2024-04-27 11:42:24 | gunman | 1 | 48755 | 3 | 1.000 | 48755.0 |
654 | 2024-04-27 11:26:02 | gunman | 1 | 48755 | 3 | 1.190 | 40970.6 |
653 | 2024-04-27 11:25:36 | gunman | 1 | 48755 | 3 | 1.283 | 38000.8 |
652 | 2024-04-25 03:14:15 | gunman | 1 | 48755 | 3 | 3.390 | 14382.0 |
651 | 2024-04-08 07:18:50 | gunman | 3 | 112716 | 324 | 9.813 | 11486.4 |
650 | 2024-04-06 01:02:36 | gunman | 2 | 82551 | 22 | 5.796 | 14242.8 |
649 | 2024-04-06 01:02:10 | gunman | 1 | 48755 | 3 | 3.360 | 14510.4 |
648 | 2024-04-05 23:56:42 | gunman | 3 | 112716 | 324 | 14.643 | 7697.6 |
647 | 2024-04-05 10:36:37 | gunman | 2 | 82551 | 22 | 2.910 | 28368.0 |
646 | 2024-04-05 10:34:47 | gunman | 3 | 112716 | 324 | 12.813 | 8797.0 |
645 | 2024-04-05 10:34:46 | gunman | 2 | 82551 | 22 | 4.546 | 18159.0 |
644 | 2024-04-05 10:34:41 | gunman | 1 | 48755 | 3 | 0.970 | 50262.9 |
643 | 2024-04-05 10:34:23 | gunman | 3 | 112716 | 324 | 8.796 | 12814.5 |
642 | 2024-04-01 08:17:59 | gunman | 1 | 48755 | 3 | 0.936 | 52088.7 |
641 | 2024-03-31 18:05:29 | gunman | 3 | 112716 | 324 | 34.096 | 3305.8 |
640 | 2024-03-31 18:05:29 | gunman | 2 | 82551 | 22 | 9.266 | 8909.0 |
639 | 2024-03-31 18:04:45 | gunman | 1 | 48755 | 3 | 4.296 | 11348.9 |
638 | 2024-03-05 18:04:17 | gunman | 3 | 112716 | 324 | 19.613 | 5747.0 |
637 | 2024-03-05 09:47:14 | gunman | 3 | 112716 | 324 | 16.486 | 6837.1 |
636 | 2024-03-04 16:43:46 | gunman | 3 | 112716 | 324 | 14.810 | 7610.8 |
635 | 2024-03-04 16:43:49 | gunman | 2 | 82551 | 22 | 5.783 | 14274.8 |
634 | 2024-03-04 16:23:26 | gunman | 2 | 82551 | 22 | 6.796 | 12147.0 |
633 | 2024-03-04 16:23:27 | gunman | 1 | 48755 | 3 | 2.923 | 16679.8 |
632 | 2024-03-04 16:23:07 | gunman | 3 | 112716 | 324 | 6.156 | 18309.9 |
631 | 2024-03-04 07:57:32 | gunman | 3 | 112716 | 324 | 5.076 | 22205.7 |
630 | 2024-03-04 07:57:33 | gunman | 2 | 82551 | 22 | 2.453 | 33653.1 |
629 | 2024-03-04 07:57:30 | gunman | 1 | 48755 | 3 | 0.826 | 59025.4 |
628 | 2024-02-10 05:32:01 | gunman | 2 | 82551 | 22 | 8.253 | 10002.5 |
627 | 2024-01-03 22:10:35 | gunman | 2 | 82551 | 22 | 2.576 | 32046.2 |
626 | 2023-12-26 10:02:09 | gunman | 2 | 82551 | 22 | 2.406 | 34310.5 |
625 | 2023-12-21 12:17:46 | gunman | 1 | 48755 | 3 | 0.720 | 67715.3 |
624 | 2023-11-25 03:07:57 | gunman | 1 | 48755 | 3 | 0.750 | 65006.7 |
623 | 2023-11-24 10:20:01 | gunman | 1 | 48755 | 3 | 1.530 | 31866.0 |
622 | 2023-11-21 18:04:24 | gunman | 1 | 48755 | 3 | 0.733 | 66514.3 |
621 | 2023-11-12 21:39:08 | gunman | 2 | 82551 | 22 | 2.076 | 39764.5 |
620 | 2023-11-03 17:25:00 | gunman | 1 | 48755 | 3 | 0.813 | 59969.2 |
619 | 2023-10-18 21:32:23 | gunman | 1 | 48755 | 3 | 0.860 | 56691.9 |
618 | 2023-10-16 06:32:10 | gunman | 1 | 48755 | 3 | 0.826 | 59025.4 |
617 | 2023-10-08 01:22:24 | gunman | 1 | 48755 | 3 | 0.720 | 67715.3 |
616 | 2023-10-07 23:52:23 | gunman | 1 | 48755 | 3 | 1.533 | 31803.7 |
615 | 2023-09-26 13:12:51 | gunman | 1 | 48755 | 3 | 0.733 | 66514.3 |
614 | 2023-09-12 19:47:02 | gunman | 1 | 48755 | 3 | 0.810 | 60191.4 |
613 | 2023-08-15 07:58:24 | gunman | 2 | 82551 | 22 | 2.013 | 41008.9 |
612 | 2023-08-04 02:01:55 | gunman | 1 | 48755 | 3 | 0.766 | 63648.8 |
611 | 2023-07-31 18:52:34 | gunman | 1 | 48755 | 3 | 0.796 | 61250.0 |
610 | 2023-04-30 15:12:05 | gunman | 1 | 48755 | 3 | 0.733 | 66514.3 |
609 | 2023-04-29 11:14:55 | gunman | 2 | 82551 | 22 | 2.123 | 38884.1 |
608 | 2023-04-19 16:15:32 | gunman | 1 | 48755 | 3 | 0.843 | 57835.1 |
607 | 2023-02-21 10:49:18 | gunman | 1 | 48755 | 3 | 0.800 | 60943.8 |
606 | 2023-02-03 09:20:21 | gunman | 2 | 82551 | 22 | 2.046 | 40347.5 |
605 | 2023-01-11 00:15:57 | gunman | 1 | 48755 | 3 | 0.796 | 61250.0 |
604 | 2022-12-19 02:47:18 | gunman | 1 | 48755 | 3 | 0.813 | 59969.2 |
603 | 2022-11-16 09:45:02 | gunman | 2 | 82551 | 22 | 2.250 | 36689.3 |
602 | 2022-09-23 12:40:53 | gunman | 1 | 48755 | 3 | 0.826 | 59025.4 |
601 | 2022-09-17 19:41:47 | gunman | 1 | 48755 | 3 | 0.936 | 52088.7 |
600 | 2022-08-29 18:33:50 | gunman | 1 | 48755 | 3 | 0.720 | 67715.3 |
599 | 2022-06-25 21:55:44 | gunman | 1 | 48755 | 3 | 0.720 | 67715.3 |
598 | 2022-06-03 02:20:50 | gunman | 1 | 48755 | 3 | 0.750 | 65006.7 |
597 | 2022-05-08 20:27:15 | gunman | 2 | 82551 | 22 | 2.093 | 39441.5 |
596 | 2022-04-14 08:56:00 | gunman | 1 | 48755 | 3 | 1.063 | 45865.5 |
595 | 2022-04-12 04:07:59 | gunman | 1 | 48755 | 3 | 1.763 | 27654.6 |
594 | 2022-02-16 09:43:34 | gunman | 1 | 48755 | 3 | 0.750 | 65006.7 |
593 | 2022-01-10 03:39:49 | gunman | 1 | 48755 | 3 | 0.783 | 62266.9 |
592 | 2021-11-10 06:36:24 | gunman | 1 | 48755 | 3 | 0.813 | 59969.2 |
591 | 2021-11-08 10:16:38 | gunman | 1 | 48755 | 3 | 0.733 | 66514.3 |
590 | 2021-10-12 20:41:49 | gunman | 1 | 48755 | 3 | 0.720 | 67715.3 |
589 | 2021-10-11 23:56:19 | gunman | 1 | 48755 | 3 | 1.466 | 33257.2 |
588 | 2021-10-10 20:34:29 | gunman | 1 | 48755 | 3 | 0.750 | 65006.7 |
587 | 2021-10-02 04:01:07 | gunman | 1 | 48755 | 3 | 0.890 | 54780.9 |
586 | 2021-09-30 00:05:51 | gunman | 1 | 48755 | 3 | 0.720 | 67715.3 |
585 | 2021-09-21 09:23:58 | gunman | 1 | 48755 | 3 | 0.843 | 57835.1 |
584 | 2021-09-20 12:41:03 | gunman | 1 | 48755 | 3 | 0.830 | 58741.0 |
583 | 2021-09-13 18:59:07 | gunman | 1 | 48755 | 3 | 0.736 | 66243.2 |
582 | 2021-08-07 06:14:20 | gunman | 1 | 48755 | 3 | 0.733 | 66514.3 |
581 | 2021-08-05 07:55:01 | gunman | 1 | 48755 | 3 | 0.860 | 56691.9 |
580 | 2021-07-25 12:46:15 | gunman | 2 | 82551 | 22 | 2.106 | 39198.0 |
579 | 2021-05-31 15:18:25 | gunman | 1 | 48755 | 3 | 0.750 | 65006.7 |
578 | 2021-05-21 06:20:30 | gunman | 3 | 112716 | 324 | 5.063 | 22262.7 |
577 | 2021-05-15 21:26:01 | gunman | 2 | 82551 | 22 | 2.126 | 38829.3 |
576 | 2021-05-06 10:03:47 | gunman | 1 | 48755 | 3 | 0.750 | 65006.7 |
575 | 2021-05-01 05:00:47 | gunman | 1 | 48755 | 3 | 0.906 | 53813.5 |
574 | 2021-04-15 09:21:55 | gunman | 2 | 82551 | 22 | 2.440 | 33832.4 |
573 | 2021-04-11 13:05:33 | gunman | 3 | 112716 | 324 | 5.580 | 20200.0 |
572 | 2021-04-04 14:09:35 | gunman | 1 | 48755 | 3 | 0.750 | 65006.7 |
571 | 2021-02-21 12:11:35 | gunman | 2 | 82551 | 22 | 4.643 | 17779.7 |
570 | 2021-02-18 13:55:20 | gunman | 3 | 112716 | 324 | 5.576 | 20214.5 |
569 | 2021-01-28 18:11:07 | gunman | 1 | 48755 | 3 | 0.750 | 65006.7 |
568 | 2021-01-26 14:04:13 | gunman | 1 | 48755 | 3 | 0.733 | 66514.3 |
567 | 2021-01-19 23:08:11 | gunman | 1 | 48755 | 3 | 0.796 | 61250.0 |
566 | 2020-12-29 15:11:36 | gunman | 3 | 112716 | 324 | 4.513 | 24975.8 |
565 | 2020-11-16 22:19:49 | gunman | 1 | 48755 | 3 | 0.736 | 66243.2 |
564 | 2020-11-14 07:51:06 | gunman | 3 | 112716 | 324 | 5.000 | 22543.2 |
563 | 2020-11-08 08:35:51 | gunman | 1 | 48755 | 3 | 0.826 | 59025.4 |
562 | 2020-10-28 16:29:37 | gunman | 3 | 112716 | 324 | 5.390 | 20912.1 |
561 | 2020-10-25 22:36:03 | gunman | 1 | 48755 | 3 | 0.796 | 61250.0 |
560 | 2020-10-18 19:02:50 | gunman | 1 | 48755 | 3 | 0.843 | 57835.1 |
559 | 2020-10-14 13:32:48 | gunman | 3 | 112716 | 324 | 4.953 | 22757.1 |
558 | 2020-10-05 07:15:14 | gunman | 1 | 48755 | 3 | 0.750 | 65006.7 |
557 | 2020-09-22 08:04:23 | gunman | 3 | 112716 | 324 | 4.750 | 23729.7 |
556 | 2020-08-13 05:42:31 | gunman | 1 | 48755 | 3 | 0.843 | 57835.1 |