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 |
1114 | 2025-09-07 03:08:35 | room | 1 | 13983 | 17 | 0.233 | 60012.9 |
1113 | 2025-09-06 13:15:34 | room | 1 | 13983 | 17 | 0.266 | 52567.7 |
1112 | 2025-09-03 07:21:48 | room | 1 | 13983 | 17 | 0.263 | 53167.3 |
1111 | 2025-08-28 20:49:53 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1110 | 2025-08-28 00:36:07 | room | 1 | 13983 | 17 | 0.296 | 47239.9 |
1109 | 2025-08-20 18:32:59 | room | 1 | 13983 | 17 | 0.280 | 49939.3 |
1108 | 2025-08-18 15:10:23 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1107 | 2025-08-11 03:52:30 | room | 1 | 13983 | 17 | 1.156 | 12096.0 |
1106 | 2025-08-10 08:38:24 | room | 1 | 13983 | 17 | 0.546 | 25609.9 |
1105 | 2025-08-04 22:59:06 | room | 2 | 29872 | 214 | 4.063 | 7352.2 |
1104 | 2025-08-04 17:27:40 | room | 1 | 13983 | 17 | 1.453 | 9623.5 |
1103 | 2025-08-04 17:26:21 | room | 1 | 13983 | 17 | 1.110 | 12597.3 |
1102 | 2025-08-04 01:06:51 | room | 1 | 13983 | 17 | 0.796 | 17566.6 |
1101 | 2025-07-31 17:11:55 | room | 1 | 13983 | 17 | 1.673 | 8358.0 |
1100 | 2025-07-28 17:20:43 | room | 1 | 13983 | 17 | 1.360 | 10281.6 |
1099 | 2025-07-27 02:23:35 | room | 1 | 13983 | 17 | 0.950 | 14718.9 |
1098 | 2025-07-25 23:53:57 | room | 2 | 29872 | 214 | 2.423 | 12328.5 |
1097 | 2025-07-25 08:10:02 | room | 2 | 29872 | 214 | 2.063 | 14479.9 |
1096 | 2025-07-25 01:14:18 | room | 1 | 13983 | 17 | 0.690 | 20265.2 |
1095 | 2025-07-24 12:00:45 | room | 2 | 29872 | 214 | 3.640 | 8206.6 |
1094 | 2025-07-24 05:26:20 | room | 2 | 29872 | 214 | 4.313 | 6926.0 |
1093 | 2025-07-24 01:36:51 | room | 1 | 13983 | 17 | 1.330 | 10513.5 |
1092 | 2025-07-21 14:25:28 | room | 1 | 13983 | 17 | 0.266 | 52567.7 |
1091 | 2025-07-20 22:12:08 | room | 2 | 29872 | 214 | 0.970 | 30795.9 |
1090 | 2025-07-18 14:09:05 | room | 1 | 13983 | 17 | 2.356 | 5935.1 |
1089 | 2025-07-17 20:24:53 | room | 1 | 13983 | 17 | 0.720 | 19420.8 |
1088 | 2025-07-14 10:05:01 | room | 2 | 29872 | 214 | 4.216 | 7085.4 |
1087 | 2025-07-11 18:46:14 | room | 2 | 29872 | 214 | 2.190 | 13640.2 |
1086 | 2025-07-10 23:48:53 | room | 1 | 13983 | 17 | 0.293 | 47723.5 |
1085 | 2025-07-08 22:11:05 | room | 1 | 13983 | 17 | 1.780 | 7855.6 |
1084 | 2025-07-07 02:48:48 | room | 1 | 13983 | 17 | 1.253 | 11159.6 |
1083 | 2025-07-04 16:14:51 | room | 1 | 13983 | 17 | 0.500 | 27966.0 |
1082 | 2025-07-03 19:16:25 | room | 1 | 13983 | 17 | 0.236 | 59250.0 |
1081 | 2025-07-03 12:49:54 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1080 | 2025-07-02 09:43:15 | room | 1 | 13983 | 17 | 1.593 | 8777.8 |
1079 | 2025-07-02 01:13:08 | room | 1 | 13983 | 17 | 1.576 | 8872.5 |
1078 | 2025-07-01 12:19:43 | room | 1 | 13983 | 17 | 0.266 | 52567.7 |
1077 | 2025-06-30 18:44:06 | room | 1 | 13983 | 17 | 0.296 | 47239.9 |
1076 | 2025-06-30 13:21:24 | room | 1 | 13983 | 17 | 1.843 | 7587.1 |
1075 | 2025-06-29 10:23:11 | room | 1 | 13983 | 17 | 0.266 | 52567.7 |
1074 | 2025-06-28 16:35:14 | room | 1 | 13983 | 17 | 1.110 | 12597.3 |
1073 | 2025-06-28 13:32:25 | room | 1 | 13983 | 17 | 0.656 | 21315.5 |
1072 | 2025-06-27 17:43:08 | room | 1 | 13983 | 17 | 0.686 | 20383.4 |
1071 | 2025-06-24 05:51:31 | room | 1 | 13983 | 17 | 1.360 | 10281.6 |
1070 | 2025-06-23 20:05:43 | room | 2 | 29872 | 214 | 4.406 | 6779.8 |
1069 | 2025-06-22 00:33:06 | room | 2 | 29872 | 214 | 3.923 | 7614.6 |
1068 | 2025-06-20 23:48:59 | room | 1 | 13983 | 17 | 0.986 | 14181.5 |
1067 | 2025-06-15 20:11:09 | room | 1 | 13983 | 17 | 2.403 | 5819.0 |
1066 | 2025-06-12 04:26:04 | room | 1 | 13983 | 17 | 0.953 | 14672.6 |
1065 | 2025-06-08 08:02:25 | room | 1 | 13983 | 17 | 1.343 | 10411.8 |
1064 | 2025-06-07 02:50:00 | room | 1 | 13983 | 17 | 0.686 | 20383.4 |
1063 | 2025-06-02 15:23:44 | room | 1 | 13983 | 17 | 0.670 | 20870.1 |
1062 | 2025-06-02 00:13:06 | room | 1 | 13983 | 17 | 0.846 | 16528.4 |
1061 | 2025-06-01 00:59:05 | room | 2 | 29872 | 214 | 6.546 | 4563.4 |
1060 | 2025-05-31 23:17:03 | room | 1 | 13983 | 17 | 1.763 | 7931.4 |
1059 | 2025-05-30 09:08:49 | room | 2 | 29872 | 214 | 3.656 | 8170.7 |
1058 | 2025-05-29 15:58:30 | room | 1 | 13983 | 17 | 1.313 | 10649.7 |
1057 | 2025-05-28 20:22:29 | room | 1 | 13983 | 17 | 0.280 | 49939.3 |
1056 | 2025-05-28 16:34:50 | room | 2 | 29872 | 214 | 1.076 | 27762.1 |
1055 | 2025-05-28 09:23:21 | room | 1 | 13983 | 17 | 0.216 | 64736.1 |
1054 | 2025-05-26 23:56:58 | room | 2 | 29872 | 214 | 4.920 | 6071.5 |
1053 | 2025-05-25 14:54:07 | room | 1 | 13983 | 17 | 0.236 | 59250.0 |
1052 | 2025-05-24 01:13:30 | room | 1 | 13983 | 17 | 1.170 | 11951.3 |
1051 | 2025-05-23 19:32:42 | room | 2 | 29872 | 214 | 4.186 | 7136.2 |
1050 | 2025-05-22 19:04:20 | room | 2 | 29872 | 214 | 0.950 | 31444.2 |
1049 | 2025-05-20 23:50:14 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1048 | 2025-05-20 17:13:00 | room | 2 | 29872 | 214 | 6.656 | 4488.0 |
1047 | 2025-05-16 10:36:58 | room | 1 | 13983 | 17 | 1.186 | 11790.1 |
1046 | 2025-05-15 21:32:50 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1045 | 2025-05-12 05:52:55 | room | 1 | 13983 | 17 | 0.626 | 22337.1 |
1044 | 2025-05-10 09:33:39 | room | 2 | 29872 | 214 | 5.453 | 5478.1 |
1043 | 2025-05-09 11:28:36 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1042 | 2025-05-09 06:55:34 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1041 | 2025-05-05 02:34:23 | room | 1 | 13983 | 17 | 0.263 | 53167.3 |
1040 | 2025-05-02 10:17:09 | room | 2 | 29872 | 214 | 4.390 | 6804.6 |
1039 | 2025-05-01 08:44:19 | room | 2 | 29872 | 214 | 0.873 | 34217.6 |
1038 | 2025-04-30 15:24:01 | room | 1 | 13983 | 17 | 0.420 | 33292.9 |
1037 | 2025-04-30 01:32:13 | room | 2 | 29872 | 214 | 5.690 | 5249.9 |
1036 | 2025-04-30 00:23:07 | room | 1 | 13983 | 17 | 1.330 | 10513.5 |
1035 | 2025-04-29 12:06:09 | room | 2 | 29872 | 214 | 1.906 | 15672.6 |
1034 | 2025-04-28 16:06:46 | room | 1 | 13983 | 17 | 1.283 | 10898.7 |
1033 | 2025-04-27 14:41:30 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
1032 | 2025-04-19 18:49:56 | room | 1 | 13983 | 17 | 0.250 | 55932.0 |
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 |