History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pillow"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 400 | 2024-04-27 09:28:53 | pillow | 1 | 48755 | 5 | 1.110 | 43923.4 |
| 399 | 2024-04-19 01:45:26 | pillow | 3 | 112716 | 377 | 4.690 | 24033.3 |
| 398 | 2024-04-05 02:27:58 | pillow | 2 | 82551 | 41 | 2.923 | 28241.9 |
| 397 | 2024-04-05 02:27:57 | pillow | 1 | 48755 | 5 | 1.763 | 27654.6 |
| 396 | 2024-04-03 16:28:55 | pillow | 2 | 82551 | 41 | 9.000 | 9172.3 |
| 395 | 2024-04-03 16:09:30 | pillow | 3 | 112716 | 377 | 8.220 | 13712.4 |
| 394 | 2024-04-02 22:18:11 | pillow | 3 | 112716 | 377 | 13.190 | 8545.6 |
| 393 | 2024-03-31 20:23:37 | pillow | 3 | 112716 | 377 | 6.830 | 16503.1 |
| 392 | 2024-03-31 20:23:39 | pillow | 2 | 82551 | 41 | 3.046 | 27101.4 |
| 391 | 2024-03-31 20:23:28 | pillow | 3 | 112716 | 377 | 10.706 | 10528.3 |
| 390 | 2024-03-31 20:23:34 | pillow | 1 | 48755 | 5 | 2.326 | 20960.9 |
| 389 | 2024-03-31 20:23:26 | pillow | 2 | 82551 | 41 | 3.826 | 21576.3 |
| 388 | 2024-03-31 20:23:25 | pillow | 1 | 48755 | 5 | 1.810 | 26936.5 |
| 387 | 2024-03-30 18:13:38 | pillow | 1 | 48755 | 5 | 1.983 | 24586.5 |
| 386 | 2024-03-29 16:34:58 | pillow | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 385 | 2024-03-28 18:53:00 | pillow | 1 | 48755 | 5 | 1.906 | 25579.7 |
| 384 | 2024-02-15 00:46:35 | pillow | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 383 | 2024-01-06 06:16:44 | pillow | 3 | 112716 | 377 | 6.000 | 18786.0 |
| 382 | 2024-01-06 06:16:45 | pillow | 2 | 82551 | 41 | 2.593 | 31836.1 |
| 381 | 2023-12-30 15:19:38 | pillow | 3 | 112716 | 377 | 4.956 | 22743.3 |
| 380 | 2023-12-30 15:19:35 | pillow | 2 | 82551 | 41 | 2.500 | 33020.4 |
| 379 | 2023-12-19 03:20:31 | pillow | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 378 | 2023-12-17 10:20:48 | pillow | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 377 | 2023-12-11 13:19:56 | pillow | 3 | 112716 | 377 | 5.063 | 22262.7 |
| 376 | 2023-12-03 09:06:29 | pillow | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 375 | 2023-11-29 23:30:53 | pillow | 1 | 48755 | 5 | 1.750 | 27860.0 |
| 374 | 2023-11-27 23:35:53 | pillow | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 373 | 2023-11-23 08:04:31 | pillow | 1 | 48755 | 5 | 0.800 | 60943.8 |
| 372 | 2023-11-14 03:42:07 | pillow | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 371 | 2023-11-14 03:29:58 | pillow | 1 | 48755 | 5 | 0.753 | 64747.7 |
| 370 | 2023-11-05 19:11:16 | pillow | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 369 | 2023-10-13 22:42:06 | pillow | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 368 | 2023-10-13 22:41:48 | pillow | 2 | 82551 | 41 | 2.373 | 34787.6 |
| 367 | 2023-10-10 11:05:11 | pillow | 3 | 112716 | 377 | 5.576 | 20214.5 |
| 366 | 2023-10-09 09:37:10 | pillow | 3 | 112716 | 377 | 6.843 | 16471.7 |
| 365 | 2023-10-06 03:09:44 | pillow | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 364 | 2023-10-01 08:36:04 | pillow | 3 | 112716 | 377 | 5.750 | 19602.8 |
| 363 | 2023-09-27 05:54:55 | pillow | 2 | 82551 | 41 | 2.596 | 31799.3 |
| 362 | 2023-09-26 18:38:12 | pillow | 3 | 112716 | 377 | 5.750 | 19602.8 |
| 361 | 2023-09-24 21:20:10 | pillow | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 360 | 2023-09-12 19:02:42 | pillow | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 359 | 2023-09-11 09:30:15 | pillow | 3 | 112716 | 377 | 4.733 | 23814.9 |
| 358 | 2023-08-02 21:38:00 | pillow | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 357 | 2023-07-30 14:55:57 | pillow | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 356 | 2023-06-03 22:09:35 | pillow | 3 | 112716 | 377 | 4.576 | 24632.0 |
| 355 | 2023-05-04 19:35:10 | pillow | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 354 | 2023-04-07 15:39:53 | pillow | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 353 | 2023-03-11 15:09:04 | pillow | 3 | 112716 | 377 | 4.626 | 24365.8 |
| 352 | 2023-02-24 17:32:35 | pillow | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 351 | 2022-12-23 05:06:13 | pillow | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 350 | 2022-12-15 12:20:08 | pillow | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 349 | 2022-12-15 04:13:40 | pillow | 3 | 112716 | 377 | 4.576 | 24632.0 |
| 348 | 2022-12-09 16:03:11 | pillow | 3 | 112716 | 377 | 5.563 | 20261.7 |
| 347 | 2022-11-01 09:18:25 | pillow | 3 | 112716 | 377 | 5.406 | 20850.2 |
| 346 | 2022-10-23 13:10:18 | pillow | 3 | 112716 | 377 | 4.673 | 24120.7 |
| 345 | 2022-09-15 19:12:55 | pillow | 3 | 112716 | 377 | 5.813 | 19390.3 |
| 344 | 2022-09-07 10:16:37 | pillow | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 343 | 2022-08-15 08:32:43 | pillow | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 342 | 2022-08-04 21:01:43 | pillow | 3 | 112716 | 377 | 5.346 | 21084.2 |
| 341 | 2022-04-27 07:37:01 | pillow | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 340 | 2022-04-25 03:18:15 | pillow | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 339 | 2022-04-14 15:29:46 | pillow | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 338 | 2022-02-10 21:32:34 | pillow | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 337 | 2022-01-16 11:27:16 | pillow | 1 | 48755 | 5 | 0.970 | 50262.9 |
| 336 | 2022-01-14 06:51:20 | pillow | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 335 | 2022-01-01 06:24:49 | pillow | 1 | 48755 | 5 | 1.140 | 42767.5 |
| 334 | 2021-12-23 15:58:37 | pillow | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 333 | 2021-11-14 07:32:20 | pillow | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 332 | 2021-09-29 21:24:58 | pillow | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 331 | 2021-09-27 19:32:05 | pillow | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 330 | 2021-09-06 18:38:39 | pillow | 1 | 48755 | 5 | 1.500 | 32503.3 |
| 329 | 2021-06-05 18:23:06 | pillow | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 328 | 2021-05-06 21:14:17 | pillow | 1 | 48755 | 5 | 1.090 | 44729.4 |
| 327 | 2021-05-03 10:52:02 | pillow | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 326 | 2021-04-01 16:13:02 | pillow | 1 | 48755 | 5 | 1.736 | 28084.7 |
| 325 | 2021-03-03 15:33:03 | pillow | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 324 | 2020-12-26 01:18:29 | pillow | 2 | 82551 | 41 | 2.140 | 38575.2 |
| 323 | 2020-12-17 14:33:53 | pillow | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 322 | 2020-12-02 23:31:40 | pillow | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 321 | 2020-12-02 13:43:08 | pillow | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 320 | 2020-11-22 00:30:24 | pillow | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 319 | 2020-11-03 13:34:34 | pillow | 2 | 82551 | 41 | 2.563 | 32208.7 |
| 318 | 2020-10-30 21:32:58 | pillow | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 317 | 2020-10-19 09:08:17 | pillow | 1 | 48755 | 5 | 1.500 | 32503.3 |
| 316 | 2020-10-15 10:40:45 | pillow | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 315 | 2020-08-30 11:31:15 | pillow | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 314 | 2020-08-28 08:00:39 | pillow | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 313 | 2020-08-25 08:02:08 | pillow | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 312 | 2020-08-22 07:47:08 | pillow | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 311 | 2020-08-21 22:45:09 | pillow | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 310 | 2020-08-01 04:15:59 | pillow | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 309 | 2020-07-30 10:17:29 | pillow | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 308 | 2020-06-08 16:46:40 | pillow | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 307 | 2020-05-26 17:34:50 | pillow | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 306 | 2020-03-28 03:22:35 | pillow | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 305 | 2020-03-25 21:33:06 | pillow | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 304 | 2020-03-23 20:23:02 | pillow | 1 | 48755 | 5 | 1.016 | 47987.2 |
| 303 | 2020-03-23 08:38:58 | pillow | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 302 | 2020-03-19 22:25:49 | pillow | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 301 | 2020-02-29 14:27:01 | pillow | 3 | 112716 | 377 | 9.266 | 12164.5 |