History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"adverts"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 595 | 2026-03-16 09:30:10 | adverts | 1 | 69583 | 6 | 2.546 | 27330.3 |
| 594 | 2026-03-15 20:44:15 | adverts | 1 | 69583 | 6 | 3.296 | 21111.3 |
| 593 | 2026-03-11 23:55:06 | adverts | 1 | 69583 | 6 | 1.140 | 61037.7 |
| 592 | 2026-03-07 04:31:57 | adverts | 2 | 107671 | 27 | 10.516 | 10238.8 |
| 591 | 2026-03-06 18:27:46 | adverts | 3 | 134027 | 242 | 8.093 | 16560.9 |
| 590 | 2026-03-05 05:58:06 | adverts | 1 | 69583 | 6 | 1.406 | 49490.0 |
| 589 | 2026-03-04 22:41:50 | adverts | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 588 | 2026-03-01 07:11:04 | adverts | 2 | 107671 | 27 | 2.970 | 36252.9 |
| 587 | 2026-02-28 17:26:32 | adverts | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 586 | 2026-02-28 00:13:01 | adverts | 1 | 69583 | 6 | 1.296 | 53690.6 |
| 585 | 2026-02-26 00:24:30 | adverts | 3 | 134027 | 242 | 7.763 | 17264.8 |
| 584 | 2026-02-25 22:47:07 | adverts | 3 | 134027 | 242 | 7.423 | 18055.6 |
| 583 | 2026-02-25 13:19:33 | adverts | 3 | 134027 | 242 | 6.313 | 21230.3 |
| 582 | 2026-02-25 06:47:58 | adverts | 2 | 107671 | 27 | 3.296 | 32667.2 |
| 581 | 2026-02-24 20:01:35 | adverts | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 580 | 2026-02-24 11:58:28 | adverts | 3 | 134027 | 242 | 6.686 | 20045.9 |
| 579 | 2026-02-24 05:59:30 | adverts | 3 | 134027 | 242 | 11.983 | 11184.8 |
| 578 | 2026-02-23 02:12:51 | adverts | 2 | 107671 | 27 | 3.140 | 34290.1 |
| 577 | 2026-02-21 04:12:02 | adverts | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 576 | 2026-02-17 20:09:44 | adverts | 3 | 134027 | 242 | 27.626 | 4851.5 |
| 575 | 2026-02-16 19:49:24 | adverts | 3 | 134027 | 242 | 19.953 | 6717.1 |
| 574 | 2026-02-16 10:36:22 | adverts | 2 | 107671 | 27 | 3.296 | 32667.2 |
| 573 | 2026-02-15 18:15:24 | adverts | 2 | 107671 | 27 | 7.343 | 14663.1 |
| 572 | 2026-02-15 14:39:19 | adverts | 3 | 134027 | 242 | 7.953 | 16852.4 |
| 571 | 2026-02-15 11:21:23 | adverts | 1 | 69583 | 6 | 1.606 | 43326.9 |
| 570 | 2026-02-15 02:18:59 | adverts | 1 | 69583 | 6 | 6.063 | 11476.7 |
| 569 | 2026-02-15 00:08:51 | adverts | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 568 | 2026-02-12 12:19:54 | adverts | 2 | 107671 | 27 | 3.030 | 35535.0 |
| 567 | 2026-02-04 13:28:36 | adverts | 2 | 107671 | 27 | 3.406 | 31612.2 |
| 566 | 2026-02-01 02:55:47 | adverts | 2 | 107671 | 27 | 5.936 | 18138.6 |
| 565 | 2026-01-29 02:33:28 | adverts | 2 | 107671 | 27 | 12.173 | 8845.1 |
| 564 | 2026-01-26 06:46:35 | adverts | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 563 | 2026-01-26 05:20:45 | adverts | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 562 | 2026-01-25 06:45:51 | adverts | 2 | 107671 | 27 | 9.093 | 11841.1 |
| 561 | 2026-01-24 01:46:25 | adverts | 2 | 107671 | 27 | 12.406 | 8678.9 |
| 560 | 2026-01-15 07:35:45 | adverts | 1 | 69583 | 6 | 1.263 | 55093.4 |
| 559 | 2026-01-09 23:08:39 | adverts | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 558 | 2026-01-02 04:21:24 | adverts | 1 | 69583 | 6 | 1.313 | 52995.4 |
| 557 | 2025-12-29 17:22:35 | adverts | 1 | 69583 | 6 | 2.263 | 30748.1 |
| 556 | 2025-12-28 22:57:35 | adverts | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 555 | 2025-12-22 21:22:02 | adverts | 1 | 69583 | 6 | 2.906 | 23944.6 |
| 554 | 2025-12-20 01:54:21 | adverts | 1 | 69583 | 6 | 1.283 | 54234.6 |
| 553 | 2025-12-20 01:52:21 | adverts | 1 | 69583 | 6 | 2.250 | 30925.8 |
| 552 | 2025-12-01 10:53:49 | adverts | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 551 | 2025-11-28 22:41:58 | adverts | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 550 | 2025-11-22 14:45:28 | adverts | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 549 | 2025-11-20 23:21:17 | adverts | 1 | 69583 | 6 | 2.080 | 33453.4 |
| 548 | 2025-11-18 09:09:06 | adverts | 1 | 69583 | 6 | 2.093 | 33245.6 |
| 547 | 2025-11-15 21:37:52 | adverts | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 546 | 2025-11-15 01:28:42 | adverts | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 545 | 2025-11-14 03:37:49 | adverts | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 544 | 2025-11-12 10:42:15 | adverts | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 543 | 2025-11-10 21:03:31 | adverts | 1 | 69583 | 6 | 1.500 | 46388.7 |
| 542 | 2025-10-28 23:56:28 | adverts | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 541 | 2025-10-28 10:32:47 | adverts | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 540 | 2025-10-27 15:26:59 | adverts | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 539 | 2025-10-27 12:03:21 | adverts | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 538 | 2025-10-17 09:56:54 | adverts | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 537 | 2025-10-15 02:53:57 | adverts | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 536 | 2025-10-06 21:33:09 | adverts | 1 | 69583 | 6 | 1.263 | 55093.4 |
| 535 | 2025-10-05 06:37:06 | adverts | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 534 | 2025-09-30 05:07:21 | adverts | 1 | 69583 | 6 | 1.373 | 50679.5 |
| 533 | 2025-09-27 23:40:44 | adverts | 1 | 69583 | 6 | 1.123 | 61961.7 |
| 532 | 2025-09-27 10:17:39 | adverts | 1 | 69583 | 6 | 1.310 | 53116.8 |
| 531 | 2025-09-25 12:04:45 | adverts | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 530 | 2025-09-20 15:08:35 | adverts | 1 | 69583 | 6 | 1.280 | 54361.7 |
| 529 | 2025-09-17 18:43:14 | adverts | 2 | 107671 | 27 | 3.310 | 32529.0 |
| 528 | 2025-09-16 09:56:50 | adverts | 1 | 69583 | 6 | 1.326 | 52475.9 |
| 527 | 2025-09-15 02:18:43 | adverts | 1 | 69583 | 6 | 1.530 | 45479.1 |
| 526 | 2025-09-14 10:43:21 | adverts | 2 | 107671 | 27 | 3.406 | 31612.2 |
| 525 | 2025-09-11 02:35:16 | adverts | 2 | 107671 | 27 | 3.373 | 31921.4 |
| 524 | 2025-09-07 19:50:58 | adverts | 2 | 107671 | 27 | 2.813 | 38276.2 |
| 523 | 2025-09-04 20:27:45 | adverts | 1 | 69583 | 6 | 1.283 | 54234.6 |
| 522 | 2025-09-04 20:17:14 | adverts | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 521 | 2025-09-04 12:41:54 | adverts | 2 | 107671 | 27 | 3.030 | 35535.0 |
| 520 | 2025-09-03 04:54:51 | adverts | 1 | 69583 | 6 | 5.860 | 11874.2 |
| 519 | 2025-09-01 05:24:06 | adverts | 2 | 107671 | 27 | 3.500 | 30763.1 |
| 518 | 2025-08-29 06:27:18 | adverts | 1 | 69583 | 6 | 1.106 | 62914.1 |
| 517 | 2025-08-28 21:56:37 | adverts | 2 | 107671 | 27 | 3.203 | 33615.7 |
| 516 | 2025-08-27 23:42:14 | adverts | 1 | 69583 | 6 | 1.236 | 56296.9 |
| 515 | 2025-08-27 10:24:08 | adverts | 1 | 69583 | 6 | 1.296 | 53690.6 |
| 514 | 2025-08-25 12:11:03 | adverts | 1 | 69583 | 6 | 3.593 | 19366.3 |
| 513 | 2025-08-14 15:14:54 | adverts | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 512 | 2025-08-08 19:16:50 | adverts | 2 | 107671 | 27 | 6.203 | 17357.9 |
| 511 | 2025-08-06 10:22:52 | adverts | 3 | 134027 | 242 | 33.783 | 3967.3 |
| 510 | 2025-08-05 21:17:47 | adverts | 3 | 134027 | 242 | 21.530 | 6225.1 |
| 509 | 2025-08-03 18:12:09 | adverts | 3 | 134027 | 242 | 40.830 | 3282.6 |
| 508 | 2025-08-03 18:00:18 | adverts | 2 | 107671 | 27 | 16.143 | 6669.8 |
| 507 | 2025-08-02 11:24:01 | adverts | 1 | 69583 | 6 | 2.800 | 24851.1 |
| 506 | 2025-07-31 15:39:11 | adverts | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 505 | 2025-07-22 19:37:19 | adverts | 1 | 69583 | 6 | 4.953 | 14048.7 |
| 504 | 2025-07-22 14:09:32 | adverts | 1 | 69583 | 6 | 3.640 | 19116.2 |
| 503 | 2025-07-19 17:31:45 | adverts | 2 | 107671 | 27 | 6.533 | 16481.1 |
| 502 | 2025-07-14 05:47:36 | adverts | 2 | 107671 | 27 | 17.503 | 6151.6 |
| 501 | 2025-07-13 03:54:35 | adverts | 1 | 69583 | 6 | 5.720 | 12164.9 |
| 500 | 2025-07-13 02:02:38 | adverts | 2 | 107671 | 27 | 6.673 | 16135.3 |
| 499 | 2025-07-09 17:34:48 | adverts | 2 | 107671 | 27 | 3.280 | 32826.5 |
| 498 | 2025-07-08 14:10:04 | adverts | 2 | 107671 | 27 | 22.066 | 4879.5 |
| 497 | 2025-07-06 19:46:13 | adverts | 3 | 134027 | 242 | 6.563 | 20421.6 |
| 496 | 2025-07-06 05:18:40 | adverts | 3 | 134027 | 242 | 49.846 | 2688.8 |