History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"harper"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
594 | 2024-04-26 17:18:27 | harper | 1 | 48755 | 9 | 0.953 | 51159.5 |
593 | 2024-04-09 03:17:42 | harper | 1 | 48755 | 9 | 2.076 | 23485.1 |
592 | 2024-04-09 03:17:34 | harper | 2 | 82551 | 162 | 3.423 | 24116.6 |
591 | 2024-04-08 06:12:46 | harper | 2 | 82551 | 162 | 2.686 | 30733.8 |
590 | 2024-04-06 08:35:15 | harper | 1 | 48755 | 9 | 4.313 | 11304.2 |
589 | 2024-03-30 01:57:22 | harper | 1 | 48755 | 9 | 1.953 | 24964.2 |
588 | 2024-03-07 04:38:51 | harper | 1 | 48755 | 9 | 3.016 | 16165.5 |
587 | 2024-03-01 12:33:02 | harper | 1 | 48755 | 9 | 0.766 | 63648.8 |
586 | 2024-02-27 15:09:27 | harper | 2 | 82551 | 162 | 2.313 | 35690.0 |
585 | 2024-02-27 15:09:26 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
584 | 2024-01-03 03:54:37 | harper | 1 | 48755 | 9 | 0.843 | 57835.1 |
583 | 2024-01-02 12:34:43 | harper | 2 | 82551 | 162 | 2.326 | 35490.5 |
582 | 2023-12-31 13:52:32 | harper | 1 | 48755 | 9 | 0.780 | 62506.4 |
581 | 2023-12-09 22:16:10 | harper | 2 | 82551 | 162 | 2.126 | 38829.3 |
580 | 2023-11-23 19:42:50 | harper | 2 | 82551 | 162 | 5.420 | 15230.8 |
579 | 2023-11-14 09:18:03 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
578 | 2023-11-09 03:45:13 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
577 | 2023-11-03 23:19:49 | harper | 1 | 48755 | 9 | 0.780 | 62506.4 |
576 | 2023-10-26 07:46:28 | harper | 1 | 48755 | 9 | 0.733 | 66514.3 |
575 | 2023-10-24 08:54:11 | harper | 1 | 48755 | 9 | 0.873 | 55847.7 |
574 | 2023-10-19 18:16:20 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
573 | 2023-10-19 04:23:42 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
572 | 2023-10-15 04:53:29 | harper | 1 | 48755 | 9 | 0.876 | 55656.4 |
571 | 2023-10-07 09:53:09 | harper | 1 | 48755 | 9 | 0.783 | 62266.9 |
570 | 2023-09-26 13:30:49 | harper | 1 | 48755 | 9 | 0.780 | 62506.4 |
569 | 2023-09-14 12:50:47 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
568 | 2023-09-11 11:36:41 | harper | 2 | 82551 | 162 | 2.750 | 30018.5 |
567 | 2023-09-11 02:00:34 | harper | 1 | 48755 | 9 | 0.813 | 59969.2 |
566 | 2023-09-08 17:08:43 | harper | 2 | 82551 | 162 | 2.186 | 37763.5 |
565 | 2023-08-17 16:26:44 | harper | 2 | 82551 | 162 | 2.203 | 37472.1 |
564 | 2023-08-15 14:45:02 | harper | 1 | 48755 | 9 | 0.766 | 63648.8 |
563 | 2023-07-11 20:00:18 | harper | 2 | 82551 | 162 | 2.560 | 32246.5 |
562 | 2023-05-30 10:43:20 | harper | 2 | 82551 | 162 | 2.436 | 33887.9 |
561 | 2023-05-28 09:26:33 | harper | 1 | 48755 | 9 | 0.873 | 55847.7 |
560 | 2023-05-13 16:57:41 | harper | 1 | 48755 | 9 | 0.860 | 56691.9 |
559 | 2023-04-25 12:42:19 | harper | 2 | 82551 | 162 | 2.153 | 38342.3 |
558 | 2023-03-30 21:52:49 | harper | 2 | 82551 | 162 | 2.560 | 32246.5 |
557 | 2023-03-10 14:36:43 | harper | 1 | 48755 | 9 | 1.516 | 32160.3 |
556 | 2023-03-08 01:58:54 | harper | 2 | 82551 | 162 | 2.156 | 38289.0 |
555 | 2023-02-12 04:24:35 | harper | 1 | 48755 | 9 | 0.826 | 59025.4 |
554 | 2022-12-30 19:16:07 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
553 | 2022-12-13 20:35:23 | harper | 2 | 82551 | 162 | 2.156 | 38289.0 |
552 | 2022-10-29 09:29:45 | harper | 1 | 48755 | 9 | 0.826 | 59025.4 |
551 | 2022-09-19 16:07:10 | harper | 1 | 48755 | 9 | 0.953 | 51159.5 |
550 | 2022-09-12 12:18:05 | harper | 1 | 48755 | 9 | 0.766 | 63648.8 |
549 | 2022-08-29 08:13:33 | harper | 1 | 48755 | 9 | 1.703 | 28628.9 |
548 | 2022-08-07 04:52:59 | harper | 1 | 48755 | 9 | 0.766 | 63648.8 |
547 | 2022-08-05 21:39:20 | harper | 1 | 48755 | 9 | 0.766 | 63648.8 |
546 | 2022-07-30 05:13:01 | harper | 1 | 48755 | 9 | 0.796 | 61250.0 |
545 | 2022-07-15 21:33:00 | harper | 1 | 48755 | 9 | 0.813 | 59969.2 |
544 | 2022-07-03 11:59:59 | harper | 1 | 48755 | 9 | 0.783 | 62266.9 |
543 | 2022-07-02 23:17:07 | harper | 1 | 48755 | 9 | 0.766 | 63648.8 |
542 | 2022-06-28 07:31:05 | harper | 2 | 82551 | 162 | 2.190 | 37694.5 |
541 | 2022-06-16 11:58:37 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
540 | 2022-05-26 03:49:52 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
539 | 2022-05-01 11:52:58 | harper | 1 | 48755 | 9 | 0.893 | 54596.9 |
538 | 2022-04-29 08:04:48 | harper | 1 | 48755 | 9 | 0.766 | 63648.8 |
537 | 2022-03-22 02:46:37 | harper | 1 | 48755 | 9 | 0.796 | 61250.0 |
536 | 2022-03-18 16:20:09 | harper | 1 | 48755 | 9 | 0.906 | 53813.5 |
535 | 2022-02-09 15:30:24 | harper | 2 | 82551 | 162 | 2.360 | 34979.2 |
534 | 2022-01-20 12:46:41 | harper | 1 | 48755 | 9 | 0.826 | 59025.4 |
533 | 2021-12-11 10:41:02 | harper | 1 | 48755 | 9 | 1.890 | 25796.3 |
532 | 2021-12-08 11:52:25 | harper | 1 | 48755 | 9 | 0.876 | 55656.4 |
531 | 2021-11-20 07:04:42 | harper | 1 | 48755 | 9 | 0.856 | 56956.8 |
530 | 2021-11-18 05:09:24 | harper | 1 | 48755 | 9 | 0.843 | 57835.1 |
529 | 2021-11-11 02:00:52 | harper | 1 | 48755 | 9 | 0.763 | 63899.1 |
528 | 2021-11-10 16:14:52 | harper | 1 | 48755 | 9 | 0.936 | 52088.7 |
527 | 2021-11-10 13:42:58 | harper | 2 | 82551 | 162 | 2.623 | 31472.0 |
526 | 2021-10-03 22:37:39 | harper | 1 | 48755 | 9 | 0.860 | 56691.9 |
525 | 2021-09-14 17:42:33 | harper | 1 | 48755 | 9 | 0.783 | 62266.9 |
524 | 2021-09-10 14:51:46 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
523 | 2021-06-09 17:59:25 | harper | 1 | 48755 | 9 | 0.766 | 63648.8 |
522 | 2021-06-05 09:33:00 | harper | 1 | 48755 | 9 | 0.843 | 57835.1 |
521 | 2021-05-11 08:03:07 | harper | 1 | 48755 | 9 | 0.873 | 55847.7 |
520 | 2021-02-28 19:19:36 | harper | 1 | 48755 | 9 | 0.843 | 57835.1 |
519 | 2021-02-12 06:42:12 | harper | 1 | 48755 | 9 | 0.860 | 56691.9 |
518 | 2021-01-24 13:01:00 | harper | 1 | 48755 | 9 | 0.860 | 56691.9 |
517 | 2020-12-27 07:47:47 | harper | 2 | 82551 | 162 | 2.656 | 31080.9 |
516 | 2020-11-19 12:35:17 | harper | 1 | 48755 | 9 | 0.783 | 62266.9 |
515 | 2020-10-30 21:34:40 | harper | 1 | 48755 | 9 | 0.780 | 62506.4 |
514 | 2020-10-28 21:10:29 | harper | 2 | 82551 | 162 | 2.220 | 37185.1 |
513 | 2020-10-10 02:11:36 | harper | 1 | 48755 | 9 | 0.830 | 58741.0 |
512 | 2020-09-05 10:56:14 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
511 | 2020-08-24 12:31:47 | harper | 1 | 48755 | 9 | 0.826 | 59025.4 |
510 | 2020-08-15 16:29:06 | harper | 1 | 48755 | 9 | 0.766 | 63648.8 |
509 | 2020-08-13 02:46:38 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
508 | 2020-05-12 01:05:50 | harper | 1 | 48755 | 9 | 0.860 | 56691.9 |
507 | 2020-03-27 18:33:07 | harper | 1 | 48755 | 9 | 1.720 | 28345.9 |
506 | 2020-03-24 11:22:58 | harper | 1 | 48755 | 9 | 0.936 | 52088.7 |
505 | 2020-03-23 19:45:08 | harper | 1 | 48755 | 9 | 0.936 | 52088.7 |
504 | 2020-03-23 12:05:47 | harper | 1 | 48755 | 9 | 0.813 | 59969.2 |
503 | 2020-03-22 16:01:18 | harper | 1 | 48755 | 9 | 0.890 | 54780.9 |
502 | 2020-03-19 21:40:21 | harper | 1 | 48755 | 9 | 0.843 | 57835.1 |
501 | 2020-03-18 22:31:44 | harper | 1 | 48755 | 9 | 0.876 | 55656.4 |
500 | 2020-02-26 03:11:58 | harper | 1 | 48755 | 9 | 0.876 | 55656.4 |
499 | 2020-02-21 03:01:32 | harper | 1 | 48755 | 9 | 1.186 | 41108.8 |
498 | 2020-02-18 22:17:52 | harper | 1 | 48755 | 9 | 0.873 | 55847.7 |
497 | 2020-02-11 02:26:16 | harper | 1 | 48755 | 9 | 1.876 | 25988.8 |
496 | 2020-02-09 10:22:37 | harper | 1 | 48755 | 9 | 0.953 | 51159.5 |
495 | 2020-02-02 03:27:29 | harper | 1 | 48755 | 9 | 0.843 | 57835.1 |