History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"dearest"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 469 | 2024-03-31 13:47:13 | dearest | 1 | 69583 | 5 | 2.110 | 32977.7 |
| 468 | 2024-03-28 05:14:52 | dearest | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 467 | 2024-02-19 05:07:40 | dearest | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 466 | 2024-02-06 04:02:37 | dearest | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 465 | 2024-02-02 08:16:35 | dearest | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 464 | 2024-01-07 16:39:21 | dearest | 2 | 107671 | 51 | 2.876 | 37437.8 |
| 463 | 2023-12-15 17:31:18 | dearest | 3 | 134027 | 532 | 7.190 | 18640.8 |
| 462 | 2023-12-15 17:31:17 | dearest | 2 | 107671 | 51 | 3.610 | 29825.8 |
| 461 | 2023-12-09 23:39:55 | dearest | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 460 | 2023-12-06 17:02:32 | dearest | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 459 | 2023-12-02 17:18:14 | dearest | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 458 | 2023-11-24 06:54:43 | dearest | 1 | 69583 | 5 | 1.200 | 57985.8 |
| 457 | 2023-11-21 13:51:22 | dearest | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 456 | 2023-11-12 03:45:27 | dearest | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 455 | 2023-11-06 17:47:03 | dearest | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 454 | 2023-10-18 04:54:38 | dearest | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 453 | 2023-10-15 12:18:35 | dearest | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 452 | 2023-10-14 01:30:25 | dearest | 2 | 107671 | 51 | 5.216 | 20642.4 |
| 451 | 2023-10-14 01:29:34 | dearest | 2 | 107671 | 51 | 3.216 | 33479.8 |
| 450 | 2023-09-27 20:05:08 | dearest | 1 | 69583 | 5 | 2.470 | 28171.3 |
| 449 | 2023-09-17 10:06:48 | dearest | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 448 | 2023-09-17 00:55:51 | dearest | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 447 | 2023-07-24 06:36:34 | dearest | 2 | 107671 | 51 | 2.826 | 38100.1 |
| 446 | 2023-07-12 13:27:37 | dearest | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 445 | 2023-07-08 19:03:20 | dearest | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 444 | 2023-07-07 04:14:38 | dearest | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 443 | 2023-04-13 01:45:46 | dearest | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 442 | 2023-04-06 23:52:37 | dearest | 2 | 107671 | 51 | 2.860 | 37647.2 |
| 441 | 2023-04-01 06:27:57 | dearest | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 440 | 2023-02-05 18:05:21 | dearest | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 439 | 2023-01-04 16:56:55 | dearest | 2 | 107671 | 51 | 7.250 | 14851.2 |
| 438 | 2022-12-27 21:59:32 | dearest | 3 | 134027 | 532 | 7.173 | 18684.9 |
| 437 | 2022-12-27 02:15:46 | dearest | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 436 | 2022-12-24 20:24:58 | dearest | 3 | 134027 | 532 | 7.063 | 18975.9 |
| 435 | 2022-12-19 21:30:47 | dearest | 3 | 134027 | 532 | 7.156 | 18729.3 |
| 434 | 2022-12-18 12:51:47 | dearest | 3 | 134027 | 532 | 6.560 | 20430.9 |
| 433 | 2022-12-17 19:00:41 | dearest | 3 | 134027 | 532 | 7.283 | 18402.7 |
| 432 | 2022-12-14 07:52:09 | dearest | 3 | 134027 | 532 | 7.546 | 17761.3 |
| 431 | 2022-12-13 15:14:29 | dearest | 3 | 134027 | 532 | 6.470 | 20715.1 |
| 430 | 2022-12-12 19:50:24 | dearest | 3 | 134027 | 532 | 6.703 | 19995.1 |
| 429 | 2022-12-09 16:00:19 | dearest | 3 | 134027 | 532 | 7.513 | 17839.3 |
| 428 | 2022-12-08 21:42:23 | dearest | 3 | 134027 | 532 | 7.126 | 18808.2 |
| 427 | 2022-12-04 11:11:24 | dearest | 1 | 69583 | 5 | 1.050 | 66269.5 |
| 426 | 2022-11-10 14:39:47 | dearest | 3 | 134027 | 532 | 6.360 | 21073.4 |
| 425 | 2022-10-05 03:57:26 | dearest | 3 | 134027 | 532 | 5.860 | 22871.5 |
| 424 | 2022-09-12 18:07:43 | dearest | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 423 | 2022-09-07 07:38:51 | dearest | 2 | 107671 | 51 | 3.220 | 33438.2 |
| 422 | 2022-09-06 04:34:43 | dearest | 3 | 134027 | 532 | 7.593 | 17651.4 |
| 421 | 2022-09-04 11:50:35 | dearest | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 420 | 2022-07-31 01:40:32 | dearest | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 419 | 2022-05-27 17:46:45 | dearest | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 418 | 2022-03-31 21:36:03 | dearest | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 417 | 2022-03-30 17:16:53 | dearest | 2 | 107671 | 51 | 3.796 | 28364.3 |
| 416 | 2022-03-29 19:25:16 | dearest | 1 | 69583 | 5 | 1.393 | 49951.9 |
| 415 | 2022-02-16 09:43:24 | dearest | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 414 | 2022-01-02 14:21:34 | dearest | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 413 | 2021-12-15 10:24:24 | dearest | 2 | 107671 | 51 | 3.326 | 32372.5 |
| 412 | 2021-11-15 01:28:16 | dearest | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 411 | 2021-11-05 01:00:22 | dearest | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 410 | 2021-10-11 10:12:54 | dearest | 1 | 69583 | 5 | 2.436 | 28564.4 |
| 409 | 2021-10-09 08:26:14 | dearest | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 408 | 2021-08-15 12:49:45 | dearest | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 407 | 2021-07-13 20:26:48 | dearest | 2 | 107671 | 51 | 2.906 | 37051.3 |
| 406 | 2021-05-30 17:46:48 | dearest | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 405 | 2021-05-14 21:11:16 | dearest | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 404 | 2021-05-05 11:07:21 | dearest | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 403 | 2021-05-02 17:28:49 | dearest | 2 | 107671 | 51 | 3.140 | 34290.1 |
| 402 | 2021-05-01 03:16:05 | dearest | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 401 | 2021-04-10 23:16:24 | dearest | 3 | 134027 | 532 | 6.706 | 19986.1 |
| 400 | 2021-04-03 14:14:14 | dearest | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 399 | 2021-03-27 05:10:52 | dearest | 3 | 134027 | 532 | 6.186 | 21666.2 |
| 398 | 2021-03-11 00:23:23 | dearest | 3 | 134027 | 532 | 6.156 | 21771.8 |
| 397 | 2021-03-08 00:59:18 | dearest | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 396 | 2021-02-18 05:21:48 | dearest | 3 | 134027 | 532 | 6.470 | 20715.1 |
| 395 | 2021-02-14 03:58:27 | dearest | 2 | 107671 | 51 | 3.220 | 33438.2 |
| 394 | 2021-02-12 00:03:24 | dearest | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 393 | 2021-02-11 23:03:21 | dearest | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 392 | 2021-02-09 17:48:19 | dearest | 2 | 107671 | 51 | 5.920 | 18187.7 |
| 391 | 2021-02-06 23:58:37 | dearest | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 390 | 2021-01-31 00:06:45 | dearest | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 389 | 2021-01-15 23:02:17 | dearest | 2 | 107671 | 51 | 3.546 | 30364.1 |
| 388 | 2021-01-10 13:29:47 | dearest | 3 | 134027 | 532 | 5.906 | 22693.4 |
| 387 | 2020-11-30 05:18:28 | dearest | 3 | 134027 | 532 | 6.063 | 22105.7 |
| 386 | 2020-11-05 00:45:03 | dearest | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 385 | 2020-11-02 12:04:46 | dearest | 2 | 107671 | 51 | 5.016 | 21465.5 |
| 384 | 2020-11-01 10:01:56 | dearest | 2 | 107671 | 51 | 3.720 | 28943.8 |
| 383 | 2020-10-30 03:45:19 | dearest | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 382 | 2020-10-25 12:23:21 | dearest | 3 | 134027 | 532 | 6.546 | 20474.6 |
| 381 | 2020-10-21 16:18:24 | dearest | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 380 | 2020-10-21 13:52:14 | dearest | 3 | 134027 | 532 | 5.966 | 22465.1 |
| 379 | 2020-10-18 02:16:31 | dearest | 2 | 107671 | 51 | 2.890 | 37256.4 |
| 378 | 2020-10-13 10:44:16 | dearest | 3 | 134027 | 532 | 6.110 | 21935.7 |
| 377 | 2020-10-04 12:25:37 | dearest | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 376 | 2020-10-04 08:34:48 | dearest | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 375 | 2020-09-28 19:39:12 | dearest | 3 | 134027 | 532 | 5.953 | 22514.2 |
| 374 | 2020-09-11 04:31:11 | dearest | 2 | 107671 | 51 | 2.873 | 37476.9 |
| 373 | 2020-09-06 13:51:41 | dearest | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 372 | 2020-08-23 23:31:19 | dearest | 3 | 134027 | 532 | 6.110 | 21935.7 |
| 371 | 2020-08-09 07:37:51 | dearest | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 370 | 2020-08-05 04:24:53 | dearest | 1 | 69583 | 5 | 1.220 | 57035.2 |