History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ocean"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
477 | 2024-04-22 10:59:03 | ocean | 1 | 28756 | 3 | 2.126 | 13525.9 |
476 | 2024-04-19 11:43:05 | ocean | 1 | 28756 | 3 | 1.423 | 20208.0 |
475 | 2024-04-06 05:43:17 | ocean | 1 | 28756 | 3 | 0.516 | 55728.7 |
474 | 2024-03-31 16:14:56 | ocean | 1 | 28756 | 3 | 0.486 | 59168.7 |
473 | 2024-03-29 09:26:27 | ocean | 1 | 28756 | 3 | 0.516 | 55728.7 |
472 | 2024-03-07 07:49:34 | ocean | 3 | 83667 | 835 | 7.733 | 10819.5 |
471 | 2024-03-07 07:49:36 | ocean | 2 | 53800 | 49 | 3.736 | 14400.4 |
470 | 2024-03-07 04:23:21 | ocean | 1 | 28756 | 3 | 1.156 | 24875.4 |
469 | 2024-03-01 11:49:09 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
468 | 2024-02-28 11:30:44 | ocean | 2 | 53800 | 49 | 1.623 | 33148.5 |
467 | 2024-02-28 04:54:39 | ocean | 2 | 53800 | 49 | 3.330 | 16156.2 |
466 | 2024-02-28 04:51:29 | ocean | 3 | 83667 | 835 | 5.703 | 14670.7 |
465 | 2024-02-28 04:21:26 | ocean | 3 | 83667 | 835 | 5.596 | 14951.2 |
464 | 2024-02-28 03:06:20 | ocean | 3 | 83667 | 835 | 5.826 | 14361.0 |
463 | 2024-02-28 03:06:20 | ocean | 2 | 53800 | 49 | 1.703 | 31591.3 |
462 | 2024-02-28 03:06:16 | ocean | 1 | 28756 | 3 | 0.563 | 51076.4 |
461 | 2024-02-22 03:09:10 | ocean | 1 | 28756 | 3 | 0.513 | 56054.6 |
460 | 2024-02-03 19:31:31 | ocean | 1 | 28756 | 3 | 0.500 | 57512.0 |
459 | 2024-01-29 06:03:35 | ocean | 1 | 28756 | 3 | 0.466 | 61708.2 |
458 | 2024-01-29 03:01:45 | ocean | 1 | 28756 | 3 | 0.486 | 59168.7 |
457 | 2024-01-21 08:45:44 | ocean | 3 | 83667 | 835 | 3.420 | 24464.0 |
456 | 2024-01-21 08:45:45 | ocean | 2 | 53800 | 49 | 1.516 | 35488.1 |
455 | 2024-01-12 09:54:37 | ocean | 3 | 83667 | 835 | 3.733 | 22412.8 |
454 | 2024-01-07 23:38:12 | ocean | 1 | 28756 | 3 | 0.500 | 57512.0 |
453 | 2023-12-31 04:39:48 | ocean | 3 | 83667 | 835 | 3.376 | 24782.9 |
452 | 2023-12-31 04:39:45 | ocean | 2 | 53800 | 49 | 1.513 | 35558.5 |
451 | 2023-12-26 02:45:05 | ocean | 3 | 83667 | 835 | 5.783 | 14467.8 |
450 | 2023-11-21 10:06:45 | ocean | 2 | 53800 | 49 | 1.453 | 37026.8 |
449 | 2023-11-19 05:41:44 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
448 | 2023-11-18 10:17:01 | ocean | 1 | 28756 | 3 | 0.500 | 57512.0 |
447 | 2023-11-13 11:46:05 | ocean | 1 | 28756 | 3 | 0.486 | 59168.7 |
446 | 2023-11-03 13:54:26 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
445 | 2023-10-30 02:07:14 | ocean | 3 | 83667 | 835 | 4.453 | 18788.9 |
444 | 2023-10-24 16:40:43 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
443 | 2023-10-24 03:34:49 | ocean | 3 | 83667 | 835 | 7.970 | 10497.7 |
442 | 2023-10-21 18:25:26 | ocean | 1 | 28756 | 3 | 0.516 | 55728.7 |
441 | 2023-10-20 01:15:27 | ocean | 3 | 83667 | 835 | 7.046 | 11874.4 |
440 | 2023-10-18 09:53:32 | ocean | 1 | 28756 | 3 | 0.530 | 54256.6 |
439 | 2023-10-14 20:59:52 | ocean | 1 | 28756 | 3 | 0.516 | 55728.7 |
438 | 2023-10-05 22:28:20 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
437 | 2023-09-28 00:21:44 | ocean | 1 | 28756 | 3 | 0.483 | 59536.2 |
436 | 2023-09-14 02:42:57 | ocean | 1 | 28756 | 3 | 0.483 | 59536.2 |
435 | 2023-07-30 20:03:58 | ocean | 3 | 83667 | 835 | 3.936 | 21256.9 |
434 | 2023-07-04 00:55:13 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
433 | 2023-04-10 08:27:48 | ocean | 3 | 83667 | 835 | 3.450 | 24251.3 |
432 | 2023-03-14 03:27:10 | ocean | 1 | 28756 | 3 | 0.483 | 59536.2 |
431 | 2023-03-10 19:50:38 | ocean | 1 | 28756 | 3 | 0.483 | 59536.2 |
430 | 2023-01-17 11:20:13 | ocean | 3 | 83667 | 835 | 3.233 | 25879.1 |
429 | 2022-11-19 02:47:44 | ocean | 1 | 28756 | 3 | 0.423 | 67981.1 |
428 | 2022-10-28 08:51:36 | ocean | 3 | 83667 | 835 | 3.640 | 22985.4 |
427 | 2022-09-19 17:46:07 | ocean | 1 | 28756 | 3 | 0.453 | 63479.0 |
426 | 2022-09-18 13:14:11 | ocean | 1 | 28756 | 3 | 0.420 | 68466.7 |
425 | 2022-09-17 21:08:42 | ocean | 1 | 28756 | 3 | 0.483 | 59536.2 |
424 | 2022-09-10 15:27:29 | ocean | 1 | 28756 | 3 | 0.500 | 57512.0 |
423 | 2022-08-31 03:23:34 | ocean | 1 | 28756 | 3 | 0.440 | 65354.5 |
422 | 2022-08-15 00:12:53 | ocean | 1 | 28756 | 3 | 0.516 | 55728.7 |
421 | 2022-07-26 08:55:22 | ocean | 1 | 28756 | 3 | 0.486 | 59168.7 |
420 | 2022-07-22 16:57:58 | ocean | 1 | 28756 | 3 | 1.093 | 26309.2 |
419 | 2022-07-10 04:10:11 | ocean | 1 | 28756 | 3 | 0.453 | 63479.0 |
418 | 2022-07-02 15:52:22 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
417 | 2022-05-27 22:44:43 | ocean | 3 | 83667 | 835 | 3.330 | 25125.2 |
416 | 2022-04-27 14:29:18 | ocean | 1 | 28756 | 3 | 0.486 | 59168.7 |
415 | 2022-04-23 03:34:07 | ocean | 1 | 28756 | 3 | 0.703 | 40904.7 |
414 | 2022-03-31 20:58:18 | ocean | 1 | 28756 | 3 | 0.500 | 57512.0 |
413 | 2022-01-16 17:05:23 | ocean | 1 | 28756 | 3 | 0.453 | 63479.0 |
412 | 2021-12-17 08:26:17 | ocean | 1 | 28756 | 3 | 0.516 | 55728.7 |
411 | 2021-11-14 14:07:08 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
410 | 2021-10-02 07:24:18 | ocean | 1 | 28756 | 3 | 0.483 | 59536.2 |
409 | 2021-09-06 20:48:18 | ocean | 1 | 28756 | 3 | 0.500 | 57512.0 |
408 | 2021-09-04 08:26:39 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
407 | 2021-09-02 02:07:54 | ocean | 1 | 28756 | 3 | 0.453 | 63479.0 |
406 | 2021-08-17 19:03:12 | ocean | 1 | 28756 | 3 | 0.440 | 65354.5 |
405 | 2021-08-15 15:00:49 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
404 | 2021-06-05 20:41:52 | ocean | 1 | 28756 | 3 | 0.970 | 29645.4 |
403 | 2021-06-02 16:50:40 | ocean | 1 | 28756 | 3 | 0.516 | 55728.7 |
402 | 2021-05-19 01:12:38 | ocean | 2 | 53800 | 49 | 1.483 | 36277.8 |
401 | 2021-04-18 23:30:11 | ocean | 2 | 53800 | 49 | 1.393 | 38621.7 |
400 | 2021-02-28 02:38:33 | ocean | 1 | 28756 | 3 | 0.423 | 67981.1 |
399 | 2021-02-20 12:50:53 | ocean | 1 | 28756 | 3 | 0.483 | 59536.2 |
398 | 2021-01-31 10:04:07 | ocean | 2 | 53800 | 49 | 1.390 | 38705.0 |
397 | 2020-11-23 12:56:58 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
396 | 2020-11-16 17:27:16 | ocean | 1 | 28756 | 3 | 0.453 | 63479.0 |
395 | 2020-11-10 01:48:28 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
394 | 2020-11-06 17:31:23 | ocean | 1 | 28756 | 3 | 0.470 | 61183.0 |
393 | 2020-10-25 03:25:38 | ocean | 1 | 28756 | 3 | 0.483 | 59536.2 |
392 | 2020-10-20 18:05:48 | ocean | 1 | 28756 | 3 | 0.486 | 59168.7 |
391 | 2020-10-15 15:41:59 | ocean | 1 | 28756 | 3 | 0.500 | 57512.0 |
390 | 2020-09-10 01:04:11 | ocean | 1 | 28756 | 3 | 0.423 | 67981.1 |
389 | 2020-08-22 01:42:28 | ocean | 1 | 28756 | 3 | 0.436 | 65954.1 |
388 | 2020-07-28 04:57:26 | ocean | 1 | 28756 | 3 | 0.453 | 63479.0 |
387 | 2020-07-21 20:51:57 | ocean | 1 | 28756 | 3 | 0.546 | 52666.7 |
386 | 2020-07-20 17:40:17 | ocean | 1 | 28756 | 3 | 0.576 | 49923.6 |
385 | 2020-05-20 18:08:11 | ocean | 1 | 28756 | 3 | 0.453 | 63479.0 |
384 | 2020-03-29 13:03:11 | ocean | 3 | 83667 | 835 | 5.406 | 15476.7 |
383 | 2020-03-27 15:31:40 | ocean | 3 | 83667 | 835 | 4.220 | 19826.3 |
382 | 2020-03-27 03:10:06 | ocean | 1 | 28756 | 3 | 0.860 | 33437.2 |
381 | 2020-03-26 04:43:06 | ocean | 3 | 83667 | 835 | 3.843 | 21771.3 |
380 | 2020-03-25 01:34:54 | ocean | 1 | 28756 | 3 | 0.513 | 56054.6 |
379 | 2020-03-24 12:15:24 | ocean | 3 | 83667 | 835 | 5.940 | 14085.4 |
378 | 2020-03-23 10:12:35 | ocean | 1 | 28756 | 3 | 0.513 | 56054.6 |