History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loofa"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1296 | 2024-05-01 23:11:11 | loofa | 2 | 53800 | 53 | 2.546 | 21131.2 |
| 1295 | 2024-05-01 23:11:07 | loofa | 3 | 83667 | 711 | 6.143 | 13619.9 |
| 1294 | 2024-05-01 23:11:04 | loofa | 1 | 28756 | 5 | 1.063 | 27051.7 |
| 1293 | 2024-05-01 23:11:03 | loofa | 1 | 28756 | 5 | 1.106 | 26000.0 |
| 1292 | 2024-05-01 23:10:56 | loofa | 2 | 53800 | 53 | 1.796 | 29955.5 |
| 1291 | 2024-05-01 23:10:52 | loofa | 3 | 83667 | 711 | 4.753 | 17603.0 |
| 1290 | 2024-05-01 02:33:28 | loofa | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 1289 | 2024-04-29 19:15:01 | loofa | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1288 | 2024-04-27 19:43:53 | loofa | 2 | 53800 | 53 | 1.686 | 31909.8 |
| 1287 | 2024-04-27 12:24:06 | loofa | 3 | 83667 | 711 | 4.233 | 19765.4 |
| 1286 | 2024-04-25 12:29:35 | loofa | 1 | 28756 | 5 | 1.173 | 24514.9 |
| 1285 | 2024-04-06 14:36:57 | loofa | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1284 | 2024-04-01 17:56:25 | loofa | 1 | 28756 | 5 | 1.500 | 19170.7 |
| 1283 | 2024-03-31 08:32:25 | loofa | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1282 | 2024-03-29 08:53:20 | loofa | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1281 | 2024-03-29 02:02:48 | loofa | 1 | 28756 | 5 | 1.813 | 15861.0 |
| 1280 | 2024-03-28 06:38:29 | loofa | 3 | 83667 | 711 | 3.406 | 24564.6 |
| 1279 | 2024-03-11 23:15:08 | loofa | 2 | 53800 | 53 | 3.466 | 15522.2 |
| 1278 | 2024-03-11 23:14:33 | loofa | 3 | 83667 | 711 | 4.923 | 16995.1 |
| 1277 | 2024-03-11 04:48:19 | loofa | 2 | 53800 | 53 | 3.796 | 14172.8 |
| 1276 | 2024-03-10 20:06:10 | loofa | 2 | 53800 | 53 | 3.890 | 13830.3 |
| 1275 | 2024-03-10 20:04:25 | loofa | 3 | 83667 | 711 | 4.093 | 20441.5 |
| 1274 | 2024-03-10 10:31:04 | loofa | 3 | 83667 | 711 | 14.033 | 5962.2 |
| 1273 | 2024-03-07 11:01:40 | loofa | 3 | 83667 | 711 | 11.093 | 7542.3 |
| 1272 | 2024-03-07 11:01:38 | loofa | 2 | 53800 | 53 | 1.906 | 28226.7 |
| 1271 | 2024-03-07 06:18:41 | loofa | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1270 | 2024-02-28 07:31:45 | loofa | 1 | 28756 | 5 | 1.046 | 27491.4 |
| 1269 | 2024-02-04 11:38:53 | loofa | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 1268 | 2024-02-03 23:20:47 | loofa | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1267 | 2024-01-29 02:38:13 | loofa | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1266 | 2023-12-29 22:09:28 | loofa | 3 | 83667 | 711 | 3.626 | 23074.2 |
| 1265 | 2023-12-29 22:09:30 | loofa | 2 | 53800 | 53 | 1.596 | 33709.3 |
| 1264 | 2023-12-28 13:28:23 | loofa | 3 | 83667 | 711 | 3.720 | 22491.1 |
| 1263 | 2023-12-28 13:28:22 | loofa | 2 | 53800 | 53 | 1.686 | 31909.8 |
| 1262 | 2023-11-29 01:41:45 | loofa | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1261 | 2023-11-13 23:09:12 | loofa | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1260 | 2023-11-13 16:06:47 | loofa | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1259 | 2023-11-03 06:59:00 | loofa | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1258 | 2023-11-02 09:45:45 | loofa | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1257 | 2023-10-20 06:50:07 | loofa | 1 | 28756 | 5 | 0.560 | 51350.0 |
| 1256 | 2023-10-20 03:29:29 | loofa | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1255 | 2023-10-16 05:03:56 | loofa | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 1254 | 2023-10-08 20:19:53 | loofa | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1253 | 2023-10-03 19:10:06 | loofa | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1252 | 2023-10-03 18:51:03 | loofa | 3 | 83667 | 711 | 3.436 | 24350.1 |
| 1251 | 2023-09-29 07:12:36 | loofa | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1250 | 2023-09-15 11:27:54 | loofa | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1249 | 2023-09-13 21:14:27 | loofa | 1 | 28756 | 5 | 1.123 | 25606.4 |
| 1248 | 2023-07-09 15:34:31 | loofa | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1247 | 2023-07-01 07:02:29 | loofa | 1 | 28756 | 5 | 0.450 | 63902.2 |
| 1246 | 2023-06-29 14:20:47 | loofa | 3 | 83667 | 711 | 3.296 | 25384.4 |
| 1245 | 2023-06-25 17:02:37 | loofa | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1244 | 2023-06-17 16:56:15 | loofa | 3 | 83667 | 711 | 3.453 | 24230.2 |
| 1243 | 2023-04-10 03:49:20 | loofa | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1242 | 2023-03-06 19:59:54 | loofa | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1241 | 2023-02-01 22:19:10 | loofa | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 1240 | 2023-01-24 11:27:38 | loofa | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1239 | 2023-01-24 10:30:23 | loofa | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1238 | 2022-11-30 07:20:14 | loofa | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1237 | 2022-11-11 02:08:26 | loofa | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1236 | 2022-07-26 09:45:07 | loofa | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 1235 | 2022-07-21 22:00:21 | loofa | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1234 | 2022-03-27 15:35:37 | loofa | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1233 | 2022-03-25 10:32:28 | loofa | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1232 | 2022-02-27 23:48:27 | loofa | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1231 | 2022-01-02 11:33:37 | loofa | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1230 | 2021-12-30 17:09:16 | loofa | 3 | 83667 | 711 | 3.810 | 21959.8 |
| 1229 | 2021-12-06 22:23:31 | loofa | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1228 | 2021-11-28 08:47:57 | loofa | 3 | 83667 | 711 | 3.750 | 22311.2 |
| 1227 | 2021-11-18 18:39:59 | loofa | 3 | 83667 | 711 | 4.030 | 20761.0 |
| 1226 | 2021-11-18 06:16:24 | loofa | 3 | 83667 | 711 | 3.813 | 21942.6 |
| 1225 | 2021-11-15 18:48:24 | loofa | 3 | 83667 | 711 | 5.296 | 15798.1 |
| 1224 | 2021-11-15 01:18:31 | loofa | 3 | 83667 | 711 | 3.360 | 24900.9 |
| 1223 | 2021-11-14 13:18:43 | loofa | 3 | 83667 | 711 | 3.516 | 23796.1 |
| 1222 | 2021-11-13 21:18:50 | loofa | 3 | 83667 | 711 | 4.780 | 17503.6 |
| 1221 | 2021-11-13 14:32:45 | loofa | 3 | 83667 | 711 | 3.890 | 21508.2 |
| 1220 | 2021-11-13 06:11:01 | loofa | 3 | 83667 | 711 | 3.390 | 24680.5 |
| 1219 | 2021-11-12 15:50:27 | loofa | 3 | 83667 | 711 | 3.406 | 24564.6 |
| 1218 | 2021-11-11 21:52:14 | loofa | 3 | 83667 | 711 | 3.843 | 21771.3 |
| 1217 | 2021-11-11 09:35:49 | loofa | 3 | 83667 | 711 | 3.780 | 22134.1 |
| 1216 | 2021-11-10 10:13:25 | loofa | 3 | 83667 | 711 | 3.986 | 20990.2 |
| 1215 | 2021-11-09 21:45:12 | loofa | 3 | 83667 | 711 | 4.080 | 20506.6 |
| 1214 | 2021-11-09 13:26:32 | loofa | 3 | 83667 | 711 | 3.360 | 24900.9 |
| 1213 | 2021-11-08 13:30:06 | loofa | 3 | 83667 | 711 | 3.250 | 25743.7 |
| 1212 | 2021-11-08 02:54:56 | loofa | 3 | 83667 | 711 | 3.406 | 24564.6 |
| 1211 | 2021-11-07 15:02:55 | loofa | 3 | 83667 | 711 | 3.720 | 22491.1 |
| 1210 | 2021-11-07 03:12:06 | loofa | 3 | 83667 | 711 | 4.500 | 18592.7 |
| 1209 | 2021-11-06 15:51:13 | loofa | 3 | 83667 | 711 | 3.546 | 23594.8 |
| 1208 | 2021-11-06 04:08:55 | loofa | 3 | 83667 | 711 | 3.513 | 23816.4 |
| 1207 | 2021-11-05 16:47:21 | loofa | 3 | 83667 | 711 | 3.750 | 22311.2 |
| 1206 | 2021-11-05 10:00:24 | loofa | 3 | 83667 | 711 | 3.533 | 23681.6 |
| 1205 | 2021-11-04 21:52:15 | loofa | 3 | 83667 | 711 | 3.970 | 21074.8 |
| 1204 | 2021-11-04 00:18:49 | loofa | 3 | 83667 | 711 | 3.250 | 25743.7 |
| 1203 | 2021-10-27 18:42:18 | loofa | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1202 | 2021-10-25 19:18:47 | loofa | 3 | 83667 | 711 | 4.080 | 20506.6 |
| 1201 | 2021-10-25 18:27:44 | loofa | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1200 | 2021-10-24 19:27:20 | loofa | 3 | 83667 | 711 | 3.970 | 21074.8 |
| 1199 | 2021-10-23 16:22:11 | loofa | 3 | 83667 | 711 | 3.593 | 23286.1 |
| 1198 | 2021-10-22 22:50:09 | loofa | 3 | 83667 | 711 | 3.516 | 23796.1 |
| 1197 | 2021-09-16 00:27:44 | loofa | 1 | 28756 | 5 | 0.483 | 59536.2 |