History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nationality"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 785 | 2025-11-15 17:11:34 | nationality | 1 | 49908 | 3 | 0.736 | 67809.8 |
| 784 | 2025-10-24 10:21:40 | nationality | 1 | 49908 | 3 | 0.843 | 59202.8 |
| 783 | 2025-10-24 01:19:08 | nationality | 1 | 49908 | 3 | 0.813 | 61387.5 |
| 782 | 2025-10-22 10:38:52 | nationality | 1 | 49908 | 3 | 4.280 | 11660.7 |
| 781 | 2025-10-22 10:03:38 | nationality | 1 | 49908 | 3 | 3.640 | 13711.0 |
| 780 | 2025-10-22 10:01:39 | nationality | 1 | 49908 | 3 | 3.610 | 13824.9 |
| 779 | 2025-10-21 14:37:28 | nationality | 1 | 49908 | 3 | 2.093 | 23845.2 |
| 778 | 2025-10-21 14:37:21 | nationality | 1 | 49908 | 3 | 3.096 | 16120.2 |
| 777 | 2025-09-26 18:58:38 | nationality | 1 | 49908 | 3 | 0.860 | 58032.6 |
| 776 | 2025-09-20 18:04:01 | nationality | 1 | 49908 | 3 | 1.483 | 33653.4 |
| 775 | 2025-08-21 09:38:50 | nationality | 2 | 86808 | 11 | 5.813 | 14933.4 |
| 774 | 2025-08-21 02:42:28 | nationality | 3 | 121633 | 34 | 23.470 | 5182.5 |
| 773 | 2025-08-13 02:35:46 | nationality | 2 | 86808 | 11 | 9.970 | 8706.9 |
| 772 | 2025-08-13 02:00:51 | nationality | 3 | 121633 | 34 | 12.783 | 9515.2 |
| 771 | 2025-08-12 01:48:34 | nationality | 1 | 49908 | 3 | 2.343 | 21300.9 |
| 770 | 2025-08-09 07:35:32 | nationality | 1 | 49908 | 3 | 2.953 | 16900.8 |
| 769 | 2025-08-09 06:22:05 | nationality | 1 | 49908 | 3 | 3.890 | 12829.8 |
| 768 | 2025-08-05 14:41:37 | nationality | 4 | 148819 | 95 | 43.266 | 3439.6 |
| 767 | 2025-08-05 14:38:43 | nationality | 3 | 121633 | 34 | 13.030 | 9334.8 |
| 766 | 2025-08-04 11:07:30 | nationality | 1 | 49908 | 3 | 2.000 | 24954.0 |
| 765 | 2025-08-04 07:53:16 | nationality | 1 | 49908 | 3 | 0.843 | 59202.8 |
| 764 | 2025-08-01 08:39:47 | nationality | 4 | 148819 | 95 | 36.316 | 4097.9 |
| 763 | 2025-08-01 07:46:56 | nationality | 3 | 121633 | 34 | 17.546 | 6932.2 |
| 762 | 2025-07-31 15:29:43 | nationality | 1 | 49908 | 3 | 0.906 | 55086.1 |
| 761 | 2025-07-14 21:13:28 | nationality | 3 | 121633 | 34 | 15.643 | 7775.6 |
| 760 | 2025-07-13 09:08:38 | nationality | 2 | 86808 | 11 | 2.406 | 36079.8 |
| 759 | 2025-07-12 19:41:52 | nationality | 1 | 49908 | 3 | 0.860 | 58032.6 |
| 758 | 2025-07-04 07:52:22 | nationality | 1 | 49908 | 3 | 5.216 | 9568.3 |
| 757 | 2025-07-02 07:29:15 | nationality | 1 | 49908 | 3 | 4.170 | 11968.3 |
| 756 | 2025-06-30 18:43:03 | nationality | 2 | 86808 | 11 | 6.046 | 14357.9 |
| 755 | 2025-06-29 14:03:06 | nationality | 1 | 49908 | 3 | 2.266 | 22024.7 |
| 754 | 2025-06-28 06:11:06 | nationality | 1 | 49908 | 3 | 3.940 | 12667.0 |
| 753 | 2025-06-24 10:41:40 | nationality | 1 | 49908 | 3 | 2.750 | 18148.4 |
| 752 | 2025-06-20 18:21:58 | nationality | 2 | 86808 | 11 | 11.956 | 7260.6 |
| 751 | 2025-06-14 09:08:50 | nationality | 1 | 49908 | 3 | 5.830 | 8560.5 |
| 750 | 2025-06-02 13:47:37 | nationality | 4 | 148819 | 95 | 40.940 | 3635.1 |
| 749 | 2025-05-31 05:40:48 | nationality | 1 | 49908 | 3 | 5.843 | 8541.5 |
| 748 | 2025-05-31 04:34:33 | nationality | 4 | 148819 | 95 | 48.816 | 3048.6 |
| 747 | 2025-05-29 03:32:49 | nationality | 1 | 49908 | 3 | 3.296 | 15142.0 |
| 746 | 2025-05-28 03:28:10 | nationality | 3 | 121633 | 34 | 5.203 | 23377.5 |
| 745 | 2025-05-25 14:35:00 | nationality | 1 | 49908 | 3 | 0.936 | 53320.5 |
| 744 | 2025-05-24 14:09:30 | nationality | 1 | 49908 | 3 | 4.280 | 11660.7 |
| 743 | 2025-05-23 12:37:43 | nationality | 4 | 148819 | 95 | 36.160 | 4115.6 |
| 742 | 2025-05-22 21:47:15 | nationality | 1 | 49908 | 3 | 0.906 | 55086.1 |
| 741 | 2025-05-22 07:45:28 | nationality | 1 | 49908 | 3 | 3.046 | 16384.8 |
| 740 | 2025-05-20 02:30:13 | nationality | 4 | 148819 | 95 | 37.170 | 4003.7 |
| 739 | 2025-05-19 05:14:37 | nationality | 1 | 49908 | 3 | 0.860 | 58032.6 |
| 738 | 2025-05-17 16:29:10 | nationality | 1 | 49908 | 3 | 0.763 | 65410.2 |
| 737 | 2025-05-16 09:36:11 | nationality | 4 | 148819 | 95 | 47.800 | 3113.4 |
| 736 | 2025-05-14 04:01:51 | nationality | 1 | 49908 | 3 | 4.860 | 10269.1 |
| 735 | 2025-05-11 17:56:03 | nationality | 1 | 49908 | 3 | 0.903 | 55269.1 |
| 734 | 2025-05-10 20:16:09 | nationality | 4 | 148819 | 95 | 57.363 | 2594.3 |
| 733 | 2025-05-09 23:34:43 | nationality | 4 | 148819 | 95 | 47.096 | 3159.9 |
| 732 | 2025-05-09 08:31:35 | nationality | 1 | 49908 | 3 | 1.780 | 28038.2 |
| 731 | 2025-04-23 13:24:48 | nationality | 1 | 49908 | 3 | 4.453 | 11207.7 |
| 730 | 2025-04-20 06:51:35 | nationality | 1 | 49908 | 3 | 4.266 | 11699.0 |
| 729 | 2025-04-08 23:44:42 | nationality | 4 | 148819 | 95 | 48.736 | 3053.6 |
| 728 | 2025-04-06 00:51:42 | nationality | 4 | 148819 | 95 | 26.953 | 5521.4 |
| 727 | 2025-04-02 14:10:56 | nationality | 4 | 148819 | 95 | 44.596 | 3337.0 |
| 726 | 2025-04-02 05:24:08 | nationality | 4 | 148819 | 95 | 54.346 | 2738.4 |
| 725 | 2025-03-30 21:40:48 | nationality | 4 | 148819 | 95 | 35.360 | 4208.7 |
| 724 | 2025-03-28 12:42:24 | nationality | 1 | 49908 | 3 | 2.796 | 17849.8 |
| 723 | 2025-03-26 07:11:29 | nationality | 4 | 148819 | 95 | 50.516 | 2946.0 |
| 722 | 2025-03-26 04:21:24 | nationality | 1 | 49908 | 3 | 4.036 | 12365.7 |
| 721 | 2025-03-10 01:32:28 | nationality | 2 | 86808 | 11 | 12.456 | 6969.2 |
| 720 | 2025-03-07 11:14:27 | nationality | 1 | 49908 | 3 | 2.376 | 21005.1 |
| 719 | 2025-03-06 12:51:29 | nationality | 4 | 148819 | 95 | 50.190 | 2965.1 |
| 718 | 2025-03-03 19:41:51 | nationality | 4 | 148819 | 95 | 51.783 | 2873.9 |
| 717 | 2025-03-01 21:28:26 | nationality | 3 | 121633 | 34 | 24.250 | 5015.8 |
| 716 | 2025-02-28 16:31:38 | nationality | 4 | 148819 | 95 | 63.490 | 2344.0 |
| 715 | 2025-02-28 06:40:26 | nationality | 4 | 148819 | 95 | 27.860 | 5341.7 |
| 714 | 2025-02-28 06:40:23 | nationality | 3 | 121633 | 34 | 12.190 | 9978.1 |
| 713 | 2025-02-21 20:21:04 | nationality | 3 | 121633 | 34 | 27.266 | 4461.0 |
| 712 | 2025-02-21 20:21:03 | nationality | 2 | 86808 | 11 | 11.626 | 7466.7 |
| 711 | 2025-02-21 12:27:20 | nationality | 4 | 148819 | 95 | 48.546 | 3065.5 |
| 710 | 2025-02-21 12:27:13 | nationality | 3 | 121633 | 34 | 31.846 | 3819.4 |
| 709 | 2025-02-21 12:27:13 | nationality | 2 | 86808 | 11 | 18.096 | 4797.1 |
| 708 | 2025-02-21 12:23:40 | nationality | 1 | 49908 | 3 | 4.093 | 12193.5 |
| 707 | 2025-02-08 08:43:45 | nationality | 1 | 49908 | 3 | 4.406 | 11327.3 |
| 706 | 2025-01-29 02:33:14 | nationality | 4 | 148819 | 95 | 59.113 | 2517.5 |
| 705 | 2025-01-26 05:53:12 | nationality | 1 | 49908 | 3 | 2.733 | 18261.3 |
| 704 | 2025-01-26 05:37:47 | nationality | 4 | 148819 | 95 | 44.750 | 3325.6 |
| 703 | 2025-01-24 09:28:14 | nationality | 4 | 148819 | 95 | 48.706 | 3055.5 |
| 702 | 2025-01-24 04:12:26 | nationality | 4 | 148819 | 95 | 47.063 | 3162.1 |
| 701 | 2025-01-23 03:10:59 | nationality | 1 | 49908 | 3 | 4.186 | 11922.6 |
| 700 | 2025-01-17 01:25:08 | nationality | 2 | 86808 | 11 | 11.453 | 7579.5 |
| 699 | 2025-01-17 01:20:16 | nationality | 1 | 49908 | 3 | 2.503 | 19939.3 |
| 698 | 2025-01-12 15:04:55 | nationality | 4 | 148819 | 95 | 47.970 | 3102.3 |
| 697 | 2024-12-25 04:05:12 | nationality | 1 | 49908 | 3 | 3.846 | 12976.6 |
| 696 | 2024-12-25 04:04:46 | nationality | 3 | 121633 | 34 | 24.423 | 4980.3 |
| 695 | 2024-12-25 04:04:44 | nationality | 2 | 86808 | 11 | 3.720 | 23335.5 |
| 694 | 2024-12-25 04:02:36 | nationality | 4 | 148819 | 95 | 54.816 | 2714.9 |
| 693 | 2024-12-24 13:19:12 | nationality | 4 | 148819 | 95 | 36.800 | 4044.0 |
| 692 | 2024-12-24 13:19:09 | nationality | 3 | 121633 | 34 | 27.626 | 4402.8 |
| 691 | 2024-12-24 03:39:46 | nationality | 4 | 148819 | 95 | 25.806 | 5766.8 |
| 690 | 2024-12-24 03:39:41 | nationality | 3 | 121633 | 34 | 18.326 | 6637.2 |
| 689 | 2024-12-23 14:07:06 | nationality | 4 | 148819 | 95 | 47.790 | 3114.0 |
| 688 | 2024-12-23 10:42:41 | nationality | 4 | 148819 | 95 | 57.753 | 2576.8 |
| 687 | 2024-12-23 10:43:19 | nationality | 2 | 86808 | 11 | 17.936 | 4839.9 |
| 686 | 2024-12-23 10:42:56 | nationality | 4 | 148819 | 95 | 38.863 | 3829.3 |