History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grandad"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
273 | 2024-05-07 13:45:24 | grandad | 2 | 107671 | 26 | 8.956 | 12022.2 |
272 | 2024-05-07 13:44:44 | grandad | 3 | 134027 | 204 | 15.216 | 8808.3 |
271 | 2024-05-07 13:10:20 | grandad | 1 | 69583 | 4 | 1.186 | 58670.3 |
270 | 2024-05-07 08:59:39 | grandad | 2 | 107671 | 26 | 3.470 | 31029.1 |
269 | 2024-05-07 08:03:25 | grandad | 2 | 107671 | 26 | 4.876 | 22081.8 |
268 | 2024-05-07 07:58:51 | grandad | 3 | 134027 | 204 | 11.140 | 12031.1 |
267 | 2024-05-06 03:04:07 | grandad | 3 | 134027 | 204 | 6.766 | 19808.9 |
266 | 2024-05-05 22:05:31 | grandad | 3 | 134027 | 204 | 17.783 | 7536.8 |
265 | 2024-05-05 21:38:16 | grandad | 2 | 107671 | 26 | 7.610 | 14148.6 |
264 | 2024-05-05 21:38:09 | grandad | 1 | 69583 | 4 | 1.356 | 51314.9 |
263 | 2024-05-05 21:37:33 | grandad | 3 | 134027 | 204 | 17.143 | 7818.2 |
262 | 2024-05-05 21:00:47 | grandad | 3 | 134027 | 204 | 10.220 | 13114.2 |
261 | 2024-05-05 20:57:32 | grandad | 2 | 107671 | 26 | 3.813 | 28237.9 |
260 | 2024-05-04 22:14:32 | grandad | 2 | 107671 | 26 | 12.873 | 8364.1 |
259 | 2024-05-03 19:11:24 | grandad | 1 | 69583 | 4 | 2.296 | 30306.2 |
258 | 2024-05-02 05:29:32 | grandad | 1 | 69583 | 4 | 1.796 | 38743.3 |
257 | 2024-04-29 09:10:59 | grandad | 1 | 69583 | 4 | 4.060 | 17138.7 |
256 | 2024-04-27 23:04:59 | grandad | 1 | 69583 | 4 | 4.393 | 15839.5 |
255 | 2024-04-15 08:58:17 | grandad | 1 | 69583 | 4 | 1.046 | 66522.9 |
254 | 2024-04-05 17:24:49 | grandad | 3 | 134027 | 204 | 9.656 | 13880.2 |
253 | 2024-04-02 18:45:46 | grandad | 3 | 134027 | 204 | 12.436 | 10777.3 |
252 | 2024-04-01 16:39:35 | grandad | 3 | 134027 | 204 | 11.420 | 11736.2 |
251 | 2024-04-01 14:04:45 | grandad | 2 | 107671 | 26 | 3.733 | 28843.0 |
250 | 2024-03-30 07:56:35 | grandad | 3 | 134027 | 204 | 7.470 | 17942.0 |
249 | 2024-03-30 05:06:04 | grandad | 3 | 134027 | 204 | 8.033 | 16684.6 |
248 | 2024-03-30 05:05:43 | grandad | 1 | 69583 | 4 | 2.813 | 24736.2 |
247 | 2024-03-06 18:55:02 | grandad | 1 | 69583 | 4 | 1.266 | 54962.9 |
246 | 2024-03-06 16:58:10 | grandad | 3 | 134027 | 204 | 7.143 | 18763.4 |
245 | 2024-03-02 18:06:00 | grandad | 3 | 134027 | 204 | 19.060 | 7031.8 |
244 | 2024-03-02 11:17:05 | grandad | 2 | 107671 | 26 | 7.390 | 14569.8 |
243 | 2024-03-02 11:17:03 | grandad | 3 | 134027 | 204 | 8.470 | 15823.7 |
242 | 2024-02-29 00:50:08 | grandad | 3 | 134027 | 204 | 7.423 | 18055.6 |
241 | 2024-02-28 15:11:33 | grandad | 2 | 107671 | 26 | 20.923 | 5146.1 |
240 | 2024-02-28 15:11:31 | grandad | 3 | 134027 | 204 | 15.060 | 8899.5 |
239 | 2024-02-28 13:36:20 | grandad | 1 | 69583 | 4 | 2.486 | 27989.9 |
238 | 2024-01-16 14:57:27 | grandad | 1 | 69583 | 4 | 1.076 | 64668.2 |
237 | 2023-12-30 19:15:56 | grandad | 1 | 69583 | 4 | 1.233 | 56433.9 |
236 | 2023-12-29 04:36:26 | grandad | 1 | 69583 | 4 | 1.033 | 67360.1 |
235 | 2023-12-29 04:14:51 | grandad | 1 | 69583 | 4 | 1.330 | 52318.0 |
234 | 2023-12-07 09:48:20 | grandad | 1 | 69583 | 4 | 2.236 | 31119.4 |
233 | 2023-12-05 12:29:42 | grandad | 2 | 107671 | 26 | 2.780 | 38730.6 |
232 | 2023-12-01 06:12:16 | grandad | 1 | 69583 | 4 | 1.050 | 66269.5 |
231 | 2023-11-05 04:42:18 | grandad | 1 | 69583 | 4 | 1.030 | 67556.3 |
230 | 2023-10-18 23:34:42 | grandad | 1 | 69583 | 4 | 1.063 | 65459.1 |
229 | 2023-10-01 03:15:29 | grandad | 1 | 69583 | 4 | 1.063 | 65459.1 |
228 | 2023-09-15 03:34:37 | grandad | 1 | 69583 | 4 | 1.266 | 54962.9 |
227 | 2023-09-13 04:48:23 | grandad | 1 | 69583 | 4 | 1.236 | 56296.9 |
226 | 2023-09-09 20:54:32 | grandad | 1 | 69583 | 4 | 1.156 | 60192.9 |
225 | 2023-09-02 18:12:09 | grandad | 2 | 107671 | 26 | 3.356 | 32083.1 |
224 | 2023-08-14 01:26:43 | grandad | 1 | 69583 | 4 | 1.170 | 59472.6 |
223 | 2023-05-23 13:16:10 | grandad | 2 | 107671 | 26 | 2.830 | 38046.3 |
222 | 2023-05-17 04:31:08 | grandad | 1 | 69583 | 4 | 1.156 | 60192.9 |
221 | 2023-05-14 05:52:27 | grandad | 1 | 69583 | 4 | 1.030 | 67556.3 |
220 | 2023-03-09 23:27:04 | grandad | 1 | 69583 | 4 | 1.016 | 68487.2 |
219 | 2023-03-04 08:08:21 | grandad | 1 | 69583 | 4 | 1.156 | 60192.9 |
218 | 2023-03-03 10:18:17 | grandad | 2 | 107671 | 26 | 2.796 | 38508.9 |
217 | 2023-01-24 04:10:19 | grandad | 1 | 69583 | 4 | 1.046 | 66522.9 |
216 | 2022-12-29 05:32:50 | grandad | 1 | 69583 | 4 | 1.030 | 67556.3 |
215 | 2022-12-10 21:45:17 | grandad | 2 | 107671 | 26 | 3.140 | 34290.1 |
214 | 2022-09-21 20:22:08 | grandad | 1 | 69583 | 4 | 1.080 | 64428.7 |
213 | 2022-09-18 01:46:56 | grandad | 1 | 69583 | 4 | 1.080 | 64428.7 |
212 | 2022-09-12 00:35:19 | grandad | 1 | 69583 | 4 | 1.063 | 65459.1 |
211 | 2022-08-15 04:59:41 | grandad | 1 | 69583 | 4 | 1.063 | 65459.1 |
210 | 2022-08-06 20:33:09 | grandad | 1 | 69583 | 4 | 1.186 | 58670.3 |
209 | 2022-07-29 13:00:47 | grandad | 1 | 69583 | 4 | 1.046 | 66522.9 |
208 | 2022-07-03 11:38:14 | grandad | 2 | 107671 | 26 | 2.876 | 37437.8 |
207 | 2022-06-25 12:03:52 | grandad | 1 | 69583 | 4 | 1.030 | 67556.3 |
206 | 2022-06-25 02:01:09 | grandad | 1 | 69583 | 4 | 1.063 | 65459.1 |
205 | 2022-05-26 05:45:52 | grandad | 1 | 69583 | 4 | 1.093 | 63662.4 |
204 | 2022-05-16 03:35:17 | grandad | 1 | 69583 | 4 | 1.063 | 65459.1 |
203 | 2022-04-25 08:03:21 | grandad | 1 | 69583 | 4 | 1.126 | 61796.6 |
202 | 2022-04-23 00:46:43 | grandad | 1 | 69583 | 4 | 1.516 | 45899.1 |
201 | 2022-02-27 16:57:32 | grandad | 2 | 107671 | 26 | 2.843 | 37872.3 |
200 | 2022-01-24 18:09:02 | grandad | 1 | 69583 | 4 | 2.156 | 32274.1 |
199 | 2022-01-16 15:20:06 | grandad | 1 | 69583 | 4 | 1.186 | 58670.3 |
198 | 2021-12-23 01:42:17 | grandad | 1 | 69583 | 4 | 1.173 | 59320.5 |
197 | 2021-11-26 22:51:25 | grandad | 1 | 69583 | 4 | 1.110 | 62687.4 |
196 | 2021-11-10 21:19:21 | grandad | 1 | 69583 | 4 | 1.170 | 59472.6 |
195 | 2021-10-11 11:56:01 | grandad | 1 | 69583 | 4 | 1.236 | 56296.9 |
194 | 2021-07-10 04:37:21 | grandad | 1 | 69583 | 4 | 1.233 | 56433.9 |
193 | 2021-07-09 23:33:09 | grandad | 1 | 69583 | 4 | 1.216 | 57222.9 |
192 | 2021-05-24 12:08:05 | grandad | 1 | 69583 | 4 | 1.063 | 65459.1 |
191 | 2021-05-15 08:55:24 | grandad | 1 | 69583 | 4 | 1.250 | 55666.4 |
190 | 2021-04-27 18:10:56 | grandad | 1 | 69583 | 4 | 1.250 | 55666.4 |
189 | 2021-04-06 03:14:58 | grandad | 1 | 69583 | 4 | 1.250 | 55666.4 |
188 | 2021-04-01 23:30:55 | grandad | 1 | 69583 | 4 | 1.123 | 61961.7 |
187 | 2021-03-27 17:59:12 | grandad | 1 | 69583 | 4 | 1.063 | 65459.1 |
186 | 2021-03-18 03:28:06 | grandad | 1 | 69583 | 4 | 1.173 | 59320.5 |
185 | 2021-02-11 10:19:53 | grandad | 1 | 69583 | 4 | 1.173 | 59320.5 |
184 | 2021-01-11 01:36:00 | grandad | 1 | 69583 | 4 | 1.060 | 65644.3 |
183 | 2020-12-24 17:04:36 | grandad | 1 | 69583 | 4 | 1.156 | 60192.9 |
182 | 2020-11-08 11:55:11 | grandad | 1 | 69583 | 4 | 1.153 | 60349.5 |
181 | 2020-11-03 19:28:42 | grandad | 1 | 69583 | 4 | 1.170 | 59472.6 |
180 | 2020-11-01 19:40:53 | grandad | 1 | 69583 | 4 | 1.076 | 64668.2 |
179 | 2020-10-26 05:58:22 | grandad | 1 | 69583 | 4 | 1.123 | 61961.7 |
178 | 2020-09-29 04:23:39 | grandad | 1 | 69583 | 4 | 1.046 | 66522.9 |
177 | 2020-09-20 20:59:21 | grandad | 1 | 69583 | 4 | 1.046 | 66522.9 |
176 | 2020-07-21 20:40:55 | grandad | 1 | 69583 | 4 | 1.236 | 56296.9 |
175 | 2020-07-18 08:28:36 | grandad | 1 | 69583 | 4 | 1.266 | 54962.9 |
174 | 2020-06-07 08:33:55 | grandad | 1 | 69583 | 4 | 1.093 | 63662.4 |