History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"perry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
619 | 2025-09-07 09:26:03 | perry | 1 | 28756 | 14 | 0.533 | 53951.2 |
618 | 2025-08-09 10:40:32 | perry | 1 | 28756 | 14 | 1.360 | 21144.1 |
617 | 2025-08-04 05:04:10 | perry | 2 | 53800 | 124 | 7.203 | 7469.1 |
616 | 2025-08-03 03:40:43 | perry | 2 | 53800 | 124 | 11.250 | 4782.2 |
615 | 2025-07-31 02:05:53 | perry | 1 | 28756 | 14 | 0.533 | 53951.2 |
614 | 2025-07-31 00:04:18 | perry | 1 | 28756 | 14 | 1.330 | 21621.1 |
613 | 2025-07-30 00:07:41 | perry | 1 | 28756 | 14 | 2.013 | 14285.1 |
612 | 2025-07-30 00:06:39 | perry | 1 | 28756 | 14 | 1.140 | 25224.6 |
611 | 2025-07-28 06:49:15 | perry | 2 | 53800 | 124 | 4.343 | 12387.8 |
610 | 2025-07-27 06:12:35 | perry | 2 | 53800 | 124 | 8.420 | 6389.5 |
609 | 2025-07-26 23:29:42 | perry | 1 | 28756 | 14 | 1.123 | 25606.4 |
608 | 2025-07-25 23:16:58 | perry | 2 | 53800 | 124 | 1.390 | 38705.0 |
607 | 2025-07-24 17:51:27 | perry | 2 | 53800 | 124 | 4.593 | 11713.5 |
606 | 2025-07-24 08:39:14 | perry | 2 | 53800 | 124 | 4.076 | 13199.2 |
605 | 2025-07-23 22:56:46 | perry | 1 | 28756 | 14 | 2.233 | 12877.7 |
604 | 2025-07-21 04:13:32 | perry | 2 | 53800 | 124 | 1.706 | 31535.8 |
603 | 2025-07-18 14:09:03 | perry | 1 | 28756 | 14 | 1.640 | 17534.1 |
602 | 2025-07-17 12:07:52 | perry | 1 | 28756 | 14 | 3.046 | 9440.6 |
601 | 2025-07-08 09:45:14 | perry | 1 | 28756 | 14 | 1.783 | 16127.9 |
600 | 2025-07-07 00:04:45 | perry | 1 | 28756 | 14 | 2.360 | 12184.7 |
599 | 2025-07-04 00:19:26 | perry | 1 | 28756 | 14 | 2.356 | 12205.4 |
598 | 2025-06-30 15:32:26 | perry | 1 | 28756 | 14 | 1.326 | 21686.3 |
597 | 2025-06-30 00:03:44 | perry | 1 | 28756 | 14 | 0.983 | 29253.3 |
596 | 2025-06-26 04:45:35 | perry | 1 | 28756 | 14 | 3.440 | 8359.3 |
595 | 2025-06-24 06:44:06 | perry | 1 | 28756 | 14 | 1.156 | 24875.4 |
594 | 2025-06-18 10:38:06 | perry | 1 | 28756 | 14 | 1.893 | 15190.7 |
593 | 2025-06-08 08:54:46 | perry | 1 | 28756 | 14 | 2.203 | 13053.1 |
592 | 2025-06-05 21:49:21 | perry | 1 | 28756 | 14 | 1.000 | 28756.0 |
591 | 2025-06-01 23:46:58 | perry | 1 | 28756 | 14 | 2.330 | 12341.6 |
590 | 2025-06-01 21:06:49 | perry | 1 | 28756 | 14 | 1.346 | 21364.0 |
589 | 2025-05-30 23:10:48 | perry | 1 | 28756 | 14 | 2.686 | 10705.9 |
588 | 2025-05-16 10:38:00 | perry | 1 | 28756 | 14 | 1.563 | 18398.0 |
587 | 2025-05-14 04:59:01 | perry | 1 | 28756 | 14 | 2.530 | 11366.0 |
586 | 2025-05-11 00:44:57 | perry | 1 | 28756 | 14 | 1.653 | 17396.2 |
585 | 2025-05-09 10:26:37 | perry | 1 | 28756 | 14 | 0.516 | 55728.7 |
584 | 2025-05-05 22:28:15 | perry | 1 | 28756 | 14 | 2.110 | 13628.4 |
583 | 2025-05-01 23:25:19 | perry | 1 | 28756 | 14 | 2.466 | 11661.0 |
582 | 2025-05-01 10:44:03 | perry | 1 | 28756 | 14 | 2.640 | 10892.4 |
581 | 2025-04-30 12:15:27 | perry | 1 | 28756 | 14 | 2.343 | 12273.2 |
580 | 2025-04-29 23:11:32 | perry | 1 | 28756 | 14 | 1.253 | 22949.7 |
579 | 2025-04-16 09:09:18 | perry | 1 | 28756 | 14 | 1.343 | 21411.8 |
578 | 2025-04-09 01:29:02 | perry | 2 | 53800 | 124 | 16.890 | 3185.3 |
577 | 2025-04-07 22:52:49 | perry | 2 | 53800 | 124 | 4.250 | 12658.8 |
576 | 2025-04-07 07:58:14 | perry | 1 | 28756 | 14 | 0.516 | 55728.7 |
575 | 2025-04-05 21:41:14 | perry | 1 | 28756 | 14 | 2.640 | 10892.4 |
574 | 2025-04-01 22:52:08 | perry | 1 | 28756 | 14 | 2.923 | 9837.8 |
573 | 2025-03-29 05:53:54 | perry | 2 | 53800 | 124 | 7.986 | 6736.8 |
572 | 2025-03-29 00:11:07 | perry | 1 | 28756 | 14 | 1.356 | 21206.5 |
571 | 2025-03-27 15:18:11 | perry | 2 | 53800 | 124 | 7.986 | 6736.8 |
570 | 2025-03-26 14:05:55 | perry | 1 | 28756 | 14 | 0.486 | 59168.7 |
569 | 2025-03-20 06:23:17 | perry | 1 | 28756 | 14 | 3.406 | 8442.7 |
568 | 2025-03-15 10:28:39 | perry | 2 | 53800 | 124 | 4.580 | 11746.7 |
567 | 2025-03-15 10:26:52 | perry | 1 | 28756 | 14 | 2.106 | 13654.3 |
566 | 2025-03-12 12:40:20 | perry | 1 | 28756 | 14 | 1.203 | 23903.6 |
565 | 2025-03-07 15:20:00 | perry | 1 | 28756 | 14 | 2.343 | 12273.2 |
564 | 2025-03-06 07:48:48 | perry | 2 | 53800 | 124 | 4.000 | 13450.0 |
563 | 2025-03-05 20:45:54 | perry | 2 | 53800 | 124 | 6.813 | 7896.7 |
562 | 2025-03-05 20:18:28 | perry | 2 | 53800 | 124 | 11.756 | 4576.4 |
561 | 2025-03-05 20:17:53 | perry | 1 | 28756 | 14 | 2.266 | 12690.2 |
560 | 2025-03-04 13:09:37 | perry | 1 | 28756 | 14 | 1.170 | 24577.8 |
559 | 2025-02-26 13:20:08 | perry | 1 | 28756 | 14 | 0.513 | 56054.6 |
558 | 2025-02-26 06:37:04 | perry | 2 | 53800 | 124 | 11.140 | 4829.4 |
557 | 2025-02-26 06:10:43 | perry | 1 | 28756 | 14 | 0.530 | 54256.6 |
556 | 2025-02-23 04:28:23 | perry | 1 | 28756 | 14 | 1.796 | 16011.1 |
555 | 2025-02-23 03:37:16 | perry | 1 | 28756 | 14 | 0.966 | 29768.1 |
554 | 2025-01-27 09:53:41 | perry | 2 | 53800 | 124 | 9.123 | 5897.2 |
553 | 2025-01-27 09:44:14 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
552 | 2025-01-26 20:35:20 | perry | 1 | 28756 | 14 | 1.436 | 20025.1 |
551 | 2025-01-23 19:48:46 | perry | 1 | 28756 | 14 | 1.220 | 23570.5 |
550 | 2025-01-08 18:46:36 | perry | 2 | 53800 | 124 | 8.206 | 6556.2 |
549 | 2025-01-06 11:12:35 | perry | 2 | 53800 | 124 | 8.126 | 6620.7 |
548 | 2025-01-06 11:10:25 | perry | 1 | 28756 | 14 | 2.110 | 13628.4 |
547 | 2024-12-30 02:58:05 | perry | 2 | 53800 | 124 | 3.983 | 13507.4 |
546 | 2024-12-28 11:25:48 | perry | 2 | 53800 | 124 | 4.110 | 13090.0 |
545 | 2024-12-28 09:08:30 | perry | 2 | 53800 | 124 | 6.250 | 8608.0 |
544 | 2024-12-28 08:15:00 | perry | 1 | 28756 | 14 | 0.906 | 31739.5 |
543 | 2024-12-27 17:20:24 | perry | 1 | 28756 | 14 | 2.140 | 13437.4 |
542 | 2024-12-22 20:48:51 | perry | 1 | 28756 | 14 | 3.640 | 7900.0 |
541 | 2024-12-11 13:19:17 | perry | 1 | 28756 | 14 | 2.330 | 12341.6 |
540 | 2024-12-07 00:57:29 | perry | 2 | 53800 | 124 | 7.000 | 7685.7 |
539 | 2024-12-07 00:57:24 | perry | 1 | 28756 | 14 | 0.923 | 31154.9 |
538 | 2024-11-30 01:08:48 | perry | 1 | 28756 | 14 | 1.860 | 15460.2 |
537 | 2024-11-28 05:35:52 | perry | 1 | 28756 | 14 | 0.440 | 65354.5 |
536 | 2024-11-28 01:31:09 | perry | 2 | 53800 | 124 | 4.313 | 12473.9 |
535 | 2024-11-27 20:02:27 | perry | 2 | 53800 | 124 | 3.250 | 16553.8 |
534 | 2024-11-27 15:27:06 | perry | 2 | 53800 | 124 | 1.750 | 30742.9 |
533 | 2024-11-27 15:26:53 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
532 | 2024-11-16 14:48:41 | perry | 1 | 28756 | 14 | 2.420 | 11882.6 |
531 | 2024-11-06 19:12:47 | perry | 1 | 28756 | 14 | 2.360 | 12184.7 |
530 | 2024-10-28 23:46:00 | perry | 2 | 53800 | 124 | 8.500 | 6329.4 |
529 | 2024-10-28 23:38:49 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
528 | 2024-10-28 07:33:26 | perry | 1 | 28756 | 14 | 0.440 | 65354.5 |
527 | 2024-10-22 11:26:57 | perry | 1 | 28756 | 14 | 2.140 | 13437.4 |
526 | 2024-10-22 11:26:03 | perry | 1 | 28756 | 14 | 2.280 | 12612.3 |
525 | 2024-10-15 20:28:45 | perry | 1 | 28756 | 14 | 2.360 | 12184.7 |
524 | 2024-10-15 00:39:31 | perry | 1 | 28756 | 14 | 3.453 | 8327.8 |
523 | 2024-10-07 14:37:03 | perry | 1 | 28756 | 14 | 2.093 | 13739.1 |
522 | 2024-09-29 14:50:50 | perry | 2 | 53800 | 124 | 18.860 | 2852.6 |
521 | 2024-09-28 22:58:51 | perry | 2 | 53800 | 124 | 6.046 | 8898.4 |
520 | 2024-09-28 22:56:20 | perry | 1 | 28756 | 14 | 5.296 | 5429.8 |