History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spells"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 404 | 2024-04-27 12:16:23 | spells | 1 | 48755 | 13 | 2.016 | 24184.0 |
| 403 | 2024-04-22 20:01:32 | spells | 1 | 48755 | 13 | 0.873 | 55847.7 |
| 402 | 2024-04-03 10:24:14 | spells | 1 | 48755 | 13 | 2.893 | 16852.7 |
| 401 | 2024-03-30 20:51:10 | spells | 1 | 48755 | 13 | 0.906 | 53813.5 |
| 400 | 2024-03-04 08:43:10 | spells | 1 | 48755 | 13 | 1.986 | 24549.3 |
| 399 | 2024-02-28 04:54:10 | spells | 1 | 48755 | 13 | 2.873 | 16970.1 |
| 398 | 2024-02-14 21:36:52 | spells | 1 | 48755 | 13 | 1.140 | 42767.5 |
| 397 | 2024-01-29 07:37:29 | spells | 1 | 48755 | 13 | 0.733 | 66514.3 |
| 396 | 2024-01-21 17:20:46 | spells | 1 | 48755 | 13 | 0.780 | 62506.4 |
| 395 | 2023-12-26 21:31:10 | spells | 2 | 82551 | 102 | 2.546 | 32423.8 |
| 394 | 2023-11-30 05:35:25 | spells | 1 | 48755 | 13 | 0.873 | 55847.7 |
| 393 | 2023-11-29 12:11:46 | spells | 1 | 48755 | 13 | 0.796 | 61250.0 |
| 392 | 2023-11-18 19:41:36 | spells | 2 | 82551 | 102 | 2.156 | 38289.0 |
| 391 | 2023-11-18 05:44:13 | spells | 1 | 48755 | 13 | 0.860 | 56691.9 |
| 390 | 2023-11-08 16:34:28 | spells | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 389 | 2023-11-03 21:10:45 | spells | 1 | 48755 | 13 | 0.890 | 54780.9 |
| 388 | 2023-10-30 05:47:21 | spells | 1 | 48755 | 13 | 0.840 | 58041.7 |
| 387 | 2023-10-28 12:40:04 | spells | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 386 | 2023-10-11 21:39:14 | spells | 1 | 48755 | 13 | 0.903 | 53992.2 |
| 385 | 2023-09-26 20:23:43 | spells | 1 | 48755 | 13 | 0.796 | 61250.0 |
| 384 | 2023-09-14 12:28:10 | spells | 1 | 48755 | 13 | 0.860 | 56691.9 |
| 383 | 2023-09-04 18:54:53 | spells | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 382 | 2023-07-27 02:46:28 | spells | 1 | 48755 | 13 | 0.813 | 59969.2 |
| 381 | 2023-06-13 07:38:34 | spells | 1 | 48755 | 13 | 0.873 | 55847.7 |
| 380 | 2023-04-01 18:59:46 | spells | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 379 | 2023-03-31 10:36:11 | spells | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 378 | 2023-01-14 13:38:30 | spells | 1 | 48755 | 13 | 0.843 | 57835.1 |
| 377 | 2022-12-09 08:03:50 | spells | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 376 | 2022-11-05 13:55:57 | spells | 1 | 48755 | 13 | 0.826 | 59025.4 |
| 375 | 2022-09-03 18:04:02 | spells | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 374 | 2022-08-28 20:52:51 | spells | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 373 | 2022-08-18 13:31:20 | spells | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 372 | 2022-08-05 21:29:13 | spells | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 371 | 2022-07-26 06:52:52 | spells | 1 | 48755 | 13 | 1.843 | 26454.2 |
| 370 | 2022-06-25 09:23:58 | spells | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 369 | 2022-05-21 22:39:18 | spells | 1 | 48755 | 13 | 0.763 | 63899.1 |
| 368 | 2022-04-27 14:33:20 | spells | 1 | 48755 | 13 | 0.860 | 56691.9 |
| 367 | 2022-04-04 12:03:39 | spells | 1 | 48755 | 13 | 1.033 | 47197.5 |
| 366 | 2022-03-01 21:13:35 | spells | 1 | 48755 | 13 | 0.860 | 56691.9 |
| 365 | 2022-02-28 21:41:26 | spells | 1 | 48755 | 13 | 0.966 | 50471.0 |
| 364 | 2022-02-27 22:15:13 | spells | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 363 | 2022-02-26 23:55:44 | spells | 1 | 48755 | 13 | 0.890 | 54780.9 |
| 362 | 2022-02-25 16:23:15 | spells | 1 | 48755 | 13 | 0.783 | 62266.9 |
| 361 | 2022-02-13 05:31:36 | spells | 1 | 48755 | 13 | 0.970 | 50262.9 |
| 360 | 2021-12-17 12:07:43 | spells | 1 | 48755 | 13 | 0.890 | 54780.9 |
| 359 | 2021-12-08 04:34:09 | spells | 1 | 48755 | 13 | 1.720 | 28345.9 |
| 358 | 2021-12-07 17:13:42 | spells | 1 | 48755 | 13 | 1.126 | 43299.3 |
| 357 | 2021-12-07 07:47:27 | spells | 1 | 48755 | 13 | 1.516 | 32160.3 |
| 356 | 2021-12-06 20:50:02 | spells | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 355 | 2021-12-06 20:48:14 | spells | 1 | 48755 | 13 | 0.826 | 59025.4 |
| 354 | 2021-12-06 01:18:33 | spells | 1 | 48755 | 13 | 0.890 | 54780.9 |
| 353 | 2021-12-05 14:09:52 | spells | 1 | 48755 | 13 | 1.716 | 28412.0 |
| 352 | 2021-12-04 18:16:18 | spells | 1 | 48755 | 13 | 0.860 | 56691.9 |
| 351 | 2021-12-02 08:15:00 | spells | 1 | 48755 | 13 | 0.796 | 61250.0 |
| 350 | 2021-12-01 20:48:52 | spells | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 349 | 2021-12-01 09:27:06 | spells | 1 | 48755 | 13 | 0.873 | 55847.7 |
| 348 | 2021-12-01 02:38:46 | spells | 1 | 48755 | 13 | 0.970 | 50262.9 |
| 347 | 2021-11-30 19:26:46 | spells | 1 | 48755 | 13 | 0.876 | 55656.4 |
| 346 | 2021-11-30 07:41:26 | spells | 1 | 48755 | 13 | 0.890 | 54780.9 |
| 345 | 2021-11-29 16:07:06 | spells | 1 | 48755 | 13 | 0.890 | 54780.9 |
| 344 | 2021-11-29 05:03:21 | spells | 1 | 48755 | 13 | 0.810 | 60191.4 |
| 343 | 2021-10-21 14:47:25 | spells | 1 | 48755 | 13 | 0.906 | 53813.5 |
| 342 | 2021-10-20 17:13:36 | spells | 1 | 48755 | 13 | 0.856 | 56956.8 |
| 341 | 2021-10-20 09:16:05 | spells | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 340 | 2021-09-26 11:50:00 | spells | 2 | 82551 | 102 | 2.390 | 34540.2 |
| 339 | 2021-09-25 23:17:20 | spells | 2 | 82551 | 102 | 2.093 | 39441.5 |
| 338 | 2021-09-25 09:56:09 | spells | 2 | 82551 | 102 | 2.203 | 37472.1 |
| 337 | 2021-09-21 00:56:29 | spells | 1 | 48755 | 13 | 0.843 | 57835.1 |
| 336 | 2021-09-20 07:44:30 | spells | 1 | 48755 | 13 | 0.873 | 55847.7 |
| 335 | 2021-09-19 23:36:02 | spells | 2 | 82551 | 102 | 2.160 | 38218.1 |
| 334 | 2021-09-19 23:33:00 | spells | 1 | 48755 | 13 | 0.860 | 56691.9 |
| 333 | 2021-09-13 07:28:42 | spells | 1 | 48755 | 13 | 1.580 | 30857.6 |
| 332 | 2021-09-12 11:20:01 | spells | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 331 | 2021-09-07 00:43:50 | spells | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 330 | 2021-08-23 17:22:48 | spells | 1 | 48755 | 13 | 0.796 | 61250.0 |
| 329 | 2021-06-06 01:10:17 | spells | 1 | 48755 | 13 | 0.843 | 57835.1 |
| 328 | 2021-06-02 20:34:45 | spells | 1 | 48755 | 13 | 0.843 | 57835.1 |
| 327 | 2021-05-29 00:02:06 | spells | 2 | 82551 | 102 | 2.156 | 38289.0 |
| 326 | 2021-05-03 07:36:44 | spells | 2 | 82551 | 102 | 2.750 | 30018.5 |
| 325 | 2021-02-28 07:48:21 | spells | 1 | 48755 | 13 | 0.843 | 57835.1 |
| 324 | 2021-02-04 15:24:00 | spells | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 323 | 2021-01-16 16:31:32 | spells | 2 | 82551 | 102 | 2.123 | 38884.1 |
| 322 | 2020-11-23 18:23:18 | spells | 1 | 48755 | 13 | 0.826 | 59025.4 |
| 321 | 2020-10-27 10:00:53 | spells | 2 | 82551 | 102 | 2.623 | 31472.0 |
| 320 | 2020-10-23 10:13:54 | spells | 1 | 48755 | 13 | 0.783 | 62266.9 |
| 319 | 2020-10-21 04:30:12 | spells | 1 | 48755 | 13 | 0.843 | 57835.1 |
| 318 | 2020-09-13 03:08:15 | spells | 1 | 48755 | 13 | 0.780 | 62506.4 |
| 317 | 2020-08-15 22:07:35 | spells | 1 | 48755 | 13 | 0.780 | 62506.4 |
| 316 | 2020-08-09 13:51:19 | spells | 1 | 48755 | 13 | 0.780 | 62506.4 |
| 315 | 2020-08-02 22:48:26 | spells | 1 | 48755 | 13 | 0.846 | 57630.0 |
| 314 | 2020-07-25 03:44:10 | spells | 1 | 48755 | 13 | 0.890 | 54780.9 |
| 313 | 2020-05-14 15:03:32 | spells | 1 | 48755 | 13 | 0.936 | 52088.7 |
| 312 | 2020-05-11 07:35:26 | spells | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 311 | 2020-03-28 08:40:34 | spells | 1 | 48755 | 13 | 0.923 | 52822.3 |
| 310 | 2020-03-24 03:59:09 | spells | 1 | 48755 | 13 | 0.893 | 54596.9 |
| 309 | 2020-03-23 00:04:12 | spells | 1 | 48755 | 13 | 0.893 | 54596.9 |
| 308 | 2020-03-19 21:17:56 | spells | 1 | 48755 | 13 | 1.376 | 35432.4 |
| 307 | 2020-02-22 22:55:43 | spells | 1 | 48755 | 13 | 2.013 | 24220.1 |
| 306 | 2020-02-21 02:42:37 | spells | 1 | 48755 | 13 | 0.873 | 55847.7 |
| 305 | 2020-02-12 20:38:35 | spells | 1 | 48755 | 13 | 3.016 | 16165.5 |