History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"granter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
454 | 2024-04-27 08:33:56 | granter | 1 | 69583 | 11 | 1.156 | 60192.9 |
453 | 2024-04-27 03:30:15 | granter | 1 | 69583 | 11 | 5.643 | 12330.9 |
452 | 2024-04-25 20:17:22 | granter | 3 | 134027 | 799 | 17.266 | 7762.5 |
451 | 2024-04-24 18:50:44 | granter | 2 | 107671 | 88 | 7.296 | 14757.5 |
450 | 2024-04-24 18:47:28 | granter | 3 | 134027 | 799 | 8.313 | 16122.6 |
449 | 2024-04-24 17:13:55 | granter | 2 | 107671 | 88 | 12.440 | 8655.2 |
448 | 2024-04-24 17:11:15 | granter | 3 | 134027 | 799 | 7.970 | 16816.4 |
447 | 2024-04-23 03:49:44 | granter | 2 | 107671 | 88 | 9.186 | 11721.2 |
446 | 2024-04-23 03:49:34 | granter | 3 | 134027 | 799 | 13.390 | 10009.5 |
445 | 2024-03-17 10:28:20 | granter | 1 | 69583 | 11 | 1.283 | 54234.6 |
444 | 2024-03-04 02:35:23 | granter | 1 | 69583 | 11 | 1.326 | 52475.9 |
443 | 2024-02-23 16:29:48 | granter | 3 | 134027 | 799 | 5.830 | 22989.2 |
442 | 2024-02-22 08:46:23 | granter | 3 | 134027 | 799 | 7.546 | 17761.3 |
441 | 2024-02-22 08:46:07 | granter | 2 | 107671 | 88 | 7.343 | 14663.1 |
440 | 2024-02-21 11:38:45 | granter | 2 | 107671 | 88 | 8.093 | 13304.2 |
439 | 2024-02-21 03:42:45 | granter | 2 | 107671 | 88 | 3.330 | 32333.6 |
438 | 2024-01-17 13:11:50 | granter | 2 | 107671 | 88 | 3.330 | 32333.6 |
437 | 2024-01-10 13:43:20 | granter | 3 | 134027 | 799 | 7.406 | 18097.1 |
436 | 2024-01-08 16:14:59 | granter | 2 | 107671 | 88 | 3.626 | 29694.2 |
435 | 2023-12-13 21:08:36 | granter | 1 | 69583 | 11 | 2.406 | 28920.6 |
434 | 2023-12-11 20:59:34 | granter | 1 | 69583 | 11 | 1.156 | 60192.9 |
433 | 2023-12-11 11:34:56 | granter | 1 | 69583 | 11 | 1.076 | 64668.2 |
432 | 2023-11-29 22:22:01 | granter | 1 | 69583 | 11 | 1.156 | 60192.9 |
431 | 2023-11-26 16:07:38 | granter | 1 | 69583 | 11 | 1.186 | 58670.3 |
430 | 2023-11-21 00:01:16 | granter | 3 | 134027 | 799 | 5.736 | 23365.9 |
429 | 2023-11-17 16:54:55 | granter | 1 | 69583 | 11 | 1.170 | 59472.6 |
428 | 2023-11-16 19:49:12 | granter | 2 | 107671 | 88 | 3.153 | 34148.7 |
427 | 2023-11-12 04:43:43 | granter | 1 | 69583 | 11 | 1.093 | 63662.4 |
426 | 2023-11-06 07:39:02 | granter | 1 | 69583 | 11 | 1.030 | 67556.3 |
425 | 2023-09-29 13:25:08 | granter | 1 | 69583 | 11 | 1.156 | 60192.9 |
424 | 2023-09-25 01:57:45 | granter | 1 | 69583 | 11 | 1.063 | 65459.1 |
423 | 2023-09-23 03:31:06 | granter | 1 | 69583 | 11 | 1.093 | 63662.4 |
422 | 2023-08-20 21:27:00 | granter | 3 | 134027 | 799 | 5.750 | 23309.0 |
421 | 2023-08-17 15:49:06 | granter | 2 | 107671 | 88 | 2.796 | 38508.9 |
420 | 2023-08-07 03:58:04 | granter | 1 | 69583 | 11 | 1.013 | 68690.0 |
419 | 2023-05-05 21:27:38 | granter | 3 | 134027 | 799 | 5.720 | 23431.3 |
418 | 2023-04-30 07:13:04 | granter | 2 | 107671 | 88 | 3.266 | 32967.2 |
417 | 2023-04-25 22:21:20 | granter | 1 | 69583 | 11 | 1.046 | 66522.9 |
416 | 2023-04-21 09:15:46 | granter | 1 | 69583 | 11 | 1.046 | 66522.9 |
415 | 2023-02-14 01:40:52 | granter | 3 | 134027 | 799 | 6.156 | 21771.8 |
414 | 2023-02-12 01:19:46 | granter | 1 | 69583 | 11 | 2.060 | 33778.2 |
413 | 2023-02-02 07:07:17 | granter | 2 | 107671 | 88 | 2.953 | 36461.6 |
412 | 2023-01-06 02:56:58 | granter | 1 | 69583 | 11 | 1.283 | 54234.6 |
411 | 2022-12-09 07:15:50 | granter | 1 | 69583 | 11 | 1.030 | 67556.3 |
410 | 2022-11-24 19:33:35 | granter | 3 | 134027 | 799 | 5.890 | 22755.0 |
409 | 2022-11-14 05:20:15 | granter | 2 | 107671 | 88 | 2.800 | 38453.9 |
408 | 2022-09-26 00:51:36 | granter | 1 | 69583 | 11 | 1.080 | 64428.7 |
407 | 2022-08-25 09:15:18 | granter | 1 | 69583 | 11 | 1.313 | 52995.4 |
406 | 2022-08-08 02:38:41 | granter | 1 | 69583 | 11 | 1.046 | 66522.9 |
405 | 2022-06-18 05:40:41 | granter | 2 | 107671 | 88 | 2.906 | 37051.3 |
404 | 2022-06-16 08:05:56 | granter | 1 | 69583 | 11 | 1.080 | 64428.7 |
403 | 2022-04-19 23:00:35 | granter | 3 | 134027 | 799 | 6.250 | 21444.3 |
402 | 2022-04-01 20:31:56 | granter | 1 | 69583 | 11 | 1.046 | 66522.9 |
401 | 2022-03-04 09:04:14 | granter | 1 | 69583 | 11 | 1.310 | 53116.8 |
400 | 2022-02-06 05:36:12 | granter | 2 | 107671 | 88 | 2.780 | 38730.6 |
399 | 2022-01-26 08:08:53 | granter | 1 | 69583 | 11 | 1.233 | 56433.9 |
398 | 2022-01-05 15:02:06 | granter | 1 | 69583 | 11 | 1.373 | 50679.5 |
397 | 2021-12-13 23:39:06 | granter | 1 | 69583 | 11 | 1.156 | 60192.9 |
396 | 2021-12-12 10:55:32 | granter | 1 | 69583 | 11 | 1.076 | 64668.2 |
395 | 2021-11-20 16:50:48 | granter | 1 | 69583 | 11 | 1.046 | 66522.9 |
394 | 2021-11-11 09:46:33 | granter | 2 | 107671 | 88 | 3.233 | 33303.7 |
393 | 2021-11-07 22:56:14 | granter | 1 | 69583 | 11 | 1.173 | 59320.5 |
392 | 2021-11-05 23:19:02 | granter | 1 | 69583 | 11 | 1.250 | 55666.4 |
391 | 2021-09-21 06:12:50 | granter | 1 | 69583 | 11 | 1.076 | 64668.2 |
390 | 2021-09-19 03:12:49 | granter | 1 | 69583 | 11 | 1.046 | 66522.9 |
389 | 2021-08-28 06:01:24 | granter | 1 | 69583 | 11 | 1.076 | 64668.2 |
388 | 2021-08-21 02:50:02 | granter | 1 | 69583 | 11 | 1.046 | 66522.9 |
387 | 2021-05-20 12:25:12 | granter | 1 | 69583 | 11 | 1.266 | 54962.9 |
386 | 2021-02-20 23:14:48 | granter | 1 | 69583 | 11 | 1.110 | 62687.4 |
385 | 2021-02-17 22:27:04 | granter | 1 | 69583 | 11 | 1.046 | 66522.9 |
384 | 2020-11-18 19:01:53 | granter | 1 | 69583 | 11 | 1.220 | 57035.2 |
383 | 2020-11-13 17:43:29 | granter | 1 | 69583 | 11 | 1.250 | 55666.4 |
382 | 2020-08-29 20:13:59 | granter | 1 | 69583 | 11 | 1.153 | 60349.5 |
381 | 2020-08-24 05:29:10 | granter | 1 | 69583 | 11 | 1.200 | 57985.8 |
380 | 2020-08-18 15:48:19 | granter | 1 | 69583 | 11 | 1.076 | 64668.2 |
379 | 2020-08-15 19:39:51 | granter | 1 | 69583 | 11 | 1.080 | 64428.7 |
378 | 2020-08-12 13:12:09 | granter | 1 | 69583 | 11 | 1.093 | 63662.4 |
377 | 2020-07-18 02:36:40 | granter | 1 | 69583 | 11 | 1.186 | 58670.3 |
376 | 2020-07-16 02:05:45 | granter | 1 | 69583 | 11 | 1.093 | 63662.4 |
375 | 2020-07-13 09:27:50 | granter | 1 | 69583 | 11 | 1.123 | 61961.7 |
374 | 2020-05-19 09:29:11 | granter | 1 | 69583 | 11 | 1.063 | 65459.1 |
373 | 2020-05-11 10:46:47 | granter | 1 | 69583 | 11 | 1.080 | 64428.7 |
372 | 2020-03-30 04:04:06 | granter | 1 | 69583 | 11 | 2.670 | 26061.0 |
371 | 2020-03-29 07:16:09 | granter | 1 | 69583 | 11 | 2.436 | 28564.4 |
370 | 2020-03-26 10:36:38 | granter | 1 | 69583 | 11 | 1.250 | 55666.4 |
369 | 2020-03-21 14:41:31 | granter | 1 | 69583 | 11 | 1.093 | 63662.4 |
368 | 2020-03-02 02:52:00 | granter | 1 | 69583 | 11 | 1.156 | 60192.9 |
367 | 2020-02-27 22:21:04 | granter | 1 | 69583 | 11 | 2.216 | 31400.3 |
366 | 2020-02-25 01:17:49 | granter | 1 | 69583 | 11 | 2.033 | 34226.8 |
365 | 2020-02-24 23:10:48 | granter | 1 | 69583 | 11 | 1.263 | 55093.4 |
364 | 2020-02-24 22:16:31 | granter | 1 | 69583 | 11 | 1.233 | 56433.9 |
363 | 2020-02-11 01:49:55 | granter | 1 | 69583 | 11 | 2.640 | 26357.2 |
362 | 2020-02-10 17:30:19 | granter | 1 | 69583 | 11 | 1.203 | 57841.2 |
361 | 2020-02-09 00:23:37 | granter | 1 | 69583 | 11 | 1.313 | 52995.4 |
360 | 2020-02-08 20:09:32 | granter | 1 | 69583 | 11 | 1.186 | 58670.3 |
359 | 2020-02-05 11:58:09 | granter | 1 | 69583 | 11 | 2.593 | 26834.9 |
358 | 2020-02-02 19:26:43 | granter | 1 | 69583 | 11 | 1.110 | 62687.4 |
357 | 2020-01-31 08:07:44 | granter | 1 | 69583 | 11 | 2.670 | 26061.0 |
356 | 2020-01-29 06:44:25 | granter | 1 | 69583 | 11 | 2.716 | 25619.7 |
355 | 2020-01-20 16:26:33 | granter | 1 | 69583 | 11 | 1.703 | 40859.1 |