History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gillies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 586 | 2024-04-16 07:55:54 | gillies | 1 | 69583 | 13 | 1.216 | 57222.9 |
| 585 | 2024-03-03 10:58:51 | gillies | 2 | 107671 | 82 | 7.126 | 15109.6 |
| 584 | 2024-03-03 05:34:46 | gillies | 2 | 107671 | 82 | 3.170 | 33965.6 |
| 583 | 2024-02-27 00:44:57 | gillies | 2 | 107671 | 82 | 7.076 | 15216.4 |
| 582 | 2024-02-26 20:13:05 | gillies | 2 | 107671 | 82 | 6.936 | 15523.5 |
| 581 | 2024-02-18 03:43:39 | gillies | 3 | 134027 | 638 | 11.160 | 12009.6 |
| 580 | 2024-02-17 19:10:00 | gillies | 3 | 134027 | 638 | 12.643 | 10600.9 |
| 579 | 2024-02-13 21:20:20 | gillies | 3 | 134027 | 638 | 8.250 | 16245.7 |
| 578 | 2024-02-13 13:06:14 | gillies | 3 | 134027 | 638 | 21.893 | 6121.9 |
| 577 | 2024-02-12 15:00:00 | gillies | 3 | 134027 | 638 | 16.283 | 8231.1 |
| 576 | 2024-02-12 14:59:19 | gillies | 3 | 134027 | 638 | 9.110 | 14712.1 |
| 575 | 2024-01-24 08:41:40 | gillies | 2 | 107671 | 82 | 2.720 | 39584.9 |
| 574 | 2024-01-24 03:41:16 | gillies | 1 | 69583 | 13 | 1.046 | 66522.9 |
| 573 | 2024-01-17 13:57:12 | gillies | 3 | 134027 | 638 | 7.076 | 18941.1 |
| 572 | 2024-01-08 05:22:08 | gillies | 3 | 134027 | 638 | 7.423 | 18055.6 |
| 571 | 2024-01-02 15:03:57 | gillies | 3 | 134027 | 638 | 6.686 | 20045.9 |
| 570 | 2024-01-01 02:10:21 | gillies | 1 | 69583 | 13 | 1.140 | 61037.7 |
| 569 | 2023-12-30 21:25:14 | gillies | 1 | 69583 | 13 | 1.233 | 56433.9 |
| 568 | 2023-12-27 19:32:57 | gillies | 3 | 134027 | 638 | 7.000 | 19146.7 |
| 567 | 2023-12-27 19:32:58 | gillies | 2 | 107671 | 82 | 3.436 | 31336.1 |
| 566 | 2023-12-02 12:06:13 | gillies | 1 | 69583 | 13 | 1.063 | 65459.1 |
| 565 | 2023-11-21 20:40:30 | gillies | 2 | 107671 | 82 | 2.923 | 36835.8 |
| 564 | 2023-11-18 17:14:06 | gillies | 1 | 69583 | 13 | 1.126 | 61796.6 |
| 563 | 2023-11-16 03:49:04 | gillies | 3 | 134027 | 638 | 6.860 | 19537.5 |
| 562 | 2023-11-14 09:08:32 | gillies | 1 | 69583 | 13 | 1.156 | 60192.9 |
| 561 | 2023-11-09 12:54:21 | gillies | 1 | 69583 | 13 | 1.156 | 60192.9 |
| 560 | 2023-10-30 08:21:16 | gillies | 1 | 69583 | 13 | 1.153 | 60349.5 |
| 559 | 2023-10-23 13:12:12 | gillies | 1 | 69583 | 13 | 1.186 | 58670.3 |
| 558 | 2023-10-18 14:41:33 | gillies | 1 | 69583 | 13 | 1.216 | 57222.9 |
| 557 | 2023-10-13 23:10:16 | gillies | 1 | 69583 | 13 | 1.093 | 63662.4 |
| 556 | 2023-10-13 21:22:02 | gillies | 1 | 69583 | 13 | 1.126 | 61796.6 |
| 555 | 2023-10-06 02:06:21 | gillies | 1 | 69583 | 13 | 1.173 | 59320.5 |
| 554 | 2023-09-25 23:00:13 | gillies | 1 | 69583 | 13 | 1.046 | 66522.9 |
| 553 | 2023-09-13 06:00:54 | gillies | 1 | 69583 | 13 | 1.093 | 63662.4 |
| 552 | 2023-09-11 16:40:34 | gillies | 1 | 69583 | 13 | 1.233 | 56433.9 |
| 551 | 2023-08-21 20:19:26 | gillies | 2 | 107671 | 82 | 2.813 | 38276.2 |
| 550 | 2023-08-17 01:09:46 | gillies | 3 | 134027 | 638 | 6.266 | 21389.6 |
| 549 | 2023-08-15 16:59:04 | gillies | 1 | 69583 | 13 | 1.046 | 66522.9 |
| 548 | 2023-08-15 15:51:50 | gillies | 1 | 69583 | 13 | 1.046 | 66522.9 |
| 547 | 2023-07-03 07:50:47 | gillies | 1 | 69583 | 13 | 1.110 | 62687.4 |
| 546 | 2023-05-12 05:57:50 | gillies | 1 | 69583 | 13 | 1.046 | 66522.9 |
| 545 | 2023-05-05 15:47:50 | gillies | 2 | 107671 | 82 | 2.716 | 39643.2 |
| 544 | 2023-05-02 05:52:03 | gillies | 3 | 134027 | 638 | 5.550 | 24149.0 |
| 543 | 2023-03-26 20:29:59 | gillies | 1 | 69583 | 13 | 1.153 | 60349.5 |
| 542 | 2023-03-07 14:28:18 | gillies | 3 | 134027 | 638 | 5.936 | 22578.7 |
| 541 | 2023-03-06 10:01:33 | gillies | 1 | 69583 | 13 | 1.050 | 66269.5 |
| 540 | 2023-02-11 21:05:41 | gillies | 2 | 107671 | 82 | 2.796 | 38508.9 |
| 539 | 2023-02-07 09:10:03 | gillies | 3 | 134027 | 638 | 6.300 | 21274.1 |
| 538 | 2022-12-28 08:16:41 | gillies | 1 | 69583 | 13 | 1.156 | 60192.9 |
| 537 | 2022-12-18 05:15:54 | gillies | 1 | 69583 | 13 | 1.063 | 65459.1 |
| 536 | 2022-11-23 22:36:39 | gillies | 2 | 107671 | 82 | 2.763 | 38968.9 |
| 535 | 2022-11-19 09:22:16 | gillies | 3 | 134027 | 638 | 6.313 | 21230.3 |
| 534 | 2022-09-15 03:56:00 | gillies | 1 | 69583 | 13 | 1.046 | 66522.9 |
| 533 | 2022-09-07 12:34:20 | gillies | 1 | 69583 | 13 | 1.046 | 66522.9 |
| 532 | 2022-08-07 16:54:08 | gillies | 1 | 69583 | 13 | 1.046 | 66522.9 |
| 531 | 2022-07-12 15:39:15 | gillies | 1 | 69583 | 13 | 1.033 | 67360.1 |
| 530 | 2022-06-27 20:03:02 | gillies | 3 | 134027 | 638 | 5.686 | 23571.4 |
| 529 | 2022-06-25 21:29:30 | gillies | 1 | 69583 | 13 | 1.156 | 60192.9 |
| 528 | 2022-06-23 12:29:22 | gillies | 3 | 134027 | 638 | 5.673 | 23625.4 |
| 527 | 2022-05-29 11:12:24 | gillies | 1 | 69583 | 13 | 1.173 | 59320.5 |
| 526 | 2022-04-30 11:36:23 | gillies | 2 | 107671 | 82 | 2.843 | 37872.3 |
| 525 | 2022-03-12 23:56:32 | gillies | 1 | 69583 | 13 | 1.060 | 65644.3 |
| 524 | 2022-03-11 06:55:26 | gillies | 1 | 69583 | 13 | 1.076 | 64668.2 |
| 523 | 2022-03-10 16:42:41 | gillies | 1 | 69583 | 13 | 1.436 | 48456.1 |
| 522 | 2022-03-09 15:21:52 | gillies | 1 | 69583 | 13 | 1.313 | 52995.4 |
| 521 | 2022-03-08 11:22:02 | gillies | 1 | 69583 | 13 | 1.560 | 44604.5 |
| 520 | 2022-03-07 15:11:11 | gillies | 1 | 69583 | 13 | 1.483 | 46920.4 |
| 519 | 2022-03-06 13:56:32 | gillies | 1 | 69583 | 13 | 1.063 | 65459.1 |
| 518 | 2022-03-05 13:36:56 | gillies | 1 | 69583 | 13 | 2.436 | 28564.4 |
| 517 | 2022-03-04 13:31:52 | gillies | 1 | 69583 | 13 | 1.326 | 52475.9 |
| 516 | 2022-03-03 07:10:40 | gillies | 1 | 69583 | 13 | 1.220 | 57035.2 |
| 515 | 2022-03-02 17:23:02 | gillies | 1 | 69583 | 13 | 1.203 | 57841.2 |
| 514 | 2022-02-21 15:07:39 | gillies | 1 | 69583 | 13 | 1.140 | 61037.7 |
| 513 | 2022-01-06 16:16:14 | gillies | 2 | 107671 | 82 | 2.970 | 36252.9 |
| 512 | 2021-12-23 07:24:02 | gillies | 1 | 69583 | 13 | 1.186 | 58670.3 |
| 511 | 2021-12-21 03:51:33 | gillies | 1 | 69583 | 13 | 1.190 | 58473.1 |
| 510 | 2021-11-20 04:48:41 | gillies | 1 | 69583 | 13 | 1.156 | 60192.9 |
| 509 | 2021-10-30 11:00:49 | gillies | 1 | 69583 | 13 | 1.313 | 52995.4 |
| 508 | 2021-10-29 09:41:33 | gillies | 1 | 69583 | 13 | 1.110 | 62687.4 |
| 507 | 2021-10-28 22:22:06 | gillies | 1 | 69583 | 13 | 1.173 | 59320.5 |
| 506 | 2021-10-28 04:32:59 | gillies | 1 | 69583 | 13 | 1.140 | 61037.7 |
| 505 | 2021-10-27 18:10:22 | gillies | 1 | 69583 | 13 | 1.203 | 57841.2 |
| 504 | 2021-10-26 03:33:54 | gillies | 1 | 69583 | 13 | 1.030 | 67556.3 |
| 503 | 2021-09-21 16:27:24 | gillies | 1 | 69583 | 13 | 1.063 | 65459.1 |
| 502 | 2021-09-20 17:48:40 | gillies | 1 | 69583 | 13 | 1.080 | 64428.7 |
| 501 | 2021-09-14 06:32:55 | gillies | 1 | 69583 | 13 | 1.170 | 59472.6 |
| 500 | 2021-09-14 06:29:40 | gillies | 1 | 69583 | 13 | 1.156 | 60192.9 |
| 499 | 2021-09-05 18:48:05 | gillies | 1 | 69583 | 13 | 1.186 | 58670.3 |
| 498 | 2021-08-27 17:05:07 | gillies | 1 | 69583 | 13 | 1.063 | 65459.1 |
| 497 | 2021-08-20 14:46:16 | gillies | 1 | 69583 | 13 | 1.153 | 60349.5 |
| 496 | 2021-06-19 19:57:36 | gillies | 1 | 69583 | 13 | 1.170 | 59472.6 |
| 495 | 2021-06-19 19:52:49 | gillies | 1 | 69583 | 13 | 1.203 | 57841.2 |
| 494 | 2021-06-19 13:16:19 | gillies | 1 | 69583 | 13 | 1.060 | 65644.3 |
| 493 | 2021-06-18 20:14:07 | gillies | 1 | 69583 | 13 | 1.156 | 60192.9 |
| 492 | 2021-06-18 18:24:48 | gillies | 1 | 69583 | 13 | 1.030 | 67556.3 |
| 491 | 2021-06-17 23:59:22 | gillies | 1 | 69583 | 13 | 1.173 | 59320.5 |
| 490 | 2021-06-17 14:04:11 | gillies | 1 | 69583 | 13 | 1.080 | 64428.7 |
| 489 | 2021-06-16 17:34:28 | gillies | 3 | 134027 | 638 | 9.686 | 13837.2 |
| 488 | 2021-06-09 03:05:22 | gillies | 1 | 69583 | 13 | 1.030 | 67556.3 |
| 487 | 2021-06-08 12:01:51 | gillies | 1 | 69583 | 13 | 1.063 | 65459.1 |