History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fanion"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 441 | 2024-04-27 18:26:08 | fanion | 1 | 48755 | 5 | 0.970 | 50262.9 |
| 440 | 2024-04-23 15:58:06 | fanion | 1 | 48755 | 5 | 2.126 | 22932.7 |
| 439 | 2024-04-23 13:23:33 | fanion | 1 | 48755 | 5 | 1.923 | 25353.6 |
| 438 | 2024-04-09 18:20:02 | fanion | 1 | 48755 | 5 | 2.970 | 16415.8 |
| 437 | 2024-04-09 12:33:52 | fanion | 2 | 82551 | 53 | 2.860 | 28864.0 |
| 436 | 2024-04-09 12:33:22 | fanion | 3 | 112716 | 571 | 5.860 | 19234.8 |
| 435 | 2024-04-08 22:17:26 | fanion | 3 | 112716 | 571 | 17.423 | 6469.4 |
| 434 | 2024-04-08 22:17:37 | fanion | 1 | 48755 | 5 | 1.173 | 41564.4 |
| 433 | 2024-04-08 22:17:27 | fanion | 2 | 82551 | 53 | 3.843 | 21480.9 |
| 432 | 2024-04-08 22:17:22 | fanion | 1 | 48755 | 5 | 1.140 | 42767.5 |
| 431 | 2024-04-03 03:46:46 | fanion | 1 | 48755 | 5 | 1.513 | 32224.1 |
| 430 | 2024-03-31 02:29:57 | fanion | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 429 | 2024-03-08 06:49:26 | fanion | 1 | 48755 | 5 | 2.783 | 17518.9 |
| 428 | 2024-02-13 05:33:23 | fanion | 3 | 112716 | 571 | 10.033 | 11234.5 |
| 427 | 2024-02-12 15:47:47 | fanion | 3 | 112716 | 571 | 12.420 | 9075.4 |
| 426 | 2024-02-09 22:17:29 | fanion | 3 | 112716 | 571 | 13.813 | 8160.1 |
| 425 | 2024-02-06 10:00:42 | fanion | 3 | 112716 | 571 | 6.156 | 18309.9 |
| 424 | 2024-02-06 10:00:38 | fanion | 2 | 82551 | 53 | 2.720 | 30349.6 |
| 423 | 2024-02-06 10:00:34 | fanion | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 422 | 2024-01-07 10:00:01 | fanion | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 421 | 2024-01-06 16:51:38 | fanion | 3 | 112716 | 571 | 5.686 | 19823.4 |
| 420 | 2024-01-06 16:51:37 | fanion | 2 | 82551 | 53 | 2.580 | 31996.5 |
| 419 | 2023-12-27 22:50:12 | fanion | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 418 | 2023-12-21 21:32:15 | fanion | 3 | 112716 | 571 | 5.483 | 20557.4 |
| 417 | 2023-12-21 21:32:14 | fanion | 2 | 82551 | 53 | 2.640 | 31269.3 |
| 416 | 2023-11-25 16:18:17 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 415 | 2023-11-15 06:27:19 | fanion | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 414 | 2023-11-12 01:58:22 | fanion | 1 | 48755 | 5 | 0.840 | 58041.7 |
| 413 | 2023-11-12 01:18:16 | fanion | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 412 | 2023-11-09 22:25:57 | fanion | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 411 | 2023-10-20 11:42:34 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 410 | 2023-10-17 08:58:42 | fanion | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 409 | 2023-10-11 15:35:13 | fanion | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 408 | 2023-09-25 00:23:32 | fanion | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 407 | 2023-09-13 13:11:32 | fanion | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 406 | 2023-08-12 11:19:40 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 405 | 2023-08-09 17:05:02 | fanion | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 404 | 2023-05-12 21:45:44 | fanion | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 403 | 2023-05-02 04:07:06 | fanion | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 402 | 2023-03-09 00:31:32 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 401 | 2023-01-19 21:03:32 | fanion | 1 | 48755 | 5 | 1.483 | 32875.9 |
| 400 | 2022-12-29 00:24:13 | fanion | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 399 | 2022-10-02 03:12:19 | fanion | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 398 | 2022-09-18 05:46:42 | fanion | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 397 | 2022-08-14 16:43:21 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 396 | 2022-07-19 10:49:23 | fanion | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 395 | 2022-07-17 03:56:35 | fanion | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 394 | 2022-06-11 12:09:09 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 393 | 2022-06-07 21:37:34 | fanion | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 392 | 2022-03-08 06:00:23 | fanion | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 391 | 2022-03-06 02:10:08 | fanion | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 390 | 2022-02-24 11:46:05 | fanion | 1 | 48755 | 5 | 1.250 | 39004.0 |
| 389 | 2022-01-28 22:22:40 | fanion | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 388 | 2022-01-27 17:35:01 | fanion | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 387 | 2022-01-26 20:58:52 | fanion | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 386 | 2022-01-25 22:03:04 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 385 | 2022-01-24 23:27:18 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 384 | 2021-12-31 09:58:26 | fanion | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 383 | 2021-11-16 07:50:04 | fanion | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 382 | 2021-11-12 23:59:21 | fanion | 1 | 48755 | 5 | 0.986 | 49447.3 |
| 381 | 2021-11-01 10:39:11 | fanion | 2 | 82551 | 53 | 2.716 | 30394.3 |
| 380 | 2021-10-05 03:59:10 | fanion | 1 | 48755 | 5 | 0.753 | 64747.7 |
| 379 | 2021-09-22 13:34:11 | fanion | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 378 | 2021-09-21 19:21:29 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 377 | 2021-09-21 02:04:36 | fanion | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 376 | 2021-09-15 05:26:09 | fanion | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 375 | 2021-09-02 21:49:49 | fanion | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 374 | 2021-08-16 09:19:50 | fanion | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 373 | 2021-08-10 02:19:39 | fanion | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 372 | 2021-06-02 08:29:59 | fanion | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 371 | 2021-05-28 15:32:56 | fanion | 2 | 82551 | 53 | 2.423 | 34069.7 |
| 370 | 2021-05-02 22:10:43 | fanion | 2 | 82551 | 53 | 2.186 | 37763.5 |
| 369 | 2021-04-06 12:12:14 | fanion | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 368 | 2021-03-10 19:20:38 | fanion | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 367 | 2021-02-14 12:06:48 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 366 | 2021-01-16 03:39:04 | fanion | 2 | 82551 | 53 | 2.406 | 34310.5 |
| 365 | 2020-11-03 08:04:22 | fanion | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 364 | 2020-10-27 18:58:30 | fanion | 2 | 82551 | 53 | 2.500 | 33020.4 |
| 363 | 2020-10-24 21:09:21 | fanion | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 362 | 2020-10-17 08:01:05 | fanion | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 361 | 2020-08-28 23:18:34 | fanion | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 360 | 2020-07-29 06:49:07 | fanion | 2 | 82551 | 53 | 2.656 | 31080.9 |
| 359 | 2020-07-28 01:37:40 | fanion | 2 | 82551 | 53 | 2.656 | 31080.9 |
| 358 | 2020-05-23 08:21:11 | fanion | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 357 | 2020-03-30 21:25:00 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 356 | 2020-03-27 19:00:46 | fanion | 1 | 48755 | 5 | 1.810 | 26936.5 |
| 355 | 2020-03-25 10:27:29 | fanion | 1 | 48755 | 5 | 1.703 | 28628.9 |
| 354 | 2020-03-25 09:01:40 | fanion | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 353 | 2020-03-23 06:18:17 | fanion | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 352 | 2020-03-22 09:07:43 | fanion | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 351 | 2020-03-19 23:13:51 | fanion | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 350 | 2020-03-18 22:51:26 | fanion | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 349 | 2020-02-26 12:06:55 | fanion | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 348 | 2020-02-24 19:32:46 | fanion | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 347 | 2020-02-19 10:20:41 | fanion | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 346 | 2020-02-18 18:33:17 | fanion | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 345 | 2020-02-03 02:54:51 | fanion | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 344 | 2020-02-02 11:39:52 | fanion | 1 | 48755 | 5 | 0.950 | 51321.1 |
| 343 | 2020-01-31 14:18:50 | fanion | 1 | 48755 | 5 | 3.033 | 16074.8 |
| 342 | 2020-01-30 06:29:45 | fanion | 1 | 48755 | 5 | 0.966 | 50471.0 |