History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"frank"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
549 | 2024-04-23 20:19:03 | frank | 1 | 28756 | 10 | 1.140 | 25224.6 |
548 | 2024-04-21 07:21:34 | frank | 1 | 28756 | 10 | 0.576 | 49923.6 |
547 | 2024-04-21 07:21:29 | frank | 2 | 53800 | 109 | 1.810 | 29723.8 |
546 | 2024-04-21 07:21:24 | frank | 1 | 28756 | 10 | 0.470 | 61183.0 |
545 | 2024-04-03 06:06:44 | frank | 1 | 28756 | 10 | 0.470 | 61183.0 |
544 | 2024-03-31 05:55:19 | frank | 2 | 53800 | 109 | 3.470 | 15504.3 |
543 | 2024-03-31 03:44:31 | frank | 1 | 28756 | 10 | 0.470 | 61183.0 |
542 | 2024-03-15 22:37:34 | frank | 2 | 53800 | 109 | 1.873 | 28724.0 |
541 | 2024-03-15 22:36:55 | frank | 1 | 28756 | 10 | 0.873 | 32939.3 |
540 | 2024-03-04 03:15:24 | frank | 2 | 53800 | 109 | 1.406 | 38264.6 |
539 | 2024-03-04 03:15:18 | frank | 1 | 28756 | 10 | 0.453 | 63479.0 |
538 | 2024-02-25 19:19:32 | frank | 1 | 28756 | 10 | 0.516 | 55728.7 |
537 | 2024-02-12 15:23:22 | frank | 2 | 53800 | 109 | 4.576 | 11757.0 |
536 | 2024-02-11 23:14:06 | frank | 2 | 53800 | 109 | 5.313 | 10126.1 |
535 | 2024-02-11 17:36:43 | frank | 1 | 28756 | 10 | 0.453 | 63479.0 |
534 | 2024-02-04 05:31:22 | frank | 1 | 28756 | 10 | 0.983 | 29253.3 |
533 | 2024-02-03 02:11:43 | frank | 1 | 28756 | 10 | 0.530 | 54256.6 |
532 | 2024-01-26 00:22:49 | frank | 1 | 28756 | 10 | 0.500 | 57512.0 |
531 | 2024-01-12 04:09:48 | frank | 2 | 53800 | 109 | 1.376 | 39098.8 |
530 | 2024-01-11 08:22:32 | frank | 1 | 28756 | 10 | 0.436 | 65954.1 |
529 | 2024-01-09 03:55:56 | frank | 1 | 28756 | 10 | 0.483 | 59536.2 |
528 | 2024-01-02 08:42:31 | frank | 2 | 53800 | 109 | 1.560 | 34487.2 |
527 | 2023-12-30 15:55:39 | frank | 2 | 53800 | 109 | 1.403 | 38346.4 |
526 | 2023-12-30 08:18:49 | frank | 2 | 53800 | 109 | 1.486 | 36204.6 |
525 | 2023-11-30 01:43:55 | frank | 2 | 53800 | 109 | 1.546 | 34799.5 |
524 | 2023-11-18 13:25:01 | frank | 1 | 28756 | 10 | 0.546 | 52666.7 |
523 | 2023-11-13 14:01:22 | frank | 1 | 28756 | 10 | 0.436 | 65954.1 |
522 | 2023-11-12 22:26:46 | frank | 2 | 53800 | 109 | 1.390 | 38705.0 |
521 | 2023-11-02 21:25:15 | frank | 1 | 28756 | 10 | 0.983 | 29253.3 |
520 | 2023-10-27 16:37:02 | frank | 1 | 28756 | 10 | 0.453 | 63479.0 |
519 | 2023-10-22 03:25:16 | frank | 2 | 53800 | 109 | 1.313 | 40974.9 |
518 | 2023-10-21 09:14:04 | frank | 1 | 28756 | 10 | 0.486 | 59168.7 |
517 | 2023-10-18 17:06:59 | frank | 1 | 28756 | 10 | 0.483 | 59536.2 |
516 | 2023-10-12 08:33:07 | frank | 1 | 28756 | 10 | 0.530 | 54256.6 |
515 | 2023-10-09 05:46:01 | frank | 1 | 28756 | 10 | 0.500 | 57512.0 |
514 | 2023-10-03 16:08:05 | frank | 1 | 28756 | 10 | 0.953 | 30174.2 |
513 | 2023-09-29 10:12:05 | frank | 2 | 53800 | 109 | 3.330 | 16156.2 |
512 | 2023-09-23 22:06:46 | frank | 2 | 53800 | 109 | 1.483 | 36277.8 |
511 | 2023-09-18 23:54:26 | frank | 1 | 28756 | 10 | 0.563 | 51076.4 |
510 | 2023-09-10 22:01:59 | frank | 1 | 28756 | 10 | 0.530 | 54256.6 |
509 | 2023-08-25 23:15:20 | frank | 1 | 28756 | 10 | 0.440 | 65354.5 |
508 | 2023-08-01 13:01:33 | frank | 2 | 53800 | 109 | 1.406 | 38264.6 |
507 | 2023-06-19 00:12:04 | frank | 1 | 28756 | 10 | 0.470 | 61183.0 |
506 | 2023-05-28 04:05:51 | frank | 1 | 28756 | 10 | 0.440 | 65354.5 |
505 | 2023-04-10 03:57:11 | frank | 2 | 53800 | 109 | 1.343 | 40059.6 |
504 | 2023-03-24 15:27:22 | frank | 1 | 28756 | 10 | 0.440 | 65354.5 |
503 | 2023-02-27 22:25:53 | frank | 1 | 28756 | 10 | 0.423 | 67981.1 |
502 | 2023-01-30 16:09:55 | frank | 1 | 28756 | 10 | 0.420 | 68466.7 |
501 | 2023-01-15 23:01:36 | frank | 2 | 53800 | 109 | 1.576 | 34137.1 |
500 | 2023-01-08 13:31:32 | frank | 1 | 28756 | 10 | 0.423 | 67981.1 |
499 | 2022-12-15 20:38:20 | frank | 1 | 28756 | 10 | 0.470 | 61183.0 |
498 | 2022-11-13 02:59:57 | frank | 1 | 28756 | 10 | 0.500 | 57512.0 |
497 | 2022-11-07 14:16:09 | frank | 1 | 28756 | 10 | 0.576 | 49923.6 |
496 | 2022-10-28 03:08:01 | frank | 2 | 53800 | 109 | 1.360 | 39558.8 |
495 | 2022-10-06 11:59:57 | frank | 1 | 28756 | 10 | 0.436 | 65954.1 |
494 | 2022-09-01 17:43:37 | frank | 1 | 28756 | 10 | 0.453 | 63479.0 |
493 | 2022-08-24 06:21:04 | frank | 1 | 28756 | 10 | 0.423 | 67981.1 |
492 | 2022-08-16 04:42:59 | frank | 1 | 28756 | 10 | 0.516 | 55728.7 |
491 | 2022-07-21 21:25:25 | frank | 1 | 28756 | 10 | 0.423 | 67981.1 |
490 | 2022-07-18 10:29:55 | frank | 1 | 28756 | 10 | 0.470 | 61183.0 |
489 | 2022-07-10 13:09:22 | frank | 1 | 28756 | 10 | 0.486 | 59168.7 |
488 | 2022-06-26 08:11:20 | frank | 1 | 28756 | 10 | 0.486 | 59168.7 |
487 | 2022-06-25 18:18:53 | frank | 1 | 28756 | 10 | 0.436 | 65954.1 |
486 | 2022-06-08 21:07:15 | frank | 1 | 28756 | 10 | 0.563 | 51076.4 |
485 | 2022-05-28 09:16:57 | frank | 2 | 53800 | 109 | 1.376 | 39098.8 |
484 | 2022-05-25 07:20:05 | frank | 1 | 28756 | 10 | 0.436 | 65954.1 |
483 | 2022-03-31 01:52:35 | frank | 1 | 28756 | 10 | 0.576 | 49923.6 |
482 | 2022-03-15 11:06:18 | frank | 1 | 28756 | 10 | 0.576 | 49923.6 |
481 | 2022-03-14 19:02:50 | frank | 1 | 28756 | 10 | 0.623 | 46157.3 |
480 | 2022-03-13 19:04:25 | frank | 1 | 28756 | 10 | 0.453 | 63479.0 |
479 | 2022-03-12 17:38:41 | frank | 1 | 28756 | 10 | 0.453 | 63479.0 |
478 | 2022-02-06 14:41:16 | frank | 1 | 28756 | 10 | 0.436 | 65954.1 |
477 | 2022-02-04 11:42:02 | frank | 1 | 28756 | 10 | 0.513 | 56054.6 |
476 | 2022-01-21 02:26:21 | frank | 2 | 53800 | 109 | 1.686 | 31909.8 |
475 | 2021-12-19 20:04:53 | frank | 1 | 28756 | 10 | 0.453 | 63479.0 |
474 | 2021-12-16 21:02:13 | frank | 1 | 28756 | 10 | 0.436 | 65954.1 |
473 | 2021-11-24 05:38:19 | frank | 1 | 28756 | 10 | 0.436 | 65954.1 |
472 | 2021-11-15 03:41:18 | frank | 1 | 28756 | 10 | 0.500 | 57512.0 |
471 | 2021-11-14 04:33:38 | frank | 1 | 28756 | 10 | 0.516 | 55728.7 |
470 | 2021-11-13 05:29:42 | frank | 1 | 28756 | 10 | 0.593 | 48492.4 |
469 | 2021-11-12 09:20:21 | frank | 1 | 28756 | 10 | 0.513 | 56054.6 |
468 | 2021-11-11 05:55:38 | frank | 1 | 28756 | 10 | 0.470 | 61183.0 |
467 | 2021-11-05 15:12:34 | frank | 1 | 28756 | 10 | 0.486 | 59168.7 |
466 | 2021-10-25 02:28:38 | frank | 2 | 53800 | 109 | 1.360 | 39558.8 |
465 | 2021-10-07 20:48:36 | frank | 1 | 28756 | 10 | 0.483 | 59536.2 |
464 | 2021-10-05 19:04:12 | frank | 1 | 28756 | 10 | 0.436 | 65954.1 |
463 | 2021-09-12 14:26:22 | frank | 1 | 28756 | 10 | 0.423 | 67981.1 |
462 | 2021-09-12 07:42:38 | frank | 1 | 28756 | 10 | 0.466 | 61708.2 |
461 | 2021-09-05 16:42:28 | frank | 1 | 28756 | 10 | 0.440 | 65354.5 |
460 | 2021-07-28 20:56:20 | frank | 1 | 28756 | 10 | 0.423 | 67981.1 |
459 | 2021-06-12 10:01:19 | frank | 1 | 28756 | 10 | 0.453 | 63479.0 |
458 | 2021-05-25 15:34:17 | frank | 1 | 28756 | 10 | 0.500 | 57512.0 |
457 | 2021-04-29 08:58:18 | frank | 1 | 28756 | 10 | 0.530 | 54256.6 |
456 | 2021-04-24 19:09:50 | frank | 1 | 28756 | 10 | 0.516 | 55728.7 |
455 | 2021-04-02 16:29:03 | frank | 1 | 28756 | 10 | 0.516 | 55728.7 |
454 | 2021-03-28 23:14:37 | frank | 1 | 28756 | 10 | 0.513 | 56054.6 |
453 | 2021-03-09 08:31:09 | frank | 1 | 28756 | 10 | 0.470 | 61183.0 |
452 | 2021-01-12 18:19:25 | frank | 1 | 28756 | 10 | 0.420 | 68466.7 |
451 | 2020-12-05 21:30:29 | frank | 1 | 28756 | 10 | 0.440 | 65354.5 |
450 | 2020-11-08 21:56:56 | frank | 1 | 28756 | 10 | 0.486 | 59168.7 |