History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"occur"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
324 | 2024-04-20 15:24:02 | occur | 1 | 28756 | 2 | 0.593 | 48492.4 |
323 | 2024-04-06 13:42:47 | occur | 1 | 28756 | 2 | 0.420 | 68466.7 |
322 | 2024-03-31 21:26:56 | occur | 2 | 53800 | 17 | 4.720 | 11398.3 |
321 | 2024-03-31 15:19:24 | occur | 1 | 28756 | 2 | 0.923 | 31154.9 |
320 | 2024-03-28 20:33:31 | occur | 1 | 28756 | 2 | 1.046 | 27491.4 |
319 | 2024-03-07 08:31:01 | occur | 2 | 53800 | 17 | 3.766 | 14285.7 |
318 | 2024-03-07 05:15:01 | occur | 1 | 28756 | 2 | 0.516 | 55728.7 |
317 | 2024-03-06 23:15:41 | occur | 3 | 83667 | 285 | 13.923 | 6009.3 |
316 | 2024-03-05 21:50:53 | occur | 3 | 83667 | 285 | 3.873 | 21602.6 |
315 | 2024-03-01 12:49:35 | occur | 1 | 28756 | 2 | 0.483 | 59536.2 |
314 | 2024-03-01 04:10:32 | occur | 2 | 53800 | 17 | 1.360 | 39558.8 |
313 | 2024-03-01 04:10:24 | occur | 3 | 83667 | 285 | 3.563 | 23482.2 |
312 | 2024-02-28 06:26:16 | occur | 2 | 53800 | 17 | 1.890 | 28465.6 |
311 | 2024-02-28 06:26:02 | occur | 3 | 83667 | 285 | 4.330 | 19322.6 |
310 | 2024-02-27 12:03:08 | occur | 3 | 83667 | 285 | 9.156 | 9137.9 |
309 | 2024-02-26 04:10:07 | occur | 3 | 83667 | 285 | 8.923 | 9376.6 |
308 | 2024-02-26 04:10:06 | occur | 2 | 53800 | 17 | 3.546 | 15172.0 |
307 | 2024-02-26 04:05:55 | occur | 1 | 28756 | 2 | 0.470 | 61183.0 |
306 | 2024-02-04 02:08:07 | occur | 1 | 28756 | 2 | 0.500 | 57512.0 |
305 | 2024-01-29 04:29:07 | occur | 1 | 28756 | 2 | 0.486 | 59168.7 |
304 | 2024-01-26 22:34:17 | occur | 1 | 28756 | 2 | 0.500 | 57512.0 |
303 | 2024-01-16 23:11:28 | occur | 3 | 83667 | 285 | 3.796 | 22040.8 |
302 | 2024-01-16 23:11:29 | occur | 2 | 53800 | 17 | 1.640 | 32804.9 |
301 | 2024-01-03 08:11:00 | occur | 1 | 28756 | 2 | 0.500 | 57512.0 |
300 | 2023-12-18 09:12:39 | occur | 2 | 53800 | 17 | 2.186 | 24611.2 |
299 | 2023-12-18 09:12:36 | occur | 3 | 83667 | 285 | 4.483 | 18663.2 |
298 | 2023-12-06 03:48:48 | occur | 3 | 83667 | 285 | 3.280 | 25508.2 |
297 | 2023-12-06 03:48:46 | occur | 2 | 53800 | 17 | 1.563 | 34421.0 |
296 | 2023-12-05 22:13:20 | occur | 2 | 53800 | 17 | 1.406 | 38264.6 |
295 | 2023-11-24 09:06:40 | occur | 3 | 83667 | 285 | 3.250 | 25743.7 |
294 | 2023-11-17 15:25:14 | occur | 1 | 28756 | 2 | 0.486 | 59168.7 |
293 | 2023-11-12 02:51:39 | occur | 1 | 28756 | 2 | 0.436 | 65954.1 |
292 | 2023-11-02 04:31:16 | occur | 3 | 83667 | 285 | 3.376 | 24782.9 |
291 | 2023-11-02 04:31:14 | occur | 2 | 53800 | 17 | 1.343 | 40059.6 |
290 | 2023-10-31 08:47:17 | occur | 2 | 53800 | 17 | 1.360 | 39558.8 |
289 | 2023-10-31 08:47:14 | occur | 3 | 83667 | 285 | 3.250 | 25743.7 |
288 | 2023-10-28 03:38:32 | occur | 1 | 28756 | 2 | 0.486 | 59168.7 |
287 | 2023-10-26 08:25:01 | occur | 1 | 28756 | 2 | 0.440 | 65354.5 |
286 | 2023-10-21 06:30:51 | occur | 1 | 28756 | 2 | 0.720 | 39938.9 |
285 | 2023-10-20 22:07:32 | occur | 1 | 28756 | 2 | 0.453 | 63479.0 |
284 | 2023-10-11 01:52:39 | occur | 1 | 28756 | 2 | 0.436 | 65954.1 |
283 | 2023-10-04 14:10:18 | occur | 1 | 28756 | 2 | 0.453 | 63479.0 |
282 | 2023-09-28 22:36:55 | occur | 1 | 28756 | 2 | 0.500 | 57512.0 |
281 | 2023-09-25 03:33:42 | occur | 1 | 28756 | 2 | 0.486 | 59168.7 |
280 | 2023-09-22 07:19:53 | occur | 1 | 28756 | 2 | 0.563 | 51076.4 |
279 | 2023-09-04 00:17:59 | occur | 2 | 53800 | 17 | 1.420 | 37887.3 |
278 | 2023-08-24 04:47:33 | occur | 3 | 83667 | 285 | 3.203 | 26121.4 |
277 | 2023-08-20 15:31:18 | occur | 1 | 28756 | 2 | 0.470 | 61183.0 |
276 | 2023-05-22 22:03:30 | occur | 1 | 28756 | 2 | 0.953 | 30174.2 |
275 | 2023-05-19 18:45:41 | occur | 1 | 28756 | 2 | 0.436 | 65954.1 |
274 | 2023-05-08 06:09:17 | occur | 3 | 83667 | 285 | 3.203 | 26121.4 |
273 | 2023-03-20 06:18:55 | occur | 1 | 28756 | 2 | 0.470 | 61183.0 |
272 | 2023-02-14 11:15:01 | occur | 3 | 83667 | 285 | 3.233 | 25879.1 |
271 | 2023-01-19 14:01:23 | occur | 1 | 28756 | 2 | 0.423 | 67981.1 |
270 | 2023-01-07 03:36:19 | occur | 1 | 28756 | 2 | 0.436 | 65954.1 |
269 | 2022-12-24 06:26:09 | occur | 2 | 53800 | 17 | 1.530 | 35163.4 |
268 | 2022-12-18 16:06:30 | occur | 1 | 28756 | 2 | 0.483 | 59536.2 |
267 | 2022-11-26 17:03:11 | occur | 3 | 83667 | 285 | 3.190 | 26227.9 |
266 | 2022-11-12 14:13:51 | occur | 1 | 28756 | 2 | 0.453 | 63479.0 |
265 | 2022-09-29 05:17:32 | occur | 1 | 28756 | 2 | 0.436 | 65954.1 |
264 | 2022-09-19 21:37:39 | occur | 1 | 28756 | 2 | 0.500 | 57512.0 |
263 | 2022-09-13 20:00:41 | occur | 1 | 28756 | 2 | 0.436 | 65954.1 |
262 | 2022-08-24 04:19:38 | occur | 2 | 53800 | 17 | 1.356 | 39675.5 |
261 | 2022-08-16 00:24:32 | occur | 1 | 28756 | 2 | 0.453 | 63479.0 |
260 | 2022-08-14 19:51:04 | occur | 1 | 28756 | 2 | 0.440 | 65354.5 |
259 | 2022-07-30 10:03:39 | occur | 1 | 28756 | 2 | 0.470 | 61183.0 |
258 | 2022-07-29 04:02:16 | occur | 1 | 28756 | 2 | 0.453 | 63479.0 |
257 | 2022-05-16 22:18:10 | occur | 1 | 28756 | 2 | 0.500 | 57512.0 |
256 | 2022-04-30 22:21:54 | occur | 1 | 28756 | 2 | 0.483 | 59536.2 |
255 | 2022-04-29 22:44:03 | occur | 3 | 83667 | 285 | 3.500 | 23904.9 |
254 | 2022-02-04 21:20:18 | occur | 1 | 28756 | 2 | 0.450 | 63902.2 |
253 | 2022-01-10 13:56:53 | occur | 1 | 28756 | 2 | 0.500 | 57512.0 |
252 | 2021-12-28 15:09:52 | occur | 3 | 83667 | 285 | 4.063 | 20592.4 |
251 | 2021-12-05 01:27:14 | occur | 1 | 28756 | 2 | 0.483 | 59536.2 |
250 | 2021-10-12 10:13:36 | occur | 1 | 28756 | 2 | 0.440 | 65354.5 |
249 | 2021-09-21 15:10:22 | occur | 1 | 28756 | 2 | 0.483 | 59536.2 |
248 | 2021-09-06 05:46:30 | occur | 1 | 28756 | 2 | 0.500 | 57512.0 |
247 | 2021-08-21 19:56:27 | occur | 1 | 28756 | 2 | 0.470 | 61183.0 |
246 | 2021-05-28 18:26:52 | occur | 1 | 28756 | 2 | 0.453 | 63479.0 |
245 | 2021-05-03 01:03:21 | occur | 1 | 28756 | 2 | 0.453 | 63479.0 |
244 | 2021-04-01 07:14:27 | occur | 1 | 28756 | 2 | 0.486 | 59168.7 |
243 | 2021-03-22 10:28:30 | occur | 3 | 83667 | 285 | 3.390 | 24680.5 |
242 | 2021-03-13 22:51:25 | occur | 3 | 83667 | 285 | 3.453 | 24230.2 |
241 | 2021-02-25 19:32:28 | occur | 3 | 83667 | 285 | 3.843 | 21771.3 |
240 | 2021-02-09 23:15:07 | occur | 1 | 28756 | 2 | 0.483 | 59536.2 |
239 | 2021-01-30 16:13:06 | occur | 2 | 53800 | 17 | 1.360 | 39558.8 |
238 | 2021-01-16 07:56:42 | occur | 1 | 28756 | 2 | 0.436 | 65954.1 |
237 | 2020-12-17 06:18:15 | occur | 1 | 28756 | 2 | 0.420 | 68466.7 |
236 | 2020-11-12 12:46:05 | occur | 2 | 53800 | 17 | 1.403 | 38346.4 |
235 | 2020-11-01 01:50:19 | occur | 1 | 28756 | 2 | 0.470 | 61183.0 |
234 | 2020-10-31 20:29:22 | occur | 3 | 83667 | 285 | 3.406 | 24564.6 |
233 | 2020-10-27 02:21:09 | occur | 3 | 83667 | 285 | 3.843 | 21771.3 |
232 | 2020-10-24 03:09:32 | occur | 3 | 83667 | 285 | 6.546 | 12781.4 |
231 | 2020-10-03 15:37:42 | occur | 2 | 53800 | 17 | 1.343 | 40059.6 |
230 | 2020-08-13 12:56:40 | occur | 1 | 28756 | 2 | 0.470 | 61183.0 |
229 | 2020-08-05 03:37:54 | occur | 3 | 83667 | 285 | 3.470 | 24111.5 |
228 | 2020-08-05 03:37:47 | occur | 2 | 53800 | 17 | 1.736 | 30990.8 |
227 | 2020-07-30 04:49:54 | occur | 1 | 28756 | 2 | 0.466 | 61708.2 |
226 | 2020-07-28 15:33:23 | occur | 1 | 28756 | 2 | 0.453 | 63479.0 |
225 | 2020-06-01 20:22:05 | occur | 1 | 28756 | 2 | 0.486 | 59168.7 |