History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fancied"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 579 | 2024-04-18 00:16:39 | fancied | 1 | 69583 | 3 | 1.953 | 35628.8 |
| 578 | 2024-03-30 00:32:14 | fancied | 3 | 134027 | 434 | 15.846 | 8458.1 |
| 577 | 2024-03-29 10:12:29 | fancied | 2 | 107671 | 27 | 3.516 | 30623.2 |
| 576 | 2024-03-29 07:17:26 | fancied | 3 | 134027 | 434 | 16.986 | 7890.4 |
| 575 | 2024-03-29 06:59:34 | fancied | 2 | 107671 | 27 | 11.673 | 9223.9 |
| 574 | 2024-03-29 06:59:37 | fancied | 3 | 134027 | 434 | 8.313 | 16122.6 |
| 573 | 2024-03-29 06:25:20 | fancied | 1 | 69583 | 3 | 2.860 | 24329.7 |
| 572 | 2024-03-23 09:36:05 | fancied | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 571 | 2024-02-28 00:09:26 | fancied | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 570 | 2024-02-07 22:34:16 | fancied | 3 | 134027 | 434 | 24.643 | 5438.7 |
| 569 | 2024-02-06 02:11:46 | fancied | 3 | 134027 | 434 | 10.076 | 13301.6 |
| 568 | 2024-01-26 10:20:29 | fancied | 3 | 134027 | 434 | 6.360 | 21073.4 |
| 567 | 2024-01-26 09:27:43 | fancied | 3 | 134027 | 434 | 8.313 | 16122.6 |
| 566 | 2024-01-13 16:16:19 | fancied | 3 | 134027 | 434 | 5.830 | 22989.2 |
| 565 | 2024-01-02 12:47:21 | fancied | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 564 | 2023-12-16 17:01:08 | fancied | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 563 | 2023-12-08 06:49:19 | fancied | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 562 | 2023-12-08 06:49:17 | fancied | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 561 | 2023-11-20 07:52:23 | fancied | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 560 | 2023-11-09 20:37:04 | fancied | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 559 | 2023-11-08 11:27:01 | fancied | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 558 | 2023-11-06 03:17:27 | fancied | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 557 | 2023-10-31 20:49:31 | fancied | 3 | 134027 | 434 | 13.220 | 10138.2 |
| 556 | 2023-10-24 15:51:40 | fancied | 3 | 134027 | 434 | 6.546 | 20474.6 |
| 555 | 2023-10-22 22:55:40 | fancied | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 554 | 2023-10-01 06:13:47 | fancied | 3 | 134027 | 434 | 6.516 | 20568.9 |
| 553 | 2023-10-01 06:13:41 | fancied | 2 | 107671 | 27 | 2.846 | 37832.4 |
| 552 | 2023-09-29 07:44:38 | fancied | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 551 | 2023-09-15 12:32:49 | fancied | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 550 | 2023-08-17 04:50:45 | fancied | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 549 | 2023-08-03 18:45:47 | fancied | 3 | 134027 | 434 | 6.280 | 21341.9 |
| 548 | 2023-07-21 05:05:20 | fancied | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 547 | 2023-05-16 19:24:45 | fancied | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 546 | 2023-04-13 18:33:39 | fancied | 3 | 134027 | 434 | 5.826 | 23005.0 |
| 545 | 2023-04-02 04:39:06 | fancied | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 544 | 2023-03-09 23:25:59 | fancied | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 543 | 2023-01-21 14:09:40 | fancied | 3 | 134027 | 434 | 5.813 | 23056.4 |
| 542 | 2022-12-31 01:13:11 | fancied | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 541 | 2022-12-17 05:45:28 | fancied | 1 | 69583 | 3 | 2.126 | 32729.5 |
| 540 | 2022-10-31 11:32:00 | fancied | 3 | 134027 | 434 | 6.046 | 22167.9 |
| 539 | 2022-09-19 23:43:05 | fancied | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 538 | 2022-08-17 01:48:29 | fancied | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 537 | 2022-07-11 12:47:27 | fancied | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 536 | 2022-06-01 14:30:06 | fancied | 3 | 134027 | 434 | 5.983 | 22401.3 |
| 535 | 2022-05-18 15:56:30 | fancied | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 534 | 2022-04-28 20:16:59 | fancied | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 533 | 2022-04-26 14:38:54 | fancied | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 532 | 2022-04-13 00:30:57 | fancied | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 531 | 2022-01-17 22:06:50 | fancied | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 530 | 2021-12-28 12:38:35 | fancied | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 529 | 2021-11-15 17:32:56 | fancied | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 528 | 2021-10-03 11:05:31 | fancied | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 527 | 2021-09-14 23:50:34 | fancied | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 526 | 2021-09-12 04:10:53 | fancied | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 525 | 2021-06-22 23:59:41 | fancied | 1 | 69583 | 3 | 2.576 | 27012.0 |
| 524 | 2021-06-14 23:19:13 | fancied | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 523 | 2021-05-13 08:05:10 | fancied | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 522 | 2021-05-05 15:35:33 | fancied | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 521 | 2021-04-12 03:56:28 | fancied | 1 | 69583 | 3 | 2.296 | 30306.2 |
| 520 | 2021-03-12 01:06:35 | fancied | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 519 | 2021-03-05 07:58:35 | fancied | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 518 | 2021-02-11 01:47:56 | fancied | 2 | 107671 | 27 | 2.890 | 37256.4 |
| 517 | 2021-02-06 09:25:02 | fancied | 3 | 134027 | 434 | 6.000 | 22337.8 |
| 516 | 2020-11-30 22:30:17 | fancied | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 515 | 2020-11-26 03:09:20 | fancied | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 514 | 2020-11-01 10:36:23 | fancied | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 513 | 2020-10-04 13:29:47 | fancied | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 512 | 2020-09-27 11:46:44 | fancied | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 511 | 2020-09-06 21:19:16 | fancied | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 510 | 2020-08-24 09:07:09 | fancied | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 509 | 2020-08-17 08:37:34 | fancied | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 508 | 2020-08-01 01:52:32 | fancied | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 507 | 2020-07-31 02:54:14 | fancied | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 506 | 2020-07-26 15:31:33 | fancied | 1 | 69583 | 3 | 1.160 | 59985.3 |
| 505 | 2020-07-24 03:36:48 | fancied | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 504 | 2020-06-13 01:07:24 | fancied | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 503 | 2020-06-02 07:48:23 | fancied | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 502 | 2020-06-01 08:26:24 | fancied | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 501 | 2020-05-03 19:13:45 | fancied | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 500 | 2020-04-18 07:45:03 | fancied | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 499 | 2020-04-17 08:24:11 | fancied | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 498 | 2020-04-16 07:49:53 | fancied | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 497 | 2020-04-15 08:00:19 | fancied | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 496 | 2020-03-28 22:47:47 | fancied | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 495 | 2020-03-21 19:38:18 | fancied | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 494 | 2020-03-13 05:13:33 | fancied | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 493 | 2020-03-12 05:34:03 | fancied | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 492 | 2020-03-09 14:05:06 | fancied | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 491 | 2020-03-09 08:22:14 | fancied | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 490 | 2020-03-05 08:03:13 | fancied | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 489 | 2020-03-05 06:33:48 | fancied | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 488 | 2020-03-05 02:42:35 | fancied | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 487 | 2020-03-04 01:55:40 | fancied | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 486 | 2020-03-03 18:16:27 | fancied | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 485 | 2020-03-03 01:45:02 | fancied | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 484 | 2020-03-01 13:22:10 | fancied | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 483 | 2020-02-29 12:37:42 | fancied | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 482 | 2020-02-28 13:42:10 | fancied | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 481 | 2020-02-25 22:58:30 | fancied | 1 | 69583 | 3 | 4.016 | 17326.4 |
| 480 | 2020-02-25 07:43:57 | fancied | 1 | 69583 | 3 | 2.750 | 25302.9 |