History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spearer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 481 | 2025-10-31 14:46:47 | spearer | 1 | 69583 | 9 | 1.326 | 52475.9 |
| 480 | 2025-10-28 02:14:45 | spearer | 1 | 69583 | 9 | 1.283 | 54234.6 |
| 479 | 2025-10-25 18:19:54 | spearer | 1 | 69583 | 9 | 1.220 | 57035.2 |
| 478 | 2025-10-24 23:31:38 | spearer | 1 | 69583 | 9 | 1.216 | 57222.9 |
| 477 | 2025-09-19 01:15:09 | spearer | 1 | 69583 | 9 | 1.186 | 58670.3 |
| 476 | 2025-08-27 05:47:00 | spearer | 1 | 69583 | 9 | 1.123 | 61961.7 |
| 475 | 2025-08-26 20:32:44 | spearer | 1 | 69583 | 9 | 1.173 | 59320.5 |
| 474 | 2025-08-24 21:02:55 | spearer | 1 | 69583 | 9 | 7.190 | 9677.7 |
| 473 | 2025-08-11 04:17:24 | spearer | 1 | 69583 | 9 | 5.796 | 12005.3 |
| 472 | 2025-08-09 01:54:35 | spearer | 1 | 69583 | 9 | 7.126 | 9764.7 |
| 471 | 2025-08-05 00:37:02 | spearer | 2 | 107671 | 74 | 7.796 | 13811.1 |
| 470 | 2025-08-04 00:36:31 | spearer | 2 | 107671 | 74 | 8.080 | 13325.6 |
| 469 | 2025-08-03 23:13:53 | spearer | 3 | 134027 | 621 | 21.343 | 6279.7 |
| 468 | 2025-08-02 13:24:41 | spearer | 1 | 69583 | 9 | 2.873 | 24219.6 |
| 467 | 2025-08-02 02:28:24 | spearer | 2 | 107671 | 74 | 15.800 | 6814.6 |
| 466 | 2025-08-02 02:01:03 | spearer | 3 | 134027 | 621 | 24.563 | 5456.5 |
| 465 | 2025-08-01 16:42:12 | spearer | 3 | 134027 | 621 | 15.816 | 8474.1 |
| 464 | 2025-07-31 10:52:44 | spearer | 1 | 69583 | 9 | 1.313 | 52995.4 |
| 463 | 2025-07-31 10:44:59 | spearer | 1 | 69583 | 9 | 1.263 | 55093.4 |
| 462 | 2025-07-30 19:44:22 | spearer | 1 | 69583 | 9 | 1.330 | 52318.0 |
| 461 | 2025-07-28 04:56:21 | spearer | 3 | 134027 | 621 | 31.020 | 4320.7 |
| 460 | 2025-07-27 04:26:55 | spearer | 1 | 69583 | 9 | 2.750 | 25302.9 |
| 459 | 2025-07-26 09:45:58 | spearer | 1 | 69583 | 9 | 1.250 | 55666.4 |
| 458 | 2025-07-24 23:40:54 | spearer | 1 | 69583 | 9 | 2.643 | 26327.3 |
| 457 | 2025-07-24 02:28:02 | spearer | 1 | 69583 | 9 | 7.250 | 9597.7 |
| 456 | 2025-07-23 20:45:36 | spearer | 1 | 69583 | 9 | 3.640 | 19116.2 |
| 455 | 2025-07-23 16:38:06 | spearer | 1 | 69583 | 9 | 7.030 | 9898.0 |
| 454 | 2025-07-22 20:43:46 | spearer | 1 | 69583 | 9 | 3.953 | 17602.6 |
| 453 | 2025-07-22 18:27:44 | spearer | 1 | 69583 | 9 | 3.076 | 22621.3 |
| 452 | 2025-07-22 10:10:49 | spearer | 1 | 69583 | 9 | 1.190 | 58473.1 |
| 451 | 2025-07-19 23:57:11 | spearer | 1 | 69583 | 9 | 2.843 | 24475.2 |
| 450 | 2025-07-03 00:37:18 | spearer | 2 | 107671 | 74 | 19.063 | 5648.2 |
| 449 | 2025-07-01 10:15:08 | spearer | 1 | 69583 | 9 | 1.283 | 54234.6 |
| 448 | 2025-06-30 23:46:33 | spearer | 1 | 69583 | 9 | 1.186 | 58670.3 |
| 447 | 2025-06-28 01:07:39 | spearer | 1 | 69583 | 9 | 5.440 | 12791.0 |
| 446 | 2025-06-26 17:33:12 | spearer | 3 | 134027 | 621 | 32.143 | 4169.7 |
| 445 | 2025-06-25 11:18:48 | spearer | 3 | 134027 | 621 | 7.076 | 18941.1 |
| 444 | 2025-06-24 13:14:46 | spearer | 1 | 69583 | 9 | 6.483 | 10733.1 |
| 443 | 2025-06-24 07:55:47 | spearer | 1 | 69583 | 9 | 3.343 | 20814.5 |
| 442 | 2025-06-23 23:13:41 | spearer | 2 | 107671 | 74 | 18.643 | 5775.4 |
| 441 | 2025-06-23 11:31:55 | spearer | 3 | 134027 | 621 | 20.936 | 6401.7 |
| 440 | 2025-06-22 23:50:43 | spearer | 3 | 134027 | 621 | 14.550 | 9211.5 |
| 439 | 2025-06-22 23:01:30 | spearer | 3 | 134027 | 621 | 7.593 | 17651.4 |
| 438 | 2025-06-21 15:22:43 | spearer | 2 | 107671 | 74 | 3.706 | 29053.2 |
| 437 | 2025-06-21 14:25:00 | spearer | 3 | 134027 | 621 | 36.800 | 3642.0 |
| 436 | 2025-06-19 21:31:44 | spearer | 1 | 69583 | 9 | 8.970 | 7757.3 |
| 435 | 2025-06-19 20:58:38 | spearer | 1 | 69583 | 9 | 1.310 | 53116.8 |
| 434 | 2025-06-10 22:58:03 | spearer | 2 | 107671 | 74 | 25.140 | 4282.9 |
| 433 | 2025-06-10 06:00:04 | spearer | 1 | 69583 | 9 | 3.376 | 20611.1 |
| 432 | 2025-06-08 19:31:13 | spearer | 1 | 69583 | 9 | 6.000 | 11597.2 |
| 431 | 2025-06-08 13:19:25 | spearer | 2 | 107671 | 74 | 22.266 | 4835.7 |
| 430 | 2025-06-05 02:08:14 | spearer | 1 | 69583 | 9 | 3.576 | 19458.3 |
| 429 | 2025-06-01 09:22:27 | spearer | 1 | 69583 | 9 | 3.610 | 19275.1 |
| 428 | 2025-05-30 13:15:14 | spearer | 1 | 69583 | 9 | 3.156 | 22047.8 |
| 427 | 2025-05-30 08:58:40 | spearer | 1 | 69583 | 9 | 3.686 | 18877.6 |
| 426 | 2025-05-29 00:14:11 | spearer | 1 | 69583 | 9 | 5.940 | 11714.3 |
| 425 | 2025-05-20 22:34:10 | spearer | 1 | 69583 | 9 | 2.610 | 26660.2 |
| 424 | 2025-05-19 21:12:21 | spearer | 1 | 69583 | 9 | 10.456 | 6654.8 |
| 423 | 2025-05-19 20:53:43 | spearer | 1 | 69583 | 9 | 4.560 | 15259.4 |
| 422 | 2025-05-11 17:29:46 | spearer | 1 | 69583 | 9 | 2.360 | 29484.3 |
| 421 | 2025-05-10 10:53:21 | spearer | 1 | 69583 | 9 | 3.173 | 21929.7 |
| 420 | 2025-05-10 00:57:13 | spearer | 3 | 134027 | 621 | 47.846 | 2801.2 |
| 419 | 2025-05-08 14:43:33 | spearer | 3 | 134027 | 621 | 34.516 | 3883.0 |
| 418 | 2025-05-08 05:07:51 | spearer | 3 | 134027 | 621 | 34.470 | 3888.2 |
| 417 | 2025-05-05 01:25:30 | spearer | 1 | 69583 | 9 | 1.203 | 57841.2 |
| 416 | 2025-05-04 00:47:08 | spearer | 1 | 69583 | 9 | 3.876 | 17952.3 |
| 415 | 2025-05-01 08:53:15 | spearer | 1 | 69583 | 9 | 7.876 | 8834.8 |
| 414 | 2025-05-01 06:30:46 | spearer | 1 | 69583 | 9 | 2.076 | 33517.8 |
| 413 | 2025-04-28 00:47:10 | spearer | 1 | 69583 | 9 | 7.110 | 9786.6 |
| 412 | 2025-04-24 01:47:44 | spearer | 3 | 134027 | 621 | 52.863 | 2535.4 |
| 411 | 2025-04-22 22:32:21 | spearer | 3 | 134027 | 621 | 23.920 | 5603.1 |
| 410 | 2025-04-21 17:55:10 | spearer | 3 | 134027 | 621 | 27.673 | 4843.2 |
| 409 | 2025-04-21 14:35:07 | spearer | 2 | 107671 | 74 | 20.153 | 5342.7 |
| 408 | 2025-04-19 20:49:38 | spearer | 1 | 69583 | 9 | 2.830 | 24587.6 |
| 407 | 2025-04-19 20:21:39 | spearer | 1 | 69583 | 9 | 3.483 | 19977.9 |
| 406 | 2025-04-15 15:36:49 | spearer | 1 | 69583 | 9 | 1.216 | 57222.9 |
| 405 | 2025-04-10 19:57:48 | spearer | 1 | 69583 | 9 | 1.390 | 50059.7 |
| 404 | 2025-04-09 06:22:37 | spearer | 1 | 69583 | 9 | 5.920 | 11753.9 |
| 403 | 2025-04-04 01:44:10 | spearer | 1 | 69583 | 9 | 5.530 | 12582.8 |
| 402 | 2025-03-31 11:12:16 | spearer | 1 | 69583 | 9 | 3.813 | 18248.9 |
| 401 | 2025-03-24 10:00:22 | spearer | 3 | 134027 | 621 | 34.546 | 3879.7 |
| 400 | 2025-03-19 22:29:25 | spearer | 1 | 69583 | 9 | 5.593 | 12441.1 |
| 399 | 2025-03-19 21:41:25 | spearer | 1 | 69583 | 9 | 3.406 | 20429.5 |
| 398 | 2025-03-13 14:50:27 | spearer | 3 | 134027 | 621 | 39.426 | 3399.5 |
| 397 | 2025-03-13 14:47:22 | spearer | 3 | 134027 | 621 | 33.330 | 4021.2 |
| 396 | 2025-03-12 03:32:47 | spearer | 3 | 134027 | 621 | 34.313 | 3906.0 |
| 395 | 2025-03-11 23:27:10 | spearer | 3 | 134027 | 621 | 35.190 | 3808.7 |
| 394 | 2025-03-11 14:47:08 | spearer | 3 | 134027 | 621 | 20.076 | 6676.0 |
| 393 | 2025-03-11 01:06:34 | spearer | 3 | 134027 | 621 | 17.343 | 7728.0 |
| 392 | 2025-03-10 21:35:02 | spearer | 3 | 134027 | 621 | 19.440 | 6894.4 |
| 391 | 2025-03-09 12:44:59 | spearer | 1 | 69583 | 9 | 5.250 | 13253.9 |
| 390 | 2025-03-02 05:40:33 | spearer | 1 | 69583 | 9 | 5.450 | 12767.5 |
| 389 | 2025-02-27 10:50:03 | spearer | 1 | 69583 | 9 | 6.060 | 11482.3 |
| 388 | 2025-02-19 07:40:43 | spearer | 1 | 69583 | 9 | 6.296 | 11051.9 |
| 387 | 2025-02-12 12:42:53 | spearer | 1 | 69583 | 9 | 4.096 | 16988.0 |
| 386 | 2025-02-08 06:37:51 | spearer | 1 | 69583 | 9 | 2.266 | 30707.4 |
| 385 | 2025-02-07 16:16:03 | spearer | 2 | 107671 | 74 | 13.983 | 7700.1 |
| 384 | 2025-02-07 09:10:16 | spearer | 3 | 134027 | 621 | 25.876 | 5179.6 |
| 383 | 2025-02-07 08:08:00 | spearer | 3 | 134027 | 621 | 25.770 | 5200.9 |
| 382 | 2025-02-07 08:07:59 | spearer | 2 | 107671 | 74 | 16.253 | 6624.7 |