History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"capitols"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 541 | 2024-05-03 15:05:12 | capitols | 3 | 146162 | 100 | 10.546 | 13859.5 |
| 540 | 2024-04-30 07:33:25 | capitols | 2 | 121059 | 9 | 4.233 | 28598.9 |
| 539 | 2024-04-28 03:06:36 | capitols | 1 | 82945 | 3 | 4.313 | 19231.4 |
| 538 | 2024-04-28 02:28:27 | capitols | 3 | 146162 | 100 | 11.703 | 12489.3 |
| 537 | 2024-04-26 18:09:36 | capitols | 2 | 121059 | 9 | 4.080 | 29671.3 |
| 536 | 2024-04-26 18:06:59 | capitols | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 535 | 2024-04-26 18:06:27 | capitols | 3 | 146162 | 100 | 7.986 | 18302.3 |
| 534 | 2024-04-22 06:01:42 | capitols | 4 | 161609 | 1016 | 19.703 | 8202.3 |
| 533 | 2024-04-20 18:53:01 | capitols | 4 | 161609 | 1016 | 52.626 | 3070.9 |
| 532 | 2024-04-20 14:48:59 | capitols | 4 | 161609 | 1016 | 44.080 | 3666.3 |
| 531 | 2024-04-20 09:40:59 | capitols | 3 | 146162 | 100 | 9.610 | 15209.4 |
| 530 | 2024-04-20 03:46:19 | capitols | 4 | 161609 | 1016 | 25.206 | 6411.5 |
| 529 | 2024-04-19 18:48:08 | capitols | 4 | 161609 | 1016 | 36.393 | 4440.7 |
| 528 | 2024-04-19 10:30:10 | capitols | 4 | 161609 | 1016 | 45.940 | 3517.8 |
| 527 | 2024-04-19 10:30:14 | capitols | 3 | 146162 | 100 | 15.360 | 9515.8 |
| 526 | 2024-04-19 10:30:12 | capitols | 2 | 121059 | 9 | 16.283 | 7434.7 |
| 525 | 2024-04-19 09:43:41 | capitols | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 524 | 2024-04-05 21:05:25 | capitols | 1 | 82945 | 3 | 2.530 | 32784.6 |
| 523 | 2024-03-30 10:26:30 | capitols | 3 | 146162 | 100 | 13.266 | 11017.8 |
| 522 | 2024-03-28 22:01:30 | capitols | 2 | 121059 | 9 | 7.923 | 15279.4 |
| 521 | 2024-03-28 21:46:16 | capitols | 3 | 146162 | 100 | 15.750 | 9280.1 |
| 520 | 2024-03-28 17:40:04 | capitols | 3 | 146162 | 100 | 8.233 | 17753.2 |
| 519 | 2024-03-28 17:40:06 | capitols | 2 | 121059 | 9 | 3.780 | 32026.2 |
| 518 | 2024-03-28 17:40:00 | capitols | 1 | 82945 | 3 | 1.690 | 49079.9 |
| 517 | 2024-03-21 07:12:24 | capitols | 4 | 161609 | 1016 | 45.160 | 3578.6 |
| 516 | 2024-03-18 21:17:17 | capitols | 4 | 161609 | 1016 | 11.690 | 13824.6 |
| 515 | 2024-03-18 02:49:45 | capitols | 4 | 161609 | 1016 | 23.673 | 6826.7 |
| 514 | 2024-03-17 22:20:19 | capitols | 4 | 161609 | 1016 | 16.283 | 9925.0 |
| 513 | 2024-03-15 12:27:07 | capitols | 2 | 121059 | 9 | 13.143 | 9210.9 |
| 512 | 2024-03-15 12:13:36 | capitols | 3 | 146162 | 100 | 7.343 | 19904.9 |
| 511 | 2024-03-15 04:13:00 | capitols | 4 | 161609 | 1016 | 16.343 | 9888.6 |
| 510 | 2024-03-14 14:26:55 | capitols | 2 | 121059 | 9 | 8.513 | 14220.5 |
| 509 | 2024-03-14 14:26:42 | capitols | 3 | 146162 | 100 | 15.796 | 9253.1 |
| 508 | 2024-03-14 14:26:37 | capitols | 4 | 161609 | 1016 | 16.940 | 9540.1 |
| 507 | 2024-03-14 13:40:21 | capitols | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 506 | 2024-03-07 10:23:08 | capitols | 1 | 82945 | 3 | 4.563 | 18177.7 |
| 505 | 2024-03-06 10:47:18 | capitols | 1 | 82945 | 3 | 3.360 | 24686.0 |
| 504 | 2024-03-01 19:04:51 | capitols | 1 | 82945 | 3 | 2.076 | 39954.2 |
| 503 | 2024-02-04 11:58:14 | capitols | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 502 | 2024-01-30 04:49:41 | capitols | 3 | 146162 | 100 | 7.716 | 18942.7 |
| 501 | 2024-01-29 22:20:26 | capitols | 1 | 82945 | 3 | 3.143 | 26390.4 |
| 500 | 2024-01-26 00:10:52 | capitols | 3 | 146162 | 100 | 9.296 | 15723.1 |
| 499 | 2024-01-26 00:10:23 | capitols | 3 | 146162 | 100 | 7.483 | 19532.5 |
| 498 | 2024-01-21 18:31:48 | capitols | 3 | 146162 | 100 | 6.860 | 21306.4 |
| 497 | 2024-01-16 10:54:13 | capitols | 2 | 121059 | 9 | 3.296 | 36729.1 |
| 496 | 2024-01-05 18:49:26 | capitols | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 495 | 2023-12-22 00:34:18 | capitols | 4 | 161609 | 1016 | 12.296 | 13143.2 |
| 494 | 2023-12-22 00:34:20 | capitols | 3 | 146162 | 100 | 7.593 | 19249.6 |
| 493 | 2023-12-17 02:44:17 | capitols | 2 | 121059 | 9 | 3.766 | 32145.2 |
| 492 | 2023-12-11 00:57:19 | capitols | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 491 | 2023-11-28 20:18:49 | capitols | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 490 | 2023-11-27 14:21:17 | capitols | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 489 | 2023-11-01 03:07:25 | capitols | 3 | 146162 | 100 | 6.860 | 21306.4 |
| 488 | 2023-10-29 17:24:27 | capitols | 1 | 82945 | 3 | 1.733 | 47862.1 |
| 487 | 2023-10-28 16:36:54 | capitols | 2 | 121059 | 9 | 3.656 | 33112.4 |
| 486 | 2023-10-24 21:45:45 | capitols | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 485 | 2023-10-13 13:30:51 | capitols | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 484 | 2023-09-25 17:14:40 | capitols | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 483 | 2023-09-18 13:13:30 | capitols | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 482 | 2023-09-14 05:23:34 | capitols | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 481 | 2023-09-13 12:14:44 | capitols | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 480 | 2023-08-07 13:16:34 | capitols | 3 | 146162 | 100 | 6.406 | 22816.4 |
| 479 | 2023-08-06 19:47:51 | capitols | 2 | 121059 | 9 | 3.216 | 37642.7 |
| 478 | 2023-07-03 20:30:54 | capitols | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 477 | 2023-05-27 12:02:31 | capitols | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 476 | 2023-04-16 05:51:17 | capitols | 3 | 146162 | 100 | 6.220 | 23498.7 |
| 475 | 2023-04-16 02:22:25 | capitols | 2 | 121059 | 9 | 3.300 | 36684.5 |
| 474 | 2023-04-10 11:35:39 | capitols | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 473 | 2023-02-18 13:23:12 | capitols | 2 | 121059 | 9 | 3.610 | 33534.3 |
| 472 | 2023-02-11 07:21:45 | capitols | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 471 | 2023-01-31 06:26:47 | capitols | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 470 | 2023-01-21 19:08:34 | capitols | 3 | 146162 | 100 | 6.300 | 23200.3 |
| 469 | 2023-01-21 09:02:22 | capitols | 2 | 121059 | 9 | 3.190 | 37949.5 |
| 468 | 2023-01-21 02:58:18 | capitols | 4 | 161609 | 1016 | 12.516 | 12912.2 |
| 467 | 2022-12-14 06:13:24 | capitols | 2 | 121059 | 9 | 3.423 | 35366.3 |
| 466 | 2022-12-08 20:47:26 | capitols | 3 | 146162 | 100 | 7.250 | 20160.3 |
| 465 | 2022-12-08 04:46:31 | capitols | 2 | 121059 | 9 | 3.580 | 33815.4 |
| 464 | 2022-12-05 10:21:50 | capitols | 4 | 161609 | 1016 | 13.690 | 11804.9 |
| 463 | 2022-12-03 15:58:29 | capitols | 3 | 146162 | 100 | 6.873 | 21266.1 |
| 462 | 2022-11-29 01:51:27 | capitols | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 461 | 2022-11-13 15:15:00 | capitols | 2 | 121059 | 9 | 4.033 | 30017.1 |
| 460 | 2022-11-03 12:03:18 | capitols | 3 | 146162 | 100 | 6.986 | 20922.1 |
| 459 | 2022-11-01 11:44:21 | capitols | 2 | 121059 | 9 | 4.046 | 29920.7 |
| 458 | 2022-10-28 09:31:29 | capitols | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 457 | 2022-10-22 00:20:02 | capitols | 3 | 146162 | 100 | 6.266 | 23326.2 |
| 456 | 2022-10-20 07:56:53 | capitols | 4 | 161609 | 1016 | 11.406 | 14168.8 |
| 455 | 2022-07-25 02:35:34 | capitols | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 454 | 2022-07-14 19:48:27 | capitols | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 453 | 2022-06-03 01:02:30 | capitols | 2 | 121059 | 9 | 3.203 | 37795.5 |
| 452 | 2022-05-20 10:55:23 | capitols | 3 | 146162 | 100 | 6.673 | 21903.5 |
| 451 | 2022-05-16 10:10:27 | capitols | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 450 | 2022-03-24 15:16:21 | capitols | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 449 | 2022-03-19 22:58:00 | capitols | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 448 | 2022-01-15 12:32:02 | capitols | 3 | 146162 | 100 | 6.906 | 21164.5 |
| 447 | 2021-12-28 01:10:54 | capitols | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 446 | 2021-12-07 07:09:51 | capitols | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 445 | 2021-12-04 00:19:45 | capitols | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 444 | 2021-11-16 05:24:21 | capitols | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 443 | 2021-11-14 03:53:34 | capitols | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 442 | 2021-08-30 22:12:54 | capitols | 1 | 82945 | 3 | 1.593 | 52068.4 |