History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
594 | 2025-09-08 22:11:10 | substates | 1 | 81242 | 4 | 1.283 | 63321.9 |
593 | 2025-09-08 03:53:27 | substates | 1 | 81242 | 4 | 1.423 | 57092.1 |
592 | 2025-09-03 02:56:25 | substates | 1 | 81242 | 4 | 1.343 | 60492.9 |
591 | 2025-09-02 12:24:43 | substates | 1 | 81242 | 4 | 1.423 | 57092.1 |
590 | 2025-08-29 04:08:54 | substates | 1 | 81242 | 4 | 1.280 | 63470.3 |
589 | 2025-08-28 19:00:10 | substates | 1 | 81242 | 4 | 1.450 | 56029.0 |
588 | 2025-08-28 12:01:13 | substates | 1 | 81242 | 4 | 1.500 | 54161.3 |
587 | 2025-08-27 03:32:31 | substates | 1 | 81242 | 4 | 1.360 | 59736.8 |
586 | 2025-08-25 14:32:06 | substates | 1 | 81242 | 4 | 5.000 | 16248.4 |
585 | 2025-08-21 05:03:22 | substates | 1 | 81242 | 4 | 5.906 | 13755.8 |
584 | 2025-08-15 08:36:58 | substates | 1 | 81242 | 4 | 3.470 | 23412.7 |
583 | 2025-08-14 01:01:27 | substates | 1 | 81242 | 4 | 1.296 | 62686.7 |
582 | 2025-08-07 12:01:05 | substates | 2 | 121436 | 15 | 7.626 | 15923.9 |
581 | 2025-08-01 06:39:34 | substates | 1 | 81242 | 4 | 5.050 | 16087.5 |
580 | 2025-07-27 06:55:58 | substates | 1 | 81242 | 4 | 3.203 | 25364.3 |
579 | 2025-07-23 12:04:06 | substates | 3 | 148641 | 107 | 33.080 | 4493.4 |
578 | 2025-07-22 15:40:47 | substates | 2 | 121436 | 15 | 9.390 | 12932.5 |
577 | 2025-07-20 00:19:42 | substates | 3 | 148641 | 107 | 7.156 | 20771.5 |
576 | 2025-07-16 08:56:42 | substates | 1 | 81242 | 4 | 1.890 | 42985.2 |
575 | 2025-07-15 15:29:35 | substates | 1 | 81242 | 4 | 4.266 | 19044.1 |
574 | 2025-07-12 21:27:09 | substates | 3 | 148641 | 107 | 14.626 | 10162.8 |
573 | 2025-07-12 18:50:47 | substates | 1 | 81242 | 4 | 1.516 | 53589.7 |
572 | 2025-07-12 11:36:53 | substates | 1 | 81242 | 4 | 1.750 | 46424.0 |
571 | 2025-07-09 08:46:01 | substates | 1 | 81242 | 4 | 10.580 | 7678.8 |
570 | 2025-07-09 02:54:43 | substates | 2 | 121436 | 15 | 4.283 | 28353.0 |
569 | 2025-07-08 10:11:24 | substates | 1 | 81242 | 4 | 7.606 | 10681.3 |
568 | 2025-07-07 19:38:05 | substates | 1 | 81242 | 4 | 1.483 | 54782.2 |
567 | 2025-07-07 13:59:20 | substates | 3 | 148641 | 107 | 32.173 | 4620.1 |
566 | 2025-07-07 02:54:07 | substates | 1 | 81242 | 4 | 5.796 | 14016.9 |
565 | 2025-07-04 15:15:42 | substates | 3 | 148641 | 107 | 22.140 | 6713.7 |
564 | 2025-07-04 12:28:49 | substates | 1 | 81242 | 4 | 7.516 | 10809.2 |
563 | 2025-07-04 10:45:05 | substates | 2 | 121436 | 15 | 13.236 | 9174.7 |
562 | 2025-07-03 13:48:42 | substates | 1 | 81242 | 4 | 1.466 | 55417.5 |
561 | 2025-07-01 07:07:50 | substates | 1 | 81242 | 4 | 1.453 | 55913.3 |
560 | 2025-06-30 18:43:00 | substates | 2 | 121436 | 15 | 12.686 | 9572.4 |
559 | 2025-06-28 04:40:41 | substates | 1 | 81242 | 4 | 3.203 | 25364.3 |
558 | 2025-06-27 16:46:32 | substates | 3 | 148641 | 107 | 21.263 | 6990.6 |
557 | 2025-06-26 21:39:06 | substates | 2 | 121436 | 15 | 3.546 | 34245.9 |
556 | 2025-06-26 05:42:48 | substates | 1 | 81242 | 4 | 6.826 | 11901.8 |
555 | 2025-06-25 17:32:41 | substates | 1 | 81242 | 4 | 1.343 | 60492.9 |
554 | 2025-06-24 05:44:35 | substates | 1 | 81242 | 4 | 5.436 | 14945.2 |
553 | 2025-06-10 17:33:26 | substates | 1 | 81242 | 4 | 7.780 | 10442.4 |
552 | 2025-06-05 13:24:29 | substates | 1 | 81242 | 4 | 6.463 | 12570.3 |
551 | 2025-06-04 04:11:55 | substates | 1 | 81242 | 4 | 4.013 | 20244.7 |
550 | 2025-06-03 19:14:13 | substates | 1 | 81242 | 4 | 3.186 | 25499.7 |
549 | 2025-05-27 15:47:47 | substates | 3 | 148641 | 107 | 33.673 | 4414.2 |
548 | 2025-05-26 11:07:31 | substates | 3 | 148641 | 107 | 42.190 | 3523.1 |
547 | 2025-05-26 06:50:21 | substates | 1 | 81242 | 4 | 7.203 | 11278.9 |
546 | 2025-05-11 00:23:21 | substates | 3 | 148641 | 107 | 29.063 | 5114.4 |
545 | 2025-05-02 18:34:03 | substates | 2 | 121436 | 15 | 3.813 | 31847.9 |
544 | 2025-05-01 09:05:16 | substates | 1 | 81242 | 4 | 10.376 | 7829.8 |
543 | 2025-04-30 19:26:32 | substates | 1 | 81242 | 4 | 1.483 | 54782.2 |
542 | 2025-04-29 03:14:10 | substates | 3 | 148641 | 107 | 14.046 | 10582.4 |
541 | 2025-04-28 04:41:21 | substates | 1 | 81242 | 4 | 4.970 | 16346.5 |
540 | 2025-04-24 14:13:18 | substates | 3 | 148641 | 107 | 26.453 | 5619.1 |
539 | 2025-04-24 12:16:53 | substates | 2 | 121436 | 15 | 27.063 | 4487.2 |
538 | 2025-04-24 10:46:16 | substates | 3 | 148641 | 107 | 49.033 | 3031.4 |
537 | 2025-04-20 04:07:16 | substates | 1 | 81242 | 4 | 6.106 | 13305.3 |
536 | 2025-04-12 13:48:15 | substates | 1 | 81242 | 4 | 4.860 | 16716.5 |
535 | 2025-04-11 14:45:01 | substates | 3 | 148641 | 107 | 19.563 | 7598.1 |
534 | 2025-04-04 12:43:08 | substates | 3 | 148641 | 107 | 18.096 | 8214.0 |
533 | 2025-03-26 04:44:37 | substates | 1 | 81242 | 4 | 6.563 | 12378.8 |
532 | 2025-03-24 03:20:40 | substates | 3 | 148641 | 107 | 26.846 | 5536.8 |
531 | 2025-03-23 20:47:35 | substates | 1 | 81242 | 4 | 6.890 | 11791.3 |
530 | 2025-03-23 20:27:49 | substates | 2 | 121436 | 15 | 13.593 | 8933.7 |
529 | 2025-03-22 15:53:47 | substates | 3 | 148641 | 107 | 22.736 | 6537.7 |
528 | 2025-03-21 22:47:35 | substates | 2 | 121436 | 15 | 19.423 | 6252.2 |
527 | 2025-03-20 05:16:34 | substates | 1 | 81242 | 4 | 5.156 | 15756.8 |
526 | 2025-03-09 22:58:23 | substates | 1 | 81242 | 4 | 6.580 | 12346.8 |
525 | 2025-03-06 15:28:55 | substates | 3 | 148641 | 107 | 23.506 | 6323.5 |
524 | 2025-03-05 21:02:41 | substates | 1 | 81242 | 4 | 10.313 | 7877.6 |
523 | 2025-02-28 07:03:42 | substates | 3 | 148641 | 107 | 26.033 | 5709.7 |
522 | 2025-02-28 07:03:41 | substates | 2 | 121436 | 15 | 16.813 | 7222.7 |
521 | 2025-02-28 06:57:57 | substates | 1 | 81242 | 4 | 5.250 | 15474.7 |
520 | 2025-02-25 05:17:32 | substates | 1 | 81242 | 4 | 3.373 | 24086.0 |
519 | 2025-02-15 21:26:51 | substates | 3 | 148641 | 107 | 17.423 | 8531.3 |
518 | 2025-02-13 13:57:12 | substates | 2 | 121436 | 15 | 18.456 | 6579.8 |
517 | 2025-02-13 13:54:58 | substates | 1 | 81242 | 4 | 2.703 | 30056.2 |
516 | 2025-02-12 11:22:09 | substates | 2 | 121436 | 15 | 26.220 | 4631.4 |
515 | 2025-02-11 15:06:57 | substates | 1 | 81242 | 4 | 8.233 | 9867.8 |
514 | 2025-02-10 23:48:21 | substates | 3 | 148641 | 107 | 46.126 | 3222.5 |
513 | 2025-02-10 23:47:59 | substates | 2 | 121436 | 15 | 18.220 | 6665.0 |
512 | 2025-02-08 04:19:12 | substates | 3 | 148641 | 107 | 30.986 | 4797.0 |
511 | 2025-02-06 19:50:44 | substates | 3 | 148641 | 107 | 31.376 | 4737.4 |
510 | 2025-02-06 19:50:42 | substates | 2 | 121436 | 15 | 18.030 | 6735.2 |
509 | 2025-02-06 19:41:29 | substates | 1 | 81242 | 4 | 5.266 | 15427.6 |
508 | 2025-01-27 01:36:04 | substates | 1 | 81242 | 4 | 1.530 | 53099.3 |
507 | 2025-01-25 10:04:27 | substates | 3 | 148641 | 107 | 43.360 | 3428.1 |
506 | 2025-01-14 06:13:37 | substates | 1 | 81242 | 4 | 1.466 | 55417.5 |
505 | 2025-01-05 22:52:35 | substates | 1 | 81242 | 4 | 2.843 | 28576.2 |
504 | 2025-01-04 16:25:44 | substates | 2 | 121436 | 15 | 18.360 | 6614.2 |
503 | 2025-01-03 09:43:58 | substates | 3 | 148641 | 107 | 41.236 | 3604.6 |
502 | 2025-01-03 06:38:00 | substates | 2 | 121436 | 15 | 17.893 | 6786.8 |
501 | 2025-01-01 22:35:06 | substates | 3 | 148641 | 107 | 35.846 | 4146.7 |
500 | 2025-01-01 16:19:27 | substates | 3 | 148641 | 107 | 33.003 | 4503.9 |
499 | 2025-01-01 12:18:17 | substates | 3 | 148641 | 107 | 41.783 | 3557.5 |
498 | 2025-01-01 12:18:20 | substates | 2 | 121436 | 15 | 26.266 | 4623.3 |
497 | 2025-01-01 12:15:59 | substates | 1 | 81242 | 4 | 2.313 | 35124.1 |
496 | 2024-12-24 05:01:56 | substates | 1 | 81242 | 4 | 7.016 | 11579.5 |
495 | 2024-12-19 03:43:00 | substates | 1 | 81242 | 4 | 6.393 | 12708.0 |