History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"beard"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
615 | 2024-04-13 06:09:40 | beard | 1 | 28756 | 8 | 0.513 | 56054.6 |
614 | 2024-04-11 06:24:54 | beard | 1 | 28756 | 8 | 0.513 | 56054.6 |
613 | 2024-04-06 06:08:50 | beard | 2 | 53800 | 165 | 3.423 | 15717.2 |
612 | 2024-04-06 06:08:47 | beard | 1 | 28756 | 8 | 0.530 | 54256.6 |
611 | 2024-03-31 16:09:29 | beard | 1 | 28756 | 8 | 0.546 | 52666.7 |
610 | 2024-03-29 11:21:30 | beard | 1 | 28756 | 8 | 0.580 | 49579.3 |
609 | 2024-03-29 11:21:13 | beard | 2 | 53800 | 165 | 5.906 | 9109.4 |
608 | 2024-03-28 18:41:34 | beard | 2 | 53800 | 165 | 3.190 | 16865.2 |
607 | 2024-03-28 18:23:41 | beard | 1 | 28756 | 8 | 0.530 | 54256.6 |
606 | 2024-03-07 15:44:02 | beard | 2 | 53800 | 165 | 1.686 | 31909.8 |
605 | 2024-03-07 04:05:11 | beard | 1 | 28756 | 8 | 0.610 | 47141.0 |
604 | 2024-03-01 08:07:25 | beard | 1 | 28756 | 8 | 0.656 | 43835.4 |
603 | 2024-02-27 18:01:54 | beard | 2 | 53800 | 165 | 1.890 | 28465.6 |
602 | 2024-02-26 22:52:19 | beard | 2 | 53800 | 165 | 1.720 | 31279.1 |
601 | 2024-02-26 19:32:24 | beard | 1 | 28756 | 8 | 0.436 | 65954.1 |
600 | 2024-02-03 18:34:19 | beard | 1 | 28756 | 8 | 0.470 | 61183.0 |
599 | 2024-01-29 06:07:47 | beard | 1 | 28756 | 8 | 0.530 | 54256.6 |
598 | 2024-01-11 04:49:35 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
597 | 2023-12-28 22:32:07 | beard | 1 | 28756 | 8 | 0.453 | 63479.0 |
596 | 2023-12-28 13:42:30 | beard | 2 | 53800 | 165 | 1.423 | 37807.4 |
595 | 2023-12-07 21:09:13 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
594 | 2023-12-07 21:09:12 | beard | 1 | 28756 | 8 | 0.550 | 52283.6 |
593 | 2023-11-24 22:38:56 | beard | 2 | 53800 | 165 | 1.436 | 37465.2 |
592 | 2023-11-18 09:37:22 | beard | 1 | 28756 | 8 | 0.486 | 59168.7 |
591 | 2023-11-13 09:20:13 | beard | 1 | 28756 | 8 | 0.440 | 65354.5 |
590 | 2023-11-03 08:50:57 | beard | 1 | 28756 | 8 | 0.563 | 51076.4 |
589 | 2023-11-02 06:56:38 | beard | 2 | 53800 | 165 | 1.373 | 39184.3 |
588 | 2023-11-02 06:05:39 | beard | 1 | 28756 | 8 | 0.470 | 61183.0 |
587 | 2023-10-20 06:31:12 | beard | 1 | 28756 | 8 | 0.440 | 65354.5 |
586 | 2023-10-20 02:55:18 | beard | 1 | 28756 | 8 | 0.483 | 59536.2 |
585 | 2023-10-17 22:05:21 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
584 | 2023-10-12 00:55:05 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
583 | 2023-10-05 00:16:26 | beard | 1 | 28756 | 8 | 0.436 | 65954.1 |
582 | 2023-09-28 03:06:55 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
581 | 2023-09-24 21:01:28 | beard | 1 | 28756 | 8 | 0.470 | 61183.0 |
580 | 2023-09-23 22:22:14 | beard | 1 | 28756 | 8 | 0.453 | 63479.0 |
579 | 2023-09-22 02:38:25 | beard | 1 | 28756 | 8 | 0.453 | 63479.0 |
578 | 2023-09-16 14:41:33 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
577 | 2023-08-24 23:02:33 | beard | 2 | 53800 | 165 | 1.610 | 33416.1 |
576 | 2023-08-14 02:44:00 | beard | 1 | 28756 | 8 | 0.440 | 65354.5 |
575 | 2023-06-17 15:35:06 | beard | 1 | 28756 | 8 | 0.450 | 63902.2 |
574 | 2023-05-13 09:34:52 | beard | 1 | 28756 | 8 | 0.440 | 65354.5 |
573 | 2023-05-07 22:57:47 | beard | 2 | 53800 | 165 | 1.436 | 37465.2 |
572 | 2023-03-26 23:07:08 | beard | 1 | 28756 | 8 | 0.466 | 61708.2 |
571 | 2023-03-15 06:57:17 | beard | 1 | 28756 | 8 | 0.470 | 61183.0 |
570 | 2023-03-11 13:24:11 | beard | 1 | 28756 | 8 | 0.483 | 59536.2 |
569 | 2023-02-13 12:23:53 | beard | 2 | 53800 | 165 | 1.560 | 34487.2 |
568 | 2023-01-02 20:50:51 | beard | 1 | 28756 | 8 | 0.516 | 55728.7 |
567 | 2022-12-31 09:47:28 | beard | 2 | 53800 | 165 | 1.423 | 37807.4 |
566 | 2022-12-03 17:27:06 | beard | 1 | 28756 | 8 | 0.483 | 59536.2 |
565 | 2022-11-24 22:48:39 | beard | 2 | 53800 | 165 | 1.403 | 38346.4 |
564 | 2022-09-23 21:00:56 | beard | 1 | 28756 | 8 | 0.436 | 65954.1 |
563 | 2022-09-01 14:44:02 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
562 | 2022-08-27 19:31:00 | beard | 1 | 28756 | 8 | 0.453 | 63479.0 |
561 | 2022-08-23 05:39:12 | beard | 1 | 28756 | 8 | 0.466 | 61708.2 |
560 | 2022-08-19 22:16:43 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
559 | 2022-07-10 19:32:40 | beard | 1 | 28756 | 8 | 0.436 | 65954.1 |
558 | 2022-05-30 17:55:05 | beard | 1 | 28756 | 8 | 0.453 | 63479.0 |
557 | 2022-05-07 10:15:23 | beard | 1 | 28756 | 8 | 0.436 | 65954.1 |
556 | 2022-05-05 15:24:17 | beard | 1 | 28756 | 8 | 0.530 | 54256.6 |
555 | 2022-04-27 14:45:04 | beard | 2 | 53800 | 165 | 1.763 | 30516.2 |
554 | 2022-02-02 15:19:37 | beard | 1 | 28756 | 8 | 0.516 | 55728.7 |
553 | 2022-01-24 14:35:10 | beard | 1 | 28756 | 8 | 0.533 | 53951.2 |
552 | 2022-01-22 11:25:46 | beard | 1 | 28756 | 8 | 0.483 | 59536.2 |
551 | 2021-12-28 11:38:25 | beard | 2 | 53800 | 165 | 1.563 | 34421.0 |
550 | 2021-11-17 23:43:36 | beard | 1 | 28756 | 8 | 0.516 | 55728.7 |
549 | 2021-11-01 22:13:38 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
548 | 2021-10-12 18:00:59 | beard | 2 | 53800 | 165 | 1.720 | 31279.1 |
547 | 2021-09-27 07:17:16 | beard | 1 | 28756 | 8 | 0.453 | 63479.0 |
546 | 2021-08-27 21:48:34 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
545 | 2021-08-15 14:30:44 | beard | 2 | 53800 | 165 | 1.483 | 36277.8 |
544 | 2021-08-12 15:47:47 | beard | 1 | 28756 | 8 | 0.563 | 51076.4 |
543 | 2021-08-02 02:44:02 | beard | 1 | 28756 | 8 | 0.420 | 68466.7 |
542 | 2021-07-28 16:48:24 | beard | 1 | 28756 | 8 | 0.453 | 63479.0 |
541 | 2021-05-01 12:38:42 | beard | 1 | 28756 | 8 | 0.533 | 53951.2 |
540 | 2021-04-20 11:32:57 | beard | 1 | 28756 | 8 | 0.436 | 65954.1 |
539 | 2021-02-01 13:51:16 | beard | 1 | 28756 | 8 | 0.533 | 53951.2 |
538 | 2021-01-29 02:32:37 | beard | 1 | 28756 | 8 | 0.483 | 59536.2 |
537 | 2021-01-26 23:50:53 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
536 | 2021-01-26 23:36:46 | beard | 1 | 28756 | 8 | 0.470 | 61183.0 |
535 | 2021-01-05 03:21:09 | beard | 1 | 28756 | 8 | 0.453 | 63479.0 |
534 | 2020-11-06 05:42:02 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
533 | 2020-11-04 21:25:07 | beard | 1 | 28756 | 8 | 0.470 | 61183.0 |
532 | 2020-10-30 23:17:23 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
531 | 2020-10-28 01:29:45 | beard | 1 | 28756 | 8 | 0.936 | 30722.2 |
530 | 2020-10-26 07:37:29 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
529 | 2020-10-22 15:22:09 | beard | 1 | 28756 | 8 | 0.453 | 63479.0 |
528 | 2020-10-15 07:51:09 | beard | 1 | 28756 | 8 | 0.436 | 65954.1 |
527 | 2020-09-25 20:12:04 | beard | 1 | 28756 | 8 | 0.486 | 59168.7 |
526 | 2020-09-21 03:00:00 | beard | 1 | 28756 | 8 | 0.453 | 63479.0 |
525 | 2020-08-02 20:31:00 | beard | 1 | 28756 | 8 | 0.436 | 65954.1 |
524 | 2020-07-22 15:29:17 | beard | 1 | 28756 | 8 | 0.500 | 57512.0 |
523 | 2020-05-17 22:38:33 | beard | 1 | 28756 | 8 | 0.516 | 55728.7 |
522 | 2020-04-20 17:30:57 | beard | 1 | 28756 | 8 | 0.563 | 51076.4 |
521 | 2020-03-25 08:07:35 | beard | 1 | 28756 | 8 | 0.970 | 29645.4 |
520 | 2020-03-24 21:45:10 | beard | 1 | 28756 | 8 | 0.533 | 53951.2 |
519 | 2020-03-23 06:09:52 | beard | 1 | 28756 | 8 | 0.533 | 53951.2 |
518 | 2020-03-21 13:44:32 | beard | 1 | 28756 | 8 | 0.546 | 52666.7 |
517 | 2020-03-21 03:06:18 | beard | 1 | 28756 | 8 | 0.483 | 59536.2 |
516 | 2020-03-21 00:48:08 | beard | 1 | 28756 | 8 | 0.466 | 61708.2 |