History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pippin"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 417 | 2024-04-28 06:41:33 | pippin | 1 | 48755 | 4 | 1.856 | 26268.9 |
| 416 | 2024-04-19 17:39:11 | pippin | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 415 | 2024-03-31 19:20:06 | pippin | 3 | 112716 | 360 | 8.360 | 13482.8 |
| 414 | 2024-03-31 19:20:08 | pippin | 2 | 82551 | 37 | 6.500 | 12700.2 |
| 413 | 2024-03-29 20:22:13 | pippin | 2 | 82551 | 37 | 2.720 | 30349.6 |
| 412 | 2024-03-29 20:21:27 | pippin | 3 | 112716 | 360 | 6.220 | 18121.5 |
| 411 | 2024-03-29 06:24:08 | pippin | 3 | 112716 | 360 | 18.690 | 6030.8 |
| 410 | 2024-03-29 06:18:06 | pippin | 3 | 112716 | 360 | 20.703 | 5444.4 |
| 409 | 2024-03-29 06:18:07 | pippin | 2 | 82551 | 37 | 8.436 | 9785.6 |
| 408 | 2024-03-29 06:17:59 | pippin | 1 | 48755 | 4 | 2.173 | 22436.7 |
| 407 | 2024-02-28 12:10:40 | pippin | 2 | 82551 | 37 | 2.546 | 32423.8 |
| 406 | 2024-02-28 12:10:25 | pippin | 3 | 112716 | 360 | 5.783 | 19490.9 |
| 405 | 2024-02-27 11:50:38 | pippin | 2 | 82551 | 37 | 2.453 | 33653.1 |
| 404 | 2024-02-27 11:50:22 | pippin | 3 | 112716 | 360 | 5.936 | 18988.5 |
| 403 | 2024-02-25 19:58:15 | pippin | 2 | 82551 | 37 | 8.453 | 9765.9 |
| 402 | 2024-02-25 19:58:15 | pippin | 3 | 112716 | 360 | 6.453 | 17467.2 |
| 401 | 2024-02-25 19:57:50 | pippin | 1 | 48755 | 4 | 13.000 | 3750.4 |
| 400 | 2024-02-12 05:58:35 | pippin | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 399 | 2024-01-14 02:00:32 | pippin | 3 | 112716 | 360 | 5.500 | 20493.8 |
| 398 | 2024-01-10 12:27:35 | pippin | 3 | 112716 | 360 | 4.610 | 24450.3 |
| 397 | 2024-01-10 12:27:32 | pippin | 2 | 82551 | 37 | 2.360 | 34979.2 |
| 396 | 2024-01-06 07:12:46 | pippin | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 395 | 2023-12-25 20:41:22 | pippin | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 394 | 2023-12-22 18:54:52 | pippin | 3 | 112716 | 360 | 4.953 | 22757.1 |
| 393 | 2023-12-14 17:41:42 | pippin | 3 | 112716 | 360 | 10.813 | 10424.1 |
| 392 | 2023-11-17 15:06:26 | pippin | 1 | 48755 | 4 | 1.000 | 48755.0 |
| 391 | 2023-11-03 05:45:00 | pippin | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 390 | 2023-10-26 07:42:43 | pippin | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 389 | 2023-10-23 12:39:25 | pippin | 3 | 112716 | 360 | 5.670 | 19879.4 |
| 388 | 2023-10-18 00:24:29 | pippin | 1 | 48755 | 4 | 0.936 | 52088.7 |
| 387 | 2023-10-15 18:27:23 | pippin | 1 | 48755 | 4 | 1.656 | 29441.4 |
| 386 | 2023-10-06 20:49:41 | pippin | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 385 | 2023-10-06 14:30:36 | pippin | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 384 | 2023-09-26 08:16:07 | pippin | 1 | 48755 | 4 | 0.810 | 60191.4 |
| 383 | 2023-09-22 06:08:36 | pippin | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 382 | 2023-08-22 10:35:50 | pippin | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 381 | 2023-08-03 12:07:50 | pippin | 3 | 112716 | 360 | 5.610 | 20092.0 |
| 380 | 2023-06-29 04:32:58 | pippin | 3 | 112716 | 360 | 4.720 | 23880.5 |
| 379 | 2023-06-09 20:48:02 | pippin | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 378 | 2023-05-24 20:12:18 | pippin | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 377 | 2023-04-13 02:24:36 | pippin | 3 | 112716 | 360 | 4.516 | 24959.3 |
| 376 | 2023-03-19 21:11:55 | pippin | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 375 | 2023-02-07 23:38:51 | pippin | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 374 | 2023-01-17 15:46:18 | pippin | 3 | 112716 | 360 | 4.483 | 25143.0 |
| 373 | 2023-01-16 08:44:49 | pippin | 3 | 112716 | 360 | 5.126 | 21989.1 |
| 372 | 2023-01-12 16:00:23 | pippin | 3 | 112716 | 360 | 5.030 | 22408.7 |
| 371 | 2023-01-07 04:28:09 | pippin | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 370 | 2022-12-03 08:43:09 | pippin | 3 | 112716 | 360 | 4.500 | 25048.0 |
| 369 | 2022-10-27 19:07:34 | pippin | 3 | 112716 | 360 | 4.466 | 25238.7 |
| 368 | 2022-10-06 20:42:23 | pippin | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 367 | 2022-10-06 15:09:31 | pippin | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 366 | 2022-10-03 06:36:05 | pippin | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 365 | 2022-09-30 12:55:33 | pippin | 3 | 112716 | 360 | 5.126 | 21989.1 |
| 364 | 2022-09-04 15:45:34 | pippin | 3 | 112716 | 360 | 5.330 | 21147.5 |
| 363 | 2022-08-21 04:40:18 | pippin | 3 | 112716 | 360 | 4.640 | 24292.2 |
| 362 | 2022-08-19 15:46:23 | pippin | 3 | 112716 | 360 | 4.890 | 23050.3 |
| 361 | 2022-07-30 19:18:44 | pippin | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 360 | 2022-06-05 10:33:40 | pippin | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 359 | 2022-06-02 03:56:04 | pippin | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 358 | 2022-05-29 17:46:27 | pippin | 3 | 112716 | 360 | 5.096 | 22118.5 |
| 357 | 2022-05-24 03:42:19 | pippin | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 356 | 2022-03-23 09:46:14 | pippin | 3 | 112716 | 360 | 5.263 | 21416.7 |
| 355 | 2022-03-20 14:10:24 | pippin | 3 | 112716 | 360 | 5.343 | 21096.0 |
| 354 | 2022-03-17 03:37:46 | pippin | 3 | 112716 | 360 | 4.873 | 23130.7 |
| 353 | 2022-02-05 12:57:42 | pippin | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 352 | 2022-02-04 00:39:21 | pippin | 3 | 112716 | 360 | 5.796 | 19447.2 |
| 351 | 2022-01-28 18:46:32 | pippin | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 350 | 2022-01-27 00:36:19 | pippin | 3 | 112716 | 360 | 7.580 | 14870.2 |
| 349 | 2022-01-08 07:27:19 | pippin | 3 | 112716 | 360 | 5.500 | 20493.8 |
| 348 | 2021-12-31 04:48:12 | pippin | 3 | 112716 | 360 | 6.313 | 17854.6 |
| 347 | 2021-12-30 06:27:06 | pippin | 3 | 112716 | 360 | 5.796 | 19447.2 |
| 346 | 2021-12-29 05:20:37 | pippin | 3 | 112716 | 360 | 10.436 | 10800.7 |
| 345 | 2021-12-28 07:04:56 | pippin | 3 | 112716 | 360 | 5.533 | 20371.6 |
| 344 | 2021-12-27 05:31:59 | pippin | 3 | 112716 | 360 | 5.986 | 18829.9 |
| 343 | 2021-12-26 06:11:59 | pippin | 3 | 112716 | 360 | 9.063 | 12436.9 |
| 342 | 2021-12-25 06:14:20 | pippin | 3 | 112716 | 360 | 6.486 | 17378.4 |
| 341 | 2021-12-24 02:27:52 | pippin | 3 | 112716 | 360 | 5.923 | 19030.2 |
| 340 | 2021-11-29 10:00:54 | pippin | 1 | 48755 | 4 | 0.873 | 55847.7 |
| 339 | 2021-11-23 15:58:39 | pippin | 3 | 112716 | 360 | 4.610 | 24450.3 |
| 338 | 2021-11-15 18:08:48 | pippin | 3 | 112716 | 360 | 4.703 | 23966.8 |
| 337 | 2021-11-15 04:48:13 | pippin | 3 | 112716 | 360 | 4.936 | 22835.5 |
| 336 | 2021-11-14 18:18:29 | pippin | 3 | 112716 | 360 | 4.780 | 23580.8 |
| 335 | 2021-11-14 03:42:37 | pippin | 3 | 112716 | 360 | 5.263 | 21416.7 |
| 334 | 2021-11-13 19:02:47 | pippin | 3 | 112716 | 360 | 4.516 | 24959.3 |
| 333 | 2021-11-13 05:04:15 | pippin | 3 | 112716 | 360 | 4.656 | 24208.8 |
| 332 | 2021-11-12 19:01:36 | pippin | 3 | 112716 | 360 | 8.530 | 13214.1 |
| 331 | 2021-11-11 21:54:18 | pippin | 3 | 112716 | 360 | 5.843 | 19290.8 |
| 330 | 2021-11-11 11:01:01 | pippin | 3 | 112716 | 360 | 5.640 | 19985.1 |
| 329 | 2021-11-11 09:03:47 | pippin | 3 | 112716 | 360 | 5.376 | 20966.5 |
| 328 | 2021-11-11 01:04:42 | pippin | 3 | 112716 | 360 | 7.216 | 15620.3 |
| 327 | 2021-11-10 09:02:45 | pippin | 3 | 112716 | 360 | 10.750 | 10485.2 |
| 326 | 2021-11-09 21:01:00 | pippin | 3 | 112716 | 360 | 5.626 | 20034.8 |
| 325 | 2021-11-09 09:03:12 | pippin | 3 | 112716 | 360 | 5.643 | 19974.5 |
| 324 | 2021-11-07 20:18:13 | pippin | 3 | 112716 | 360 | 5.580 | 20200.0 |
| 323 | 2021-11-05 22:49:32 | pippin | 3 | 112716 | 360 | 5.453 | 20670.5 |
| 322 | 2021-10-31 09:39:41 | pippin | 1 | 48755 | 4 | 1.393 | 35000.0 |
| 321 | 2021-10-30 14:09:19 | pippin | 3 | 112716 | 360 | 4.563 | 24702.2 |
| 320 | 2021-10-30 03:09:24 | pippin | 3 | 112716 | 360 | 4.626 | 24365.8 |
| 319 | 2021-10-29 09:29:27 | pippin | 3 | 112716 | 360 | 4.626 | 24365.8 |
| 318 | 2021-10-29 02:07:26 | pippin | 3 | 112716 | 360 | 4.656 | 24208.8 |