History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yardman"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
263 | 2024-02-17 19:54:41 | yardman | 3 | 134027 | 165 | 14.453 | 9273.3 |
262 | 2024-02-12 16:34:13 | yardman | 3 | 134027 | 165 | 22.203 | 6036.4 |
261 | 2024-02-10 16:56:42 | yardman | 3 | 134027 | 165 | 18.640 | 7190.3 |
260 | 2024-02-01 22:55:05 | yardman | 2 | 107671 | 17 | 2.920 | 36873.6 |
259 | 2024-01-30 07:37:21 | yardman | 3 | 134027 | 165 | 8.346 | 16058.8 |
258 | 2024-01-30 07:37:13 | yardman | 2 | 107671 | 17 | 4.890 | 22018.6 |
257 | 2024-01-29 13:50:16 | yardman | 2 | 107671 | 17 | 2.920 | 36873.6 |
256 | 2023-12-23 03:46:06 | yardman | 1 | 69583 | 2 | 1.080 | 64428.7 |
255 | 2023-12-19 19:34:20 | yardman | 1 | 69583 | 2 | 1.060 | 65644.3 |
254 | 2023-12-02 22:48:35 | yardman | 1 | 69583 | 2 | 1.356 | 51314.9 |
253 | 2023-11-08 03:44:41 | yardman | 2 | 107671 | 17 | 2.796 | 38508.9 |
252 | 2023-11-02 13:47:01 | yardman | 3 | 134027 | 165 | 7.986 | 16782.7 |
251 | 2023-10-20 18:24:53 | yardman | 1 | 69583 | 2 | 1.250 | 55666.4 |
250 | 2023-10-17 13:35:48 | yardman | 3 | 134027 | 165 | 9.016 | 14865.5 |
249 | 2023-10-10 23:31:02 | yardman | 1 | 69583 | 2 | 1.156 | 60192.9 |
248 | 2023-10-05 00:05:07 | yardman | 3 | 134027 | 165 | 7.013 | 19111.2 |
247 | 2023-10-05 00:05:10 | yardman | 2 | 107671 | 17 | 3.376 | 31893.1 |
246 | 2023-10-03 09:26:48 | yardman | 1 | 69583 | 2 | 2.390 | 29114.2 |
245 | 2023-09-29 18:17:43 | yardman | 1 | 69583 | 2 | 1.186 | 58670.3 |
244 | 2023-09-17 01:16:58 | yardman | 1 | 69583 | 2 | 1.046 | 66522.9 |
243 | 2023-08-12 18:30:50 | yardman | 2 | 107671 | 17 | 2.780 | 38730.6 |
242 | 2023-08-06 19:43:51 | yardman | 1 | 69583 | 2 | 1.123 | 61961.7 |
241 | 2023-06-13 01:57:28 | yardman | 1 | 69583 | 2 | 1.106 | 62914.1 |
240 | 2023-05-03 12:44:21 | yardman | 1 | 69583 | 2 | 1.050 | 66269.5 |
239 | 2023-04-25 03:19:05 | yardman | 2 | 107671 | 17 | 5.500 | 19576.5 |
238 | 2023-02-27 16:33:39 | yardman | 1 | 69583 | 2 | 1.060 | 65644.3 |
237 | 2023-01-29 13:52:03 | yardman | 2 | 107671 | 17 | 2.873 | 37476.9 |
236 | 2023-01-28 09:10:32 | yardman | 1 | 69583 | 2 | 1.033 | 67360.1 |
235 | 2023-01-24 17:36:52 | yardman | 1 | 69583 | 2 | 1.030 | 67556.3 |
234 | 2022-12-22 19:33:42 | yardman | 1 | 69583 | 2 | 1.123 | 61961.7 |
233 | 2022-11-10 17:55:42 | yardman | 2 | 107671 | 17 | 2.766 | 38926.6 |
232 | 2022-10-15 05:26:31 | yardman | 3 | 134027 | 165 | 5.736 | 23365.9 |
231 | 2022-09-18 19:03:40 | yardman | 1 | 69583 | 2 | 1.173 | 59320.5 |
230 | 2022-09-11 10:43:28 | yardman | 1 | 69583 | 2 | 1.046 | 66522.9 |
229 | 2022-07-15 02:30:20 | yardman | 3 | 134027 | 165 | 5.750 | 23309.0 |
228 | 2022-06-25 19:07:35 | yardman | 1 | 69583 | 2 | 1.060 | 65644.3 |
227 | 2022-05-26 09:43:25 | yardman | 2 | 107671 | 17 | 2.796 | 38508.9 |
226 | 2022-05-05 22:27:30 | yardman | 1 | 69583 | 2 | 1.076 | 64668.2 |
225 | 2022-04-11 20:41:16 | yardman | 1 | 69583 | 2 | 1.360 | 51164.0 |
224 | 2022-01-07 17:00:59 | yardman | 1 | 69583 | 2 | 1.170 | 59472.6 |
223 | 2022-01-05 07:09:08 | yardman | 1 | 69583 | 2 | 1.326 | 52475.9 |
222 | 2021-12-16 20:39:39 | yardman | 3 | 134027 | 165 | 6.843 | 19586.0 |
221 | 2021-12-16 09:48:34 | yardman | 1 | 69583 | 2 | 1.173 | 59320.5 |
220 | 2021-09-13 04:09:30 | yardman | 1 | 69583 | 2 | 1.140 | 61037.7 |
219 | 2021-06-16 03:02:24 | yardman | 1 | 69583 | 2 | 1.170 | 59472.6 |
218 | 2021-06-05 17:15:44 | yardman | 1 | 69583 | 2 | 1.186 | 58670.3 |
217 | 2021-05-23 14:18:59 | yardman | 3 | 134027 | 165 | 6.500 | 20619.5 |
216 | 2021-05-21 04:13:49 | yardman | 1 | 69583 | 2 | 1.126 | 61796.6 |
215 | 2021-04-20 01:01:00 | yardman | 3 | 134027 | 165 | 12.250 | 10941.0 |
214 | 2021-03-24 14:52:40 | yardman | 3 | 134027 | 165 | 6.970 | 19229.1 |
213 | 2021-03-03 13:39:31 | yardman | 1 | 69583 | 2 | 1.093 | 63662.4 |
212 | 2021-02-26 21:11:28 | yardman | 3 | 134027 | 165 | 5.656 | 23696.4 |
211 | 2021-02-19 15:37:04 | yardman | 3 | 134027 | 165 | 6.156 | 21771.8 |
210 | 2021-02-02 11:55:08 | yardman | 1 | 69583 | 2 | 1.063 | 65459.1 |
209 | 2020-12-25 22:27:00 | yardman | 3 | 134027 | 165 | 6.343 | 21129.9 |
208 | 2020-12-19 02:15:41 | yardman | 3 | 134027 | 165 | 6.373 | 21030.4 |
207 | 2020-11-23 06:41:39 | yardman | 1 | 69583 | 2 | 1.046 | 66522.9 |
206 | 2020-10-26 02:56:20 | yardman | 1 | 69583 | 2 | 1.063 | 65459.1 |
205 | 2020-10-20 05:02:16 | yardman | 1 | 69583 | 2 | 1.343 | 51811.6 |
204 | 2020-10-18 22:07:55 | yardman | 1 | 69583 | 2 | 1.156 | 60192.9 |
203 | 2020-08-12 12:28:20 | yardman | 1 | 69583 | 2 | 1.063 | 65459.1 |
202 | 2020-05-02 00:34:55 | yardman | 1 | 69583 | 2 | 1.093 | 63662.4 |
201 | 2020-03-29 20:58:16 | yardman | 1 | 69583 | 2 | 1.236 | 56296.9 |
200 | 2020-03-25 01:10:36 | yardman | 1 | 69583 | 2 | 2.406 | 28920.6 |
199 | 2020-03-24 16:25:25 | yardman | 1 | 69583 | 2 | 2.530 | 27503.2 |
198 | 2020-03-20 16:54:02 | yardman | 1 | 69583 | 2 | 1.123 | 61961.7 |
197 | 2020-03-02 05:46:32 | yardman | 3 | 134027 | 165 | 7.063 | 18975.9 |
196 | 2020-03-01 05:45:42 | yardman | 1 | 69583 | 2 | 2.516 | 27656.2 |
195 | 2020-02-27 20:26:57 | yardman | 1 | 69583 | 2 | 1.313 | 52995.4 |
194 | 2020-02-27 18:27:07 | yardman | 3 | 134027 | 165 | 22.483 | 5961.3 |
193 | 2020-02-26 23:59:00 | yardman | 3 | 134027 | 165 | 6.640 | 20184.8 |
192 | 2020-02-26 17:35:37 | yardman | 3 | 134027 | 165 | 7.110 | 18850.5 |
191 | 2020-02-18 02:28:59 | yardman | 1 | 69583 | 2 | 2.673 | 26031.8 |
190 | 2020-02-10 04:06:41 | yardman | 1 | 69583 | 2 | 1.186 | 58670.3 |
189 | 2020-02-08 17:45:42 | yardman | 1 | 69583 | 2 | 1.300 | 53525.4 |
188 | 2020-02-07 17:48:17 | yardman | 3 | 134027 | 165 | 7.126 | 18808.2 |
187 | 2020-02-07 15:43:43 | yardman | 3 | 134027 | 165 | 6.780 | 19768.0 |
186 | 2020-02-05 12:28:58 | yardman | 1 | 69583 | 2 | 1.326 | 52475.9 |
185 | 2020-02-05 11:49:56 | yardman | 1 | 69583 | 2 | 2.766 | 25156.5 |
184 | 2020-02-04 15:23:58 | yardman | 3 | 134027 | 165 | 14.920 | 8983.0 |
183 | 2020-02-03 01:55:27 | yardman | 3 | 134027 | 165 | 7.123 | 18816.1 |
182 | 2020-01-29 06:09:04 | yardman | 1 | 69583 | 2 | 1.343 | 51811.6 |
181 | 2020-01-27 22:32:56 | yardman | 1 | 69583 | 2 | 1.810 | 38443.6 |
180 | 2020-01-26 21:26:04 | yardman | 3 | 134027 | 165 | 16.143 | 8302.5 |
179 | 2020-01-24 23:30:28 | yardman | 1 | 69583 | 2 | 1.076 | 64668.2 |
178 | 2020-01-24 11:31:37 | yardman | 3 | 134027 | 165 | 7.576 | 17691.0 |
177 | 2020-01-23 21:21:27 | yardman | 1 | 69583 | 2 | 1.203 | 57841.2 |
176 | 2020-01-23 19:16:39 | yardman | 2 | 107671 | 17 | 3.733 | 28843.0 |
175 | 2020-01-22 08:29:38 | yardman | 2 | 107671 | 17 | 7.283 | 14783.9 |
174 | 2020-01-20 00:13:38 | yardman | 3 | 134027 | 165 | 18.876 | 7100.4 |
173 | 2020-01-17 13:29:40 | yardman | 3 | 134027 | 165 | 7.500 | 17870.3 |
172 | 2020-01-17 12:59:00 | yardman | 1 | 69583 | 2 | 2.686 | 25905.8 |
171 | 2020-01-17 01:32:18 | yardman | 1 | 69583 | 2 | 1.186 | 58670.3 |
170 | 2020-01-13 20:15:42 | yardman | 1 | 69583 | 2 | 3.720 | 18705.1 |
169 | 2020-01-13 04:15:32 | yardman | 2 | 107671 | 17 | 5.343 | 20151.8 |
168 | 2020-01-08 08:20:50 | yardman | 3 | 134027 | 165 | 13.033 | 10283.7 |
167 | 2020-01-07 22:18:22 | yardman | 3 | 134027 | 165 | 7.310 | 18334.7 |
166 | 2020-01-07 10:51:14 | yardman | 1 | 69583 | 2 | 1.390 | 50059.7 |
165 | 2019-12-30 01:05:00 | yardman | 3 | 134027 | 165 | 6.093 | 21996.9 |
164 | 2019-12-28 05:21:57 | yardman | 3 | 134027 | 165 | 6.283 | 21331.7 |