History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"upstater"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 583 | 2024-04-06 19:22:18 | upstater | 2 | 121059 | 20 | 4.516 | 26806.7 |
| 582 | 2024-04-06 10:14:56 | upstater | 2 | 121059 | 20 | 10.830 | 11178.1 |
| 581 | 2024-04-06 10:14:39 | upstater | 1 | 82945 | 5 | 6.063 | 13680.5 |
| 580 | 2024-04-06 07:35:53 | upstater | 3 | 146162 | 112 | 8.326 | 17554.9 |
| 579 | 2024-04-06 01:40:25 | upstater | 3 | 146162 | 112 | 19.250 | 7592.8 |
| 578 | 2024-04-05 23:15:06 | upstater | 1 | 82945 | 5 | 3.403 | 24374.1 |
| 577 | 2024-04-05 22:19:25 | upstater | 3 | 146162 | 112 | 7.530 | 19410.6 |
| 576 | 2024-04-05 22:19:26 | upstater | 2 | 121059 | 20 | 3.813 | 31749.0 |
| 575 | 2024-03-30 10:57:47 | upstater | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 574 | 2024-03-30 08:40:35 | upstater | 2 | 121059 | 20 | 9.266 | 13064.9 |
| 573 | 2024-03-30 08:09:53 | upstater | 1 | 82945 | 5 | 2.186 | 37943.7 |
| 572 | 2024-03-07 09:07:03 | upstater | 1 | 82945 | 5 | 5.330 | 15561.9 |
| 571 | 2024-03-06 20:11:17 | upstater | 3 | 146162 | 112 | 20.076 | 7280.4 |
| 570 | 2024-03-06 12:46:35 | upstater | 3 | 146162 | 112 | 21.283 | 6867.5 |
| 569 | 2024-03-06 04:17:24 | upstater | 3 | 146162 | 112 | 17.530 | 8337.8 |
| 568 | 2024-03-06 02:33:25 | upstater | 3 | 146162 | 112 | 9.470 | 15434.2 |
| 567 | 2024-03-06 02:33:27 | upstater | 2 | 121059 | 20 | 3.826 | 31641.1 |
| 566 | 2024-03-06 02:33:24 | upstater | 1 | 82945 | 5 | 1.440 | 57600.7 |
| 565 | 2024-03-01 15:32:23 | upstater | 2 | 121059 | 20 | 11.890 | 10181.6 |
| 564 | 2024-03-01 15:32:17 | upstater | 1 | 82945 | 5 | 3.720 | 22297.0 |
| 563 | 2024-03-01 13:51:04 | upstater | 3 | 146162 | 112 | 9.046 | 16157.6 |
| 562 | 2024-02-29 03:31:57 | upstater | 1 | 82945 | 5 | 2.953 | 28088.4 |
| 561 | 2024-02-29 01:25:59 | upstater | 3 | 146162 | 112 | 7.890 | 18525.0 |
| 560 | 2024-02-29 01:25:59 | upstater | 2 | 121059 | 20 | 3.736 | 32403.4 |
| 559 | 2024-02-29 01:25:44 | upstater | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 558 | 2024-02-27 10:03:27 | upstater | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 557 | 2024-02-14 13:44:27 | upstater | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 556 | 2024-02-08 12:12:53 | upstater | 2 | 121059 | 20 | 14.156 | 8551.8 |
| 555 | 2024-02-08 12:12:49 | upstater | 3 | 146162 | 112 | 14.016 | 10428.2 |
| 554 | 2024-02-03 23:45:23 | upstater | 3 | 146162 | 112 | 6.626 | 22058.9 |
| 553 | 2024-02-03 23:45:19 | upstater | 2 | 121059 | 20 | 2.983 | 40583.0 |
| 552 | 2024-02-03 23:45:15 | upstater | 1 | 82945 | 5 | 1.203 | 68948.5 |
| 551 | 2024-02-02 05:34:16 | upstater | 3 | 146162 | 112 | 6.406 | 22816.4 |
| 550 | 2024-02-02 05:34:08 | upstater | 2 | 121059 | 20 | 3.423 | 35366.3 |
| 549 | 2024-01-31 14:02:43 | upstater | 2 | 121059 | 20 | 3.576 | 33853.2 |
| 548 | 2024-01-30 16:43:59 | upstater | 1 | 82945 | 5 | 2.516 | 32967.0 |
| 547 | 2024-01-22 12:15:55 | upstater | 3 | 146162 | 112 | 16.876 | 8660.9 |
| 546 | 2024-01-22 04:22:50 | upstater | 3 | 146162 | 112 | 7.546 | 19369.5 |
| 545 | 2024-01-18 17:36:46 | upstater | 3 | 146162 | 112 | 7.186 | 20339.8 |
| 544 | 2023-12-31 15:44:11 | upstater | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 543 | 2023-12-22 11:27:48 | upstater | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 542 | 2023-12-06 16:57:10 | upstater | 2 | 121059 | 20 | 3.236 | 37410.1 |
| 541 | 2023-12-04 15:56:43 | upstater | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 540 | 2023-12-01 23:46:58 | upstater | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 539 | 2023-11-02 00:45:06 | upstater | 3 | 146162 | 112 | 6.000 | 24360.3 |
| 538 | 2023-10-24 16:20:30 | upstater | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 537 | 2023-10-17 04:27:45 | upstater | 1 | 82945 | 5 | 2.060 | 40264.6 |
| 536 | 2023-09-16 19:00:33 | upstater | 1 | 82945 | 5 | 1.560 | 53169.9 |
| 535 | 2023-09-03 16:46:47 | upstater | 2 | 121059 | 20 | 3.343 | 36212.7 |
| 534 | 2023-08-10 01:32:32 | upstater | 3 | 146162 | 112 | 7.046 | 20744.0 |
| 533 | 2023-06-29 23:21:03 | upstater | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 532 | 2023-04-22 20:27:00 | upstater | 3 | 146162 | 112 | 6.640 | 22012.3 |
| 531 | 2023-04-07 06:35:51 | upstater | 1 | 82945 | 5 | 1.216 | 68211.3 |
| 530 | 2023-01-29 19:10:30 | upstater | 3 | 146162 | 112 | 5.936 | 24623.0 |
| 529 | 2023-01-22 07:36:19 | upstater | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 528 | 2022-12-19 15:13:56 | upstater | 2 | 121059 | 20 | 6.030 | 20076.1 |
| 527 | 2022-11-18 10:51:12 | upstater | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 526 | 2022-11-08 23:01:04 | upstater | 3 | 146162 | 112 | 6.173 | 23677.6 |
| 525 | 2022-10-01 10:52:39 | upstater | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 524 | 2022-08-13 16:03:45 | upstater | 2 | 121059 | 20 | 3.080 | 39304.9 |
| 523 | 2022-07-10 03:16:50 | upstater | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 522 | 2022-06-12 02:57:57 | upstater | 1 | 82945 | 5 | 1.216 | 68211.3 |
| 521 | 2022-05-18 15:18:22 | upstater | 1 | 82945 | 5 | 1.233 | 67270.9 |
| 520 | 2022-05-14 14:14:24 | upstater | 3 | 146162 | 112 | 6.703 | 21805.5 |
| 519 | 2022-03-18 05:16:12 | upstater | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 518 | 2022-03-14 20:13:38 | upstater | 1 | 82945 | 5 | 1.440 | 57600.7 |
| 517 | 2022-03-12 15:16:47 | upstater | 1 | 82945 | 5 | 1.403 | 59119.7 |
| 516 | 2022-01-11 21:34:46 | upstater | 3 | 146162 | 112 | 7.376 | 19815.9 |
| 515 | 2021-12-25 02:50:50 | upstater | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 514 | 2021-12-23 01:03:23 | upstater | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 513 | 2021-11-09 07:02:03 | upstater | 1 | 82945 | 5 | 1.233 | 67270.9 |
| 512 | 2021-09-11 03:16:26 | upstater | 1 | 82945 | 5 | 1.236 | 67107.6 |
| 511 | 2021-07-27 21:20:35 | upstater | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 510 | 2021-04-14 16:20:40 | upstater | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 509 | 2021-02-21 04:30:18 | upstater | 1 | 82945 | 5 | 1.216 | 68211.3 |
| 508 | 2020-12-30 10:36:16 | upstater | 1 | 82945 | 5 | 1.233 | 67270.9 |
| 507 | 2020-12-02 16:39:05 | upstater | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 506 | 2020-11-01 05:58:38 | upstater | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 505 | 2020-10-28 00:17:27 | upstater | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 504 | 2020-10-22 20:19:22 | upstater | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 503 | 2020-10-17 04:21:09 | upstater | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 502 | 2020-08-20 12:52:20 | upstater | 1 | 82945 | 5 | 1.346 | 61623.3 |
| 501 | 2020-08-09 18:19:01 | upstater | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 500 | 2020-05-16 06:37:00 | upstater | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 499 | 2020-04-08 20:10:11 | upstater | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 498 | 2020-04-03 23:04:02 | upstater | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 497 | 2020-03-21 05:30:10 | upstater | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 496 | 2020-02-25 09:39:54 | upstater | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 495 | 2020-02-13 08:37:17 | upstater | 1 | 82945 | 5 | 3.093 | 26817.0 |
| 494 | 2020-02-03 20:26:34 | upstater | 1 | 82945 | 5 | 1.606 | 51646.9 |
| 493 | 2020-02-03 18:32:51 | upstater | 1 | 82945 | 5 | 1.670 | 49667.7 |
| 492 | 2020-02-03 14:25:32 | upstater | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 491 | 2020-02-01 09:40:47 | upstater | 1 | 82945 | 5 | 1.656 | 50087.6 |
| 490 | 2020-01-22 10:20:38 | upstater | 1 | 82945 | 5 | 4.640 | 17876.1 |
| 489 | 2020-01-22 01:56:02 | upstater | 1 | 82945 | 5 | 4.830 | 17172.9 |
| 488 | 2020-01-15 12:33:21 | upstater | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 487 | 2020-01-10 08:50:16 | upstater | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 486 | 2019-12-31 00:57:48 | upstater | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 485 | 2019-12-30 17:33:33 | upstater | 1 | 82945 | 5 | 2.123 | 39069.7 |
| 484 | 2019-12-29 06:22:39 | upstater | 1 | 82945 | 5 | 1.516 | 54713.1 |