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 |
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 |
469 | 2024-07-25 06:35:18 | granter | 3 | 134027 | 799 | 7.546 | 17761.3 |
468 | 2024-07-24 08:45:24 | granter | 3 | 134027 | 799 | 18.893 | 7094.0 |
467 | 2024-07-24 08:45:17 | granter | 3 | 134027 | 799 | 21.470 | 6242.5 |
466 | 2024-07-20 15:11:15 | granter | 1 | 69583 | 11 | 4.360 | 15959.4 |
465 | 2024-07-11 10:14:16 | granter | 1 | 69583 | 11 | 4.420 | 15742.8 |
464 | 2024-07-11 08:13:25 | granter | 1 | 69583 | 11 | 5.500 | 12651.5 |
463 | 2024-07-07 19:44:02 | granter | 1 | 69583 | 11 | 3.170 | 21950.5 |
462 | 2024-07-01 19:23:53 | granter | 1 | 69583 | 11 | 4.873 | 14279.3 |
461 | 2024-06-29 22:38:35 | granter | 1 | 69583 | 11 | 4.310 | 16144.5 |
460 | 2024-06-20 21:17:52 | granter | 1 | 69583 | 11 | 6.096 | 11414.5 |
459 | 2024-06-16 09:10:43 | granter | 2 | 107671 | 88 | 17.346 | 6207.3 |
458 | 2024-06-10 21:12:26 | granter | 1 | 69583 | 11 | 4.296 | 16197.2 |
457 | 2024-05-30 15:21:10 | granter | 2 | 107671 | 88 | 2.906 | 37051.3 |
456 | 2024-05-03 21:43:58 | granter | 3 | 134027 | 799 | 18.093 | 7407.7 |
455 | 2024-05-01 02:54:41 | granter | 3 | 134027 | 799 | 10.986 | 12199.8 |
454 | 2024-04-27 08:33:56 | granter | 1 | 69583 | 11 | 1.156 | 60192.9 |
453 | 2024-04-27 03:30:15 | granter | 1 | 69583 | 11 | 5.643 | 12330.9 |
452 | 2024-04-25 20:17:22 | granter | 3 | 134027 | 799 | 17.266 | 7762.5 |
451 | 2024-04-24 18:50:44 | granter | 2 | 107671 | 88 | 7.296 | 14757.5 |
450 | 2024-04-24 18:47:28 | granter | 3 | 134027 | 799 | 8.313 | 16122.6 |
449 | 2024-04-24 17:13:55 | granter | 2 | 107671 | 88 | 12.440 | 8655.2 |
448 | 2024-04-24 17:11:15 | granter | 3 | 134027 | 799 | 7.970 | 16816.4 |
447 | 2024-04-23 03:49:44 | granter | 2 | 107671 | 88 | 9.186 | 11721.2 |
446 | 2024-04-23 03:49:34 | granter | 3 | 134027 | 799 | 13.390 | 10009.5 |
445 | 2024-03-17 10:28:20 | granter | 1 | 69583 | 11 | 1.283 | 54234.6 |
444 | 2024-03-04 02:35:23 | granter | 1 | 69583 | 11 | 1.326 | 52475.9 |
443 | 2024-02-23 16:29:48 | granter | 3 | 134027 | 799 | 5.830 | 22989.2 |
442 | 2024-02-22 08:46:23 | granter | 3 | 134027 | 799 | 7.546 | 17761.3 |
441 | 2024-02-22 08:46:07 | granter | 2 | 107671 | 88 | 7.343 | 14663.1 |
440 | 2024-02-21 11:38:45 | granter | 2 | 107671 | 88 | 8.093 | 13304.2 |
439 | 2024-02-21 03:42:45 | granter | 2 | 107671 | 88 | 3.330 | 32333.6 |
438 | 2024-01-17 13:11:50 | granter | 2 | 107671 | 88 | 3.330 | 32333.6 |
437 | 2024-01-10 13:43:20 | granter | 3 | 134027 | 799 | 7.406 | 18097.1 |
436 | 2024-01-08 16:14:59 | granter | 2 | 107671 | 88 | 3.626 | 29694.2 |
435 | 2023-12-13 21:08:36 | granter | 1 | 69583 | 11 | 2.406 | 28920.6 |
434 | 2023-12-11 20:59:34 | granter | 1 | 69583 | 11 | 1.156 | 60192.9 |
433 | 2023-12-11 11:34:56 | granter | 1 | 69583 | 11 | 1.076 | 64668.2 |
432 | 2023-11-29 22:22:01 | granter | 1 | 69583 | 11 | 1.156 | 60192.9 |
431 | 2023-11-26 16:07:38 | granter | 1 | 69583 | 11 | 1.186 | 58670.3 |