History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"retained"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
410 | 2024-04-16 20:14:43 | retained | 1 | 82945 | 7 | 6.393 | 12974.3 |
409 | 2024-04-10 20:04:03 | retained | 1 | 82945 | 7 | 3.063 | 27079.7 |
408 | 2024-04-07 06:22:39 | retained | 3 | 146162 | 454 | 11.140 | 13120.5 |
407 | 2024-04-06 11:25:00 | retained | 3 | 146162 | 454 | 31.266 | 4674.8 |
406 | 2024-04-04 23:29:31 | retained | 3 | 146162 | 454 | 19.046 | 7674.2 |
405 | 2024-04-04 15:32:16 | retained | 2 | 121059 | 67 | 3.953 | 30624.6 |
404 | 2024-04-04 15:26:49 | retained | 1 | 82945 | 7 | 1.813 | 45750.1 |
403 | 2024-04-04 15:26:28 | retained | 3 | 146162 | 454 | 7.250 | 20160.3 |
402 | 2024-04-04 06:58:22 | retained | 2 | 121059 | 67 | 12.236 | 9893.7 |
401 | 2024-04-04 06:58:21 | retained | 3 | 146162 | 454 | 11.423 | 12795.4 |
400 | 2024-04-04 06:58:16 | retained | 1 | 82945 | 7 | 1.830 | 45325.1 |
399 | 2024-03-30 01:16:09 | retained | 1 | 82945 | 7 | 4.436 | 18698.2 |
398 | 2024-03-29 22:15:44 | retained | 1 | 82945 | 7 | 4.800 | 17280.2 |
397 | 2024-03-28 13:34:09 | retained | 1 | 82945 | 7 | 1.906 | 43517.8 |
396 | 2024-03-04 09:26:39 | retained | 2 | 121059 | 67 | 8.766 | 13810.1 |
395 | 2024-03-04 09:26:31 | retained | 1 | 82945 | 7 | 1.563 | 53067.8 |
394 | 2024-03-01 13:16:57 | retained | 3 | 146162 | 454 | 21.206 | 6892.5 |
393 | 2024-02-29 08:36:52 | retained | 3 | 146162 | 454 | 8.623 | 16950.2 |
392 | 2024-02-28 06:08:58 | retained | 1 | 82945 | 7 | 1.860 | 44594.1 |
391 | 2024-02-22 15:56:38 | retained | 3 | 146162 | 454 | 16.186 | 9030.1 |
390 | 2024-02-09 19:43:05 | retained | 3 | 146162 | 454 | 13.003 | 11240.6 |
389 | 2024-02-04 17:08:48 | retained | 3 | 146162 | 454 | 12.860 | 11365.6 |
388 | 2024-02-04 17:07:58 | retained | 2 | 121059 | 67 | 4.156 | 29128.7 |
387 | 2024-02-03 20:07:30 | retained | 2 | 121059 | 67 | 3.766 | 32145.2 |
386 | 2024-02-03 07:07:10 | retained | 2 | 121059 | 67 | 3.500 | 34588.3 |
385 | 2024-02-03 07:07:06 | retained | 1 | 82945 | 7 | 1.610 | 51518.6 |
384 | 2024-01-24 12:10:24 | retained | 3 | 146162 | 454 | 9.546 | 15311.3 |
383 | 2024-01-23 01:36:48 | retained | 3 | 146162 | 454 | 17.126 | 8534.5 |
382 | 2024-01-16 19:09:10 | retained | 3 | 146162 | 454 | 8.016 | 18233.8 |
381 | 2024-01-04 06:11:19 | retained | 1 | 82945 | 7 | 1.796 | 46183.2 |
380 | 2023-12-27 00:49:17 | retained | 1 | 82945 | 7 | 1.390 | 59672.7 |
379 | 2023-12-24 19:17:22 | retained | 2 | 121059 | 67 | 3.330 | 36354.1 |
378 | 2023-12-08 17:06:16 | retained | 1 | 82945 | 7 | 1.280 | 64800.8 |
377 | 2023-12-04 00:36:26 | retained | 3 | 146162 | 454 | 7.890 | 18525.0 |
376 | 2023-12-04 00:36:25 | retained | 2 | 121059 | 67 | 3.843 | 31501.2 |
375 | 2023-12-01 16:53:12 | retained | 1 | 82945 | 7 | 1.343 | 61761.0 |
374 | 2023-11-25 07:50:12 | retained | 3 | 146162 | 454 | 6.920 | 21121.7 |
373 | 2023-11-06 17:56:16 | retained | 1 | 82945 | 7 | 1.610 | 51518.6 |
372 | 2023-10-27 03:26:49 | retained | 3 | 146162 | 454 | 7.923 | 18447.8 |
371 | 2023-10-22 07:51:50 | retained | 1 | 82945 | 7 | 1.296 | 64000.8 |
370 | 2023-10-19 02:04:39 | retained | 1 | 82945 | 7 | 3.233 | 25655.7 |
369 | 2023-10-17 02:32:23 | retained | 1 | 82945 | 7 | 1.610 | 51518.6 |
368 | 2023-10-15 00:26:42 | retained | 1 | 82945 | 7 | 1.330 | 62364.7 |
367 | 2023-09-26 14:53:45 | retained | 2 | 121059 | 67 | 3.390 | 35710.6 |
366 | 2023-09-26 12:55:48 | retained | 1 | 82945 | 7 | 1.406 | 58993.6 |
365 | 2023-09-17 00:25:28 | retained | 1 | 82945 | 7 | 1.516 | 54713.1 |
364 | 2023-08-09 21:39:17 | retained | 1 | 82945 | 7 | 1.343 | 61761.0 |
363 | 2023-08-03 18:19:55 | retained | 3 | 146162 | 454 | 6.653 | 21969.3 |
362 | 2023-07-20 17:15:04 | retained | 3 | 146162 | 454 | 6.533 | 22372.9 |
361 | 2023-07-11 12:35:41 | retained | 1 | 82945 | 7 | 1.373 | 60411.5 |
360 | 2023-07-07 18:32:29 | retained | 2 | 121059 | 67 | 3.343 | 36212.7 |
359 | 2023-05-07 19:31:38 | retained | 1 | 82945 | 7 | 1.283 | 64649.3 |
358 | 2023-04-11 02:33:59 | retained | 3 | 146162 | 454 | 6.453 | 22650.2 |
357 | 2023-03-28 23:41:31 | retained | 2 | 121059 | 67 | 3.736 | 32403.4 |
356 | 2023-03-17 09:42:43 | retained | 1 | 82945 | 7 | 1.296 | 64000.8 |
355 | 2023-02-27 02:01:48 | retained | 1 | 82945 | 7 | 1.376 | 60279.8 |
354 | 2023-01-08 01:54:19 | retained | 3 | 146162 | 454 | 6.436 | 22710.1 |
353 | 2022-12-26 07:56:28 | retained | 2 | 121059 | 67 | 3.203 | 37795.5 |
352 | 2022-12-25 07:35:19 | retained | 1 | 82945 | 7 | 1.436 | 57761.1 |
351 | 2022-11-19 02:03:18 | retained | 1 | 82945 | 7 | 1.296 | 64000.8 |
350 | 2022-09-20 07:40:05 | retained | 3 | 146162 | 454 | 6.546 | 22328.4 |
349 | 2022-09-11 09:20:20 | retained | 3 | 146162 | 454 | 6.656 | 21959.4 |
348 | 2022-09-11 02:39:07 | retained | 1 | 82945 | 7 | 1.263 | 65673.0 |
347 | 2022-08-30 20:08:22 | retained | 2 | 121059 | 67 | 3.720 | 32542.7 |
346 | 2022-08-28 09:27:55 | retained | 2 | 121059 | 67 | 3.343 | 36212.7 |
345 | 2022-07-26 07:55:16 | retained | 1 | 82945 | 7 | 1.326 | 62552.8 |
344 | 2022-04-18 01:00:30 | retained | 1 | 82945 | 7 | 1.453 | 57085.3 |
343 | 2022-04-15 21:49:58 | retained | 1 | 82945 | 7 | 1.296 | 64000.8 |
342 | 2022-04-01 17:01:41 | retained | 3 | 146162 | 454 | 6.686 | 21860.9 |
341 | 2022-03-28 09:02:07 | retained | 1 | 82945 | 7 | 1.610 | 51518.6 |
340 | 2022-03-19 00:21:22 | retained | 2 | 121059 | 67 | 4.343 | 27874.5 |
339 | 2022-01-09 11:41:45 | retained | 1 | 82945 | 7 | 1.530 | 54212.4 |
338 | 2021-12-19 02:41:43 | retained | 3 | 146162 | 454 | 9.690 | 15083.8 |
337 | 2021-12-16 20:24:59 | retained | 1 | 82945 | 7 | 1.500 | 55296.7 |
336 | 2021-12-10 21:35:06 | retained | 1 | 82945 | 7 | 1.470 | 56425.2 |
335 | 2021-11-22 01:47:46 | retained | 1 | 82945 | 7 | 1.343 | 61761.0 |
334 | 2021-11-08 19:40:25 | retained | 3 | 146162 | 454 | 6.763 | 21612.0 |
333 | 2021-11-08 18:56:16 | retained | 3 | 146162 | 454 | 7.720 | 18932.9 |
332 | 2021-10-11 10:48:04 | retained | 3 | 146162 | 454 | 7.686 | 19016.7 |
331 | 2021-09-27 06:47:44 | retained | 1 | 82945 | 7 | 1.470 | 56425.2 |
330 | 2021-09-12 07:44:11 | retained | 1 | 82945 | 7 | 1.296 | 64000.8 |
329 | 2021-09-11 08:38:28 | retained | 3 | 146162 | 454 | 6.470 | 22590.7 |
328 | 2021-08-27 23:26:11 | retained | 1 | 82945 | 7 | 1.296 | 64000.8 |
327 | 2021-08-21 06:16:20 | retained | 3 | 146162 | 454 | 6.813 | 21453.4 |
326 | 2021-08-09 01:03:50 | retained | 3 | 146162 | 454 | 7.686 | 19016.7 |
325 | 2021-07-10 23:51:22 | retained | 3 | 146162 | 454 | 7.160 | 20413.7 |
324 | 2021-06-21 06:02:15 | retained | 1 | 82945 | 7 | 1.513 | 54821.5 |
323 | 2021-06-11 16:55:11 | retained | 2 | 121059 | 67 | 3.890 | 31120.6 |
322 | 2021-05-31 07:51:26 | retained | 1 | 82945 | 7 | 1.300 | 63803.8 |
321 | 2021-05-27 05:05:05 | retained | 1 | 82945 | 7 | 3.016 | 27501.7 |
320 | 2021-05-15 07:53:38 | retained | 2 | 121059 | 67 | 3.280 | 36908.2 |
319 | 2021-05-06 02:30:12 | retained | 1 | 82945 | 7 | 1.513 | 54821.5 |
318 | 2021-05-02 21:41:10 | retained | 1 | 82945 | 7 | 1.513 | 54821.5 |
317 | 2021-04-18 06:10:00 | retained | 2 | 121059 | 67 | 3.673 | 32959.2 |
316 | 2021-04-04 05:37:06 | retained | 1 | 82945 | 7 | 2.860 | 29001.7 |
315 | 2021-02-21 22:03:38 | retained | 1 | 82945 | 7 | 2.950 | 28116.9 |
314 | 2021-01-19 15:27:50 | retained | 1 | 82945 | 7 | 1.313 | 63172.1 |
313 | 2020-11-24 17:28:23 | retained | 1 | 82945 | 7 | 1.280 | 64800.8 |
312 | 2020-11-18 18:35:16 | retained | 1 | 82945 | 7 | 1.326 | 62552.8 |
311 | 2020-11-11 05:45:57 | retained | 2 | 121059 | 67 | 3.610 | 33534.3 |