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 |
| 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 |
| 495 | 2025-07-05 14:34:54 | adverts | 2 | 107671 | 27 | 11.343 | 9492.3 |
| 494 | 2025-07-02 01:28:31 | adverts | 1 | 69583 | 6 | 3.766 | 18476.6 |
| 493 | 2025-06-29 17:12:16 | adverts | 2 | 107671 | 27 | 6.610 | 16289.1 |
| 492 | 2025-06-26 23:03:49 | adverts | 1 | 69583 | 6 | 6.063 | 11476.7 |
| 491 | 2025-06-24 11:36:15 | adverts | 1 | 69583 | 6 | 5.546 | 12546.5 |
| 490 | 2025-06-18 12:54:05 | adverts | 1 | 69583 | 6 | 6.360 | 10940.7 |
| 489 | 2025-06-12 03:23:52 | adverts | 1 | 69583 | 6 | 4.453 | 15626.1 |
| 488 | 2025-06-06 04:31:52 | adverts | 3 | 134027 | 242 | 28.860 | 4644.0 |
| 487 | 2025-06-05 19:35:31 | adverts | 3 | 134027 | 242 | 6.653 | 20145.3 |
| 486 | 2025-06-04 07:55:57 | adverts | 3 | 134027 | 242 | 34.046 | 3936.6 |
| 485 | 2025-06-03 14:04:41 | adverts | 2 | 107671 | 27 | 3.356 | 32083.1 |
| 484 | 2025-06-03 04:16:50 | adverts | 3 | 134027 | 242 | 27.016 | 4961.0 |
| 483 | 2025-06-01 00:39:37 | adverts | 1 | 69583 | 6 | 6.000 | 11597.2 |
| 482 | 2025-05-29 10:24:37 | adverts | 3 | 134027 | 242 | 31.203 | 4295.3 |
| 481 | 2025-05-26 00:19:27 | adverts | 2 | 107671 | 27 | 12.486 | 8623.3 |
| 480 | 2025-05-25 23:25:10 | adverts | 1 | 69583 | 6 | 3.343 | 20814.5 |
| 479 | 2025-05-25 09:53:56 | adverts | 2 | 107671 | 27 | 6.656 | 16176.5 |
| 478 | 2025-05-21 23:26:33 | adverts | 3 | 134027 | 242 | 39.550 | 3388.8 |
| 477 | 2025-05-21 08:43:00 | adverts | 3 | 134027 | 242 | 6.533 | 20515.4 |
| 476 | 2025-05-20 23:46:15 | adverts | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 475 | 2025-05-20 11:42:20 | adverts | 1 | 69583 | 6 | 5.953 | 11688.7 |
| 474 | 2025-05-17 07:32:20 | adverts | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 473 | 2025-05-16 13:02:03 | adverts | 1 | 69583 | 6 | 6.063 | 11476.7 |
| 472 | 2025-05-12 03:08:47 | adverts | 1 | 69583 | 6 | 5.546 | 12546.5 |
| 471 | 2025-05-05 04:03:27 | adverts | 3 | 134027 | 242 | 38.156 | 3512.6 |
| 470 | 2025-05-05 03:39:42 | adverts | 2 | 107671 | 27 | 3.420 | 31482.7 |
| 469 | 2025-05-04 20:35:15 | adverts | 1 | 69583 | 6 | 1.313 | 52995.4 |
| 468 | 2025-05-04 15:53:26 | adverts | 3 | 134027 | 242 | 28.153 | 4760.7 |
| 467 | 2025-05-04 07:57:26 | adverts | 3 | 134027 | 242 | 32.266 | 4153.8 |
| 466 | 2025-05-03 19:34:32 | adverts | 3 | 134027 | 242 | 23.080 | 5807.1 |
| 465 | 2025-05-03 13:33:19 | adverts | 2 | 107671 | 27 | 13.466 | 7995.8 |
| 464 | 2025-05-03 04:14:45 | adverts | 3 | 134027 | 242 | 35.030 | 3826.1 |
| 463 | 2025-05-01 20:20:21 | adverts | 1 | 69583 | 6 | 1.236 | 56296.9 |
| 462 | 2025-05-01 05:06:23 | adverts | 1 | 69583 | 6 | 3.453 | 20151.5 |
| 461 | 2025-05-01 00:33:33 | adverts | 1 | 69583 | 6 | 5.466 | 12730.2 |
| 460 | 2025-04-25 22:21:55 | adverts | 1 | 69583 | 6 | 6.610 | 10526.9 |
| 459 | 2025-04-20 10:21:56 | adverts | 1 | 69583 | 6 | 3.203 | 21724.3 |
| 458 | 2025-04-16 11:18:47 | adverts | 1 | 69583 | 6 | 2.580 | 26970.2 |
| 457 | 2025-04-11 03:08:04 | adverts | 1 | 69583 | 6 | 6.123 | 11364.2 |
| 456 | 2025-04-05 20:51:37 | adverts | 1 | 69583 | 6 | 3.156 | 22047.8 |
| 455 | 2025-03-31 06:10:17 | adverts | 1 | 69583 | 6 | 3.123 | 22280.8 |
| 454 | 2025-03-22 20:41:08 | adverts | 3 | 134027 | 242 | 27.236 | 4921.0 |
| 453 | 2025-03-21 02:04:16 | adverts | 2 | 107671 | 27 | 22.860 | 4710.0 |
| 452 | 2025-03-21 00:57:48 | adverts | 3 | 134027 | 242 | 6.610 | 20276.4 |
| 451 | 2025-03-19 12:00:48 | adverts | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 450 | 2025-03-11 17:44:46 | adverts | 1 | 69583 | 6 | 2.766 | 25156.5 |
| 449 | 2025-03-08 03:38:11 | adverts | 1 | 69583 | 6 | 3.626 | 19190.0 |
| 448 | 2025-03-07 18:23:43 | adverts | 1 | 69583 | 6 | 1.296 | 53690.6 |