History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shingle"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
624 | 2024-05-05 17:17:39 | shingle | 1 | 69583 | 7 | 1.233 | 56433.9 |
623 | 2024-04-30 14:13:29 | shingle | 1 | 69583 | 7 | 1.373 | 50679.5 |
622 | 2024-04-27 03:18:46 | shingle | 1 | 69583 | 7 | 1.390 | 50059.7 |
621 | 2024-04-03 13:14:52 | shingle | 1 | 69583 | 7 | 3.000 | 23194.3 |
620 | 2024-03-28 12:54:25 | shingle | 1 | 69583 | 7 | 2.623 | 26528.0 |
619 | 2024-01-14 05:07:05 | shingle | 2 | 107671 | 34 | 3.110 | 34620.9 |
618 | 2024-01-09 00:09:09 | shingle | 3 | 134027 | 297 | 6.986 | 19185.1 |
617 | 2024-01-07 19:40:40 | shingle | 1 | 69583 | 7 | 1.186 | 58670.3 |
616 | 2023-12-31 23:14:18 | shingle | 1 | 69583 | 7 | 1.233 | 56433.9 |
615 | 2023-12-08 07:10:38 | shingle | 3 | 134027 | 297 | 6.030 | 22226.7 |
614 | 2023-12-08 07:10:36 | shingle | 2 | 107671 | 34 | 3.016 | 35699.9 |
613 | 2023-12-04 00:56:03 | shingle | 1 | 69583 | 7 | 1.203 | 57841.2 |
612 | 2023-12-02 12:50:49 | shingle | 1 | 69583 | 7 | 1.203 | 57841.2 |
611 | 2023-11-11 01:17:05 | shingle | 1 | 69583 | 7 | 1.233 | 56433.9 |
610 | 2023-11-06 03:11:54 | shingle | 1 | 69583 | 7 | 1.173 | 59320.5 |
609 | 2023-10-30 13:20:44 | shingle | 1 | 69583 | 7 | 1.220 | 57035.2 |
608 | 2023-10-22 14:39:35 | shingle | 2 | 107671 | 34 | 2.813 | 38276.2 |
607 | 2023-10-19 00:38:19 | shingle | 1 | 69583 | 7 | 1.093 | 63662.4 |
606 | 2023-10-13 07:45:57 | shingle | 3 | 134027 | 297 | 5.640 | 23763.7 |
605 | 2023-09-26 11:43:07 | shingle | 1 | 69583 | 7 | 1.186 | 58670.3 |
604 | 2023-09-11 23:58:14 | shingle | 1 | 69583 | 7 | 1.173 | 59320.5 |
603 | 2023-08-28 11:53:18 | shingle | 1 | 69583 | 7 | 1.266 | 54962.9 |
602 | 2023-08-23 15:07:58 | shingle | 1 | 69583 | 7 | 1.156 | 60192.9 |
601 | 2023-08-02 12:18:52 | shingle | 2 | 107671 | 34 | 3.143 | 34257.4 |
600 | 2023-07-23 22:21:15 | shingle | 3 | 134027 | 297 | 5.606 | 23907.8 |
599 | 2023-05-25 13:33:23 | shingle | 1 | 69583 | 7 | 1.063 | 65459.1 |
598 | 2023-05-07 18:59:15 | shingle | 1 | 69583 | 7 | 2.360 | 29484.3 |
597 | 2023-04-10 10:02:25 | shingle | 2 | 107671 | 34 | 3.203 | 33615.7 |
596 | 2023-04-05 09:02:43 | shingle | 3 | 134027 | 297 | 5.703 | 23501.1 |
595 | 2023-03-20 09:31:43 | shingle | 1 | 69583 | 7 | 1.063 | 65459.1 |
594 | 2023-01-14 09:39:39 | shingle | 2 | 107671 | 34 | 2.830 | 38046.3 |
593 | 2023-01-10 12:14:37 | shingle | 1 | 69583 | 7 | 1.076 | 64668.2 |
592 | 2023-01-07 10:23:08 | shingle | 1 | 69583 | 7 | 1.080 | 64428.7 |
591 | 2023-01-06 19:45:57 | shingle | 1 | 69583 | 7 | 1.063 | 65459.1 |
590 | 2023-01-02 06:17:29 | shingle | 3 | 134027 | 297 | 6.440 | 20811.6 |
589 | 2022-10-19 17:36:08 | shingle | 2 | 107671 | 34 | 3.220 | 33438.2 |
588 | 2022-10-01 03:47:53 | shingle | 1 | 69583 | 7 | 1.093 | 63662.4 |
587 | 2022-09-12 06:31:15 | shingle | 1 | 69583 | 7 | 1.110 | 62687.4 |
586 | 2022-09-06 06:59:28 | shingle | 3 | 134027 | 297 | 6.766 | 19808.9 |
585 | 2022-09-04 04:16:36 | shingle | 3 | 134027 | 297 | 5.736 | 23365.9 |
584 | 2022-05-21 19:29:49 | shingle | 2 | 107671 | 34 | 2.796 | 38508.9 |
583 | 2022-05-16 04:04:13 | shingle | 1 | 69583 | 7 | 1.186 | 58670.3 |
582 | 2022-05-06 15:31:22 | shingle | 1 | 69583 | 7 | 1.250 | 55666.4 |
581 | 2022-03-31 20:55:59 | shingle | 3 | 134027 | 297 | 6.750 | 19855.9 |
580 | 2022-01-30 17:57:25 | shingle | 1 | 69583 | 7 | 1.203 | 57841.2 |
579 | 2022-01-28 14:59:34 | shingle | 1 | 69583 | 7 | 1.110 | 62687.4 |
578 | 2022-01-25 22:48:54 | shingle | 1 | 69583 | 7 | 1.110 | 62687.4 |
577 | 2022-01-16 21:20:53 | shingle | 2 | 107671 | 34 | 2.843 | 37872.3 |
576 | 2021-12-12 08:50:23 | shingle | 3 | 134027 | 297 | 6.546 | 20474.6 |
575 | 2021-11-23 20:46:12 | shingle | 1 | 69583 | 7 | 1.110 | 62687.4 |
574 | 2021-11-08 12:25:48 | shingle | 2 | 107671 | 34 | 3.390 | 31761.4 |
573 | 2021-10-12 14:20:52 | shingle | 1 | 69583 | 7 | 1.546 | 45008.4 |
572 | 2021-10-11 15:52:17 | shingle | 1 | 69583 | 7 | 1.126 | 61796.6 |
571 | 2021-10-09 13:29:58 | shingle | 1 | 69583 | 7 | 1.250 | 55666.4 |
570 | 2021-09-18 09:53:32 | shingle | 1 | 69583 | 7 | 1.296 | 53690.6 |
569 | 2021-09-11 00:04:16 | shingle | 1 | 69583 | 7 | 1.093 | 63662.4 |
568 | 2021-09-10 21:22:34 | shingle | 1 | 69583 | 7 | 1.356 | 51314.9 |
567 | 2021-07-11 11:42:15 | shingle | 1 | 69583 | 7 | 1.093 | 63662.4 |
566 | 2021-06-26 14:57:26 | shingle | 1 | 69583 | 7 | 1.266 | 54962.9 |
565 | 2021-04-26 18:44:11 | shingle | 1 | 69583 | 7 | 1.170 | 59472.6 |
564 | 2021-04-07 13:11:32 | shingle | 1 | 69583 | 7 | 1.436 | 48456.1 |
563 | 2021-04-03 09:32:49 | shingle | 1 | 69583 | 7 | 1.483 | 46920.4 |
562 | 2021-03-26 23:27:37 | shingle | 1 | 69583 | 7 | 1.296 | 53690.6 |
561 | 2021-01-10 05:42:39 | shingle | 1 | 69583 | 7 | 1.106 | 62914.1 |
560 | 2020-12-18 13:55:59 | shingle | 1 | 69583 | 7 | 1.153 | 60349.5 |
559 | 2020-12-11 16:18:57 | shingle | 1 | 69583 | 7 | 1.106 | 62914.1 |
558 | 2020-12-09 06:25:26 | shingle | 3 | 134027 | 297 | 11.470 | 11685.0 |
557 | 2020-11-05 17:10:15 | shingle | 3 | 134027 | 297 | 12.343 | 10858.5 |
556 | 2020-10-31 15:28:05 | shingle | 2 | 107671 | 34 | 2.813 | 38276.2 |
555 | 2020-10-28 20:28:40 | shingle | 2 | 107671 | 34 | 2.860 | 37647.2 |
554 | 2020-10-06 14:50:08 | shingle | 1 | 69583 | 7 | 1.080 | 64428.7 |
553 | 2020-10-06 10:53:38 | shingle | 1 | 69583 | 7 | 1.140 | 61037.7 |
552 | 2020-09-14 14:00:54 | shingle | 1 | 69583 | 7 | 1.140 | 61037.7 |
551 | 2020-09-07 03:08:02 | shingle | 1 | 69583 | 7 | 1.216 | 57222.9 |
550 | 2020-08-03 05:10:03 | shingle | 1 | 69583 | 7 | 1.110 | 62687.4 |
549 | 2020-08-03 02:17:11 | shingle | 1 | 69583 | 7 | 1.233 | 56433.9 |
548 | 2020-07-29 13:52:10 | shingle | 1 | 69583 | 7 | 1.173 | 59320.5 |
547 | 2020-07-26 13:28:45 | shingle | 1 | 69583 | 7 | 1.250 | 55666.4 |
546 | 2020-07-23 14:52:10 | shingle | 1 | 69583 | 7 | 1.126 | 61796.6 |
545 | 2020-07-16 14:07:43 | shingle | 1 | 69583 | 7 | 1.326 | 52475.9 |
544 | 2020-06-08 08:21:07 | shingle | 1 | 69583 | 7 | 1.110 | 62687.4 |
543 | 2020-03-26 18:24:20 | shingle | 1 | 69583 | 7 | 1.250 | 55666.4 |
542 | 2020-03-21 03:39:58 | shingle | 1 | 69583 | 7 | 1.236 | 56296.9 |
541 | 2020-03-06 20:00:19 | shingle | 1 | 69583 | 7 | 1.063 | 65459.1 |
540 | 2020-02-29 06:57:01 | shingle | 1 | 69583 | 7 | 1.453 | 47889.2 |
539 | 2020-02-27 23:56:06 | shingle | 1 | 69583 | 7 | 1.280 | 54361.7 |
538 | 2020-02-23 10:48:07 | shingle | 1 | 69583 | 7 | 4.203 | 16555.6 |
537 | 2020-02-09 18:45:26 | shingle | 1 | 69583 | 7 | 2.156 | 32274.1 |
536 | 2020-02-07 08:12:09 | shingle | 1 | 69583 | 7 | 1.326 | 52475.9 |
535 | 2020-02-05 03:19:33 | shingle | 1 | 69583 | 7 | 2.703 | 25742.9 |
534 | 2020-02-03 09:59:51 | shingle | 1 | 69583 | 7 | 2.906 | 23944.6 |
533 | 2020-01-31 12:30:09 | shingle | 1 | 69583 | 7 | 2.250 | 30925.8 |
532 | 2020-01-27 14:04:04 | shingle | 1 | 69583 | 7 | 1.376 | 50569.0 |
531 | 2020-01-16 17:38:43 | shingle | 1 | 69583 | 7 | 1.236 | 56296.9 |
530 | 2020-01-15 23:42:27 | shingle | 1 | 69583 | 7 | 2.813 | 24736.2 |
529 | 2020-01-12 22:52:04 | shingle | 1 | 69583 | 7 | 1.220 | 57035.2 |
528 | 2020-01-12 15:33:46 | shingle | 1 | 69583 | 7 | 1.153 | 60349.5 |
527 | 2020-01-07 03:04:14 | shingle | 1 | 69583 | 7 | 3.360 | 20709.2 |
526 | 2020-01-01 11:38:25 | shingle | 1 | 69583 | 7 | 1.326 | 52475.9 |
525 | 2019-12-27 22:08:51 | shingle | 1 | 69583 | 7 | 1.313 | 52995.4 |