History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"effective"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 481 | 2025-10-27 07:23:46 | effective | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 480 | 2025-10-12 19:05:43 | effective | 3 | 148641 | 61 | 6.953 | 21378.0 |
| 479 | 2025-08-17 05:26:02 | effective | 3 | 148641 | 61 | 16.830 | 8831.9 |
| 478 | 2025-08-16 01:03:57 | effective | 1 | 81242 | 3 | 1.906 | 42624.3 |
| 477 | 2025-08-12 00:17:53 | effective | 2 | 121436 | 15 | 12.000 | 10119.7 |
| 476 | 2025-08-07 23:39:10 | effective | 2 | 121436 | 15 | 6.643 | 18280.3 |
| 475 | 2025-08-03 13:25:52 | effective | 1 | 81242 | 3 | 2.750 | 29542.5 |
| 474 | 2025-07-26 12:36:31 | effective | 1 | 81242 | 3 | 6.606 | 12298.2 |
| 473 | 2025-07-23 03:15:55 | effective | 1 | 81242 | 3 | 3.000 | 27080.7 |
| 472 | 2025-07-22 18:54:41 | effective | 1 | 81242 | 3 | 6.466 | 12564.5 |
| 471 | 2025-07-14 11:03:54 | effective | 4 | 165329 | 234 | 73.816 | 2239.7 |
| 470 | 2025-07-11 12:48:07 | effective | 4 | 165329 | 234 | 71.740 | 2304.6 |
| 469 | 2025-07-10 23:59:43 | effective | 4 | 165329 | 234 | 48.317 | 3421.8 |
| 468 | 2025-07-09 01:30:17 | effective | 4 | 165329 | 234 | 12.470 | 13258.1 |
| 467 | 2025-07-03 04:50:51 | effective | 3 | 148641 | 61 | 7.253 | 20493.7 |
| 466 | 2025-06-30 02:50:29 | effective | 3 | 148641 | 61 | 17.953 | 8279.5 |
| 465 | 2025-06-29 05:21:55 | effective | 1 | 81242 | 3 | 6.670 | 12180.2 |
| 464 | 2025-06-26 18:27:38 | effective | 2 | 121436 | 15 | 8.593 | 14132.0 |
| 463 | 2025-06-26 18:12:16 | effective | 3 | 148641 | 61 | 25.893 | 5740.6 |
| 462 | 2025-06-26 04:28:01 | effective | 1 | 81242 | 3 | 5.050 | 16087.5 |
| 461 | 2025-06-21 11:11:03 | effective | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 460 | 2025-06-18 02:06:36 | effective | 1 | 81242 | 3 | 5.716 | 14213.1 |
| 459 | 2025-06-11 04:30:50 | effective | 4 | 165329 | 234 | 38.203 | 4327.6 |
| 458 | 2025-06-08 01:26:01 | effective | 4 | 165329 | 234 | 68.983 | 2396.7 |
| 457 | 2025-06-06 13:34:34 | effective | 4 | 165329 | 234 | 84.673 | 1952.6 |
| 456 | 2025-06-05 07:57:25 | effective | 4 | 165329 | 234 | 62.876 | 2629.4 |
| 455 | 2025-05-19 22:51:23 | effective | 1 | 81242 | 3 | 6.673 | 12174.7 |
| 454 | 2025-05-18 05:29:50 | effective | 1 | 81242 | 3 | 6.760 | 12018.0 |
| 453 | 2025-05-09 10:59:10 | effective | 3 | 148641 | 61 | 6.923 | 21470.6 |
| 452 | 2025-05-06 04:45:24 | effective | 3 | 148641 | 61 | 25.736 | 5775.6 |
| 451 | 2025-05-05 01:13:50 | effective | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 450 | 2025-04-27 23:59:36 | effective | 3 | 148641 | 61 | 18.406 | 8075.7 |
| 449 | 2025-04-25 06:42:16 | effective | 3 | 148641 | 61 | 26.363 | 5638.2 |
| 448 | 2025-04-25 02:17:52 | effective | 3 | 148641 | 61 | 35.863 | 4144.7 |
| 447 | 2025-04-23 04:57:38 | effective | 1 | 81242 | 3 | 6.766 | 12007.4 |
| 446 | 2025-04-21 11:51:18 | effective | 3 | 148641 | 61 | 30.000 | 4954.7 |
| 445 | 2025-04-18 08:54:39 | effective | 3 | 148641 | 61 | 19.516 | 7616.4 |
| 444 | 2025-04-18 07:26:09 | effective | 2 | 121436 | 15 | 20.063 | 6052.7 |
| 443 | 2025-04-17 03:04:24 | effective | 1 | 81242 | 3 | 1.513 | 53696.0 |
| 442 | 2025-04-16 08:02:48 | effective | 4 | 165329 | 234 | 56.813 | 2910.1 |
| 441 | 2025-04-16 05:04:37 | effective | 4 | 165329 | 234 | 53.766 | 3075.0 |
| 440 | 2025-04-15 14:08:30 | effective | 4 | 165329 | 234 | 69.720 | 2371.3 |
| 439 | 2025-04-15 00:37:10 | effective | 4 | 165329 | 234 | 48.860 | 3383.7 |
| 438 | 2025-04-14 06:35:42 | effective | 4 | 165329 | 234 | 58.660 | 2818.4 |
| 437 | 2025-04-10 22:01:44 | effective | 1 | 81242 | 3 | 10.390 | 7819.2 |
| 436 | 2025-04-04 11:18:04 | effective | 1 | 81242 | 3 | 4.686 | 17337.2 |
| 435 | 2025-03-23 09:25:31 | effective | 1 | 81242 | 3 | 7.063 | 11502.5 |
| 434 | 2025-03-22 12:38:20 | effective | 4 | 165329 | 234 | 57.346 | 2883.0 |
| 433 | 2025-03-20 06:42:14 | effective | 1 | 81242 | 3 | 7.046 | 11530.2 |
| 432 | 2025-03-14 02:14:27 | effective | 3 | 148641 | 61 | 27.280 | 5448.7 |
| 431 | 2025-03-13 14:41:10 | effective | 4 | 165329 | 234 | 63.456 | 2605.4 |
| 430 | 2025-03-13 12:48:32 | effective | 4 | 165329 | 234 | 58.720 | 2815.5 |
| 429 | 2025-03-13 12:47:29 | effective | 1 | 81242 | 3 | 6.953 | 11684.5 |
| 428 | 2025-03-09 03:54:27 | effective | 4 | 165329 | 234 | 60.710 | 2723.3 |
| 427 | 2025-03-08 23:39:52 | effective | 1 | 81242 | 3 | 7.250 | 11205.8 |
| 426 | 2025-03-07 17:03:27 | effective | 3 | 148641 | 61 | 27.533 | 5398.6 |
| 425 | 2025-03-05 19:32:07 | effective | 4 | 165329 | 234 | 50.533 | 3271.7 |
| 424 | 2025-03-05 19:32:05 | effective | 3 | 148641 | 61 | 26.170 | 5679.8 |
| 423 | 2025-03-05 19:32:04 | effective | 2 | 121436 | 15 | 17.766 | 6835.3 |
| 422 | 2025-03-05 16:37:02 | effective | 3 | 148641 | 61 | 28.160 | 5278.4 |
| 421 | 2025-03-03 13:05:19 | effective | 3 | 148641 | 61 | 39.253 | 3786.7 |
| 420 | 2025-03-03 13:05:21 | effective | 3 | 148641 | 61 | 28.456 | 5223.5 |
| 419 | 2025-03-03 13:05:15 | effective | 2 | 121436 | 15 | 16.720 | 7262.9 |
| 418 | 2025-03-03 12:44:23 | effective | 1 | 81242 | 3 | 5.453 | 14898.6 |
| 417 | 2025-02-07 21:53:47 | effective | 1 | 81242 | 3 | 5.296 | 15340.3 |
| 416 | 2025-01-31 09:22:07 | effective | 1 | 81242 | 3 | 6.203 | 13097.2 |
| 415 | 2025-01-27 09:50:02 | effective | 1 | 81242 | 3 | 10.000 | 8124.2 |
| 414 | 2025-01-05 11:37:34 | effective | 1 | 81242 | 3 | 9.923 | 8187.2 |
| 413 | 2024-12-27 19:47:55 | effective | 1 | 81242 | 3 | 4.813 | 16879.7 |
| 412 | 2024-12-16 22:02:46 | effective | 1 | 81242 | 3 | 5.796 | 14016.9 |
| 411 | 2024-12-06 03:23:59 | effective | 1 | 81242 | 3 | 6.593 | 12322.5 |
| 410 | 2024-11-26 11:06:12 | effective | 1 | 81242 | 3 | 8.143 | 9976.9 |
| 409 | 2024-11-21 15:17:33 | effective | 1 | 81242 | 3 | 4.860 | 16716.5 |
| 408 | 2024-11-11 00:42:13 | effective | 1 | 81242 | 3 | 6.263 | 12971.7 |
| 407 | 2024-10-31 10:43:41 | effective | 1 | 81242 | 3 | 6.830 | 11894.9 |
| 406 | 2024-10-20 01:47:22 | effective | 2 | 121436 | 15 | 21.140 | 5744.4 |
| 405 | 2024-10-19 11:07:45 | effective | 2 | 121436 | 15 | 17.220 | 7052.0 |
| 404 | 2024-10-17 15:50:08 | effective | 2 | 121436 | 15 | 8.410 | 14439.5 |
| 403 | 2024-10-17 15:49:54 | effective | 1 | 81242 | 3 | 2.750 | 29542.5 |
| 402 | 2024-10-17 15:33:09 | effective | 3 | 148641 | 61 | 34.516 | 4306.4 |
| 401 | 2024-10-16 09:30:07 | effective | 3 | 148641 | 61 | 57.016 | 2607.0 |
| 400 | 2024-10-15 03:56:29 | effective | 3 | 148641 | 61 | 44.333 | 3352.8 |
| 399 | 2024-10-13 03:03:59 | effective | 3 | 148641 | 61 | 36.013 | 4127.4 |
| 398 | 2024-10-13 03:03:53 | effective | 3 | 148641 | 61 | 35.313 | 4209.2 |
| 397 | 2024-10-13 03:03:46 | effective | 2 | 121436 | 15 | 21.826 | 5563.8 |
| 396 | 2024-10-13 03:03:12 | effective | 1 | 81242 | 3 | 5.470 | 14852.3 |
| 395 | 2024-10-09 09:43:08 | effective | 1 | 81242 | 3 | 6.890 | 11791.3 |
| 394 | 2024-09-08 15:01:40 | effective | 1 | 81242 | 3 | 4.066 | 19980.8 |
| 393 | 2024-08-14 23:09:29 | effective | 1 | 81242 | 3 | 6.343 | 12808.1 |
| 392 | 2024-08-10 13:12:11 | effective | 3 | 148641 | 61 | 43.600 | 3409.2 |
| 391 | 2024-08-10 12:52:38 | effective | 3 | 148641 | 61 | 34.300 | 4333.6 |
| 390 | 2024-08-10 12:52:31 | effective | 4 | 165329 | 234 | 35.296 | 4684.1 |
| 389 | 2024-08-10 12:52:40 | effective | 2 | 121436 | 15 | 11.890 | 10213.3 |
| 388 | 2024-08-10 12:50:12 | effective | 1 | 81242 | 3 | 6.140 | 13231.6 |
| 387 | 2024-08-09 19:19:12 | effective | 1 | 81242 | 3 | 6.606 | 12298.2 |
| 386 | 2024-08-07 15:53:36 | effective | 1 | 81242 | 3 | 5.373 | 15120.4 |
| 385 | 2024-07-20 18:26:02 | effective | 1 | 81242 | 3 | 4.720 | 17212.3 |
| 384 | 2024-07-17 01:37:20 | effective | 1 | 81242 | 3 | 2.873 | 28277.8 |
| 383 | 2024-07-06 07:07:01 | effective | 1 | 81242 | 3 | 5.016 | 16196.6 |
| 382 | 2024-07-06 06:55:51 | effective | 1 | 81242 | 3 | 4.700 | 17285.5 |