History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"advance"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
973 | 2024-04-25 02:32:52 | advance | 4 | 151207 | 815 | 21.893 | 6906.6 |
972 | 2024-04-15 13:01:02 | advance | 2 | 107671 | 10 | 8.016 | 13432.0 |
971 | 2024-04-15 12:58:40 | advance | 2 | 107671 | 10 | 9.733 | 11062.5 |
970 | 2024-04-13 02:32:11 | advance | 4 | 151207 | 815 | 16.660 | 9076.1 |
969 | 2024-04-12 02:39:16 | advance | 4 | 151207 | 815 | 15.953 | 9478.3 |
968 | 2024-04-11 02:22:37 | advance | 4 | 151207 | 815 | 14.266 | 10599.1 |
967 | 2024-04-10 02:29:09 | advance | 4 | 151207 | 815 | 14.173 | 10668.7 |
966 | 2024-04-09 02:15:37 | advance | 4 | 151207 | 815 | 16.876 | 8959.9 |
965 | 2024-04-08 10:15:14 | advance | 4 | 151207 | 815 | 27.970 | 5406.0 |
964 | 2024-04-08 02:12:51 | advance | 4 | 151207 | 815 | 19.190 | 7879.5 |
963 | 2024-04-07 17:25:02 | advance | 4 | 151207 | 815 | 42.846 | 3529.1 |
962 | 2024-04-07 02:15:28 | advance | 4 | 151207 | 815 | 24.280 | 6227.6 |
961 | 2024-04-06 02:08:48 | advance | 4 | 151207 | 815 | 42.190 | 3584.0 |
960 | 2024-04-06 00:03:26 | advance | 4 | 151207 | 815 | 30.096 | 5024.2 |
959 | 2024-04-05 17:03:59 | advance | 4 | 151207 | 815 | 11.563 | 13076.8 |
958 | 2024-04-05 02:14:07 | advance | 4 | 151207 | 815 | 19.033 | 7944.5 |
957 | 2024-04-04 02:10:58 | advance | 4 | 151207 | 815 | 23.576 | 6413.6 |
956 | 2024-04-04 00:04:40 | advance | 4 | 151207 | 815 | 27.096 | 5580.4 |
955 | 2024-04-03 05:07:24 | advance | 4 | 151207 | 815 | 32.500 | 4652.5 |
954 | 2024-04-03 02:16:28 | advance | 4 | 151207 | 815 | 10.843 | 13945.1 |
953 | 2024-04-02 00:59:33 | advance | 4 | 151207 | 815 | 9.703 | 15583.5 |
952 | 2024-04-01 00:53:07 | advance | 4 | 151207 | 815 | 38.640 | 3913.2 |
951 | 2024-03-31 00:57:08 | advance | 4 | 151207 | 815 | 23.936 | 6317.1 |
950 | 2024-03-30 00:56:24 | advance | 4 | 151207 | 815 | 33.640 | 4494.9 |
949 | 2024-03-29 00:58:04 | advance | 4 | 151207 | 815 | 37.486 | 4033.7 |
948 | 2024-03-28 00:59:14 | advance | 4 | 151207 | 815 | 28.066 | 5387.6 |
947 | 2024-03-27 00:51:51 | advance | 4 | 151207 | 815 | 13.173 | 11478.6 |
946 | 2024-03-26 01:53:34 | advance | 4 | 151207 | 815 | 22.250 | 6795.8 |
945 | 2024-03-25 02:24:25 | advance | 4 | 151207 | 815 | 11.766 | 12851.2 |
944 | 2024-03-24 01:44:53 | advance | 4 | 151207 | 815 | 9.796 | 15435.6 |
943 | 2024-03-23 01:39:11 | advance | 4 | 151207 | 815 | 31.970 | 4729.7 |
942 | 2024-03-22 01:49:30 | advance | 4 | 151207 | 815 | 39.113 | 3865.9 |
941 | 2024-03-21 01:51:17 | advance | 4 | 151207 | 815 | 29.190 | 5180.1 |
940 | 2024-03-20 01:40:15 | advance | 4 | 151207 | 815 | 12.220 | 12373.7 |
939 | 2024-03-19 01:42:20 | advance | 4 | 151207 | 815 | 22.156 | 6824.7 |
938 | 2024-03-18 01:20:59 | advance | 4 | 151207 | 815 | 14.610 | 10349.6 |
937 | 2024-03-17 01:28:36 | advance | 4 | 151207 | 815 | 14.550 | 10392.2 |
936 | 2024-03-16 01:08:48 | advance | 4 | 151207 | 815 | 34.080 | 4436.8 |
935 | 2024-03-15 01:03:55 | advance | 4 | 151207 | 815 | 36.876 | 4100.4 |
934 | 2024-03-14 01:14:58 | advance | 4 | 151207 | 815 | 14.406 | 10496.1 |
933 | 2024-03-08 00:51:10 | advance | 1 | 69583 | 4 | 3.283 | 21194.9 |
932 | 2024-03-06 23:29:18 | advance | 4 | 151207 | 815 | 27.830 | 5433.2 |
931 | 2024-03-06 17:25:35 | advance | 1 | 69583 | 4 | 3.470 | 20052.7 |
930 | 2024-03-06 14:50:58 | advance | 4 | 151207 | 815 | 14.923 | 10132.5 |
929 | 2024-03-05 09:24:35 | advance | 4 | 151207 | 815 | 24.113 | 6270.8 |
928 | 2024-03-04 20:33:04 | advance | 4 | 151207 | 815 | 17.393 | 8693.6 |
927 | 2024-03-04 16:29:07 | advance | 4 | 151207 | 815 | 33.156 | 4560.5 |
926 | 2024-03-04 04:11:04 | advance | 4 | 151207 | 815 | 33.720 | 4484.2 |
925 | 2024-03-03 16:51:57 | advance | 4 | 151207 | 815 | 12.096 | 12500.6 |
924 | 2024-03-03 05:26:01 | advance | 4 | 151207 | 815 | 21.890 | 6907.6 |
923 | 2024-03-02 21:02:20 | advance | 4 | 151207 | 815 | 10.203 | 14819.9 |
922 | 2024-02-29 20:09:26 | advance | 1 | 69583 | 4 | 1.250 | 55666.4 |
921 | 2024-02-25 23:05:16 | advance | 1 | 69583 | 4 | 1.606 | 43326.9 |
920 | 2024-02-09 21:27:09 | advance | 3 | 134027 | 92 | 12.593 | 10643.0 |
919 | 2024-02-06 10:34:38 | advance | 3 | 134027 | 92 | 5.923 | 22628.2 |
918 | 2024-02-05 12:43:00 | advance | 4 | 151207 | 815 | 40.770 | 3708.8 |
917 | 2024-02-03 04:51:14 | advance | 1 | 69583 | 4 | 2.703 | 25742.9 |
916 | 2024-01-29 06:03:54 | advance | 1 | 69583 | 4 | 1.123 | 61961.7 |
915 | 2024-01-27 10:19:05 | advance | 4 | 151207 | 815 | 12.533 | 12064.7 |
914 | 2024-01-27 08:37:43 | advance | 4 | 151207 | 815 | 11.156 | 13553.9 |
913 | 2024-01-27 08:37:39 | advance | 2 | 107671 | 10 | 3.390 | 31761.4 |
912 | 2024-01-27 08:37:27 | advance | 3 | 134027 | 92 | 6.360 | 21073.4 |
911 | 2024-01-14 14:48:38 | advance | 2 | 107671 | 10 | 3.063 | 35152.1 |
910 | 2024-01-14 14:48:32 | advance | 3 | 134027 | 92 | 6.376 | 21020.5 |
909 | 2024-01-02 12:21:32 | advance | 1 | 69583 | 4 | 1.140 | 61037.7 |
908 | 2023-12-13 13:00:46 | advance | 4 | 151207 | 815 | 13.780 | 10972.9 |
907 | 2023-12-12 21:03:24 | advance | 2 | 107671 | 10 | 3.140 | 34290.1 |
906 | 2023-11-25 05:24:54 | advance | 4 | 151207 | 815 | 13.156 | 11493.4 |
905 | 2023-11-24 10:01:58 | advance | 1 | 69583 | 4 | 1.060 | 65644.3 |
904 | 2023-11-21 11:01:20 | advance | 1 | 69583 | 4 | 1.063 | 65459.1 |
903 | 2023-11-17 16:21:49 | advance | 1 | 69583 | 4 | 1.156 | 60192.9 |
902 | 2023-11-17 06:52:00 | advance | 4 | 151207 | 815 | 9.703 | 15583.5 |
901 | 2023-11-16 01:07:53 | advance | 4 | 151207 | 815 | 13.643 | 11083.1 |
900 | 2023-10-30 05:35:57 | advance | 4 | 151207 | 815 | 10.500 | 14400.7 |
899 | 2023-10-24 01:25:49 | advance | 4 | 151207 | 815 | 11.140 | 13573.3 |
898 | 2023-10-20 02:41:57 | advance | 4 | 151207 | 815 | 9.580 | 15783.6 |
897 | 2023-10-18 20:21:59 | advance | 4 | 151207 | 815 | 9.673 | 15631.9 |
896 | 2023-10-06 09:08:21 | advance | 1 | 69583 | 4 | 1.250 | 55666.4 |
895 | 2023-09-15 12:32:40 | advance | 1 | 69583 | 4 | 1.080 | 64428.7 |
894 | 2023-09-13 13:33:17 | advance | 2 | 107671 | 10 | 2.780 | 38730.6 |
893 | 2023-09-11 20:46:26 | advance | 4 | 151207 | 815 | 11.393 | 13271.9 |
892 | 2023-09-09 17:16:27 | advance | 1 | 69583 | 4 | 1.050 | 66269.5 |
891 | 2023-09-06 12:23:02 | advance | 4 | 151207 | 815 | 9.453 | 15995.7 |
890 | 2023-08-20 22:10:19 | advance | 4 | 151207 | 815 | 12.610 | 11991.0 |
889 | 2023-08-17 17:14:56 | advance | 4 | 151207 | 815 | 9.906 | 15264.2 |
888 | 2023-07-24 11:57:24 | advance | 1 | 69583 | 4 | 1.203 | 57841.2 |
887 | 2023-06-12 01:06:49 | advance | 1 | 69583 | 4 | 1.046 | 66522.9 |
886 | 2023-06-02 11:11:22 | advance | 2 | 107671 | 10 | 2.706 | 39789.7 |
885 | 2023-04-30 17:49:16 | advance | 4 | 151207 | 815 | 10.203 | 14819.9 |
884 | 2023-04-20 08:02:02 | advance | 4 | 151207 | 815 | 9.436 | 16024.5 |
883 | 2023-04-01 15:21:37 | advance | 1 | 69583 | 4 | 1.046 | 66522.9 |
882 | 2023-03-28 23:36:25 | advance | 1 | 69583 | 4 | 1.046 | 66522.9 |
881 | 2023-03-08 07:20:20 | advance | 2 | 107671 | 10 | 2.733 | 39396.6 |
880 | 2023-02-06 12:16:02 | advance | 4 | 151207 | 815 | 11.843 | 12767.6 |
879 | 2023-01-11 22:46:48 | advance | 1 | 69583 | 4 | 1.046 | 66522.9 |
878 | 2022-12-15 19:46:29 | advance | 2 | 107671 | 10 | 3.046 | 35348.3 |
877 | 2022-12-07 02:31:45 | advance | 1 | 69583 | 4 | 1.220 | 57035.2 |
876 | 2022-11-20 07:12:31 | advance | 4 | 151207 | 815 | 9.360 | 16154.6 |
875 | 2022-10-18 05:11:30 | advance | 1 | 69583 | 4 | 1.060 | 65644.3 |
874 | 2022-08-23 20:01:21 | advance | 4 | 151207 | 815 | 10.610 | 14251.4 |