History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"advice"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
622 | 2024-05-14 04:57:30 | advice | 1 | 48755 | 3 | 0.906 | 53813.5 |
621 | 2024-05-06 09:09:08 | advice | 3 | 112716 | 280 | 16.610 | 6786.0 |
620 | 2024-05-05 19:18:35 | advice | 2 | 82551 | 20 | 3.780 | 21838.9 |
619 | 2024-05-05 19:18:19 | advice | 3 | 112716 | 280 | 5.530 | 20382.6 |
618 | 2024-05-04 07:25:47 | advice | 1 | 48755 | 3 | 0.920 | 52994.6 |
617 | 2024-05-03 17:51:59 | advice | 2 | 82551 | 20 | 2.686 | 30733.8 |
616 | 2024-05-03 15:48:55 | advice | 3 | 112716 | 280 | 6.050 | 18630.7 |
615 | 2024-05-03 13:49:58 | advice | 1 | 48755 | 3 | 0.843 | 57835.1 |
614 | 2024-05-03 09:50:19 | advice | 2 | 82551 | 20 | 3.640 | 22678.8 |
613 | 2024-05-03 06:44:59 | advice | 3 | 112716 | 280 | 6.546 | 17219.1 |
612 | 2024-05-02 02:37:24 | advice | 3 | 112716 | 280 | 9.500 | 11864.8 |
611 | 2024-05-02 00:15:39 | advice | 2 | 82551 | 20 | 4.843 | 17045.4 |
610 | 2024-05-01 18:14:39 | advice | 2 | 82551 | 20 | 2.830 | 29170.0 |
609 | 2024-04-22 14:07:21 | advice | 1 | 48755 | 3 | 1.046 | 46610.9 |
608 | 2024-04-18 23:14:10 | advice | 1 | 48755 | 3 | 0.826 | 59025.4 |
607 | 2024-04-05 10:36:19 | advice | 1 | 48755 | 3 | 1.720 | 28345.9 |
606 | 2024-03-31 18:25:00 | advice | 1 | 48755 | 3 | 2.203 | 22131.2 |
605 | 2024-03-06 11:35:59 | advice | 1 | 48755 | 3 | 1.923 | 25353.6 |
604 | 2024-02-25 22:24:13 | advice | 1 | 48755 | 3 | 1.123 | 43415.0 |
603 | 2024-02-23 08:21:14 | advice | 2 | 82551 | 20 | 2.330 | 35429.6 |
602 | 2024-02-05 15:06:50 | advice | 3 | 112716 | 280 | 5.953 | 18934.3 |
601 | 2024-02-05 15:06:46 | advice | 2 | 82551 | 20 | 2.733 | 30205.3 |
600 | 2024-02-05 04:15:45 | advice | 2 | 82551 | 20 | 5.486 | 15047.6 |
599 | 2024-02-05 04:15:29 | advice | 3 | 112716 | 280 | 6.780 | 16624.8 |
598 | 2024-02-04 12:41:27 | advice | 3 | 112716 | 280 | 6.576 | 17140.5 |
597 | 2024-02-04 00:27:47 | advice | 2 | 82551 | 20 | 2.203 | 37472.1 |
596 | 2024-02-04 00:27:43 | advice | 3 | 112716 | 280 | 4.690 | 24033.3 |
595 | 2024-01-19 00:41:32 | advice | 1 | 48755 | 3 | 0.830 | 58741.0 |
594 | 2024-01-06 06:24:59 | advice | 2 | 82551 | 20 | 2.486 | 33206.4 |
593 | 2024-01-01 21:10:23 | advice | 3 | 112716 | 280 | 8.923 | 12632.1 |
592 | 2023-12-30 07:56:29 | advice | 1 | 48755 | 3 | 0.783 | 62266.9 |
591 | 2023-12-28 21:15:22 | advice | 3 | 112716 | 280 | 5.920 | 19039.9 |
590 | 2023-12-28 21:15:17 | advice | 2 | 82551 | 20 | 2.466 | 33475.7 |
589 | 2023-11-17 14:55:26 | advice | 2 | 82551 | 20 | 2.953 | 27955.0 |
588 | 2023-11-17 09:34:58 | advice | 1 | 48755 | 3 | 0.826 | 59025.4 |
587 | 2023-11-14 14:46:30 | advice | 3 | 112716 | 280 | 5.253 | 21457.5 |
586 | 2023-11-14 14:46:25 | advice | 2 | 82551 | 20 | 2.203 | 37472.1 |
585 | 2023-11-13 11:01:08 | advice | 1 | 48755 | 3 | 0.750 | 65006.7 |
584 | 2023-11-06 16:07:58 | advice | 1 | 48755 | 3 | 1.343 | 36303.1 |
583 | 2023-10-21 10:00:09 | advice | 1 | 48755 | 3 | 0.813 | 59969.2 |
582 | 2023-10-21 06:26:46 | advice | 1 | 48755 | 3 | 1.716 | 28412.0 |
581 | 2023-10-18 11:13:48 | advice | 1 | 48755 | 3 | 0.783 | 62266.9 |
580 | 2023-10-15 16:02:53 | advice | 1 | 48755 | 3 | 0.750 | 65006.7 |
579 | 2023-09-26 05:43:45 | advice | 1 | 48755 | 3 | 0.843 | 57835.1 |
578 | 2023-09-22 00:31:20 | advice | 1 | 48755 | 3 | 0.733 | 66514.3 |
577 | 2023-09-18 18:48:50 | advice | 1 | 48755 | 3 | 0.873 | 55847.7 |
576 | 2023-09-15 11:18:00 | advice | 1 | 48755 | 3 | 0.826 | 59025.4 |
575 | 2023-08-19 00:51:57 | advice | 2 | 82551 | 20 | 2.640 | 31269.3 |
574 | 2023-08-17 05:36:31 | advice | 1 | 48755 | 3 | 0.780 | 62506.4 |
573 | 2023-05-29 09:25:20 | advice | 1 | 48755 | 3 | 0.860 | 56691.9 |
572 | 2023-05-19 13:57:27 | advice | 1 | 48755 | 3 | 0.830 | 58741.0 |
571 | 2023-05-03 11:40:30 | advice | 2 | 82551 | 20 | 2.126 | 38829.3 |
570 | 2023-03-15 10:43:30 | advice | 1 | 48755 | 3 | 0.750 | 65006.7 |
569 | 2023-02-10 12:26:00 | advice | 2 | 82551 | 20 | 2.080 | 39688.0 |
568 | 2023-02-09 19:06:35 | advice | 1 | 48755 | 3 | 1.640 | 29728.7 |
567 | 2023-01-03 22:35:48 | advice | 1 | 48755 | 3 | 0.750 | 65006.7 |
566 | 2022-11-21 21:17:20 | advice | 2 | 82551 | 20 | 2.186 | 37763.5 |
565 | 2022-10-23 06:20:52 | advice | 1 | 48755 | 3 | 0.750 | 65006.7 |
564 | 2022-09-25 15:43:48 | advice | 1 | 48755 | 3 | 0.766 | 63648.8 |
563 | 2022-09-08 07:36:06 | advice | 3 | 112716 | 280 | 5.546 | 20323.8 |
562 | 2022-06-29 13:51:24 | advice | 1 | 48755 | 3 | 0.766 | 63648.8 |
561 | 2022-06-25 17:15:33 | advice | 1 | 48755 | 3 | 0.763 | 63899.1 |
560 | 2022-06-25 12:00:02 | advice | 2 | 82551 | 20 | 2.406 | 34310.5 |
559 | 2022-05-05 16:36:01 | advice | 1 | 48755 | 3 | 0.983 | 49598.2 |
558 | 2022-03-06 02:43:14 | advice | 1 | 48755 | 3 | 0.843 | 57835.1 |
557 | 2022-02-02 09:47:30 | advice | 1 | 48755 | 3 | 0.763 | 63899.1 |
556 | 2022-01-31 06:17:22 | advice | 1 | 48755 | 3 | 0.826 | 59025.4 |
555 | 2021-11-24 07:55:39 | advice | 1 | 48755 | 3 | 0.843 | 57835.1 |
554 | 2021-11-22 08:48:53 | advice | 1 | 48755 | 3 | 0.843 | 57835.1 |
553 | 2021-11-22 05:40:42 | advice | 1 | 48755 | 3 | 1.733 | 28133.3 |
552 | 2021-08-16 04:14:54 | advice | 1 | 48755 | 3 | 0.780 | 62506.4 |
551 | 2021-05-31 03:46:26 | advice | 1 | 48755 | 3 | 0.796 | 61250.0 |
550 | 2021-05-12 03:15:38 | advice | 1 | 48755 | 3 | 0.890 | 54780.9 |
549 | 2021-05-05 20:59:36 | advice | 1 | 48755 | 3 | 1.736 | 28084.7 |
548 | 2021-02-12 08:02:51 | advice | 1 | 48755 | 3 | 0.780 | 62506.4 |
547 | 2021-02-07 19:14:50 | advice | 1 | 48755 | 3 | 0.813 | 59969.2 |
546 | 2021-02-02 19:58:41 | advice | 1 | 48755 | 3 | 0.750 | 65006.7 |
545 | 2021-01-29 17:09:02 | advice | 1 | 48755 | 3 | 0.876 | 55656.4 |
544 | 2021-01-29 14:37:03 | advice | 1 | 48755 | 3 | 0.860 | 56691.9 |
543 | 2020-11-23 05:22:17 | advice | 1 | 48755 | 3 | 0.766 | 63648.8 |
542 | 2020-10-29 04:11:01 | advice | 1 | 48755 | 3 | 0.846 | 57630.0 |
541 | 2020-10-26 20:27:09 | advice | 1 | 48755 | 3 | 0.893 | 54596.9 |
540 | 2020-10-25 22:45:28 | advice | 2 | 82551 | 20 | 5.000 | 16510.2 |
539 | 2020-10-23 16:04:41 | advice | 1 | 48755 | 3 | 0.843 | 57835.1 |
538 | 2020-10-16 17:56:21 | advice | 1 | 48755 | 3 | 0.830 | 58741.0 |
537 | 2020-10-07 21:07:51 | advice | 1 | 48755 | 3 | 0.750 | 65006.7 |
536 | 2020-08-21 04:44:54 | advice | 1 | 48755 | 3 | 0.860 | 56691.9 |
535 | 2020-08-19 19:42:08 | advice | 1 | 48755 | 3 | 0.843 | 57835.1 |
534 | 2020-08-11 06:59:04 | advice | 3 | 112716 | 280 | 5.406 | 20850.2 |
533 | 2020-07-31 20:34:40 | advice | 1 | 48755 | 3 | 0.970 | 50262.9 |
532 | 2020-07-28 09:59:53 | advice | 1 | 48755 | 3 | 0.923 | 52822.3 |
531 | 2020-07-26 08:55:45 | advice | 1 | 48755 | 3 | 0.906 | 53813.5 |
530 | 2020-05-25 18:01:08 | advice | 1 | 48755 | 3 | 0.733 | 66514.3 |
529 | 2020-04-24 02:37:46 | advice | 1 | 48755 | 3 | 0.856 | 56956.8 |
528 | 2020-04-18 06:22:59 | advice | 1 | 48755 | 3 | 0.860 | 56691.9 |
527 | 2020-04-17 06:21:50 | advice | 1 | 48755 | 3 | 0.906 | 53813.5 |
526 | 2020-04-16 07:03:04 | advice | 1 | 48755 | 3 | 1.483 | 32875.9 |
525 | 2020-04-15 06:22:26 | advice | 1 | 48755 | 3 | 0.796 | 61250.0 |
524 | 2020-03-28 06:18:35 | advice | 1 | 48755 | 3 | 1.766 | 27607.6 |
523 | 2020-03-27 18:32:53 | advice | 1 | 48755 | 3 | 0.843 | 57835.1 |