History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spikey"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 498 | 2024-04-28 05:39:02 | spikey | 1 | 48755 | 7 | 2.343 | 20808.8 |
| 497 | 2024-04-27 06:51:18 | spikey | 1 | 48755 | 7 | 2.190 | 22262.6 |
| 496 | 2024-03-29 19:09:40 | spikey | 3 | 112716 | 673 | 12.360 | 9119.4 |
| 495 | 2024-03-29 05:21:57 | spikey | 3 | 112716 | 673 | 10.403 | 10835.0 |
| 494 | 2024-03-29 05:21:47 | spikey | 2 | 82551 | 68 | 4.986 | 16556.6 |
| 493 | 2024-03-28 21:27:35 | spikey | 2 | 82551 | 68 | 3.923 | 21042.8 |
| 492 | 2024-03-28 21:27:27 | spikey | 1 | 48755 | 7 | 3.110 | 15676.8 |
| 491 | 2024-03-15 09:35:06 | spikey | 3 | 112716 | 673 | 20.156 | 5592.2 |
| 490 | 2024-03-08 18:56:16 | spikey | 3 | 112716 | 673 | 16.016 | 7037.7 |
| 489 | 2024-03-07 20:03:10 | spikey | 3 | 112716 | 673 | 12.330 | 9141.6 |
| 488 | 2024-03-05 21:51:47 | spikey | 3 | 112716 | 673 | 6.436 | 17513.4 |
| 487 | 2024-03-05 21:49:55 | spikey | 3 | 112716 | 673 | 6.076 | 18551.0 |
| 486 | 2024-03-04 07:49:39 | spikey | 3 | 112716 | 673 | 5.656 | 19928.6 |
| 485 | 2024-03-04 07:49:42 | spikey | 2 | 82551 | 68 | 2.686 | 30733.8 |
| 484 | 2024-03-04 07:49:24 | spikey | 1 | 48755 | 7 | 0.840 | 58041.7 |
| 483 | 2024-02-11 22:10:18 | spikey | 1 | 48755 | 7 | 0.846 | 57630.0 |
| 482 | 2024-01-30 13:27:56 | spikey | 2 | 82551 | 68 | 2.420 | 34112.0 |
| 481 | 2024-01-30 13:27:04 | spikey | 3 | 112716 | 673 | 7.000 | 16102.3 |
| 480 | 2024-01-27 10:39:26 | spikey | 3 | 112716 | 673 | 6.110 | 18447.8 |
| 479 | 2024-01-22 09:21:17 | spikey | 2 | 82551 | 68 | 2.110 | 39123.7 |
| 478 | 2024-01-20 01:51:25 | spikey | 3 | 112716 | 673 | 6.233 | 18083.7 |
| 477 | 2024-01-19 03:23:09 | spikey | 3 | 112716 | 673 | 4.860 | 23192.6 |
| 476 | 2024-01-09 14:17:54 | spikey | 2 | 82551 | 68 | 2.703 | 30540.5 |
| 475 | 2024-01-09 14:17:44 | spikey | 3 | 112716 | 673 | 6.190 | 18209.4 |
| 474 | 2023-12-18 05:24:35 | spikey | 2 | 82551 | 68 | 2.280 | 36206.6 |
| 473 | 2023-12-18 05:24:30 | spikey | 3 | 112716 | 673 | 4.716 | 23900.8 |
| 472 | 2023-12-17 18:47:55 | spikey | 1 | 48755 | 7 | 0.890 | 54780.9 |
| 471 | 2023-12-07 23:54:01 | spikey | 1 | 48755 | 7 | 0.950 | 51321.1 |
| 470 | 2023-12-07 23:53:59 | spikey | 1 | 48755 | 7 | 1.013 | 48129.3 |
| 469 | 2023-12-02 02:31:09 | spikey | 1 | 48755 | 7 | 0.983 | 49598.2 |
| 468 | 2023-11-30 23:39:20 | spikey | 1 | 48755 | 7 | 1.346 | 36222.1 |
| 467 | 2023-11-25 15:34:00 | spikey | 3 | 112716 | 673 | 4.670 | 24136.2 |
| 466 | 2023-11-19 03:00:01 | spikey | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 465 | 2023-11-17 03:05:18 | spikey | 2 | 82551 | 68 | 2.516 | 32810.4 |
| 464 | 2023-11-17 03:05:12 | spikey | 3 | 112716 | 673 | 5.360 | 21029.1 |
| 463 | 2023-11-05 18:55:56 | spikey | 1 | 48755 | 7 | 0.920 | 52994.6 |
| 462 | 2023-10-29 09:02:08 | spikey | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 461 | 2023-10-21 13:46:30 | spikey | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 460 | 2023-10-18 22:53:39 | spikey | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 459 | 2023-10-17 22:31:15 | spikey | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 458 | 2023-09-26 01:35:14 | spikey | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 457 | 2023-09-15 17:42:35 | spikey | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 456 | 2023-09-14 08:45:17 | spikey | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 455 | 2023-08-26 20:37:03 | spikey | 3 | 112716 | 673 | 5.610 | 20092.0 |
| 454 | 2023-08-18 07:52:36 | spikey | 3 | 112716 | 673 | 5.250 | 21469.7 |
| 453 | 2023-07-31 08:52:03 | spikey | 1 | 48755 | 7 | 0.873 | 55847.7 |
| 452 | 2023-07-11 15:39:57 | spikey | 3 | 112716 | 673 | 5.533 | 20371.6 |
| 451 | 2023-07-08 22:04:52 | spikey | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 450 | 2023-06-30 11:34:08 | spikey | 3 | 112716 | 673 | 5.673 | 19868.9 |
| 449 | 2023-05-29 21:20:34 | spikey | 3 | 112716 | 673 | 5.190 | 21717.9 |
| 448 | 2023-05-19 11:51:24 | spikey | 3 | 112716 | 673 | 5.190 | 21717.9 |
| 447 | 2023-05-16 02:03:18 | spikey | 3 | 112716 | 673 | 4.690 | 24033.3 |
| 446 | 2023-05-12 09:36:56 | spikey | 3 | 112716 | 673 | 4.643 | 24276.5 |
| 445 | 2023-04-21 05:54:03 | spikey | 3 | 112716 | 673 | 4.656 | 24208.8 |
| 444 | 2023-04-15 23:29:51 | spikey | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 443 | 2023-03-24 13:03:29 | spikey | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 442 | 2023-02-21 04:32:47 | spikey | 3 | 112716 | 673 | 4.593 | 24540.8 |
| 441 | 2023-01-20 07:06:54 | spikey | 3 | 112716 | 673 | 5.096 | 22118.5 |
| 440 | 2023-01-15 09:53:42 | spikey | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 439 | 2022-12-23 09:16:15 | spikey | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 438 | 2022-12-06 06:24:30 | spikey | 3 | 112716 | 673 | 5.360 | 21029.1 |
| 437 | 2022-12-01 17:47:17 | spikey | 3 | 112716 | 673 | 4.563 | 24702.2 |
| 436 | 2022-11-15 00:27:13 | spikey | 3 | 112716 | 673 | 5.080 | 22188.2 |
| 435 | 2022-11-12 11:15:28 | spikey | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 434 | 2022-11-06 14:00:58 | spikey | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 433 | 2022-11-06 14:00:57 | spikey | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 432 | 2022-11-04 13:27:10 | spikey | 3 | 112716 | 673 | 4.716 | 23900.8 |
| 431 | 2022-11-04 12:07:23 | spikey | 3 | 112716 | 673 | 4.623 | 24381.6 |
| 430 | 2022-10-30 18:23:44 | spikey | 3 | 112716 | 673 | 5.313 | 21215.1 |
| 429 | 2022-10-26 22:00:37 | spikey | 3 | 112716 | 673 | 4.593 | 24540.8 |
| 428 | 2022-10-20 07:26:59 | spikey | 3 | 112716 | 673 | 4.953 | 22757.1 |
| 427 | 2022-10-06 18:56:54 | spikey | 3 | 112716 | 673 | 4.703 | 23966.8 |
| 426 | 2022-09-30 01:49:26 | spikey | 3 | 112716 | 673 | 4.690 | 24033.3 |
| 425 | 2022-09-06 16:33:02 | spikey | 3 | 112716 | 673 | 5.296 | 21283.2 |
| 424 | 2022-08-30 15:46:03 | spikey | 3 | 112716 | 673 | 4.720 | 23880.5 |
| 423 | 2022-08-24 15:27:32 | spikey | 3 | 112716 | 673 | 5.546 | 20323.8 |
| 422 | 2022-07-18 18:41:27 | spikey | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 421 | 2022-07-17 11:24:24 | spikey | 3 | 112716 | 673 | 5.313 | 21215.1 |
| 420 | 2022-07-10 00:13:33 | spikey | 3 | 112716 | 673 | 4.576 | 24632.0 |
| 419 | 2022-06-24 13:36:45 | spikey | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 418 | 2022-06-15 22:48:05 | spikey | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 417 | 2022-06-09 08:51:36 | spikey | 3 | 112716 | 673 | 5.280 | 21347.7 |
| 416 | 2022-05-09 03:26:39 | spikey | 3 | 112716 | 673 | 5.610 | 20092.0 |
| 415 | 2022-05-05 17:08:16 | spikey | 3 | 112716 | 673 | 5.640 | 19985.1 |
| 414 | 2022-04-20 12:28:01 | spikey | 3 | 112716 | 673 | 5.030 | 22408.7 |
| 413 | 2022-04-18 09:28:52 | spikey | 3 | 112716 | 673 | 5.593 | 20153.0 |
| 412 | 2022-04-03 19:24:25 | spikey | 3 | 112716 | 673 | 5.093 | 22131.6 |
| 411 | 2022-02-25 15:46:55 | spikey | 1 | 48755 | 7 | 1.003 | 48609.2 |
| 410 | 2022-02-21 23:51:42 | spikey | 3 | 112716 | 673 | 5.593 | 20153.0 |
| 409 | 2022-02-01 21:54:11 | spikey | 1 | 48755 | 7 | 0.903 | 53992.2 |
| 408 | 2022-01-20 14:22:41 | spikey | 3 | 112716 | 673 | 5.640 | 19985.1 |
| 407 | 2021-12-21 17:08:19 | spikey | 3 | 112716 | 673 | 9.140 | 12332.2 |
| 406 | 2021-12-14 15:50:06 | spikey | 1 | 48755 | 7 | 0.846 | 57630.0 |
| 405 | 2021-11-06 23:29:10 | spikey | 3 | 112716 | 673 | 6.876 | 16392.7 |
| 404 | 2021-11-06 23:29:02 | spikey | 2 | 82551 | 68 | 2.470 | 33421.5 |
| 403 | 2021-11-02 11:57:53 | spikey | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 402 | 2021-10-27 23:55:35 | spikey | 1 | 48755 | 7 | 0.893 | 54596.9 |
| 401 | 2021-10-06 06:20:03 | spikey | 1 | 48755 | 7 | 0.890 | 54780.9 |
| 400 | 2021-09-18 08:08:32 | spikey | 1 | 48755 | 7 | 0.903 | 53992.2 |
| 399 | 2021-08-31 20:20:43 | spikey | 1 | 48755 | 7 | 0.796 | 61250.0 |