History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"china"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1380 | 2024-04-24 19:55:19 | china | 1 | 28756 | 9 | 0.670 | 42919.4 |
1379 | 2024-04-19 15:10:30 | china | 1 | 28756 | 9 | 0.703 | 40904.7 |
1378 | 2024-04-11 05:12:56 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1377 | 2024-04-07 04:00:30 | china | 1 | 28756 | 9 | 1.250 | 23004.8 |
1376 | 2024-04-03 06:13:37 | china | 2 | 53800 | 112 | 3.830 | 14047.0 |
1375 | 2024-04-03 06:10:20 | china | 1 | 28756 | 9 | 1.076 | 26724.9 |
1374 | 2024-03-31 06:52:57 | china | 1 | 28756 | 9 | 0.483 | 59536.2 |
1373 | 2024-03-27 07:34:51 | china | 1 | 28756 | 9 | 0.453 | 63479.0 |
1372 | 2024-03-23 07:28:00 | china | 2 | 53800 | 112 | 1.593 | 33772.8 |
1371 | 2024-03-04 00:42:12 | china | 1 | 28756 | 9 | 0.516 | 55728.7 |
1370 | 2024-03-01 05:23:56 | china | 1 | 28756 | 9 | 0.453 | 63479.0 |
1369 | 2024-02-25 18:46:00 | china | 2 | 53800 | 112 | 3.750 | 14346.7 |
1368 | 2024-02-25 18:43:55 | china | 1 | 28756 | 9 | 1.606 | 17905.4 |
1367 | 2024-02-05 07:27:26 | china | 1 | 28756 | 9 | 0.516 | 55728.7 |
1366 | 2024-02-03 03:24:35 | china | 1 | 28756 | 9 | 0.533 | 53951.2 |
1365 | 2024-01-26 10:06:21 | china | 1 | 28756 | 9 | 1.063 | 27051.7 |
1364 | 2024-01-21 00:52:37 | china | 1 | 28756 | 9 | 0.436 | 65954.1 |
1363 | 2023-12-28 10:47:56 | china | 2 | 53800 | 112 | 1.483 | 36277.8 |
1362 | 2023-11-30 23:23:31 | china | 2 | 53800 | 112 | 1.563 | 34421.0 |
1361 | 2023-11-28 17:00:34 | china | 2 | 53800 | 112 | 1.406 | 38264.6 |
1360 | 2023-11-27 06:51:14 | china | 1 | 28756 | 9 | 0.453 | 63479.0 |
1359 | 2023-11-25 05:27:47 | china | 2 | 53800 | 112 | 1.453 | 37026.8 |
1358 | 2023-11-13 10:12:54 | china | 1 | 28756 | 9 | 0.453 | 63479.0 |
1357 | 2023-11-09 15:13:05 | china | 1 | 28756 | 9 | 0.470 | 61183.0 |
1356 | 2023-10-27 15:15:16 | china | 1 | 28756 | 9 | 0.470 | 61183.0 |
1355 | 2023-10-20 17:39:59 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1354 | 2023-10-18 18:06:45 | china | 1 | 28756 | 9 | 0.453 | 63479.0 |
1353 | 2023-10-13 11:33:26 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1352 | 2023-10-11 07:58:43 | china | 1 | 28756 | 9 | 0.453 | 63479.0 |
1351 | 2023-10-09 22:43:48 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1350 | 2023-10-04 14:30:06 | china | 1 | 28756 | 9 | 0.483 | 59536.2 |
1349 | 2023-09-26 10:28:06 | china | 2 | 53800 | 112 | 1.483 | 36277.8 |
1348 | 2023-09-21 15:08:44 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1347 | 2023-09-19 15:36:01 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1346 | 2023-09-15 19:42:32 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1345 | 2023-09-13 07:16:15 | china | 1 | 28756 | 9 | 0.440 | 65354.5 |
1344 | 2023-08-29 16:26:39 | china | 2 | 53800 | 112 | 1.610 | 33416.1 |
1343 | 2023-08-16 02:44:38 | china | 1 | 28756 | 9 | 0.546 | 52666.7 |
1342 | 2023-07-07 21:16:01 | china | 1 | 28756 | 9 | 0.453 | 63479.0 |
1341 | 2023-06-30 05:51:09 | china | 1 | 28756 | 9 | 0.466 | 61708.2 |
1340 | 2023-06-26 05:20:33 | china | 1 | 28756 | 9 | 0.436 | 65954.1 |
1339 | 2023-06-23 10:56:54 | china | 1 | 28756 | 9 | 0.466 | 61708.2 |
1338 | 2023-06-20 23:18:41 | china | 1 | 28756 | 9 | 0.890 | 32310.1 |
1337 | 2023-05-25 11:51:12 | china | 1 | 28756 | 9 | 0.440 | 65354.5 |
1336 | 2023-05-14 10:43:26 | china | 2 | 53800 | 112 | 1.360 | 39558.8 |
1335 | 2023-05-04 12:32:47 | china | 1 | 28756 | 9 | 0.436 | 65954.1 |
1334 | 2023-05-02 11:26:28 | china | 1 | 28756 | 9 | 0.486 | 59168.7 |
1333 | 2023-04-07 04:52:43 | china | 1 | 28756 | 9 | 0.436 | 65954.1 |
1332 | 2023-03-20 16:24:18 | china | 1 | 28756 | 9 | 0.470 | 61183.0 |
1331 | 2023-03-13 22:23:39 | china | 1 | 28756 | 9 | 0.466 | 61708.2 |
1330 | 2023-03-09 11:16:36 | china | 1 | 28756 | 9 | 0.486 | 59168.7 |
1329 | 2023-02-21 01:17:17 | china | 2 | 53800 | 112 | 1.390 | 38705.0 |
1328 | 2023-01-20 05:55:17 | china | 1 | 28756 | 9 | 0.483 | 59536.2 |
1327 | 2023-01-20 00:38:43 | china | 1 | 28756 | 9 | 0.483 | 59536.2 |
1326 | 2023-01-18 01:28:12 | china | 1 | 28756 | 9 | 0.453 | 63479.0 |
1325 | 2023-01-16 07:08:41 | china | 1 | 28756 | 9 | 0.486 | 59168.7 |
1324 | 2022-12-09 03:25:40 | china | 1 | 28756 | 9 | 0.483 | 59536.2 |
1323 | 2022-12-06 00:15:08 | china | 1 | 28756 | 9 | 0.436 | 65954.1 |
1322 | 2022-12-04 03:54:21 | china | 1 | 28756 | 9 | 0.420 | 68466.7 |
1321 | 2022-12-03 03:17:25 | china | 2 | 53800 | 112 | 1.346 | 39970.3 |
1320 | 2022-12-02 08:50:52 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1319 | 2022-11-17 12:20:44 | china | 1 | 28756 | 9 | 0.530 | 54256.6 |
1318 | 2022-10-16 09:16:19 | china | 1 | 28756 | 9 | 0.423 | 67981.1 |
1317 | 2022-09-06 09:09:03 | china | 1 | 28756 | 9 | 0.436 | 65954.1 |
1316 | 2022-09-04 15:45:17 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1315 | 2022-09-03 02:57:11 | china | 1 | 28756 | 9 | 0.513 | 56054.6 |
1314 | 2022-08-25 20:57:07 | china | 1 | 28756 | 9 | 0.466 | 61708.2 |
1313 | 2022-07-16 06:50:02 | china | 1 | 28756 | 9 | 0.486 | 59168.7 |
1312 | 2022-07-13 05:11:56 | china | 1 | 28756 | 9 | 0.470 | 61183.0 |
1311 | 2022-07-12 16:20:22 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1310 | 2022-07-08 01:49:15 | china | 1 | 28756 | 9 | 0.440 | 65354.5 |
1309 | 2022-05-29 04:46:46 | china | 1 | 28756 | 9 | 0.440 | 65354.5 |
1308 | 2022-05-26 03:33:03 | china | 1 | 28756 | 9 | 0.436 | 65954.1 |
1307 | 2022-05-25 13:46:38 | china | 1 | 28756 | 9 | 0.466 | 61708.2 |
1306 | 2022-05-16 13:41:56 | china | 1 | 28756 | 9 | 0.516 | 55728.7 |
1305 | 2022-05-12 17:19:20 | china | 2 | 53800 | 112 | 1.423 | 37807.4 |
1304 | 2022-04-10 14:57:43 | china | 1 | 28756 | 9 | 0.533 | 53951.2 |
1303 | 2022-04-10 00:54:11 | china | 2 | 53800 | 112 | 1.436 | 37465.2 |
1302 | 2022-04-07 14:28:25 | china | 1 | 28756 | 9 | 0.563 | 51076.4 |
1301 | 2022-04-07 02:28:44 | china | 1 | 28756 | 9 | 0.703 | 40904.7 |
1300 | 2022-03-31 19:18:31 | china | 2 | 53800 | 112 | 1.906 | 28226.7 |
1299 | 2022-03-10 16:00:56 | china | 1 | 28756 | 9 | 0.640 | 44931.3 |
1298 | 2022-02-17 11:15:09 | china | 2 | 53800 | 112 | 1.563 | 34421.0 |
1297 | 2022-02-11 21:43:19 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1296 | 2022-02-07 10:41:53 | china | 1 | 28756 | 9 | 0.436 | 65954.1 |
1295 | 2022-02-06 09:36:42 | china | 1 | 28756 | 9 | 1.156 | 24875.4 |
1294 | 2022-02-05 08:13:56 | china | 1 | 28756 | 9 | 0.483 | 59536.2 |
1293 | 2022-02-04 08:26:14 | china | 1 | 28756 | 9 | 0.513 | 56054.6 |
1292 | 2022-02-03 02:46:32 | china | 1 | 28756 | 9 | 0.530 | 54256.6 |
1291 | 2022-02-02 08:12:53 | china | 1 | 28756 | 9 | 1.060 | 27128.3 |
1290 | 2022-02-01 06:05:45 | china | 1 | 28756 | 9 | 0.470 | 61183.0 |
1289 | 2022-01-31 04:08:03 | china | 1 | 28756 | 9 | 0.546 | 52666.7 |
1288 | 2022-01-30 09:43:55 | china | 1 | 28756 | 9 | 0.436 | 65954.1 |
1287 | 2022-01-29 08:57:34 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1286 | 2021-12-23 05:09:53 | china | 1 | 28756 | 9 | 0.470 | 61183.0 |
1285 | 2021-11-18 05:07:10 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1284 | 2021-11-13 13:24:38 | china | 1 | 28756 | 9 | 0.440 | 65354.5 |
1283 | 2021-11-07 11:11:21 | china | 1 | 28756 | 9 | 0.500 | 57512.0 |
1282 | 2021-10-26 00:13:51 | china | 1 | 28756 | 9 | 0.436 | 65954.1 |
1281 | 2021-10-23 23:57:34 | china | 1 | 28756 | 9 | 0.466 | 61708.2 |