History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"store"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1338 | 2025-09-03 10:18:31 | store | 1 | 28756 | 24 | 0.513 | 56054.6 |
1337 | 2025-08-27 00:45:53 | store | 1 | 28756 | 24 | 0.516 | 55728.7 |
1336 | 2025-08-26 13:20:54 | store | 1 | 28756 | 24 | 1.233 | 23322.0 |
1335 | 2025-08-23 19:48:56 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1334 | 2025-08-10 04:54:45 | store | 1 | 28756 | 24 | 1.203 | 23903.6 |
1333 | 2025-08-05 08:15:28 | store | 2 | 53800 | 237 | 6.093 | 8829.8 |
1332 | 2025-08-05 00:25:41 | store | 2 | 53800 | 237 | 7.313 | 7356.8 |
1331 | 2025-08-04 07:08:43 | store | 2 | 53800 | 237 | 12.003 | 4482.2 |
1330 | 2025-08-01 19:15:40 | store | 1 | 28756 | 24 | 2.856 | 10068.6 |
1329 | 2025-08-01 06:00:05 | store | 2 | 53800 | 237 | 12.046 | 4466.2 |
1328 | 2025-08-01 05:26:15 | store | 1 | 28756 | 24 | 1.453 | 19790.8 |
1327 | 2025-08-01 03:53:58 | store | 1 | 28756 | 24 | 2.313 | 12432.3 |
1326 | 2025-07-29 18:36:01 | store | 2 | 53800 | 237 | 7.876 | 6830.9 |
1325 | 2025-07-28 17:51:42 | store | 1 | 28756 | 24 | 1.186 | 24246.2 |
1324 | 2025-07-27 20:02:56 | store | 2 | 53800 | 237 | 3.550 | 15154.9 |
1323 | 2025-07-27 03:04:46 | store | 1 | 28756 | 24 | 3.093 | 9297.1 |
1322 | 2025-07-23 07:38:53 | store | 1 | 28756 | 24 | 2.453 | 11722.8 |
1321 | 2025-07-23 06:53:10 | store | 1 | 28756 | 24 | 1.206 | 23844.1 |
1320 | 2025-07-22 19:14:38 | store | 2 | 53800 | 237 | 8.076 | 6661.7 |
1319 | 2025-07-22 15:04:29 | store | 1 | 28756 | 24 | 2.936 | 9794.3 |
1318 | 2025-07-22 12:42:05 | store | 1 | 28756 | 24 | 1.456 | 19750.0 |
1317 | 2025-07-22 12:18:39 | store | 1 | 28756 | 24 | 2.763 | 10407.5 |
1316 | 2025-07-21 23:33:03 | store | 2 | 53800 | 237 | 1.750 | 30742.9 |
1315 | 2025-07-15 11:53:35 | store | 2 | 53800 | 237 | 12.580 | 4276.6 |
1314 | 2025-07-14 17:47:52 | store | 1 | 28756 | 24 | 1.076 | 26724.9 |
1313 | 2025-07-13 15:39:37 | store | 1 | 28756 | 24 | 2.390 | 12031.8 |
1312 | 2025-07-11 16:02:27 | store | 2 | 53800 | 237 | 4.126 | 13039.3 |
1311 | 2025-07-10 10:38:59 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1310 | 2025-07-05 16:55:57 | store | 1 | 28756 | 24 | 1.280 | 22465.6 |
1309 | 2025-07-04 11:10:34 | store | 2 | 53800 | 237 | 8.436 | 6377.4 |
1308 | 2025-07-02 22:23:49 | store | 2 | 53800 | 237 | 4.966 | 10833.7 |
1307 | 2025-07-02 18:00:43 | store | 1 | 28756 | 24 | 2.343 | 12273.2 |
1306 | 2025-07-02 03:07:18 | store | 1 | 28756 | 24 | 1.033 | 27837.4 |
1305 | 2025-07-01 19:23:47 | store | 1 | 28756 | 24 | 2.123 | 13545.0 |
1304 | 2025-07-01 04:08:38 | store | 1 | 28756 | 24 | 0.546 | 52666.7 |
1303 | 2025-06-29 12:58:59 | store | 2 | 53800 | 237 | 4.546 | 11834.6 |
1302 | 2025-06-28 01:10:36 | store | 1 | 28756 | 24 | 3.170 | 9071.3 |
1301 | 2025-06-26 23:24:15 | store | 2 | 53800 | 237 | 7.233 | 7438.1 |
1300 | 2025-06-25 18:11:37 | store | 2 | 53800 | 237 | 1.500 | 35866.7 |
1299 | 2025-06-22 21:59:43 | store | 1 | 28756 | 24 | 0.516 | 55728.7 |
1298 | 2025-06-21 05:53:57 | store | 1 | 28756 | 24 | 0.516 | 55728.7 |
1297 | 2025-06-21 04:04:40 | store | 1 | 28756 | 24 | 2.593 | 11089.9 |
1296 | 2025-06-20 21:44:23 | store | 1 | 28756 | 24 | 2.140 | 13437.4 |
1295 | 2025-06-18 14:32:24 | store | 2 | 53800 | 237 | 8.796 | 6116.4 |
1294 | 2025-06-15 06:28:53 | store | 1 | 28756 | 24 | 0.453 | 63479.0 |
1293 | 2025-06-15 06:28:35 | store | 2 | 53800 | 237 | 1.673 | 32157.8 |
1292 | 2025-06-14 19:35:44 | store | 2 | 53800 | 237 | 4.000 | 13450.0 |
1291 | 2025-06-10 07:26:28 | store | 1 | 28756 | 24 | 2.530 | 11366.0 |
1290 | 2025-06-10 03:42:11 | store | 1 | 28756 | 24 | 1.096 | 26237.2 |
1289 | 2025-06-05 18:49:10 | store | 1 | 28756 | 24 | 0.470 | 61183.0 |
1288 | 2025-06-05 02:55:36 | store | 1 | 28756 | 24 | 2.376 | 12102.7 |
1287 | 2025-06-03 10:55:23 | store | 1 | 28756 | 24 | 1.813 | 15861.0 |
1286 | 2025-06-02 19:47:58 | store | 1 | 28756 | 24 | 0.483 | 59536.2 |
1285 | 2025-06-02 17:06:34 | store | 1 | 28756 | 24 | 1.640 | 17534.1 |
1284 | 2025-06-02 02:03:26 | store | 1 | 28756 | 24 | 2.800 | 10270.0 |
1283 | 2025-06-01 03:37:38 | store | 1 | 28756 | 24 | 2.266 | 12690.2 |
1282 | 2025-05-30 08:35:40 | store | 1 | 28756 | 24 | 2.033 | 14144.6 |
1281 | 2025-05-29 15:19:57 | store | 1 | 28756 | 24 | 1.736 | 16564.5 |
1280 | 2025-05-26 00:25:52 | store | 2 | 53800 | 237 | 4.453 | 12081.7 |
1279 | 2025-05-25 02:39:29 | store | 1 | 28756 | 24 | 0.516 | 55728.7 |
1278 | 2025-05-24 06:50:36 | store | 2 | 53800 | 237 | 8.403 | 6402.5 |
1277 | 2025-05-24 06:32:41 | store | 2 | 53800 | 237 | 3.953 | 13609.9 |
1276 | 2025-05-24 06:32:00 | store | 1 | 28756 | 24 | 1.986 | 14479.4 |
1275 | 2025-05-23 09:39:11 | store | 1 | 28756 | 24 | 3.076 | 9348.5 |
1274 | 2025-05-22 17:02:38 | store | 2 | 53800 | 237 | 6.046 | 8898.4 |
1273 | 2025-05-22 05:28:39 | store | 1 | 28756 | 24 | 2.233 | 12877.7 |
1272 | 2025-05-21 06:03:39 | store | 1 | 28756 | 24 | 1.356 | 21206.5 |
1271 | 2025-05-20 20:15:57 | store | 1 | 28756 | 24 | 0.533 | 53951.2 |
1270 | 2025-05-17 16:02:32 | store | 1 | 28756 | 24 | 0.516 | 55728.7 |
1269 | 2025-05-12 18:25:01 | store | 1 | 28756 | 24 | 0.500 | 57512.0 |
1268 | 2025-05-11 16:54:17 | store | 1 | 28756 | 24 | 1.030 | 27918.4 |
1267 | 2025-05-10 03:41:02 | store | 1 | 28756 | 24 | 2.233 | 12877.7 |
1266 | 2025-05-09 17:56:28 | store | 1 | 28756 | 24 | 0.466 | 61708.2 |
1265 | 2025-05-02 17:10:02 | store | 1 | 28756 | 24 | 1.343 | 21411.8 |
1264 | 2025-05-02 02:03:17 | store | 1 | 28756 | 24 | 2.343 | 12273.2 |
1263 | 2025-05-01 04:20:49 | store | 1 | 28756 | 24 | 4.173 | 6891.0 |
1262 | 2025-04-21 17:46:30 | store | 2 | 53800 | 237 | 11.223 | 4793.7 |
1261 | 2025-04-21 06:53:02 | store | 2 | 53800 | 237 | 7.783 | 6912.5 |
1260 | 2025-04-20 05:40:12 | store | 1 | 28756 | 24 | 2.390 | 12031.8 |
1259 | 2025-04-19 19:51:02 | store | 1 | 28756 | 24 | 0.533 | 53951.2 |
1258 | 2025-04-09 03:45:14 | store | 1 | 28756 | 24 | 2.420 | 11882.6 |
1257 | 2025-03-20 20:31:23 | store | 2 | 53800 | 237 | 2.436 | 22085.4 |
1256 | 2025-03-19 21:00:55 | store | 1 | 28756 | 24 | 1.720 | 16718.6 |
1255 | 2025-03-19 07:42:06 | store | 1 | 28756 | 24 | 0.513 | 56054.6 |
1254 | 2025-03-09 22:18:05 | store | 2 | 53800 | 237 | 5.626 | 9562.7 |
1253 | 2025-03-09 06:25:16 | store | 1 | 28756 | 24 | 1.373 | 20943.9 |
1252 | 2025-03-09 06:24:16 | store | 2 | 53800 | 237 | 8.096 | 6645.3 |
1251 | 2025-03-07 05:31:01 | store | 1 | 28756 | 24 | 2.190 | 13130.6 |
1250 | 2025-02-28 12:23:30 | store | 1 | 28756 | 24 | 2.453 | 11722.8 |
1249 | 2025-02-27 22:41:04 | store | 1 | 28756 | 24 | 3.843 | 7482.7 |
1248 | 2025-02-27 08:15:33 | store | 2 | 53800 | 237 | 8.570 | 6277.7 |
1247 | 2025-02-27 07:36:42 | store | 2 | 53800 | 237 | 12.453 | 4320.2 |
1246 | 2025-02-27 07:10:47 | store | 1 | 28756 | 24 | 0.470 | 61183.0 |
1245 | 2025-01-28 16:44:29 | store | 1 | 28756 | 24 | 0.530 | 54256.6 |
1244 | 2025-01-28 12:02:33 | store | 2 | 53800 | 237 | 11.906 | 4518.7 |
1243 | 2025-01-28 04:33:08 | store | 1 | 28756 | 24 | 2.360 | 12184.7 |
1242 | 2025-01-28 03:38:09 | store | 2 | 53800 | 237 | 7.970 | 6750.3 |
1241 | 2025-01-28 02:27:20 | store | 2 | 53800 | 237 | 6.483 | 8298.6 |
1240 | 2025-01-27 23:15:55 | store | 2 | 53800 | 237 | 6.140 | 8762.2 |
1239 | 2025-01-25 09:12:17 | store | 1 | 28756 | 24 | 2.013 | 14285.1 |