History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1337 | 2025-05-08 00:24:37 | pies | 1 | 13983 | 30 | 1.186 | 11790.1 |
1336 | 2025-05-07 02:45:55 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
1335 | 2025-05-04 03:53:32 | pies | 1 | 13983 | 30 | 1.390 | 10059.7 |
1334 | 2025-05-01 05:47:34 | pies | 2 | 29872 | 675 | 4.610 | 6479.8 |
1333 | 2025-05-01 05:34:19 | pies | 2 | 29872 | 675 | 3.030 | 9858.7 |
1332 | 2025-05-01 04:28:04 | pies | 2 | 29872 | 675 | 4.030 | 7412.4 |
1331 | 2025-04-30 17:33:05 | pies | 2 | 29872 | 675 | 2.203 | 13559.7 |
1330 | 2025-04-30 15:58:53 | pies | 1 | 13983 | 30 | 1.843 | 7587.1 |
1329 | 2025-04-30 14:13:03 | pies | 2 | 29872 | 675 | 4.033 | 7406.9 |
1328 | 2025-04-30 03:25:18 | pies | 2 | 29872 | 675 | 4.173 | 7158.4 |
1327 | 2025-04-29 14:16:15 | pies | 2 | 29872 | 675 | 4.496 | 6644.1 |
1326 | 2025-04-28 17:38:17 | pies | 1 | 13983 | 30 | 0.263 | 53167.3 |
1325 | 2025-04-28 13:07:09 | pies | 2 | 29872 | 675 | 5.610 | 5324.8 |
1324 | 2025-04-27 02:36:04 | pies | 1 | 13983 | 30 | 0.796 | 17566.6 |
1323 | 2025-04-27 02:06:15 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
1322 | 2025-04-27 01:52:28 | pies | 1 | 13983 | 30 | 0.216 | 64736.1 |
1321 | 2025-04-26 14:47:48 | pies | 1 | 13983 | 30 | 0.846 | 16528.4 |
1320 | 2025-04-25 05:35:03 | pies | 1 | 13983 | 30 | 0.656 | 21315.5 |
1319 | 2025-04-19 09:55:01 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
1318 | 2025-04-15 20:05:10 | pies | 1 | 13983 | 30 | 1.060 | 13191.5 |
1317 | 2025-04-13 12:33:58 | pies | 1 | 13983 | 30 | 0.280 | 49939.3 |
1316 | 2025-04-11 12:10:49 | pies | 1 | 13983 | 30 | 1.170 | 11951.3 |
1315 | 2025-04-07 02:06:54 | pies | 1 | 13983 | 30 | 0.983 | 14224.8 |
1314 | 2025-03-29 18:12:17 | pies | 1 | 13983 | 30 | 0.953 | 14672.6 |
1313 | 2025-03-27 08:09:18 | pies | 1 | 13983 | 30 | 1.813 | 7712.6 |
1312 | 2025-03-26 16:41:05 | pies | 1 | 13983 | 30 | 1.783 | 7842.4 |
1311 | 2025-03-18 17:43:20 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
1310 | 2025-03-16 02:08:12 | pies | 1 | 13983 | 30 | 1.623 | 8615.5 |
1309 | 2025-03-14 20:44:13 | pies | 1 | 13983 | 30 | 1.296 | 10789.4 |
1308 | 2025-03-07 02:02:22 | pies | 1 | 13983 | 30 | 1.343 | 10411.8 |
1307 | 2025-03-06 17:56:31 | pies | 1 | 13983 | 30 | 1.110 | 12597.3 |
1306 | 2025-03-06 00:53:16 | pies | 2 | 29872 | 675 | 2.610 | 11445.2 |
1305 | 2025-03-05 13:50:34 | pies | 2 | 29872 | 675 | 6.716 | 4447.9 |
1304 | 2025-03-05 13:37:03 | pies | 2 | 29872 | 675 | 3.810 | 7840.4 |
1303 | 2025-03-05 06:23:14 | pies | 1 | 13983 | 30 | 0.906 | 15433.8 |
1302 | 2025-02-28 04:16:18 | pies | 2 | 29872 | 675 | 4.313 | 6926.0 |
1301 | 2025-02-25 07:11:17 | pies | 2 | 29872 | 675 | 4.893 | 6105.0 |
1300 | 2025-02-25 04:31:59 | pies | 2 | 29872 | 675 | 4.330 | 6898.8 |
1299 | 2025-02-25 03:03:08 | pies | 2 | 29872 | 675 | 4.453 | 6708.3 |
1298 | 2025-02-25 02:53:00 | pies | 1 | 13983 | 30 | 0.686 | 20383.4 |
1297 | 2025-02-24 22:14:57 | pies | 1 | 13983 | 30 | 0.673 | 20777.1 |
1296 | 2025-02-23 18:57:35 | pies | 1 | 13983 | 30 | 1.110 | 12597.3 |
1295 | 2025-02-05 21:41:30 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
1294 | 2025-02-04 13:49:34 | pies | 1 | 13983 | 30 | 2.186 | 6396.6 |
1293 | 2025-01-26 00:10:02 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
1292 | 2025-01-25 19:42:55 | pies | 2 | 29872 | 675 | 2.970 | 10057.9 |
1291 | 2025-01-25 19:18:49 | pies | 2 | 29872 | 675 | 3.970 | 7524.4 |
1290 | 2025-01-25 19:05:10 | pies | 1 | 13983 | 30 | 0.516 | 27098.8 |
1289 | 2025-01-24 17:14:33 | pies | 1 | 13983 | 30 | 1.326 | 10545.2 |
1288 | 2025-01-23 18:37:53 | pies | 2 | 29872 | 675 | 4.436 | 6734.0 |
1287 | 2025-01-05 13:24:27 | pies | 1 | 13983 | 30 | 1.173 | 11920.7 |
1286 | 2024-12-27 13:18:49 | pies | 1 | 13983 | 30 | 1.143 | 12233.6 |
1285 | 2024-12-26 23:54:14 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
1284 | 2024-12-26 17:35:20 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
1283 | 2024-12-25 08:46:37 | pies | 1 | 13983 | 30 | 0.280 | 49939.3 |
1282 | 2024-12-10 21:17:41 | pies | 1 | 13983 | 30 | 1.080 | 12947.2 |
1281 | 2024-12-06 16:01:55 | pies | 2 | 29872 | 675 | 2.500 | 11948.8 |
1280 | 2024-12-06 13:37:30 | pies | 2 | 29872 | 675 | 4.250 | 7028.7 |
1279 | 2024-12-06 13:20:07 | pies | 2 | 29872 | 675 | 5.530 | 5401.8 |
1278 | 2024-12-06 12:33:36 | pies | 1 | 13983 | 30 | 0.233 | 60012.9 |
1277 | 2024-12-01 12:12:48 | pies | 1 | 13983 | 30 | 0.873 | 16017.2 |
1276 | 2024-11-28 06:29:23 | pies | 1 | 13983 | 30 | 0.250 | 55932.0 |
1275 | 2024-11-26 23:13:28 | pies | 1 | 13983 | 30 | 0.486 | 28771.6 |
1274 | 2024-11-26 13:59:18 | pies | 1 | 13983 | 30 | 0.360 | 38841.7 |
1273 | 2024-11-25 07:59:21 | pies | 1 | 13983 | 30 | 1.063 | 13154.3 |
1272 | 2024-11-06 09:14:32 | pies | 2 | 29872 | 675 | 4.013 | 7443.8 |
1271 | 2024-11-06 07:56:57 | pies | 1 | 13983 | 30 | 0.266 | 52567.7 |
1270 | 2024-10-28 05:37:29 | pies | 2 | 29872 | 675 | 3.360 | 8890.5 |
1269 | 2024-10-28 03:37:07 | pies | 2 | 29872 | 675 | 7.453 | 4008.1 |
1268 | 2024-10-27 20:02:13 | pies | 1 | 13983 | 30 | 0.280 | 49939.3 |
1267 | 2024-10-27 11:22:45 | pies | 1 | 13983 | 30 | 0.970 | 14415.5 |
1266 | 2024-10-26 03:33:20 | pies | 1 | 13983 | 30 | 1.436 | 9737.5 |
1265 | 2024-10-18 14:34:02 | pies | 1 | 13983 | 30 | 1.330 | 10513.5 |
1264 | 2024-10-16 05:33:57 | pies | 1 | 13983 | 30 | 1.250 | 11186.4 |
1263 | 2024-10-07 16:01:07 | pies | 1 | 13983 | 30 | 1.016 | 13762.8 |
1262 | 2024-10-07 10:06:50 | pies | 2 | 29872 | 675 | 5.936 | 5032.3 |
1261 | 2024-10-07 08:28:39 | pies | 1 | 13983 | 30 | 0.220 | 63559.1 |
1260 | 2024-09-28 01:48:54 | pies | 2 | 29872 | 675 | 7.220 | 4137.4 |
1259 | 2024-09-28 00:59:33 | pies | 2 | 29872 | 675 | 1.873 | 15948.7 |
1258 | 2024-09-27 19:56:34 | pies | 1 | 13983 | 30 | 2.216 | 6310.0 |
1257 | 2024-09-27 08:33:26 | pies | 1 | 13983 | 30 | 0.263 | 53167.3 |
1256 | 2024-09-26 01:38:14 | pies | 1 | 13983 | 30 | 1.313 | 10649.7 |
1255 | 2024-09-12 20:45:04 | pies | 2 | 29872 | 675 | 4.060 | 7357.6 |
1254 | 2024-09-07 04:08:22 | pies | 2 | 29872 | 675 | 6.813 | 4384.6 |
1253 | 2024-09-07 03:59:18 | pies | 1 | 13983 | 30 | 3.970 | 3522.2 |
1252 | 2024-08-31 05:21:15 | pies | 1 | 13983 | 30 | 1.373 | 10184.3 |
1251 | 2024-08-28 20:49:33 | pies | 2 | 29872 | 675 | 8.500 | 3514.4 |
1250 | 2024-08-28 19:07:35 | pies | 2 | 29872 | 675 | 5.626 | 5309.6 |
1249 | 2024-08-28 17:15:32 | pies | 1 | 13983 | 30 | 0.236 | 59250.0 |
1248 | 2024-08-28 05:59:40 | pies | 1 | 13983 | 30 | 1.546 | 9044.6 |
1247 | 2024-08-26 17:05:53 | pies | 1 | 13983 | 30 | 1.843 | 7587.1 |
1246 | 2024-08-15 00:28:06 | pies | 1 | 13983 | 30 | 2.030 | 6888.2 |
1245 | 2024-08-13 20:41:16 | pies | 2 | 29872 | 675 | 6.123 | 4878.7 |
1244 | 2024-08-13 08:46:16 | pies | 2 | 29872 | 675 | 3.326 | 8981.4 |
1243 | 2024-08-09 14:08:09 | pies | 1 | 13983 | 30 | 0.860 | 16259.3 |
1242 | 2024-08-07 22:09:29 | pies | 2 | 29872 | 675 | 4.123 | 7245.2 |
1241 | 2024-08-07 21:14:46 | pies | 1 | 13983 | 30 | 0.280 | 49939.3 |
1240 | 2024-08-04 10:42:10 | pies | 1 | 13983 | 30 | 0.843 | 16587.2 |
1239 | 2024-08-02 01:05:26 | pies | 1 | 13983 | 30 | 1.750 | 7990.3 |
1238 | 2024-07-29 18:47:23 | pies | 2 | 29872 | 675 | 0.906 | 32971.3 |