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 |
| 585 | 2025-12-15 08:28:45 | subnational | 1 | 49908 | 2 | 0.796 | 62698.5 |
| 584 | 2025-12-01 00:56:47 | subnational | 1 | 49908 | 2 | 0.923 | 54071.5 |
| 583 | 2025-11-30 09:33:47 | subnational | 1 | 49908 | 2 | 0.873 | 57168.4 |
| 582 | 2025-11-28 13:56:27 | subnational | 1 | 49908 | 2 | 0.873 | 57168.4 |
| 581 | 2025-11-27 02:18:13 | subnational | 1 | 49908 | 2 | 0.936 | 53320.5 |
| 580 | 2025-11-24 01:53:21 | subnational | 1 | 49908 | 2 | 1.313 | 38010.7 |
| 579 | 2025-11-20 13:35:05 | subnational | 1 | 49908 | 2 | 0.906 | 55086.1 |
| 578 | 2025-11-18 16:01:30 | subnational | 1 | 49908 | 2 | 0.876 | 56972.6 |
| 577 | 2025-11-17 07:16:44 | subnational | 1 | 49908 | 2 | 0.876 | 56972.6 |
| 576 | 2025-11-16 05:19:54 | subnational | 2 | 86808 | 3 | 2.470 | 35144.9 |
| 575 | 2025-11-07 12:51:41 | subnational | 1 | 49908 | 2 | 0.750 | 66544.0 |
| 574 | 2025-10-31 02:07:52 | subnational | 1 | 49908 | 2 | 0.780 | 63984.6 |
| 573 | 2025-10-30 10:34:25 | subnational | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 572 | 2025-10-29 23:19:28 | subnational | 1 | 49908 | 2 | 0.780 | 63984.6 |
| 571 | 2025-10-24 17:20:36 | subnational | 2 | 86808 | 3 | 2.126 | 40831.6 |
| 570 | 2025-10-18 02:41:43 | subnational | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 569 | 2025-10-17 08:23:16 | subnational | 1 | 49908 | 2 | 0.856 | 58303.7 |
| 568 | 2025-10-16 14:45:47 | subnational | 1 | 49908 | 2 | 0.796 | 62698.5 |
| 567 | 2025-10-16 07:42:53 | subnational | 1 | 49908 | 2 | 1.796 | 27788.4 |
| 566 | 2025-10-15 06:09:39 | subnational | 4 | 148819 | 100 | 8.110 | 18350.1 |
| 565 | 2025-10-15 03:15:31 | subnational | 1 | 49908 | 2 | 0.826 | 60421.3 |
| 564 | 2025-09-30 17:45:42 | subnational | 1 | 49908 | 2 | 0.906 | 55086.1 |
| 563 | 2025-09-29 10:37:13 | subnational | 1 | 49908 | 2 | 0.830 | 60130.1 |
| 562 | 2025-09-28 16:44:32 | subnational | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 561 | 2025-09-22 13:48:27 | subnational | 1 | 49908 | 2 | 0.780 | 63984.6 |
| 560 | 2025-09-15 17:08:37 | subnational | 1 | 49908 | 2 | 0.903 | 55269.1 |
| 559 | 2025-09-13 08:12:50 | subnational | 1 | 49908 | 2 | 0.843 | 59202.8 |
| 558 | 2025-09-13 03:02:23 | subnational | 1 | 49908 | 2 | 0.876 | 56972.6 |
| 557 | 2025-09-12 03:12:39 | subnational | 1 | 49908 | 2 | 0.923 | 54071.5 |
| 556 | 2025-09-10 12:13:30 | subnational | 1 | 49908 | 2 | 0.873 | 57168.4 |
| 555 | 2025-08-29 11:31:39 | subnational | 1 | 49908 | 2 | 0.843 | 59202.8 |
| 554 | 2025-08-29 01:37:43 | subnational | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 553 | 2025-08-23 13:16:09 | subnational | 1 | 49908 | 2 | 2.173 | 22967.3 |
| 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 |