History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"headwater"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
135 | 2024-03-19 01:51:37 | headwater | 1 | 81242 | 3 | 3.220 | 25230.4 |
134 | 2024-03-18 23:22:35 | headwater | 3 | 148641 | 35 | 11.800 | 12596.7 |
133 | 2024-03-11 18:00:12 | headwater | 3 | 148641 | 35 | 15.876 | 9362.6 |
132 | 2024-03-11 18:00:04 | headwater | 2 | 121436 | 9 | 13.220 | 9185.8 |
131 | 2024-03-11 17:57:16 | headwater | 1 | 81242 | 3 | 1.593 | 50999.4 |
130 | 2024-03-11 11:59:50 | headwater | 1 | 81242 | 3 | 1.796 | 45235.0 |
129 | 2024-03-10 22:25:13 | headwater | 1 | 81242 | 3 | 1.500 | 54161.3 |
128 | 2024-03-02 19:35:09 | headwater | 4 | 165329 | 291 | 31.940 | 5176.2 |
127 | 2024-03-02 19:35:14 | headwater | 3 | 148641 | 35 | 26.843 | 5537.4 |
126 | 2024-03-02 19:35:12 | headwater | 2 | 121436 | 9 | 15.826 | 7673.2 |
125 | 2024-03-02 19:29:26 | headwater | 1 | 81242 | 3 | 1.550 | 52414.2 |
124 | 2024-03-01 03:03:47 | headwater | 1 | 81242 | 3 | 1.936 | 41963.8 |
123 | 2024-02-29 18:34:26 | headwater | 1 | 81242 | 3 | 1.440 | 56418.1 |
122 | 2024-02-09 17:40:04 | headwater | 1 | 81242 | 3 | 1.233 | 65889.7 |
121 | 2024-02-06 20:46:11 | headwater | 3 | 148641 | 35 | 20.003 | 7430.9 |
120 | 2024-02-02 16:19:39 | headwater | 1 | 81242 | 3 | 1.436 | 56575.2 |
119 | 2024-01-29 14:16:51 | headwater | 1 | 81242 | 3 | 1.376 | 59042.2 |
118 | 2023-12-30 01:27:42 | headwater | 3 | 148641 | 35 | 6.440 | 23080.9 |
117 | 2023-12-29 16:14:56 | headwater | 1 | 81242 | 3 | 1.220 | 66591.8 |
116 | 2023-12-15 18:25:06 | headwater | 1 | 81242 | 3 | 2.250 | 36107.6 |
115 | 2023-12-15 03:02:56 | headwater | 1 | 81242 | 3 | 1.596 | 50903.5 |
114 | 2023-10-03 14:46:49 | headwater | 3 | 148641 | 35 | 7.080 | 20994.5 |
113 | 2023-09-29 01:05:50 | headwater | 1 | 81242 | 3 | 1.376 | 59042.2 |
112 | 2023-09-16 07:22:48 | headwater | 1 | 81242 | 3 | 1.390 | 58447.5 |
111 | 2023-07-23 19:37:47 | headwater | 1 | 81242 | 3 | 1.266 | 64172.2 |
110 | 2023-07-15 16:02:25 | headwater | 3 | 148641 | 35 | 6.923 | 21470.6 |
109 | 2023-04-24 15:33:16 | headwater | 1 | 81242 | 3 | 1.220 | 66591.8 |
108 | 2023-04-04 01:17:03 | headwater | 3 | 148641 | 35 | 6.060 | 24528.2 |
107 | 2023-02-12 19:09:26 | headwater | 1 | 81242 | 3 | 1.343 | 60492.9 |
106 | 2022-12-30 19:19:04 | headwater | 3 | 148641 | 35 | 6.170 | 24090.9 |
105 | 2022-12-09 19:43:04 | headwater | 1 | 81242 | 3 | 1.360 | 59736.8 |
104 | 2022-09-01 19:48:22 | headwater | 3 | 148641 | 35 | 6.423 | 23142.0 |
103 | 2022-08-12 23:13:19 | headwater | 1 | 81242 | 3 | 1.216 | 66810.9 |
102 | 2022-08-10 14:42:10 | headwater | 1 | 81242 | 3 | 1.233 | 65889.7 |
101 | 2022-04-02 00:14:31 | headwater | 1 | 81242 | 3 | 1.360 | 59736.8 |
100 | 2022-01-16 10:56:44 | headwater | 1 | 81242 | 3 | 1.470 | 55266.7 |
99 | 2022-01-14 07:55:22 | headwater | 1 | 81242 | 3 | 1.280 | 63470.3 |
98 | 2021-10-14 23:07:40 | headwater | 1 | 81242 | 3 | 1.406 | 57782.4 |
97 | 2021-10-12 18:53:55 | headwater | 1 | 81242 | 3 | 1.503 | 54053.2 |
96 | 2021-10-11 21:57:50 | headwater | 1 | 81242 | 3 | 1.550 | 52414.2 |
95 | 2021-10-10 18:46:02 | headwater | 1 | 81242 | 3 | 1.373 | 59171.2 |
94 | 2021-09-20 16:32:39 | headwater | 1 | 81242 | 3 | 1.393 | 58321.6 |
93 | 2021-09-19 23:05:20 | headwater | 1 | 81242 | 3 | 1.390 | 58447.5 |
92 | 2021-09-13 07:28:40 | headwater | 1 | 81242 | 3 | 1.546 | 52549.8 |
91 | 2021-04-15 22:14:34 | headwater | 1 | 81242 | 3 | 1.440 | 56418.1 |
90 | 2020-12-31 06:24:57 | headwater | 1 | 81242 | 3 | 1.360 | 59736.8 |
89 | 2020-11-01 14:36:56 | headwater | 1 | 81242 | 3 | 1.283 | 63321.9 |
88 | 2020-10-31 15:30:59 | headwater | 1 | 81242 | 3 | 1.216 | 66810.9 |
87 | 2020-10-21 07:19:04 | headwater | 1 | 81242 | 3 | 2.640 | 30773.5 |
86 | 2020-03-23 23:27:32 | headwater | 1 | 81242 | 3 | 1.360 | 59736.8 |
85 | 2020-03-14 03:38:24 | headwater | 1 | 81242 | 3 | 1.390 | 58447.5 |
84 | 2020-03-05 03:46:26 | headwater | 1 | 81242 | 3 | 1.313 | 61875.1 |
83 | 2020-02-09 00:16:46 | headwater | 1 | 81242 | 3 | 1.500 | 54161.3 |
82 | 2020-02-08 20:03:16 | headwater | 1 | 81242 | 3 | 4.016 | 20229.6 |
81 | 2020-02-04 19:31:17 | headwater | 1 | 81242 | 3 | 3.093 | 26266.4 |
80 | 2020-01-31 08:35:34 | headwater | 1 | 81242 | 3 | 2.906 | 27956.6 |
79 | 2020-01-31 02:25:17 | headwater | 1 | 81242 | 3 | 1.580 | 51419.0 |
78 | 2020-01-30 08:21:02 | headwater | 1 | 81242 | 3 | 1.440 | 56418.1 |
77 | 2020-01-23 04:59:46 | headwater | 1 | 81242 | 3 | 1.436 | 56575.2 |
76 | 2020-01-15 04:00:02 | headwater | 1 | 81242 | 3 | 1.500 | 54161.3 |
75 | 2020-01-06 12:11:17 | headwater | 1 | 81242 | 3 | 1.453 | 55913.3 |
74 | 2020-01-03 08:03:09 | headwater | 1 | 81242 | 3 | 1.436 | 56575.2 |
73 | 2019-11-29 15:59:50 | headwater | 1 | 81242 | 3 | 1.266 | 64172.2 |
72 | 2019-08-25 00:46:21 | headwater | 1 | 81242 | 3 | 1.386 | 58616.2 |
71 | 2019-05-29 21:45:38 | headwater | 1 | 81242 | 3 | 1.273 | 63819.3 |
70 | 2019-05-19 02:05:20 | headwater | 1 | 81242 | 3 | 1.406 | 57782.4 |
69 | 2019-04-05 15:33:25 | headwater | 1 | 81242 | 3 | 1.233 | 65889.7 |
68 | 2019-03-28 08:34:28 | headwater | 1 | 81242 | 3 | 1.260 | 64477.8 |
67 | 2019-01-29 04:25:37 | headwater | 1 | 81242 | 3 | 1.336 | 60809.9 |
66 | 2019-01-28 01:35:43 | headwater | 1 | 81242 | 3 | 1.176 | 69083.3 |
65 | 2019-01-27 11:56:41 | headwater | 1 | 81242 | 3 | 1.200 | 67701.7 |
64 | 2019-01-23 22:10:38 | headwater | 1 | 81242 | 3 | 1.240 | 65517.7 |
63 | 2019-01-18 00:33:40 | headwater | 1 | 81242 | 3 | 1.193 | 68098.9 |
62 | 2018-12-16 20:43:48 | headwater | 1 | 81242 | 3 | 1.200 | 67701.7 |
61 | 2018-11-24 08:07:28 | headwater | 1 | 81242 | 3 | 1.303 | 62350.0 |
60 | 2018-11-10 20:15:12 | headwater | 1 | 81242 | 3 | 1.323 | 61407.4 |
59 | 2018-10-03 19:14:54 | headwater | 1 | 81242 | 3 | 1.383 | 58743.3 |
58 | 2018-07-05 06:14:09 | headwater | 1 | 81242 | 3 | 1.230 | 66050.4 |
57 | 2018-07-01 09:37:58 | headwater | 1 | 81242 | 3 | 1.443 | 56300.8 |
56 | 2018-06-24 12:23:13 | headwater | 1 | 81242 | 3 | 2.440 | 33295.9 |
55 | 2018-06-23 17:18:58 | headwater | 1 | 81242 | 3 | 1.300 | 62493.8 |
54 | 2018-06-19 14:07:27 | headwater | 1 | 81242 | 3 | 1.340 | 60628.4 |
53 | 2018-06-07 07:05:23 | headwater | 1 | 81242 | 3 | 1.246 | 65202.2 |
52 | 2018-05-09 10:45:28 | headwater | 1 | 81242 | 3 | 1.390 | 58447.5 |
51 | 2018-04-23 11:59:18 | headwater | 1 | 81242 | 3 | 1.340 | 60628.4 |
50 | 2018-04-08 16:28:06 | headwater | 1 | 81242 | 3 | 2.156 | 37681.8 |
49 | 2018-03-26 14:46:10 | headwater | 1 | 81242 | 3 | 2.560 | 31735.2 |
48 | 2018-01-03 20:32:27 | headwater | 1 | 81242 | 3 | 2.186 | 37164.7 |
47 | 2017-11-11 22:41:26 | headwater | 1 | 81242 | 3 | 1.803 | 45059.3 |
46 | 2017-09-24 00:52:49 | headwater | 1 | 81242 | 3 | 2.200 | 36928.2 |
45 | 2017-09-07 03:01:52 | headwater | 1 | 81242 | 3 | 3.273 | 24821.9 |
44 | 2017-05-17 08:25:52 | headwater | 1 | 81242 | 3 | 1.653 | 49148.2 |
43 | 2016-11-05 21:54:54 | headwater | 1 | 81242 | 3 | 1.726 | 47069.5 |
42 | 2016-10-29 20:33:06 | headwater | 1 | 81242 | 3 | 1.736 | 46798.4 |
41 | 2016-06-25 10:37:13 | headwater | 1 | 81242 | 3 | 2.160 | 37612.0 |
40 | 2015-11-03 19:57:30 | headwater | 1 | 81242 | 3 | 2.140 | 37963.6 |
39 | 2015-10-26 07:25:44 | headwater | 1 | 81242 | 3 | 2.973 | 27326.6 |
38 | 2015-10-21 16:08:01 | headwater | 1 | 81242 | 3 | 1.323 | 61407.4 |
37 | 2015-10-05 11:18:13 | headwater | 1 | 81242 | 3 | 1.473 | 55154.1 |
36 | 2015-09-17 05:45:38 | headwater | 3 | 148641 | 35 | 14.600 | 10180.9 |