History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gussie"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 607 | 2024-04-23 03:33:44 | gussie | 1 | 48755 | 3 | 1.686 | 28917.6 |
| 606 | 2024-04-16 07:34:59 | gussie | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 605 | 2024-04-06 08:38:37 | gussie | 1 | 48755 | 3 | 2.970 | 16415.8 |
| 604 | 2024-03-28 11:42:31 | gussie | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 603 | 2024-02-05 02:39:17 | gussie | 2 | 82551 | 31 | 4.186 | 19720.7 |
| 602 | 2024-02-05 02:38:57 | gussie | 3 | 112716 | 406 | 6.216 | 18133.2 |
| 601 | 2024-02-04 14:52:06 | gussie | 3 | 112716 | 406 | 9.626 | 11709.5 |
| 600 | 2024-02-04 14:52:11 | gussie | 2 | 82551 | 31 | 2.966 | 27832.4 |
| 599 | 2024-01-19 02:40:19 | gussie | 3 | 112716 | 406 | 6.436 | 17513.4 |
| 598 | 2024-01-19 02:40:16 | gussie | 2 | 82551 | 31 | 2.310 | 35736.4 |
| 597 | 2024-01-13 13:31:14 | gussie | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 596 | 2024-01-10 20:11:03 | gussie | 2 | 82551 | 31 | 2.140 | 38575.2 |
| 595 | 2024-01-06 13:47:04 | gussie | 3 | 112716 | 406 | 5.000 | 22543.2 |
| 594 | 2024-01-06 13:47:03 | gussie | 2 | 82551 | 31 | 2.530 | 32628.9 |
| 593 | 2023-12-30 21:12:25 | gussie | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 592 | 2023-11-25 19:15:49 | gussie | 2 | 82551 | 31 | 2.470 | 33421.5 |
| 591 | 2023-11-17 23:51:23 | gussie | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 590 | 2023-11-14 04:09:27 | gussie | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 589 | 2023-11-04 19:17:00 | gussie | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 588 | 2023-10-22 19:57:43 | gussie | 1 | 48755 | 3 | 1.673 | 29142.3 |
| 587 | 2023-10-19 13:31:58 | gussie | 2 | 82551 | 31 | 2.110 | 39123.7 |
| 586 | 2023-10-19 11:14:54 | gussie | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 585 | 2023-10-18 14:15:35 | gussie | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 584 | 2023-10-12 22:55:16 | gussie | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 583 | 2023-10-11 14:04:03 | gussie | 3 | 112716 | 406 | 5.080 | 22188.2 |
| 582 | 2023-09-30 06:22:32 | gussie | 3 | 112716 | 406 | 5.360 | 21029.1 |
| 581 | 2023-09-26 07:15:10 | gussie | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 580 | 2023-09-20 12:05:47 | gussie | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 579 | 2023-09-13 14:13:51 | gussie | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 578 | 2023-08-15 15:04:04 | gussie | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 577 | 2023-07-30 19:01:26 | gussie | 2 | 82551 | 31 | 2.436 | 33887.9 |
| 576 | 2023-06-03 07:42:55 | gussie | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 575 | 2023-05-12 05:01:08 | gussie | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 574 | 2023-05-04 02:11:57 | gussie | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 573 | 2023-04-09 02:31:34 | gussie | 2 | 82551 | 31 | 2.140 | 38575.2 |
| 572 | 2023-03-06 09:10:09 | gussie | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 571 | 2023-02-14 23:29:39 | gussie | 1 | 48755 | 3 | 0.703 | 69352.8 |
| 570 | 2023-01-06 10:05:01 | gussie | 2 | 82551 | 31 | 2.046 | 40347.5 |
| 569 | 2022-12-28 07:39:46 | gussie | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 568 | 2022-10-28 17:02:42 | gussie | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 567 | 2022-09-15 03:03:43 | gussie | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 566 | 2022-09-12 06:52:23 | gussie | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 565 | 2022-09-09 15:57:05 | gussie | 2 | 82551 | 31 | 2.046 | 40347.5 |
| 564 | 2022-09-01 10:49:49 | gussie | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 563 | 2022-08-28 15:55:00 | gussie | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 562 | 2022-07-15 04:57:46 | gussie | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 561 | 2022-07-10 00:41:20 | gussie | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 560 | 2022-07-01 03:43:25 | gussie | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 559 | 2022-06-26 04:26:56 | gussie | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 558 | 2022-06-25 05:43:33 | gussie | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 557 | 2022-06-17 08:46:11 | gussie | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 556 | 2022-06-10 14:25:47 | gussie | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 555 | 2022-06-04 08:51:58 | gussie | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 554 | 2022-03-28 08:35:24 | gussie | 1 | 48755 | 3 | 1.050 | 46433.3 |
| 553 | 2022-03-06 00:56:09 | gussie | 1 | 48755 | 3 | 1.030 | 47335.0 |
| 552 | 2021-12-20 16:46:12 | gussie | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 551 | 2021-12-18 13:11:16 | gussie | 1 | 48755 | 3 | 0.753 | 64747.7 |
| 550 | 2021-12-17 06:54:49 | gussie | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 549 | 2021-12-08 23:51:47 | gussie | 3 | 112716 | 406 | 5.390 | 20912.1 |
| 548 | 2021-11-28 18:14:02 | gussie | 3 | 112716 | 406 | 4.533 | 24865.7 |
| 547 | 2021-11-28 05:17:51 | gussie | 3 | 112716 | 406 | 7.216 | 15620.3 |
| 546 | 2021-11-27 09:43:46 | gussie | 3 | 112716 | 406 | 6.373 | 17686.5 |
| 545 | 2021-11-26 20:29:51 | gussie | 3 | 112716 | 406 | 9.983 | 11290.8 |
| 544 | 2021-11-26 08:45:35 | gussie | 3 | 112716 | 406 | 5.220 | 21593.1 |
| 543 | 2021-11-25 17:08:06 | gussie | 3 | 112716 | 406 | 5.656 | 19928.6 |
| 542 | 2021-11-24 15:04:29 | gussie | 3 | 112716 | 406 | 4.626 | 24365.8 |
| 541 | 2021-11-24 02:40:08 | gussie | 3 | 112716 | 406 | 4.500 | 25048.0 |
| 540 | 2021-11-23 06:05:44 | gussie | 3 | 112716 | 406 | 5.813 | 19390.3 |
| 539 | 2021-11-22 18:10:51 | gussie | 3 | 112716 | 406 | 4.923 | 22895.8 |
| 538 | 2021-11-22 12:27:22 | gussie | 3 | 112716 | 406 | 4.533 | 24865.7 |
| 537 | 2021-11-21 09:15:25 | gussie | 3 | 112716 | 406 | 4.533 | 24865.7 |
| 536 | 2021-11-20 15:50:23 | gussie | 3 | 112716 | 406 | 4.653 | 24224.4 |
| 535 | 2021-11-11 23:38:03 | gussie | 3 | 112716 | 406 | 4.563 | 24702.2 |
| 534 | 2021-11-07 11:56:03 | gussie | 3 | 112716 | 406 | 5.093 | 22131.6 |
| 533 | 2021-11-06 17:27:19 | gussie | 3 | 112716 | 406 | 4.453 | 25312.4 |
| 532 | 2021-11-05 14:27:27 | gussie | 3 | 112716 | 406 | 5.220 | 21593.1 |
| 531 | 2021-11-03 22:10:43 | gussie | 3 | 112716 | 406 | 4.516 | 24959.3 |
| 530 | 2021-10-25 17:01:20 | gussie | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 529 | 2021-10-23 16:01:27 | gussie | 1 | 48755 | 3 | 0.716 | 68093.6 |
| 528 | 2021-10-14 18:11:47 | gussie | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 527 | 2021-10-13 22:10:01 | gussie | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 526 | 2021-10-12 13:58:34 | gussie | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 525 | 2021-10-11 16:55:43 | gussie | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 524 | 2021-10-10 13:49:57 | gussie | 1 | 48755 | 3 | 1.673 | 29142.3 |
| 523 | 2021-09-26 14:42:12 | gussie | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 522 | 2021-09-21 09:20:56 | gussie | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 521 | 2021-09-20 22:40:05 | gussie | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 520 | 2021-09-20 04:53:02 | gussie | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 519 | 2021-09-14 01:54:51 | gussie | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 518 | 2021-09-06 19:15:25 | gussie | 1 | 48755 | 3 | 0.716 | 68093.6 |
| 517 | 2021-08-19 22:54:49 | gussie | 3 | 112716 | 406 | 4.750 | 23729.7 |
| 516 | 2021-07-26 11:51:39 | gussie | 3 | 112716 | 406 | 5.000 | 22543.2 |
| 515 | 2021-07-04 17:38:46 | gussie | 3 | 112716 | 406 | 4.736 | 23799.8 |
| 514 | 2021-06-05 19:09:02 | gussie | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 513 | 2021-06-01 04:24:29 | gussie | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 512 | 2021-05-26 13:29:15 | gussie | 3 | 112716 | 406 | 5.030 | 22408.7 |
| 511 | 2021-05-06 23:14:33 | gussie | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 510 | 2021-04-20 05:56:19 | gussie | 3 | 112716 | 406 | 5.330 | 21147.5 |
| 509 | 2021-04-05 05:13:05 | gussie | 1 | 48755 | 3 | 1.610 | 30282.6 |
| 508 | 2021-03-22 04:14:58 | gussie | 3 | 112716 | 406 | 5.593 | 20153.0 |