History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"beastie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
607 | 2024-04-26 13:44:10 | beastie | 1 | 69583 | 3 | 2.390 | 29114.2 |
606 | 2024-04-26 11:58:48 | beastie | 2 | 107671 | 20 | 10.360 | 10393.0 |
605 | 2024-04-26 11:39:27 | beastie | 3 | 134027 | 274 | 8.123 | 16499.7 |
604 | 2024-04-23 08:01:50 | beastie | 3 | 134027 | 274 | 13.733 | 9759.5 |
603 | 2024-04-21 07:50:16 | beastie | 3 | 134027 | 274 | 20.846 | 6429.4 |
602 | 2024-04-20 16:05:04 | beastie | 3 | 134027 | 274 | 24.033 | 5576.8 |
601 | 2024-04-19 15:58:22 | beastie | 3 | 134027 | 274 | 7.953 | 16852.4 |
600 | 2024-04-19 15:57:39 | beastie | 3 | 134027 | 274 | 18.330 | 7311.9 |
599 | 2024-04-18 18:48:33 | beastie | 3 | 134027 | 274 | 13.766 | 9736.1 |
598 | 2024-04-16 00:21:06 | beastie | 3 | 134027 | 274 | 6.766 | 19808.9 |
597 | 2024-03-26 03:15:14 | beastie | 2 | 107671 | 20 | 7.110 | 15143.6 |
596 | 2024-03-26 03:13:13 | beastie | 3 | 134027 | 274 | 8.250 | 16245.7 |
595 | 2024-03-22 18:35:52 | beastie | 3 | 134027 | 274 | 7.406 | 18097.1 |
594 | 2024-03-22 18:35:55 | beastie | 2 | 107671 | 20 | 3.656 | 29450.5 |
593 | 2024-03-22 06:43:57 | beastie | 2 | 107671 | 20 | 6.923 | 15552.7 |
592 | 2024-03-22 06:43:37 | beastie | 3 | 134027 | 274 | 7.063 | 18975.9 |
591 | 2024-03-21 17:32:15 | beastie | 3 | 134027 | 274 | 11.920 | 11243.9 |
590 | 2024-03-16 15:32:21 | beastie | 1 | 69583 | 3 | 4.016 | 17326.4 |
589 | 2024-03-11 02:12:09 | beastie | 3 | 134027 | 274 | 16.703 | 8024.1 |
588 | 2024-03-11 01:27:20 | beastie | 3 | 134027 | 274 | 20.876 | 6420.1 |
587 | 2024-03-10 20:12:10 | beastie | 3 | 134027 | 274 | 17.566 | 7629.9 |
586 | 2024-03-10 20:12:07 | beastie | 2 | 107671 | 20 | 8.063 | 13353.7 |
585 | 2024-03-10 20:11:54 | beastie | 1 | 69583 | 3 | 2.843 | 24475.2 |
584 | 2024-02-12 20:24:19 | beastie | 3 | 134027 | 274 | 6.250 | 21444.3 |
583 | 2024-02-09 14:49:57 | beastie | 1 | 69583 | 3 | 1.220 | 57035.2 |
582 | 2024-02-03 03:20:38 | beastie | 2 | 107671 | 20 | 5.750 | 18725.4 |
581 | 2024-02-03 03:19:38 | beastie | 3 | 134027 | 274 | 6.546 | 20474.6 |
580 | 2024-02-02 23:31:57 | beastie | 2 | 107671 | 20 | 3.720 | 28943.8 |
579 | 2024-02-02 23:31:25 | beastie | 3 | 134027 | 274 | 7.063 | 18975.9 |
578 | 2024-02-02 23:02:23 | beastie | 2 | 107671 | 20 | 3.766 | 28590.3 |
577 | 2024-02-02 23:01:23 | beastie | 3 | 134027 | 274 | 7.203 | 18607.1 |
576 | 2024-01-15 16:05:26 | beastie | 3 | 134027 | 274 | 6.296 | 21287.6 |
575 | 2024-01-15 16:05:24 | beastie | 2 | 107671 | 20 | 3.233 | 33303.7 |
574 | 2024-01-14 23:16:49 | beastie | 1 | 69583 | 3 | 1.173 | 59320.5 |
573 | 2024-01-08 18:02:14 | beastie | 1 | 69583 | 3 | 1.093 | 63662.4 |
572 | 2023-12-18 00:07:22 | beastie | 2 | 107671 | 20 | 2.983 | 36094.9 |
571 | 2023-12-15 11:15:30 | beastie | 3 | 134027 | 274 | 6.000 | 22337.8 |
570 | 2023-12-09 12:19:48 | beastie | 1 | 69583 | 3 | 1.096 | 63488.1 |
569 | 2023-12-05 23:10:07 | beastie | 1 | 69583 | 3 | 1.420 | 49002.1 |
568 | 2023-12-05 06:16:44 | beastie | 3 | 134027 | 274 | 6.343 | 21129.9 |
567 | 2023-12-05 06:16:41 | beastie | 2 | 107671 | 20 | 3.283 | 32796.5 |
566 | 2023-11-17 04:01:58 | beastie | 1 | 69583 | 3 | 1.063 | 65459.1 |
565 | 2023-11-10 12:39:45 | beastie | 1 | 69583 | 3 | 1.076 | 64668.2 |
564 | 2023-11-10 01:43:38 | beastie | 1 | 69583 | 3 | 1.080 | 64428.7 |
563 | 2023-11-09 22:58:35 | beastie | 1 | 69583 | 3 | 2.140 | 32515.4 |
562 | 2023-10-24 10:44:29 | beastie | 1 | 69583 | 3 | 1.203 | 57841.2 |
561 | 2023-10-17 19:14:04 | beastie | 1 | 69583 | 3 | 1.140 | 61037.7 |
560 | 2023-09-28 12:52:10 | beastie | 3 | 134027 | 274 | 9.530 | 14063.7 |
559 | 2023-09-26 12:22:15 | beastie | 1 | 69583 | 3 | 1.220 | 57035.2 |
558 | 2023-09-24 12:04:32 | beastie | 1 | 69583 | 3 | 1.296 | 53690.6 |
557 | 2023-09-18 15:42:00 | beastie | 2 | 107671 | 20 | 3.250 | 33129.5 |
556 | 2023-09-15 22:25:38 | beastie | 3 | 134027 | 274 | 7.656 | 17506.1 |
555 | 2023-08-30 21:15:46 | beastie | 1 | 69583 | 3 | 1.063 | 65459.1 |
554 | 2023-08-20 05:56:54 | beastie | 1 | 69583 | 3 | 1.390 | 50059.7 |
553 | 2023-08-16 20:54:30 | beastie | 1 | 69583 | 3 | 1.080 | 64428.7 |
552 | 2023-06-17 08:33:17 | beastie | 2 | 107671 | 20 | 2.830 | 38046.3 |
551 | 2023-06-17 01:38:34 | beastie | 3 | 134027 | 274 | 6.623 | 20236.6 |
550 | 2023-06-02 12:28:23 | beastie | 1 | 69583 | 3 | 1.046 | 66522.9 |
549 | 2023-05-02 13:10:01 | beastie | 1 | 69583 | 3 | 1.203 | 57841.2 |
548 | 2023-03-24 22:51:38 | beastie | 1 | 69583 | 3 | 1.063 | 65459.1 |
547 | 2023-03-15 10:08:59 | beastie | 2 | 107671 | 20 | 3.390 | 31761.4 |
546 | 2023-03-14 21:58:30 | beastie | 3 | 134027 | 274 | 5.906 | 22693.4 |
545 | 2023-02-24 08:18:48 | beastie | 3 | 134027 | 274 | 5.873 | 22820.9 |
544 | 2023-01-16 12:15:15 | beastie | 1 | 69583 | 3 | 1.080 | 64428.7 |
543 | 2023-01-13 23:32:23 | beastie | 3 | 134027 | 274 | 5.830 | 22989.2 |
542 | 2023-01-12 19:24:44 | beastie | 1 | 69583 | 3 | 1.063 | 65459.1 |
541 | 2023-01-05 16:48:43 | beastie | 3 | 134027 | 274 | 6.343 | 21129.9 |
540 | 2023-01-03 19:02:14 | beastie | 3 | 134027 | 274 | 6.500 | 20619.5 |
539 | 2022-12-21 16:08:05 | beastie | 2 | 107671 | 20 | 2.813 | 38276.2 |
538 | 2022-12-17 09:42:59 | beastie | 2 | 107671 | 20 | 2.826 | 38100.1 |
537 | 2022-12-16 23:01:41 | beastie | 3 | 134027 | 274 | 6.393 | 20964.6 |
536 | 2022-11-22 01:46:41 | beastie | 3 | 134027 | 274 | 5.950 | 22525.5 |
535 | 2022-11-18 05:37:32 | beastie | 3 | 134027 | 274 | 5.843 | 22938.0 |
534 | 2022-11-14 19:21:37 | beastie | 2 | 107671 | 20 | 3.233 | 33303.7 |
533 | 2022-11-05 00:29:57 | beastie | 3 | 134027 | 274 | 5.983 | 22401.3 |
532 | 2022-10-31 06:03:09 | beastie | 3 | 134027 | 274 | 6.703 | 19995.1 |
531 | 2022-10-30 09:20:49 | beastie | 3 | 134027 | 274 | 14.563 | 9203.3 |
530 | 2022-10-29 22:23:03 | beastie | 3 | 134027 | 274 | 7.170 | 18692.7 |
529 | 2022-10-29 11:17:28 | beastie | 3 | 134027 | 274 | 7.220 | 18563.3 |
528 | 2022-10-29 00:15:26 | beastie | 3 | 134027 | 274 | 6.470 | 20715.1 |
527 | 2022-10-28 10:39:06 | beastie | 3 | 134027 | 274 | 5.736 | 23365.9 |
526 | 2022-10-27 23:03:55 | beastie | 3 | 134027 | 274 | 6.233 | 21502.8 |
525 | 2022-10-27 11:29:20 | beastie | 3 | 134027 | 274 | 7.030 | 19065.0 |
524 | 2022-10-27 02:26:45 | beastie | 3 | 134027 | 274 | 5.703 | 23501.1 |
523 | 2022-10-27 00:13:33 | beastie | 3 | 134027 | 274 | 6.703 | 19995.1 |
522 | 2022-10-26 23:44:45 | beastie | 3 | 134027 | 274 | 6.626 | 20227.4 |
521 | 2022-10-26 11:58:17 | beastie | 3 | 134027 | 274 | 6.456 | 20760.1 |
520 | 2022-10-25 11:52:04 | beastie | 3 | 134027 | 274 | 7.686 | 17437.8 |
519 | 2022-10-25 00:52:40 | beastie | 3 | 134027 | 274 | 5.986 | 22390.1 |
518 | 2022-10-24 14:08:35 | beastie | 3 | 134027 | 274 | 6.000 | 22337.8 |
517 | 2022-10-24 00:01:32 | beastie | 3 | 134027 | 274 | 5.813 | 23056.4 |
516 | 2022-10-23 13:08:32 | beastie | 3 | 134027 | 274 | 6.423 | 20866.7 |
515 | 2022-10-23 01:29:26 | beastie | 3 | 134027 | 274 | 5.780 | 23188.1 |
514 | 2022-10-22 16:37:57 | beastie | 3 | 134027 | 274 | 6.593 | 20328.7 |
513 | 2022-10-22 05:16:00 | beastie | 3 | 134027 | 274 | 5.736 | 23365.9 |
512 | 2022-10-21 13:19:09 | beastie | 3 | 134027 | 274 | 5.953 | 22514.2 |
511 | 2022-10-20 21:45:04 | beastie | 3 | 134027 | 274 | 6.220 | 21547.7 |
510 | 2022-10-20 01:39:32 | beastie | 3 | 134027 | 274 | 6.673 | 20085.0 |
509 | 2022-10-19 14:18:37 | beastie | 3 | 134027 | 274 | 6.970 | 19229.1 |
508 | 2022-10-19 00:14:00 | beastie | 3 | 134027 | 274 | 7.410 | 18087.3 |