History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"consult"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
338 | 2024-04-22 05:31:04 | consult | 1 | 69583 | 4 | 1.250 | 55666.4 |
337 | 2024-04-08 05:24:36 | consult | 3 | 134027 | 138 | 10.530 | 12728.1 |
336 | 2024-04-07 20:33:55 | consult | 3 | 134027 | 138 | 18.173 | 7375.1 |
335 | 2024-04-07 16:03:27 | consult | 3 | 134027 | 138 | 15.473 | 8662.0 |
334 | 2024-04-05 17:21:12 | consult | 3 | 134027 | 138 | 14.186 | 9447.8 |
333 | 2024-04-05 10:43:29 | consult | 3 | 134027 | 138 | 9.873 | 13575.1 |
332 | 2024-04-05 10:25:15 | consult | 3 | 134027 | 138 | 8.780 | 15265.0 |
331 | 2024-03-17 18:30:15 | consult | 1 | 69583 | 4 | 2.720 | 25582.0 |
330 | 2024-01-15 11:02:48 | consult | 3 | 134027 | 138 | 6.236 | 21492.5 |
329 | 2024-01-15 11:02:49 | consult | 2 | 107671 | 21 | 3.453 | 31181.9 |
328 | 2024-01-02 09:01:28 | consult | 1 | 69583 | 4 | 1.110 | 62687.4 |
327 | 2023-12-22 17:42:50 | consult | 1 | 69583 | 4 | 1.280 | 54361.7 |
326 | 2023-12-06 20:25:22 | consult | 3 | 134027 | 138 | 6.830 | 19623.3 |
325 | 2023-12-03 21:46:22 | consult | 1 | 69583 | 4 | 1.343 | 51811.6 |
324 | 2023-11-19 16:19:13 | consult | 1 | 69583 | 4 | 1.203 | 57841.2 |
323 | 2023-11-16 22:32:30 | consult | 1 | 69583 | 4 | 1.283 | 54234.6 |
322 | 2023-11-02 07:12:37 | consult | 1 | 69583 | 4 | 1.390 | 50059.7 |
321 | 2023-10-24 23:22:40 | consult | 1 | 69583 | 4 | 1.873 | 37150.6 |
320 | 2023-10-24 05:49:56 | consult | 1 | 69583 | 4 | 1.220 | 57035.2 |
319 | 2023-10-15 11:44:28 | consult | 1 | 69583 | 4 | 1.186 | 58670.3 |
318 | 2023-09-23 01:10:58 | consult | 1 | 69583 | 4 | 2.436 | 28564.4 |
317 | 2023-09-18 23:42:32 | consult | 1 | 69583 | 4 | 1.280 | 54361.7 |
316 | 2023-09-05 05:53:45 | consult | 3 | 134027 | 138 | 6.720 | 19944.5 |
315 | 2023-08-23 09:15:21 | consult | 1 | 69583 | 4 | 1.140 | 61037.7 |
314 | 2023-08-20 03:47:38 | consult | 1 | 69583 | 4 | 1.140 | 61037.7 |
313 | 2023-08-20 02:14:45 | consult | 1 | 69583 | 4 | 1.156 | 60192.9 |
312 | 2023-05-20 12:09:24 | consult | 1 | 69583 | 4 | 1.110 | 62687.4 |
311 | 2023-05-13 06:39:22 | consult | 1 | 69583 | 4 | 1.063 | 65459.1 |
310 | 2023-03-15 00:15:18 | consult | 1 | 69583 | 4 | 1.080 | 64428.7 |
309 | 2023-02-14 13:56:36 | consult | 3 | 134027 | 138 | 6.563 | 20421.6 |
308 | 2023-02-06 23:09:21 | consult | 1 | 69583 | 4 | 1.186 | 58670.3 |
307 | 2023-01-04 07:11:26 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
306 | 2022-11-25 21:11:13 | consult | 3 | 134027 | 138 | 5.703 | 23501.1 |
305 | 2022-10-13 04:06:42 | consult | 1 | 69583 | 4 | 1.266 | 54962.9 |
304 | 2022-09-24 01:04:21 | consult | 1 | 69583 | 4 | 1.190 | 58473.1 |
303 | 2022-07-14 19:27:17 | consult | 2 | 107671 | 21 | 2.860 | 37647.2 |
302 | 2022-06-19 02:17:58 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
301 | 2022-05-22 10:01:10 | consult | 1 | 69583 | 4 | 1.330 | 52318.0 |
300 | 2022-05-07 06:32:00 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
299 | 2022-04-26 14:39:45 | consult | 1 | 69583 | 4 | 1.263 | 55093.4 |
298 | 2022-04-21 03:11:55 | consult | 3 | 134027 | 138 | 11.810 | 11348.6 |
297 | 2022-04-19 00:20:07 | consult | 3 | 134027 | 138 | 6.796 | 19721.5 |
296 | 2022-03-03 11:33:57 | consult | 1 | 69583 | 4 | 1.656 | 42018.7 |
295 | 2022-01-28 11:47:30 | consult | 1 | 69583 | 4 | 1.283 | 54234.6 |
294 | 2021-11-25 20:15:00 | consult | 1 | 69583 | 4 | 1.280 | 54361.7 |
293 | 2021-11-23 17:20:42 | consult | 1 | 69583 | 4 | 1.126 | 61796.6 |
292 | 2021-11-23 06:32:23 | consult | 1 | 69583 | 4 | 1.123 | 61961.7 |
291 | 2021-11-10 18:27:19 | consult | 1 | 69583 | 4 | 1.653 | 42095.0 |
290 | 2021-11-10 11:25:10 | consult | 1 | 69583 | 4 | 1.110 | 62687.4 |
289 | 2021-11-10 00:33:32 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
288 | 2021-11-09 10:01:05 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
287 | 2021-11-08 13:12:30 | consult | 1 | 69583 | 4 | 1.250 | 55666.4 |
286 | 2021-11-08 02:35:23 | consult | 1 | 69583 | 4 | 1.186 | 58670.3 |
285 | 2021-10-23 20:42:19 | consult | 1 | 69583 | 4 | 1.280 | 54361.7 |
284 | 2021-10-21 20:25:06 | consult | 1 | 69583 | 4 | 1.110 | 62687.4 |
283 | 2021-10-09 22:44:49 | consult | 1 | 69583 | 4 | 1.250 | 55666.4 |
282 | 2021-10-08 18:58:03 | consult | 1 | 69583 | 4 | 1.296 | 53690.6 |
281 | 2021-10-07 18:15:08 | consult | 1 | 69583 | 4 | 1.250 | 55666.4 |
280 | 2021-10-06 19:11:00 | consult | 1 | 69583 | 4 | 1.326 | 52475.9 |
279 | 2021-10-05 16:53:55 | consult | 1 | 69583 | 4 | 1.126 | 61796.6 |
278 | 2021-10-04 21:37:48 | consult | 1 | 69583 | 4 | 1.263 | 55093.4 |
277 | 2021-10-03 18:35:32 | consult | 1 | 69583 | 4 | 1.110 | 62687.4 |
276 | 2021-10-02 18:19:09 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
275 | 2021-09-18 09:44:41 | consult | 1 | 69583 | 4 | 1.080 | 64428.7 |
274 | 2021-09-17 17:37:29 | consult | 1 | 69583 | 4 | 1.233 | 56433.9 |
273 | 2021-09-17 06:24:24 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
272 | 2021-09-10 13:05:16 | consult | 1 | 69583 | 4 | 1.110 | 62687.4 |
271 | 2021-08-20 06:34:54 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
270 | 2021-07-20 06:55:16 | consult | 2 | 107671 | 21 | 3.216 | 33479.8 |
269 | 2021-05-31 07:22:05 | consult | 1 | 69583 | 4 | 2.233 | 31161.2 |
268 | 2021-05-19 13:14:32 | consult | 1 | 69583 | 4 | 1.110 | 62687.4 |
267 | 2021-05-15 18:04:58 | consult | 3 | 134027 | 138 | 6.003 | 22326.7 |
266 | 2021-05-09 13:31:13 | consult | 2 | 107671 | 21 | 3.546 | 30364.1 |
265 | 2021-05-06 01:53:18 | consult | 1 | 69583 | 4 | 1.250 | 55666.4 |
264 | 2021-02-26 15:32:07 | consult | 1 | 69583 | 4 | 1.266 | 54962.9 |
263 | 2021-02-21 09:12:48 | consult | 3 | 134027 | 138 | 6.360 | 21073.4 |
262 | 2021-02-16 15:39:49 | consult | 1 | 69583 | 4 | 1.266 | 54962.9 |
261 | 2021-01-27 17:57:35 | consult | 1 | 69583 | 4 | 1.126 | 61796.6 |
260 | 2021-01-23 03:41:36 | consult | 2 | 107671 | 21 | 2.910 | 37000.3 |
259 | 2021-01-19 14:57:11 | consult | 1 | 69583 | 4 | 1.140 | 61037.7 |
258 | 2020-12-20 03:13:06 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
257 | 2020-11-12 09:18:30 | consult | 1 | 69583 | 4 | 1.216 | 57222.9 |
256 | 2020-11-08 05:30:55 | consult | 1 | 69583 | 4 | 1.220 | 57035.2 |
255 | 2020-11-03 07:11:45 | consult | 2 | 107671 | 21 | 2.966 | 36301.8 |
254 | 2020-10-03 15:52:01 | consult | 1 | 69583 | 4 | 1.076 | 64668.2 |
253 | 2020-08-31 15:01:05 | consult | 1 | 69583 | 4 | 1.186 | 58670.3 |
252 | 2020-08-23 02:12:03 | consult | 1 | 69583 | 4 | 1.250 | 55666.4 |
251 | 2020-08-05 21:25:40 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
250 | 2020-08-02 01:46:36 | consult | 1 | 69583 | 4 | 1.203 | 57841.2 |
249 | 2020-07-29 21:43:23 | consult | 1 | 69583 | 4 | 1.280 | 54361.7 |
248 | 2020-07-28 04:11:38 | consult | 1 | 69583 | 4 | 2.516 | 27656.2 |
247 | 2020-07-26 06:06:38 | consult | 1 | 69583 | 4 | 1.126 | 61796.6 |
246 | 2020-06-02 07:05:58 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
245 | 2020-06-01 06:45:53 | consult | 1 | 69583 | 4 | 1.296 | 53690.6 |
244 | 2020-05-07 15:50:22 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |
243 | 2020-04-27 00:51:36 | consult | 1 | 69583 | 4 | 1.096 | 63488.1 |
242 | 2020-04-18 01:25:28 | consult | 1 | 69583 | 4 | 1.280 | 54361.7 |
241 | 2020-04-17 02:06:48 | consult | 1 | 69583 | 4 | 1.203 | 57841.2 |
240 | 2020-04-16 02:06:18 | consult | 1 | 69583 | 4 | 1.170 | 59472.6 |
239 | 2020-04-15 01:23:37 | consult | 1 | 69583 | 4 | 1.093 | 63662.4 |