History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tavern"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
586 | 2024-04-27 10:09:04 | tavern | 1 | 48755 | 4 | 1.046 | 46610.9 |
585 | 2024-04-06 10:56:23 | tavern | 2 | 82551 | 54 | 7.486 | 11027.4 |
584 | 2024-03-25 07:42:43 | tavern | 1 | 48755 | 4 | 0.890 | 54780.9 |
583 | 2024-01-16 02:39:29 | tavern | 3 | 112716 | 690 | 5.716 | 19719.4 |
582 | 2023-12-20 15:25:59 | tavern | 1 | 48755 | 4 | 0.843 | 57835.1 |
581 | 2023-12-16 06:27:49 | tavern | 3 | 112716 | 690 | 5.016 | 22471.3 |
580 | 2023-12-07 15:08:33 | tavern | 2 | 82551 | 54 | 2.533 | 32590.2 |
579 | 2023-11-23 15:25:28 | tavern | 1 | 48755 | 4 | 0.763 | 63899.1 |
578 | 2023-11-22 21:16:34 | tavern | 1 | 48755 | 4 | 0.766 | 63648.8 |
577 | 2023-11-20 12:03:34 | tavern | 3 | 112716 | 690 | 5.033 | 22395.4 |
576 | 2023-11-20 12:03:32 | tavern | 2 | 82551 | 54 | 2.140 | 38575.2 |
575 | 2023-11-09 00:40:32 | tavern | 1 | 48755 | 4 | 0.856 | 56956.8 |
574 | 2023-11-03 16:36:02 | tavern | 1 | 48755 | 4 | 0.750 | 65006.7 |
573 | 2023-10-14 01:15:26 | tavern | 1 | 48755 | 4 | 0.750 | 65006.7 |
572 | 2023-10-08 00:10:04 | tavern | 1 | 48755 | 4 | 0.783 | 62266.9 |
571 | 2023-09-29 09:42:03 | tavern | 1 | 48755 | 4 | 0.750 | 65006.7 |
570 | 2023-09-14 02:41:50 | tavern | 1 | 48755 | 4 | 1.156 | 42175.6 |
569 | 2023-09-05 23:25:28 | tavern | 2 | 82551 | 54 | 2.500 | 33020.4 |
568 | 2023-08-04 13:49:14 | tavern | 1 | 48755 | 4 | 0.750 | 65006.7 |
567 | 2023-06-27 20:39:41 | tavern | 3 | 112716 | 690 | 4.953 | 22757.1 |
566 | 2023-05-25 08:07:28 | tavern | 2 | 82551 | 54 | 2.140 | 38575.2 |
565 | 2023-05-04 01:24:25 | tavern | 1 | 48755 | 4 | 0.750 | 65006.7 |
564 | 2023-05-01 21:49:14 | tavern | 3 | 112716 | 690 | 5.563 | 20261.7 |
563 | 2023-04-30 17:24:47 | tavern | 3 | 112716 | 690 | 5.376 | 20966.5 |
562 | 2023-04-28 12:55:54 | tavern | 3 | 112716 | 690 | 6.220 | 18121.5 |
561 | 2023-04-27 11:46:22 | tavern | 3 | 112716 | 690 | 10.920 | 10322.0 |
560 | 2023-04-26 13:13:07 | tavern | 3 | 112716 | 690 | 5.733 | 19660.9 |
559 | 2023-04-25 16:00:20 | tavern | 3 | 112716 | 690 | 5.296 | 21283.2 |
558 | 2023-04-24 23:33:09 | tavern | 3 | 112716 | 690 | 5.623 | 20045.5 |
557 | 2023-03-06 17:20:01 | tavern | 3 | 112716 | 690 | 4.720 | 23880.5 |
556 | 2023-03-06 11:53:06 | tavern | 2 | 82551 | 54 | 2.170 | 38041.9 |
555 | 2023-02-27 22:26:00 | tavern | 1 | 48755 | 4 | 0.750 | 65006.7 |
554 | 2023-02-01 14:58:54 | tavern | 3 | 112716 | 690 | 5.076 | 22205.7 |
553 | 2023-01-11 15:06:50 | tavern | 3 | 112716 | 690 | 5.330 | 21147.5 |
552 | 2022-12-24 07:00:49 | tavern | 1 | 48755 | 4 | 0.750 | 65006.7 |
551 | 2022-12-23 16:27:40 | tavern | 3 | 112716 | 690 | 4.670 | 24136.2 |
550 | 2022-12-16 20:24:29 | tavern | 3 | 112716 | 690 | 5.310 | 21227.1 |
549 | 2022-12-13 05:34:41 | tavern | 2 | 82551 | 54 | 2.156 | 38289.0 |
548 | 2022-09-10 10:48:49 | tavern | 1 | 48755 | 4 | 0.750 | 65006.7 |
547 | 2022-08-23 10:32:18 | tavern | 1 | 48755 | 4 | 0.846 | 57630.0 |
546 | 2022-07-30 21:55:59 | tavern | 2 | 82551 | 54 | 2.220 | 37185.1 |
545 | 2022-07-29 12:25:29 | tavern | 1 | 48755 | 4 | 0.860 | 56691.9 |
544 | 2022-07-28 13:31:58 | tavern | 2 | 82551 | 54 | 2.220 | 37185.1 |
543 | 2022-04-26 02:20:36 | tavern | 1 | 48755 | 4 | 0.936 | 52088.7 |
542 | 2022-04-23 19:25:16 | tavern | 1 | 48755 | 4 | 0.876 | 55656.4 |
541 | 2022-02-27 12:08:26 | tavern | 2 | 82551 | 54 | 2.190 | 37694.5 |
540 | 2022-02-18 20:05:04 | tavern | 2 | 82551 | 54 | 2.546 | 32423.8 |
539 | 2022-02-14 13:52:20 | tavern | 3 | 112716 | 690 | 5.986 | 18829.9 |
538 | 2022-01-15 05:59:54 | tavern | 1 | 48755 | 4 | 0.796 | 61250.0 |
537 | 2021-12-25 06:44:21 | tavern | 3 | 112716 | 690 | 4.750 | 23729.7 |
536 | 2021-12-16 10:38:36 | tavern | 1 | 48755 | 4 | 0.860 | 56691.9 |
535 | 2021-11-15 05:21:33 | tavern | 1 | 48755 | 4 | 0.763 | 63899.1 |
534 | 2021-11-11 11:42:53 | tavern | 3 | 112716 | 690 | 6.123 | 18408.6 |
533 | 2021-11-06 19:27:19 | tavern | 3 | 112716 | 690 | 5.390 | 20912.1 |
532 | 2021-10-29 23:54:12 | tavern | 3 | 112716 | 690 | 5.610 | 20092.0 |
531 | 2021-09-30 17:39:11 | tavern | 3 | 112716 | 690 | 5.563 | 20261.7 |
530 | 2021-09-29 18:40:58 | tavern | 3 | 112716 | 690 | 5.860 | 19234.8 |
529 | 2021-09-29 05:21:51 | tavern | 3 | 112716 | 690 | 5.346 | 21084.2 |
528 | 2021-09-28 16:32:11 | tavern | 1 | 48755 | 4 | 1.826 | 26700.4 |
527 | 2021-09-28 13:06:58 | tavern | 3 | 112716 | 690 | 4.780 | 23580.8 |
526 | 2021-09-27 15:30:07 | tavern | 3 | 112716 | 690 | 4.893 | 23036.2 |
525 | 2021-09-22 18:01:54 | tavern | 3 | 112716 | 690 | 5.580 | 20200.0 |
524 | 2021-09-21 09:48:07 | tavern | 3 | 112716 | 690 | 4.736 | 23799.8 |
523 | 2021-09-20 16:42:22 | tavern | 3 | 112716 | 690 | 4.720 | 23880.5 |
522 | 2021-09-19 13:47:40 | tavern | 3 | 112716 | 690 | 5.033 | 22395.4 |
521 | 2021-09-11 19:12:53 | tavern | 3 | 112716 | 690 | 4.923 | 22895.8 |
520 | 2021-09-11 06:22:28 | tavern | 3 | 112716 | 690 | 5.296 | 21283.2 |
519 | 2021-09-10 19:05:17 | tavern | 3 | 112716 | 690 | 5.530 | 20382.6 |
518 | 2021-08-31 13:20:43 | tavern | 1 | 48755 | 4 | 0.796 | 61250.0 |
517 | 2021-08-29 08:01:48 | tavern | 1 | 48755 | 4 | 0.780 | 62506.4 |
516 | 2021-08-27 03:37:17 | tavern | 1 | 48755 | 4 | 0.766 | 63648.8 |
515 | 2021-08-09 02:45:24 | tavern | 3 | 112716 | 690 | 4.783 | 23566.0 |
514 | 2021-08-06 10:10:58 | tavern | 3 | 112716 | 690 | 4.766 | 23650.0 |
513 | 2021-07-11 01:10:30 | tavern | 3 | 112716 | 690 | 4.970 | 22679.3 |
512 | 2021-07-02 19:56:17 | tavern | 3 | 112716 | 690 | 5.640 | 19985.1 |
511 | 2021-07-01 00:01:38 | tavern | 3 | 112716 | 690 | 5.233 | 21539.5 |
510 | 2021-06-24 09:10:12 | tavern | 3 | 112716 | 690 | 5.876 | 19182.4 |
509 | 2021-06-21 00:32:55 | tavern | 2 | 82551 | 54 | 2.423 | 34069.7 |
508 | 2021-06-19 18:35:58 | tavern | 2 | 82551 | 54 | 2.170 | 38041.9 |
507 | 2021-06-19 07:30:47 | tavern | 3 | 112716 | 690 | 5.436 | 20735.1 |
506 | 2021-06-10 21:07:43 | tavern | 2 | 82551 | 54 | 2.406 | 34310.5 |
505 | 2021-06-09 22:02:22 | tavern | 2 | 82551 | 54 | 2.546 | 32423.8 |
504 | 2021-06-06 22:40:36 | tavern | 2 | 82551 | 54 | 2.486 | 33206.4 |
503 | 2021-06-06 19:12:15 | tavern | 2 | 82551 | 54 | 2.406 | 34310.5 |
502 | 2021-06-06 03:37:47 | tavern | 2 | 82551 | 54 | 2.593 | 31836.1 |
501 | 2021-06-06 01:36:25 | tavern | 2 | 82551 | 54 | 2.483 | 33246.5 |
500 | 2021-06-05 18:34:50 | tavern | 2 | 82551 | 54 | 2.450 | 33694.3 |
499 | 2021-06-05 16:16:36 | tavern | 2 | 82551 | 54 | 2.593 | 31836.1 |
498 | 2021-06-05 09:44:32 | tavern | 2 | 82551 | 54 | 2.153 | 38342.3 |
497 | 2021-06-05 07:20:52 | tavern | 2 | 82551 | 54 | 2.736 | 30172.1 |
496 | 2021-06-04 11:49:17 | tavern | 2 | 82551 | 54 | 2.343 | 35233.0 |
495 | 2021-06-04 09:36:11 | tavern | 2 | 82551 | 54 | 2.470 | 33421.5 |
494 | 2021-06-03 01:16:12 | tavern | 2 | 82551 | 54 | 2.156 | 38289.0 |
493 | 2021-06-02 14:29:53 | tavern | 2 | 82551 | 54 | 2.173 | 37989.4 |
492 | 2021-06-02 03:43:57 | tavern | 2 | 82551 | 54 | 2.486 | 33206.4 |
491 | 2021-06-01 06:25:41 | tavern | 2 | 82551 | 54 | 2.610 | 31628.7 |
490 | 2021-06-01 03:52:03 | tavern | 2 | 82551 | 54 | 2.203 | 37472.1 |
489 | 2021-05-31 15:00:44 | tavern | 2 | 82551 | 54 | 2.233 | 36968.7 |
488 | 2021-05-31 13:20:29 | tavern | 2 | 82551 | 54 | 2.156 | 38289.0 |
487 | 2021-05-30 22:59:23 | tavern | 2 | 82551 | 54 | 2.500 | 33020.4 |