History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grandma"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
287 | 2024-04-17 05:04:58 | grandma | 1 | 69583 | 4 | 1.046 | 66522.9 |
286 | 2024-03-20 20:42:42 | grandma | 1 | 69583 | 4 | 2.826 | 24622.4 |
285 | 2024-03-14 14:13:51 | grandma | 3 | 134027 | 125 | 22.670 | 5912.1 |
284 | 2024-03-06 23:21:25 | grandma | 3 | 134027 | 125 | 20.280 | 6608.8 |
283 | 2024-03-06 16:58:46 | grandma | 2 | 107671 | 22 | 5.780 | 18628.2 |
282 | 2024-03-06 12:59:56 | grandma | 1 | 69583 | 4 | 1.266 | 54962.9 |
281 | 2024-03-06 12:59:43 | grandma | 3 | 134027 | 125 | 7.283 | 18402.7 |
280 | 2024-03-05 22:07:21 | grandma | 1 | 69583 | 4 | 3.326 | 20920.9 |
279 | 2024-02-29 06:00:59 | grandma | 3 | 134027 | 125 | 7.330 | 18284.7 |
278 | 2024-02-28 15:38:55 | grandma | 3 | 134027 | 125 | 21.626 | 6197.5 |
277 | 2024-02-28 15:38:56 | grandma | 2 | 107671 | 22 | 6.906 | 15590.9 |
276 | 2024-02-28 11:53:45 | grandma | 1 | 69583 | 4 | 1.750 | 39761.7 |
275 | 2024-02-02 08:08:47 | grandma | 2 | 107671 | 22 | 3.186 | 33795.0 |
274 | 2024-02-02 08:01:31 | grandma | 3 | 134027 | 125 | 7.016 | 19103.1 |
273 | 2024-01-12 04:34:33 | grandma | 3 | 134027 | 125 | 6.436 | 20824.6 |
272 | 2024-01-12 04:34:30 | grandma | 2 | 107671 | 22 | 3.403 | 31640.0 |
271 | 2024-01-01 09:15:31 | grandma | 1 | 69583 | 4 | 1.206 | 57697.3 |
270 | 2023-12-30 19:16:12 | grandma | 1 | 69583 | 4 | 1.076 | 64668.2 |
269 | 2023-12-07 09:48:55 | grandma | 1 | 69583 | 4 | 1.076 | 64668.2 |
268 | 2023-11-17 05:17:16 | grandma | 1 | 69583 | 4 | 1.110 | 62687.4 |
267 | 2023-11-06 22:47:46 | grandma | 1 | 69583 | 4 | 1.170 | 59472.6 |
266 | 2023-10-23 06:37:46 | grandma | 1 | 69583 | 4 | 1.050 | 66269.5 |
265 | 2023-09-29 10:58:36 | grandma | 1 | 69583 | 4 | 1.203 | 57841.2 |
264 | 2023-09-16 14:43:55 | grandma | 1 | 69583 | 4 | 1.046 | 66522.9 |
263 | 2023-08-18 17:15:16 | grandma | 1 | 69583 | 4 | 1.063 | 65459.1 |
262 | 2023-06-30 11:17:07 | grandma | 1 | 69583 | 4 | 1.123 | 61961.7 |
261 | 2023-06-26 17:42:10 | grandma | 1 | 69583 | 4 | 1.063 | 65459.1 |
260 | 2023-05-27 10:07:26 | grandma | 1 | 69583 | 4 | 1.063 | 65459.1 |
259 | 2023-05-20 07:29:40 | grandma | 1 | 69583 | 4 | 1.046 | 66522.9 |
258 | 2023-03-21 17:37:31 | grandma | 1 | 69583 | 4 | 1.046 | 66522.9 |
257 | 2023-03-15 12:57:53 | grandma | 1 | 69583 | 4 | 1.076 | 64668.2 |
256 | 2023-02-22 02:27:17 | grandma | 1 | 69583 | 4 | 1.046 | 66522.9 |
255 | 2023-01-03 21:50:07 | grandma | 1 | 69583 | 4 | 1.013 | 68690.0 |
254 | 2022-10-25 08:12:11 | grandma | 1 | 69583 | 4 | 1.110 | 62687.4 |
253 | 2022-09-26 03:53:32 | grandma | 1 | 69583 | 4 | 1.030 | 67556.3 |
252 | 2022-09-12 00:34:43 | grandma | 1 | 69583 | 4 | 1.030 | 67556.3 |
251 | 2022-09-08 07:04:02 | grandma | 1 | 69583 | 4 | 1.033 | 67360.1 |
250 | 2022-08-15 04:59:24 | grandma | 1 | 69583 | 4 | 1.140 | 61037.7 |
249 | 2022-08-06 20:32:52 | grandma | 1 | 69583 | 4 | 1.170 | 59472.6 |
248 | 2022-06-25 12:03:32 | grandma | 1 | 69583 | 4 | 1.093 | 63662.4 |
247 | 2022-06-25 02:00:46 | grandma | 1 | 69583 | 4 | 1.093 | 63662.4 |
246 | 2022-06-24 03:30:30 | grandma | 1 | 69583 | 4 | 1.046 | 66522.9 |
245 | 2022-05-11 07:19:53 | grandma | 1 | 69583 | 4 | 1.076 | 64668.2 |
244 | 2022-02-15 15:39:19 | grandma | 1 | 69583 | 4 | 1.033 | 67360.1 |
243 | 2022-02-14 10:39:07 | grandma | 1 | 69583 | 4 | 1.186 | 58670.3 |
242 | 2021-10-28 11:07:13 | grandma | 1 | 69583 | 4 | 1.220 | 57035.2 |
241 | 2021-07-18 04:19:24 | grandma | 1 | 69583 | 4 | 1.030 | 67556.3 |
240 | 2021-06-22 07:08:40 | grandma | 1 | 69583 | 4 | 1.250 | 55666.4 |
239 | 2021-06-06 11:50:08 | grandma | 1 | 69583 | 4 | 1.216 | 57222.9 |
238 | 2021-05-26 20:44:35 | grandma | 1 | 69583 | 4 | 1.376 | 50569.0 |
237 | 2021-05-12 12:42:22 | grandma | 1 | 69583 | 4 | 1.220 | 57035.2 |
236 | 2021-04-15 10:16:35 | grandma | 1 | 69583 | 4 | 1.186 | 58670.3 |
235 | 2021-04-02 20:57:09 | grandma | 1 | 69583 | 4 | 1.046 | 66522.9 |
234 | 2021-03-15 07:43:42 | grandma | 1 | 69583 | 4 | 1.080 | 64428.7 |
233 | 2021-02-16 19:10:51 | grandma | 1 | 69583 | 4 | 1.060 | 65644.3 |
232 | 2021-01-10 05:51:51 | grandma | 1 | 69583 | 4 | 1.046 | 66522.9 |
231 | 2021-01-05 17:59:31 | grandma | 1 | 69583 | 4 | 1.250 | 55666.4 |
230 | 2020-12-27 18:26:24 | grandma | 1 | 69583 | 4 | 1.156 | 60192.9 |
229 | 2020-11-04 04:19:45 | grandma | 1 | 69583 | 4 | 1.313 | 52995.4 |
228 | 2020-10-28 19:34:47 | grandma | 1 | 69583 | 4 | 1.093 | 63662.4 |
227 | 2020-10-23 16:47:28 | grandma | 1 | 69583 | 4 | 1.060 | 65644.3 |
226 | 2020-10-04 09:43:17 | grandma | 1 | 69583 | 4 | 1.156 | 60192.9 |
225 | 2020-08-28 16:10:07 | grandma | 1 | 69583 | 4 | 1.076 | 64668.2 |
224 | 2020-08-25 18:30:32 | grandma | 1 | 69583 | 4 | 1.110 | 62687.4 |
223 | 2020-08-22 20:44:12 | grandma | 1 | 69583 | 4 | 1.173 | 59320.5 |
222 | 2020-06-17 01:38:01 | grandma | 1 | 69583 | 4 | 1.153 | 60349.5 |
221 | 2020-05-22 18:49:25 | grandma | 1 | 69583 | 4 | 1.046 | 66522.9 |
220 | 2020-03-28 06:53:32 | grandma | 1 | 69583 | 4 | 1.280 | 54361.7 |
219 | 2020-03-22 02:31:14 | grandma | 1 | 69583 | 4 | 1.173 | 59320.5 |
218 | 2020-03-09 11:50:27 | grandma | 1 | 69583 | 4 | 1.076 | 64668.2 |
217 | 2020-03-04 23:46:55 | grandma | 1 | 69583 | 4 | 1.190 | 58473.1 |
216 | 2020-02-28 00:28:47 | grandma | 3 | 134027 | 125 | 11.220 | 11945.4 |
215 | 2020-02-27 14:14:10 | grandma | 2 | 107671 | 22 | 6.156 | 17490.4 |
214 | 2020-02-27 12:17:44 | grandma | 2 | 107671 | 22 | 11.593 | 9287.6 |
213 | 2020-02-25 11:38:32 | grandma | 1 | 69583 | 4 | 2.623 | 26528.0 |
212 | 2020-02-25 04:25:16 | grandma | 1 | 69583 | 4 | 1.126 | 61796.6 |
211 | 2020-02-24 07:40:55 | grandma | 1 | 69583 | 4 | 1.233 | 56433.9 |
210 | 2020-02-20 06:19:38 | grandma | 1 | 69583 | 4 | 1.343 | 51811.6 |
209 | 2020-02-20 03:24:00 | grandma | 1 | 69583 | 4 | 1.173 | 59320.5 |
208 | 2020-02-18 19:46:08 | grandma | 1 | 69583 | 4 | 1.266 | 54962.9 |
207 | 2020-02-10 00:42:18 | grandma | 3 | 134027 | 125 | 6.703 | 19995.1 |
206 | 2020-02-07 22:04:35 | grandma | 1 | 69583 | 4 | 1.313 | 52995.4 |
205 | 2020-01-31 17:14:26 | grandma | 2 | 107671 | 22 | 6.860 | 15695.5 |
204 | 2020-01-30 22:47:10 | grandma | 3 | 134027 | 125 | 8.940 | 14991.8 |
203 | 2020-01-30 13:56:27 | grandma | 3 | 134027 | 125 | 13.393 | 10007.2 |
202 | 2020-01-29 01:00:46 | grandma | 1 | 69583 | 4 | 1.360 | 51164.0 |
201 | 2020-01-28 05:57:24 | grandma | 2 | 107671 | 22 | 9.110 | 11819.0 |
200 | 2020-01-27 01:24:15 | grandma | 3 | 134027 | 125 | 15.313 | 8752.5 |
199 | 2020-01-25 10:36:04 | grandma | 1 | 69583 | 4 | 1.390 | 50059.7 |
198 | 2020-01-24 19:06:46 | grandma | 1 | 69583 | 4 | 2.766 | 25156.5 |
197 | 2020-01-23 18:46:03 | grandma | 3 | 134027 | 125 | 13.893 | 9647.1 |
196 | 2020-01-22 16:12:11 | grandma | 1 | 69583 | 4 | 1.610 | 43219.3 |
195 | 2020-01-17 01:27:39 | grandma | 2 | 107671 | 22 | 3.376 | 31893.1 |
194 | 2020-01-16 20:34:15 | grandma | 1 | 69583 | 4 | 1.423 | 48898.8 |
193 | 2020-01-08 19:29:31 | grandma | 1 | 69583 | 4 | 1.046 | 66522.9 |
192 | 2020-01-07 13:21:16 | grandma | 3 | 134027 | 125 | 9.986 | 13421.5 |
191 | 2020-01-07 06:22:36 | grandma | 3 | 134027 | 125 | 11.500 | 11654.5 |
190 | 2020-01-07 06:21:45 | grandma | 2 | 107671 | 22 | 3.343 | 32207.9 |
189 | 2020-01-06 23:46:55 | grandma | 1 | 69583 | 4 | 1.233 | 56433.9 |
188 | 2019-12-30 19:12:14 | grandma | 1 | 69583 | 4 | 1.266 | 54962.9 |