History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"speared"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
622 | 2025-07-13 10:43:42 | speared | 1 | 69583 | 9 | 2.626 | 26497.7 |
621 | 2025-07-12 21:49:13 | speared | 1 | 69583 | 9 | 2.626 | 26497.7 |
620 | 2025-07-11 13:47:11 | speared | 3 | 134027 | 706 | 31.110 | 4308.2 |
619 | 2025-07-11 03:15:36 | speared | 1 | 69583 | 9 | 3.000 | 23194.3 |
618 | 2025-07-10 06:59:47 | speared | 3 | 134027 | 706 | 30.310 | 4421.9 |
617 | 2025-07-09 09:12:09 | speared | 2 | 107671 | 89 | 3.453 | 31181.9 |
616 | 2025-07-09 04:46:56 | speared | 3 | 134027 | 706 | 34.316 | 3905.7 |
615 | 2025-07-07 08:13:52 | speared | 1 | 69583 | 9 | 4.393 | 15839.5 |
614 | 2025-07-06 02:58:34 | speared | 1 | 69583 | 9 | 1.250 | 55666.4 |
613 | 2025-07-06 02:58:15 | speared | 2 | 107671 | 89 | 3.346 | 32179.0 |
612 | 2025-07-03 05:40:43 | speared | 1 | 69583 | 9 | 7.513 | 9261.7 |
611 | 2025-07-02 02:46:38 | speared | 1 | 69583 | 9 | 8.173 | 8513.8 |
610 | 2025-06-25 16:01:15 | speared | 1 | 69583 | 9 | 1.220 | 57035.2 |
609 | 2025-06-24 18:43:47 | speared | 1 | 69583 | 9 | 1.296 | 53690.6 |
608 | 2025-06-21 04:16:44 | speared | 3 | 134027 | 706 | 8.233 | 16279.2 |
607 | 2025-06-20 00:50:04 | speared | 1 | 69583 | 9 | 6.280 | 11080.1 |
606 | 2025-06-13 22:22:34 | speared | 1 | 69583 | 9 | 5.563 | 12508.2 |
605 | 2025-06-11 21:46:52 | speared | 1 | 69583 | 9 | 2.970 | 23428.6 |
604 | 2025-06-11 19:48:26 | speared | 1 | 69583 | 9 | 1.186 | 58670.3 |
603 | 2025-06-10 13:43:18 | speared | 1 | 69583 | 9 | 8.670 | 8025.7 |
602 | 2025-06-06 00:25:41 | speared | 1 | 69583 | 9 | 3.313 | 21003.0 |
601 | 2025-06-04 22:55:42 | speared | 1 | 69583 | 9 | 8.813 | 7895.5 |
600 | 2025-06-04 16:40:57 | speared | 3 | 134027 | 706 | 38.080 | 3519.6 |
599 | 2025-06-02 17:12:48 | speared | 3 | 134027 | 706 | 40.080 | 3344.0 |
598 | 2025-06-02 07:58:37 | speared | 1 | 69583 | 9 | 3.576 | 19458.3 |
597 | 2025-06-02 05:33:52 | speared | 3 | 134027 | 706 | 51.190 | 2618.2 |
596 | 2025-06-01 13:20:11 | speared | 1 | 69583 | 9 | 4.563 | 15249.4 |
595 | 2025-06-01 08:58:34 | speared | 3 | 134027 | 706 | 6.813 | 19672.2 |
594 | 2025-05-31 20:16:38 | speared | 1 | 69583 | 9 | 8.203 | 8482.6 |
593 | 2025-05-31 02:13:58 | speared | 1 | 69583 | 9 | 2.596 | 26803.9 |
592 | 2025-05-27 03:18:00 | speared | 3 | 134027 | 706 | 27.300 | 4909.4 |
591 | 2025-05-25 02:52:39 | speared | 3 | 134027 | 706 | 7.140 | 18771.3 |
590 | 2025-05-24 23:33:16 | speared | 1 | 69583 | 9 | 2.470 | 28171.3 |
589 | 2025-05-24 19:42:18 | speared | 3 | 134027 | 706 | 37.860 | 3540.1 |
588 | 2025-05-20 00:35:43 | speared | 1 | 69583 | 9 | 4.703 | 14795.4 |
587 | 2025-05-19 11:36:37 | speared | 1 | 69583 | 9 | 1.280 | 54361.7 |
586 | 2025-05-17 10:15:22 | speared | 3 | 134027 | 706 | 9.533 | 14059.3 |
585 | 2025-05-17 01:46:52 | speared | 3 | 134027 | 706 | 25.800 | 5194.8 |
584 | 2025-05-13 23:17:58 | speared | 1 | 69583 | 9 | 2.640 | 26357.2 |
583 | 2025-05-13 17:48:17 | speared | 1 | 69583 | 9 | 1.376 | 50569.0 |
582 | 2025-05-12 10:13:56 | speared | 1 | 69583 | 9 | 3.733 | 18640.0 |
581 | 2025-05-12 06:56:20 | speared | 1 | 69583 | 9 | 5.970 | 11655.4 |
580 | 2025-05-11 22:06:45 | speared | 1 | 69583 | 9 | 3.143 | 22139.0 |
579 | 2025-05-11 21:51:35 | speared | 1 | 69583 | 9 | 6.250 | 11133.3 |
578 | 2025-05-10 10:36:57 | speared | 2 | 107671 | 89 | 9.936 | 10836.5 |
577 | 2025-05-08 20:12:15 | speared | 2 | 107671 | 89 | 13.156 | 8184.2 |
576 | 2025-05-07 20:35:10 | speared | 2 | 107671 | 89 | 13.030 | 8263.3 |
575 | 2025-05-07 18:42:58 | speared | 1 | 69583 | 9 | 1.326 | 52475.9 |
574 | 2025-05-06 11:06:25 | speared | 2 | 107671 | 89 | 12.703 | 8476.0 |
573 | 2025-05-05 00:02:45 | speared | 1 | 69583 | 9 | 5.986 | 11624.3 |
572 | 2025-05-03 07:41:08 | speared | 1 | 69583 | 9 | 7.843 | 8872.0 |
571 | 2025-05-01 05:30:21 | speared | 3 | 134027 | 706 | 28.380 | 4722.6 |
570 | 2025-04-30 17:00:59 | speared | 3 | 134027 | 706 | 25.033 | 5354.0 |
569 | 2025-04-30 07:41:28 | speared | 1 | 69583 | 9 | 9.173 | 7585.6 |
568 | 2025-04-29 09:23:03 | speared | 3 | 134027 | 706 | 17.596 | 7616.9 |
567 | 2025-04-29 04:03:00 | speared | 3 | 134027 | 706 | 33.880 | 3955.9 |
566 | 2025-04-29 03:59:32 | speared | 3 | 134027 | 706 | 18.173 | 7375.1 |
565 | 2025-04-28 02:33:30 | speared | 1 | 69583 | 9 | 9.376 | 7421.4 |
564 | 2025-04-27 02:47:44 | speared | 3 | 134027 | 706 | 19.593 | 6840.6 |
563 | 2025-04-26 20:21:02 | speared | 3 | 134027 | 706 | 37.596 | 3564.9 |
562 | 2025-04-24 23:50:16 | speared | 3 | 134027 | 706 | 6.736 | 19897.1 |
561 | 2025-04-19 23:13:09 | speared | 1 | 69583 | 9 | 2.970 | 23428.6 |
560 | 2025-04-15 12:17:35 | speared | 1 | 69583 | 9 | 1.360 | 51164.0 |
559 | 2025-04-10 21:55:42 | speared | 1 | 69583 | 9 | 5.580 | 12470.1 |
558 | 2025-04-10 21:48:16 | speared | 1 | 69583 | 9 | 5.860 | 11874.2 |
557 | 2025-04-01 23:33:44 | speared | 1 | 69583 | 9 | 3.593 | 19366.3 |
556 | 2025-03-31 06:38:04 | speared | 3 | 134027 | 706 | 26.766 | 5007.4 |
555 | 2025-03-29 18:31:54 | speared | 3 | 134027 | 706 | 35.296 | 3797.2 |
554 | 2025-03-29 12:07:17 | speared | 3 | 134027 | 706 | 35.873 | 3736.2 |
553 | 2025-03-29 06:23:19 | speared | 3 | 134027 | 706 | 30.866 | 4342.2 |
552 | 2025-03-26 20:41:58 | speared | 3 | 134027 | 706 | 32.503 | 4123.5 |
551 | 2025-03-26 03:50:04 | speared | 1 | 69583 | 9 | 2.626 | 26497.7 |
550 | 2025-03-23 09:28:33 | speared | 1 | 69583 | 9 | 3.280 | 21214.3 |
549 | 2025-03-19 00:01:58 | speared | 1 | 69583 | 9 | 1.110 | 62687.4 |
548 | 2025-03-11 15:04:40 | speared | 1 | 69583 | 9 | 8.423 | 8261.1 |
547 | 2025-03-11 08:15:18 | speared | 1 | 69583 | 9 | 3.173 | 21929.7 |
546 | 2025-03-02 05:40:33 | speared | 1 | 69583 | 9 | 5.830 | 11935.3 |
545 | 2025-02-24 01:09:52 | speared | 1 | 69583 | 9 | 3.220 | 21609.6 |
544 | 2025-02-12 12:09:17 | speared | 1 | 69583 | 9 | 4.360 | 15959.4 |
543 | 2025-02-07 07:58:02 | speared | 2 | 107671 | 89 | 16.546 | 6507.4 |
542 | 2025-02-06 14:10:42 | speared | 2 | 107671 | 89 | 21.703 | 4961.1 |
541 | 2025-02-06 11:38:28 | speared | 3 | 134027 | 706 | 30.110 | 4451.2 |
540 | 2025-02-06 09:53:51 | speared | 2 | 107671 | 89 | 14.390 | 7482.3 |
539 | 2025-02-06 09:49:24 | speared | 3 | 134027 | 706 | 6.766 | 19808.9 |
538 | 2025-02-06 09:21:57 | speared | 3 | 134027 | 706 | 32.803 | 4085.8 |
537 | 2025-02-06 08:19:51 | speared | 3 | 134027 | 706 | 27.063 | 4952.4 |
536 | 2025-02-06 08:19:53 | speared | 2 | 107671 | 89 | 17.546 | 6136.5 |
535 | 2025-02-06 07:52:59 | speared | 1 | 69583 | 9 | 1.280 | 54361.7 |
534 | 2025-02-05 17:08:45 | speared | 1 | 69583 | 9 | 5.706 | 12194.7 |
533 | 2025-01-30 13:40:58 | speared | 1 | 69583 | 9 | 3.093 | 22496.9 |
532 | 2025-01-13 10:05:35 | speared | 3 | 134027 | 706 | 21.610 | 6202.1 |
531 | 2025-01-12 05:41:28 | speared | 1 | 69583 | 9 | 5.843 | 11908.8 |
530 | 2025-01-06 07:35:56 | speared | 1 | 69583 | 9 | 2.656 | 26198.4 |
529 | 2024-12-26 20:15:53 | speared | 2 | 107671 | 89 | 24.126 | 4462.9 |
528 | 2024-12-26 11:26:11 | speared | 2 | 107671 | 89 | 16.736 | 6433.5 |
527 | 2024-12-25 16:27:38 | speared | 2 | 107671 | 89 | 6.436 | 16729.5 |
526 | 2024-12-25 10:11:44 | speared | 3 | 134027 | 706 | 42.626 | 3144.3 |
525 | 2024-12-25 09:43:55 | speared | 3 | 134027 | 706 | 10.453 | 12821.9 |
524 | 2024-12-21 07:39:54 | speared | 3 | 134027 | 706 | 30.553 | 4386.7 |
523 | 2024-12-21 02:34:36 | speared | 3 | 134027 | 706 | 42.580 | 3147.7 |