History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"servant"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
267 | 2024-04-12 22:14:08 | servant | 2 | 107671 | 22 | 3.530 | 30501.7 |
266 | 2024-04-12 22:11:29 | servant | 1 | 69583 | 2 | 2.673 | 26031.8 |
265 | 2024-04-12 22:11:16 | servant | 3 | 134027 | 219 | 7.126 | 18808.2 |
264 | 2024-04-08 09:37:42 | servant | 3 | 134027 | 219 | 22.563 | 5940.1 |
263 | 2024-04-06 07:21:54 | servant | 3 | 134027 | 219 | 24.720 | 5421.8 |
262 | 2024-04-05 14:00:23 | servant | 3 | 134027 | 219 | 27.376 | 4895.8 |
261 | 2024-04-05 09:00:35 | servant | 3 | 134027 | 219 | 13.220 | 10138.2 |
260 | 2024-04-05 07:43:46 | servant | 3 | 134027 | 219 | 18.876 | 7100.4 |
259 | 2024-04-04 05:22:07 | servant | 1 | 69583 | 2 | 2.923 | 23805.3 |
258 | 2024-03-28 13:40:51 | servant | 1 | 69583 | 2 | 1.280 | 54361.7 |
257 | 2024-02-28 10:23:08 | servant | 1 | 69583 | 2 | 2.780 | 25029.9 |
256 | 2023-12-29 23:17:50 | servant | 1 | 69583 | 2 | 1.123 | 61961.7 |
255 | 2023-12-26 18:19:52 | servant | 1 | 69583 | 2 | 1.186 | 58670.3 |
254 | 2023-12-25 06:35:25 | servant | 1 | 69583 | 2 | 1.140 | 61037.7 |
253 | 2023-12-08 13:33:57 | servant | 3 | 134027 | 219 | 6.063 | 22105.7 |
252 | 2023-12-01 05:46:08 | servant | 1 | 69583 | 2 | 1.203 | 57841.2 |
251 | 2023-11-28 12:29:22 | servant | 1 | 69583 | 2 | 1.203 | 57841.2 |
250 | 2023-11-04 15:00:21 | servant | 1 | 69583 | 2 | 1.266 | 54962.9 |
249 | 2023-10-16 03:17:25 | servant | 1 | 69583 | 2 | 1.250 | 55666.4 |
248 | 2023-10-13 02:29:18 | servant | 1 | 69583 | 2 | 1.200 | 57985.8 |
247 | 2023-10-05 16:30:27 | servant | 1 | 69583 | 2 | 1.873 | 37150.6 |
246 | 2023-09-29 08:32:49 | servant | 1 | 69583 | 2 | 1.140 | 61037.7 |
245 | 2023-09-24 07:33:06 | servant | 1 | 69583 | 2 | 1.233 | 56433.9 |
244 | 2023-09-05 13:26:16 | servant | 3 | 134027 | 219 | 6.893 | 19443.9 |
243 | 2023-08-20 23:56:41 | servant | 1 | 69583 | 2 | 1.233 | 56433.9 |
242 | 2023-08-08 16:44:37 | servant | 1 | 69583 | 2 | 1.233 | 56433.9 |
241 | 2023-06-01 18:06:59 | servant | 3 | 134027 | 219 | 6.750 | 19855.9 |
240 | 2023-05-09 03:06:49 | servant | 1 | 69583 | 2 | 1.096 | 63488.1 |
239 | 2023-04-24 23:03:43 | servant | 1 | 69583 | 2 | 1.110 | 62687.4 |
238 | 2023-04-22 06:43:32 | servant | 1 | 69583 | 2 | 1.093 | 63662.4 |
237 | 2023-04-09 04:00:56 | servant | 3 | 134027 | 219 | 6.263 | 21399.8 |
236 | 2023-03-24 22:20:12 | servant | 3 | 134027 | 219 | 7.186 | 18651.1 |
235 | 2023-03-19 21:50:38 | servant | 1 | 69583 | 2 | 1.280 | 54361.7 |
234 | 2023-03-03 23:07:14 | servant | 1 | 69583 | 2 | 1.110 | 62687.4 |
233 | 2023-02-14 04:27:10 | servant | 3 | 134027 | 219 | 5.950 | 22525.5 |
232 | 2022-12-26 06:26:36 | servant | 1 | 69583 | 2 | 1.190 | 58473.1 |
231 | 2022-12-22 07:18:33 | servant | 1 | 69583 | 2 | 1.250 | 55666.4 |
230 | 2022-11-26 14:10:08 | servant | 3 | 134027 | 219 | 5.860 | 22871.5 |
229 | 2022-09-14 21:18:00 | servant | 1 | 69583 | 2 | 1.110 | 62687.4 |
228 | 2022-09-14 08:19:17 | servant | 1 | 69583 | 2 | 1.266 | 54962.9 |
227 | 2022-08-18 14:15:02 | servant | 1 | 69583 | 2 | 1.173 | 59320.5 |
226 | 2022-07-18 20:20:11 | servant | 1 | 69583 | 2 | 1.110 | 62687.4 |
225 | 2022-07-18 01:08:45 | servant | 1 | 69583 | 2 | 1.093 | 63662.4 |
224 | 2022-07-14 04:10:15 | servant | 1 | 69583 | 2 | 1.093 | 63662.4 |
223 | 2022-07-03 05:37:11 | servant | 1 | 69583 | 2 | 1.110 | 62687.4 |
222 | 2022-06-09 01:57:56 | servant | 1 | 69583 | 2 | 1.110 | 62687.4 |
221 | 2022-04-26 22:53:30 | servant | 3 | 134027 | 219 | 6.093 | 21996.9 |
220 | 2022-04-14 15:42:43 | servant | 1 | 69583 | 2 | 1.610 | 43219.3 |
219 | 2022-03-12 01:55:18 | servant | 1 | 69583 | 2 | 1.173 | 59320.5 |
218 | 2022-01-08 11:44:10 | servant | 1 | 69583 | 2 | 1.186 | 58670.3 |
217 | 2021-12-20 11:20:45 | servant | 1 | 69583 | 2 | 2.766 | 25156.5 |
216 | 2021-08-31 04:36:55 | servant | 1 | 69583 | 2 | 1.093 | 63662.4 |
215 | 2021-05-29 13:28:58 | servant | 1 | 69583 | 2 | 1.280 | 54361.7 |
214 | 2021-05-23 19:18:43 | servant | 1 | 69583 | 2 | 1.203 | 57841.2 |
213 | 2021-05-04 01:55:33 | servant | 1 | 69583 | 2 | 1.233 | 56433.9 |
212 | 2021-04-02 05:22:04 | servant | 1 | 69583 | 2 | 1.140 | 61037.7 |
211 | 2021-02-27 01:12:03 | servant | 1 | 69583 | 2 | 1.283 | 54234.6 |
210 | 2021-02-17 23:37:27 | servant | 1 | 69583 | 2 | 1.266 | 54962.9 |
209 | 2021-02-10 18:55:06 | servant | 1 | 69583 | 2 | 1.110 | 62687.4 |
208 | 2020-11-08 17:47:23 | servant | 1 | 69583 | 2 | 1.140 | 61037.7 |
207 | 2020-10-31 22:10:58 | servant | 1 | 69583 | 2 | 1.343 | 51811.6 |
206 | 2020-10-19 05:04:28 | servant | 1 | 69583 | 2 | 1.173 | 59320.5 |
205 | 2020-08-30 14:43:43 | servant | 1 | 69583 | 2 | 1.186 | 58670.3 |
204 | 2020-07-31 07:04:46 | servant | 1 | 69583 | 2 | 1.173 | 59320.5 |
203 | 2020-04-28 20:08:26 | servant | 1 | 69583 | 2 | 1.156 | 60192.9 |
202 | 2020-03-31 10:42:39 | servant | 1 | 69583 | 2 | 1.110 | 62687.4 |
201 | 2020-03-28 15:36:56 | servant | 1 | 69583 | 2 | 2.673 | 26031.8 |
200 | 2020-03-24 21:35:46 | servant | 1 | 69583 | 2 | 1.313 | 52995.4 |
199 | 2020-03-24 02:37:51 | servant | 1 | 69583 | 2 | 1.313 | 52995.4 |
198 | 2020-03-19 23:53:31 | servant | 1 | 69583 | 2 | 1.203 | 57841.2 |
197 | 2020-03-18 23:03:32 | servant | 1 | 69583 | 2 | 1.280 | 54361.7 |
196 | 2020-02-28 10:58:24 | servant | 3 | 134027 | 219 | 15.453 | 8673.2 |
195 | 2020-02-28 06:45:52 | servant | 3 | 134027 | 219 | 11.423 | 11733.1 |
194 | 2020-02-28 05:13:20 | servant | 3 | 134027 | 219 | 6.546 | 20474.6 |
193 | 2020-02-28 01:30:30 | servant | 3 | 134027 | 219 | 8.016 | 16719.9 |
192 | 2020-02-27 15:45:37 | servant | 3 | 134027 | 219 | 7.736 | 17325.1 |
191 | 2020-02-27 11:15:35 | servant | 3 | 134027 | 219 | 7.500 | 17870.3 |
190 | 2020-02-23 23:39:16 | servant | 1 | 69583 | 2 | 1.390 | 50059.7 |
189 | 2020-02-12 14:59:18 | servant | 1 | 69583 | 2 | 3.453 | 20151.5 |
188 | 2020-02-10 10:29:06 | servant | 1 | 69583 | 2 | 2.500 | 27833.2 |
187 | 2020-02-05 13:38:44 | servant | 1 | 69583 | 2 | 1.360 | 51164.0 |
186 | 2020-02-04 10:54:52 | servant | 1 | 69583 | 2 | 1.296 | 53690.6 |
185 | 2020-02-02 21:17:55 | servant | 1 | 69583 | 2 | 1.356 | 51314.9 |
184 | 2020-01-27 23:54:26 | servant | 1 | 69583 | 2 | 1.280 | 54361.7 |
183 | 2020-01-27 12:54:44 | servant | 1 | 69583 | 2 | 1.530 | 45479.1 |
182 | 2020-01-25 00:59:17 | servant | 1 | 69583 | 2 | 1.546 | 45008.4 |
181 | 2020-01-20 10:19:13 | servant | 1 | 69583 | 2 | 2.906 | 23944.6 |
180 | 2020-01-18 10:02:00 | servant | 1 | 69583 | 2 | 1.390 | 50059.7 |
179 | 2020-01-14 02:08:19 | servant | 1 | 69583 | 2 | 3.860 | 18026.7 |
178 | 2020-01-13 12:36:29 | servant | 3 | 134027 | 219 | 7.766 | 17258.2 |
177 | 2020-01-13 09:21:13 | servant | 3 | 134027 | 219 | 16.266 | 8239.7 |
176 | 2020-01-13 04:04:06 | servant | 3 | 134027 | 219 | 7.500 | 17870.3 |
175 | 2020-01-13 02:11:02 | servant | 1 | 69583 | 2 | 1.393 | 49951.9 |
174 | 2020-01-01 16:54:47 | servant | 1 | 69583 | 2 | 1.420 | 49002.1 |
173 | 2019-12-27 01:59:18 | servant | 1 | 69583 | 2 | 1.390 | 50059.7 |
172 | 2019-12-27 01:49:44 | servant | 1 | 69583 | 2 | 2.330 | 29863.9 |
171 | 2019-12-24 13:17:44 | servant | 1 | 69583 | 2 | 1.123 | 61961.7 |
170 | 2019-10-23 11:48:30 | servant | 1 | 69583 | 2 | 1.220 | 57035.2 |
169 | 2019-07-22 11:43:17 | servant | 1 | 69583 | 2 | 1.123 | 61961.7 |
168 | 2019-06-09 18:57:24 | servant | 1 | 69583 | 2 | 1.300 | 53525.4 |