History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"buses"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1234 | 2024-04-03 03:41:32 | buses | 1 | 28756 | 20 | 1.140 | 25224.6 |
| 1233 | 2024-03-31 07:26:22 | buses | 1 | 28756 | 20 | 0.440 | 65354.5 |
| 1232 | 2024-03-27 03:35:38 | buses | 1 | 28756 | 20 | 1.110 | 25906.3 |
| 1231 | 2024-03-24 02:49:28 | buses | 1 | 28756 | 20 | 1.063 | 27051.7 |
| 1230 | 2024-03-04 12:21:22 | buses | 1 | 28756 | 20 | 0.530 | 54256.6 |
| 1229 | 2024-03-03 21:41:24 | buses | 1 | 28756 | 20 | 0.516 | 55728.7 |
| 1228 | 2024-02-25 17:32:04 | buses | 1 | 28756 | 20 | 0.453 | 63479.0 |
| 1227 | 2024-02-02 20:48:03 | buses | 1 | 28756 | 20 | 0.483 | 59536.2 |
| 1226 | 2024-01-28 17:33:15 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1225 | 2024-01-26 08:14:49 | buses | 1 | 28756 | 20 | 0.486 | 59168.7 |
| 1224 | 2024-01-23 21:06:52 | buses | 1 | 28756 | 20 | 0.450 | 63902.2 |
| 1223 | 2024-01-17 01:54:52 | buses | 1 | 28756 | 20 | 0.453 | 63479.0 |
| 1222 | 2023-12-29 11:35:26 | buses | 2 | 53800 | 344 | 1.500 | 35866.7 |
| 1221 | 2023-12-26 04:06:45 | buses | 2 | 53800 | 344 | 1.343 | 40059.6 |
| 1220 | 2023-12-22 16:16:27 | buses | 1 | 28756 | 20 | 1.106 | 26000.0 |
| 1219 | 2023-12-18 19:24:56 | buses | 1 | 28756 | 20 | 0.470 | 61183.0 |
| 1218 | 2023-11-16 01:12:57 | buses | 2 | 53800 | 344 | 1.533 | 35094.6 |
| 1217 | 2023-11-14 02:37:22 | buses | 1 | 28756 | 20 | 0.470 | 61183.0 |
| 1216 | 2023-11-13 16:59:04 | buses | 1 | 28756 | 20 | 0.440 | 65354.5 |
| 1215 | 2023-11-13 00:46:46 | buses | 1 | 28756 | 20 | 0.470 | 61183.0 |
| 1214 | 2023-11-11 12:55:51 | buses | 1 | 28756 | 20 | 0.516 | 55728.7 |
| 1213 | 2023-10-28 04:35:40 | buses | 1 | 28756 | 20 | 0.453 | 63479.0 |
| 1212 | 2023-10-26 19:46:20 | buses | 2 | 53800 | 344 | 3.796 | 14172.8 |
| 1211 | 2023-10-25 22:41:13 | buses | 1 | 28756 | 20 | 0.483 | 59536.2 |
| 1210 | 2023-10-19 19:51:41 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1209 | 2023-10-18 16:48:59 | buses | 1 | 28756 | 20 | 0.516 | 55728.7 |
| 1208 | 2023-10-14 01:25:36 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1207 | 2023-10-04 16:54:23 | buses | 1 | 28756 | 20 | 0.420 | 68466.7 |
| 1206 | 2023-09-27 15:16:03 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1205 | 2023-09-11 19:00:04 | buses | 1 | 28756 | 20 | 0.513 | 56054.6 |
| 1204 | 2023-09-09 11:32:34 | buses | 1 | 28756 | 20 | 0.423 | 67981.1 |
| 1203 | 2023-09-01 10:55:14 | buses | 1 | 28756 | 20 | 0.733 | 39230.6 |
| 1202 | 2023-08-30 20:28:49 | buses | 1 | 28756 | 20 | 0.423 | 67981.1 |
| 1201 | 2023-08-02 11:41:19 | buses | 1 | 28756 | 20 | 0.440 | 65354.5 |
| 1200 | 2023-08-02 10:33:10 | buses | 1 | 28756 | 20 | 0.483 | 59536.2 |
| 1199 | 2023-06-05 14:57:12 | buses | 1 | 28756 | 20 | 0.483 | 59536.2 |
| 1198 | 2023-06-02 05:32:11 | buses | 1 | 28756 | 20 | 0.423 | 67981.1 |
| 1197 | 2023-03-25 17:22:50 | buses | 1 | 28756 | 20 | 0.453 | 63479.0 |
| 1196 | 2023-03-03 03:24:20 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1195 | 2023-01-10 00:32:09 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1194 | 2022-11-24 23:10:13 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1193 | 2022-10-16 16:14:51 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1192 | 2022-09-18 22:58:33 | buses | 1 | 28756 | 20 | 0.453 | 63479.0 |
| 1191 | 2022-08-31 12:31:33 | buses | 1 | 28756 | 20 | 0.483 | 59536.2 |
| 1190 | 2022-08-17 14:27:50 | buses | 1 | 28756 | 20 | 0.450 | 63902.2 |
| 1189 | 2022-08-14 15:00:54 | buses | 1 | 28756 | 20 | 0.513 | 56054.6 |
| 1188 | 2022-08-14 12:28:15 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1187 | 2022-08-07 18:37:48 | buses | 1 | 28756 | 20 | 0.440 | 65354.5 |
| 1186 | 2022-08-06 03:49:46 | buses | 1 | 28756 | 20 | 0.470 | 61183.0 |
| 1185 | 2022-06-07 14:09:47 | buses | 1 | 28756 | 20 | 0.440 | 65354.5 |
| 1184 | 2022-05-08 16:24:03 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1183 | 2022-03-15 13:07:05 | buses | 1 | 28756 | 20 | 0.486 | 59168.7 |
| 1182 | 2022-03-14 21:01:48 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1181 | 2022-03-13 21:06:03 | buses | 1 | 28756 | 20 | 0.606 | 47452.1 |
| 1180 | 2022-03-12 19:37:25 | buses | 1 | 28756 | 20 | 0.546 | 52666.7 |
| 1179 | 2022-03-01 15:48:46 | buses | 1 | 28756 | 20 | 0.656 | 43835.4 |
| 1178 | 2022-02-28 19:00:08 | buses | 1 | 28756 | 20 | 0.640 | 44931.3 |
| 1177 | 2022-02-27 22:41:41 | buses | 1 | 28756 | 20 | 0.483 | 59536.2 |
| 1176 | 2022-02-27 09:35:56 | buses | 1 | 28756 | 20 | 0.450 | 63902.2 |
| 1175 | 2022-02-26 11:27:59 | buses | 1 | 28756 | 20 | 0.453 | 63479.0 |
| 1174 | 2022-02-25 20:17:13 | buses | 1 | 28756 | 20 | 0.983 | 29253.3 |
| 1173 | 2022-02-25 11:21:02 | buses | 1 | 28756 | 20 | 0.593 | 48492.4 |
| 1172 | 2022-02-19 13:28:55 | buses | 1 | 28756 | 20 | 0.483 | 59536.2 |
| 1171 | 2022-02-17 09:43:35 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1170 | 2022-02-13 00:56:41 | buses | 1 | 28756 | 20 | 0.453 | 63479.0 |
| 1169 | 2022-02-12 12:27:21 | buses | 1 | 28756 | 20 | 0.470 | 61183.0 |
| 1168 | 2022-02-11 20:59:20 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1167 | 2022-02-03 17:40:44 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1166 | 2022-01-28 22:23:15 | buses | 1 | 28756 | 20 | 0.440 | 65354.5 |
| 1165 | 2022-01-28 04:22:10 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1164 | 2022-01-27 09:51:12 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1163 | 2022-01-26 22:05:05 | buses | 1 | 28756 | 20 | 0.513 | 56054.6 |
| 1162 | 2022-01-26 09:26:05 | buses | 1 | 28756 | 20 | 0.470 | 61183.0 |
| 1161 | 2022-01-25 09:19:20 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1160 | 2022-01-24 20:19:00 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1159 | 2022-01-24 00:39:14 | buses | 1 | 28756 | 20 | 0.453 | 63479.0 |
| 1158 | 2022-01-21 14:17:31 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1157 | 2022-01-21 02:36:32 | buses | 1 | 28756 | 20 | 0.560 | 51350.0 |
| 1156 | 2022-01-20 16:39:03 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1155 | 2022-01-20 06:43:56 | buses | 1 | 28756 | 20 | 0.470 | 61183.0 |
| 1154 | 2022-01-19 19:02:02 | buses | 1 | 28756 | 20 | 0.546 | 52666.7 |
| 1153 | 2022-01-19 06:48:26 | buses | 1 | 28756 | 20 | 0.486 | 59168.7 |
| 1152 | 2022-01-18 16:19:53 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1151 | 2022-01-17 22:46:59 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |
| 1150 | 2022-01-09 08:22:42 | buses | 1 | 28756 | 20 | 0.470 | 61183.0 |
| 1149 | 2022-01-08 16:33:02 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1148 | 2022-01-07 22:06:34 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1147 | 2022-01-07 10:20:58 | buses | 1 | 28756 | 20 | 0.513 | 56054.6 |
| 1146 | 2022-01-05 21:33:45 | buses | 1 | 28756 | 20 | 0.453 | 63479.0 |
| 1145 | 2022-01-05 12:07:11 | buses | 1 | 28756 | 20 | 0.953 | 30174.2 |
| 1144 | 2022-01-04 20:31:26 | buses | 1 | 28756 | 20 | 1.046 | 27491.4 |
| 1143 | 2021-12-23 23:58:01 | buses | 1 | 28756 | 20 | 1.626 | 17685.1 |
| 1142 | 2021-12-22 23:00:06 | buses | 1 | 28756 | 20 | 0.470 | 61183.0 |
| 1141 | 2021-12-21 23:51:48 | buses | 1 | 28756 | 20 | 0.516 | 55728.7 |
| 1140 | 2021-12-20 21:53:18 | buses | 1 | 28756 | 20 | 0.513 | 56054.6 |
| 1139 | 2021-12-14 04:38:27 | buses | 1 | 28756 | 20 | 0.500 | 57512.0 |
| 1138 | 2021-12-13 18:54:52 | buses | 1 | 28756 | 20 | 0.450 | 63902.2 |
| 1137 | 2021-12-13 10:01:39 | buses | 1 | 28756 | 20 | 0.516 | 55728.7 |
| 1136 | 2021-12-12 16:54:03 | buses | 1 | 28756 | 20 | 0.530 | 54256.6 |
| 1135 | 2021-12-12 05:05:31 | buses | 1 | 28756 | 20 | 0.436 | 65954.1 |