History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fruits"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 422 | 2024-04-28 01:23:51 | fruits | 1 | 48755 | 5 | 1.796 | 27146.4 |
| 421 | 2024-04-27 11:44:42 | fruits | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 420 | 2024-04-27 10:47:52 | fruits | 1 | 48755 | 5 | 1.796 | 27146.4 |
| 419 | 2024-04-03 10:43:57 | fruits | 1 | 48755 | 5 | 1.533 | 31803.7 |
| 418 | 2024-03-30 19:35:01 | fruits | 3 | 112716 | 814 | 10.703 | 10531.3 |
| 417 | 2024-03-30 01:29:37 | fruits | 3 | 112716 | 814 | 12.343 | 9132.0 |
| 416 | 2024-03-29 10:02:44 | fruits | 3 | 112716 | 814 | 6.266 | 17988.5 |
| 415 | 2024-03-29 10:02:43 | fruits | 2 | 82551 | 60 | 8.156 | 10121.5 |
| 414 | 2024-03-29 10:02:33 | fruits | 3 | 112716 | 814 | 8.810 | 12794.1 |
| 413 | 2024-03-29 10:02:38 | fruits | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 412 | 2024-03-29 10:02:31 | fruits | 2 | 82551 | 60 | 2.763 | 29877.3 |
| 411 | 2024-03-29 10:02:31 | fruits | 1 | 48755 | 5 | 1.813 | 26891.9 |
| 410 | 2024-03-04 00:26:11 | fruits | 1 | 48755 | 5 | 2.843 | 17149.1 |
| 409 | 2024-01-27 03:25:40 | fruits | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 408 | 2023-12-22 19:30:06 | fruits | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 407 | 2023-12-06 23:56:02 | fruits | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 406 | 2023-12-06 23:56:01 | fruits | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 405 | 2023-11-23 18:50:26 | fruits | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 404 | 2023-11-22 07:44:52 | fruits | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 403 | 2023-11-19 19:05:02 | fruits | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 402 | 2023-11-13 22:45:37 | fruits | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 401 | 2023-10-31 09:38:24 | fruits | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 400 | 2023-10-22 18:42:02 | fruits | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 399 | 2023-10-13 23:16:29 | fruits | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 398 | 2023-10-05 05:30:26 | fruits | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 397 | 2023-09-26 07:23:42 | fruits | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 396 | 2023-09-13 16:45:58 | fruits | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 395 | 2023-09-09 02:25:39 | fruits | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 394 | 2023-09-02 16:27:20 | fruits | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 393 | 2023-06-19 04:09:09 | fruits | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 392 | 2023-05-16 21:54:05 | fruits | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 391 | 2023-04-24 01:43:01 | fruits | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 390 | 2023-04-02 21:47:48 | fruits | 1 | 48755 | 5 | 1.643 | 29674.4 |
| 389 | 2023-01-27 12:06:35 | fruits | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 388 | 2023-01-15 15:50:18 | fruits | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 387 | 2022-11-14 04:52:34 | fruits | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 386 | 2022-10-09 12:40:24 | fruits | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 385 | 2022-09-01 07:25:23 | fruits | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 384 | 2022-08-23 11:57:19 | fruits | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 383 | 2022-07-29 12:50:33 | fruits | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 382 | 2022-07-24 20:40:38 | fruits | 3 | 112716 | 814 | 4.753 | 23714.7 |
| 381 | 2022-07-17 21:29:23 | fruits | 3 | 112716 | 814 | 4.533 | 24865.7 |
| 380 | 2022-07-04 11:22:04 | fruits | 1 | 48755 | 5 | 1.030 | 47335.0 |
| 379 | 2022-06-22 21:54:54 | fruits | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 378 | 2022-05-19 12:54:26 | fruits | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 377 | 2022-03-10 08:12:47 | fruits | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 376 | 2022-03-07 02:41:01 | fruits | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 375 | 2021-12-15 11:14:35 | fruits | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 374 | 2021-12-13 09:17:06 | fruits | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 373 | 2021-11-26 15:06:01 | fruits | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 372 | 2021-10-22 15:38:30 | fruits | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 371 | 2021-09-10 13:52:35 | fruits | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 370 | 2021-08-26 03:07:46 | fruits | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 369 | 2021-08-20 07:54:54 | fruits | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 368 | 2021-07-08 01:26:14 | fruits | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 367 | 2021-06-28 09:38:26 | fruits | 3 | 112716 | 814 | 5.623 | 20045.5 |
| 366 | 2021-05-19 15:25:49 | fruits | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 365 | 2021-04-23 05:57:51 | fruits | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 364 | 2021-04-01 19:33:26 | fruits | 3 | 112716 | 814 | 5.390 | 20912.1 |
| 363 | 2021-03-27 18:27:13 | fruits | 3 | 112716 | 814 | 6.330 | 17806.6 |
| 362 | 2021-03-25 10:03:41 | fruits | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 361 | 2021-03-23 09:43:03 | fruits | 3 | 112716 | 814 | 5.236 | 21527.1 |
| 360 | 2021-03-17 02:42:41 | fruits | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 359 | 2021-02-16 18:03:20 | fruits | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 358 | 2021-02-10 10:17:39 | fruits | 3 | 112716 | 814 | 4.690 | 24033.3 |
| 357 | 2021-01-08 12:08:22 | fruits | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 356 | 2020-12-20 07:27:15 | fruits | 3 | 112716 | 814 | 5.406 | 20850.2 |
| 355 | 2020-12-01 18:36:56 | fruits | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 354 | 2020-11-12 11:56:34 | fruits | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 353 | 2020-10-28 23:50:40 | fruits | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 352 | 2020-10-22 04:28:12 | fruits | 1 | 48755 | 5 | 1.513 | 32224.1 |
| 351 | 2020-10-21 04:22:39 | fruits | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 350 | 2020-10-10 05:49:13 | fruits | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 349 | 2020-08-18 18:35:14 | fruits | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 348 | 2020-08-05 22:47:27 | fruits | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 347 | 2020-08-05 19:17:26 | fruits | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 346 | 2020-05-26 13:54:38 | fruits | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 345 | 2020-05-04 11:19:42 | fruits | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 344 | 2020-03-30 02:00:41 | fruits | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 343 | 2020-03-28 04:57:26 | fruits | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 342 | 2020-03-26 17:38:35 | fruits | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 341 | 2020-03-24 03:34:31 | fruits | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 340 | 2020-03-22 09:35:49 | fruits | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 339 | 2020-03-20 02:01:07 | fruits | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 338 | 2020-03-02 10:33:03 | fruits | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 337 | 2020-02-27 15:01:40 | fruits | 1 | 48755 | 5 | 0.966 | 50471.0 |
| 336 | 2020-02-19 11:42:24 | fruits | 1 | 48755 | 5 | 1.826 | 26700.4 |
| 335 | 2020-02-19 10:43:25 | fruits | 3 | 112716 | 814 | 10.813 | 10424.1 |
| 334 | 2020-02-13 15:52:16 | fruits | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 333 | 2020-02-07 05:23:03 | fruits | 3 | 112716 | 814 | 6.033 | 18683.2 |
| 332 | 2020-02-06 23:09:51 | fruits | 3 | 112716 | 814 | 9.486 | 11882.4 |
| 331 | 2020-02-06 21:05:25 | fruits | 3 | 112716 | 814 | 7.296 | 15449.0 |
| 330 | 2020-02-06 11:11:31 | fruits | 3 | 112716 | 814 | 5.123 | 22002.0 |
| 329 | 2020-02-06 09:10:50 | fruits | 3 | 112716 | 814 | 5.953 | 18934.3 |
| 328 | 2020-02-06 08:21:15 | fruits | 3 | 112716 | 814 | 5.970 | 18880.4 |
| 327 | 2020-02-05 23:04:43 | fruits | 3 | 112716 | 814 | 7.080 | 15920.3 |
| 326 | 2020-02-05 13:30:59 | fruits | 1 | 48755 | 5 | 0.970 | 50262.9 |
| 325 | 2020-02-04 09:03:14 | fruits | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 324 | 2020-02-03 14:56:23 | fruits | 1 | 48755 | 5 | 1.720 | 28345.9 |
| 323 | 2020-02-02 05:58:26 | fruits | 1 | 48755 | 5 | 0.890 | 54780.9 |