History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shanny"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 537 | 2025-04-20 05:42:45 | shanny | 1 | 48755 | 6 | 2.953 | 16510.3 |
| 536 | 2025-04-11 15:54:13 | shanny | 1 | 48755 | 6 | 3.030 | 16090.8 |
| 535 | 2025-04-11 13:36:21 | shanny | 1 | 48755 | 6 | 5.266 | 9258.5 |
| 534 | 2025-04-08 02:36:15 | shanny | 3 | 112716 | 524 | 29.660 | 3800.3 |
| 533 | 2025-04-06 10:57:34 | shanny | 3 | 112716 | 524 | 34.346 | 3281.8 |
| 532 | 2025-04-03 13:57:16 | shanny | 3 | 112716 | 524 | 4.733 | 23814.9 |
| 531 | 2025-03-31 02:15:29 | shanny | 1 | 48755 | 6 | 3.890 | 12533.4 |
| 530 | 2025-03-22 00:24:23 | shanny | 3 | 112716 | 524 | 36.376 | 3098.6 |
| 529 | 2025-03-20 18:26:20 | shanny | 3 | 112716 | 524 | 31.846 | 3539.4 |
| 528 | 2025-03-18 14:03:45 | shanny | 3 | 112716 | 524 | 5.466 | 20621.3 |
| 527 | 2025-03-13 13:06:51 | shanny | 2 | 82551 | 50 | 12.750 | 6474.6 |
| 526 | 2025-03-13 13:06:10 | shanny | 1 | 48755 | 6 | 2.203 | 22131.2 |
| 525 | 2025-03-12 18:54:24 | shanny | 3 | 112716 | 524 | 23.816 | 4732.8 |
| 524 | 2025-03-11 08:51:40 | shanny | 1 | 48755 | 6 | 5.983 | 8148.9 |
| 523 | 2025-03-10 15:09:24 | shanny | 3 | 112716 | 524 | 18.360 | 6139.2 |
| 522 | 2025-03-08 01:58:43 | shanny | 3 | 112716 | 524 | 24.610 | 4580.1 |
| 521 | 2025-03-07 08:25:10 | shanny | 3 | 112716 | 524 | 36.220 | 3112.0 |
| 520 | 2025-03-07 08:25:30 | shanny | 1 | 48755 | 6 | 3.703 | 13166.4 |
| 519 | 2025-03-07 08:25:06 | shanny | 2 | 82551 | 50 | 12.623 | 6539.7 |
| 518 | 2025-02-28 15:54:34 | shanny | 1 | 48755 | 6 | 3.156 | 15448.4 |
| 517 | 2025-02-27 08:42:31 | shanny | 1 | 48755 | 6 | 2.110 | 23106.6 |
| 516 | 2025-02-24 22:51:09 | shanny | 1 | 48755 | 6 | 2.013 | 24220.1 |
| 515 | 2025-02-17 05:24:33 | shanny | 2 | 82551 | 50 | 11.020 | 7491.0 |
| 514 | 2025-02-09 07:01:51 | shanny | 1 | 48755 | 6 | 2.016 | 24184.0 |
| 513 | 2025-02-07 19:31:25 | shanny | 2 | 82551 | 50 | 8.296 | 9950.7 |
| 512 | 2025-02-05 23:49:23 | shanny | 2 | 82551 | 50 | 8.673 | 9518.2 |
| 511 | 2025-02-05 22:42:06 | shanny | 3 | 112716 | 524 | 25.703 | 4385.3 |
| 510 | 2025-02-05 22:15:48 | shanny | 3 | 112716 | 524 | 7.906 | 14257.0 |
| 509 | 2025-02-04 21:25:49 | shanny | 3 | 112716 | 524 | 32.093 | 3512.2 |
| 508 | 2025-02-04 21:25:48 | shanny | 2 | 82551 | 50 | 10.693 | 7720.1 |
| 507 | 2025-02-04 21:25:46 | shanny | 1 | 48755 | 6 | 5.843 | 8344.2 |
| 506 | 2025-02-01 11:19:47 | shanny | 1 | 48755 | 6 | 3.970 | 12280.9 |
| 505 | 2025-01-28 13:53:59 | shanny | 1 | 48755 | 6 | 3.453 | 14119.6 |
| 504 | 2025-01-06 21:07:34 | shanny | 3 | 112716 | 524 | 14.156 | 7962.4 |
| 503 | 2025-01-06 21:07:32 | shanny | 2 | 82551 | 50 | 5.330 | 15488.0 |
| 502 | 2025-01-06 20:11:09 | shanny | 3 | 112716 | 524 | 5.296 | 21283.2 |
| 501 | 2025-01-06 20:11:10 | shanny | 2 | 82551 | 50 | 2.483 | 33246.5 |
| 500 | 2025-01-06 20:11:08 | shanny | 1 | 48755 | 6 | 0.796 | 61250.0 |
| 499 | 2025-01-05 04:36:53 | shanny | 1 | 48755 | 6 | 5.733 | 8504.3 |
| 498 | 2024-12-28 17:34:50 | shanny | 2 | 82551 | 50 | 7.876 | 10481.3 |
| 497 | 2024-12-28 17:34:48 | shanny | 1 | 48755 | 6 | 1.703 | 28628.9 |
| 496 | 2024-12-08 18:29:54 | shanny | 1 | 48755 | 6 | 2.186 | 22303.3 |
| 495 | 2024-12-06 19:49:11 | shanny | 1 | 48755 | 6 | 4.250 | 11471.8 |
| 494 | 2024-12-06 04:26:47 | shanny | 3 | 112716 | 524 | 18.770 | 6005.1 |
| 493 | 2024-12-05 23:32:10 | shanny | 3 | 112716 | 524 | 28.030 | 4021.3 |
| 492 | 2024-12-05 19:28:04 | shanny | 2 | 82551 | 50 | 10.206 | 8088.5 |
| 491 | 2024-12-05 18:39:35 | shanny | 3 | 112716 | 524 | 5.626 | 20034.8 |
| 490 | 2024-12-05 13:09:11 | shanny | 3 | 112716 | 524 | 18.410 | 6122.5 |
| 489 | 2024-12-05 13:09:11 | shanny | 2 | 82551 | 50 | 8.860 | 9317.3 |
| 488 | 2024-12-05 13:09:06 | shanny | 1 | 48755 | 6 | 2.610 | 18680.1 |
| 487 | 2024-11-28 23:55:40 | shanny | 1 | 48755 | 6 | 4.360 | 11182.3 |
| 486 | 2024-11-08 13:37:09 | shanny | 1 | 48755 | 6 | 2.796 | 17437.4 |
| 485 | 2024-11-06 15:18:44 | shanny | 1 | 48755 | 6 | 6.420 | 7594.2 |
| 484 | 2024-11-03 23:57:29 | shanny | 1 | 48755 | 6 | 4.076 | 11961.5 |
| 483 | 2024-10-28 10:44:08 | shanny | 2 | 82551 | 50 | 10.330 | 7991.4 |
| 482 | 2024-10-28 10:44:03 | shanny | 1 | 48755 | 6 | 1.903 | 25620.1 |
| 481 | 2024-10-26 18:44:11 | shanny | 3 | 112716 | 524 | 25.660 | 4392.7 |
| 480 | 2024-10-25 04:28:41 | shanny | 1 | 48755 | 6 | 6.030 | 8085.4 |
| 479 | 2024-10-21 09:39:55 | shanny | 3 | 112716 | 524 | 40.283 | 2798.1 |
| 478 | 2024-10-20 05:01:32 | shanny | 3 | 112716 | 524 | 27.186 | 4146.1 |
| 477 | 2024-10-19 13:48:26 | shanny | 3 | 112716 | 524 | 30.253 | 3725.8 |
| 476 | 2024-10-19 09:58:04 | shanny | 3 | 112716 | 524 | 29.266 | 3851.4 |
| 475 | 2024-10-07 09:09:51 | shanny | 1 | 48755 | 6 | 2.640 | 18467.8 |
| 474 | 2024-10-03 17:15:09 | shanny | 1 | 48755 | 6 | 3.703 | 13166.4 |
| 473 | 2024-09-27 01:04:02 | shanny | 1 | 48755 | 6 | 6.716 | 7259.5 |
| 472 | 2024-09-08 18:22:54 | shanny | 1 | 48755 | 6 | 9.203 | 5297.7 |
| 471 | 2024-09-05 01:19:01 | shanny | 1 | 48755 | 6 | 6.000 | 8125.8 |
| 470 | 2024-09-03 23:16:42 | shanny | 3 | 112716 | 524 | 40.366 | 2792.3 |
| 469 | 2024-09-03 09:53:41 | shanny | 3 | 112716 | 524 | 38.113 | 2957.4 |
| 468 | 2024-08-31 07:09:05 | shanny | 3 | 112716 | 524 | 41.360 | 2725.2 |
| 467 | 2024-08-31 06:03:36 | shanny | 2 | 82551 | 50 | 19.830 | 4162.9 |
| 466 | 2024-08-31 05:49:27 | shanny | 3 | 112716 | 524 | 8.953 | 12589.7 |
| 465 | 2024-08-31 02:32:12 | shanny | 2 | 82551 | 50 | 27.453 | 3007.0 |
| 464 | 2024-08-31 02:31:54 | shanny | 3 | 112716 | 524 | 36.783 | 3064.4 |
| 463 | 2024-08-31 02:31:07 | shanny | 1 | 48755 | 6 | 5.343 | 9125.0 |
| 462 | 2024-08-30 15:31:26 | shanny | 1 | 48755 | 6 | 9.093 | 5361.8 |
| 461 | 2024-08-26 20:43:59 | shanny | 1 | 48755 | 6 | 6.800 | 7169.9 |
| 460 | 2024-08-16 05:48:19 | shanny | 1 | 48755 | 6 | 8.250 | 5909.7 |
| 459 | 2024-08-08 01:57:37 | shanny | 1 | 48755 | 6 | 3.093 | 15763.0 |
| 458 | 2024-08-01 07:12:22 | shanny | 1 | 48755 | 6 | 2.673 | 18239.8 |
| 457 | 2024-07-31 19:20:41 | shanny | 3 | 112716 | 524 | 20.373 | 5532.6 |
| 456 | 2024-07-31 04:41:34 | shanny | 3 | 112716 | 524 | 8.296 | 13586.8 |
| 455 | 2024-07-31 04:03:29 | shanny | 3 | 112716 | 524 | 29.110 | 3872.1 |
| 454 | 2024-07-31 04:03:27 | shanny | 2 | 82551 | 50 | 7.093 | 11638.4 |
| 453 | 2024-07-31 04:03:23 | shanny | 1 | 48755 | 6 | 4.626 | 10539.3 |
| 452 | 2024-07-28 12:18:51 | shanny | 1 | 48755 | 6 | 3.376 | 14441.6 |
| 451 | 2024-07-27 08:10:21 | shanny | 1 | 48755 | 6 | 3.500 | 13930.0 |
| 450 | 2024-07-26 16:33:53 | shanny | 1 | 48755 | 6 | 3.126 | 15596.6 |
| 449 | 2024-07-26 16:33:49 | shanny | 1 | 48755 | 6 | 3.203 | 15221.7 |
| 448 | 2024-07-24 14:54:08 | shanny | 1 | 48755 | 6 | 1.486 | 32809.6 |
| 447 | 2024-07-22 02:57:28 | shanny | 1 | 48755 | 6 | 4.826 | 10102.6 |
| 446 | 2024-07-13 11:08:34 | shanny | 1 | 48755 | 6 | 1.456 | 33485.6 |
| 445 | 2024-06-28 10:14:10 | shanny | 1 | 48755 | 6 | 2.046 | 23829.4 |
| 444 | 2024-06-28 07:18:24 | shanny | 1 | 48755 | 6 | 3.280 | 14864.3 |
| 443 | 2024-06-26 23:24:58 | shanny | 1 | 48755 | 6 | 1.390 | 35075.5 |
| 442 | 2024-06-06 07:40:41 | shanny | 1 | 48755 | 6 | 4.266 | 11428.7 |
| 441 | 2024-05-29 05:12:52 | shanny | 1 | 48755 | 6 | 4.046 | 12050.2 |
| 440 | 2024-05-27 16:21:58 | shanny | 1 | 48755 | 6 | 1.983 | 24586.5 |
| 439 | 2024-05-12 11:48:58 | shanny | 1 | 48755 | 6 | 1.813 | 26891.9 |
| 438 | 2024-05-11 06:47:36 | shanny | 3 | 112716 | 524 | 13.156 | 8567.6 |