History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hiker"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
490 | 2024-04-08 16:29:02 | hiker | 1 | 28756 | 12 | 1.690 | 17015.4 |
489 | 2024-04-02 20:30:00 | hiker | 1 | 28756 | 12 | 0.580 | 49579.3 |
488 | 2024-03-31 07:12:34 | hiker | 2 | 53800 | 228 | 4.580 | 11746.7 |
487 | 2024-03-31 07:10:41 | hiker | 1 | 28756 | 12 | 1.656 | 17364.7 |
486 | 2024-03-28 19:56:03 | hiker | 1 | 28756 | 12 | 0.546 | 52666.7 |
485 | 2024-03-28 19:55:51 | hiker | 2 | 53800 | 228 | 1.640 | 32804.9 |
484 | 2024-03-28 18:57:54 | hiker | 2 | 53800 | 228 | 3.140 | 17133.8 |
483 | 2024-03-28 18:10:02 | hiker | 1 | 28756 | 12 | 0.986 | 29164.3 |
482 | 2024-03-08 03:59:07 | hiker | 1 | 28756 | 12 | 0.563 | 51076.4 |
481 | 2024-03-03 18:56:00 | hiker | 1 | 28756 | 12 | 1.156 | 24875.4 |
480 | 2024-03-01 09:32:52 | hiker | 1 | 28756 | 12 | 1.110 | 25906.3 |
479 | 2024-02-26 08:44:31 | hiker | 1 | 28756 | 12 | 0.546 | 52666.7 |
478 | 2024-02-16 05:45:13 | hiker | 1 | 28756 | 12 | 0.500 | 57512.0 |
477 | 2024-02-06 02:38:34 | hiker | 2 | 53800 | 228 | 1.596 | 33709.3 |
476 | 2024-02-06 02:38:30 | hiker | 1 | 28756 | 12 | 0.486 | 59168.7 |
475 | 2024-01-28 17:19:16 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
474 | 2024-01-27 05:23:57 | hiker | 1 | 28756 | 12 | 0.530 | 54256.6 |
473 | 2024-01-07 01:48:28 | hiker | 1 | 28756 | 12 | 0.500 | 57512.0 |
472 | 2024-01-02 12:17:50 | hiker | 1 | 28756 | 12 | 0.546 | 52666.7 |
471 | 2023-12-25 04:13:16 | hiker | 1 | 28756 | 12 | 0.486 | 59168.7 |
470 | 2023-12-17 05:53:46 | hiker | 2 | 53800 | 228 | 1.360 | 39558.8 |
469 | 2023-12-15 07:09:30 | hiker | 2 | 53800 | 228 | 1.546 | 34799.5 |
468 | 2023-12-13 23:29:09 | hiker | 2 | 53800 | 228 | 1.533 | 35094.6 |
467 | 2023-11-30 23:39:35 | hiker | 1 | 28756 | 12 | 0.453 | 63479.0 |
466 | 2023-11-19 22:28:57 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
465 | 2023-11-16 06:35:39 | hiker | 2 | 53800 | 228 | 1.546 | 34799.5 |
464 | 2023-11-11 11:58:12 | hiker | 1 | 28756 | 12 | 0.516 | 55728.7 |
463 | 2023-11-11 08:40:30 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
462 | 2023-10-29 05:43:59 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
461 | 2023-10-21 11:06:30 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
460 | 2023-10-18 15:55:55 | hiker | 1 | 28756 | 12 | 0.513 | 56054.6 |
459 | 2023-10-16 07:39:56 | hiker | 1 | 28756 | 12 | 0.470 | 61183.0 |
458 | 2023-10-05 05:01:54 | hiker | 1 | 28756 | 12 | 0.546 | 52666.7 |
457 | 2023-09-23 07:43:16 | hiker | 1 | 28756 | 12 | 0.420 | 68466.7 |
456 | 2023-09-14 23:48:53 | hiker | 1 | 28756 | 12 | 0.500 | 57512.0 |
455 | 2023-09-12 02:27:52 | hiker | 1 | 28756 | 12 | 0.453 | 63479.0 |
454 | 2023-08-29 14:34:16 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
453 | 2023-08-26 00:43:31 | hiker | 1 | 28756 | 12 | 0.466 | 61708.2 |
452 | 2023-06-26 11:55:32 | hiker | 1 | 28756 | 12 | 0.423 | 67981.1 |
451 | 2023-05-08 21:07:04 | hiker | 1 | 28756 | 12 | 0.423 | 67981.1 |
450 | 2023-04-07 11:38:49 | hiker | 1 | 28756 | 12 | 0.486 | 59168.7 |
449 | 2023-01-26 13:49:41 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
448 | 2023-01-21 21:48:17 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
447 | 2022-11-17 15:08:06 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
446 | 2022-10-12 06:31:07 | hiker | 1 | 28756 | 12 | 0.440 | 65354.5 |
445 | 2022-09-20 00:56:49 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
444 | 2022-08-14 21:14:13 | hiker | 1 | 28756 | 12 | 0.420 | 68466.7 |
443 | 2022-07-31 23:07:38 | hiker | 1 | 28756 | 12 | 0.420 | 68466.7 |
442 | 2022-07-29 05:26:00 | hiker | 1 | 28756 | 12 | 0.453 | 63479.0 |
441 | 2022-07-08 08:45:14 | hiker | 1 | 28756 | 12 | 0.546 | 52666.7 |
440 | 2022-06-21 22:57:43 | hiker | 1 | 28756 | 12 | 0.423 | 67981.1 |
439 | 2022-06-17 00:13:03 | hiker | 1 | 28756 | 12 | 0.466 | 61708.2 |
438 | 2022-06-14 07:09:25 | hiker | 1 | 28756 | 12 | 0.453 | 63479.0 |
437 | 2022-06-09 22:13:09 | hiker | 1 | 28756 | 12 | 0.516 | 55728.7 |
436 | 2022-05-18 10:27:24 | hiker | 1 | 28756 | 12 | 0.466 | 61708.2 |
435 | 2022-03-15 08:10:51 | hiker | 1 | 28756 | 12 | 0.470 | 61183.0 |
434 | 2022-03-06 03:05:50 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
433 | 2021-12-25 13:53:11 | hiker | 1 | 28756 | 12 | 0.530 | 54256.6 |
432 | 2021-11-25 19:24:16 | hiker | 1 | 28756 | 12 | 1.000 | 28756.0 |
431 | 2021-11-11 21:18:23 | hiker | 1 | 28756 | 12 | 0.453 | 63479.0 |
430 | 2021-10-30 08:55:40 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
429 | 2021-09-10 03:22:37 | hiker | 1 | 28756 | 12 | 0.440 | 65354.5 |
428 | 2021-09-07 22:12:14 | hiker | 1 | 28756 | 12 | 0.500 | 57512.0 |
427 | 2021-08-22 21:56:37 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
426 | 2021-08-19 02:58:05 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
425 | 2021-05-22 01:42:20 | hiker | 1 | 28756 | 12 | 0.516 | 55728.7 |
424 | 2021-05-18 18:11:42 | hiker | 1 | 28756 | 12 | 0.530 | 54256.6 |
423 | 2021-05-16 16:01:58 | hiker | 1 | 28756 | 12 | 0.516 | 55728.7 |
422 | 2021-04-16 09:23:18 | hiker | 1 | 28756 | 12 | 0.516 | 55728.7 |
421 | 2021-03-19 11:33:19 | hiker | 1 | 28756 | 12 | 0.640 | 44931.3 |
420 | 2021-02-15 14:57:10 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
419 | 2021-01-29 06:08:45 | hiker | 1 | 28756 | 12 | 0.453 | 63479.0 |
418 | 2020-12-31 16:26:28 | hiker | 1 | 28756 | 12 | 0.470 | 61183.0 |
417 | 2020-11-14 10:31:04 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
416 | 2020-11-11 07:42:12 | hiker | 1 | 28756 | 12 | 0.453 | 63479.0 |
415 | 2020-10-05 03:10:59 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
414 | 2020-09-01 18:50:45 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
413 | 2020-08-26 13:12:23 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
412 | 2020-08-25 09:36:09 | hiker | 1 | 28756 | 12 | 0.533 | 53951.2 |
411 | 2020-08-23 19:36:09 | hiker | 1 | 28756 | 12 | 0.516 | 55728.7 |
410 | 2020-08-11 02:32:22 | hiker | 1 | 28756 | 12 | 0.436 | 65954.1 |
409 | 2020-08-08 04:44:09 | hiker | 1 | 28756 | 12 | 0.470 | 61183.0 |
408 | 2020-08-03 17:35:58 | hiker | 1 | 28756 | 12 | 0.516 | 55728.7 |
407 | 2020-08-01 21:16:00 | hiker | 1 | 28756 | 12 | 0.470 | 61183.0 |
406 | 2020-07-29 15:02:42 | hiker | 1 | 28756 | 12 | 0.453 | 63479.0 |
405 | 2020-06-21 09:26:40 | hiker | 1 | 28756 | 12 | 0.500 | 57512.0 |
404 | 2020-06-20 09:18:46 | hiker | 1 | 28756 | 12 | 0.486 | 59168.7 |
403 | 2020-06-17 14:38:27 | hiker | 1 | 28756 | 12 | 0.470 | 61183.0 |
402 | 2020-06-13 01:28:15 | hiker | 1 | 28756 | 12 | 1.030 | 27918.4 |
401 | 2020-05-25 01:35:35 | hiker | 1 | 28756 | 12 | 0.546 | 52666.7 |
400 | 2020-05-15 10:03:09 | hiker | 1 | 28756 | 12 | 0.500 | 57512.0 |
399 | 2020-05-06 20:47:53 | hiker | 1 | 28756 | 12 | 0.516 | 55728.7 |
398 | 2020-03-26 23:56:39 | hiker | 1 | 28756 | 12 | 0.513 | 56054.6 |
397 | 2020-03-26 08:15:16 | hiker | 1 | 28756 | 12 | 0.530 | 54256.6 |
396 | 2020-03-24 12:17:50 | hiker | 1 | 28756 | 12 | 0.720 | 39938.9 |
395 | 2020-03-23 02:02:46 | hiker | 1 | 28756 | 12 | 1.063 | 27051.7 |
394 | 2020-03-22 19:59:01 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
393 | 2020-03-21 06:47:12 | hiker | 1 | 28756 | 12 | 0.936 | 30722.2 |
392 | 2020-03-18 17:00:50 | hiker | 1 | 28756 | 12 | 0.483 | 59536.2 |
391 | 2020-02-29 14:09:57 | hiker | 1 | 28756 | 12 | 0.530 | 54256.6 |