History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"room"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1031 | 2025-04-15 19:25:47 | room | 2 | 29872 | 214 | 2.156 | 13855.3 |
1030 | 2025-04-15 15:42:02 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1029 | 2025-04-15 10:14:40 | room | 1 | 13983 | 17 | 0.780 | 17926.9 |
1028 | 2025-04-13 07:11:33 | room | 2 | 29872 | 214 | 0.876 | 34100.5 |
1027 | 2025-04-10 10:20:12 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1026 | 2025-04-07 18:32:35 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1025 | 2025-04-03 09:55:53 | room | 1 | 13983 | 17 | 0.843 | 16587.2 |
1024 | 2025-03-21 01:13:23 | room | 1 | 13983 | 17 | 0.966 | 14475.2 |
1023 | 2025-03-20 16:44:45 | room | 1 | 13983 | 17 | 1.500 | 9322.0 |
1022 | 2025-03-16 02:18:14 | room | 2 | 29872 | 214 | 7.096 | 4209.7 |
1021 | 2025-03-15 09:01:57 | room | 2 | 29872 | 214 | 6.893 | 4333.7 |
1020 | 2025-03-15 08:39:30 | room | 1 | 13983 | 17 | 0.610 | 22923.0 |
1019 | 2025-03-06 20:50:34 | room | 2 | 29872 | 214 | 3.843 | 7773.1 |
1018 | 2025-03-06 20:32:17 | room | 1 | 13983 | 17 | 0.216 | 64736.1 |
1017 | 2025-02-26 07:52:34 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1016 | 2025-02-25 06:53:54 | room | 2 | 29872 | 214 | 4.610 | 6479.8 |
1015 | 2025-02-25 05:45:48 | room | 2 | 29872 | 214 | 4.050 | 7375.8 |
1014 | 2025-02-25 05:29:45 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1013 | 2025-02-24 10:53:16 | room | 1 | 13983 | 17 | 0.626 | 22337.1 |
1012 | 2025-02-23 02:52:57 | room | 1 | 13983 | 17 | 0.593 | 23580.1 |
1011 | 2025-02-04 20:31:24 | room | 1 | 13983 | 17 | 1.280 | 10924.2 |
1010 | 2025-02-04 00:50:22 | room | 1 | 13983 | 17 | 1.483 | 9428.9 |
1009 | 2025-01-26 11:36:31 | room | 1 | 13983 | 17 | 0.236 | 59250.0 |
1008 | 2025-01-26 01:10:26 | room | 2 | 29872 | 214 | 4.516 | 6614.7 |
1007 | 2025-01-26 00:27:36 | room | 1 | 13983 | 17 | 0.266 | 52567.7 |
1006 | 2025-01-26 00:03:04 | room | 1 | 13983 | 17 | 0.233 | 60012.9 |
1005 | 2025-01-24 02:30:29 | room | 1 | 13983 | 17 | 0.890 | 15711.2 |
1004 | 2025-01-05 20:29:20 | room | 2 | 29872 | 214 | 4.373 | 6831.0 |
1003 | 2025-01-05 19:58:11 | room | 2 | 29872 | 214 | 1.986 | 15041.3 |
1002 | 2025-01-05 19:29:50 | room | 1 | 13983 | 17 | 1.470 | 9512.2 |
1001 | 2024-12-28 06:10:26 | room | 1 | 13983 | 17 | 1.640 | 8526.2 |
1000 | 2024-12-27 06:19:56 | room | 1 | 13983 | 17 | 0.216 | 64736.1 |
999 | 2024-12-26 23:15:05 | room | 2 | 29872 | 214 | 2.656 | 11247.0 |
998 | 2024-12-26 23:05:31 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
997 | 2024-12-25 01:08:47 | room | 1 | 13983 | 17 | 0.263 | 53167.3 |
996 | 2024-12-06 19:16:06 | room | 2 | 29872 | 214 | 0.906 | 32971.3 |
995 | 2024-12-06 15:00:09 | room | 2 | 29872 | 214 | 4.453 | 6708.3 |
994 | 2024-12-06 14:44:10 | room | 1 | 13983 | 17 | 1.046 | 13368.1 |
993 | 2024-11-27 01:50:18 | room | 1 | 13983 | 17 | 0.970 | 14415.5 |
992 | 2024-11-26 21:19:49 | room | 1 | 13983 | 17 | 0.266 | 52567.7 |
991 | 2024-11-24 23:19:57 | room | 1 | 13983 | 17 | 0.296 | 47239.9 |
990 | 2024-11-06 13:10:24 | room | 2 | 29872 | 214 | 5.000 | 5974.4 |
989 | 2024-11-06 12:45:13 | room | 1 | 13983 | 17 | 0.220 | 63559.1 |
988 | 2024-10-28 02:00:04 | room | 1 | 13983 | 17 | 0.233 | 60012.9 |
987 | 2024-10-27 23:59:22 | room | 2 | 29872 | 214 | 2.673 | 11175.5 |
986 | 2024-10-27 22:10:12 | room | 2 | 29872 | 214 | 6.906 | 4325.5 |
985 | 2024-10-27 21:21:47 | room | 1 | 13983 | 17 | 0.450 | 31073.3 |
984 | 2024-10-25 22:13:53 | room | 1 | 13983 | 17 | 0.686 | 20383.4 |
983 | 2024-10-22 10:16:11 | room | 1 | 13983 | 17 | 1.453 | 9623.5 |
982 | 2024-10-16 10:06:59 | room | 1 | 13983 | 17 | 0.280 | 49939.3 |
981 | 2024-10-11 14:58:49 | room | 2 | 29872 | 214 | 2.216 | 13480.1 |
980 | 2024-10-11 14:58:48 | room | 1 | 13983 | 17 | 0.876 | 15962.3 |
979 | 2024-10-08 02:02:28 | room | 1 | 13983 | 17 | 2.736 | 5110.7 |
978 | 2024-10-07 13:28:15 | room | 2 | 29872 | 214 | 7.373 | 4051.5 |
977 | 2024-10-07 13:18:54 | room | 1 | 13983 | 17 | 0.890 | 15711.2 |
976 | 2024-09-28 16:31:25 | room | 2 | 29872 | 214 | 7.873 | 3794.2 |
975 | 2024-09-27 22:20:36 | room | 2 | 29872 | 214 | 7.813 | 3823.4 |
974 | 2024-09-27 21:32:45 | room | 1 | 13983 | 17 | 0.220 | 63559.1 |
973 | 2024-09-27 15:07:23 | room | 2 | 29872 | 214 | 4.220 | 7078.7 |
972 | 2024-09-27 15:03:33 | room | 1 | 13983 | 17 | 1.966 | 7112.4 |
971 | 2024-09-25 19:59:00 | room | 1 | 13983 | 17 | 2.343 | 5968.0 |
970 | 2024-09-21 05:20:36 | room | 1 | 13983 | 17 | 0.733 | 19076.4 |
969 | 2024-09-07 06:23:32 | room | 1 | 13983 | 17 | 1.796 | 7785.6 |
968 | 2024-08-30 05:49:25 | room | 1 | 13983 | 17 | 3.076 | 4545.8 |
967 | 2024-08-28 19:26:31 | room | 2 | 29872 | 214 | 8.733 | 3420.6 |
966 | 2024-08-28 17:31:29 | room | 1 | 13983 | 17 | 0.216 | 64736.1 |
965 | 2024-08-28 10:35:57 | room | 2 | 29872 | 214 | 6.736 | 4434.7 |
964 | 2024-08-28 09:41:19 | room | 1 | 13983 | 17 | 0.236 | 59250.0 |
963 | 2024-08-26 16:28:42 | room | 1 | 13983 | 17 | 2.876 | 4862.0 |
962 | 2024-08-23 09:44:22 | room | 1 | 13983 | 17 | 0.796 | 17566.6 |
961 | 2024-08-19 23:00:27 | room | 2 | 29872 | 214 | 5.546 | 5386.2 |
960 | 2024-08-10 04:56:33 | room | 1 | 13983 | 17 | 0.970 | 14415.5 |
959 | 2024-08-08 00:33:59 | room | 1 | 13983 | 17 | 0.593 | 23580.1 |
958 | 2024-08-07 11:01:32 | room | 2 | 29872 | 214 | 2.453 | 12177.7 |
957 | 2024-08-03 11:39:38 | room | 1 | 13983 | 17 | 0.313 | 44674.1 |
956 | 2024-08-02 11:07:32 | room | 2 | 29872 | 214 | 7.923 | 3770.3 |
955 | 2024-08-02 09:24:20 | room | 1 | 13983 | 17 | 0.263 | 53167.3 |
954 | 2024-07-29 15:20:07 | room | 1 | 13983 | 17 | 0.516 | 27098.8 |
953 | 2024-07-29 10:45:28 | room | 2 | 29872 | 214 | 1.610 | 18554.0 |
952 | 2024-07-29 09:32:49 | room | 1 | 13983 | 17 | 0.233 | 60012.9 |
951 | 2024-07-27 15:26:14 | room | 1 | 13983 | 17 | 1.673 | 8358.0 |
950 | 2024-07-26 22:16:19 | room | 1 | 13983 | 17 | 0.296 | 47239.9 |
949 | 2024-07-21 21:17:23 | room | 2 | 29872 | 214 | 4.093 | 7298.3 |
948 | 2024-07-17 06:16:26 | room | 1 | 13983 | 17 | 1.410 | 9917.0 |
947 | 2024-07-13 14:52:17 | room | 1 | 13983 | 17 | 0.673 | 20777.1 |
946 | 2024-07-08 08:20:42 | room | 1 | 13983 | 17 | 1.533 | 9121.3 |
945 | 2024-07-06 17:20:43 | room | 1 | 13983 | 17 | 0.953 | 14672.6 |
944 | 2024-07-06 14:57:39 | room | 1 | 13983 | 17 | 1.063 | 13154.3 |
943 | 2024-07-05 10:02:47 | room | 1 | 13983 | 17 | 0.593 | 23580.1 |
942 | 2024-07-03 05:08:52 | room | 1 | 13983 | 17 | 0.470 | 29751.1 |
941 | 2024-06-29 14:23:27 | room | 2 | 29872 | 214 | 2.876 | 10386.6 |
940 | 2024-06-29 13:12:44 | room | 1 | 13983 | 17 | 0.233 | 60012.9 |
939 | 2024-06-29 03:52:25 | room | 2 | 29872 | 214 | 4.296 | 6953.4 |
938 | 2024-06-29 03:47:27 | room | 1 | 13983 | 17 | 0.983 | 14224.8 |
937 | 2024-06-27 14:20:51 | room | 1 | 13983 | 17 | 0.920 | 15198.9 |
936 | 2024-06-21 09:46:47 | room | 1 | 13983 | 17 | 1.013 | 13803.6 |
935 | 2024-06-10 21:09:04 | room | 1 | 13983 | 17 | 0.670 | 20870.1 |
934 | 2024-06-04 23:20:13 | room | 2 | 29872 | 214 | 1.516 | 19704.5 |
933 | 2024-06-04 00:48:25 | room | 2 | 29872 | 214 | 3.390 | 8811.8 |
932 | 2024-06-03 21:45:53 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |