History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"baggie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
625 | 2024-04-30 02:59:01 | baggie | 1 | 48755 | 5 | 1.640 | 29728.7 |
624 | 2024-04-27 17:57:03 | baggie | 2 | 82551 | 59 | 3.296 | 25045.8 |
623 | 2024-04-24 07:27:33 | baggie | 1 | 48755 | 5 | 1.953 | 24964.2 |
622 | 2024-04-22 14:02:18 | baggie | 3 | 112716 | 500 | 17.610 | 6400.7 |
621 | 2024-04-20 23:09:08 | baggie | 3 | 112716 | 500 | 17.393 | 6480.5 |
620 | 2024-04-05 23:43:29 | baggie | 1 | 48755 | 5 | 3.046 | 16006.2 |
619 | 2024-03-31 18:21:38 | baggie | 1 | 48755 | 5 | 1.920 | 25393.2 |
618 | 2024-03-31 07:05:09 | baggie | 3 | 112716 | 500 | 14.610 | 7715.0 |
617 | 2024-03-31 06:28:15 | baggie | 3 | 112716 | 500 | 14.253 | 7908.2 |
616 | 2024-03-31 06:03:26 | baggie | 3 | 112716 | 500 | 5.233 | 21539.5 |
615 | 2024-03-28 07:49:38 | baggie | 2 | 82551 | 59 | 8.216 | 10047.6 |
614 | 2024-03-23 14:51:01 | baggie | 2 | 82551 | 59 | 2.153 | 38342.3 |
613 | 2024-03-08 22:44:33 | baggie | 3 | 112716 | 500 | 11.016 | 10232.0 |
612 | 2024-03-07 04:02:59 | baggie | 3 | 112716 | 500 | 14.033 | 8032.2 |
611 | 2024-03-06 23:25:46 | baggie | 3 | 112716 | 500 | 8.250 | 13662.5 |
610 | 2024-03-06 02:50:33 | baggie | 3 | 112716 | 500 | 10.390 | 10848.5 |
609 | 2024-03-06 02:50:32 | baggie | 2 | 82551 | 59 | 5.513 | 14973.9 |
608 | 2024-03-06 02:50:28 | baggie | 1 | 48755 | 5 | 1.813 | 26891.9 |
607 | 2024-03-04 18:27:04 | baggie | 1 | 48755 | 5 | 2.890 | 16870.2 |
606 | 2024-02-11 21:43:30 | baggie | 1 | 48755 | 5 | 0.890 | 54780.9 |
605 | 2024-02-04 05:31:55 | baggie | 2 | 82551 | 59 | 3.140 | 26290.1 |
604 | 2024-02-02 22:18:38 | baggie | 3 | 112716 | 500 | 10.126 | 11131.3 |
603 | 2024-02-02 01:49:36 | baggie | 3 | 112716 | 500 | 5.156 | 21861.1 |
602 | 2024-01-31 21:38:08 | baggie | 2 | 82551 | 59 | 2.406 | 34310.5 |
601 | 2024-01-31 21:37:44 | baggie | 3 | 112716 | 500 | 5.406 | 20850.2 |
600 | 2024-01-31 18:03:06 | baggie | 3 | 112716 | 500 | 5.783 | 19490.9 |
599 | 2024-01-27 03:42:14 | baggie | 1 | 48755 | 5 | 0.860 | 56691.9 |
598 | 2024-01-15 00:05:08 | baggie | 2 | 82551 | 59 | 2.513 | 32849.6 |
597 | 2024-01-11 21:41:20 | baggie | 3 | 112716 | 500 | 5.343 | 21096.0 |
596 | 2023-12-29 21:55:12 | baggie | 3 | 112716 | 500 | 5.736 | 19650.6 |
595 | 2023-12-28 16:06:57 | baggie | 3 | 112716 | 500 | 5.440 | 20719.9 |
594 | 2023-12-28 16:07:00 | baggie | 2 | 82551 | 59 | 2.626 | 31436.0 |
593 | 2023-12-25 09:41:52 | baggie | 3 | 112716 | 500 | 4.813 | 23419.1 |
592 | 2023-12-04 19:11:54 | baggie | 2 | 82551 | 59 | 2.156 | 38289.0 |
591 | 2023-12-04 19:11:45 | baggie | 3 | 112716 | 500 | 4.750 | 23729.7 |
590 | 2023-12-04 05:53:15 | baggie | 3 | 112716 | 500 | 5.626 | 20034.8 |
589 | 2023-11-30 07:48:13 | baggie | 2 | 82551 | 59 | 2.513 | 32849.6 |
588 | 2023-11-18 18:01:42 | baggie | 1 | 48755 | 5 | 0.813 | 59969.2 |
587 | 2023-11-17 03:49:37 | baggie | 1 | 48755 | 5 | 0.766 | 63648.8 |
586 | 2023-11-13 21:01:36 | baggie | 3 | 112716 | 500 | 4.783 | 23566.0 |
585 | 2023-11-13 09:26:15 | baggie | 1 | 48755 | 5 | 0.843 | 57835.1 |
584 | 2023-11-09 16:59:07 | baggie | 1 | 48755 | 5 | 0.780 | 62506.4 |
583 | 2023-11-04 09:39:13 | baggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
582 | 2023-10-22 10:59:29 | baggie | 1 | 48755 | 5 | 0.830 | 58741.0 |
581 | 2023-10-18 13:27:05 | baggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
580 | 2023-10-11 06:04:37 | baggie | 1 | 48755 | 5 | 0.736 | 66243.2 |
579 | 2023-10-06 16:35:26 | baggie | 1 | 48755 | 5 | 0.860 | 56691.9 |
578 | 2023-10-06 04:02:17 | baggie | 3 | 112716 | 500 | 5.626 | 20034.8 |
577 | 2023-09-26 12:21:40 | baggie | 1 | 48755 | 5 | 0.826 | 59025.4 |
576 | 2023-09-13 15:04:55 | baggie | 1 | 48755 | 5 | 0.936 | 52088.7 |
575 | 2023-09-05 04:08:58 | baggie | 1 | 48755 | 5 | 0.843 | 57835.1 |
574 | 2023-08-31 21:15:44 | baggie | 3 | 112716 | 500 | 5.343 | 21096.0 |
573 | 2023-08-28 23:11:22 | baggie | 2 | 82551 | 59 | 2.140 | 38575.2 |
572 | 2023-08-25 12:18:03 | baggie | 3 | 112716 | 500 | 5.250 | 21469.7 |
571 | 2023-08-10 05:29:25 | baggie | 3 | 112716 | 500 | 5.250 | 21469.7 |
570 | 2023-08-03 00:14:11 | baggie | 1 | 48755 | 5 | 0.873 | 55847.7 |
569 | 2023-06-23 02:01:41 | baggie | 3 | 112716 | 500 | 5.550 | 20309.2 |
568 | 2023-06-15 09:36:25 | baggie | 3 | 112716 | 500 | 5.110 | 22057.9 |
567 | 2023-06-14 11:27:48 | baggie | 3 | 112716 | 500 | 4.640 | 24292.2 |
566 | 2023-06-13 10:39:37 | baggie | 3 | 112716 | 500 | 5.326 | 21163.3 |
565 | 2023-06-11 11:37:25 | baggie | 3 | 112716 | 500 | 5.923 | 19030.2 |
564 | 2023-06-10 23:01:42 | baggie | 1 | 48755 | 5 | 0.733 | 66514.3 |
563 | 2023-06-10 20:20:10 | baggie | 3 | 112716 | 500 | 5.593 | 20153.0 |
562 | 2023-05-17 11:08:56 | baggie | 3 | 112716 | 500 | 5.360 | 21029.1 |
561 | 2023-05-12 19:27:12 | baggie | 2 | 82551 | 59 | 2.110 | 39123.7 |
560 | 2023-04-25 13:28:02 | baggie | 1 | 48755 | 5 | 0.766 | 63648.8 |
559 | 2023-04-21 20:54:56 | baggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
558 | 2023-03-30 09:36:32 | baggie | 1 | 48755 | 5 | 1.656 | 29441.4 |
557 | 2023-03-03 12:32:56 | baggie | 3 | 112716 | 500 | 4.606 | 24471.6 |
556 | 2023-02-25 05:35:04 | baggie | 3 | 112716 | 500 | 4.670 | 24136.2 |
555 | 2023-02-19 17:30:40 | baggie | 2 | 82551 | 59 | 2.110 | 39123.7 |
554 | 2023-02-13 13:31:49 | baggie | 3 | 112716 | 500 | 4.563 | 24702.2 |
553 | 2023-01-13 03:25:36 | baggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
552 | 2023-01-09 11:08:45 | baggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
551 | 2022-12-08 23:31:12 | baggie | 3 | 112716 | 500 | 4.563 | 24702.2 |
550 | 2022-12-03 18:00:35 | baggie | 3 | 112716 | 500 | 4.750 | 23729.7 |
549 | 2022-12-02 04:12:27 | baggie | 2 | 82551 | 59 | 2.126 | 38829.3 |
548 | 2022-12-01 23:02:24 | baggie | 3 | 112716 | 500 | 5.470 | 20606.2 |
547 | 2022-11-29 23:35:26 | baggie | 3 | 112716 | 500 | 5.423 | 20784.8 |
546 | 2022-11-27 23:39:28 | baggie | 3 | 112716 | 500 | 5.236 | 21527.1 |
545 | 2022-11-11 08:51:41 | baggie | 3 | 112716 | 500 | 4.766 | 23650.0 |
544 | 2022-11-07 00:25:52 | baggie | 3 | 112716 | 500 | 5.343 | 21096.0 |
543 | 2022-11-06 21:57:31 | baggie | 3 | 112716 | 500 | 5.330 | 21147.5 |
542 | 2022-11-02 03:51:24 | baggie | 3 | 112716 | 500 | 5.376 | 20966.5 |
541 | 2022-11-01 16:52:00 | baggie | 1 | 48755 | 5 | 0.796 | 61250.0 |
540 | 2022-09-29 06:22:48 | baggie | 1 | 48755 | 5 | 0.843 | 57835.1 |
539 | 2022-09-24 19:54:47 | baggie | 3 | 112716 | 500 | 4.970 | 22679.3 |
538 | 2022-08-20 18:07:35 | baggie | 3 | 112716 | 500 | 4.813 | 23419.1 |
537 | 2022-08-20 11:38:55 | baggie | 3 | 112716 | 500 | 5.280 | 21347.7 |
536 | 2022-08-01 14:32:50 | baggie | 3 | 112716 | 500 | 4.813 | 23419.1 |
535 | 2022-07-23 17:36:06 | baggie | 3 | 112716 | 500 | 4.640 | 24292.2 |
534 | 2022-07-08 20:54:29 | baggie | 2 | 82551 | 59 | 2.140 | 38575.2 |
533 | 2022-06-21 09:54:43 | baggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
532 | 2022-06-12 06:26:08 | baggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
531 | 2022-02-28 14:52:01 | baggie | 1 | 48755 | 5 | 1.140 | 42767.5 |
530 | 2022-02-24 12:27:05 | baggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
529 | 2022-02-17 20:14:30 | baggie | 2 | 82551 | 59 | 2.140 | 38575.2 |
528 | 2021-12-15 16:36:04 | baggie | 1 | 48755 | 5 | 0.843 | 57835.1 |
527 | 2021-11-28 18:41:27 | baggie | 2 | 82551 | 59 | 2.330 | 35429.6 |
526 | 2021-11-23 19:29:35 | baggie | 1 | 48755 | 5 | 0.843 | 57835.1 |