History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"patrons"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 485 | 2025-04-14 18:20:22 | patrons | 1 | 69583 | 7 | 4.170 | 16686.6 |
| 484 | 2025-04-12 11:15:36 | patrons | 1 | 69583 | 7 | 5.983 | 11630.1 |
| 483 | 2025-04-08 20:14:34 | patrons | 2 | 107671 | 64 | 16.846 | 6391.5 |
| 482 | 2025-04-07 11:23:45 | patrons | 1 | 69583 | 7 | 3.500 | 19880.9 |
| 481 | 2025-03-29 07:31:12 | patrons | 1 | 69583 | 7 | 5.500 | 12651.5 |
| 480 | 2025-03-22 05:05:05 | patrons | 1 | 69583 | 7 | 1.203 | 57841.2 |
| 479 | 2025-03-21 18:30:22 | patrons | 3 | 134027 | 578 | 34.503 | 3884.5 |
| 478 | 2025-03-20 10:19:47 | patrons | 1 | 69583 | 7 | 3.923 | 17737.2 |
| 477 | 2025-03-20 03:30:48 | patrons | 1 | 69583 | 7 | 4.970 | 14000.6 |
| 476 | 2025-03-12 21:12:42 | patrons | 1 | 69583 | 7 | 2.640 | 26357.2 |
| 475 | 2025-03-11 01:47:03 | patrons | 1 | 69583 | 7 | 6.766 | 10284.2 |
| 474 | 2025-03-05 17:32:35 | patrons | 2 | 107671 | 64 | 11.250 | 9570.8 |
| 473 | 2025-02-27 05:48:15 | patrons | 1 | 69583 | 7 | 5.800 | 11997.1 |
| 472 | 2025-02-13 00:26:21 | patrons | 1 | 69583 | 7 | 4.013 | 17339.4 |
| 471 | 2025-02-10 16:20:19 | patrons | 2 | 107671 | 64 | 18.690 | 5760.9 |
| 470 | 2025-02-08 17:38:19 | patrons | 3 | 134027 | 578 | 62.880 | 2131.5 |
| 469 | 2025-02-08 01:46:11 | patrons | 3 | 134027 | 578 | 43.280 | 3096.7 |
| 468 | 2025-02-07 19:30:59 | patrons | 2 | 107671 | 64 | 14.220 | 7571.8 |
| 467 | 2025-02-07 19:27:26 | patrons | 3 | 134027 | 578 | 15.096 | 8878.3 |
| 466 | 2025-02-07 17:54:41 | patrons | 1 | 69583 | 7 | 3.046 | 22844.1 |
| 465 | 2025-02-07 15:21:12 | patrons | 3 | 134027 | 578 | 35.783 | 3745.5 |
| 464 | 2025-02-07 15:21:10 | patrons | 2 | 107671 | 64 | 17.203 | 6258.9 |
| 463 | 2025-02-07 14:58:45 | patrons | 1 | 69583 | 7 | 6.076 | 11452.1 |
| 462 | 2025-02-07 10:19:13 | patrons | 1 | 69583 | 7 | 6.266 | 11104.9 |
| 461 | 2025-01-17 10:32:53 | patrons | 1 | 69583 | 7 | 5.656 | 12302.5 |
| 460 | 2025-01-07 23:18:40 | patrons | 1 | 69583 | 7 | 3.593 | 19366.3 |
| 459 | 2025-01-06 09:48:24 | patrons | 1 | 69583 | 7 | 3.110 | 22374.0 |
| 458 | 2025-01-05 07:16:38 | patrons | 1 | 69583 | 7 | 7.063 | 9851.8 |
| 457 | 2024-11-23 14:35:43 | patrons | 3 | 134027 | 578 | 17.340 | 7729.4 |
| 456 | 2024-11-22 10:38:30 | patrons | 3 | 134027 | 578 | 15.060 | 8899.5 |
| 455 | 2024-11-20 09:37:59 | patrons | 2 | 107671 | 64 | 10.410 | 10343.0 |
| 454 | 2024-11-19 00:23:14 | patrons | 3 | 134027 | 578 | 34.643 | 3868.8 |
| 453 | 2024-11-18 16:32:31 | patrons | 3 | 134027 | 578 | 35.343 | 3792.2 |
| 452 | 2024-11-18 16:32:30 | patrons | 2 | 107671 | 64 | 17.596 | 6119.1 |
| 451 | 2024-11-08 01:15:59 | patrons | 1 | 69583 | 7 | 5.923 | 11747.9 |
| 450 | 2024-11-06 00:21:03 | patrons | 1 | 69583 | 7 | 5.830 | 11935.3 |
| 449 | 2024-11-03 16:11:39 | patrons | 1 | 69583 | 7 | 6.046 | 11508.9 |
| 448 | 2024-10-24 23:37:28 | patrons | 1 | 69583 | 7 | 6.826 | 10193.8 |
| 447 | 2024-10-09 01:57:15 | patrons | 1 | 69583 | 7 | 5.610 | 12403.4 |
| 446 | 2024-10-06 13:38:34 | patrons | 1 | 69583 | 7 | 9.733 | 7149.2 |
| 445 | 2024-09-28 20:25:38 | patrons | 1 | 69583 | 7 | 5.126 | 13574.5 |
| 444 | 2024-09-05 07:24:26 | patrons | 1 | 69583 | 7 | 5.876 | 11841.9 |
| 443 | 2024-09-04 04:42:53 | patrons | 1 | 69583 | 7 | 6.436 | 10811.5 |
| 442 | 2024-09-01 17:36:56 | patrons | 1 | 69583 | 7 | 9.300 | 7482.0 |
| 441 | 2024-08-29 12:18:38 | patrons | 1 | 69583 | 7 | 4.373 | 15912.0 |
| 440 | 2024-08-23 14:47:15 | patrons | 1 | 69583 | 7 | 10.576 | 6579.3 |
| 439 | 2024-08-16 00:32:23 | patrons | 1 | 69583 | 7 | 8.456 | 8228.8 |
| 438 | 2024-08-15 13:09:15 | patrons | 1 | 69583 | 7 | 6.453 | 10783.0 |
| 437 | 2024-08-09 09:45:43 | patrons | 1 | 69583 | 7 | 4.890 | 14229.7 |
| 436 | 2024-08-07 19:07:56 | patrons | 1 | 69583 | 7 | 5.270 | 13203.6 |
| 435 | 2024-07-30 05:55:44 | patrons | 1 | 69583 | 7 | 2.716 | 25619.7 |
| 434 | 2024-07-29 13:10:46 | patrons | 1 | 69583 | 7 | 4.360 | 15959.4 |
| 433 | 2024-07-07 15:38:28 | patrons | 1 | 69583 | 7 | 4.373 | 15912.0 |
| 432 | 2024-07-05 15:39:03 | patrons | 1 | 69583 | 7 | 5.733 | 12137.3 |
| 431 | 2024-07-02 08:37:26 | patrons | 1 | 69583 | 7 | 3.593 | 19366.3 |
| 430 | 2024-07-01 21:00:43 | patrons | 1 | 69583 | 7 | 5.000 | 13916.6 |
| 429 | 2024-06-30 01:32:22 | patrons | 1 | 69583 | 7 | 2.143 | 32469.9 |
| 428 | 2024-06-29 16:29:08 | patrons | 1 | 69583 | 7 | 5.813 | 11970.2 |
| 427 | 2024-06-22 22:48:39 | patrons | 1 | 69583 | 7 | 2.220 | 31343.7 |
| 426 | 2024-05-29 13:46:01 | patrons | 1 | 69583 | 7 | 2.843 | 24475.2 |
| 425 | 2024-04-30 04:34:35 | patrons | 1 | 69583 | 7 | 1.220 | 57035.2 |
| 424 | 2024-04-05 01:54:31 | patrons | 1 | 69583 | 7 | 1.640 | 42428.7 |
| 423 | 2024-03-27 16:41:44 | patrons | 1 | 69583 | 7 | 1.263 | 55093.4 |
| 422 | 2023-12-27 13:04:44 | patrons | 3 | 134027 | 578 | 6.110 | 21935.7 |
| 421 | 2023-12-27 06:57:23 | patrons | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 420 | 2023-12-24 08:23:29 | patrons | 3 | 134027 | 578 | 6.263 | 21399.8 |
| 419 | 2023-12-24 02:36:15 | patrons | 1 | 69583 | 7 | 1.216 | 57222.9 |
| 418 | 2023-12-19 13:56:45 | patrons | 1 | 69583 | 7 | 1.220 | 57035.2 |
| 417 | 2023-12-18 14:10:06 | patrons | 3 | 134027 | 578 | 6.873 | 19500.5 |
| 416 | 2023-12-18 14:09:56 | patrons | 2 | 107671 | 64 | 3.530 | 30501.7 |
| 415 | 2023-11-24 00:05:17 | patrons | 1 | 69583 | 7 | 1.266 | 54962.9 |
| 414 | 2023-11-20 11:59:45 | patrons | 1 | 69583 | 7 | 1.090 | 63837.6 |
| 413 | 2023-11-12 10:07:21 | patrons | 1 | 69583 | 7 | 1.170 | 59472.6 |
| 412 | 2023-11-01 06:16:52 | patrons | 1 | 69583 | 7 | 1.563 | 44518.9 |
| 411 | 2023-10-17 12:26:06 | patrons | 1 | 69583 | 7 | 1.266 | 54962.9 |
| 410 | 2023-10-06 02:30:17 | patrons | 1 | 69583 | 7 | 1.220 | 57035.2 |
| 409 | 2023-09-29 11:51:22 | patrons | 1 | 69583 | 7 | 1.123 | 61961.7 |
| 408 | 2023-09-23 03:34:33 | patrons | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 407 | 2023-08-24 19:37:47 | patrons | 1 | 69583 | 7 | 1.283 | 54234.6 |
| 406 | 2023-08-03 15:10:52 | patrons | 1 | 69583 | 7 | 1.123 | 61961.7 |
| 405 | 2023-05-11 04:28:40 | patrons | 1 | 69583 | 7 | 1.203 | 57841.2 |
| 404 | 2023-04-26 15:12:56 | patrons | 1 | 69583 | 7 | 1.216 | 57222.9 |
| 403 | 2023-03-02 23:12:22 | patrons | 1 | 69583 | 7 | 1.080 | 64428.7 |
| 402 | 2023-02-19 02:38:02 | patrons | 1 | 69583 | 7 | 1.063 | 65459.1 |
| 401 | 2023-01-29 01:15:41 | patrons | 1 | 69583 | 7 | 1.153 | 60349.5 |
| 400 | 2022-12-15 20:50:31 | patrons | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 399 | 2022-10-11 02:02:03 | patrons | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 398 | 2022-08-29 05:37:58 | patrons | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 397 | 2022-08-21 14:06:26 | patrons | 1 | 69583 | 7 | 1.220 | 57035.2 |
| 396 | 2022-06-20 16:59:07 | patrons | 1 | 69583 | 7 | 1.110 | 62687.4 |
| 395 | 2022-06-16 23:30:21 | patrons | 1 | 69583 | 7 | 1.110 | 62687.4 |
| 394 | 2022-04-07 14:33:33 | patrons | 1 | 69583 | 7 | 1.546 | 45008.4 |
| 393 | 2022-03-01 14:01:22 | patrons | 1 | 69583 | 7 | 1.390 | 50059.7 |
| 392 | 2022-01-09 04:19:00 | patrons | 1 | 69583 | 7 | 1.250 | 55666.4 |
| 391 | 2022-01-07 01:20:01 | patrons | 1 | 69583 | 7 | 1.233 | 56433.9 |
| 390 | 2021-11-21 06:25:47 | patrons | 1 | 69583 | 7 | 1.310 | 53116.8 |
| 389 | 2021-11-05 06:50:18 | patrons | 1 | 69583 | 7 | 1.170 | 59472.6 |
| 388 | 2021-09-22 16:31:19 | patrons | 1 | 69583 | 7 | 1.440 | 48321.5 |
| 387 | 2021-09-03 04:39:32 | patrons | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 386 | 2021-08-19 09:48:55 | patrons | 3 | 134027 | 578 | 6.766 | 19808.9 |