History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"potion"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
582 | 2024-03-30 08:07:05 | potion | 2 | 82551 | 58 | 2.593 | 31836.1 |
581 | 2024-03-30 07:18:37 | potion | 2 | 82551 | 58 | 5.420 | 15230.8 |
580 | 2024-03-30 07:18:09 | potion | 3 | 112716 | 581 | 9.313 | 12103.1 |
579 | 2024-03-28 22:39:19 | potion | 3 | 112716 | 581 | 6.546 | 17219.1 |
578 | 2024-03-28 18:03:02 | potion | 2 | 82551 | 58 | 8.250 | 10006.2 |
577 | 2024-03-28 17:40:46 | potion | 1 | 48755 | 7 | 0.940 | 51867.0 |
576 | 2024-03-28 14:17:19 | potion | 3 | 112716 | 581 | 5.546 | 20323.8 |
575 | 2024-03-28 14:17:21 | potion | 2 | 82551 | 58 | 2.576 | 32046.2 |
574 | 2024-03-26 18:15:58 | potion | 2 | 82551 | 58 | 2.546 | 32423.8 |
573 | 2024-03-26 18:13:34 | potion | 1 | 48755 | 7 | 0.876 | 55656.4 |
572 | 2024-03-26 18:12:57 | potion | 3 | 112716 | 581 | 6.033 | 18683.2 |
571 | 2024-03-23 00:05:35 | potion | 3 | 112716 | 581 | 4.783 | 23566.0 |
570 | 2024-02-29 04:30:07 | potion | 2 | 82551 | 58 | 2.356 | 35038.6 |
569 | 2024-02-29 04:09:08 | potion | 2 | 82551 | 58 | 2.266 | 36430.3 |
568 | 2024-02-29 04:08:48 | potion | 3 | 112716 | 581 | 6.266 | 17988.5 |
567 | 2024-02-28 07:01:04 | potion | 3 | 112716 | 581 | 17.956 | 6277.3 |
566 | 2024-02-27 21:23:25 | potion | 2 | 82551 | 58 | 5.110 | 16154.8 |
565 | 2024-02-27 11:35:17 | potion | 3 | 112716 | 581 | 5.826 | 19347.1 |
564 | 2024-02-27 11:35:16 | potion | 2 | 82551 | 58 | 2.470 | 33421.5 |
563 | 2024-02-18 21:04:06 | potion | 1 | 48755 | 7 | 0.966 | 50471.0 |
562 | 2024-01-20 07:36:29 | potion | 1 | 48755 | 7 | 0.906 | 53813.5 |
561 | 2024-01-02 21:37:09 | potion | 3 | 112716 | 581 | 5.610 | 20092.0 |
560 | 2024-01-02 21:37:07 | potion | 2 | 82551 | 58 | 2.623 | 31472.0 |
559 | 2023-12-14 14:35:56 | potion | 3 | 112716 | 581 | 4.966 | 22697.5 |
558 | 2023-12-14 14:35:54 | potion | 2 | 82551 | 58 | 2.296 | 35954.3 |
557 | 2023-12-03 20:38:51 | potion | 1 | 48755 | 7 | 0.826 | 59025.4 |
556 | 2023-12-03 20:38:50 | potion | 1 | 48755 | 7 | 0.860 | 56691.9 |
555 | 2023-12-03 10:13:35 | potion | 2 | 82551 | 58 | 2.623 | 31472.0 |
554 | 2023-12-02 11:50:28 | potion | 1 | 48755 | 7 | 0.826 | 59025.4 |
553 | 2023-11-27 17:44:19 | potion | 3 | 112716 | 581 | 4.796 | 23502.1 |
552 | 2023-11-13 22:43:12 | potion | 1 | 48755 | 7 | 0.843 | 57835.1 |
551 | 2023-11-11 21:21:13 | potion | 1 | 48755 | 7 | 0.860 | 56691.9 |
550 | 2023-11-05 09:37:00 | potion | 1 | 48755 | 7 | 0.750 | 65006.7 |
549 | 2023-10-25 05:25:36 | potion | 1 | 48755 | 7 | 0.750 | 65006.7 |
548 | 2023-10-19 21:12:06 | potion | 1 | 48755 | 7 | 0.783 | 62266.9 |
547 | 2023-10-11 20:09:48 | potion | 1 | 48755 | 7 | 0.923 | 52822.3 |
546 | 2023-10-04 00:36:03 | potion | 2 | 82551 | 58 | 8.686 | 9503.9 |
545 | 2023-10-04 00:36:03 | potion | 3 | 112716 | 581 | 6.813 | 16544.3 |
544 | 2023-09-30 15:11:12 | potion | 3 | 112716 | 581 | 4.796 | 23502.1 |
543 | 2023-09-30 15:11:04 | potion | 2 | 82551 | 58 | 2.156 | 38289.0 |
542 | 2023-09-29 15:48:04 | potion | 1 | 48755 | 7 | 0.750 | 65006.7 |
541 | 2023-09-24 22:12:19 | potion | 1 | 48755 | 7 | 0.750 | 65006.7 |
540 | 2023-09-22 07:32:58 | potion | 1 | 48755 | 7 | 0.890 | 54780.9 |
539 | 2023-09-16 04:50:42 | potion | 1 | 48755 | 7 | 0.826 | 59025.4 |
538 | 2023-08-31 10:46:57 | potion | 2 | 82551 | 58 | 2.140 | 38575.2 |
537 | 2023-08-26 09:06:12 | potion | 3 | 112716 | 581 | 4.796 | 23502.1 |
536 | 2023-07-05 03:44:56 | potion | 1 | 48755 | 7 | 0.753 | 64747.7 |
535 | 2023-06-12 13:44:42 | potion | 1 | 48755 | 7 | 0.796 | 61250.0 |
534 | 2023-06-09 06:50:09 | potion | 1 | 48755 | 7 | 0.750 | 65006.7 |
533 | 2023-05-18 00:33:09 | potion | 2 | 82551 | 58 | 2.126 | 38829.3 |
532 | 2023-05-13 05:59:03 | potion | 3 | 112716 | 581 | 4.273 | 26378.7 |
531 | 2023-04-10 23:44:15 | potion | 1 | 48755 | 7 | 0.750 | 65006.7 |
530 | 2023-02-25 05:35:16 | potion | 2 | 82551 | 58 | 2.123 | 38884.1 |
529 | 2023-02-24 14:23:07 | potion | 1 | 48755 | 7 | 0.763 | 63899.1 |
528 | 2023-02-21 19:37:20 | potion | 3 | 112716 | 581 | 4.763 | 23664.9 |
527 | 2023-01-31 15:18:39 | potion | 1 | 48755 | 7 | 0.750 | 65006.7 |
526 | 2022-12-06 04:24:31 | potion | 2 | 82551 | 58 | 2.533 | 32590.2 |
525 | 2022-12-03 02:12:45 | potion | 3 | 112716 | 581 | 4.736 | 23799.8 |
524 | 2022-11-29 06:08:09 | potion | 1 | 48755 | 7 | 0.826 | 59025.4 |
523 | 2022-11-04 05:47:34 | potion | 1 | 48755 | 7 | 0.760 | 64151.3 |
522 | 2022-08-27 02:23:49 | potion | 3 | 112716 | 581 | 5.080 | 22188.2 |
521 | 2022-07-23 22:52:30 | potion | 1 | 48755 | 7 | 0.766 | 63648.8 |
520 | 2022-07-21 23:29:51 | potion | 1 | 48755 | 7 | 0.876 | 55656.4 |
519 | 2022-07-08 09:08:02 | potion | 3 | 112716 | 581 | 6.126 | 18399.6 |
518 | 2022-04-15 09:44:58 | potion | 3 | 112716 | 581 | 6.000 | 18786.0 |
517 | 2022-04-09 14:16:42 | potion | 2 | 82551 | 58 | 2.153 | 38342.3 |
516 | 2022-03-31 04:26:29 | potion | 1 | 48755 | 7 | 1.013 | 48129.3 |
515 | 2022-03-23 05:47:51 | potion | 1 | 48755 | 7 | 0.766 | 63648.8 |
514 | 2022-01-27 21:55:06 | potion | 1 | 48755 | 7 | 0.766 | 63648.8 |
513 | 2022-01-13 04:58:41 | potion | 1 | 48755 | 7 | 0.830 | 58741.0 |
512 | 2022-01-12 09:42:46 | potion | 1 | 48755 | 7 | 0.766 | 63648.8 |
511 | 2022-01-11 21:47:33 | potion | 1 | 48755 | 7 | 0.920 | 52994.6 |
510 | 2022-01-11 04:52:44 | potion | 1 | 48755 | 7 | 0.813 | 59969.2 |
509 | 2022-01-10 14:24:33 | potion | 1 | 48755 | 7 | 0.796 | 61250.0 |
508 | 2022-01-09 20:10:39 | potion | 1 | 48755 | 7 | 0.906 | 53813.5 |
507 | 2022-01-09 11:32:00 | potion | 1 | 48755 | 7 | 0.906 | 53813.5 |
506 | 2021-12-31 18:45:52 | potion | 1 | 48755 | 7 | 0.890 | 54780.9 |
505 | 2021-12-30 19:22:58 | potion | 1 | 48755 | 7 | 0.910 | 53576.9 |
504 | 2021-12-29 17:30:31 | potion | 1 | 48755 | 7 | 0.813 | 59969.2 |
503 | 2021-12-29 02:52:25 | potion | 1 | 48755 | 7 | 0.826 | 59025.4 |
502 | 2021-12-28 18:27:29 | potion | 1 | 48755 | 7 | 0.766 | 63648.8 |
501 | 2021-12-27 16:37:10 | potion | 1 | 48755 | 7 | 0.766 | 63648.8 |
500 | 2021-12-26 16:18:21 | potion | 1 | 48755 | 7 | 0.843 | 57835.1 |
499 | 2021-12-25 11:15:02 | potion | 1 | 48755 | 7 | 0.923 | 52822.3 |
498 | 2021-12-24 11:45:16 | potion | 1 | 48755 | 7 | 0.890 | 54780.9 |
497 | 2021-12-22 23:56:30 | potion | 3 | 112716 | 581 | 5.780 | 19501.0 |
496 | 2021-12-17 07:26:37 | potion | 1 | 48755 | 7 | 0.873 | 55847.7 |
495 | 2021-12-16 18:44:44 | potion | 1 | 48755 | 7 | 0.953 | 51159.5 |
494 | 2021-12-16 16:53:40 | potion | 1 | 48755 | 7 | 0.750 | 65006.7 |
493 | 2021-12-16 05:04:54 | potion | 1 | 48755 | 7 | 0.766 | 63648.8 |
492 | 2021-12-15 16:08:48 | potion | 1 | 48755 | 7 | 0.843 | 57835.1 |
491 | 2021-12-15 01:05:46 | potion | 1 | 48755 | 7 | 0.750 | 65006.7 |
490 | 2021-12-14 15:19:35 | potion | 1 | 48755 | 7 | 0.843 | 57835.1 |
489 | 2021-11-15 15:26:23 | potion | 1 | 48755 | 7 | 0.890 | 54780.9 |
488 | 2021-11-15 02:08:16 | potion | 1 | 48755 | 7 | 0.763 | 63899.1 |
487 | 2021-11-14 15:38:15 | potion | 1 | 48755 | 7 | 0.890 | 54780.9 |
486 | 2021-11-14 01:01:58 | potion | 1 | 48755 | 7 | 0.780 | 62506.4 |
485 | 2021-11-13 16:25:18 | potion | 1 | 48755 | 7 | 1.830 | 26642.1 |
484 | 2021-11-13 02:24:10 | potion | 1 | 48755 | 7 | 0.953 | 51159.5 |
483 | 2021-11-12 16:21:43 | potion | 1 | 48755 | 7 | 0.860 | 56691.9 |