History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cellars"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 470 | 2024-04-18 15:00:04 | cellars | 2 | 107671 | 39 | 4.000 | 26917.8 |
| 469 | 2024-04-13 18:44:12 | cellars | 2 | 107671 | 39 | 7.763 | 13869.8 |
| 468 | 2024-04-13 05:53:49 | cellars | 2 | 107671 | 39 | 3.486 | 30886.7 |
| 467 | 2024-04-13 05:52:13 | cellars | 3 | 134027 | 429 | 7.470 | 17942.0 |
| 466 | 2024-04-12 22:54:17 | cellars | 2 | 107671 | 39 | 3.280 | 32826.5 |
| 465 | 2024-04-12 22:54:13 | cellars | 3 | 134027 | 429 | 6.500 | 20619.5 |
| 464 | 2024-04-12 22:54:09 | cellars | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 463 | 2024-04-12 22:53:52 | cellars | 3 | 134027 | 429 | 7.093 | 18895.7 |
| 462 | 2024-04-10 22:52:37 | cellars | 3 | 134027 | 429 | 16.626 | 8061.3 |
| 461 | 2024-04-09 22:30:33 | cellars | 3 | 134027 | 429 | 14.500 | 9243.2 |
| 460 | 2024-04-09 16:18:35 | cellars | 3 | 134027 | 429 | 8.110 | 16526.1 |
| 459 | 2024-01-25 01:25:54 | cellars | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 458 | 2024-01-15 23:16:00 | cellars | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 457 | 2024-01-12 01:31:04 | cellars | 2 | 107671 | 39 | 3.513 | 30649.3 |
| 456 | 2023-12-14 15:50:49 | cellars | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 455 | 2023-12-11 21:01:55 | cellars | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 454 | 2023-12-11 11:03:10 | cellars | 3 | 134027 | 429 | 6.140 | 21828.5 |
| 453 | 2023-12-02 17:54:48 | cellars | 2 | 107671 | 39 | 2.936 | 36672.7 |
| 452 | 2023-11-25 11:44:07 | cellars | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 451 | 2023-11-21 00:15:55 | cellars | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 450 | 2023-11-14 23:00:05 | cellars | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 449 | 2023-11-13 02:32:26 | cellars | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 448 | 2023-11-01 18:48:32 | cellars | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 447 | 2023-10-25 23:15:22 | cellars | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 446 | 2023-10-21 14:20:16 | cellars | 2 | 107671 | 39 | 2.906 | 37051.3 |
| 445 | 2023-10-13 17:21:53 | cellars | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 444 | 2023-10-13 13:57:04 | cellars | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 443 | 2023-10-08 07:59:59 | cellars | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 442 | 2023-09-25 05:27:52 | cellars | 2 | 107671 | 39 | 7.283 | 14783.9 |
| 441 | 2023-09-24 23:37:44 | cellars | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 440 | 2023-09-21 18:08:02 | cellars | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 439 | 2023-09-18 21:56:50 | cellars | 2 | 107671 | 39 | 5.360 | 20087.9 |
| 438 | 2023-09-15 04:29:25 | cellars | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 437 | 2023-09-10 17:42:55 | cellars | 3 | 134027 | 429 | 8.280 | 16186.8 |
| 436 | 2023-09-10 02:22:36 | cellars | 3 | 134027 | 429 | 6.953 | 19276.1 |
| 435 | 2023-09-01 06:37:58 | cellars | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 434 | 2023-08-16 03:56:04 | cellars | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 433 | 2023-07-31 07:11:52 | cellars | 2 | 107671 | 39 | 2.890 | 37256.4 |
| 432 | 2023-07-04 05:33:21 | cellars | 1 | 69583 | 3 | 2.516 | 27656.2 |
| 431 | 2023-06-07 13:54:45 | cellars | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 430 | 2023-05-31 03:27:21 | cellars | 3 | 134027 | 429 | 5.813 | 23056.4 |
| 429 | 2023-04-11 03:24:04 | cellars | 2 | 107671 | 39 | 2.826 | 38100.1 |
| 428 | 2023-03-27 03:47:43 | cellars | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 427 | 2023-03-24 04:02:53 | cellars | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 426 | 2023-03-08 07:04:23 | cellars | 3 | 134027 | 429 | 5.703 | 23501.1 |
| 425 | 2023-01-16 10:05:41 | cellars | 2 | 107671 | 39 | 2.843 | 37872.3 |
| 424 | 2023-01-10 18:52:45 | cellars | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 423 | 2022-12-18 23:52:36 | cellars | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 422 | 2022-12-14 09:05:10 | cellars | 3 | 134027 | 429 | 5.733 | 23378.2 |
| 421 | 2022-10-28 15:22:50 | cellars | 2 | 107671 | 39 | 2.890 | 37256.4 |
| 420 | 2022-10-24 05:51:12 | cellars | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 419 | 2022-09-08 08:43:05 | cellars | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 418 | 2022-08-05 15:49:48 | cellars | 3 | 134027 | 429 | 6.783 | 19759.3 |
| 417 | 2022-07-29 02:14:52 | cellars | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 416 | 2022-06-14 16:17:20 | cellars | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 415 | 2022-05-29 08:30:38 | cellars | 2 | 107671 | 39 | 2.846 | 37832.4 |
| 414 | 2022-05-27 01:10:51 | cellars | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 413 | 2022-03-11 07:37:20 | cellars | 3 | 134027 | 429 | 6.080 | 22043.9 |
| 412 | 2022-02-20 01:58:28 | cellars | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 411 | 2022-02-18 23:44:23 | cellars | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 410 | 2021-12-15 13:21:10 | cellars | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 409 | 2021-11-17 15:32:44 | cellars | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 408 | 2021-11-02 22:59:57 | cellars | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 407 | 2021-11-01 15:46:28 | cellars | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 406 | 2021-11-01 08:05:03 | cellars | 1 | 69583 | 3 | 1.813 | 38380.0 |
| 405 | 2021-10-22 18:22:31 | cellars | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 404 | 2021-10-20 16:39:23 | cellars | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 403 | 2021-09-22 08:22:47 | cellars | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 402 | 2021-09-21 03:37:55 | cellars | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 401 | 2021-09-20 12:25:12 | cellars | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 400 | 2021-09-19 08:41:26 | cellars | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 399 | 2021-09-06 07:20:03 | cellars | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 398 | 2021-09-04 01:59:32 | cellars | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 397 | 2021-08-19 16:35:06 | cellars | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 396 | 2021-08-18 02:26:43 | cellars | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 395 | 2021-08-17 12:13:59 | cellars | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 394 | 2021-08-14 19:01:25 | cellars | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 393 | 2021-06-21 22:08:20 | cellars | 3 | 134027 | 429 | 5.986 | 22390.1 |
| 392 | 2021-05-24 22:33:35 | cellars | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 391 | 2021-05-14 03:27:47 | cellars | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 390 | 2021-04-28 08:55:00 | cellars | 1 | 69583 | 3 | 1.486 | 46825.7 |
| 389 | 2021-04-22 15:06:57 | cellars | 3 | 134027 | 429 | 8.873 | 15105.0 |
| 388 | 2021-04-02 11:34:53 | cellars | 3 | 134027 | 429 | 5.970 | 22450.1 |
| 387 | 2021-03-28 04:48:23 | cellars | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 386 | 2021-02-10 17:56:55 | cellars | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 385 | 2021-02-05 23:48:47 | cellars | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 384 | 2021-01-17 13:03:36 | cellars | 3 | 134027 | 429 | 6.670 | 20094.0 |
| 383 | 2020-12-13 05:03:26 | cellars | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 382 | 2020-12-08 22:17:33 | cellars | 2 | 107671 | 39 | 2.876 | 37437.8 |
| 381 | 2020-11-10 21:05:44 | cellars | 2 | 107671 | 39 | 4.580 | 23509.0 |
| 380 | 2020-11-03 22:44:37 | cellars | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 379 | 2020-10-31 04:43:06 | cellars | 3 | 134027 | 429 | 11.626 | 11528.2 |
| 378 | 2020-10-27 00:03:23 | cellars | 3 | 134027 | 429 | 6.906 | 19407.3 |
| 377 | 2020-10-08 16:21:32 | cellars | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 376 | 2020-10-07 05:09:35 | cellars | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 375 | 2020-09-29 14:29:34 | cellars | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 374 | 2020-09-06 07:26:25 | cellars | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 373 | 2020-08-22 12:23:58 | cellars | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 372 | 2020-08-17 14:00:17 | cellars | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 371 | 2020-08-17 10:00:35 | cellars | 1 | 69583 | 3 | 1.246 | 55845.1 |