History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"granter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
569 | 2025-05-28 07:59:05 | granter | 1 | 69583 | 11 | 1.173 | 59320.5 |
568 | 2025-05-25 08:31:55 | granter | 1 | 69583 | 11 | 1.110 | 62687.4 |
567 | 2025-05-23 13:29:25 | granter | 3 | 134027 | 799 | 49.640 | 2700.0 |
566 | 2025-05-20 05:41:07 | granter | 1 | 69583 | 11 | 8.220 | 8465.1 |
565 | 2025-05-20 03:18:15 | granter | 1 | 69583 | 11 | 6.703 | 10380.9 |
564 | 2025-05-18 12:46:32 | granter | 1 | 69583 | 11 | 5.453 | 12760.5 |
563 | 2025-05-17 18:08:55 | granter | 3 | 134027 | 799 | 7.000 | 19146.7 |
562 | 2025-05-16 13:24:12 | granter | 2 | 107671 | 88 | 20.093 | 5358.6 |
561 | 2025-05-16 06:16:55 | granter | 1 | 69583 | 11 | 8.640 | 8053.6 |
560 | 2025-05-15 18:46:06 | granter | 1 | 69583 | 11 | 1.200 | 57985.8 |
559 | 2025-05-15 01:27:32 | granter | 1 | 69583 | 11 | 1.203 | 57841.2 |
558 | 2025-05-14 06:52:36 | granter | 3 | 134027 | 799 | 34.050 | 3936.2 |
557 | 2025-05-13 13:48:55 | granter | 1 | 69583 | 11 | 5.406 | 12871.4 |
556 | 2025-05-13 07:04:32 | granter | 1 | 69583 | 11 | 1.076 | 64668.2 |
555 | 2025-05-12 05:30:07 | granter | 1 | 69583 | 11 | 4.716 | 14754.7 |
554 | 2025-05-11 23:22:08 | granter | 1 | 69583 | 11 | 5.470 | 12720.8 |
553 | 2025-05-09 13:59:32 | granter | 1 | 69583 | 11 | 1.220 | 57035.2 |
552 | 2025-05-08 19:57:47 | granter | 3 | 134027 | 799 | 17.843 | 7511.5 |
551 | 2025-05-07 20:01:41 | granter | 2 | 107671 | 88 | 15.890 | 6776.0 |
550 | 2025-05-06 19:57:04 | granter | 2 | 107671 | 88 | 6.736 | 15984.4 |
549 | 2025-05-05 22:43:00 | granter | 2 | 107671 | 88 | 9.423 | 11426.4 |
548 | 2025-05-05 17:51:53 | granter | 3 | 134027 | 799 | 7.296 | 18369.9 |
547 | 2025-05-05 13:15:16 | granter | 3 | 134027 | 799 | 30.520 | 4391.4 |
546 | 2025-05-05 13:05:32 | granter | 3 | 134027 | 799 | 6.733 | 19906.0 |
545 | 2025-05-05 06:54:28 | granter | 3 | 134027 | 799 | 33.706 | 3976.4 |
544 | 2025-05-05 02:29:55 | granter | 3 | 134027 | 799 | 7.686 | 17437.8 |
543 | 2025-05-04 22:42:09 | granter | 3 | 134027 | 799 | 6.763 | 19817.7 |
542 | 2025-05-03 15:42:55 | granter | 3 | 134027 | 799 | 8.716 | 15377.1 |
541 | 2025-05-02 15:15:07 | granter | 1 | 69583 | 11 | 2.606 | 26701.1 |
540 | 2025-05-01 18:06:48 | granter | 1 | 69583 | 11 | 1.250 | 55666.4 |
539 | 2025-04-30 02:05:49 | granter | 1 | 69583 | 11 | 3.076 | 22621.3 |
538 | 2025-04-27 06:52:59 | granter | 3 | 134027 | 799 | 13.953 | 9605.6 |
537 | 2025-04-24 16:04:43 | granter | 2 | 107671 | 88 | 16.046 | 6710.1 |
536 | 2025-04-23 09:18:37 | granter | 2 | 107671 | 88 | 13.236 | 8134.7 |
535 | 2025-04-22 20:16:22 | granter | 1 | 69583 | 11 | 6.356 | 10947.6 |
534 | 2025-04-20 04:25:45 | granter | 1 | 69583 | 11 | 5.843 | 11908.8 |
533 | 2025-04-20 02:30:23 | granter | 1 | 69583 | 11 | 5.060 | 13751.6 |
532 | 2025-04-19 21:43:51 | granter | 1 | 69583 | 11 | 8.546 | 8142.2 |
531 | 2025-04-19 00:07:46 | granter | 1 | 69583 | 11 | 1.170 | 59472.6 |
530 | 2025-04-13 12:29:50 | granter | 3 | 134027 | 799 | 8.436 | 15887.5 |
529 | 2025-04-13 12:09:05 | granter | 3 | 134027 | 799 | 7.703 | 17399.3 |
528 | 2025-04-11 17:00:12 | granter | 3 | 134027 | 799 | 39.376 | 3403.8 |
527 | 2025-04-10 23:29:20 | granter | 1 | 69583 | 11 | 3.890 | 17887.7 |
526 | 2025-04-08 12:08:16 | granter | 1 | 69583 | 11 | 3.170 | 21950.5 |
525 | 2025-04-05 17:16:53 | granter | 3 | 134027 | 799 | 6.750 | 19855.9 |
524 | 2025-04-04 22:12:02 | granter | 3 | 134027 | 799 | 35.816 | 3742.1 |
523 | 2025-04-04 16:51:18 | granter | 3 | 134027 | 799 | 22.706 | 5902.7 |
522 | 2025-04-04 13:15:14 | granter | 3 | 134027 | 799 | 26.470 | 5063.4 |
521 | 2025-04-03 19:38:24 | granter | 2 | 107671 | 88 | 15.186 | 7090.1 |
520 | 2025-04-03 18:30:03 | granter | 1 | 69583 | 11 | 1.063 | 65459.1 |
519 | 2025-04-03 01:44:08 | granter | 3 | 134027 | 799 | 7.516 | 17832.2 |
518 | 2025-04-02 22:07:07 | granter | 2 | 107671 | 88 | 6.593 | 16331.1 |
517 | 2025-03-20 06:26:52 | granter | 1 | 69583 | 11 | 5.953 | 11688.7 |
516 | 2025-03-20 03:58:51 | granter | 1 | 69583 | 11 | 5.610 | 12403.4 |
515 | 2025-03-14 18:01:49 | granter | 1 | 69583 | 11 | 2.750 | 25302.9 |
514 | 2025-03-14 14:34:54 | granter | 1 | 69583 | 11 | 1.106 | 62914.1 |
513 | 2025-03-12 09:48:31 | granter | 1 | 69583 | 11 | 6.046 | 11508.9 |
512 | 2025-03-11 02:15:55 | granter | 1 | 69583 | 11 | 3.936 | 17678.6 |
511 | 2025-03-07 23:52:40 | granter | 1 | 69583 | 11 | 2.733 | 25460.3 |
510 | 2025-03-02 06:10:16 | granter | 1 | 69583 | 11 | 4.016 | 17326.4 |
509 | 2025-03-01 09:11:27 | granter | 1 | 69583 | 11 | 6.313 | 11022.2 |
508 | 2025-02-09 15:08:29 | granter | 1 | 69583 | 11 | 4.406 | 15792.8 |
507 | 2025-02-01 17:15:40 | granter | 1 | 69583 | 11 | 4.750 | 14649.1 |
506 | 2025-01-28 11:51:15 | granter | 1 | 69583 | 11 | 2.940 | 23667.7 |
505 | 2024-12-28 12:54:24 | granter | 1 | 69583 | 11 | 2.936 | 23699.9 |
504 | 2024-12-27 08:00:34 | granter | 1 | 69583 | 11 | 7.436 | 9357.6 |
503 | 2024-11-28 02:13:03 | granter | 3 | 134027 | 799 | 20.143 | 6653.8 |
502 | 2024-11-12 12:26:36 | granter | 2 | 107671 | 88 | 13.423 | 8021.4 |
501 | 2024-11-12 10:54:05 | granter | 2 | 107671 | 88 | 22.656 | 4752.4 |
500 | 2024-11-11 18:18:48 | granter | 3 | 134027 | 799 | 33.190 | 4038.2 |
499 | 2024-11-11 01:09:26 | granter | 3 | 134027 | 799 | 43.923 | 3051.4 |
498 | 2024-11-11 01:09:24 | granter | 2 | 107671 | 88 | 16.360 | 6581.4 |
497 | 2024-11-10 14:02:02 | granter | 1 | 69583 | 11 | 1.190 | 58473.1 |
496 | 2024-11-09 07:53:48 | granter | 1 | 69583 | 11 | 3.283 | 21194.9 |
495 | 2024-11-04 01:59:13 | granter | 1 | 69583 | 11 | 2.970 | 23428.6 |
494 | 2024-10-28 01:56:28 | granter | 1 | 69583 | 11 | 1.126 | 61796.6 |
493 | 2024-10-23 15:38:18 | granter | 1 | 69583 | 11 | 6.690 | 10401.0 |
492 | 2024-10-08 14:49:07 | granter | 1 | 69583 | 11 | 5.940 | 11714.3 |
491 | 2024-10-08 12:41:24 | granter | 1 | 69583 | 11 | 6.986 | 9960.3 |
490 | 2024-10-05 01:08:33 | granter | 3 | 134027 | 799 | 52.046 | 2575.2 |
489 | 2024-10-04 17:38:16 | granter | 2 | 107671 | 88 | 25.796 | 4173.9 |
488 | 2024-10-04 17:34:21 | granter | 1 | 69583 | 11 | 4.063 | 17126.0 |
487 | 2024-10-04 08:12:11 | granter | 3 | 134027 | 799 | 49.533 | 2705.8 |
486 | 2024-10-04 01:36:07 | granter | 2 | 107671 | 88 | 24.703 | 4358.6 |
485 | 2024-10-03 07:46:42 | granter | 3 | 134027 | 799 | 73.773 | 1816.7 |
484 | 2024-10-03 07:46:44 | granter | 2 | 107671 | 88 | 28.800 | 3738.6 |
483 | 2024-09-28 02:40:55 | granter | 1 | 69583 | 11 | 12.093 | 5754.0 |
482 | 2024-09-22 04:47:19 | granter | 1 | 69583 | 11 | 4.530 | 15360.5 |
481 | 2024-09-04 13:23:41 | granter | 1 | 69583 | 11 | 8.550 | 8138.4 |
480 | 2024-08-31 08:48:19 | granter | 1 | 69583 | 11 | 7.686 | 9053.2 |
479 | 2024-08-27 06:42:16 | granter | 2 | 107671 | 88 | 12.296 | 8756.6 |
478 | 2024-08-26 14:56:07 | granter | 2 | 107671 | 88 | 34.750 | 3098.4 |
477 | 2024-08-26 12:08:47 | granter | 1 | 69583 | 11 | 10.310 | 6749.1 |
476 | 2024-08-22 02:19:50 | granter | 2 | 107671 | 88 | 18.766 | 5737.6 |
475 | 2024-08-17 11:08:21 | granter | 1 | 69583 | 11 | 7.093 | 9810.1 |
474 | 2024-08-16 00:35:32 | granter | 1 | 69583 | 11 | 8.000 | 8697.9 |
473 | 2024-08-14 03:32:57 | granter | 1 | 69583 | 11 | 6.233 | 11163.6 |
472 | 2024-08-12 06:47:34 | granter | 1 | 69583 | 11 | 10.766 | 6463.2 |
471 | 2024-07-25 19:58:04 | granter | 3 | 134027 | 799 | 13.313 | 10067.4 |
470 | 2024-07-25 11:13:51 | granter | 3 | 134027 | 799 | 22.456 | 5968.4 |