History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drug"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
618 | 2024-04-27 16:04:25 | drug | 1 | 13983 | 10 | 0.310 | 45106.5 |
617 | 2024-04-26 23:01:47 | drug | 1 | 13983 | 10 | 0.860 | 16259.3 |
616 | 2024-04-26 17:19:01 | drug | 2 | 29872 | 126 | 0.936 | 31914.5 |
615 | 2024-04-15 00:13:29 | drug | 1 | 13983 | 10 | 0.546 | 25609.9 |
614 | 2024-04-14 23:59:38 | drug | 1 | 13983 | 10 | 0.893 | 15658.5 |
613 | 2024-04-04 23:13:03 | drug | 1 | 13983 | 10 | 0.716 | 19529.3 |
612 | 2024-03-30 22:26:48 | drug | 2 | 29872 | 126 | 2.296 | 13010.5 |
611 | 2024-03-30 22:08:31 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
610 | 2024-03-30 19:32:35 | drug | 2 | 29872 | 126 | 2.046 | 14600.2 |
609 | 2024-03-28 21:46:14 | drug | 2 | 29872 | 126 | 2.970 | 10057.9 |
608 | 2024-03-28 19:03:07 | drug | 2 | 29872 | 126 | 1.016 | 29401.6 |
607 | 2024-03-19 22:17:54 | drug | 1 | 13983 | 10 | 0.266 | 52567.7 |
606 | 2024-03-07 06:04:44 | drug | 2 | 29872 | 126 | 2.000 | 14936.0 |
605 | 2024-03-05 20:49:44 | drug | 2 | 29872 | 126 | 1.030 | 29001.9 |
604 | 2024-03-05 20:00:54 | drug | 1 | 13983 | 10 | 0.530 | 26383.0 |
603 | 2024-02-25 16:45:50 | drug | 1 | 13983 | 10 | 0.393 | 35580.2 |
602 | 2024-02-23 10:28:42 | drug | 1 | 13983 | 10 | 0.280 | 49939.3 |
601 | 2024-02-03 02:08:10 | drug | 1 | 13983 | 10 | 0.500 | 27966.0 |
600 | 2024-01-26 09:26:53 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
599 | 2024-01-15 14:33:02 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
598 | 2023-12-09 19:31:02 | drug | 2 | 29872 | 126 | 0.856 | 34897.2 |
597 | 2023-12-06 14:44:01 | drug | 1 | 13983 | 10 | 0.236 | 59250.0 |
596 | 2023-12-05 13:52:32 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
595 | 2023-11-30 19:04:38 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
594 | 2023-11-29 00:49:38 | drug | 2 | 29872 | 126 | 0.736 | 40587.0 |
593 | 2023-11-20 20:37:22 | drug | 1 | 13983 | 10 | 0.216 | 64736.1 |
592 | 2023-11-20 00:53:53 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
591 | 2023-11-11 04:05:46 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
590 | 2023-10-27 15:36:31 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
589 | 2023-10-22 18:57:33 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
588 | 2023-10-18 15:05:51 | drug | 1 | 13983 | 10 | 0.216 | 64736.1 |
587 | 2023-10-11 15:50:02 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
586 | 2023-10-04 22:41:40 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
585 | 2023-09-24 15:29:01 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
584 | 2023-09-19 23:51:05 | drug | 1 | 13983 | 10 | 0.216 | 64736.1 |
583 | 2023-08-16 12:19:13 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
582 | 2023-07-13 04:28:32 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
581 | 2023-05-05 20:23:20 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
580 | 2023-04-18 17:16:40 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
579 | 2023-02-10 05:16:14 | drug | 1 | 13983 | 10 | 0.216 | 64736.1 |
578 | 2023-01-23 13:41:21 | drug | 1 | 13983 | 10 | 0.206 | 67878.6 |
577 | 2022-12-07 22:13:03 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
576 | 2022-10-09 05:13:49 | drug | 1 | 13983 | 10 | 0.216 | 64736.1 |
575 | 2022-09-13 11:36:45 | drug | 1 | 13983 | 10 | 0.216 | 64736.1 |
574 | 2022-09-12 05:21:43 | drug | 1 | 13983 | 10 | 0.266 | 52567.7 |
573 | 2022-09-10 16:21:15 | drug | 1 | 13983 | 10 | 0.236 | 59250.0 |
572 | 2022-08-07 01:47:27 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
571 | 2022-08-06 16:22:41 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
570 | 2022-08-04 08:02:20 | drug | 1 | 13983 | 10 | 0.216 | 64736.1 |
569 | 2022-07-30 02:56:00 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
568 | 2022-07-28 23:03:26 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
567 | 2022-07-03 10:32:20 | drug | 1 | 13983 | 10 | 0.346 | 40413.3 |
566 | 2022-07-02 22:35:05 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
565 | 2022-07-02 09:32:20 | drug | 1 | 13983 | 10 | 0.200 | 69915.0 |
564 | 2022-06-18 20:18:34 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
563 | 2022-06-16 10:30:11 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
562 | 2022-06-15 19:59:55 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
561 | 2022-06-08 16:11:50 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
560 | 2022-06-01 12:33:42 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
559 | 2022-05-26 02:45:59 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
558 | 2022-05-25 16:00:23 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
557 | 2022-03-31 14:52:45 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
556 | 2022-03-29 10:56:30 | drug | 1 | 13983 | 10 | 0.376 | 37188.8 |
555 | 2022-02-27 20:33:01 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
554 | 2022-01-02 05:05:50 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
553 | 2021-11-19 14:16:59 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
552 | 2021-11-04 17:11:41 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
551 | 2021-11-02 15:48:12 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
550 | 2021-10-04 20:26:21 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
549 | 2021-08-18 05:50:50 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
548 | 2021-08-16 17:30:58 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
547 | 2021-05-05 19:49:31 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
546 | 2021-02-03 13:14:13 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
545 | 2020-11-01 18:49:46 | drug | 1 | 13983 | 10 | 0.236 | 59250.0 |
544 | 2020-10-30 18:56:12 | drug | 2 | 29872 | 126 | 0.876 | 34100.5 |
543 | 2020-10-27 06:58:52 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
542 | 2020-10-25 01:15:37 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
541 | 2020-10-23 14:51:48 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
540 | 2020-10-13 13:41:25 | drug | 1 | 13983 | 10 | 0.236 | 59250.0 |
539 | 2020-10-05 11:21:43 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
538 | 2020-09-26 13:48:58 | drug | 1 | 13983 | 10 | 0.206 | 67878.6 |
537 | 2020-09-10 14:53:26 | drug | 1 | 13983 | 10 | 0.206 | 67878.6 |
536 | 2020-09-06 22:32:28 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
535 | 2020-08-31 03:00:36 | drug | 2 | 29872 | 126 | 0.923 | 32364.0 |
534 | 2020-08-27 01:48:06 | drug | 2 | 29872 | 126 | 0.763 | 39150.7 |
533 | 2020-08-24 19:58:32 | drug | 1 | 13983 | 10 | 0.216 | 64736.1 |
532 | 2020-08-22 01:55:52 | drug | 2 | 29872 | 126 | 0.750 | 39829.3 |
531 | 2020-08-15 20:52:31 | drug | 2 | 29872 | 126 | 0.733 | 40753.1 |
530 | 2020-08-05 05:01:40 | drug | 2 | 29872 | 126 | 0.733 | 40753.1 |
529 | 2020-08-04 15:35:51 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |
528 | 2020-07-31 16:57:35 | drug | 2 | 29872 | 126 | 0.873 | 34217.6 |
527 | 2020-07-31 13:28:43 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
526 | 2020-07-30 05:17:44 | drug | 1 | 13983 | 10 | 0.250 | 55932.0 |
525 | 2020-07-29 03:35:56 | drug | 1 | 13983 | 10 | 0.220 | 63559.1 |
524 | 2020-07-26 21:36:44 | drug | 1 | 13983 | 10 | 0.236 | 59250.0 |
523 | 2020-07-25 08:25:30 | drug | 2 | 29872 | 126 | 0.796 | 37527.6 |
522 | 2020-07-23 08:07:12 | drug | 2 | 29872 | 126 | 0.810 | 36879.0 |
521 | 2020-06-18 10:12:05 | drug | 2 | 29872 | 126 | 0.750 | 39829.3 |
520 | 2020-04-24 15:53:17 | drug | 1 | 13983 | 10 | 0.233 | 60012.9 |
519 | 2020-04-20 03:07:51 | drug | 1 | 13983 | 10 | 0.203 | 68881.8 |