History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"headgate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
504 | 2024-05-02 17:09:32 | headgate | 1 | 82945 | 2 | 3.843 | 21583.4 |
503 | 2024-04-24 05:56:56 | headgate | 1 | 82945 | 2 | 1.733 | 47862.1 |
502 | 2024-04-13 17:14:48 | headgate | 1 | 82945 | 2 | 1.483 | 55930.5 |
501 | 2024-04-07 23:09:04 | headgate | 1 | 82945 | 2 | 4.093 | 20265.1 |
500 | 2024-04-01 14:59:52 | headgate | 2 | 121059 | 5 | 4.453 | 27185.9 |
499 | 2024-04-01 04:54:19 | headgate | 3 | 146162 | 61 | 19.410 | 7530.2 |
498 | 2024-04-01 04:20:24 | headgate | 1 | 82945 | 2 | 2.500 | 33178.0 |
497 | 2024-04-01 04:19:25 | headgate | 2 | 121059 | 5 | 7.780 | 15560.3 |
496 | 2024-04-01 04:19:22 | headgate | 3 | 146162 | 61 | 8.000 | 18270.3 |
495 | 2024-04-01 04:19:20 | headgate | 1 | 82945 | 2 | 1.593 | 52068.4 |
494 | 2024-03-18 20:20:13 | headgate | 4 | 161609 | 625 | 23.253 | 6950.0 |
493 | 2024-03-18 04:22:43 | headgate | 4 | 161609 | 625 | 13.140 | 12299.0 |
492 | 2024-03-16 15:21:18 | headgate | 4 | 161609 | 625 | 16.466 | 9814.7 |
491 | 2024-03-16 08:48:29 | headgate | 4 | 161609 | 625 | 47.626 | 3393.3 |
490 | 2024-03-11 17:57:32 | headgate | 2 | 121059 | 5 | 12.330 | 9818.2 |
489 | 2024-03-11 17:57:16 | headgate | 3 | 146162 | 61 | 25.016 | 5842.7 |
488 | 2024-03-11 02:11:11 | headgate | 3 | 146162 | 61 | 23.533 | 6210.9 |
487 | 2024-03-11 02:11:12 | headgate | 4 | 161609 | 625 | 15.670 | 10313.3 |
486 | 2024-03-11 02:11:11 | headgate | 2 | 121059 | 5 | 12.030 | 10063.1 |
485 | 2024-03-10 22:25:11 | headgate | 1 | 82945 | 2 | 1.500 | 55296.7 |
484 | 2024-03-07 04:14:09 | headgate | 1 | 82945 | 2 | 1.530 | 54212.4 |
483 | 2024-03-01 09:47:13 | headgate | 1 | 82945 | 2 | 3.923 | 21143.3 |
482 | 2024-02-11 15:45:31 | headgate | 4 | 161609 | 625 | 43.363 | 3726.9 |
481 | 2024-02-10 09:21:48 | headgate | 4 | 161609 | 625 | 12.610 | 12815.9 |
480 | 2024-02-09 21:53:17 | headgate | 4 | 161609 | 625 | 15.656 | 10322.5 |
479 | 2024-02-09 21:53:15 | headgate | 2 | 121059 | 5 | 9.190 | 13172.9 |
478 | 2024-02-09 17:39:35 | headgate | 3 | 146162 | 61 | 7.436 | 19656.0 |
477 | 2024-02-09 17:39:40 | headgate | 1 | 82945 | 2 | 1.436 | 57761.1 |
476 | 2024-01-29 14:16:24 | headgate | 3 | 146162 | 61 | 10.843 | 13479.8 |
475 | 2024-01-29 14:15:47 | headgate | 3 | 146162 | 61 | 9.486 | 15408.2 |
474 | 2024-01-29 10:04:53 | headgate | 3 | 146162 | 61 | 6.533 | 22372.9 |
473 | 2023-12-28 15:52:34 | headgate | 1 | 82945 | 2 | 1.266 | 65517.4 |
472 | 2023-12-12 11:35:32 | headgate | 1 | 82945 | 2 | 1.280 | 64800.8 |
471 | 2023-12-01 00:20:51 | headgate | 1 | 82945 | 2 | 1.440 | 57600.7 |
470 | 2023-11-27 21:54:00 | headgate | 1 | 82945 | 2 | 1.610 | 51518.6 |
469 | 2023-10-18 21:36:13 | headgate | 1 | 82945 | 2 | 1.330 | 62364.7 |
468 | 2023-09-26 13:37:08 | headgate | 1 | 82945 | 2 | 1.393 | 59544.1 |
467 | 2023-07-28 04:57:22 | headgate | 1 | 82945 | 2 | 1.233 | 67270.9 |
466 | 2023-07-20 19:56:28 | headgate | 1 | 82945 | 2 | 1.263 | 65673.0 |
465 | 2023-04-18 20:19:06 | headgate | 1 | 82945 | 2 | 1.236 | 67107.6 |
464 | 2023-04-05 06:12:09 | headgate | 1 | 82945 | 2 | 1.373 | 60411.5 |
463 | 2023-02-06 11:59:19 | headgate | 1 | 82945 | 2 | 1.233 | 67270.9 |
462 | 2022-12-10 06:31:05 | headgate | 1 | 82945 | 2 | 1.860 | 44594.1 |
461 | 2022-12-05 00:42:03 | headgate | 1 | 82945 | 2 | 1.266 | 65517.4 |
460 | 2022-09-02 04:15:17 | headgate | 1 | 82945 | 2 | 1.483 | 55930.5 |
459 | 2022-08-07 11:29:55 | headgate | 1 | 82945 | 2 | 1.283 | 64649.3 |
458 | 2022-07-30 23:46:38 | headgate | 1 | 82945 | 2 | 1.406 | 58993.6 |
457 | 2022-07-30 14:12:56 | headgate | 1 | 82945 | 2 | 1.403 | 59119.7 |
456 | 2022-05-17 18:30:06 | headgate | 3 | 146162 | 61 | 6.813 | 21453.4 |
455 | 2022-04-10 12:17:12 | headgate | 1 | 82945 | 2 | 1.393 | 59544.1 |
454 | 2022-04-09 18:07:17 | headgate | 1 | 82945 | 2 | 1.406 | 58993.6 |
453 | 2022-03-22 17:07:39 | headgate | 1 | 82945 | 2 | 1.830 | 45325.1 |
452 | 2022-01-28 19:52:36 | headgate | 3 | 146162 | 61 | 7.000 | 20880.3 |
451 | 2022-01-28 00:57:19 | headgate | 3 | 146162 | 61 | 6.860 | 21306.4 |
450 | 2022-01-27 07:08:05 | headgate | 3 | 146162 | 61 | 7.436 | 19656.0 |
449 | 2022-01-26 20:21:54 | headgate | 3 | 146162 | 61 | 6.406 | 22816.4 |
448 | 2022-01-26 10:53:10 | headgate | 3 | 146162 | 61 | 6.250 | 23385.9 |
447 | 2022-01-25 22:28:39 | headgate | 3 | 146162 | 61 | 8.923 | 16380.4 |
446 | 2022-01-25 02:55:56 | headgate | 3 | 146162 | 61 | 6.703 | 21805.5 |
445 | 2022-01-24 17:56:26 | headgate | 3 | 146162 | 61 | 7.983 | 18309.2 |
444 | 2022-01-23 22:27:52 | headgate | 3 | 146162 | 61 | 6.783 | 21548.3 |
443 | 2022-01-15 00:06:59 | headgate | 3 | 146162 | 61 | 6.420 | 22766.7 |
442 | 2021-12-31 22:00:08 | headgate | 3 | 146162 | 61 | 7.153 | 20433.7 |
441 | 2021-12-31 11:17:33 | headgate | 3 | 146162 | 61 | 6.533 | 22372.9 |
440 | 2021-12-30 17:20:37 | headgate | 3 | 146162 | 61 | 7.516 | 19446.8 |
439 | 2021-12-29 23:09:22 | headgate | 3 | 146162 | 61 | 6.330 | 23090.4 |
438 | 2021-12-29 13:37:29 | headgate | 3 | 146162 | 61 | 6.326 | 23105.0 |
437 | 2021-12-29 04:11:49 | headgate | 3 | 146162 | 61 | 6.873 | 21266.1 |
436 | 2021-12-28 12:57:33 | headgate | 3 | 146162 | 61 | 7.360 | 19859.0 |
435 | 2021-12-27 20:46:55 | headgate | 3 | 146162 | 61 | 6.546 | 22328.4 |
434 | 2021-12-27 09:29:56 | headgate | 3 | 146162 | 61 | 6.563 | 22270.6 |
433 | 2021-12-26 21:04:03 | headgate | 3 | 146162 | 61 | 7.686 | 19016.7 |
432 | 2021-12-26 09:31:51 | headgate | 3 | 146162 | 61 | 7.593 | 19249.6 |
431 | 2021-12-26 01:03:28 | headgate | 3 | 146162 | 61 | 6.983 | 20931.1 |
430 | 2021-12-25 11:35:37 | headgate | 3 | 146162 | 61 | 6.986 | 20922.1 |
429 | 2021-12-25 00:31:52 | headgate | 3 | 146162 | 61 | 6.423 | 22756.0 |
428 | 2021-12-24 12:27:32 | headgate | 3 | 146162 | 61 | 7.063 | 20694.0 |
427 | 2021-12-24 01:01:19 | headgate | 3 | 146162 | 61 | 6.686 | 21860.9 |
426 | 2021-12-23 22:36:49 | headgate | 3 | 146162 | 61 | 7.703 | 18974.7 |
425 | 2021-12-23 11:09:15 | headgate | 3 | 146162 | 61 | 6.843 | 21359.3 |
424 | 2021-12-23 02:36:05 | headgate | 3 | 146162 | 61 | 7.643 | 19123.6 |
423 | 2021-12-22 15:38:21 | headgate | 3 | 146162 | 61 | 7.263 | 20124.2 |
422 | 2021-12-22 04:07:12 | headgate | 3 | 146162 | 61 | 8.050 | 18156.8 |
421 | 2021-12-21 19:04:13 | headgate | 3 | 146162 | 61 | 7.970 | 18339.0 |
420 | 2021-12-21 09:14:23 | headgate | 3 | 146162 | 61 | 7.283 | 20068.9 |
419 | 2021-12-20 22:18:28 | headgate | 3 | 146162 | 61 | 6.373 | 22934.6 |
418 | 2021-12-20 11:32:24 | headgate | 3 | 146162 | 61 | 7.733 | 18901.1 |
417 | 2021-12-19 17:46:30 | headgate | 3 | 146162 | 61 | 7.170 | 20385.2 |
416 | 2021-12-19 05:58:21 | headgate | 3 | 146162 | 61 | 6.313 | 23152.5 |
415 | 2021-12-18 19:10:28 | headgate | 3 | 146162 | 61 | 7.750 | 18859.6 |
414 | 2021-12-05 11:28:56 | headgate | 1 | 82945 | 2 | 1.436 | 57761.1 |
413 | 2021-11-19 14:52:45 | headgate | 3 | 146162 | 61 | 13.643 | 10713.3 |
412 | 2021-11-10 10:00:09 | headgate | 3 | 146162 | 61 | 7.953 | 18378.2 |
411 | 2021-11-09 23:42:53 | headgate | 3 | 146162 | 61 | 7.440 | 19645.4 |
410 | 2021-11-09 11:57:17 | headgate | 3 | 146162 | 61 | 6.423 | 22756.0 |
409 | 2021-11-08 12:37:21 | headgate | 3 | 146162 | 61 | 7.986 | 18302.3 |
408 | 2021-11-08 02:00:27 | headgate | 3 | 146162 | 61 | 6.500 | 22486.5 |
407 | 2021-11-07 20:38:27 | headgate | 3 | 146162 | 61 | 6.513 | 22441.6 |
406 | 2021-11-07 10:31:16 | headgate | 3 | 146162 | 61 | 6.643 | 22002.4 |
405 | 2021-11-07 00:21:21 | headgate | 3 | 146162 | 61 | 7.546 | 19369.5 |