History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nectar"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 412 | 2024-05-01 15:05:39 | nectar | 2 | 82551 | 22 | 5.923 | 13937.4 |
| 411 | 2024-05-01 06:12:58 | nectar | 2 | 82551 | 22 | 2.313 | 35690.0 |
| 410 | 2024-05-01 06:12:41 | nectar | 3 | 112716 | 371 | 6.483 | 17386.4 |
| 409 | 2024-04-28 21:52:53 | nectar | 2 | 82551 | 22 | 2.453 | 33653.1 |
| 408 | 2024-04-28 21:48:28 | nectar | 3 | 112716 | 371 | 7.453 | 15123.6 |
| 407 | 2024-04-28 18:26:17 | nectar | 2 | 82551 | 22 | 3.763 | 21937.5 |
| 406 | 2024-04-28 18:26:01 | nectar | 2 | 82551 | 22 | 2.580 | 31996.5 |
| 405 | 2024-04-28 18:25:55 | nectar | 3 | 112716 | 371 | 5.203 | 21663.7 |
| 404 | 2024-04-28 18:25:52 | nectar | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 403 | 2024-04-28 18:25:18 | nectar | 3 | 112716 | 371 | 5.860 | 19234.8 |
| 402 | 2024-04-27 03:29:07 | nectar | 1 | 48755 | 3 | 1.843 | 26454.2 |
| 401 | 2024-04-27 02:34:22 | nectar | 3 | 112716 | 371 | 16.550 | 6810.6 |
| 400 | 2024-04-05 20:28:43 | nectar | 1 | 48755 | 3 | 1.830 | 26642.1 |
| 399 | 2024-03-26 21:02:54 | nectar | 2 | 82551 | 22 | 2.516 | 32810.4 |
| 398 | 2024-03-26 21:02:50 | nectar | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 397 | 2024-03-26 21:02:29 | nectar | 3 | 112716 | 371 | 7.186 | 15685.5 |
| 396 | 2024-03-26 07:13:48 | nectar | 3 | 112716 | 371 | 5.936 | 18988.5 |
| 395 | 2024-03-08 00:48:27 | nectar | 3 | 112716 | 371 | 16.033 | 7030.3 |
| 394 | 2024-03-07 03:10:12 | nectar | 3 | 112716 | 371 | 18.923 | 5956.6 |
| 393 | 2024-03-06 22:54:06 | nectar | 1 | 48755 | 3 | 2.860 | 17047.2 |
| 392 | 2024-03-06 22:06:47 | nectar | 3 | 112716 | 371 | 10.656 | 10577.7 |
| 391 | 2024-03-06 15:23:55 | nectar | 3 | 112716 | 371 | 13.453 | 8378.5 |
| 390 | 2024-03-06 11:03:01 | nectar | 3 | 112716 | 371 | 6.656 | 16934.5 |
| 389 | 2024-02-05 03:51:52 | nectar | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 388 | 2024-02-01 08:37:33 | nectar | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 387 | 2024-01-31 12:30:55 | nectar | 2 | 82551 | 22 | 2.610 | 31628.7 |
| 386 | 2024-01-31 12:29:50 | nectar | 3 | 112716 | 371 | 5.703 | 19764.3 |
| 385 | 2024-01-31 01:25:15 | nectar | 2 | 82551 | 22 | 2.470 | 33421.5 |
| 384 | 2024-01-31 00:26:27 | nectar | 3 | 112716 | 371 | 5.373 | 20978.2 |
| 383 | 2024-01-30 20:51:20 | nectar | 2 | 82551 | 22 | 2.263 | 36478.6 |
| 382 | 2024-01-30 20:46:59 | nectar | 3 | 112716 | 371 | 5.500 | 20493.8 |
| 381 | 2024-01-30 00:16:15 | nectar | 2 | 82551 | 22 | 2.483 | 33246.5 |
| 380 | 2024-01-30 00:15:51 | nectar | 3 | 112716 | 371 | 5.670 | 19879.4 |
| 379 | 2024-01-22 07:46:47 | nectar | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 378 | 2024-01-21 06:52:35 | nectar | 3 | 112716 | 371 | 4.860 | 23192.6 |
| 377 | 2023-12-19 06:37:19 | nectar | 3 | 112716 | 371 | 4.893 | 23036.2 |
| 376 | 2023-12-19 06:37:17 | nectar | 2 | 82551 | 22 | 2.203 | 37472.1 |
| 375 | 2023-12-01 07:23:12 | nectar | 3 | 112716 | 371 | 4.736 | 23799.8 |
| 374 | 2023-11-19 05:38:20 | nectar | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 373 | 2023-11-17 02:58:36 | nectar | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 372 | 2023-11-12 03:19:02 | nectar | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 371 | 2023-11-07 09:29:01 | nectar | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 370 | 2023-11-04 12:47:28 | nectar | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 369 | 2023-11-04 08:47:03 | nectar | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 368 | 2023-10-29 18:42:24 | nectar | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 367 | 2023-10-15 12:12:15 | nectar | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 366 | 2023-09-26 23:44:53 | nectar | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 365 | 2023-09-25 16:27:11 | nectar | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 364 | 2023-09-14 19:26:24 | nectar | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 363 | 2023-09-03 22:53:52 | nectar | 1 | 48755 | 3 | 1.596 | 30548.2 |
| 362 | 2023-08-31 14:11:44 | nectar | 3 | 112716 | 371 | 5.236 | 21527.1 |
| 361 | 2023-08-18 15:16:23 | nectar | 3 | 112716 | 371 | 5.236 | 21527.1 |
| 360 | 2023-05-31 03:43:49 | nectar | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 359 | 2023-05-27 21:19:09 | nectar | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 358 | 2023-05-15 22:46:22 | nectar | 3 | 112716 | 371 | 4.673 | 24120.7 |
| 357 | 2023-03-02 22:24:53 | nectar | 3 | 112716 | 371 | 4.656 | 24208.8 |
| 356 | 2023-03-01 14:59:49 | nectar | 3 | 112716 | 371 | 5.030 | 22408.7 |
| 355 | 2023-02-23 22:46:27 | nectar | 3 | 112716 | 371 | 4.610 | 24450.3 |
| 354 | 2023-02-04 21:01:46 | nectar | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 353 | 2023-02-01 01:31:17 | nectar | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 352 | 2022-12-05 03:49:00 | nectar | 3 | 112716 | 371 | 4.643 | 24276.5 |
| 351 | 2022-12-02 11:46:13 | nectar | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 350 | 2022-10-10 15:05:40 | nectar | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 349 | 2022-07-27 07:47:23 | nectar | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 348 | 2022-07-23 14:44:23 | nectar | 3 | 112716 | 371 | 4.720 | 23880.5 |
| 347 | 2022-07-12 02:02:24 | nectar | 3 | 112716 | 371 | 5.373 | 20978.2 |
| 346 | 2022-06-05 14:17:54 | nectar | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 345 | 2022-06-02 06:42:26 | nectar | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 344 | 2022-03-07 01:09:43 | nectar | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 343 | 2022-03-04 19:34:06 | nectar | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 342 | 2022-02-23 05:45:13 | nectar | 3 | 112716 | 371 | 5.470 | 20606.2 |
| 341 | 2022-01-28 22:06:21 | nectar | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 340 | 2021-12-17 10:53:46 | nectar | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 339 | 2021-11-28 09:06:27 | nectar | 3 | 112716 | 371 | 5.266 | 21404.5 |
| 338 | 2021-11-25 02:02:03 | nectar | 3 | 112716 | 371 | 4.673 | 24120.7 |
| 337 | 2021-11-21 10:17:23 | nectar | 3 | 112716 | 371 | 4.750 | 23729.7 |
| 336 | 2021-11-09 23:47:15 | nectar | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 335 | 2021-10-05 18:06:22 | nectar | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 334 | 2021-07-26 20:18:00 | nectar | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 333 | 2021-07-06 21:25:56 | nectar | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 332 | 2021-07-03 08:11:21 | nectar | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 331 | 2021-05-17 13:15:58 | nectar | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 330 | 2021-04-17 12:35:50 | nectar | 1 | 48755 | 3 | 1.690 | 28849.1 |
| 329 | 2021-03-29 13:49:42 | nectar | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 328 | 2021-03-25 05:28:11 | nectar | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 327 | 2021-03-20 22:26:04 | nectar | 1 | 48755 | 3 | 1.220 | 39963.1 |
| 326 | 2021-03-20 08:57:51 | nectar | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 325 | 2021-01-01 19:07:42 | nectar | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 324 | 2020-12-18 01:04:05 | nectar | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 323 | 2020-11-06 14:27:47 | nectar | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 322 | 2020-10-26 23:02:19 | nectar | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 321 | 2020-10-23 02:28:41 | nectar | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 320 | 2020-10-17 14:06:52 | nectar | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 319 | 2020-09-14 03:13:06 | nectar | 1 | 48755 | 3 | 1.453 | 33554.7 |
| 318 | 2020-09-06 07:37:09 | nectar | 1 | 48755 | 3 | 0.716 | 68093.6 |
| 317 | 2020-08-17 13:58:39 | nectar | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 316 | 2020-08-14 04:49:22 | nectar | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 315 | 2020-07-30 23:16:22 | nectar | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 314 | 2020-05-29 22:32:28 | nectar | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 313 | 2020-05-11 14:03:42 | nectar | 1 | 48755 | 3 | 0.846 | 57630.0 |