History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bassett"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 511 | 2025-10-23 06:55:38 | bassett | 1 | 69583 | 4 | 6.016 | 11566.3 |
| 510 | 2025-10-21 20:02:39 | bassett | 1 | 69583 | 4 | 2.953 | 23563.5 |
| 509 | 2025-10-17 13:45:09 | bassett | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 508 | 2025-10-10 04:45:55 | bassett | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 507 | 2025-10-02 07:23:18 | bassett | 3 | 134027 | 180 | 6.360 | 21073.4 |
| 506 | 2025-10-01 21:16:01 | bassett | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 505 | 2025-09-28 04:37:28 | bassett | 1 | 69583 | 4 | 5.173 | 13451.2 |
| 504 | 2025-09-28 03:36:57 | bassett | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 503 | 2025-09-28 01:35:33 | bassett | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 502 | 2025-09-27 23:03:59 | bassett | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 501 | 2025-09-26 10:04:33 | bassett | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 500 | 2025-09-23 05:55:42 | bassett | 1 | 69583 | 4 | 1.326 | 52475.9 |
| 499 | 2025-08-28 08:08:36 | bassett | 1 | 69583 | 4 | 1.346 | 51696.1 |
| 498 | 2025-08-28 04:15:36 | bassett | 1 | 69583 | 4 | 1.330 | 52318.0 |
| 497 | 2025-08-26 22:48:14 | bassett | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 496 | 2025-08-15 01:14:37 | bassett | 1 | 69583 | 4 | 4.453 | 15626.1 |
| 495 | 2025-08-01 05:35:57 | bassett | 1 | 69583 | 4 | 3.096 | 22475.1 |
| 494 | 2025-08-01 03:53:57 | bassett | 1 | 69583 | 4 | 8.393 | 8290.6 |
| 493 | 2025-07-27 18:02:57 | bassett | 2 | 107671 | 18 | 8.563 | 12574.0 |
| 492 | 2025-07-27 18:00:06 | bassett | 3 | 134027 | 180 | 31.176 | 4299.0 |
| 491 | 2025-07-27 02:47:48 | bassett | 1 | 69583 | 4 | 3.233 | 21522.7 |
| 490 | 2025-07-25 09:08:55 | bassett | 1 | 69583 | 4 | 2.906 | 23944.6 |
| 489 | 2025-07-25 00:27:40 | bassett | 1 | 69583 | 4 | 5.750 | 12101.4 |
| 488 | 2025-07-24 09:36:17 | bassett | 1 | 69583 | 4 | 9.923 | 7012.3 |
| 487 | 2025-07-24 00:52:24 | bassett | 1 | 69583 | 4 | 8.576 | 8113.7 |
| 486 | 2025-07-18 23:27:55 | bassett | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 485 | 2025-07-10 23:16:16 | bassett | 1 | 69583 | 4 | 5.890 | 11813.8 |
| 484 | 2025-07-09 14:08:08 | bassett | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 483 | 2025-07-09 08:22:58 | bassett | 1 | 69583 | 4 | 5.983 | 11630.1 |
| 482 | 2025-07-07 05:10:43 | bassett | 1 | 69583 | 4 | 3.076 | 22621.3 |
| 481 | 2025-06-29 13:28:18 | bassett | 1 | 69583 | 4 | 3.983 | 17470.0 |
| 480 | 2025-06-24 09:25:55 | bassett | 1 | 69583 | 4 | 5.656 | 12302.5 |
| 479 | 2025-06-16 00:13:45 | bassett | 1 | 69583 | 4 | 3.110 | 22374.0 |
| 478 | 2025-06-15 09:36:03 | bassett | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 477 | 2025-06-10 20:37:57 | bassett | 1 | 69583 | 4 | 6.283 | 11074.8 |
| 476 | 2025-06-04 04:54:17 | bassett | 1 | 69583 | 4 | 7.390 | 9415.8 |
| 475 | 2025-06-03 20:39:54 | bassett | 3 | 134027 | 180 | 26.810 | 4999.1 |
| 474 | 2025-06-02 17:25:57 | bassett | 3 | 134027 | 180 | 23.813 | 5628.3 |
| 473 | 2025-05-31 03:57:48 | bassett | 3 | 134027 | 180 | 23.643 | 5668.8 |
| 472 | 2025-05-28 03:00:52 | bassett | 1 | 69583 | 4 | 1.720 | 40455.2 |
| 471 | 2025-05-25 19:03:54 | bassett | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 470 | 2025-05-24 03:27:34 | bassett | 3 | 134027 | 180 | 28.826 | 4649.5 |
| 469 | 2025-05-23 07:29:28 | bassett | 3 | 134027 | 180 | 19.873 | 6744.2 |
| 468 | 2025-05-23 06:12:05 | bassett | 2 | 107671 | 18 | 3.453 | 31181.9 |
| 467 | 2025-05-22 00:25:23 | bassett | 1 | 69583 | 4 | 5.700 | 12207.5 |
| 466 | 2025-05-21 22:56:41 | bassett | 1 | 69583 | 4 | 6.640 | 10479.4 |
| 465 | 2025-05-14 12:04:39 | bassett | 3 | 134027 | 180 | 35.426 | 3783.3 |
| 464 | 2025-05-14 05:27:01 | bassett | 2 | 107671 | 18 | 17.003 | 6332.5 |
| 463 | 2025-05-12 23:50:46 | bassett | 1 | 69583 | 4 | 3.046 | 22844.1 |
| 462 | 2025-05-05 06:28:29 | bassett | 1 | 69583 | 4 | 1.263 | 55093.4 |
| 461 | 2025-05-02 08:27:01 | bassett | 1 | 69583 | 4 | 3.063 | 22717.3 |
| 460 | 2025-04-30 05:10:25 | bassett | 1 | 69583 | 4 | 6.813 | 10213.3 |
| 459 | 2025-04-21 05:25:06 | bassett | 2 | 107671 | 18 | 16.953 | 6351.1 |
| 458 | 2025-04-20 08:07:42 | bassett | 1 | 69583 | 4 | 1.283 | 54234.6 |
| 457 | 2025-04-19 21:59:09 | bassett | 1 | 69583 | 4 | 1.890 | 36816.4 |
| 456 | 2025-04-10 23:54:28 | bassett | 1 | 69583 | 4 | 3.016 | 23071.3 |
| 455 | 2025-04-06 04:23:44 | bassett | 1 | 69583 | 4 | 6.030 | 11539.5 |
| 454 | 2025-04-05 02:13:45 | bassett | 1 | 69583 | 4 | 1.310 | 53116.8 |
| 453 | 2025-03-29 06:52:58 | bassett | 1 | 69583 | 4 | 5.703 | 12201.1 |
| 452 | 2025-03-23 09:42:30 | bassett | 1 | 69583 | 4 | 6.343 | 10970.0 |
| 451 | 2025-03-23 08:46:06 | bassett | 1 | 69583 | 4 | 2.966 | 23460.2 |
| 450 | 2025-03-20 10:24:05 | bassett | 1 | 69583 | 4 | 6.796 | 10238.8 |
| 449 | 2025-03-13 21:34:32 | bassett | 1 | 69583 | 4 | 2.940 | 23667.7 |
| 448 | 2025-03-06 03:10:02 | bassett | 1 | 69583 | 4 | 5.140 | 13537.5 |
| 447 | 2025-03-03 11:17:31 | bassett | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 446 | 2025-02-20 00:47:15 | bassett | 1 | 69583 | 4 | 6.033 | 11533.7 |
| 445 | 2025-02-09 22:27:18 | bassett | 1 | 69583 | 4 | 6.453 | 10783.0 |
| 444 | 2024-12-30 07:18:13 | bassett | 1 | 69583 | 4 | 6.966 | 9988.9 |
| 443 | 2024-12-28 17:49:35 | bassett | 1 | 69583 | 4 | 8.640 | 8053.6 |
| 442 | 2024-11-23 10:47:26 | bassett | 1 | 69583 | 4 | 8.860 | 7853.6 |
| 441 | 2024-11-14 00:58:33 | bassett | 1 | 69583 | 4 | 5.080 | 13697.4 |
| 440 | 2024-10-23 17:53:27 | bassett | 1 | 69583 | 4 | 6.470 | 10754.7 |
| 439 | 2024-10-21 10:53:40 | bassett | 3 | 134027 | 180 | 41.550 | 3225.7 |
| 438 | 2024-10-16 05:07:57 | bassett | 1 | 69583 | 4 | 5.936 | 11722.2 |
| 437 | 2024-10-14 14:01:12 | bassett | 3 | 134027 | 180 | 29.703 | 4512.2 |
| 436 | 2024-10-14 14:00:45 | bassett | 3 | 134027 | 180 | 35.750 | 3749.0 |
| 435 | 2024-10-13 07:37:19 | bassett | 2 | 107671 | 18 | 19.733 | 5456.4 |
| 434 | 2024-10-13 07:36:11 | bassett | 3 | 134027 | 180 | 43.110 | 3109.0 |
| 433 | 2024-10-13 07:35:26 | bassett | 1 | 69583 | 4 | 5.733 | 12137.3 |
| 432 | 2024-09-28 20:27:22 | bassett | 1 | 69583 | 4 | 4.703 | 14795.4 |
| 431 | 2024-09-12 11:57:24 | bassett | 1 | 69583 | 4 | 6.766 | 10284.2 |
| 430 | 2024-09-04 20:39:43 | bassett | 1 | 69583 | 4 | 10.796 | 6445.3 |
| 429 | 2024-09-04 10:13:19 | bassett | 3 | 134027 | 180 | 23.186 | 5780.5 |
| 428 | 2024-09-03 13:56:32 | bassett | 3 | 134027 | 180 | 45.393 | 2952.6 |
| 427 | 2024-09-02 04:04:49 | bassett | 3 | 134027 | 180 | 36.453 | 3676.7 |
| 426 | 2024-08-28 04:30:35 | bassett | 2 | 107671 | 18 | 28.596 | 3765.2 |
| 425 | 2024-08-28 04:30:36 | bassett | 3 | 134027 | 180 | 24.110 | 5559.0 |
| 424 | 2024-08-28 04:23:49 | bassett | 1 | 69583 | 4 | 12.986 | 5358.3 |
| 423 | 2024-08-25 17:21:27 | bassett | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 422 | 2024-08-22 11:00:08 | bassett | 1 | 69583 | 4 | 13.906 | 5003.8 |
| 421 | 2024-08-21 11:05:46 | bassett | 1 | 69583 | 4 | 8.080 | 8611.8 |
| 420 | 2024-08-20 20:18:55 | bassett | 1 | 69583 | 4 | 3.970 | 17527.2 |
| 419 | 2024-08-17 00:28:28 | bassett | 1 | 69583 | 4 | 8.516 | 8170.9 |
| 418 | 2024-08-12 13:58:51 | bassett | 1 | 69583 | 4 | 8.393 | 8290.6 |
| 417 | 2024-08-09 10:50:20 | bassett | 1 | 69583 | 4 | 3.203 | 21724.3 |
| 416 | 2024-07-28 23:51:36 | bassett | 1 | 69583 | 4 | 5.003 | 13908.3 |
| 415 | 2024-07-22 11:54:14 | bassett | 1 | 69583 | 4 | 3.500 | 19880.9 |
| 414 | 2024-07-09 22:16:04 | bassett | 1 | 69583 | 4 | 4.326 | 16084.8 |
| 413 | 2024-07-08 14:21:27 | bassett | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 412 | 2024-07-08 11:17:37 | bassett | 1 | 69583 | 4 | 5.970 | 11655.4 |