History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"asteroid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1027 | 2025-08-16 22:36:00 | asteroid | 1 | 82945 | 3 | 3.266 | 25396.5 |
1026 | 2025-08-15 05:13:31 | asteroid | 4 | 161609 | 716 | 51.236 | 3154.2 |
1025 | 2025-08-14 20:27:44 | asteroid | 4 | 161609 | 716 | 33.813 | 4779.5 |
1024 | 2025-08-13 17:49:45 | asteroid | 1 | 82945 | 3 | 8.780 | 9447.0 |
1023 | 2025-08-12 15:57:02 | asteroid | 4 | 161609 | 716 | 44.486 | 3632.8 |
1022 | 2025-08-12 12:24:23 | asteroid | 4 | 161609 | 716 | 33.310 | 4851.7 |
1021 | 2025-08-12 04:51:17 | asteroid | 4 | 161609 | 716 | 31.233 | 5174.3 |
1020 | 2025-08-12 02:24:04 | asteroid | 4 | 161609 | 716 | 40.973 | 3944.3 |
1019 | 2025-08-10 15:02:28 | asteroid | 4 | 161609 | 716 | 42.366 | 3814.6 |
1018 | 2025-08-10 02:40:54 | asteroid | 2 | 121059 | 11 | 11.550 | 10481.3 |
1017 | 2025-08-09 07:00:31 | asteroid | 1 | 82945 | 3 | 9.266 | 8951.5 |
1016 | 2025-08-09 03:22:51 | asteroid | 1 | 82945 | 3 | 1.483 | 55930.5 |
1015 | 2025-08-08 23:39:49 | asteroid | 1 | 82945 | 3 | 8.186 | 10132.5 |
1014 | 2025-08-07 21:18:20 | asteroid | 1 | 82945 | 3 | 1.500 | 55296.7 |
1013 | 2025-07-26 23:44:15 | asteroid | 3 | 146162 | 74 | 25.973 | 5627.5 |
1012 | 2025-07-26 22:27:42 | asteroid | 1 | 82945 | 3 | 4.233 | 19594.8 |
1011 | 2025-07-24 07:15:04 | asteroid | 1 | 82945 | 3 | 5.546 | 14955.8 |
1010 | 2025-07-21 16:48:44 | asteroid | 1 | 82945 | 3 | 1.470 | 56425.2 |
1009 | 2025-07-13 09:25:51 | asteroid | 3 | 146162 | 74 | 16.530 | 8842.2 |
1008 | 2025-07-13 09:23:35 | asteroid | 1 | 82945 | 3 | 3.500 | 23698.6 |
1007 | 2025-07-12 23:17:56 | asteroid | 1 | 82945 | 3 | 1.483 | 55930.5 |
1006 | 2025-07-11 08:55:02 | asteroid | 3 | 146162 | 74 | 50.076 | 2918.8 |
1005 | 2025-07-10 18:51:47 | asteroid | 1 | 82945 | 3 | 3.766 | 22024.7 |
1004 | 2025-07-10 05:17:12 | asteroid | 2 | 121059 | 11 | 16.250 | 7449.8 |
1003 | 2025-07-08 17:34:51 | asteroid | 3 | 146162 | 74 | 7.736 | 18893.7 |
1002 | 2025-07-06 12:43:36 | asteroid | 3 | 146162 | 74 | 7.360 | 19859.0 |
1001 | 2025-07-06 09:07:27 | asteroid | 2 | 121059 | 11 | 23.830 | 5080.1 |
1000 | 2025-07-06 00:21:33 | asteroid | 4 | 161609 | 716 | 12.143 | 13308.8 |
999 | 2025-07-03 23:30:48 | asteroid | 1 | 82945 | 3 | 6.826 | 12151.3 |
998 | 2025-06-30 03:50:40 | asteroid | 1 | 82945 | 3 | 6.046 | 13719.0 |
997 | 2025-06-29 00:55:28 | asteroid | 1 | 82945 | 3 | 1.436 | 57761.1 |
996 | 2025-06-25 20:47:01 | asteroid | 4 | 161609 | 716 | 33.033 | 4892.4 |
995 | 2025-06-24 14:33:21 | asteroid | 4 | 161609 | 716 | 60.253 | 2682.2 |
994 | 2025-06-24 13:29:59 | asteroid | 4 | 161609 | 716 | 44.516 | 3630.4 |
993 | 2025-06-24 08:52:20 | asteroid | 4 | 161609 | 716 | 38.580 | 4188.9 |
992 | 2025-06-21 20:47:00 | asteroid | 4 | 161609 | 716 | 53.940 | 2996.1 |
991 | 2025-06-21 07:53:06 | asteroid | 1 | 82945 | 3 | 1.266 | 65517.4 |
990 | 2025-06-21 04:40:00 | asteroid | 1 | 82945 | 3 | 1.560 | 53169.9 |
989 | 2025-06-19 21:55:12 | asteroid | 1 | 82945 | 3 | 4.686 | 17700.6 |
988 | 2025-06-16 06:45:51 | asteroid | 1 | 82945 | 3 | 7.113 | 11661.0 |
987 | 2025-06-10 07:30:26 | asteroid | 1 | 82945 | 3 | 3.593 | 23085.2 |
986 | 2025-05-26 03:36:55 | asteroid | 1 | 82945 | 3 | 7.343 | 11295.8 |
985 | 2025-05-17 21:54:42 | asteroid | 1 | 82945 | 3 | 9.936 | 8347.9 |
984 | 2025-05-16 09:09:18 | asteroid | 4 | 161609 | 716 | 49.956 | 3235.0 |
983 | 2025-05-16 04:44:20 | asteroid | 1 | 82945 | 3 | 3.876 | 21399.6 |
982 | 2025-05-15 20:41:29 | asteroid | 4 | 161609 | 716 | 88.900 | 1817.9 |
981 | 2025-05-15 20:28:48 | asteroid | 4 | 161609 | 716 | 53.613 | 3014.4 |
980 | 2025-05-14 07:59:47 | asteroid | 2 | 121059 | 11 | 14.423 | 8393.5 |
979 | 2025-05-14 04:05:37 | asteroid | 4 | 161609 | 716 | 52.406 | 3083.8 |
978 | 2025-05-12 22:58:13 | asteroid | 1 | 82945 | 3 | 1.453 | 57085.3 |
977 | 2025-05-07 18:56:06 | asteroid | 3 | 146162 | 74 | 8.360 | 17483.5 |
976 | 2025-05-07 18:55:52 | asteroid | 1 | 82945 | 3 | 1.373 | 60411.5 |
975 | 2025-05-06 07:06:03 | asteroid | 1 | 82945 | 3 | 3.376 | 24569.0 |
974 | 2025-05-05 22:27:27 | asteroid | 3 | 146162 | 74 | 23.986 | 6093.6 |
973 | 2025-05-05 06:11:03 | asteroid | 1 | 82945 | 3 | 1.373 | 60411.5 |
972 | 2025-05-04 15:49:02 | asteroid | 2 | 121059 | 11 | 12.063 | 10035.6 |
971 | 2025-05-04 13:33:21 | asteroid | 3 | 146162 | 74 | 42.953 | 3402.8 |
970 | 2025-05-04 04:14:11 | asteroid | 3 | 146162 | 74 | 41.880 | 3490.0 |
969 | 2025-05-03 09:37:25 | asteroid | 3 | 146162 | 74 | 7.876 | 18557.9 |
968 | 2025-05-02 12:41:36 | asteroid | 3 | 146162 | 74 | 34.343 | 4255.9 |
967 | 2025-05-01 15:33:05 | asteroid | 3 | 146162 | 74 | 7.046 | 20744.0 |
966 | 2025-04-29 22:21:34 | asteroid | 3 | 146162 | 74 | 40.253 | 3631.1 |
965 | 2025-04-26 16:29:03 | asteroid | 3 | 146162 | 74 | 39.800 | 3672.4 |
964 | 2025-04-26 00:12:19 | asteroid | 2 | 121059 | 11 | 27.780 | 4357.8 |
963 | 2025-04-25 03:16:44 | asteroid | 1 | 82945 | 3 | 3.750 | 22118.7 |
962 | 2025-04-17 01:28:17 | asteroid | 1 | 82945 | 3 | 1.313 | 63172.1 |
961 | 2025-04-10 22:36:00 | asteroid | 1 | 82945 | 3 | 4.796 | 17294.6 |
960 | 2025-04-03 20:07:14 | asteroid | 3 | 146162 | 74 | 35.936 | 4067.3 |
959 | 2025-04-03 06:14:16 | asteroid | 1 | 82945 | 3 | 1.530 | 54212.4 |
958 | 2025-03-20 18:53:58 | asteroid | 3 | 146162 | 74 | 30.533 | 4787.0 |
957 | 2025-03-20 05:04:48 | asteroid | 1 | 82945 | 3 | 5.686 | 14587.6 |
956 | 2025-03-18 10:02:42 | asteroid | 3 | 146162 | 74 | 47.346 | 3087.1 |
955 | 2025-03-13 13:05:32 | asteroid | 1 | 82945 | 3 | 6.326 | 13111.8 |
954 | 2025-03-11 21:42:18 | asteroid | 1 | 82945 | 3 | 3.436 | 24140.0 |
953 | 2025-03-11 12:23:10 | asteroid | 3 | 146162 | 74 | 37.410 | 3907.0 |
952 | 2025-03-09 03:08:54 | asteroid | 3 | 146162 | 74 | 54.023 | 2705.6 |
951 | 2025-03-09 01:30:57 | asteroid | 3 | 146162 | 74 | 34.816 | 4198.1 |
950 | 2025-03-09 01:30:45 | asteroid | 2 | 121059 | 11 | 21.546 | 5618.6 |
949 | 2025-03-08 21:58:02 | asteroid | 3 | 146162 | 74 | 31.673 | 4614.7 |
948 | 2025-03-03 11:18:33 | asteroid | 1 | 82945 | 3 | 2.143 | 38705.1 |
947 | 2025-03-02 13:08:28 | asteroid | 1 | 82945 | 3 | 3.266 | 25396.5 |
946 | 2025-02-25 14:08:21 | asteroid | 3 | 146162 | 74 | 7.436 | 19656.0 |
945 | 2025-02-18 08:49:39 | asteroid | 2 | 121059 | 11 | 3.876 | 31233.0 |
944 | 2025-02-12 13:22:55 | asteroid | 2 | 121059 | 11 | 17.876 | 6772.2 |
943 | 2025-02-07 14:55:35 | asteroid | 3 | 146162 | 74 | 46.930 | 3114.5 |
942 | 2025-02-04 11:19:00 | asteroid | 2 | 121059 | 11 | 10.140 | 11938.8 |
941 | 2025-02-04 11:14:46 | asteroid | 1 | 82945 | 3 | 3.343 | 24811.5 |
940 | 2025-02-03 14:21:10 | asteroid | 3 | 146162 | 74 | 29.533 | 4949.1 |
939 | 2025-02-02 07:11:53 | asteroid | 3 | 146162 | 74 | 39.723 | 3679.5 |
938 | 2025-02-02 06:19:15 | asteroid | 4 | 161609 | 716 | 66.846 | 2417.6 |
937 | 2025-02-02 06:19:13 | asteroid | 3 | 146162 | 74 | 35.706 | 4093.5 |
936 | 2025-02-02 02:13:43 | asteroid | 4 | 161609 | 716 | 69.160 | 2336.7 |
935 | 2025-02-01 18:49:45 | asteroid | 4 | 161609 | 716 | 78.440 | 2060.3 |
934 | 2025-02-01 11:37:44 | asteroid | 4 | 161609 | 716 | 13.723 | 11776.5 |
933 | 2025-02-01 11:37:43 | asteroid | 3 | 146162 | 74 | 7.780 | 18786.9 |
932 | 2025-01-27 20:47:33 | asteroid | 1 | 82945 | 3 | 5.563 | 14910.1 |
931 | 2025-01-25 22:27:15 | asteroid | 1 | 82945 | 3 | 10.406 | 7970.9 |
930 | 2025-01-06 06:50:06 | asteroid | 2 | 121059 | 11 | 19.720 | 6138.9 |
929 | 2025-01-01 08:20:04 | asteroid | 1 | 82945 | 3 | 7.516 | 11035.8 |
928 | 2024-12-30 13:57:47 | asteroid | 2 | 121059 | 11 | 14.686 | 8243.2 |