History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scotia"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 909 | 2025-12-08 16:25:20 | scotia | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 908 | 2025-12-07 04:50:51 | scotia | 2 | 82551 | 21 | 4.923 | 16768.4 |
| 907 | 2025-12-06 23:01:46 | scotia | 3 | 112716 | 361 | 5.623 | 20045.5 |
| 906 | 2025-11-27 21:36:03 | scotia | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 905 | 2025-11-26 14:56:27 | scotia | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 904 | 2025-11-26 05:50:50 | scotia | 1 | 48755 | 3 | 4.483 | 10875.5 |
| 903 | 2025-11-25 08:37:27 | scotia | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 902 | 2025-11-24 13:17:00 | scotia | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 901 | 2025-11-20 21:50:36 | scotia | 1 | 48755 | 3 | 2.560 | 19044.9 |
| 900 | 2025-11-20 19:04:08 | scotia | 1 | 48755 | 3 | 2.390 | 20399.6 |
| 899 | 2025-11-17 17:41:12 | scotia | 3 | 112716 | 361 | 5.656 | 19928.6 |
| 898 | 2025-11-14 16:25:41 | scotia | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 897 | 2025-10-28 21:33:27 | scotia | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 896 | 2025-10-26 18:01:20 | scotia | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 895 | 2025-10-24 11:59:41 | scotia | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 894 | 2025-10-20 00:18:44 | scotia | 3 | 112716 | 361 | 29.110 | 3872.1 |
| 893 | 2025-10-13 22:09:26 | scotia | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 892 | 2025-10-06 21:46:59 | scotia | 3 | 112716 | 361 | 5.890 | 19136.8 |
| 891 | 2025-09-28 09:56:40 | scotia | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 890 | 2025-09-28 00:03:56 | scotia | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 889 | 2025-09-27 19:22:20 | scotia | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 888 | 2025-09-26 22:24:20 | scotia | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 887 | 2025-09-25 21:14:36 | scotia | 1 | 48755 | 3 | 3.330 | 14641.1 |
| 886 | 2025-09-25 05:08:05 | scotia | 1 | 48755 | 3 | 6.000 | 8125.8 |
| 885 | 2025-09-24 05:30:47 | scotia | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 884 | 2025-09-24 01:25:26 | scotia | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 883 | 2025-09-18 08:09:39 | scotia | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 882 | 2025-09-15 02:54:20 | scotia | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 881 | 2025-09-09 13:01:11 | scotia | 3 | 112716 | 361 | 5.500 | 20493.8 |
| 880 | 2025-09-06 19:10:26 | scotia | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 879 | 2025-09-01 23:32:03 | scotia | 3 | 112716 | 361 | 10.686 | 10548.0 |
| 878 | 2025-08-28 00:00:39 | scotia | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 877 | 2025-08-25 06:51:26 | scotia | 1 | 48755 | 3 | 3.486 | 13985.9 |
| 876 | 2025-08-25 04:41:24 | scotia | 1 | 48755 | 3 | 4.160 | 11720.0 |
| 875 | 2025-08-12 14:49:27 | scotia | 3 | 112716 | 361 | 13.420 | 8399.1 |
| 874 | 2025-08-11 11:51:09 | scotia | 1 | 48755 | 3 | 5.453 | 8940.9 |
| 873 | 2025-08-04 12:23:51 | scotia | 1 | 48755 | 3 | 1.983 | 24586.5 |
| 872 | 2025-08-01 04:44:12 | scotia | 1 | 48755 | 3 | 2.203 | 22131.2 |
| 871 | 2025-08-01 01:20:32 | scotia | 1 | 48755 | 3 | 3.906 | 12482.1 |
| 870 | 2025-07-27 20:53:01 | scotia | 3 | 112716 | 361 | 11.846 | 9515.1 |
| 869 | 2025-07-27 01:35:43 | scotia | 1 | 48755 | 3 | 2.156 | 22613.6 |
| 868 | 2025-07-26 21:16:06 | scotia | 2 | 82551 | 21 | 13.313 | 6200.8 |
| 867 | 2025-07-25 03:07:45 | scotia | 1 | 48755 | 3 | 3.750 | 13001.3 |
| 866 | 2025-07-25 00:02:41 | scotia | 1 | 48755 | 3 | 2.673 | 18239.8 |
| 865 | 2025-07-24 05:27:13 | scotia | 1 | 48755 | 3 | 3.483 | 13998.0 |
| 864 | 2025-07-23 19:07:41 | scotia | 3 | 112716 | 361 | 24.563 | 4588.9 |
| 863 | 2025-07-23 02:46:06 | scotia | 1 | 48755 | 3 | 3.466 | 14066.6 |
| 862 | 2025-07-22 05:02:43 | scotia | 3 | 112716 | 361 | 6.283 | 17939.8 |
| 861 | 2025-07-18 20:38:27 | scotia | 3 | 112716 | 361 | 33.496 | 3365.1 |
| 860 | 2025-07-14 05:07:05 | scotia | 3 | 112716 | 361 | 25.130 | 4485.3 |
| 859 | 2025-07-12 06:55:50 | scotia | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 858 | 2025-07-11 00:07:07 | scotia | 3 | 112716 | 361 | 42.143 | 2674.6 |
| 857 | 2025-07-11 00:03:23 | scotia | 2 | 82551 | 21 | 21.283 | 3878.7 |
| 856 | 2025-07-05 10:34:29 | scotia | 1 | 48755 | 3 | 5.986 | 8144.8 |
| 855 | 2025-07-03 18:56:03 | scotia | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 854 | 2025-07-03 11:40:27 | scotia | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 853 | 2025-06-27 00:42:13 | scotia | 1 | 48755 | 3 | 3.986 | 12231.6 |
| 852 | 2025-06-22 02:28:03 | scotia | 2 | 82551 | 21 | 19.160 | 4308.5 |
| 851 | 2025-06-20 06:18:34 | scotia | 1 | 48755 | 3 | 6.250 | 7800.8 |
| 850 | 2025-06-19 13:52:45 | scotia | 3 | 112716 | 361 | 9.483 | 11886.1 |
| 849 | 2025-06-17 14:07:41 | scotia | 3 | 112716 | 361 | 13.250 | 8506.9 |
| 848 | 2025-06-15 23:19:06 | scotia | 1 | 48755 | 3 | 5.720 | 8523.6 |
| 847 | 2025-06-14 07:24:22 | scotia | 1 | 48755 | 3 | 4.140 | 11776.6 |
| 846 | 2025-06-13 19:10:07 | scotia | 1 | 48755 | 3 | 1.780 | 27390.4 |
| 845 | 2025-06-04 09:28:40 | scotia | 1 | 48755 | 3 | 3.860 | 12630.8 |
| 844 | 2025-06-02 15:53:23 | scotia | 3 | 112716 | 361 | 26.516 | 4250.9 |
| 843 | 2025-06-02 11:52:26 | scotia | 1 | 48755 | 3 | 2.186 | 22303.3 |
| 842 | 2025-06-01 06:54:52 | scotia | 3 | 112716 | 361 | 28.096 | 4011.8 |
| 841 | 2025-05-26 00:42:02 | scotia | 1 | 48755 | 3 | 4.343 | 11226.1 |
| 840 | 2025-05-20 17:46:40 | scotia | 1 | 48755 | 3 | 4.296 | 11348.9 |
| 839 | 2025-05-20 04:57:07 | scotia | 1 | 48755 | 3 | 2.156 | 22613.6 |
| 838 | 2025-05-10 06:45:56 | scotia | 1 | 48755 | 3 | 3.810 | 12796.6 |
| 837 | 2025-05-02 20:03:05 | scotia | 3 | 112716 | 361 | 7.093 | 15891.2 |
| 836 | 2025-05-02 11:48:47 | scotia | 1 | 48755 | 3 | 2.250 | 21668.9 |
| 835 | 2025-05-02 02:29:49 | scotia | 2 | 82551 | 21 | 11.783 | 7005.9 |
| 834 | 2025-05-01 18:39:13 | scotia | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 833 | 2025-05-01 09:34:47 | scotia | 1 | 48755 | 3 | 2.093 | 23294.3 |
| 832 | 2025-05-01 01:43:43 | scotia | 1 | 48755 | 3 | 4.376 | 11141.5 |
| 831 | 2025-04-23 00:05:57 | scotia | 1 | 48755 | 3 | 4.283 | 11383.4 |
| 830 | 2025-04-20 04:14:26 | scotia | 1 | 48755 | 3 | 3.596 | 13558.1 |
| 829 | 2025-04-14 23:13:01 | scotia | 1 | 48755 | 3 | 3.970 | 12280.9 |
| 828 | 2025-04-09 12:48:07 | scotia | 3 | 112716 | 361 | 27.846 | 4047.8 |
| 827 | 2025-04-09 03:03:07 | scotia | 3 | 112716 | 361 | 23.770 | 4741.9 |
| 826 | 2025-04-07 18:13:22 | scotia | 3 | 112716 | 361 | 5.096 | 22118.5 |
| 825 | 2025-04-06 06:27:35 | scotia | 1 | 48755 | 3 | 5.940 | 8207.9 |
| 824 | 2025-03-31 14:35:06 | scotia | 1 | 48755 | 3 | 3.906 | 12482.1 |
| 823 | 2025-03-20 05:55:51 | scotia | 1 | 48755 | 3 | 3.220 | 15141.3 |
| 822 | 2025-03-18 00:55:45 | scotia | 1 | 48755 | 3 | 4.190 | 11636.0 |
| 821 | 2025-03-16 15:09:11 | scotia | 3 | 112716 | 361 | 14.186 | 7945.6 |
| 820 | 2025-03-15 09:04:52 | scotia | 3 | 112716 | 361 | 25.580 | 4406.4 |
| 819 | 2025-03-15 00:45:43 | scotia | 3 | 112716 | 361 | 44.346 | 2541.7 |
| 818 | 2025-03-12 19:01:58 | scotia | 3 | 112716 | 361 | 28.300 | 3982.9 |
| 817 | 2025-03-12 01:29:32 | scotia | 1 | 48755 | 3 | 3.920 | 12437.5 |
| 816 | 2025-03-07 01:55:01 | scotia | 1 | 48755 | 3 | 2.936 | 16605.9 |
| 815 | 2025-03-02 20:58:49 | scotia | 2 | 82551 | 21 | 2.326 | 35490.5 |
| 814 | 2025-03-02 20:58:27 | scotia | 3 | 112716 | 361 | 4.890 | 23050.3 |
| 813 | 2025-03-01 03:57:47 | scotia | 2 | 82551 | 21 | 14.516 | 5686.9 |
| 812 | 2025-02-28 17:17:15 | scotia | 3 | 112716 | 361 | 29.860 | 3774.8 |
| 811 | 2025-02-28 02:27:59 | scotia | 1 | 48755 | 3 | 1.296 | 37619.6 |
| 810 | 2025-02-27 19:42:13 | scotia | 3 | 112716 | 361 | 40.786 | 2763.6 |