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 |
| 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 |
| 385 | 2021-08-18 09:17:41 | patrons | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 384 | 2021-07-29 08:47:56 | patrons | 3 | 134027 | 578 | 5.953 | 22514.2 |
| 383 | 2021-07-05 05:32:16 | patrons | 3 | 134027 | 578 | 6.016 | 22278.4 |
| 382 | 2021-06-24 14:41:11 | patrons | 3 | 134027 | 578 | 7.046 | 19021.7 |
| 381 | 2021-06-13 13:53:35 | patrons | 3 | 134027 | 578 | 7.263 | 18453.4 |
| 380 | 2021-06-07 04:39:02 | patrons | 3 | 134027 | 578 | 7.220 | 18563.3 |
| 379 | 2021-05-31 05:08:55 | patrons | 3 | 134027 | 578 | 6.626 | 20227.4 |
| 378 | 2021-05-27 22:24:55 | patrons | 3 | 134027 | 578 | 7.280 | 18410.3 |
| 377 | 2021-05-26 07:11:15 | patrons | 1 | 69583 | 7 | 1.220 | 57035.2 |
| 376 | 2021-05-22 04:30:28 | patrons | 3 | 134027 | 578 | 7.076 | 18941.1 |
| 375 | 2021-05-22 00:15:41 | patrons | 3 | 134027 | 578 | 7.406 | 18097.1 |
| 374 | 2021-05-19 05:49:05 | patrons | 3 | 134027 | 578 | 6.893 | 19443.9 |
| 373 | 2021-05-14 10:06:12 | patrons | 1 | 69583 | 7 | 1.076 | 64668.2 |
| 372 | 2021-04-30 07:38:03 | patrons | 1 | 69583 | 7 | 1.140 | 61037.7 |
| 371 | 2021-04-22 18:00:36 | patrons | 3 | 134027 | 578 | 14.470 | 9262.4 |
| 370 | 2021-03-29 17:08:50 | patrons | 1 | 69583 | 7 | 2.266 | 30707.4 |
| 369 | 2021-03-22 03:12:35 | patrons | 3 | 134027 | 578 | 7.140 | 18771.3 |
| 368 | 2021-02-11 15:52:38 | patrons | 3 | 134027 | 578 | 6.516 | 20568.9 |
| 367 | 2021-02-11 05:18:06 | patrons | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 366 | 2021-02-06 18:46:16 | patrons | 3 | 134027 | 578 | 6.406 | 20922.1 |
| 365 | 2021-02-06 09:34:17 | patrons | 1 | 69583 | 7 | 1.220 | 57035.2 |
| 364 | 2021-02-06 09:06:14 | patrons | 1 | 69583 | 7 | 1.170 | 59472.6 |
| 363 | 2021-02-06 08:44:47 | patrons | 1 | 69583 | 7 | 1.123 | 61961.7 |
| 362 | 2021-02-06 08:19:24 | patrons | 1 | 69583 | 7 | 1.266 | 54962.9 |
| 361 | 2021-01-13 10:53:01 | patrons | 1 | 69583 | 7 | 1.110 | 62687.4 |
| 360 | 2020-12-14 16:08:32 | patrons | 1 | 69583 | 7 | 1.170 | 59472.6 |
| 359 | 2020-11-04 08:33:48 | patrons | 1 | 69583 | 7 | 1.123 | 61961.7 |
| 358 | 2020-10-25 23:41:09 | patrons | 1 | 69583 | 7 | 1.356 | 51314.9 |
| 357 | 2020-10-14 19:00:15 | patrons | 1 | 69583 | 7 | 1.173 | 59320.5 |
| 356 | 2020-09-29 21:01:47 | patrons | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 355 | 2020-08-26 23:38:57 | patrons | 1 | 69583 | 7 | 1.170 | 59472.6 |
| 354 | 2020-07-31 19:36:42 | patrons | 1 | 69583 | 7 | 1.296 | 53690.6 |
| 353 | 2020-07-25 07:16:59 | patrons | 1 | 69583 | 7 | 1.250 | 55666.4 |
| 352 | 2020-06-19 03:42:24 | patrons | 1 | 69583 | 7 | 1.126 | 61796.6 |
| 351 | 2020-04-29 08:30:39 | patrons | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 350 | 2020-03-27 22:04:19 | patrons | 1 | 69583 | 7 | 1.390 | 50059.7 |
| 349 | 2020-03-24 09:54:37 | patrons | 1 | 69583 | 7 | 1.250 | 55666.4 |
| 348 | 2020-03-24 02:54:44 | patrons | 1 | 69583 | 7 | 3.283 | 21194.9 |
| 347 | 2020-03-23 00:44:42 | patrons | 1 | 69583 | 7 | 1.466 | 47464.5 |
| 346 | 2020-03-19 23:48:26 | patrons | 1 | 69583 | 7 | 1.203 | 57841.2 |
| 345 | 2020-03-17 15:21:20 | patrons | 1 | 69583 | 7 | 1.250 | 55666.4 |
| 344 | 2020-03-14 04:55:04 | patrons | 1 | 69583 | 7 | 1.123 | 61961.7 |
| 343 | 2020-02-27 07:13:54 | patrons | 1 | 69583 | 7 | 1.376 | 50569.0 |
| 342 | 2020-02-26 05:01:38 | patrons | 1 | 69583 | 7 | 1.296 | 53690.6 |
| 341 | 2020-02-24 10:06:05 | patrons | 1 | 69583 | 7 | 1.343 | 51811.6 |
| 340 | 2020-02-22 07:19:45 | patrons | 1 | 69583 | 7 | 2.860 | 24329.7 |
| 339 | 2020-02-20 18:06:58 | patrons | 1 | 69583 | 7 | 1.170 | 59472.6 |
| 338 | 2020-02-19 23:54:41 | patrons | 1 | 69583 | 7 | 1.250 | 55666.4 |
| 337 | 2020-02-11 02:30:58 | patrons | 1 | 69583 | 7 | 1.326 | 52475.9 |
| 336 | 2020-01-30 23:30:11 | patrons | 1 | 69583 | 7 | 3.986 | 17456.8 |
| 335 | 2020-01-30 21:49:08 | patrons | 1 | 69583 | 7 | 1.393 | 49951.9 |
| 334 | 2020-01-30 16:57:09 | patrons | 1 | 69583 | 7 | 1.330 | 52318.0 |
| 333 | 2020-01-28 11:21:58 | patrons | 1 | 69583 | 7 | 2.233 | 31161.2 |
| 332 | 2020-01-26 17:14:59 | patrons | 1 | 69583 | 7 | 1.296 | 53690.6 |
| 331 | 2020-01-25 18:06:56 | patrons | 1 | 69583 | 7 | 4.343 | 16021.9 |
| 330 | 2020-01-25 12:35:34 | patrons | 1 | 69583 | 7 | 1.360 | 51164.0 |
| 329 | 2020-01-24 10:26:37 | patrons | 1 | 69583 | 7 | 2.500 | 27833.2 |
| 328 | 2020-01-22 06:34:52 | patrons | 1 | 69583 | 7 | 1.236 | 56296.9 |
| 327 | 2020-01-13 05:00:29 | patrons | 1 | 69583 | 7 | 3.970 | 17527.2 |
| 326 | 2020-01-12 18:17:27 | patrons | 1 | 69583 | 7 | 1.390 | 50059.7 |