History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"beloved"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 567 | 2024-04-23 05:38:52 | beloved | 1 | 69583 | 3 | 2.673 | 26031.8 |
| 566 | 2024-03-26 11:20:07 | beloved | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 565 | 2024-03-04 14:39:02 | beloved | 2 | 107671 | 32 | 10.843 | 9930.0 |
| 564 | 2024-03-04 12:48:46 | beloved | 2 | 107671 | 32 | 11.940 | 9017.7 |
| 563 | 2024-02-29 01:06:19 | beloved | 2 | 107671 | 32 | 5.843 | 18427.3 |
| 562 | 2024-02-28 17:52:01 | beloved | 2 | 107671 | 32 | 3.296 | 32667.2 |
| 561 | 2023-12-20 10:12:42 | beloved | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 560 | 2023-12-20 01:09:19 | beloved | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 559 | 2023-12-08 04:30:04 | beloved | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 558 | 2023-11-26 12:37:06 | beloved | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 557 | 2023-11-24 01:08:59 | beloved | 2 | 107671 | 32 | 2.826 | 38100.1 |
| 556 | 2023-11-21 04:37:31 | beloved | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 555 | 2023-11-19 23:23:25 | beloved | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 554 | 2023-10-17 22:42:24 | beloved | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 553 | 2023-10-07 00:58:21 | beloved | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 552 | 2023-09-29 11:44:07 | beloved | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 551 | 2023-08-27 21:49:49 | beloved | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 550 | 2023-08-24 07:41:25 | beloved | 2 | 107671 | 32 | 3.346 | 32179.0 |
| 549 | 2023-08-02 08:32:50 | beloved | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 548 | 2023-05-14 08:27:32 | beloved | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 547 | 2023-05-08 07:47:49 | beloved | 2 | 107671 | 32 | 3.126 | 34443.7 |
| 546 | 2023-04-29 07:12:43 | beloved | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 545 | 2023-02-18 11:24:16 | beloved | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 544 | 2023-02-15 22:46:55 | beloved | 2 | 107671 | 32 | 2.796 | 38508.9 |
| 543 | 2023-01-28 11:31:04 | beloved | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 542 | 2023-01-24 20:16:50 | beloved | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 541 | 2022-12-16 23:33:41 | beloved | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 540 | 2022-11-25 17:01:15 | beloved | 2 | 107671 | 32 | 2.796 | 38508.9 |
| 539 | 2022-10-06 21:35:16 | beloved | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 538 | 2022-10-03 07:45:02 | beloved | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 537 | 2022-08-28 05:47:38 | beloved | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 536 | 2022-06-20 03:23:10 | beloved | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 535 | 2022-04-24 05:08:06 | beloved | 2 | 107671 | 32 | 2.810 | 38317.1 |
| 534 | 2022-04-22 00:32:50 | beloved | 2 | 107671 | 32 | 3.796 | 28364.3 |
| 533 | 2022-04-17 06:53:57 | beloved | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 532 | 2022-04-15 03:49:07 | beloved | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 531 | 2022-03-01 00:16:19 | beloved | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 530 | 2022-01-09 03:53:49 | beloved | 2 | 107671 | 32 | 2.920 | 36873.6 |
| 529 | 2022-01-08 16:56:25 | beloved | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 528 | 2021-11-17 10:19:30 | beloved | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 527 | 2021-11-06 22:06:17 | beloved | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 526 | 2021-09-26 11:56:22 | beloved | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 525 | 2021-09-09 09:27:55 | beloved | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 524 | 2021-09-07 04:16:56 | beloved | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 523 | 2021-08-07 19:38:46 | beloved | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 522 | 2021-08-04 01:29:07 | beloved | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 521 | 2021-06-04 09:18:04 | beloved | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 520 | 2021-06-02 10:58:28 | beloved | 2 | 107671 | 32 | 3.373 | 31921.4 |
| 519 | 2021-05-10 04:05:38 | beloved | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 518 | 2021-05-08 05:01:59 | beloved | 2 | 107671 | 32 | 3.296 | 32667.2 |
| 517 | 2021-05-03 15:24:28 | beloved | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 516 | 2021-04-29 23:54:16 | beloved | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 515 | 2021-04-08 19:17:30 | beloved | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 514 | 2021-04-06 14:48:35 | beloved | 2 | 107671 | 32 | 2.893 | 37217.8 |
| 513 | 2021-03-22 16:50:34 | beloved | 3 | 134027 | 433 | 5.923 | 22628.2 |
| 512 | 2021-03-13 01:05:18 | beloved | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 511 | 2021-02-25 02:45:11 | beloved | 3 | 134027 | 433 | 6.060 | 22116.7 |
| 510 | 2021-01-25 12:53:20 | beloved | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 509 | 2021-01-23 13:46:23 | beloved | 1 | 69583 | 3 | 2.170 | 32065.9 |
| 508 | 2021-01-21 20:07:42 | beloved | 2 | 107671 | 32 | 3.220 | 33438.2 |
| 507 | 2020-12-22 17:11:42 | beloved | 2 | 107671 | 32 | 3.016 | 35699.9 |
| 506 | 2020-12-07 13:46:30 | beloved | 3 | 134027 | 433 | 5.953 | 22514.2 |
| 505 | 2020-11-19 08:14:30 | beloved | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 504 | 2020-10-28 19:04:10 | beloved | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 503 | 2020-10-24 10:07:27 | beloved | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 502 | 2020-10-18 12:42:35 | beloved | 2 | 107671 | 32 | 3.093 | 34811.2 |
| 501 | 2020-10-17 14:22:00 | beloved | 3 | 134027 | 433 | 6.236 | 21492.5 |
| 500 | 2020-10-08 18:34:14 | beloved | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 499 | 2020-08-20 00:44:25 | beloved | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 498 | 2020-08-14 08:20:45 | beloved | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 497 | 2020-07-21 11:35:25 | beloved | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 496 | 2020-05-29 07:23:51 | beloved | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 495 | 2020-04-22 14:31:49 | beloved | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 494 | 2020-04-17 21:12:25 | beloved | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 493 | 2020-03-28 18:07:36 | beloved | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 492 | 2020-03-27 17:05:06 | beloved | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 491 | 2020-03-26 13:08:19 | beloved | 1 | 69583 | 3 | 1.486 | 46825.7 |
| 490 | 2020-03-25 08:40:15 | beloved | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 489 | 2020-03-21 04:00:47 | beloved | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 488 | 2020-03-04 10:06:49 | beloved | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 487 | 2020-02-28 10:45:02 | beloved | 1 | 69583 | 3 | 4.250 | 16372.5 |
| 486 | 2020-02-26 20:34:07 | beloved | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 485 | 2020-02-22 07:49:46 | beloved | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 484 | 2020-02-10 18:27:47 | beloved | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 483 | 2020-02-08 17:26:56 | beloved | 1 | 69583 | 3 | 2.890 | 24077.2 |
| 482 | 2020-02-05 21:12:07 | beloved | 1 | 69583 | 3 | 2.780 | 25029.9 |
| 481 | 2020-01-31 14:58:00 | beloved | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 480 | 2020-01-31 00:57:10 | beloved | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 479 | 2020-01-25 05:14:41 | beloved | 1 | 69583 | 3 | 2.843 | 24475.2 |
| 478 | 2020-01-22 02:58:48 | beloved | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 477 | 2020-01-20 10:55:33 | beloved | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 476 | 2020-01-17 18:31:39 | beloved | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 475 | 2020-01-14 15:25:21 | beloved | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 474 | 2020-01-10 18:57:37 | beloved | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 473 | 2020-01-09 20:18:34 | beloved | 1 | 69583 | 3 | 2.110 | 32977.7 |
| 472 | 2019-12-31 08:24:12 | beloved | 1 | 69583 | 3 | 1.643 | 42351.2 |
| 471 | 2019-12-29 11:23:39 | beloved | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 470 | 2019-12-28 14:10:19 | beloved | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 469 | 2019-12-28 04:56:11 | beloved | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 468 | 2019-11-17 00:48:29 | beloved | 1 | 69583 | 3 | 1.593 | 43680.5 |