History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yardage"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
211 | 2024-04-02 12:16:32 | yardage | 1 | 69583 | 2 | 1.170 | 59472.6 |
210 | 2024-03-28 23:49:03 | yardage | 1 | 69583 | 2 | 2.076 | 33517.8 |
209 | 2024-03-25 21:01:11 | yardage | 3 | 134027 | 153 | 16.843 | 7957.4 |
208 | 2024-03-25 21:01:03 | yardage | 2 | 107671 | 13 | 8.000 | 13458.9 |
207 | 2024-03-25 20:12:04 | yardage | 1 | 69583 | 2 | 4.013 | 17339.4 |
206 | 2024-03-08 12:44:40 | yardage | 3 | 134027 | 153 | 18.313 | 7318.7 |
205 | 2024-03-07 23:55:41 | yardage | 2 | 107671 | 13 | 3.640 | 29579.9 |
204 | 2024-03-07 23:55:29 | yardage | 3 | 134027 | 153 | 8.063 | 16622.5 |
203 | 2024-03-07 15:13:41 | yardage | 2 | 107671 | 13 | 3.563 | 30219.2 |
202 | 2024-03-07 15:13:38 | yardage | 3 | 134027 | 153 | 6.873 | 19500.5 |
201 | 2024-03-07 12:47:33 | yardage | 1 | 69583 | 2 | 1.030 | 67556.3 |
200 | 2024-02-23 02:35:34 | yardage | 2 | 107671 | 13 | 6.593 | 16331.1 |
199 | 2024-02-23 02:35:33 | yardage | 3 | 134027 | 153 | 7.126 | 18808.2 |
198 | 2024-02-22 21:44:39 | yardage | 1 | 69583 | 2 | 1.046 | 66522.9 |
197 | 2024-01-19 00:32:17 | yardage | 1 | 69583 | 2 | 1.046 | 66522.9 |
196 | 2024-01-08 12:49:38 | yardage | 1 | 69583 | 2 | 1.203 | 57841.2 |
195 | 2023-12-22 11:14:49 | yardage | 3 | 134027 | 153 | 6.390 | 20974.5 |
194 | 2023-12-22 11:14:48 | yardage | 2 | 107671 | 13 | 3.236 | 33272.9 |
193 | 2023-12-17 00:43:58 | yardage | 2 | 107671 | 13 | 2.873 | 37476.9 |
192 | 2023-12-01 19:10:19 | yardage | 1 | 69583 | 2 | 1.206 | 57697.3 |
191 | 2023-11-15 14:26:05 | yardage | 1 | 69583 | 2 | 1.030 | 67556.3 |
190 | 2023-11-12 05:51:38 | yardage | 1 | 69583 | 2 | 1.466 | 47464.5 |
189 | 2023-10-29 18:05:45 | yardage | 1 | 69583 | 2 | 1.200 | 57985.8 |
188 | 2023-10-07 09:36:41 | yardage | 1 | 69583 | 2 | 1.186 | 58670.3 |
187 | 2023-09-17 14:13:45 | yardage | 2 | 107671 | 13 | 3.216 | 33479.8 |
186 | 2023-09-02 00:55:11 | yardage | 1 | 69583 | 2 | 1.076 | 64668.2 |
185 | 2023-06-23 21:47:35 | yardage | 2 | 107671 | 13 | 3.373 | 31921.4 |
184 | 2023-06-04 21:07:16 | yardage | 1 | 69583 | 2 | 1.186 | 58670.3 |
183 | 2023-03-26 11:31:08 | yardage | 1 | 69583 | 2 | 1.190 | 58473.1 |
182 | 2023-03-22 04:21:12 | yardage | 2 | 107671 | 13 | 2.750 | 39153.1 |
181 | 2023-01-09 23:09:50 | yardage | 1 | 69583 | 2 | 1.030 | 67556.3 |
180 | 2022-12-21 18:38:26 | yardage | 2 | 107671 | 13 | 3.153 | 34148.7 |
179 | 2022-10-09 12:43:24 | yardage | 1 | 69583 | 2 | 1.050 | 66269.5 |
178 | 2022-09-05 10:18:02 | yardage | 1 | 69583 | 2 | 1.046 | 66522.9 |
177 | 2022-09-01 13:04:09 | yardage | 1 | 69583 | 2 | 1.173 | 59320.5 |
176 | 2022-08-23 04:03:14 | yardage | 2 | 107671 | 13 | 2.783 | 38688.8 |
175 | 2022-07-13 19:39:34 | yardage | 3 | 134027 | 153 | 5.846 | 22926.3 |
174 | 2022-05-28 13:05:01 | yardage | 1 | 69583 | 2 | 1.046 | 66522.9 |
173 | 2022-05-12 15:19:42 | yardage | 1 | 69583 | 2 | 1.233 | 56433.9 |
172 | 2022-02-09 19:34:23 | yardage | 1 | 69583 | 2 | 1.220 | 57035.2 |
171 | 2022-01-05 00:13:29 | yardage | 1 | 69583 | 2 | 1.280 | 54361.7 |
170 | 2021-12-16 01:00:08 | yardage | 1 | 69583 | 2 | 1.076 | 64668.2 |
169 | 2021-09-06 10:21:20 | yardage | 1 | 69583 | 2 | 1.046 | 66522.9 |
168 | 2021-05-23 11:39:26 | yardage | 1 | 69583 | 2 | 1.203 | 57841.2 |
167 | 2021-02-13 15:50:02 | yardage | 1 | 69583 | 2 | 1.063 | 65459.1 |
166 | 2021-01-31 07:01:23 | yardage | 1 | 69583 | 2 | 1.143 | 60877.5 |
165 | 2020-10-29 12:34:40 | yardage | 1 | 69583 | 2 | 1.080 | 64428.7 |
164 | 2020-10-23 11:57:25 | yardage | 1 | 69583 | 2 | 1.126 | 61796.6 |
163 | 2020-10-13 09:58:35 | yardage | 1 | 69583 | 2 | 1.063 | 65459.1 |
162 | 2020-08-01 02:21:20 | yardage | 1 | 69583 | 2 | 1.140 | 61037.7 |
161 | 2020-06-07 13:03:36 | yardage | 1 | 69583 | 2 | 1.063 | 65459.1 |
160 | 2020-03-30 08:58:15 | yardage | 1 | 69583 | 2 | 2.560 | 27180.9 |
159 | 2020-03-28 10:56:15 | yardage | 1 | 69583 | 2 | 1.860 | 37410.2 |
158 | 2020-03-23 23:50:28 | yardage | 1 | 69583 | 2 | 1.236 | 56296.9 |
157 | 2020-03-21 05:10:44 | yardage | 1 | 69583 | 2 | 1.126 | 61796.6 |
156 | 2020-03-06 01:03:45 | yardage | 1 | 69583 | 2 | 1.186 | 58670.3 |
155 | 2020-02-23 17:23:08 | yardage | 1 | 69583 | 2 | 1.283 | 54234.6 |
154 | 2020-02-21 04:22:36 | yardage | 1 | 69583 | 2 | 1.296 | 53690.6 |
153 | 2020-02-08 19:33:06 | yardage | 1 | 69583 | 2 | 1.220 | 57035.2 |
152 | 2020-02-06 02:10:37 | yardage | 1 | 69583 | 2 | 2.670 | 26061.0 |
151 | 2020-02-01 07:50:54 | yardage | 1 | 69583 | 2 | 2.653 | 26228.0 |
150 | 2020-01-28 23:33:18 | yardage | 1 | 69583 | 2 | 1.360 | 51164.0 |
149 | 2020-01-26 16:31:23 | yardage | 1 | 69583 | 2 | 1.283 | 54234.6 |
148 | 2020-01-24 03:38:51 | yardage | 1 | 69583 | 2 | 1.033 | 67360.1 |
147 | 2020-01-15 09:49:48 | yardage | 1 | 69583 | 2 | 1.876 | 37091.2 |
146 | 2020-01-07 12:35:13 | yardage | 2 | 107671 | 13 | 4.970 | 21664.2 |
145 | 2020-01-07 09:52:39 | yardage | 1 | 69583 | 2 | 1.220 | 57035.2 |
144 | 2020-01-07 07:32:32 | yardage | 1 | 69583 | 2 | 1.313 | 52995.4 |
143 | 2020-01-06 20:36:08 | yardage | 1 | 69583 | 2 | 1.250 | 55666.4 |
142 | 2019-12-30 17:24:15 | yardage | 1 | 69583 | 2 | 2.703 | 25742.9 |
141 | 2019-12-29 15:41:00 | yardage | 1 | 69583 | 2 | 1.170 | 59472.6 |
140 | 2019-11-27 06:16:36 | yardage | 1 | 69583 | 2 | 1.203 | 57841.2 |
139 | 2019-08-25 13:21:19 | yardage | 1 | 69583 | 2 | 1.106 | 62914.1 |
138 | 2019-07-22 13:57:29 | yardage | 3 | 134027 | 153 | 6.223 | 21537.4 |
137 | 2019-05-16 11:17:12 | yardage | 1 | 69583 | 2 | 1.090 | 63837.6 |
136 | 2019-01-18 23:59:00 | yardage | 1 | 69583 | 2 | 1.073 | 64849.0 |
135 | 2019-01-07 16:34:12 | yardage | 1 | 69583 | 2 | 0.993 | 70073.5 |
134 | 2018-11-30 15:57:33 | yardage | 1 | 69583 | 2 | 1.173 | 59320.5 |
133 | 2018-11-19 03:18:43 | yardage | 1 | 69583 | 2 | 1.013 | 68690.0 |
132 | 2018-11-13 16:30:23 | yardage | 1 | 69583 | 2 | 1.183 | 58819.1 |
131 | 2018-09-16 14:34:19 | yardage | 1 | 69583 | 2 | 1.030 | 67556.3 |
130 | 2018-08-22 04:01:26 | yardage | 1 | 69583 | 2 | 1.083 | 64250.2 |
129 | 2018-08-13 13:36:05 | yardage | 1 | 69583 | 2 | 1.253 | 55533.1 |
128 | 2018-08-07 19:47:17 | yardage | 1 | 69583 | 2 | 1.063 | 65459.1 |
127 | 2018-08-07 19:45:38 | yardage | 1 | 69583 | 2 | 1.173 | 59320.5 |
126 | 2018-07-11 10:54:48 | yardage | 1 | 69583 | 2 | 2.093 | 33245.6 |
125 | 2018-07-06 15:50:08 | yardage | 1 | 69583 | 2 | 1.013 | 68690.0 |
124 | 2018-06-23 02:38:42 | yardage | 1 | 69583 | 2 | 1.203 | 57841.2 |
123 | 2018-06-23 00:59:08 | yardage | 1 | 69583 | 2 | 1.213 | 57364.4 |
122 | 2018-06-23 00:17:49 | yardage | 1 | 69583 | 2 | 1.056 | 65893.0 |
121 | 2018-06-22 14:15:06 | yardage | 1 | 69583 | 2 | 1.230 | 56571.5 |
120 | 2018-06-19 16:52:48 | yardage | 1 | 69583 | 2 | 1.190 | 58473.1 |
119 | 2018-06-15 22:20:09 | yardage | 1 | 69583 | 2 | 1.176 | 59169.2 |
118 | 2018-05-29 15:31:24 | yardage | 1 | 69583 | 2 | 1.040 | 66906.7 |
117 | 2018-05-25 13:29:55 | yardage | 1 | 69583 | 2 | 1.093 | 63662.4 |
116 | 2018-05-07 19:05:57 | yardage | 1 | 69583 | 2 | 1.193 | 58326.1 |
115 | 2018-05-02 21:44:32 | yardage | 1 | 69583 | 2 | 1.150 | 60507.0 |
114 | 2018-04-15 20:18:25 | yardage | 1 | 69583 | 2 | 1.166 | 59676.7 |
113 | 2018-04-10 05:29:46 | yardage | 1 | 69583 | 2 | 1.033 | 67360.1 |
112 | 2018-04-06 19:18:26 | yardage | 1 | 69583 | 2 | 1.826 | 38106.8 |