History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spencer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 483 | 2025-11-20 11:24:18 | spencer | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 482 | 2025-11-17 10:43:44 | spencer | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 481 | 2025-11-09 07:15:05 | spencer | 1 | 69583 | 5 | 1.406 | 49490.0 |
| 480 | 2025-11-03 12:36:02 | spencer | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 479 | 2025-10-28 03:13:23 | spencer | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 478 | 2025-10-17 14:39:43 | spencer | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 477 | 2025-10-17 10:12:38 | spencer | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 476 | 2025-10-13 21:40:07 | spencer | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 475 | 2025-10-08 10:19:40 | spencer | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 474 | 2025-10-02 15:49:03 | spencer | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 473 | 2025-10-02 05:15:44 | spencer | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 472 | 2025-09-28 10:28:18 | spencer | 3 | 134027 | 464 | 6.653 | 20145.3 |
| 471 | 2025-09-27 01:59:09 | spencer | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 470 | 2025-09-25 19:20:24 | spencer | 1 | 69583 | 5 | 5.983 | 11630.1 |
| 469 | 2025-09-25 19:20:13 | spencer | 1 | 69583 | 5 | 6.233 | 11163.6 |
| 468 | 2025-09-25 19:19:49 | spencer | 1 | 69583 | 5 | 2.720 | 25582.0 |
| 467 | 2025-09-25 19:19:31 | spencer | 1 | 69583 | 5 | 8.983 | 7746.1 |
| 466 | 2025-09-22 16:05:17 | spencer | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 465 | 2025-09-20 04:02:17 | spencer | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 464 | 2025-09-19 15:13:33 | spencer | 1 | 69583 | 5 | 1.576 | 44151.6 |
| 463 | 2025-09-12 23:27:02 | spencer | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 462 | 2025-09-12 15:01:31 | spencer | 3 | 134027 | 464 | 6.796 | 19721.5 |
| 461 | 2025-09-07 20:02:39 | spencer | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 460 | 2025-09-06 18:17:23 | spencer | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 459 | 2025-09-05 07:51:32 | spencer | 3 | 134027 | 464 | 6.953 | 19276.1 |
| 458 | 2025-09-01 11:49:37 | spencer | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 457 | 2025-08-26 12:56:11 | spencer | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 456 | 2025-08-25 04:13:02 | spencer | 1 | 69583 | 5 | 6.216 | 11194.2 |
| 455 | 2025-08-24 21:33:27 | spencer | 1 | 69583 | 5 | 5.830 | 11935.3 |
| 454 | 2025-08-23 22:14:56 | spencer | 1 | 69583 | 5 | 5.673 | 12265.6 |
| 453 | 2025-08-16 19:48:03 | spencer | 1 | 69583 | 5 | 2.783 | 25002.9 |
| 452 | 2025-08-15 06:34:23 | spencer | 1 | 69583 | 5 | 2.610 | 26660.2 |
| 451 | 2025-08-01 22:54:52 | spencer | 3 | 134027 | 464 | 16.860 | 7949.4 |
| 450 | 2025-08-01 22:44:14 | spencer | 2 | 107671 | 37 | 17.140 | 6281.9 |
| 449 | 2025-08-01 17:30:48 | spencer | 1 | 69583 | 5 | 7.936 | 8768.0 |
| 448 | 2025-08-01 13:28:37 | spencer | 1 | 69583 | 5 | 5.813 | 11970.2 |
| 447 | 2025-08-01 05:13:05 | spencer | 1 | 69583 | 5 | 5.423 | 12831.1 |
| 446 | 2025-07-31 08:50:38 | spencer | 1 | 69583 | 5 | 3.640 | 19116.2 |
| 445 | 2025-07-28 18:29:14 | spencer | 3 | 134027 | 464 | 17.063 | 7854.8 |
| 444 | 2025-07-26 19:03:01 | spencer | 1 | 69583 | 5 | 7.110 | 9786.6 |
| 443 | 2025-07-23 14:35:41 | spencer | 1 | 69583 | 5 | 5.216 | 13340.3 |
| 442 | 2025-07-23 03:24:45 | spencer | 1 | 69583 | 5 | 3.250 | 21410.2 |
| 441 | 2025-07-23 01:05:56 | spencer | 1 | 69583 | 5 | 3.123 | 22280.8 |
| 440 | 2025-07-22 00:38:56 | spencer | 3 | 134027 | 464 | 22.970 | 5834.9 |
| 439 | 2025-07-18 18:24:19 | spencer | 3 | 134027 | 464 | 24.813 | 5401.5 |
| 438 | 2025-07-18 07:18:48 | spencer | 3 | 134027 | 464 | 14.656 | 9144.9 |
| 437 | 2025-07-16 20:04:13 | spencer | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 436 | 2025-07-14 04:47:24 | spencer | 3 | 134027 | 464 | 43.440 | 3085.3 |
| 435 | 2025-07-13 16:22:49 | spencer | 3 | 134027 | 464 | 7.063 | 18975.9 |
| 434 | 2025-07-10 22:43:11 | spencer | 3 | 134027 | 464 | 48.453 | 2766.1 |
| 433 | 2025-07-10 07:36:47 | spencer | 2 | 107671 | 37 | 25.126 | 4285.2 |
| 432 | 2025-06-28 00:52:45 | spencer | 1 | 69583 | 5 | 4.703 | 14795.4 |
| 431 | 2025-06-26 13:20:35 | spencer | 1 | 69583 | 5 | 5.966 | 11663.3 |
| 430 | 2025-06-24 04:07:14 | spencer | 1 | 69583 | 5 | 3.046 | 22844.1 |
| 429 | 2025-06-15 20:05:57 | spencer | 1 | 69583 | 5 | 3.720 | 18705.1 |
| 428 | 2025-06-05 21:52:16 | spencer | 1 | 69583 | 5 | 6.970 | 9983.2 |
| 427 | 2025-06-03 04:25:21 | spencer | 1 | 69583 | 5 | 5.670 | 12272.1 |
| 426 | 2025-05-26 13:20:12 | spencer | 1 | 69583 | 5 | 5.576 | 12479.0 |
| 425 | 2025-05-24 04:34:03 | spencer | 1 | 69583 | 5 | 4.750 | 14649.1 |
| 424 | 2025-05-21 22:26:17 | spencer | 1 | 69583 | 5 | 8.470 | 8215.2 |
| 423 | 2025-05-21 01:30:47 | spencer | 3 | 134027 | 464 | 18.876 | 7100.4 |
| 422 | 2025-05-20 13:04:53 | spencer | 3 | 134027 | 464 | 34.783 | 3853.2 |
| 421 | 2025-05-20 06:57:37 | spencer | 3 | 134027 | 464 | 35.423 | 3783.6 |
| 420 | 2025-05-20 03:42:43 | spencer | 3 | 134027 | 464 | 35.176 | 3810.2 |
| 419 | 2025-05-19 23:17:22 | spencer | 3 | 134027 | 464 | 18.420 | 7276.2 |
| 418 | 2025-05-18 07:06:18 | spencer | 3 | 134027 | 464 | 33.020 | 4059.0 |
| 417 | 2025-05-15 20:11:59 | spencer | 1 | 69583 | 5 | 5.703 | 12201.1 |
| 416 | 2025-05-14 05:35:49 | spencer | 1 | 69583 | 5 | 3.393 | 20507.8 |
| 415 | 2025-05-13 16:49:34 | spencer | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 414 | 2025-05-08 19:32:03 | spencer | 1 | 69583 | 5 | 5.393 | 12902.5 |
| 413 | 2025-05-08 02:01:13 | spencer | 2 | 107671 | 37 | 23.110 | 4659.1 |
| 412 | 2025-05-07 06:14:38 | spencer | 2 | 107671 | 37 | 3.530 | 30501.7 |
| 411 | 2025-04-20 18:11:50 | spencer | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 410 | 2025-04-20 03:10:49 | spencer | 1 | 69583 | 5 | 3.076 | 22621.3 |
| 409 | 2025-04-19 22:14:50 | spencer | 1 | 69583 | 5 | 4.296 | 16197.2 |
| 408 | 2025-04-15 21:26:13 | spencer | 3 | 134027 | 464 | 17.016 | 7876.5 |
| 407 | 2025-04-14 12:11:46 | spencer | 3 | 134027 | 464 | 28.030 | 4781.6 |
| 406 | 2025-04-14 05:45:49 | spencer | 3 | 134027 | 464 | 23.096 | 5803.0 |
| 405 | 2025-04-14 02:24:55 | spencer | 3 | 134027 | 464 | 25.783 | 5198.3 |
| 404 | 2025-04-13 19:59:30 | spencer | 1 | 69583 | 5 | 8.953 | 7772.0 |
| 403 | 2025-04-13 16:30:07 | spencer | 2 | 107671 | 37 | 3.343 | 32207.9 |
| 402 | 2025-04-13 13:51:02 | spencer | 3 | 134027 | 464 | 6.640 | 20184.8 |
| 401 | 2025-04-13 12:16:04 | spencer | 2 | 107671 | 37 | 3.360 | 32044.9 |
| 400 | 2025-04-12 15:53:49 | spencer | 3 | 134027 | 464 | 34.406 | 3895.5 |
| 399 | 2025-04-11 16:04:23 | spencer | 3 | 134027 | 464 | 50.120 | 2674.1 |
| 398 | 2025-04-11 03:51:07 | spencer | 1 | 69583 | 5 | 3.423 | 20328.1 |
| 397 | 2025-03-31 05:40:18 | spencer | 1 | 69583 | 5 | 2.903 | 23969.3 |
| 396 | 2025-03-23 08:31:28 | spencer | 3 | 134027 | 464 | 69.783 | 1920.6 |
| 395 | 2025-03-21 10:14:18 | spencer | 2 | 107671 | 37 | 16.750 | 6428.1 |
| 394 | 2025-03-21 09:00:12 | spencer | 3 | 134027 | 464 | 34.470 | 3888.2 |
| 393 | 2025-03-20 04:31:05 | spencer | 1 | 69583 | 5 | 3.080 | 22591.9 |
| 392 | 2025-03-18 23:27:35 | spencer | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 391 | 2025-03-14 19:21:07 | spencer | 2 | 107671 | 37 | 17.253 | 6240.7 |
| 390 | 2025-03-13 22:02:12 | spencer | 3 | 134027 | 464 | 28.483 | 4705.5 |
| 389 | 2025-03-13 19:31:55 | spencer | 3 | 134027 | 464 | 25.343 | 5288.5 |
| 388 | 2025-03-13 12:38:28 | spencer | 3 | 134027 | 464 | 23.376 | 5733.5 |
| 387 | 2025-03-13 12:24:14 | spencer | 2 | 107671 | 37 | 17.093 | 6299.1 |
| 386 | 2025-03-13 12:23:57 | spencer | 1 | 69583 | 5 | 6.016 | 11566.3 |
| 385 | 2025-03-12 17:21:04 | spencer | 3 | 134027 | 464 | 33.580 | 3991.3 |
| 384 | 2025-03-12 14:00:06 | spencer | 3 | 134027 | 464 | 9.953 | 13466.0 |