History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grants"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
415 | 2024-04-28 08:11:48 | grants | 1 | 48755 | 9 | 0.860 | 56691.9 |
414 | 2024-04-26 04:35:30 | grants | 1 | 48755 | 9 | 1.080 | 45143.5 |
413 | 2024-04-23 02:00:53 | grants | 1 | 48755 | 9 | 0.983 | 49598.2 |
412 | 2024-04-23 02:00:39 | grants | 2 | 82551 | 138 | 5.813 | 14201.1 |
411 | 2024-04-23 02:00:34 | grants | 1 | 48755 | 9 | 1.890 | 25796.3 |
410 | 2024-03-24 03:10:18 | grants | 1 | 48755 | 9 | 0.890 | 54780.9 |
409 | 2024-03-23 07:39:24 | grants | 1 | 48755 | 9 | 0.843 | 57835.1 |
408 | 2024-02-28 05:36:52 | grants | 1 | 48755 | 9 | 0.940 | 51867.0 |
407 | 2024-02-22 12:13:03 | grants | 2 | 82551 | 138 | 2.846 | 29006.0 |
406 | 2024-02-22 04:39:15 | grants | 1 | 48755 | 9 | 0.766 | 63648.8 |
405 | 2024-01-31 06:06:25 | grants | 1 | 48755 | 9 | 0.826 | 59025.4 |
404 | 2024-01-16 15:09:22 | grants | 2 | 82551 | 138 | 2.483 | 33246.5 |
403 | 2024-01-11 04:07:43 | grants | 1 | 48755 | 9 | 0.766 | 63648.8 |
402 | 2023-12-28 06:14:25 | grants | 1 | 48755 | 9 | 0.736 | 66243.2 |
401 | 2023-12-19 04:52:10 | grants | 1 | 48755 | 9 | 0.843 | 57835.1 |
400 | 2023-12-18 03:19:35 | grants | 2 | 82551 | 138 | 2.093 | 39441.5 |
399 | 2023-11-20 21:47:45 | grants | 1 | 48755 | 9 | 0.826 | 59025.4 |
398 | 2023-11-17 16:54:52 | grants | 1 | 48755 | 9 | 0.826 | 59025.4 |
397 | 2023-11-11 06:28:53 | grants | 1 | 48755 | 9 | 0.750 | 65006.7 |
396 | 2023-11-03 19:09:18 | grants | 1 | 48755 | 9 | 0.813 | 59969.2 |
395 | 2023-10-31 07:46:22 | grants | 1 | 48755 | 9 | 0.810 | 60191.4 |
394 | 2023-10-19 20:56:23 | grants | 1 | 48755 | 9 | 0.736 | 66243.2 |
393 | 2023-10-18 15:50:11 | grants | 1 | 48755 | 9 | 0.826 | 59025.4 |
392 | 2023-10-13 23:52:57 | grants | 1 | 48755 | 9 | 0.813 | 59969.2 |
391 | 2023-10-06 16:42:17 | grants | 1 | 48755 | 9 | 0.736 | 66243.2 |
390 | 2023-10-03 16:14:47 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
389 | 2023-09-28 01:23:09 | grants | 1 | 48755 | 9 | 0.843 | 57835.1 |
388 | 2023-09-22 17:56:41 | grants | 2 | 82551 | 138 | 2.500 | 33020.4 |
387 | 2023-09-17 19:15:05 | grants | 2 | 82551 | 138 | 2.330 | 35429.6 |
386 | 2023-09-13 16:54:54 | grants | 1 | 48755 | 9 | 1.610 | 30282.6 |
385 | 2023-08-02 13:55:07 | grants | 1 | 48755 | 9 | 0.750 | 65006.7 |
384 | 2023-07-14 07:04:59 | grants | 1 | 48755 | 9 | 0.736 | 66243.2 |
383 | 2023-06-17 19:30:49 | grants | 2 | 82551 | 138 | 2.093 | 39441.5 |
382 | 2023-04-28 10:15:39 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
381 | 2023-04-10 08:29:45 | grants | 1 | 48755 | 9 | 0.783 | 62266.9 |
380 | 2023-03-15 19:34:42 | grants | 2 | 82551 | 138 | 2.126 | 38829.3 |
379 | 2023-02-19 19:29:07 | grants | 1 | 48755 | 9 | 0.716 | 68093.6 |
378 | 2023-01-01 10:20:43 | grants | 1 | 48755 | 9 | 0.830 | 58741.0 |
377 | 2022-12-28 17:37:05 | grants | 1 | 48755 | 9 | 0.716 | 68093.6 |
376 | 2022-12-17 15:57:29 | grants | 2 | 82551 | 138 | 2.373 | 34787.6 |
375 | 2022-12-16 16:37:22 | grants | 1 | 48755 | 9 | 0.796 | 61250.0 |
374 | 2022-09-19 16:51:51 | grants | 1 | 48755 | 9 | 0.810 | 60191.4 |
373 | 2022-09-14 19:21:48 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
372 | 2022-09-10 18:13:13 | grants | 1 | 48755 | 9 | 0.763 | 63899.1 |
371 | 2022-09-10 17:48:39 | grants | 1 | 48755 | 9 | 0.890 | 54780.9 |
370 | 2022-08-27 01:58:06 | grants | 1 | 48755 | 9 | 0.736 | 66243.2 |
369 | 2022-08-26 08:21:28 | grants | 1 | 48755 | 9 | 0.750 | 65006.7 |
368 | 2022-08-23 22:42:25 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
367 | 2022-08-14 17:43:58 | grants | 1 | 48755 | 9 | 0.736 | 66243.2 |
366 | 2022-08-09 23:30:11 | grants | 2 | 82551 | 138 | 2.140 | 38575.2 |
365 | 2022-08-06 20:13:16 | grants | 1 | 48755 | 9 | 0.826 | 59025.4 |
364 | 2022-08-05 21:10:53 | grants | 1 | 48755 | 9 | 0.826 | 59025.4 |
363 | 2022-07-29 01:57:19 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
362 | 2022-05-29 03:57:03 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
361 | 2022-04-16 06:58:02 | grants | 1 | 48755 | 9 | 0.750 | 65006.7 |
360 | 2022-03-13 03:48:20 | grants | 2 | 82551 | 138 | 2.143 | 38521.2 |
359 | 2022-02-17 22:15:27 | grants | 1 | 48755 | 9 | 0.843 | 57835.1 |
358 | 2022-01-09 20:59:38 | grants | 1 | 48755 | 9 | 0.860 | 56691.9 |
357 | 2021-11-28 07:28:17 | grants | 2 | 82551 | 138 | 2.486 | 33206.4 |
356 | 2021-11-24 03:31:11 | grants | 1 | 48755 | 9 | 0.766 | 63648.8 |
355 | 2021-11-16 13:25:54 | grants | 1 | 48755 | 9 | 0.780 | 62506.4 |
354 | 2021-11-10 01:47:09 | grants | 1 | 48755 | 9 | 0.830 | 58741.0 |
353 | 2021-10-04 00:32:41 | grants | 1 | 48755 | 9 | 0.893 | 54596.9 |
352 | 2021-09-03 22:09:18 | grants | 1 | 48755 | 9 | 0.766 | 63648.8 |
351 | 2021-08-17 08:31:34 | grants | 1 | 48755 | 9 | 0.716 | 68093.6 |
350 | 2021-08-16 23:48:57 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
349 | 2021-06-07 08:58:36 | grants | 1 | 48755 | 9 | 0.796 | 61250.0 |
348 | 2021-05-16 07:33:14 | grants | 1 | 48755 | 9 | 0.846 | 57630.0 |
347 | 2021-05-13 10:16:16 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
346 | 2021-05-12 22:48:59 | grants | 1 | 48755 | 9 | 0.826 | 59025.4 |
345 | 2021-04-12 06:24:02 | grants | 1 | 48755 | 9 | 0.843 | 57835.1 |
344 | 2021-02-14 09:00:47 | grants | 1 | 48755 | 9 | 0.766 | 63648.8 |
343 | 2021-02-09 03:32:58 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
342 | 2021-02-03 20:32:15 | grants | 1 | 48755 | 9 | 0.796 | 61250.0 |
341 | 2021-01-25 06:23:14 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
340 | 2020-11-02 04:36:30 | grants | 1 | 48755 | 9 | 1.670 | 29194.6 |
339 | 2020-10-25 03:44:32 | grants | 1 | 48755 | 9 | 0.830 | 58741.0 |
338 | 2020-10-13 18:57:45 | grants | 1 | 48755 | 9 | 0.763 | 63899.1 |
337 | 2020-10-07 04:51:28 | grants | 1 | 48755 | 9 | 0.876 | 55656.4 |
336 | 2020-08-30 23:49:51 | grants | 1 | 48755 | 9 | 0.766 | 63648.8 |
335 | 2020-08-29 09:07:46 | grants | 1 | 48755 | 9 | 0.766 | 63648.8 |
334 | 2020-08-02 17:07:09 | grants | 1 | 48755 | 9 | 0.783 | 62266.9 |
333 | 2020-07-30 05:30:11 | grants | 1 | 48755 | 9 | 0.766 | 63648.8 |
332 | 2020-07-13 00:31:42 | grants | 1 | 48755 | 9 | 0.830 | 58741.0 |
331 | 2020-05-15 07:44:23 | grants | 1 | 48755 | 9 | 0.890 | 54780.9 |
330 | 2020-05-04 10:14:54 | grants | 1 | 48755 | 9 | 0.846 | 57630.0 |
329 | 2020-04-17 19:57:00 | grants | 1 | 48755 | 9 | 0.720 | 67715.3 |
328 | 2020-03-26 01:27:26 | grants | 1 | 48755 | 9 | 0.783 | 62266.9 |
327 | 2020-03-25 14:18:50 | grants | 1 | 48755 | 9 | 0.813 | 59969.2 |
326 | 2020-03-25 02:23:26 | grants | 1 | 48755 | 9 | 0.750 | 65006.7 |
325 | 2020-03-23 06:18:45 | grants | 1 | 48755 | 9 | 1.720 | 28345.9 |
324 | 2020-03-21 20:02:50 | grants | 1 | 48755 | 9 | 0.906 | 53813.5 |
323 | 2020-03-18 16:02:44 | grants | 1 | 48755 | 9 | 0.733 | 66514.3 |
322 | 2020-02-27 00:45:58 | grants | 1 | 48755 | 9 | 1.063 | 45865.5 |
321 | 2020-02-26 05:17:18 | grants | 1 | 48755 | 9 | 1.716 | 28412.0 |
320 | 2020-02-26 04:54:45 | grants | 1 | 48755 | 9 | 0.860 | 56691.9 |
319 | 2020-02-22 12:16:53 | grants | 1 | 48755 | 9 | 1.656 | 29441.4 |
318 | 2020-02-20 03:25:41 | grants | 1 | 48755 | 9 | 0.876 | 55656.4 |
317 | 2020-02-19 01:57:26 | grants | 1 | 48755 | 9 | 0.906 | 53813.5 |
316 | 2020-02-13 22:10:19 | grants | 1 | 48755 | 9 | 0.936 | 52088.7 |