History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"upstate"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 574 | 2025-11-14 01:47:56 | upstate | 1 | 69583 | 6 | 1.060 | 65644.3 |
| 573 | 2025-11-13 10:53:16 | upstate | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 572 | 2025-11-10 23:51:00 | upstate | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 571 | 2025-11-04 17:18:56 | upstate | 1 | 69583 | 6 | 1.200 | 57985.8 |
| 570 | 2025-10-23 06:47:12 | upstate | 1 | 69583 | 6 | 4.483 | 15521.5 |
| 569 | 2025-10-23 00:20:17 | upstate | 1 | 69583 | 6 | 5.420 | 12838.2 |
| 568 | 2025-10-18 14:06:08 | upstate | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 567 | 2025-10-18 14:06:01 | upstate | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 566 | 2025-10-17 10:18:51 | upstate | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 565 | 2025-10-17 01:17:43 | upstate | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 564 | 2025-10-16 19:05:28 | upstate | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 563 | 2025-10-11 22:27:51 | upstate | 2 | 107671 | 35 | 2.783 | 38688.8 |
| 562 | 2025-09-28 17:42:54 | upstate | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 561 | 2025-09-28 13:09:53 | upstate | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 560 | 2025-09-26 20:06:02 | upstate | 1 | 69583 | 6 | 1.283 | 54234.6 |
| 559 | 2025-09-26 17:59:45 | upstate | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 558 | 2025-09-07 22:57:20 | upstate | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 557 | 2025-08-28 13:17:25 | upstate | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 556 | 2025-08-28 12:33:02 | upstate | 1 | 69583 | 6 | 1.296 | 53690.6 |
| 555 | 2025-08-27 23:01:14 | upstate | 1 | 69583 | 6 | 4.936 | 14097.0 |
| 554 | 2025-08-26 19:42:00 | upstate | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 553 | 2025-08-20 04:24:46 | upstate | 2 | 107671 | 35 | 3.216 | 33479.8 |
| 552 | 2025-08-17 13:38:50 | upstate | 1 | 69583 | 6 | 1.986 | 35036.8 |
| 551 | 2025-08-13 19:50:33 | upstate | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 550 | 2025-08-09 06:41:35 | upstate | 1 | 69583 | 6 | 2.796 | 24886.6 |
| 549 | 2025-08-01 08:11:17 | upstate | 1 | 69583 | 6 | 2.360 | 29484.3 |
| 548 | 2025-07-25 10:17:41 | upstate | 1 | 69583 | 6 | 3.063 | 22717.3 |
| 547 | 2025-07-23 17:54:22 | upstate | 1 | 69583 | 6 | 5.376 | 12943.3 |
| 546 | 2025-07-23 01:48:50 | upstate | 1 | 69583 | 6 | 6.220 | 11187.0 |
| 545 | 2025-07-14 10:24:35 | upstate | 2 | 107671 | 35 | 19.596 | 5494.5 |
| 544 | 2025-07-13 17:26:29 | upstate | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 543 | 2025-07-13 12:56:50 | upstate | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 542 | 2025-07-04 06:25:46 | upstate | 1 | 69583 | 6 | 5.733 | 12137.3 |
| 541 | 2025-06-30 00:59:14 | upstate | 3 | 134027 | 210 | 33.140 | 4044.3 |
| 540 | 2025-06-28 14:32:07 | upstate | 3 | 134027 | 210 | 6.780 | 19768.0 |
| 539 | 2025-06-28 05:04:04 | upstate | 2 | 107671 | 35 | 15.686 | 6864.1 |
| 538 | 2025-06-27 19:17:07 | upstate | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 537 | 2025-06-27 14:41:05 | upstate | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 536 | 2025-06-20 23:31:08 | upstate | 1 | 69583 | 6 | 7.186 | 9683.1 |
| 535 | 2025-06-20 21:55:23 | upstate | 1 | 69583 | 6 | 5.343 | 13023.2 |
| 534 | 2025-06-14 13:33:45 | upstate | 1 | 69583 | 6 | 3.000 | 23194.3 |
| 533 | 2025-06-04 12:40:47 | upstate | 1 | 69583 | 6 | 8.250 | 8434.3 |
| 532 | 2025-06-04 06:14:16 | upstate | 1 | 69583 | 6 | 2.640 | 26357.2 |
| 531 | 2025-05-26 16:04:14 | upstate | 1 | 69583 | 6 | 2.873 | 24219.6 |
| 530 | 2025-05-24 19:38:39 | upstate | 3 | 134027 | 210 | 48.283 | 2775.9 |
| 529 | 2025-05-24 12:06:51 | upstate | 3 | 134027 | 210 | 44.550 | 3008.5 |
| 528 | 2025-05-23 00:13:45 | upstate | 3 | 134027 | 210 | 10.813 | 12395.0 |
| 527 | 2025-05-22 00:54:31 | upstate | 3 | 134027 | 210 | 41.690 | 3214.8 |
| 526 | 2025-05-21 20:19:23 | upstate | 1 | 69583 | 6 | 2.873 | 24219.6 |
| 525 | 2025-05-21 04:48:33 | upstate | 3 | 134027 | 210 | 5.546 | 24166.4 |
| 524 | 2025-05-20 19:28:46 | upstate | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 523 | 2025-05-19 23:36:17 | upstate | 1 | 69583 | 6 | 3.986 | 17456.8 |
| 522 | 2025-05-04 13:19:27 | upstate | 1 | 69583 | 6 | 5.110 | 13617.0 |
| 521 | 2025-05-03 17:28:05 | upstate | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 520 | 2025-05-02 12:10:11 | upstate | 1 | 69583 | 6 | 2.843 | 24475.2 |
| 519 | 2025-04-25 14:07:18 | upstate | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 518 | 2025-04-23 02:45:01 | upstate | 2 | 107671 | 35 | 14.530 | 7410.3 |
| 517 | 2025-04-21 14:51:27 | upstate | 3 | 134027 | 210 | 35.000 | 3829.3 |
| 516 | 2025-04-20 23:37:50 | upstate | 3 | 134027 | 210 | 42.546 | 3150.2 |
| 515 | 2025-04-19 19:59:49 | upstate | 1 | 69583 | 6 | 6.780 | 10263.0 |
| 514 | 2025-04-18 23:15:10 | upstate | 3 | 134027 | 210 | 44.036 | 3043.6 |
| 513 | 2025-04-17 16:56:22 | upstate | 3 | 134027 | 210 | 6.656 | 20136.3 |
| 512 | 2025-04-13 15:01:01 | upstate | 1 | 69583 | 6 | 1.236 | 56296.9 |
| 511 | 2025-04-02 05:59:27 | upstate | 1 | 69583 | 6 | 8.470 | 8215.2 |
| 510 | 2025-03-31 14:54:46 | upstate | 1 | 69583 | 6 | 6.750 | 10308.6 |
| 509 | 2025-03-29 15:43:03 | upstate | 1 | 69583 | 6 | 7.046 | 9875.5 |
| 508 | 2025-03-19 21:01:48 | upstate | 1 | 69583 | 6 | 3.673 | 18944.5 |
| 507 | 2025-03-18 05:53:33 | upstate | 1 | 69583 | 6 | 2.843 | 24475.2 |
| 506 | 2025-03-17 13:32:03 | upstate | 1 | 69583 | 6 | 4.000 | 17395.8 |
| 505 | 2025-03-15 05:29:25 | upstate | 1 | 69583 | 6 | 4.940 | 14085.6 |
| 504 | 2025-03-12 16:57:05 | upstate | 2 | 107671 | 35 | 28.596 | 3765.2 |
| 503 | 2025-03-12 12:55:29 | upstate | 2 | 107671 | 35 | 13.503 | 7973.9 |
| 502 | 2025-03-08 20:27:36 | upstate | 2 | 107671 | 35 | 9.390 | 11466.6 |
| 501 | 2025-03-08 07:14:04 | upstate | 2 | 107671 | 35 | 11.610 | 9274.0 |
| 500 | 2025-03-01 19:05:22 | upstate | 1 | 69583 | 6 | 5.783 | 12032.3 |
| 499 | 2025-02-28 05:34:08 | upstate | 3 | 134027 | 210 | 32.860 | 4078.7 |
| 498 | 2025-02-28 02:53:15 | upstate | 3 | 134027 | 210 | 35.846 | 3739.0 |
| 497 | 2025-02-27 09:25:02 | upstate | 1 | 69583 | 6 | 4.233 | 16438.2 |
| 496 | 2025-02-26 12:03:58 | upstate | 1 | 69583 | 6 | 2.890 | 24077.2 |
| 495 | 2025-02-26 11:46:53 | upstate | 1 | 69583 | 6 | 3.876 | 17952.3 |
| 494 | 2025-02-26 08:38:09 | upstate | 3 | 134027 | 210 | 36.533 | 3668.7 |
| 493 | 2025-02-26 06:37:05 | upstate | 3 | 134027 | 210 | 42.753 | 3134.9 |
| 492 | 2025-02-26 05:44:49 | upstate | 3 | 134027 | 210 | 30.766 | 4356.3 |
| 491 | 2025-02-22 22:06:50 | upstate | 1 | 69583 | 6 | 5.826 | 11943.5 |
| 490 | 2025-02-17 13:03:45 | upstate | 3 | 134027 | 210 | 31.720 | 4225.3 |
| 489 | 2025-02-16 20:29:54 | upstate | 3 | 134027 | 210 | 22.720 | 5899.1 |
| 488 | 2025-02-12 23:23:21 | upstate | 3 | 134027 | 210 | 33.313 | 4023.3 |
| 487 | 2025-02-06 05:01:29 | upstate | 1 | 69583 | 6 | 4.873 | 14279.3 |
| 486 | 2025-02-02 08:58:36 | upstate | 1 | 69583 | 6 | 5.326 | 13064.8 |
| 485 | 2025-01-27 06:36:49 | upstate | 2 | 107671 | 35 | 7.606 | 14156.1 |
| 484 | 2025-01-27 06:35:31 | upstate | 3 | 134027 | 210 | 32.023 | 4185.3 |
| 483 | 2025-01-26 23:41:32 | upstate | 3 | 134027 | 210 | 9.800 | 13676.2 |
| 482 | 2025-01-24 10:25:25 | upstate | 2 | 107671 | 35 | 20.140 | 5346.1 |
| 481 | 2025-01-24 10:24:17 | upstate | 3 | 134027 | 210 | 29.550 | 4535.6 |
| 480 | 2025-01-24 10:23:56 | upstate | 1 | 69583 | 6 | 3.093 | 22496.9 |
| 479 | 2025-01-17 18:23:11 | upstate | 1 | 69583 | 6 | 5.390 | 12909.6 |
| 478 | 2024-12-27 03:36:05 | upstate | 1 | 69583 | 6 | 5.410 | 12861.9 |
| 477 | 2024-12-21 07:39:59 | upstate | 2 | 107671 | 35 | 23.176 | 4645.8 |
| 476 | 2024-12-17 14:47:34 | upstate | 3 | 134027 | 210 | 20.096 | 6669.3 |
| 475 | 2024-12-16 23:23:04 | upstate | 3 | 134027 | 210 | 33.970 | 3945.5 |