History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"decaf"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 448 | 2024-04-03 05:33:30 | decaf | 1 | 28756 | 5 | 1.140 | 25224.6 |
| 447 | 2024-04-01 17:30:50 | decaf | 2 | 53800 | 50 | 2.000 | 26900.0 |
| 446 | 2024-03-31 13:58:53 | decaf | 3 | 83667 | 729 | 8.563 | 9770.8 |
| 445 | 2024-03-31 13:58:54 | decaf | 2 | 53800 | 50 | 1.826 | 29463.3 |
| 444 | 2024-03-31 04:20:15 | decaf | 2 | 53800 | 50 | 2.763 | 19471.6 |
| 443 | 2024-03-31 04:20:14 | decaf | 1 | 28756 | 5 | 0.563 | 51076.4 |
| 442 | 2024-03-31 04:19:46 | decaf | 3 | 83667 | 729 | 4.796 | 17445.2 |
| 441 | 2024-03-30 22:23:55 | decaf | 3 | 83667 | 729 | 9.186 | 9108.1 |
| 440 | 2024-03-30 22:23:52 | decaf | 2 | 53800 | 50 | 3.890 | 13830.3 |
| 439 | 2024-03-30 22:10:52 | decaf | 1 | 28756 | 5 | 0.550 | 52283.6 |
| 438 | 2024-03-29 02:36:46 | decaf | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 437 | 2024-03-28 08:49:58 | decaf | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 436 | 2024-02-27 20:16:18 | decaf | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 435 | 2024-01-28 23:11:45 | decaf | 1 | 28756 | 5 | 0.560 | 51350.0 |
| 434 | 2024-01-15 04:14:43 | decaf | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 433 | 2023-12-29 15:29:06 | decaf | 3 | 83667 | 729 | 3.856 | 21697.9 |
| 432 | 2023-12-29 15:29:05 | decaf | 2 | 53800 | 50 | 1.623 | 33148.5 |
| 431 | 2023-12-25 19:53:32 | decaf | 3 | 83667 | 729 | 3.563 | 23482.2 |
| 430 | 2023-12-25 19:53:34 | decaf | 2 | 53800 | 50 | 1.533 | 35094.6 |
| 429 | 2023-11-13 22:53:05 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 428 | 2023-11-12 07:40:22 | decaf | 1 | 28756 | 5 | 1.156 | 24875.4 |
| 427 | 2023-11-11 17:16:30 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 426 | 2023-11-10 13:40:58 | decaf | 1 | 28756 | 5 | 1.030 | 27918.4 |
| 425 | 2023-11-03 08:34:02 | decaf | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 424 | 2023-11-02 08:34:40 | decaf | 1 | 28756 | 5 | 1.030 | 27918.4 |
| 423 | 2023-10-20 07:30:47 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 422 | 2023-10-18 17:45:48 | decaf | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 421 | 2023-10-12 01:00:14 | decaf | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 420 | 2023-10-05 03:38:19 | decaf | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 419 | 2023-09-27 18:45:04 | decaf | 1 | 28756 | 5 | 1.016 | 28303.1 |
| 418 | 2023-09-12 20:50:45 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 417 | 2023-08-31 03:06:55 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 416 | 2023-07-31 04:20:29 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 415 | 2023-06-04 15:36:17 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 414 | 2023-05-01 19:48:31 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 413 | 2023-04-22 19:21:20 | decaf | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 412 | 2023-03-29 09:32:32 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 411 | 2023-03-28 22:56:49 | decaf | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 410 | 2023-01-14 03:48:46 | decaf | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 409 | 2023-01-12 02:01:32 | decaf | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 408 | 2022-11-26 00:26:31 | decaf | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 407 | 2022-10-30 15:07:33 | decaf | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 406 | 2022-09-26 13:33:44 | decaf | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 405 | 2022-06-18 21:00:24 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 404 | 2022-06-09 14:11:35 | decaf | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 403 | 2022-06-05 23:25:00 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 402 | 2022-02-24 04:33:44 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 401 | 2022-02-19 04:46:25 | decaf | 1 | 28756 | 5 | 1.046 | 27491.4 |
| 400 | 2022-01-23 07:36:15 | decaf | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 399 | 2022-01-22 18:47:34 | decaf | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 398 | 2022-01-22 01:21:44 | decaf | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 397 | 2022-01-21 10:52:18 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 396 | 2022-01-21 00:37:19 | decaf | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 395 | 2022-01-20 13:53:28 | decaf | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 394 | 2022-01-20 06:08:42 | decaf | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 393 | 2022-01-19 23:46:25 | decaf | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 392 | 2022-01-19 13:03:17 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 391 | 2022-01-18 21:07:17 | decaf | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 390 | 2022-01-18 10:40:49 | decaf | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 389 | 2022-01-17 21:19:01 | decaf | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 388 | 2022-01-17 15:37:35 | decaf | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 387 | 2022-01-17 00:49:22 | decaf | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 386 | 2022-01-16 09:37:25 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 385 | 2022-01-15 23:58:48 | decaf | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 384 | 2022-01-15 15:07:11 | decaf | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 383 | 2022-01-15 03:58:02 | decaf | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 382 | 2022-01-14 16:11:55 | decaf | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 381 | 2022-01-14 03:36:49 | decaf | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 380 | 2022-01-13 15:31:30 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 379 | 2022-01-02 12:13:32 | decaf | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 378 | 2022-01-01 20:15:10 | decaf | 1 | 28756 | 5 | 0.640 | 44931.3 |
| 377 | 2021-12-19 10:39:45 | decaf | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 376 | 2021-12-18 20:35:43 | decaf | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 375 | 2021-12-13 08:04:31 | decaf | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 374 | 2021-12-11 16:03:56 | decaf | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 373 | 2021-12-11 08:25:19 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 372 | 2021-12-11 07:09:45 | decaf | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 371 | 2021-12-10 21:25:25 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 370 | 2021-12-10 14:14:56 | decaf | 1 | 28756 | 5 | 1.030 | 27918.4 |
| 369 | 2021-12-10 04:05:35 | decaf | 1 | 28756 | 5 | 1.000 | 28756.0 |
| 368 | 2021-12-09 18:20:24 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 367 | 2021-12-09 04:04:10 | decaf | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 366 | 2021-12-08 21:47:37 | decaf | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 365 | 2021-12-08 11:48:14 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 364 | 2021-11-17 20:10:50 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 363 | 2021-11-17 00:37:38 | decaf | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 362 | 2021-11-10 12:16:45 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 361 | 2021-11-08 19:14:47 | decaf | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 360 | 2021-10-20 12:13:56 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 359 | 2021-09-26 07:50:17 | decaf | 3 | 83667 | 729 | 3.233 | 25879.1 |
| 358 | 2021-09-25 12:19:40 | decaf | 3 | 83667 | 729 | 3.966 | 21096.1 |
| 357 | 2021-09-21 20:29:46 | decaf | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 356 | 2021-09-21 03:13:16 | decaf | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 355 | 2021-09-20 21:28:28 | decaf | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 354 | 2021-09-20 08:02:09 | decaf | 3 | 83667 | 729 | 3.673 | 22778.9 |
| 353 | 2021-09-20 04:17:02 | decaf | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 352 | 2021-09-13 18:04:29 | decaf | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 351 | 2021-09-06 01:19:11 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 350 | 2021-08-21 15:00:18 | decaf | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 349 | 2021-08-18 07:20:24 | decaf | 1 | 28756 | 5 | 0.436 | 65954.1 |