History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shown"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
357 | 2024-05-04 03:25:03 | shown | 1 | 28756 | 9 | 1.140 | 25224.6 |
356 | 2024-04-30 11:10:56 | shown | 1 | 28756 | 9 | 1.720 | 16718.6 |
355 | 2024-04-29 20:34:01 | shown | 1 | 28756 | 9 | 1.080 | 26625.9 |
354 | 2024-04-27 04:53:11 | shown | 1 | 28756 | 9 | 1.750 | 16432.0 |
353 | 2024-04-19 09:55:34 | shown | 1 | 28756 | 9 | 0.563 | 51076.4 |
352 | 2024-04-15 06:54:50 | shown | 1 | 28756 | 9 | 1.546 | 18600.3 |
351 | 2024-04-15 06:52:31 | shown | 1 | 28756 | 9 | 1.750 | 16432.0 |
350 | 2024-04-15 01:36:08 | shown | 1 | 28756 | 9 | 0.576 | 49923.6 |
349 | 2024-04-15 01:35:23 | shown | 1 | 28756 | 9 | 2.890 | 9950.2 |
348 | 2024-04-03 01:00:42 | shown | 1 | 28756 | 9 | 0.716 | 40162.0 |
347 | 2024-03-31 16:32:15 | shown | 1 | 28756 | 9 | 1.123 | 25606.4 |
346 | 2024-03-31 16:32:07 | shown | 2 | 53800 | 117 | 1.826 | 29463.3 |
345 | 2024-03-31 10:03:21 | shown | 2 | 53800 | 117 | 5.796 | 9282.3 |
344 | 2024-03-31 08:30:51 | shown | 1 | 28756 | 9 | 0.516 | 55728.7 |
343 | 2024-03-28 18:49:12 | shown | 2 | 53800 | 117 | 4.153 | 12954.5 |
342 | 2024-03-28 18:16:50 | shown | 1 | 28756 | 9 | 0.546 | 52666.7 |
341 | 2024-03-01 07:29:56 | shown | 1 | 28756 | 9 | 0.530 | 54256.6 |
340 | 2024-02-28 09:04:58 | shown | 1 | 28756 | 9 | 1.123 | 25606.4 |
339 | 2024-02-26 01:32:27 | shown | 1 | 28756 | 9 | 0.453 | 63479.0 |
338 | 2024-01-27 00:03:05 | shown | 1 | 28756 | 9 | 1.000 | 28756.0 |
337 | 2023-12-31 14:33:12 | shown | 1 | 28756 | 9 | 0.453 | 63479.0 |
336 | 2023-12-14 18:23:11 | shown | 2 | 53800 | 117 | 1.906 | 28226.7 |
335 | 2023-11-25 20:47:53 | shown | 2 | 53800 | 117 | 1.546 | 34799.5 |
334 | 2023-11-19 12:15:58 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
333 | 2023-11-09 18:02:01 | shown | 1 | 28756 | 9 | 0.526 | 54669.2 |
332 | 2023-11-07 14:53:41 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
331 | 2023-10-28 21:50:40 | shown | 1 | 28756 | 9 | 0.440 | 65354.5 |
330 | 2023-10-28 04:48:14 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
329 | 2023-10-26 14:33:11 | shown | 1 | 28756 | 9 | 0.513 | 56054.6 |
328 | 2023-10-21 10:04:42 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
327 | 2023-10-19 08:46:25 | shown | 1 | 28756 | 9 | 0.436 | 65954.1 |
326 | 2023-10-13 13:40:34 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
325 | 2023-10-09 07:01:42 | shown | 1 | 28756 | 9 | 0.923 | 31154.9 |
324 | 2023-09-26 17:28:51 | shown | 2 | 53800 | 117 | 1.593 | 33772.8 |
323 | 2023-09-22 23:40:58 | shown | 1 | 28756 | 9 | 0.516 | 55728.7 |
322 | 2023-09-19 15:51:07 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
321 | 2023-08-16 14:19:08 | shown | 1 | 28756 | 9 | 0.440 | 65354.5 |
320 | 2023-06-27 11:53:25 | shown | 1 | 28756 | 9 | 0.453 | 63479.0 |
319 | 2023-05-16 16:13:06 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
318 | 2023-03-12 09:02:52 | shown | 1 | 28756 | 9 | 0.453 | 63479.0 |
317 | 2023-03-01 15:19:02 | shown | 1 | 28756 | 9 | 0.440 | 65354.5 |
316 | 2023-01-08 23:13:43 | shown | 1 | 28756 | 9 | 0.486 | 59168.7 |
315 | 2023-01-01 21:52:48 | shown | 1 | 28756 | 9 | 0.876 | 32826.5 |
314 | 2022-11-28 01:25:01 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
313 | 2022-10-26 01:12:57 | shown | 1 | 28756 | 9 | 0.466 | 61708.2 |
312 | 2022-09-23 03:25:38 | shown | 1 | 28756 | 9 | 0.436 | 65954.1 |
311 | 2022-09-03 16:25:11 | shown | 1 | 28756 | 9 | 0.450 | 63902.2 |
310 | 2022-09-01 03:40:46 | shown | 1 | 28756 | 9 | 1.123 | 25606.4 |
309 | 2022-06-21 03:38:46 | shown | 1 | 28756 | 9 | 0.453 | 63479.0 |
308 | 2022-05-08 02:07:51 | shown | 1 | 28756 | 9 | 0.626 | 45936.1 |
307 | 2022-02-27 23:51:27 | shown | 1 | 28756 | 9 | 0.533 | 53951.2 |
306 | 2022-02-09 05:40:52 | shown | 1 | 28756 | 9 | 0.516 | 55728.7 |
305 | 2022-01-29 06:52:27 | shown | 1 | 28756 | 9 | 0.466 | 61708.2 |
304 | 2021-11-20 07:39:11 | shown | 1 | 28756 | 9 | 0.970 | 29645.4 |
303 | 2021-11-18 06:19:58 | shown | 1 | 28756 | 9 | 0.453 | 63479.0 |
302 | 2021-10-09 17:59:02 | shown | 1 | 28756 | 9 | 0.453 | 63479.0 |
301 | 2021-10-04 00:03:36 | shown | 1 | 28756 | 9 | 0.516 | 55728.7 |
300 | 2021-09-06 02:14:42 | shown | 1 | 28756 | 9 | 0.533 | 53951.2 |
299 | 2021-09-03 20:57:05 | shown | 1 | 28756 | 9 | 0.516 | 55728.7 |
298 | 2021-06-30 17:59:52 | shown | 1 | 28756 | 9 | 0.530 | 54256.6 |
297 | 2021-06-20 08:02:36 | shown | 1 | 28756 | 9 | 0.436 | 65954.1 |
296 | 2021-03-31 16:59:01 | shown | 1 | 28756 | 9 | 0.533 | 53951.2 |
295 | 2021-03-30 16:01:18 | shown | 1 | 28756 | 9 | 0.486 | 59168.7 |
294 | 2021-01-15 08:20:45 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
293 | 2020-12-19 01:52:32 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
292 | 2020-11-04 20:58:51 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
291 | 2020-10-29 16:36:12 | shown | 1 | 28756 | 9 | 0.470 | 61183.0 |
290 | 2020-10-26 09:27:07 | shown | 1 | 28756 | 9 | 0.546 | 52666.7 |
289 | 2020-10-24 12:51:24 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
288 | 2020-10-21 09:51:38 | shown | 1 | 28756 | 9 | 0.516 | 55728.7 |
287 | 2020-10-02 06:04:54 | shown | 1 | 28756 | 9 | 0.486 | 59168.7 |
286 | 2020-09-14 22:38:56 | shown | 1 | 28756 | 9 | 0.453 | 63479.0 |
285 | 2020-08-22 09:33:35 | shown | 1 | 28756 | 9 | 0.470 | 61183.0 |
284 | 2020-08-03 07:00:59 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
283 | 2020-07-31 00:30:02 | shown | 1 | 28756 | 9 | 0.470 | 61183.0 |
282 | 2020-06-02 19:59:44 | shown | 1 | 28756 | 9 | 0.453 | 63479.0 |
281 | 2020-05-30 17:14:44 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
280 | 2020-05-03 22:16:10 | shown | 1 | 28756 | 9 | 0.546 | 52666.7 |
279 | 2020-03-25 16:24:19 | shown | 1 | 28756 | 9 | 0.546 | 52666.7 |
278 | 2020-03-23 17:12:52 | shown | 1 | 28756 | 9 | 0.546 | 52666.7 |
277 | 2020-03-23 08:31:36 | shown | 1 | 28756 | 9 | 0.453 | 63479.0 |
276 | 2020-03-22 21:59:54 | shown | 1 | 28756 | 9 | 0.546 | 52666.7 |
275 | 2020-03-22 08:50:18 | shown | 1 | 28756 | 9 | 1.360 | 21144.1 |
274 | 2020-03-18 08:14:53 | shown | 1 | 28756 | 9 | 0.500 | 57512.0 |
273 | 2020-03-05 20:33:46 | shown | 1 | 28756 | 9 | 1.076 | 26724.9 |
272 | 2020-03-05 19:23:47 | shown | 1 | 28756 | 9 | 0.576 | 49923.6 |
271 | 2020-02-27 09:53:06 | shown | 1 | 28756 | 9 | 0.436 | 65954.1 |
270 | 2020-02-23 22:21:18 | shown | 1 | 28756 | 9 | 0.440 | 65354.5 |
269 | 2020-02-21 13:16:38 | shown | 1 | 28756 | 9 | 0.530 | 54256.6 |
268 | 2020-02-15 03:58:39 | shown | 1 | 28756 | 9 | 0.876 | 32826.5 |
267 | 2020-02-11 06:14:45 | shown | 1 | 28756 | 9 | 0.530 | 54256.6 |
266 | 2020-02-04 01:44:26 | shown | 1 | 28756 | 9 | 2.266 | 12690.2 |
265 | 2020-01-30 22:13:23 | shown | 1 | 28756 | 9 | 0.483 | 59536.2 |
264 | 2020-01-30 17:24:30 | shown | 1 | 28756 | 9 | 1.123 | 25606.4 |
263 | 2020-01-24 20:30:39 | shown | 1 | 28756 | 9 | 0.593 | 48492.4 |
262 | 2020-01-24 15:57:52 | shown | 1 | 28756 | 9 | 1.360 | 21144.1 |
261 | 2020-01-21 18:14:56 | shown | 1 | 28756 | 9 | 0.486 | 59168.7 |
260 | 2020-01-14 04:55:56 | shown | 1 | 28756 | 9 | 0.530 | 54256.6 |
259 | 2020-01-12 10:10:53 | shown | 1 | 28756 | 9 | 1.143 | 25158.4 |
258 | 2020-01-08 06:00:06 | shown | 1 | 28756 | 9 | 0.546 | 52666.7 |