History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"floor"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
943 | 2024-04-29 10:36:16 | floor | 1 | 28756 | 5 | 0.533 | 53951.2 |
942 | 2024-04-20 04:03:41 | floor | 1 | 28756 | 5 | 2.156 | 13337.7 |
941 | 2024-04-17 21:35:11 | floor | 1 | 28756 | 5 | 1.860 | 15460.2 |
940 | 2024-04-13 04:42:23 | floor | 1 | 28756 | 5 | 0.470 | 61183.0 |
939 | 2024-04-06 13:43:10 | floor | 1 | 28756 | 5 | 0.436 | 65954.1 |
938 | 2024-03-28 19:56:09 | floor | 2 | 53800 | 76 | 1.546 | 34799.5 |
937 | 2024-03-28 19:56:05 | floor | 1 | 28756 | 5 | 0.470 | 61183.0 |
936 | 2024-03-28 19:55:37 | floor | 3 | 83667 | 883 | 3.736 | 22394.8 |
935 | 2024-03-28 19:47:14 | floor | 2 | 53800 | 76 | 5.580 | 9641.6 |
934 | 2024-03-28 19:47:15 | floor | 3 | 83667 | 883 | 4.750 | 17614.1 |
933 | 2024-03-28 19:29:22 | floor | 1 | 28756 | 5 | 0.546 | 52666.7 |
932 | 2024-03-25 13:16:09 | floor | 1 | 28756 | 5 | 0.453 | 63479.0 |
931 | 2024-03-17 19:38:56 | floor | 1 | 28756 | 5 | 0.516 | 55728.7 |
930 | 2024-03-07 11:02:09 | floor | 3 | 83667 | 883 | 12.266 | 6821.1 |
929 | 2024-03-07 11:02:09 | floor | 2 | 53800 | 76 | 5.513 | 9758.8 |
928 | 2024-03-07 06:55:00 | floor | 1 | 28756 | 5 | 1.500 | 19170.7 |
927 | 2024-02-29 21:33:25 | floor | 2 | 53800 | 76 | 1.516 | 35488.1 |
926 | 2024-02-29 21:33:02 | floor | 3 | 83667 | 883 | 4.140 | 20209.4 |
925 | 2024-02-27 09:39:48 | floor | 2 | 53800 | 76 | 1.733 | 31044.4 |
924 | 2024-02-27 09:39:19 | floor | 3 | 83667 | 883 | 4.283 | 19534.7 |
923 | 2024-02-25 22:26:12 | floor | 3 | 83667 | 883 | 8.063 | 10376.7 |
922 | 2024-02-25 22:26:13 | floor | 2 | 53800 | 76 | 3.516 | 15301.5 |
921 | 2024-02-25 19:19:02 | floor | 1 | 28756 | 5 | 0.500 | 57512.0 |
920 | 2024-02-14 16:52:38 | floor | 1 | 28756 | 5 | 0.453 | 63479.0 |
919 | 2024-02-03 18:40:35 | floor | 1 | 28756 | 5 | 0.483 | 59536.2 |
918 | 2024-01-30 19:13:32 | floor | 2 | 53800 | 76 | 1.643 | 32745.0 |
917 | 2024-01-26 13:24:33 | floor | 1 | 28756 | 5 | 0.970 | 29645.4 |
916 | 2024-01-20 23:52:49 | floor | 3 | 83667 | 883 | 3.216 | 26015.9 |
915 | 2024-01-14 23:42:17 | floor | 1 | 28756 | 5 | 0.516 | 55728.7 |
914 | 2023-12-29 00:55:37 | floor | 1 | 28756 | 5 | 0.436 | 65954.1 |
913 | 2023-12-07 01:07:39 | floor | 1 | 28756 | 5 | 0.450 | 63902.2 |
912 | 2023-12-05 20:39:09 | floor | 2 | 53800 | 76 | 1.450 | 37103.4 |
911 | 2023-12-05 20:39:06 | floor | 3 | 83667 | 883 | 3.673 | 22778.9 |
910 | 2023-12-01 00:42:34 | floor | 3 | 83667 | 883 | 3.580 | 23370.7 |
909 | 2023-11-22 21:22:56 | floor | 2 | 53800 | 76 | 3.250 | 16553.8 |
908 | 2023-11-21 01:25:30 | floor | 2 | 53800 | 76 | 1.393 | 38621.7 |
907 | 2023-11-17 12:19:40 | floor | 1 | 28756 | 5 | 0.453 | 63479.0 |
906 | 2023-11-10 13:11:16 | floor | 1 | 28756 | 5 | 0.470 | 61183.0 |
905 | 2023-11-09 04:08:15 | floor | 2 | 53800 | 76 | 1.326 | 40573.2 |
904 | 2023-11-08 11:52:47 | floor | 1 | 28756 | 5 | 0.450 | 63902.2 |
903 | 2023-11-01 23:12:47 | floor | 3 | 83667 | 883 | 3.910 | 21398.2 |
902 | 2023-11-01 23:12:42 | floor | 2 | 53800 | 76 | 3.060 | 17581.7 |
901 | 2023-10-28 03:10:10 | floor | 1 | 28756 | 5 | 0.516 | 55728.7 |
900 | 2023-10-20 21:50:53 | floor | 1 | 28756 | 5 | 0.516 | 55728.7 |
899 | 2023-10-18 01:55:19 | floor | 1 | 28756 | 5 | 0.453 | 63479.0 |
898 | 2023-10-17 13:56:44 | floor | 3 | 83667 | 883 | 3.263 | 25641.1 |
897 | 2023-10-17 13:56:42 | floor | 2 | 53800 | 76 | 1.343 | 40059.6 |
896 | 2023-10-17 06:25:59 | floor | 1 | 28756 | 5 | 0.436 | 65954.1 |
895 | 2023-10-11 00:13:05 | floor | 1 | 28756 | 5 | 0.420 | 68466.7 |
894 | 2023-10-04 13:50:52 | floor | 1 | 28756 | 5 | 0.456 | 63061.4 |
893 | 2023-10-04 06:52:33 | floor | 3 | 83667 | 883 | 3.780 | 22134.1 |
892 | 2023-10-04 00:30:10 | floor | 3 | 83667 | 883 | 8.780 | 9529.3 |
891 | 2023-10-01 02:24:41 | floor | 3 | 83667 | 883 | 3.233 | 25879.1 |
890 | 2023-09-29 11:54:30 | floor | 3 | 83667 | 883 | 7.720 | 10837.7 |
889 | 2023-09-25 06:39:39 | floor | 3 | 83667 | 883 | 3.300 | 25353.6 |
888 | 2023-09-25 06:39:37 | floor | 2 | 53800 | 76 | 1.356 | 39675.5 |
887 | 2023-09-22 02:37:18 | floor | 1 | 28756 | 5 | 0.436 | 65954.1 |
886 | 2023-09-19 13:29:45 | floor | 1 | 28756 | 5 | 0.500 | 57512.0 |
885 | 2023-08-17 21:44:25 | floor | 1 | 28756 | 5 | 0.436 | 65954.1 |
884 | 2023-08-14 22:06:31 | floor | 1 | 28756 | 5 | 0.453 | 63479.0 |
883 | 2023-08-13 14:35:15 | floor | 2 | 53800 | 76 | 1.326 | 40573.2 |
882 | 2023-05-13 01:53:05 | floor | 1 | 28756 | 5 | 0.453 | 63479.0 |
881 | 2023-05-03 15:40:27 | floor | 1 | 28756 | 5 | 0.420 | 68466.7 |
880 | 2023-05-02 04:55:10 | floor | 1 | 28756 | 5 | 0.423 | 67981.1 |
879 | 2023-04-25 12:43:22 | floor | 2 | 53800 | 76 | 1.313 | 40974.9 |
878 | 2023-03-26 13:31:06 | floor | 1 | 28756 | 5 | 0.423 | 67981.1 |
877 | 2023-03-11 15:42:50 | floor | 1 | 28756 | 5 | 0.500 | 57512.0 |
876 | 2023-01-31 10:49:19 | floor | 2 | 53800 | 76 | 1.500 | 35866.7 |
875 | 2023-01-25 02:10:56 | floor | 1 | 28756 | 5 | 0.483 | 59536.2 |
874 | 2023-01-01 11:58:16 | floor | 1 | 28756 | 5 | 0.483 | 59536.2 |
873 | 2022-11-12 18:29:53 | floor | 2 | 53800 | 76 | 1.326 | 40573.2 |
872 | 2022-10-10 18:52:38 | floor | 1 | 28756 | 5 | 0.423 | 67981.1 |
871 | 2022-09-21 05:02:08 | floor | 1 | 28756 | 5 | 0.466 | 61708.2 |
870 | 2022-06-24 03:39:02 | floor | 1 | 28756 | 5 | 0.436 | 65954.1 |
869 | 2022-05-16 07:26:51 | floor | 1 | 28756 | 5 | 0.440 | 65354.5 |
868 | 2022-05-15 05:56:01 | floor | 2 | 53800 | 76 | 1.420 | 37887.3 |
867 | 2022-05-02 01:46:50 | floor | 1 | 28756 | 5 | 0.423 | 67981.1 |
866 | 2022-04-29 20:27:08 | floor | 1 | 28756 | 5 | 0.420 | 68466.7 |
865 | 2022-03-08 02:27:50 | floor | 1 | 28756 | 5 | 0.686 | 41918.4 |
864 | 2022-01-16 18:52:04 | floor | 1 | 28756 | 5 | 0.580 | 49579.3 |
863 | 2022-01-14 14:34:26 | floor | 1 | 28756 | 5 | 0.530 | 54256.6 |
862 | 2022-01-12 14:06:27 | floor | 2 | 53800 | 76 | 1.406 | 38264.6 |
861 | 2021-12-01 03:45:57 | floor | 1 | 28756 | 5 | 0.456 | 63061.4 |
860 | 2021-11-27 16:30:42 | floor | 1 | 28756 | 5 | 0.423 | 67981.1 |
859 | 2021-11-10 12:38:24 | floor | 1 | 28756 | 5 | 0.500 | 57512.0 |
858 | 2021-11-08 10:29:07 | floor | 1 | 28756 | 5 | 0.456 | 63061.4 |
857 | 2021-11-06 09:52:28 | floor | 1 | 28756 | 5 | 0.456 | 63061.4 |
856 | 2021-08-24 20:43:34 | floor | 1 | 28756 | 5 | 0.420 | 68466.7 |
855 | 2021-06-23 23:09:38 | floor | 3 | 83667 | 883 | 3.936 | 21256.9 |
854 | 2021-06-05 19:38:56 | floor | 1 | 28756 | 5 | 0.483 | 59536.2 |
853 | 2021-05-24 21:53:11 | floor | 2 | 53800 | 76 | 1.843 | 29191.5 |
852 | 2021-05-20 19:39:47 | floor | 1 | 28756 | 5 | 0.513 | 56054.6 |
851 | 2021-05-11 19:33:54 | floor | 1 | 28756 | 5 | 0.436 | 65954.1 |
850 | 2021-04-28 07:46:46 | floor | 2 | 53800 | 76 | 1.500 | 35866.7 |
849 | 2021-04-10 13:39:44 | floor | 1 | 28756 | 5 | 0.563 | 51076.4 |
848 | 2021-03-28 04:20:57 | floor | 2 | 53800 | 76 | 1.530 | 35163.4 |
847 | 2021-02-18 07:08:46 | floor | 1 | 28756 | 5 | 0.483 | 59536.2 |
846 | 2021-01-24 22:50:44 | floor | 1 | 28756 | 5 | 0.453 | 63479.0 |
845 | 2021-01-11 11:29:24 | floor | 2 | 53800 | 76 | 1.343 | 40059.6 |
844 | 2021-01-11 02:47:20 | floor | 3 | 83667 | 883 | 3.250 | 25743.7 |