History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hankie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
457 | 2024-04-27 05:10:24 | hankie | 2 | 82551 | 42 | 3.690 | 22371.5 |
456 | 2024-04-22 21:25:14 | hankie | 1 | 48755 | 6 | 0.763 | 63899.1 |
455 | 2024-04-18 22:33:02 | hankie | 1 | 48755 | 6 | 0.763 | 63899.1 |
454 | 2024-04-06 01:49:33 | hankie | 1 | 48755 | 6 | 3.190 | 15283.7 |
453 | 2024-04-04 19:49:41 | hankie | 3 | 112716 | 627 | 20.160 | 5591.1 |
452 | 2024-04-04 05:35:38 | hankie | 2 | 82551 | 42 | 5.890 | 14015.4 |
451 | 2024-04-04 05:29:59 | hankie | 3 | 112716 | 627 | 9.810 | 11489.9 |
450 | 2024-04-04 05:29:58 | hankie | 2 | 82551 | 42 | 5.080 | 16250.2 |
449 | 2024-04-04 05:29:50 | hankie | 1 | 48755 | 6 | 2.300 | 21197.8 |
448 | 2024-04-04 05:29:23 | hankie | 3 | 112716 | 627 | 7.453 | 15123.6 |
447 | 2024-04-03 15:58:40 | hankie | 3 | 112716 | 627 | 15.533 | 7256.6 |
446 | 2024-04-03 06:34:23 | hankie | 3 | 112716 | 627 | 15.486 | 7278.6 |
445 | 2024-04-03 06:09:06 | hankie | 3 | 112716 | 627 | 4.876 | 23116.5 |
444 | 2024-03-06 23:54:43 | hankie | 1 | 48755 | 6 | 1.000 | 48755.0 |
443 | 2024-02-17 09:52:00 | hankie | 1 | 48755 | 6 | 0.733 | 66514.3 |
442 | 2024-01-11 00:27:45 | hankie | 3 | 112716 | 627 | 5.046 | 22337.7 |
441 | 2024-01-11 00:27:46 | hankie | 2 | 82551 | 42 | 2.500 | 33020.4 |
440 | 2024-01-04 00:30:59 | hankie | 1 | 48755 | 6 | 0.843 | 57835.1 |
439 | 2023-12-09 06:30:01 | hankie | 2 | 82551 | 42 | 2.280 | 36206.6 |
438 | 2023-12-09 06:29:57 | hankie | 3 | 112716 | 627 | 4.873 | 23130.7 |
437 | 2023-12-06 10:15:48 | hankie | 3 | 112716 | 627 | 4.783 | 23566.0 |
436 | 2023-11-24 06:36:00 | hankie | 3 | 112716 | 627 | 5.593 | 20153.0 |
435 | 2023-11-24 06:36:03 | hankie | 2 | 82551 | 42 | 2.560 | 32246.5 |
434 | 2023-11-15 19:55:41 | hankie | 1 | 48755 | 6 | 1.783 | 27344.4 |
433 | 2023-11-11 02:06:32 | hankie | 1 | 48755 | 6 | 0.826 | 59025.4 |
432 | 2023-11-04 09:42:31 | hankie | 1 | 48755 | 6 | 0.813 | 59969.2 |
431 | 2023-10-26 23:52:55 | hankie | 1 | 48755 | 6 | 0.763 | 63899.1 |
430 | 2023-10-21 23:14:31 | hankie | 1 | 48755 | 6 | 0.810 | 60191.4 |
429 | 2023-10-19 03:46:14 | hankie | 1 | 48755 | 6 | 0.860 | 56691.9 |
428 | 2023-10-18 21:11:11 | hankie | 1 | 48755 | 6 | 0.843 | 57835.1 |
427 | 2023-10-11 06:07:25 | hankie | 1 | 48755 | 6 | 0.733 | 66514.3 |
426 | 2023-10-04 03:11:15 | hankie | 1 | 48755 | 6 | 0.750 | 65006.7 |
425 | 2023-09-27 20:00:03 | hankie | 3 | 112716 | 627 | 5.766 | 19548.4 |
424 | 2023-09-27 20:00:05 | hankie | 2 | 82551 | 42 | 2.720 | 30349.6 |
423 | 2023-09-19 18:44:47 | hankie | 1 | 48755 | 6 | 0.906 | 53813.5 |
422 | 2023-09-15 12:42:09 | hankie | 1 | 48755 | 6 | 0.890 | 54780.9 |
421 | 2023-09-12 00:07:48 | hankie | 3 | 112716 | 627 | 6.640 | 16975.3 |
420 | 2023-09-03 10:45:15 | hankie | 3 | 112716 | 627 | 5.156 | 21861.1 |
419 | 2023-08-21 17:46:22 | hankie | 1 | 48755 | 6 | 0.750 | 65006.7 |
418 | 2023-07-02 06:37:10 | hankie | 1 | 48755 | 6 | 0.860 | 56691.9 |
417 | 2023-05-23 00:27:42 | hankie | 1 | 48755 | 6 | 0.733 | 66514.3 |
416 | 2023-04-03 08:56:21 | hankie | 3 | 112716 | 627 | 4.656 | 24208.8 |
415 | 2023-03-20 10:42:41 | hankie | 1 | 48755 | 6 | 0.873 | 55847.7 |
414 | 2023-03-15 21:19:50 | hankie | 1 | 48755 | 6 | 0.860 | 56691.9 |
413 | 2023-03-04 08:38:57 | hankie | 1 | 48755 | 6 | 0.766 | 63648.8 |
412 | 2023-02-25 15:28:26 | hankie | 3 | 112716 | 627 | 5.343 | 21096.0 |
411 | 2023-01-21 04:58:03 | hankie | 3 | 112716 | 627 | 4.593 | 24540.8 |
410 | 2023-01-14 16:04:52 | hankie | 3 | 112716 | 627 | 4.623 | 24381.6 |
409 | 2023-01-07 06:53:40 | hankie | 1 | 48755 | 6 | 0.753 | 64747.7 |
408 | 2022-12-14 14:58:09 | hankie | 3 | 112716 | 627 | 4.860 | 23192.6 |
407 | 2022-12-03 00:23:01 | hankie | 2 | 82551 | 42 | 2.143 | 38521.2 |
406 | 2022-11-24 12:18:38 | hankie | 1 | 48755 | 6 | 0.766 | 63648.8 |
405 | 2022-11-02 16:32:14 | hankie | 3 | 112716 | 627 | 5.190 | 21717.9 |
404 | 2022-10-07 20:33:41 | hankie | 2 | 82551 | 42 | 2.123 | 38884.1 |
403 | 2022-09-30 18:58:46 | hankie | 1 | 48755 | 6 | 0.736 | 66243.2 |
402 | 2022-09-08 20:47:43 | hankie | 2 | 82551 | 42 | 2.140 | 38575.2 |
401 | 2022-08-28 17:33:56 | hankie | 1 | 48755 | 6 | 0.750 | 65006.7 |
400 | 2022-08-18 10:07:27 | hankie | 1 | 48755 | 6 | 0.843 | 57835.1 |
399 | 2022-08-04 03:02:25 | hankie | 1 | 48755 | 6 | 0.750 | 65006.7 |
398 | 2022-07-11 17:02:59 | hankie | 2 | 82551 | 42 | 2.140 | 38575.2 |
397 | 2022-07-09 13:25:17 | hankie | 2 | 82551 | 42 | 2.156 | 38289.0 |
396 | 2022-06-17 09:31:55 | hankie | 1 | 48755 | 6 | 0.783 | 62266.9 |
395 | 2022-06-10 15:08:24 | hankie | 1 | 48755 | 6 | 0.813 | 59969.2 |
394 | 2022-06-04 09:44:12 | hankie | 1 | 48755 | 6 | 0.766 | 63648.8 |
393 | 2022-05-16 03:18:44 | hankie | 1 | 48755 | 6 | 0.860 | 56691.9 |
392 | 2022-05-15 00:05:05 | hankie | 1 | 48755 | 6 | 1.283 | 38000.8 |
391 | 2022-05-13 04:37:35 | hankie | 3 | 112716 | 627 | 5.160 | 21844.2 |
390 | 2022-05-12 21:10:43 | hankie | 1 | 48755 | 6 | 1.060 | 45995.3 |
389 | 2022-04-09 14:13:50 | hankie | 1 | 48755 | 6 | 0.873 | 55847.7 |
388 | 2022-02-18 11:41:41 | hankie | 2 | 82551 | 42 | 2.373 | 34787.6 |
387 | 2022-02-15 22:18:29 | hankie | 1 | 48755 | 6 | 0.860 | 56691.9 |
386 | 2022-02-13 18:13:56 | hankie | 1 | 48755 | 6 | 0.750 | 65006.7 |
385 | 2022-01-17 00:08:43 | hankie | 3 | 112716 | 627 | 4.733 | 23814.9 |
384 | 2021-12-25 10:42:56 | hankie | 1 | 48755 | 6 | 0.903 | 53992.2 |
383 | 2021-11-14 12:28:20 | hankie | 1 | 48755 | 6 | 0.920 | 52994.6 |
382 | 2021-11-11 17:36:37 | hankie | 1 | 48755 | 6 | 0.970 | 50262.9 |
381 | 2021-10-25 07:00:57 | hankie | 3 | 112716 | 627 | 5.716 | 19719.4 |
380 | 2021-10-04 07:35:08 | hankie | 1 | 48755 | 6 | 0.830 | 58741.0 |
379 | 2021-09-18 06:23:37 | hankie | 1 | 48755 | 6 | 0.826 | 59025.4 |
378 | 2021-09-15 04:22:29 | hankie | 1 | 48755 | 6 | 1.000 | 48755.0 |
377 | 2021-06-18 10:40:22 | hankie | 1 | 48755 | 6 | 0.813 | 59969.2 |
376 | 2021-05-28 19:10:56 | hankie | 1 | 48755 | 6 | 0.783 | 62266.9 |
375 | 2021-05-03 01:14:54 | hankie | 1 | 48755 | 6 | 0.856 | 56956.8 |
374 | 2021-04-01 07:05:38 | hankie | 1 | 48755 | 6 | 0.780 | 62506.4 |
373 | 2021-03-30 08:55:07 | hankie | 2 | 82551 | 42 | 2.406 | 34310.5 |
372 | 2021-03-19 05:41:21 | hankie | 1 | 48755 | 6 | 0.923 | 52822.3 |
371 | 2021-03-04 04:52:16 | hankie | 2 | 82551 | 42 | 2.156 | 38289.0 |
370 | 2021-02-12 09:09:05 | hankie | 1 | 48755 | 6 | 0.780 | 62506.4 |
369 | 2021-02-09 22:01:41 | hankie | 1 | 48755 | 6 | 0.766 | 63648.8 |
368 | 2020-12-19 22:25:35 | hankie | 1 | 48755 | 6 | 0.783 | 62266.9 |
367 | 2020-12-08 23:20:41 | hankie | 1 | 48755 | 6 | 0.780 | 62506.4 |
366 | 2020-11-20 23:54:17 | hankie | 1 | 48755 | 6 | 0.750 | 65006.7 |
365 | 2020-11-19 11:13:03 | hankie | 2 | 82551 | 42 | 2.656 | 31080.9 |
364 | 2020-10-26 05:24:56 | hankie | 1 | 48755 | 6 | 0.860 | 56691.9 |
363 | 2020-10-10 09:01:06 | hankie | 1 | 48755 | 6 | 0.783 | 62266.9 |
362 | 2020-10-04 19:13:18 | hankie | 1 | 48755 | 6 | 0.860 | 56691.9 |
361 | 2020-09-02 07:37:00 | hankie | 1 | 48755 | 6 | 0.873 | 55847.7 |
360 | 2020-08-10 08:52:27 | hankie | 1 | 48755 | 6 | 0.830 | 58741.0 |
359 | 2020-08-07 03:01:40 | hankie | 1 | 48755 | 6 | 0.780 | 62506.4 |
358 | 2020-08-03 21:28:00 | hankie | 1 | 48755 | 6 | 0.873 | 55847.7 |