History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nanny"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 508 | 2024-04-03 06:03:50 | nanny | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 507 | 2024-04-02 22:51:35 | nanny | 3 | 83667 | 986 | 13.813 | 6057.1 |
| 506 | 2024-03-31 15:53:14 | nanny | 2 | 53800 | 89 | 1.703 | 31591.3 |
| 505 | 2024-03-31 15:53:14 | nanny | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 504 | 2024-03-31 15:52:30 | nanny | 3 | 83667 | 986 | 7.673 | 10904.1 |
| 503 | 2024-03-31 14:06:32 | nanny | 3 | 83667 | 986 | 9.330 | 8967.5 |
| 502 | 2024-03-31 10:19:32 | nanny | 3 | 83667 | 986 | 14.486 | 5775.7 |
| 501 | 2024-03-31 10:19:31 | nanny | 2 | 53800 | 89 | 5.703 | 9433.6 |
| 500 | 2024-03-31 08:17:35 | nanny | 1 | 28756 | 5 | 1.016 | 28303.1 |
| 499 | 2024-03-29 02:51:18 | nanny | 1 | 28756 | 5 | 1.220 | 23570.5 |
| 498 | 2024-03-03 22:02:48 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 497 | 2024-03-01 05:08:28 | nanny | 1 | 28756 | 5 | 0.580 | 49579.3 |
| 496 | 2024-02-29 05:18:16 | nanny | 2 | 53800 | 89 | 1.720 | 31279.1 |
| 495 | 2024-02-29 05:17:52 | nanny | 3 | 83667 | 986 | 4.720 | 17726.1 |
| 494 | 2024-02-28 04:48:30 | nanny | 3 | 83667 | 986 | 10.890 | 7682.9 |
| 493 | 2024-02-28 01:07:38 | nanny | 2 | 53800 | 89 | 1.673 | 32157.8 |
| 492 | 2024-02-28 01:07:13 | nanny | 3 | 83667 | 986 | 4.330 | 19322.6 |
| 491 | 2024-02-27 23:01:00 | nanny | 3 | 83667 | 986 | 4.890 | 17109.8 |
| 490 | 2024-02-27 23:01:01 | nanny | 2 | 53800 | 89 | 1.843 | 29191.5 |
| 489 | 2024-02-27 20:38:42 | nanny | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 488 | 2024-01-28 19:50:19 | nanny | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 487 | 2024-01-28 18:46:13 | nanny | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 486 | 2024-01-15 01:46:32 | nanny | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 485 | 2024-01-08 14:07:47 | nanny | 2 | 53800 | 89 | 1.516 | 35488.1 |
| 484 | 2024-01-08 14:07:40 | nanny | 3 | 83667 | 986 | 3.406 | 24564.6 |
| 483 | 2023-12-13 11:55:43 | nanny | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 482 | 2023-12-07 09:19:32 | nanny | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 481 | 2023-12-07 09:19:31 | nanny | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 480 | 2023-11-26 05:46:02 | nanny | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 479 | 2023-11-16 05:22:59 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 478 | 2023-11-10 06:19:11 | nanny | 1 | 28756 | 5 | 0.563 | 51076.4 |
| 477 | 2023-11-08 02:29:27 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 476 | 2023-11-03 11:23:52 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 475 | 2023-10-25 00:18:50 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 474 | 2023-10-20 11:38:36 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 473 | 2023-10-12 08:23:06 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 472 | 2023-10-05 02:36:58 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 471 | 2023-09-28 12:43:02 | nanny | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 470 | 2023-09-12 20:17:37 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 469 | 2023-08-30 09:45:51 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 468 | 2023-08-17 04:09:53 | nanny | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 467 | 2023-08-13 20:54:33 | nanny | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 466 | 2023-06-04 07:21:15 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 465 | 2023-04-29 03:44:35 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 464 | 2023-03-26 08:45:34 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 463 | 2023-01-28 17:16:00 | nanny | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 462 | 2023-01-10 06:23:28 | nanny | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 461 | 2023-01-05 16:08:34 | nanny | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 460 | 2022-12-13 21:22:06 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 459 | 2022-11-22 07:55:29 | nanny | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 458 | 2022-11-07 06:34:13 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 457 | 2022-10-25 04:04:09 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 456 | 2022-09-19 17:13:03 | nanny | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 455 | 2022-09-12 08:50:16 | nanny | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 454 | 2022-09-07 14:34:27 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 453 | 2022-08-15 10:09:07 | nanny | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 452 | 2022-08-14 17:53:28 | nanny | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 451 | 2022-08-14 02:58:11 | nanny | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 450 | 2022-07-29 02:06:35 | nanny | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 449 | 2022-06-16 05:23:15 | nanny | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 448 | 2022-05-12 13:53:30 | nanny | 1 | 28756 | 5 | 0.640 | 44931.3 |
| 447 | 2022-02-23 17:12:52 | nanny | 1 | 28756 | 5 | 0.576 | 49923.6 |
| 446 | 2022-01-24 21:50:20 | nanny | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 445 | 2022-01-13 10:17:51 | nanny | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 444 | 2022-01-13 00:25:08 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 443 | 2022-01-12 07:29:57 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 442 | 2022-01-11 22:02:13 | nanny | 1 | 28756 | 5 | 1.110 | 25906.3 |
| 441 | 2022-01-11 04:57:15 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 440 | 2022-01-10 15:34:20 | nanny | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 439 | 2022-01-10 00:55:54 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 438 | 2022-01-09 13:40:34 | nanny | 1 | 28756 | 5 | 0.563 | 51076.4 |
| 437 | 2021-12-22 04:15:38 | nanny | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 436 | 2021-12-10 18:03:04 | nanny | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 435 | 2021-11-26 17:40:43 | nanny | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 434 | 2021-11-26 07:07:29 | nanny | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 433 | 2021-11-25 14:21:04 | nanny | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 432 | 2021-11-03 22:06:53 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 431 | 2021-10-26 04:13:54 | nanny | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 430 | 2021-10-24 03:08:22 | nanny | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 429 | 2021-10-11 15:03:31 | nanny | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 428 | 2021-09-14 06:40:21 | nanny | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 427 | 2021-08-27 17:36:19 | nanny | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 426 | 2021-08-12 11:11:22 | nanny | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 425 | 2021-08-11 18:06:52 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 424 | 2021-07-10 03:19:54 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 423 | 2021-05-23 12:45:55 | nanny | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 422 | 2021-04-06 07:20:56 | nanny | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 421 | 2021-04-02 03:49:16 | nanny | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 420 | 2021-01-16 01:45:36 | nanny | 3 | 83667 | 986 | 3.830 | 21845.2 |
| 419 | 2021-01-10 00:26:15 | nanny | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 418 | 2021-01-03 12:06:59 | nanny | 3 | 83667 | 986 | 3.420 | 24464.0 |
| 417 | 2020-12-24 21:07:26 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 416 | 2020-12-17 02:02:20 | nanny | 3 | 83667 | 986 | 3.390 | 24680.5 |
| 415 | 2020-12-11 14:48:44 | nanny | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 414 | 2020-11-17 06:43:44 | nanny | 3 | 83667 | 986 | 3.720 | 22491.1 |
| 413 | 2020-11-14 10:31:07 | nanny | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 412 | 2020-11-01 17:33:37 | nanny | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 411 | 2020-10-31 17:59:46 | nanny | 2 | 53800 | 89 | 1.450 | 37103.4 |
| 410 | 2020-10-28 06:36:05 | nanny | 1 | 28756 | 5 | 0.923 | 31154.9 |
| 409 | 2020-09-21 00:49:45 | nanny | 1 | 28756 | 5 | 0.873 | 32939.3 |