History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"faulty"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 565 | 2024-04-28 04:30:28 | faulty | 1 | 48755 | 5 | 3.110 | 15676.8 |
| 564 | 2024-04-28 02:48:59 | faulty | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 563 | 2024-04-03 01:15:12 | faulty | 1 | 48755 | 5 | 3.000 | 16251.7 |
| 562 | 2024-03-06 15:39:24 | faulty | 1 | 48755 | 5 | 2.080 | 23439.9 |
| 561 | 2024-03-03 23:35:15 | faulty | 1 | 48755 | 5 | 2.890 | 16870.2 |
| 560 | 2024-02-28 16:48:41 | faulty | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 559 | 2024-02-22 17:39:47 | faulty | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 558 | 2024-01-25 08:08:26 | faulty | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 557 | 2024-01-17 17:20:46 | faulty | 3 | 112716 | 440 | 4.640 | 24292.2 |
| 556 | 2024-01-15 22:28:42 | faulty | 3 | 112716 | 440 | 5.593 | 20153.0 |
| 555 | 2024-01-14 14:36:30 | faulty | 3 | 112716 | 440 | 4.796 | 23502.1 |
| 554 | 2023-12-27 16:04:39 | faulty | 2 | 82551 | 34 | 2.123 | 38884.1 |
| 553 | 2023-12-05 21:39:10 | faulty | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 552 | 2023-11-26 15:17:23 | faulty | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 551 | 2023-11-25 17:22:37 | faulty | 2 | 82551 | 34 | 2.250 | 36689.3 |
| 550 | 2023-11-16 10:45:14 | faulty | 3 | 112716 | 440 | 5.063 | 22262.7 |
| 549 | 2023-11-11 07:34:39 | faulty | 3 | 112716 | 440 | 6.156 | 18309.9 |
| 548 | 2023-11-10 02:22:21 | faulty | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 547 | 2023-11-05 23:44:19 | faulty | 3 | 112716 | 440 | 7.296 | 15449.0 |
| 546 | 2023-11-03 17:53:16 | faulty | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 545 | 2023-10-29 16:17:45 | faulty | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 544 | 2023-10-26 11:32:47 | faulty | 3 | 112716 | 440 | 6.483 | 17386.4 |
| 543 | 2023-10-24 09:44:20 | faulty | 3 | 112716 | 440 | 5.360 | 21029.1 |
| 542 | 2023-10-17 14:00:00 | faulty | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 541 | 2023-10-13 08:10:53 | faulty | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 540 | 2023-10-05 03:02:19 | faulty | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 539 | 2023-09-27 09:03:34 | faulty | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 538 | 2023-09-21 01:38:34 | faulty | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 537 | 2023-09-20 16:45:07 | faulty | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 536 | 2023-09-13 17:46:29 | faulty | 3 | 112716 | 440 | 5.390 | 20912.1 |
| 535 | 2023-09-13 17:46:25 | faulty | 2 | 82551 | 34 | 2.470 | 33421.5 |
| 534 | 2023-09-10 13:31:14 | faulty | 1 | 48755 | 5 | 0.800 | 60943.8 |
| 533 | 2023-08-03 09:57:26 | faulty | 3 | 112716 | 440 | 5.170 | 21801.9 |
| 532 | 2023-07-14 16:02:03 | faulty | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 531 | 2023-06-13 16:34:09 | faulty | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 530 | 2023-05-23 23:12:51 | faulty | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 529 | 2023-04-19 20:24:25 | faulty | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 528 | 2023-04-10 21:38:04 | faulty | 3 | 112716 | 440 | 4.593 | 24540.8 |
| 527 | 2023-02-25 15:49:38 | faulty | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 526 | 2023-02-07 11:29:23 | faulty | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 525 | 2023-01-14 08:11:49 | faulty | 3 | 112716 | 440 | 4.546 | 24794.5 |
| 524 | 2022-12-05 21:23:46 | faulty | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 523 | 2022-11-08 19:35:10 | faulty | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 522 | 2022-11-05 09:18:37 | faulty | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 521 | 2022-10-17 04:27:05 | faulty | 3 | 112716 | 440 | 4.576 | 24632.0 |
| 520 | 2022-09-14 16:10:46 | faulty | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 519 | 2022-09-02 00:56:52 | faulty | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 518 | 2022-08-28 09:35:59 | faulty | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 517 | 2022-08-14 22:59:52 | faulty | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 516 | 2022-08-06 16:06:04 | faulty | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 515 | 2022-08-02 11:04:33 | faulty | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 514 | 2022-07-31 03:22:50 | faulty | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 513 | 2022-07-15 18:47:41 | faulty | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 512 | 2022-05-19 04:30:08 | faulty | 3 | 112716 | 440 | 4.720 | 23880.5 |
| 511 | 2022-05-16 06:44:47 | faulty | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 510 | 2022-03-23 10:44:27 | faulty | 1 | 48755 | 5 | 1.140 | 42767.5 |
| 509 | 2022-03-15 03:43:20 | faulty | 1 | 48755 | 5 | 1.030 | 47335.0 |
| 508 | 2021-12-27 05:05:05 | faulty | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 507 | 2021-12-01 10:54:08 | faulty | 1 | 48755 | 5 | 1.750 | 27860.0 |
| 506 | 2021-10-31 22:58:51 | faulty | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 505 | 2021-10-29 22:27:58 | faulty | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 504 | 2021-08-21 16:50:57 | faulty | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 503 | 2021-08-09 23:28:40 | faulty | 3 | 112716 | 440 | 4.610 | 24450.3 |
| 502 | 2021-07-12 20:17:14 | faulty | 3 | 112716 | 440 | 9.283 | 12142.2 |
| 501 | 2021-05-28 18:34:56 | faulty | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 500 | 2021-05-21 01:57:36 | faulty | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 499 | 2021-05-03 01:19:26 | faulty | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 498 | 2021-04-01 07:16:31 | faulty | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 497 | 2021-02-18 15:16:27 | faulty | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 496 | 2021-02-09 23:00:23 | faulty | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 495 | 2020-12-07 10:04:16 | faulty | 2 | 82551 | 34 | 2.610 | 31628.7 |
| 494 | 2020-11-14 15:13:41 | faulty | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 493 | 2020-11-07 06:41:10 | faulty | 2 | 82551 | 34 | 2.173 | 37989.4 |
| 492 | 2020-11-02 01:06:40 | faulty | 1 | 48755 | 5 | 1.003 | 48609.2 |
| 491 | 2020-10-31 11:16:16 | faulty | 1 | 48755 | 5 | 1.673 | 29142.3 |
| 490 | 2020-10-27 21:35:08 | faulty | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 489 | 2020-10-23 12:41:37 | faulty | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 488 | 2020-08-19 22:35:08 | faulty | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 487 | 2020-08-13 00:45:53 | faulty | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 486 | 2020-07-26 10:01:23 | faulty | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 485 | 2020-05-11 22:58:10 | faulty | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 484 | 2020-04-15 09:54:56 | faulty | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 483 | 2020-03-26 12:07:53 | faulty | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 482 | 2020-03-26 04:20:41 | faulty | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 481 | 2020-03-24 06:08:11 | faulty | 1 | 48755 | 5 | 0.903 | 53992.2 |
| 480 | 2020-03-23 07:05:21 | faulty | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 479 | 2020-03-22 03:03:46 | faulty | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 478 | 2020-03-18 08:59:10 | faulty | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 477 | 2020-02-26 21:04:59 | faulty | 1 | 48755 | 5 | 1.000 | 48755.0 |
| 476 | 2020-02-23 10:18:35 | faulty | 1 | 48755 | 5 | 1.890 | 25796.3 |
| 475 | 2020-02-14 06:37:47 | faulty | 1 | 48755 | 5 | 1.716 | 28412.0 |
| 474 | 2020-02-09 08:20:49 | faulty | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 473 | 2020-02-07 17:45:48 | faulty | 1 | 48755 | 5 | 1.563 | 31193.2 |
| 472 | 2020-02-06 08:45:40 | faulty | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 471 | 2020-02-02 11:38:07 | faulty | 1 | 48755 | 5 | 1.313 | 37132.5 |
| 470 | 2020-02-01 03:43:03 | faulty | 1 | 48755 | 5 | 1.063 | 45865.5 |
| 469 | 2020-01-31 09:02:23 | faulty | 1 | 48755 | 5 | 1.123 | 43415.0 |
| 468 | 2020-01-26 22:11:23 | faulty | 1 | 48755 | 5 | 0.970 | 50262.9 |
| 467 | 2020-01-22 07:00:24 | faulty | 1 | 48755 | 5 | 2.783 | 17518.9 |
| 466 | 2020-01-15 20:43:10 | faulty | 1 | 48755 | 5 | 0.893 | 54596.9 |