History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"boater"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
463 | 2024-04-18 10:51:04 | boater | 2 | 82551 | 198 | 4.283 | 19274.1 |
462 | 2024-04-18 10:50:34 | boater | 1 | 48755 | 10 | 2.610 | 18680.1 |
461 | 2024-04-18 10:50:17 | boater | 2 | 82551 | 198 | 5.766 | 14316.9 |
460 | 2024-04-18 10:50:08 | boater | 1 | 48755 | 10 | 1.156 | 42175.6 |
459 | 2024-04-11 15:49:48 | boater | 2 | 82551 | 198 | 2.170 | 38041.9 |
458 | 2024-04-10 09:58:27 | boater | 1 | 48755 | 10 | 2.466 | 19770.9 |
457 | 2024-04-08 14:52:54 | boater | 1 | 48755 | 10 | 0.953 | 51159.5 |
456 | 2024-03-18 07:48:12 | boater | 1 | 48755 | 10 | 0.830 | 58741.0 |
455 | 2024-03-08 18:05:36 | boater | 2 | 82551 | 198 | 5.876 | 14048.8 |
454 | 2024-03-07 23:23:45 | boater | 2 | 82551 | 198 | 2.673 | 30883.3 |
453 | 2024-03-07 07:35:38 | boater | 2 | 82551 | 198 | 7.640 | 10805.1 |
452 | 2024-03-07 01:37:29 | boater | 1 | 48755 | 10 | 0.893 | 54596.9 |
451 | 2024-02-28 06:51:22 | boater | 1 | 48755 | 10 | 2.610 | 18680.1 |
450 | 2024-02-26 21:32:13 | boater | 1 | 48755 | 10 | 0.813 | 59969.2 |
449 | 2024-02-14 18:38:08 | boater | 1 | 48755 | 10 | 1.970 | 24748.7 |
448 | 2024-01-20 05:17:43 | boater | 2 | 82551 | 198 | 2.300 | 35891.7 |
447 | 2024-01-15 05:13:20 | boater | 1 | 48755 | 10 | 0.856 | 56956.8 |
446 | 2024-01-12 08:13:42 | boater | 2 | 82551 | 198 | 2.343 | 35233.0 |
445 | 2023-12-30 13:15:16 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
444 | 2023-12-10 02:20:46 | boater | 2 | 82551 | 198 | 2.486 | 33206.4 |
443 | 2023-12-04 23:08:42 | boater | 2 | 82551 | 198 | 2.310 | 35736.4 |
442 | 2023-11-17 16:36:29 | boater | 1 | 48755 | 10 | 0.843 | 57835.1 |
441 | 2023-11-15 17:37:50 | boater | 1 | 48755 | 10 | 0.826 | 59025.4 |
440 | 2023-11-05 18:26:49 | boater | 1 | 48755 | 10 | 0.813 | 59969.2 |
439 | 2023-10-29 11:24:01 | boater | 1 | 48755 | 10 | 0.843 | 57835.1 |
438 | 2023-10-22 19:19:35 | boater | 1 | 48755 | 10 | 0.846 | 57630.0 |
437 | 2023-10-19 20:50:16 | boater | 1 | 48755 | 10 | 0.843 | 57835.1 |
436 | 2023-10-18 13:41:25 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
435 | 2023-10-13 16:38:32 | boater | 1 | 48755 | 10 | 0.813 | 59969.2 |
434 | 2023-10-12 06:57:33 | boater | 2 | 82551 | 198 | 2.500 | 33020.4 |
433 | 2023-10-10 06:38:12 | boater | 2 | 82551 | 198 | 2.516 | 32810.4 |
432 | 2023-10-04 04:57:14 | boater | 1 | 48755 | 10 | 0.826 | 59025.4 |
431 | 2023-09-25 13:33:37 | boater | 1 | 48755 | 10 | 0.876 | 55656.4 |
430 | 2023-09-14 07:50:02 | boater | 1 | 48755 | 10 | 0.906 | 53813.5 |
429 | 2023-09-11 11:13:52 | boater | 2 | 82551 | 198 | 5.563 | 14839.3 |
428 | 2023-09-06 03:14:21 | boater | 2 | 82551 | 198 | 2.203 | 37472.1 |
427 | 2023-08-15 05:07:08 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
426 | 2023-07-13 07:32:17 | boater | 1 | 48755 | 10 | 0.796 | 61250.0 |
425 | 2023-05-24 12:25:34 | boater | 2 | 82551 | 198 | 2.170 | 38041.9 |
424 | 2023-05-16 22:01:21 | boater | 1 | 48755 | 10 | 0.736 | 66243.2 |
423 | 2023-04-27 23:02:02 | boater | 2 | 82551 | 198 | 2.140 | 38575.2 |
422 | 2023-04-22 03:38:02 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
421 | 2023-04-01 23:32:20 | boater | 1 | 48755 | 10 | 0.733 | 66514.3 |
420 | 2023-03-31 17:08:50 | boater | 2 | 82551 | 198 | 2.593 | 31836.1 |
419 | 2023-03-18 15:23:58 | boater | 1 | 48755 | 10 | 0.780 | 62506.4 |
418 | 2023-03-10 08:34:40 | boater | 1 | 48755 | 10 | 0.736 | 66243.2 |
417 | 2023-03-03 11:44:01 | boater | 2 | 82551 | 198 | 2.106 | 39198.0 |
416 | 2022-12-31 14:32:46 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
415 | 2022-12-24 02:27:14 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
414 | 2022-12-11 01:15:03 | boater | 2 | 82551 | 198 | 3.656 | 22579.6 |
413 | 2022-09-21 20:11:09 | boater | 1 | 48755 | 10 | 0.766 | 63648.8 |
412 | 2022-09-09 19:55:28 | boater | 1 | 48755 | 10 | 0.783 | 62266.9 |
411 | 2022-07-27 13:39:31 | boater | 2 | 82551 | 198 | 2.436 | 33887.9 |
410 | 2022-05-21 15:15:57 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
409 | 2022-05-18 05:19:42 | boater | 1 | 48755 | 10 | 0.763 | 63899.1 |
408 | 2022-05-03 06:22:44 | boater | 1 | 48755 | 10 | 0.796 | 61250.0 |
407 | 2022-05-01 02:14:55 | boater | 1 | 48755 | 10 | 0.766 | 63648.8 |
406 | 2022-03-05 00:59:04 | boater | 2 | 82551 | 198 | 2.186 | 37763.5 |
405 | 2022-02-09 22:50:34 | boater | 1 | 48755 | 10 | 0.813 | 59969.2 |
404 | 2022-02-02 03:52:43 | boater | 1 | 48755 | 10 | 0.763 | 63899.1 |
403 | 2021-11-09 01:05:01 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
402 | 2021-10-30 07:38:40 | boater | 1 | 48755 | 10 | 0.826 | 59025.4 |
401 | 2021-09-16 11:26:11 | boater | 1 | 48755 | 10 | 0.846 | 57630.0 |
400 | 2021-08-27 18:01:16 | boater | 1 | 48755 | 10 | 0.983 | 49598.2 |
399 | 2021-08-25 13:56:28 | boater | 1 | 48755 | 10 | 0.876 | 55656.4 |
398 | 2021-08-09 10:53:37 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
397 | 2021-07-11 09:17:13 | boater | 1 | 48755 | 10 | 0.860 | 56691.9 |
396 | 2021-05-26 10:22:03 | boater | 1 | 48755 | 10 | 0.813 | 59969.2 |
395 | 2021-04-29 14:42:23 | boater | 1 | 48755 | 10 | 1.016 | 47987.2 |
394 | 2021-04-28 03:50:12 | boater | 1 | 48755 | 10 | 0.873 | 55847.7 |
393 | 2021-03-29 03:56:31 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
392 | 2021-02-16 23:29:34 | boater | 1 | 48755 | 10 | 0.890 | 54780.9 |
391 | 2021-02-07 04:52:43 | boater | 1 | 48755 | 10 | 0.843 | 57835.1 |
390 | 2021-02-04 12:05:41 | boater | 1 | 48755 | 10 | 0.906 | 53813.5 |
389 | 2021-01-23 13:08:43 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
388 | 2021-01-12 21:52:31 | boater | 1 | 48755 | 10 | 0.763 | 63899.1 |
387 | 2020-11-18 12:20:29 | boater | 2 | 82551 | 198 | 2.660 | 31034.2 |
386 | 2020-10-21 16:49:32 | boater | 1 | 48755 | 10 | 1.720 | 28345.9 |
385 | 2020-10-17 17:31:46 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
384 | 2020-09-30 06:54:45 | boater | 1 | 48755 | 10 | 0.750 | 65006.7 |
383 | 2020-08-09 02:39:32 | boater | 1 | 48755 | 10 | 0.766 | 63648.8 |
382 | 2020-07-24 06:47:43 | boater | 1 | 48755 | 10 | 0.830 | 58741.0 |
381 | 2020-07-19 18:06:38 | boater | 1 | 48755 | 10 | 0.906 | 53813.5 |
380 | 2020-05-10 01:31:47 | boater | 1 | 48755 | 10 | 0.860 | 56691.9 |
379 | 2020-04-17 19:41:09 | boater | 1 | 48755 | 10 | 0.796 | 61250.0 |
378 | 2020-03-27 23:38:42 | boater | 1 | 48755 | 10 | 1.030 | 47335.0 |
377 | 2020-03-25 04:05:00 | boater | 1 | 48755 | 10 | 0.780 | 62506.4 |
376 | 2020-03-25 00:18:21 | boater | 1 | 48755 | 10 | 0.890 | 54780.9 |
375 | 2020-03-23 16:40:08 | boater | 1 | 48755 | 10 | 0.766 | 63648.8 |
374 | 2020-03-22 18:07:58 | boater | 1 | 48755 | 10 | 0.953 | 51159.5 |
373 | 2020-03-19 20:14:01 | boater | 1 | 48755 | 10 | 0.843 | 57835.1 |
372 | 2020-03-18 21:54:07 | boater | 1 | 48755 | 10 | 0.813 | 59969.2 |
371 | 2020-02-26 11:49:39 | boater | 1 | 48755 | 10 | 0.796 | 61250.0 |
370 | 2020-02-23 21:51:16 | boater | 1 | 48755 | 10 | 0.873 | 55847.7 |
369 | 2020-02-23 15:59:53 | boater | 1 | 48755 | 10 | 0.826 | 59025.4 |
368 | 2020-02-23 14:18:12 | boater | 1 | 48755 | 10 | 1.003 | 48609.2 |
367 | 2020-02-22 13:29:26 | boater | 1 | 48755 | 10 | 1.000 | 48755.0 |
366 | 2020-02-22 07:33:28 | boater | 1 | 48755 | 10 | 0.890 | 54780.9 |
365 | 2020-02-09 21:31:08 | boater | 1 | 48755 | 10 | 0.940 | 51867.0 |
364 | 2020-02-03 06:35:25 | boater | 1 | 48755 | 10 | 1.140 | 42767.5 |