History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subnational"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
552 | 2025-08-10 11:41:37 | subnational | 1 | 49908 | 2 | 2.033 | 24548.9 |
551 | 2025-08-09 06:23:05 | subnational | 1 | 49908 | 2 | 3.190 | 15645.1 |
550 | 2025-08-04 05:16:08 | subnational | 1 | 49908 | 2 | 1.936 | 25778.9 |
549 | 2025-08-01 10:30:27 | subnational | 1 | 49908 | 2 | 2.720 | 18348.5 |
548 | 2025-07-26 10:04:45 | subnational | 1 | 49908 | 2 | 2.326 | 21456.6 |
547 | 2025-07-25 03:09:55 | subnational | 1 | 49908 | 2 | 2.313 | 21577.2 |
546 | 2025-07-24 20:38:03 | subnational | 1 | 49908 | 2 | 3.156 | 15813.7 |
545 | 2025-07-04 04:38:31 | subnational | 1 | 49908 | 2 | 4.250 | 11743.1 |
544 | 2025-06-29 04:57:05 | subnational | 1 | 49908 | 2 | 2.093 | 23845.2 |
543 | 2025-06-24 11:34:36 | subnational | 1 | 49908 | 2 | 4.140 | 12055.1 |
542 | 2025-06-20 12:37:21 | subnational | 1 | 49908 | 2 | 4.250 | 11743.1 |
541 | 2025-06-16 15:36:34 | subnational | 1 | 49908 | 2 | 2.156 | 23148.4 |
540 | 2025-05-27 13:27:36 | subnational | 1 | 49908 | 2 | 4.016 | 12427.3 |
539 | 2025-05-27 05:50:24 | subnational | 1 | 49908 | 2 | 2.013 | 24792.8 |
538 | 2025-05-23 04:24:40 | subnational | 1 | 49908 | 2 | 4.206 | 11865.9 |
537 | 2025-05-22 11:57:40 | subnational | 1 | 49908 | 2 | 6.063 | 8231.6 |
536 | 2025-05-08 08:50:45 | subnational | 1 | 49908 | 2 | 2.453 | 20345.7 |
535 | 2025-04-26 03:43:37 | subnational | 1 | 49908 | 2 | 2.266 | 22024.7 |
534 | 2025-04-23 03:47:30 | subnational | 1 | 49908 | 2 | 6.016 | 8295.9 |
533 | 2025-04-23 00:10:09 | subnational | 4 | 148819 | 100 | 77.536 | 1919.4 |
532 | 2025-04-21 15:07:30 | subnational | 4 | 148819 | 100 | 24.970 | 5959.9 |
531 | 2025-04-17 23:00:25 | subnational | 4 | 148819 | 100 | 35.390 | 4205.1 |
530 | 2025-04-14 07:18:10 | subnational | 4 | 148819 | 100 | 24.593 | 6051.3 |
529 | 2025-04-14 04:14:48 | subnational | 4 | 148819 | 100 | 47.503 | 3132.8 |
528 | 2025-04-08 04:09:35 | subnational | 3 | 121633 | 22 | 19.640 | 6193.1 |
527 | 2025-04-08 02:52:25 | subnational | 2 | 86808 | 3 | 6.440 | 13479.5 |
526 | 2025-04-08 00:56:48 | subnational | 4 | 148819 | 100 | 36.770 | 4047.3 |
525 | 2025-04-07 22:21:43 | subnational | 4 | 148819 | 100 | 41.140 | 3617.4 |
524 | 2025-04-07 02:18:06 | subnational | 1 | 49908 | 2 | 4.173 | 11959.7 |
523 | 2025-03-25 04:10:35 | subnational | 1 | 49908 | 2 | 5.843 | 8541.5 |
522 | 2025-03-23 04:43:42 | subnational | 1 | 49908 | 2 | 4.160 | 11997.1 |
521 | 2025-03-13 04:58:54 | subnational | 4 | 148819 | 100 | 60.580 | 2456.6 |
520 | 2025-03-06 13:14:11 | subnational | 4 | 148819 | 100 | 51.296 | 2901.2 |
519 | 2025-03-06 13:14:10 | subnational | 4 | 148819 | 100 | 43.673 | 3407.6 |
518 | 2025-03-06 13:14:06 | subnational | 3 | 121633 | 22 | 25.830 | 4709.0 |
517 | 2025-03-06 13:14:05 | subnational | 2 | 86808 | 3 | 9.750 | 8903.4 |
516 | 2025-03-06 13:13:18 | subnational | 1 | 49908 | 2 | 4.220 | 11826.5 |
515 | 2025-03-02 04:06:38 | subnational | 1 | 49908 | 2 | 4.156 | 12008.7 |
514 | 2025-02-10 22:07:13 | subnational | 4 | 148819 | 100 | 65.863 | 2259.5 |
513 | 2025-02-10 22:07:07 | subnational | 2 | 86808 | 3 | 9.610 | 9033.1 |
512 | 2025-01-30 15:34:29 | subnational | 3 | 121633 | 22 | 25.156 | 4835.1 |
511 | 2025-01-30 15:34:40 | subnational | 2 | 86808 | 3 | 11.513 | 7540.0 |
510 | 2025-01-30 15:33:16 | subnational | 4 | 148819 | 100 | 43.453 | 3424.8 |
509 | 2025-01-30 15:32:25 | subnational | 1 | 49908 | 2 | 2.063 | 24192.0 |
508 | 2025-01-30 07:05:57 | subnational | 1 | 49908 | 2 | 4.296 | 11617.3 |
507 | 2025-01-24 06:47:47 | subnational | 4 | 148819 | 100 | 44.890 | 3315.2 |
506 | 2025-01-23 21:57:26 | subnational | 4 | 148819 | 100 | 42.066 | 3537.8 |
505 | 2025-01-21 10:33:08 | subnational | 4 | 148819 | 100 | 43.893 | 3390.5 |
504 | 2025-01-16 05:19:25 | subnational | 2 | 86808 | 3 | 6.406 | 13551.0 |
503 | 2025-01-16 05:16:59 | subnational | 1 | 49908 | 2 | 1.173 | 42547.3 |
502 | 2025-01-15 23:01:00 | subnational | 3 | 121633 | 22 | 21.330 | 5702.4 |
501 | 2025-01-15 07:05:17 | subnational | 3 | 121633 | 22 | 32.846 | 3703.1 |
500 | 2025-01-14 16:55:09 | subnational | 2 | 86808 | 3 | 11.780 | 7369.1 |
499 | 2025-01-14 16:54:55 | subnational | 3 | 121633 | 22 | 20.970 | 5800.3 |
498 | 2025-01-14 16:52:40 | subnational | 4 | 148819 | 100 | 61.630 | 2414.7 |
497 | 2025-01-14 16:51:30 | subnational | 1 | 49908 | 2 | 2.096 | 23811.1 |
496 | 2025-01-12 05:22:13 | subnational | 4 | 148819 | 100 | 51.020 | 2916.9 |
495 | 2025-01-10 19:09:20 | subnational | 4 | 148819 | 100 | 64.036 | 2324.0 |
494 | 2024-12-24 03:18:10 | subnational | 4 | 148819 | 100 | 42.926 | 3466.9 |
493 | 2024-12-23 22:02:47 | subnational | 3 | 121633 | 22 | 28.376 | 4286.5 |
492 | 2024-12-23 22:02:15 | subnational | 4 | 148819 | 100 | 47.550 | 3129.7 |
491 | 2024-12-23 22:02:47 | subnational | 2 | 86808 | 3 | 15.483 | 5606.7 |
490 | 2024-12-23 22:00:38 | subnational | 1 | 49908 | 2 | 1.873 | 26646.0 |
489 | 2024-12-23 21:59:15 | subnational | 4 | 148819 | 100 | 56.830 | 2618.7 |
488 | 2024-12-23 13:49:13 | subnational | 4 | 148819 | 100 | 56.893 | 2615.8 |
487 | 2024-12-23 13:49:23 | subnational | 2 | 86808 | 3 | 17.643 | 4920.3 |
486 | 2024-12-23 13:47:56 | subnational | 1 | 49908 | 2 | 0.893 | 55888.0 |
485 | 2024-12-19 04:14:04 | subnational | 3 | 121633 | 22 | 28.063 | 4334.3 |
484 | 2024-12-13 21:11:31 | subnational | 3 | 121633 | 22 | 29.310 | 4149.9 |
483 | 2024-12-13 16:39:15 | subnational | 4 | 148819 | 100 | 52.893 | 2813.6 |
482 | 2024-12-13 16:39:16 | subnational | 3 | 121633 | 22 | 19.266 | 6313.3 |
481 | 2024-12-13 16:39:17 | subnational | 2 | 86808 | 3 | 9.343 | 9291.2 |
480 | 2024-12-13 16:39:12 | subnational | 1 | 49908 | 2 | 0.856 | 58303.7 |
479 | 2024-12-07 22:49:25 | subnational | 4 | 148819 | 100 | 45.876 | 3243.9 |
478 | 2024-12-06 13:44:23 | subnational | 4 | 148819 | 100 | 14.263 | 10433.9 |
477 | 2024-11-21 08:33:22 | subnational | 4 | 148819 | 100 | 74.270 | 2003.8 |
476 | 2024-11-20 18:30:40 | subnational | 1 | 49908 | 2 | 1.656 | 30137.7 |
475 | 2024-11-19 11:16:42 | subnational | 4 | 148819 | 100 | 52.923 | 2812.0 |
474 | 2024-11-16 04:21:50 | subnational | 4 | 148819 | 100 | 49.520 | 3005.2 |
473 | 2024-11-12 14:50:25 | subnational | 4 | 148819 | 100 | 51.693 | 2878.9 |
472 | 2024-11-12 14:50:25 | subnational | 2 | 86808 | 3 | 5.923 | 14656.1 |
471 | 2024-11-09 07:30:36 | subnational | 1 | 49908 | 2 | 6.300 | 7921.9 |
470 | 2024-11-09 03:17:17 | subnational | 1 | 49908 | 2 | 6.216 | 8029.0 |
469 | 2024-11-05 09:10:49 | subnational | 2 | 86808 | 3 | 10.046 | 8641.1 |
468 | 2024-11-05 09:08:18 | subnational | 1 | 49908 | 2 | 0.860 | 58032.6 |
467 | 2024-11-05 04:54:01 | subnational | 4 | 148819 | 100 | 47.020 | 3165.0 |
466 | 2024-11-05 04:53:48 | subnational | 4 | 148819 | 100 | 57.520 | 2587.3 |
465 | 2024-11-02 18:34:52 | subnational | 3 | 121633 | 22 | 27.860 | 4365.9 |
464 | 2024-10-19 18:33:21 | subnational | 2 | 86808 | 3 | 5.860 | 14813.7 |
463 | 2024-10-19 18:30:33 | subnational | 1 | 49908 | 2 | 2.126 | 23475.1 |
462 | 2024-10-18 06:49:12 | subnational | 4 | 148819 | 100 | 57.923 | 2569.3 |
461 | 2024-10-18 06:48:51 | subnational | 3 | 121633 | 22 | 22.673 | 5364.7 |
460 | 2024-10-17 09:48:03 | subnational | 4 | 148819 | 100 | 51.673 | 2880.0 |
459 | 2024-10-16 17:27:28 | subnational | 4 | 148819 | 100 | 54.300 | 2740.7 |
458 | 2024-10-13 19:03:13 | subnational | 4 | 148819 | 100 | 51.230 | 2904.9 |
457 | 2024-10-12 22:41:41 | subnational | 3 | 121633 | 22 | 17.580 | 6918.8 |
456 | 2024-10-04 05:53:39 | subnational | 3 | 121633 | 22 | 29.860 | 4073.4 |
455 | 2024-10-04 05:53:34 | subnational | 3 | 121633 | 22 | 29.266 | 4156.1 |
454 | 2024-10-04 05:53:22 | subnational | 3 | 121633 | 22 | 39.906 | 3048.0 |
453 | 2024-10-04 05:53:34 | subnational | 2 | 86808 | 3 | 9.076 | 9564.6 |