History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"orders"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
398 | 2024-03-20 01:14:14 | orders | 1 | 48755 | 5 | 0.860 | 56691.9 |
397 | 2024-03-01 03:49:52 | orders | 1 | 48755 | 5 | 1.406 | 34676.4 |
396 | 2024-01-08 03:03:27 | orders | 2 | 82551 | 132 | 2.656 | 31080.9 |
395 | 2023-12-29 03:10:34 | orders | 2 | 82551 | 132 | 2.126 | 38829.3 |
394 | 2023-12-15 03:29:33 | orders | 1 | 48755 | 5 | 0.750 | 65006.7 |
393 | 2023-11-20 05:50:21 | orders | 1 | 48755 | 5 | 0.750 | 65006.7 |
392 | 2023-11-14 14:58:05 | orders | 1 | 48755 | 5 | 0.953 | 51159.5 |
391 | 2023-11-11 18:26:36 | orders | 1 | 48755 | 5 | 0.953 | 51159.5 |
390 | 2023-10-24 14:46:45 | orders | 1 | 48755 | 5 | 1.563 | 31193.2 |
389 | 2023-10-22 15:41:27 | orders | 1 | 48755 | 5 | 0.766 | 63648.8 |
388 | 2023-10-19 07:00:42 | orders | 1 | 48755 | 5 | 0.856 | 56956.8 |
387 | 2023-10-12 07:30:40 | orders | 1 | 48755 | 5 | 0.890 | 54780.9 |
386 | 2023-10-01 14:23:32 | orders | 2 | 82551 | 132 | 2.203 | 37472.1 |
385 | 2023-10-01 02:02:13 | orders | 1 | 48755 | 5 | 0.766 | 63648.8 |
384 | 2023-09-29 03:12:54 | orders | 1 | 48755 | 5 | 0.813 | 59969.2 |
383 | 2023-09-26 01:58:57 | orders | 1 | 48755 | 5 | 0.860 | 56691.9 |
382 | 2023-07-29 05:17:58 | orders | 1 | 48755 | 5 | 0.736 | 66243.2 |
381 | 2023-07-13 05:26:10 | orders | 2 | 82551 | 132 | 2.563 | 32208.7 |
380 | 2023-07-02 01:30:55 | orders | 1 | 48755 | 5 | 0.733 | 66514.3 |
379 | 2023-04-25 18:27:53 | orders | 1 | 48755 | 5 | 0.736 | 66243.2 |
378 | 2023-04-23 03:07:15 | orders | 1 | 48755 | 5 | 0.763 | 63899.1 |
377 | 2023-04-01 21:55:09 | orders | 2 | 82551 | 132 | 2.093 | 39441.5 |
376 | 2023-03-25 19:00:01 | orders | 1 | 48755 | 5 | 0.780 | 62506.4 |
375 | 2023-03-18 23:20:20 | orders | 1 | 48755 | 5 | 0.720 | 67715.3 |
374 | 2023-02-17 17:17:50 | orders | 1 | 48755 | 5 | 0.813 | 59969.2 |
373 | 2023-02-12 14:53:54 | orders | 2 | 82551 | 132 | 2.173 | 37989.4 |
372 | 2022-12-30 20:56:42 | orders | 2 | 82551 | 132 | 2.110 | 39123.7 |
371 | 2022-12-24 16:55:28 | orders | 2 | 82551 | 132 | 2.093 | 39441.5 |
370 | 2022-12-17 11:59:50 | orders | 1 | 48755 | 5 | 0.750 | 65006.7 |
369 | 2022-12-04 03:16:15 | orders | 1 | 48755 | 5 | 0.876 | 55656.4 |
368 | 2022-11-19 23:28:09 | orders | 2 | 82551 | 132 | 2.563 | 32208.7 |
367 | 2022-11-18 13:04:49 | orders | 2 | 82551 | 132 | 2.560 | 32246.5 |
366 | 2022-11-12 11:36:35 | orders | 2 | 82551 | 132 | 2.406 | 34310.5 |
365 | 2022-11-07 19:53:26 | orders | 2 | 82551 | 132 | 2.453 | 33653.1 |
364 | 2022-11-02 18:54:05 | orders | 2 | 82551 | 132 | 2.236 | 36919.1 |
363 | 2022-10-04 06:36:24 | orders | 2 | 82551 | 132 | 2.283 | 36159.0 |
362 | 2022-09-27 23:57:36 | orders | 2 | 82551 | 132 | 2.190 | 37694.5 |
361 | 2022-09-24 00:06:19 | orders | 2 | 82551 | 132 | 2.533 | 32590.2 |
360 | 2022-09-19 18:11:34 | orders | 1 | 48755 | 5 | 0.783 | 62266.9 |
359 | 2022-09-17 16:46:23 | orders | 1 | 48755 | 5 | 0.750 | 65006.7 |
358 | 2022-09-02 08:41:30 | orders | 2 | 82551 | 132 | 2.186 | 37763.5 |
357 | 2022-08-31 02:21:22 | orders | 1 | 48755 | 5 | 0.750 | 65006.7 |
356 | 2022-08-25 03:55:53 | orders | 1 | 48755 | 5 | 0.750 | 65006.7 |
355 | 2022-08-21 09:34:12 | orders | 2 | 82551 | 132 | 2.126 | 38829.3 |
354 | 2022-08-14 18:19:22 | orders | 1 | 48755 | 5 | 0.736 | 66243.2 |
353 | 2022-08-10 11:33:03 | orders | 1 | 48755 | 5 | 0.763 | 63899.1 |
352 | 2022-08-07 02:54:05 | orders | 1 | 48755 | 5 | 0.766 | 63648.8 |
351 | 2022-07-29 02:32:37 | orders | 1 | 48755 | 5 | 0.826 | 59025.4 |
350 | 2022-07-08 23:38:29 | orders | 2 | 82551 | 132 | 2.173 | 37989.4 |
349 | 2022-04-08 15:51:46 | orders | 1 | 48755 | 5 | 0.826 | 59025.4 |
348 | 2022-04-05 22:55:21 | orders | 1 | 48755 | 5 | 0.873 | 55847.7 |
347 | 2022-01-12 08:59:32 | orders | 1 | 48755 | 5 | 0.766 | 63648.8 |
346 | 2021-12-22 01:21:19 | orders | 1 | 48755 | 5 | 0.890 | 54780.9 |
345 | 2021-12-18 19:51:39 | orders | 1 | 48755 | 5 | 0.890 | 54780.9 |
344 | 2021-11-12 11:26:49 | orders | 1 | 48755 | 5 | 0.860 | 56691.9 |
343 | 2021-10-02 08:12:34 | orders | 1 | 48755 | 5 | 0.750 | 65006.7 |
342 | 2021-09-14 20:18:48 | orders | 1 | 48755 | 5 | 0.783 | 62266.9 |
341 | 2021-08-30 19:30:34 | orders | 1 | 48755 | 5 | 0.906 | 53813.5 |
340 | 2021-08-15 13:27:51 | orders | 1 | 48755 | 5 | 0.750 | 65006.7 |
339 | 2021-06-14 19:03:44 | orders | 1 | 48755 | 5 | 0.813 | 59969.2 |
338 | 2021-06-04 22:43:47 | orders | 2 | 82551 | 132 | 2.453 | 33653.1 |
337 | 2021-05-26 19:51:42 | orders | 1 | 48755 | 5 | 0.813 | 59969.2 |
336 | 2021-05-01 00:11:57 | orders | 1 | 48755 | 5 | 0.826 | 59025.4 |
335 | 2021-03-15 10:03:10 | orders | 1 | 48755 | 5 | 0.750 | 65006.7 |
334 | 2021-03-11 21:24:23 | orders | 1 | 48755 | 5 | 0.783 | 62266.9 |
333 | 2021-02-08 02:03:40 | orders | 1 | 48755 | 5 | 0.783 | 62266.9 |
332 | 2021-01-13 22:09:43 | orders | 1 | 48755 | 5 | 0.766 | 63648.8 |
331 | 2020-11-30 09:03:17 | orders | 1 | 48755 | 5 | 0.813 | 59969.2 |
330 | 2020-10-24 12:27:27 | orders | 1 | 48755 | 5 | 0.826 | 59025.4 |
329 | 2020-10-24 11:06:35 | orders | 1 | 48755 | 5 | 0.783 | 62266.9 |
328 | 2020-10-22 16:25:30 | orders | 1 | 48755 | 5 | 1.660 | 29370.5 |
327 | 2020-10-19 23:37:29 | orders | 1 | 48755 | 5 | 0.766 | 63648.8 |
326 | 2020-10-13 18:36:25 | orders | 1 | 48755 | 5 | 0.750 | 65006.7 |
325 | 2020-10-01 01:33:05 | orders | 1 | 48755 | 5 | 0.733 | 66514.3 |
324 | 2020-08-29 22:33:57 | orders | 1 | 48755 | 5 | 0.766 | 63648.8 |
323 | 2020-07-14 03:21:12 | orders | 1 | 48755 | 5 | 0.783 | 62266.9 |
322 | 2020-05-25 07:15:24 | orders | 1 | 48755 | 5 | 0.813 | 59969.2 |
321 | 2020-05-22 06:21:36 | orders | 1 | 48755 | 5 | 0.733 | 66514.3 |
320 | 2020-04-06 04:33:04 | orders | 1 | 48755 | 5 | 0.846 | 57630.0 |
319 | 2020-03-28 01:40:29 | orders | 1 | 48755 | 5 | 1.826 | 26700.4 |
318 | 2020-03-25 02:59:47 | orders | 1 | 48755 | 5 | 0.890 | 54780.9 |
317 | 2020-03-23 21:11:32 | orders | 1 | 48755 | 5 | 0.860 | 56691.9 |
316 | 2020-03-22 09:32:07 | orders | 1 | 48755 | 5 | 0.860 | 56691.9 |
315 | 2020-03-20 02:01:24 | orders | 1 | 48755 | 5 | 1.686 | 28917.6 |
314 | 2020-02-29 14:53:04 | orders | 2 | 82551 | 132 | 3.500 | 23586.0 |
313 | 2020-02-29 03:24:23 | orders | 2 | 82551 | 132 | 2.593 | 31836.1 |
312 | 2020-02-29 01:30:36 | orders | 2 | 82551 | 132 | 2.610 | 31628.7 |
311 | 2020-02-28 23:30:54 | orders | 2 | 82551 | 132 | 2.796 | 29524.7 |
310 | 2020-02-27 18:45:46 | orders | 2 | 82551 | 132 | 5.516 | 14965.7 |
309 | 2020-02-27 13:39:31 | orders | 2 | 82551 | 132 | 3.266 | 25275.9 |
308 | 2020-02-27 04:44:24 | orders | 1 | 48755 | 5 | 0.970 | 50262.9 |
307 | 2020-02-27 02:41:51 | orders | 1 | 48755 | 5 | 1.453 | 33554.7 |
306 | 2020-02-25 14:25:34 | orders | 1 | 48755 | 5 | 1.643 | 29674.4 |
305 | 2020-02-21 00:49:19 | orders | 1 | 48755 | 5 | 0.970 | 50262.9 |
304 | 2020-02-19 02:38:49 | orders | 1 | 48755 | 5 | 0.986 | 49447.3 |
303 | 2020-02-14 08:03:27 | orders | 1 | 48755 | 5 | 2.140 | 22782.7 |
302 | 2020-02-11 12:10:19 | orders | 1 | 48755 | 5 | 0.953 | 51159.5 |
301 | 2020-01-31 16:17:42 | orders | 1 | 48755 | 5 | 0.830 | 58741.0 |
300 | 2020-01-31 14:55:30 | orders | 1 | 48755 | 5 | 1.453 | 33554.7 |
299 | 2020-01-30 13:05:35 | orders | 1 | 48755 | 5 | 0.860 | 56691.9 |