History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gaffer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 435 | 2024-04-26 15:50:07 | gaffer | 1 | 48755 | 8 | 0.893 | 54596.9 |
| 434 | 2024-04-03 09:46:53 | gaffer | 1 | 48755 | 8 | 2.470 | 19738.9 |
| 433 | 2024-03-30 19:36:41 | gaffer | 3 | 112716 | 849 | 6.716 | 16783.2 |
| 432 | 2024-03-29 19:34:56 | gaffer | 3 | 112716 | 849 | 10.423 | 10814.2 |
| 431 | 2024-03-27 20:13:46 | gaffer | 3 | 112716 | 849 | 10.703 | 10531.3 |
| 430 | 2024-03-26 13:06:28 | gaffer | 3 | 112716 | 849 | 5.893 | 19127.1 |
| 429 | 2024-03-08 22:12:00 | gaffer | 1 | 48755 | 8 | 0.906 | 53813.5 |
| 428 | 2024-02-29 08:25:13 | gaffer | 1 | 48755 | 8 | 0.966 | 50471.0 |
| 427 | 2024-02-28 09:08:20 | gaffer | 1 | 48755 | 8 | 2.813 | 17332.0 |
| 426 | 2024-01-07 03:45:34 | gaffer | 3 | 112716 | 849 | 5.483 | 20557.4 |
| 425 | 2024-01-07 03:45:35 | gaffer | 2 | 82551 | 78 | 2.640 | 31269.3 |
| 424 | 2024-01-04 03:36:00 | gaffer | 1 | 48755 | 8 | 0.953 | 51159.5 |
| 423 | 2023-12-20 23:48:06 | gaffer | 2 | 82551 | 78 | 2.123 | 38884.1 |
| 422 | 2023-12-09 09:42:38 | gaffer | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 421 | 2023-12-03 11:54:16 | gaffer | 1 | 48755 | 8 | 0.763 | 63899.1 |
| 420 | 2023-11-30 01:31:31 | gaffer | 3 | 112716 | 849 | 5.296 | 21283.2 |
| 419 | 2023-11-24 11:37:48 | gaffer | 1 | 48755 | 8 | 1.016 | 47987.2 |
| 418 | 2023-11-15 10:18:28 | gaffer | 1 | 48755 | 8 | 0.763 | 63899.1 |
| 417 | 2023-11-05 21:07:08 | gaffer | 1 | 48755 | 8 | 0.810 | 60191.4 |
| 416 | 2023-10-24 09:48:28 | gaffer | 1 | 48755 | 8 | 0.893 | 54596.9 |
| 415 | 2023-10-24 03:37:02 | gaffer | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 414 | 2023-10-18 04:56:05 | gaffer | 1 | 48755 | 8 | 0.826 | 59025.4 |
| 413 | 2023-10-15 00:21:37 | gaffer | 1 | 48755 | 8 | 0.830 | 58741.0 |
| 412 | 2023-10-08 01:53:26 | gaffer | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 411 | 2023-10-04 11:14:58 | gaffer | 3 | 112716 | 849 | 13.440 | 8386.6 |
| 410 | 2023-09-29 18:28:04 | gaffer | 3 | 112716 | 849 | 5.436 | 20735.1 |
| 409 | 2023-09-28 03:29:59 | gaffer | 2 | 82551 | 78 | 2.656 | 31080.9 |
| 408 | 2023-09-26 00:57:37 | gaffer | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 407 | 2023-09-22 02:17:32 | gaffer | 2 | 82551 | 78 | 2.470 | 33421.5 |
| 406 | 2023-09-16 12:54:29 | gaffer | 1 | 48755 | 8 | 0.813 | 59969.2 |
| 405 | 2023-08-29 05:45:40 | gaffer | 3 | 112716 | 849 | 5.373 | 20978.2 |
| 404 | 2023-08-27 00:46:13 | gaffer | 1 | 48755 | 8 | 0.856 | 56956.8 |
| 403 | 2023-08-21 04:32:15 | gaffer | 1 | 48755 | 8 | 0.830 | 58741.0 |
| 402 | 2023-08-20 01:50:56 | gaffer | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 401 | 2023-06-30 19:10:21 | gaffer | 2 | 82551 | 78 | 2.500 | 33020.4 |
| 400 | 2023-05-31 21:20:40 | gaffer | 3 | 112716 | 849 | 4.640 | 24292.2 |
| 399 | 2023-05-29 12:21:02 | gaffer | 2 | 82551 | 78 | 2.220 | 37185.1 |
| 398 | 2023-05-21 22:07:59 | gaffer | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 397 | 2023-05-20 07:22:34 | gaffer | 1 | 48755 | 8 | 0.736 | 66243.2 |
| 396 | 2023-05-19 17:23:59 | gaffer | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 395 | 2023-05-17 04:08:15 | gaffer | 3 | 112716 | 849 | 4.703 | 23966.8 |
| 394 | 2023-04-11 16:12:45 | gaffer | 2 | 82551 | 78 | 2.076 | 39764.5 |
| 393 | 2023-03-23 05:52:57 | gaffer | 2 | 82551 | 78 | 2.093 | 39441.5 |
| 392 | 2023-03-17 11:38:50 | gaffer | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 391 | 2023-02-24 11:55:27 | gaffer | 3 | 112716 | 849 | 5.173 | 21789.3 |
| 390 | 2023-02-12 17:06:01 | gaffer | 1 | 48755 | 8 | 0.733 | 66514.3 |
| 389 | 2023-02-07 01:24:54 | gaffer | 1 | 48755 | 8 | 0.860 | 56691.9 |
| 388 | 2023-01-05 10:15:41 | gaffer | 1 | 48755 | 8 | 0.736 | 66243.2 |
| 387 | 2022-12-22 09:52:06 | gaffer | 2 | 82551 | 78 | 2.093 | 39441.5 |
| 386 | 2022-12-05 18:00:50 | gaffer | 3 | 112716 | 849 | 4.686 | 24053.8 |
| 385 | 2022-11-29 18:53:45 | gaffer | 3 | 112716 | 849 | 4.830 | 23336.6 |
| 384 | 2022-11-14 10:35:19 | gaffer | 1 | 48755 | 8 | 1.030 | 47335.0 |
| 383 | 2022-11-11 02:37:06 | gaffer | 2 | 82551 | 78 | 2.140 | 38575.2 |
| 382 | 2022-11-10 19:56:42 | gaffer | 1 | 48755 | 8 | 0.780 | 62506.4 |
| 381 | 2022-11-02 05:29:09 | gaffer | 3 | 112716 | 849 | 4.576 | 24632.0 |
| 380 | 2022-10-27 17:59:05 | gaffer | 1 | 48755 | 8 | 0.733 | 66514.3 |
| 379 | 2022-10-24 04:34:18 | gaffer | 1 | 48755 | 8 | 0.733 | 66514.3 |
| 378 | 2022-10-24 00:43:16 | gaffer | 3 | 112716 | 849 | 4.550 | 24772.7 |
| 377 | 2022-10-01 23:55:33 | gaffer | 1 | 48755 | 8 | 0.796 | 61250.0 |
| 376 | 2022-10-01 21:40:49 | gaffer | 1 | 48755 | 8 | 0.780 | 62506.4 |
| 375 | 2022-09-28 12:08:41 | gaffer | 2 | 82551 | 78 | 2.156 | 38289.0 |
| 374 | 2022-09-01 21:03:15 | gaffer | 3 | 112716 | 849 | 4.890 | 23050.3 |
| 373 | 2022-08-16 05:50:47 | gaffer | 2 | 82551 | 78 | 2.140 | 38575.2 |
| 372 | 2022-08-09 04:56:06 | gaffer | 1 | 48755 | 8 | 0.763 | 63899.1 |
| 371 | 2022-07-21 16:38:58 | gaffer | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 370 | 2022-07-17 23:22:08 | gaffer | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 369 | 2022-07-17 14:03:26 | gaffer | 3 | 112716 | 849 | 4.703 | 23966.8 |
| 368 | 2022-06-16 04:17:34 | gaffer | 3 | 112716 | 849 | 4.563 | 24702.2 |
| 367 | 2022-06-10 00:35:39 | gaffer | 3 | 112716 | 849 | 4.606 | 24471.6 |
| 366 | 2022-05-18 15:49:46 | gaffer | 1 | 48755 | 8 | 0.733 | 66514.3 |
| 365 | 2022-05-14 11:26:23 | gaffer | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 364 | 2022-05-12 07:21:12 | gaffer | 1 | 48755 | 8 | 0.800 | 60943.8 |
| 363 | 2022-05-08 22:23:43 | gaffer | 3 | 112716 | 849 | 4.656 | 24208.8 |
| 362 | 2022-05-08 12:01:26 | gaffer | 1 | 48755 | 8 | 0.753 | 64747.7 |
| 361 | 2022-04-10 05:56:40 | gaffer | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 360 | 2022-04-04 14:39:54 | gaffer | 3 | 112716 | 849 | 5.763 | 19558.6 |
| 359 | 2022-02-28 01:32:13 | gaffer | 3 | 112716 | 849 | 4.656 | 24208.8 |
| 358 | 2022-02-26 10:58:49 | gaffer | 3 | 112716 | 849 | 4.736 | 23799.8 |
| 357 | 2022-02-21 12:07:39 | gaffer | 3 | 112716 | 849 | 5.063 | 22262.7 |
| 356 | 2022-02-03 12:45:56 | gaffer | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 355 | 2022-01-24 19:14:43 | gaffer | 1 | 48755 | 8 | 1.546 | 31536.2 |
| 354 | 2022-01-07 18:58:47 | gaffer | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 353 | 2021-11-18 03:49:20 | gaffer | 1 | 48755 | 8 | 1.000 | 48755.0 |
| 352 | 2021-11-11 12:42:07 | gaffer | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 351 | 2021-10-31 15:44:00 | gaffer | 1 | 48755 | 8 | 0.736 | 66243.2 |
| 350 | 2021-10-08 00:17:52 | gaffer | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 349 | 2021-10-05 23:11:03 | gaffer | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 348 | 2021-10-04 19:20:18 | gaffer | 1 | 48755 | 8 | 1.720 | 28345.9 |
| 347 | 2021-09-14 15:33:43 | gaffer | 1 | 48755 | 8 | 0.830 | 58741.0 |
| 346 | 2021-07-29 14:13:17 | gaffer | 1 | 48755 | 8 | 0.830 | 58741.0 |
| 345 | 2021-07-23 15:31:46 | gaffer | 2 | 82551 | 78 | 2.360 | 34979.2 |
| 344 | 2021-07-08 17:19:07 | gaffer | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 343 | 2021-07-02 06:28:37 | gaffer | 1 | 48755 | 8 | 0.763 | 63899.1 |
| 342 | 2021-06-28 20:24:38 | gaffer | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 341 | 2021-05-26 10:03:55 | gaffer | 1 | 48755 | 8 | 1.813 | 26891.9 |
| 340 | 2021-05-17 12:50:57 | gaffer | 1 | 48755 | 8 | 0.763 | 63899.1 |
| 339 | 2021-05-13 10:37:20 | gaffer | 2 | 82551 | 78 | 4.046 | 20403.1 |
| 338 | 2021-04-24 16:32:04 | gaffer | 1 | 48755 | 8 | 0.873 | 55847.7 |
| 337 | 2021-04-24 03:49:08 | gaffer | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 336 | 2021-04-19 23:12:03 | gaffer | 3 | 112716 | 849 | 5.466 | 20621.3 |