History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smiths"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
413 | 2024-05-03 06:58:00 | smiths | 1 | 48755 | 4 | 0.936 | 52088.7 |
412 | 2024-04-29 07:42:20 | smiths | 1 | 48755 | 4 | 1.076 | 45311.3 |
411 | 2024-04-27 23:27:43 | smiths | 1 | 48755 | 4 | 2.030 | 24017.2 |
410 | 2024-04-27 14:27:41 | smiths | 1 | 48755 | 4 | 2.063 | 23633.1 |
409 | 2024-04-22 15:27:18 | smiths | 2 | 82551 | 62 | 2.156 | 38289.0 |
408 | 2024-04-12 21:59:47 | smiths | 2 | 82551 | 62 | 2.766 | 29844.9 |
407 | 2024-04-12 21:59:33 | smiths | 2 | 82551 | 62 | 2.656 | 31080.9 |
406 | 2024-04-12 21:59:29 | smiths | 1 | 48755 | 4 | 0.953 | 51159.5 |
405 | 2024-04-12 21:59:04 | smiths | 3 | 112716 | 696 | 5.626 | 20034.8 |
404 | 2024-04-11 13:57:27 | smiths | 3 | 112716 | 696 | 9.656 | 11673.2 |
403 | 2024-04-05 13:39:11 | smiths | 3 | 112716 | 696 | 15.703 | 7178.0 |
402 | 2024-04-03 19:42:38 | smiths | 3 | 112716 | 696 | 10.563 | 10670.8 |
401 | 2024-04-03 15:26:32 | smiths | 2 | 82551 | 62 | 7.750 | 10651.7 |
400 | 2024-04-03 15:17:20 | smiths | 3 | 112716 | 696 | 6.576 | 17140.5 |
399 | 2024-04-03 11:36:36 | smiths | 3 | 112716 | 696 | 8.126 | 13871.0 |
398 | 2024-04-03 11:35:55 | smiths | 3 | 112716 | 696 | 6.080 | 18538.8 |
397 | 2024-04-03 11:35:54 | smiths | 2 | 82551 | 62 | 2.670 | 30918.0 |
396 | 2024-04-03 11:35:53 | smiths | 1 | 48755 | 4 | 0.876 | 55656.4 |
395 | 2024-03-28 07:15:33 | smiths | 1 | 48755 | 4 | 0.860 | 56691.9 |
394 | 2024-03-13 15:14:44 | smiths | 3 | 112716 | 696 | 7.080 | 15920.3 |
393 | 2024-03-08 18:44:29 | smiths | 1 | 48755 | 4 | 2.296 | 21234.8 |
392 | 2024-03-04 20:38:10 | smiths | 3 | 112716 | 696 | 11.673 | 9656.1 |
391 | 2024-03-04 16:22:34 | smiths | 2 | 82551 | 62 | 2.970 | 27794.9 |
390 | 2024-03-04 16:05:53 | smiths | 2 | 82551 | 62 | 2.406 | 34310.5 |
389 | 2024-03-04 16:05:53 | smiths | 1 | 48755 | 4 | 0.843 | 57835.1 |
388 | 2024-03-04 16:05:15 | smiths | 3 | 112716 | 696 | 5.970 | 18880.4 |
387 | 2024-03-04 07:00:49 | smiths | 3 | 112716 | 696 | 6.856 | 16440.5 |
386 | 2024-03-04 06:48:35 | smiths | 3 | 112716 | 696 | 6.266 | 17988.5 |
385 | 2024-03-04 06:48:36 | smiths | 2 | 82551 | 62 | 2.606 | 31677.3 |
384 | 2024-03-04 06:48:27 | smiths | 1 | 48755 | 4 | 0.796 | 61250.0 |
383 | 2024-02-26 21:19:20 | smiths | 1 | 48755 | 4 | 0.940 | 51867.0 |
382 | 2024-01-31 23:35:56 | smiths | 2 | 82551 | 62 | 2.530 | 32628.9 |
381 | 2024-01-31 23:29:36 | smiths | 3 | 112716 | 696 | 5.373 | 20978.2 |
380 | 2024-01-31 20:22:40 | smiths | 2 | 82551 | 62 | 2.686 | 30733.8 |
379 | 2024-01-31 20:18:19 | smiths | 3 | 112716 | 696 | 9.233 | 12207.9 |
378 | 2024-01-30 20:03:44 | smiths | 2 | 82551 | 62 | 2.716 | 30394.3 |
377 | 2024-01-30 20:03:00 | smiths | 3 | 112716 | 696 | 6.300 | 17891.4 |
376 | 2024-01-30 19:12:35 | smiths | 3 | 112716 | 696 | 5.516 | 20434.4 |
375 | 2024-01-21 03:20:32 | smiths | 1 | 48755 | 4 | 0.750 | 65006.7 |
374 | 2024-01-13 11:37:00 | smiths | 3 | 112716 | 696 | 4.610 | 24450.3 |
373 | 2024-01-12 11:35:39 | smiths | 3 | 112716 | 696 | 5.580 | 20200.0 |
372 | 2024-01-12 01:16:03 | smiths | 2 | 82551 | 62 | 2.470 | 33421.5 |
371 | 2024-01-09 06:28:44 | smiths | 1 | 48755 | 4 | 0.826 | 59025.4 |
370 | 2024-01-02 08:26:06 | smiths | 3 | 112716 | 696 | 6.030 | 18692.5 |
369 | 2024-01-02 07:41:07 | smiths | 3 | 112716 | 696 | 12.313 | 9154.2 |
368 | 2023-12-28 18:07:56 | smiths | 3 | 112716 | 696 | 5.640 | 19985.1 |
367 | 2023-12-18 13:15:06 | smiths | 2 | 82551 | 62 | 2.203 | 37472.1 |
366 | 2023-12-12 09:05:30 | smiths | 2 | 82551 | 62 | 2.186 | 37763.5 |
365 | 2023-12-12 08:32:43 | smiths | 3 | 112716 | 696 | 6.156 | 18309.9 |
364 | 2023-12-02 22:36:17 | smiths | 3 | 112716 | 696 | 6.610 | 17052.3 |
363 | 2023-12-02 15:18:59 | smiths | 1 | 48755 | 4 | 0.843 | 57835.1 |
362 | 2023-11-19 07:02:28 | smiths | 1 | 48755 | 4 | 0.906 | 53813.5 |
361 | 2023-11-17 04:30:19 | smiths | 1 | 48755 | 4 | 0.846 | 57630.0 |
360 | 2023-11-14 07:41:18 | smiths | 3 | 112716 | 696 | 5.593 | 20153.0 |
359 | 2023-11-01 14:07:50 | smiths | 1 | 48755 | 4 | 0.826 | 59025.4 |
358 | 2023-10-28 14:48:38 | smiths | 1 | 48755 | 4 | 0.873 | 55847.7 |
357 | 2023-10-22 15:31:20 | smiths | 3 | 112716 | 696 | 5.376 | 20966.5 |
356 | 2023-10-22 14:43:53 | smiths | 1 | 48755 | 4 | 0.846 | 57630.0 |
355 | 2023-10-19 08:15:58 | smiths | 1 | 48755 | 4 | 0.826 | 59025.4 |
354 | 2023-10-12 01:56:35 | smiths | 1 | 48755 | 4 | 0.860 | 56691.9 |
353 | 2023-09-26 08:21:04 | smiths | 1 | 48755 | 4 | 0.813 | 59969.2 |
352 | 2023-09-17 07:50:35 | smiths | 2 | 82551 | 62 | 2.123 | 38884.1 |
351 | 2023-09-13 14:50:11 | smiths | 1 | 48755 | 4 | 0.813 | 59969.2 |
350 | 2023-08-25 02:31:46 | smiths | 1 | 48755 | 4 | 0.766 | 63648.8 |
349 | 2023-07-31 19:59:35 | smiths | 3 | 112716 | 696 | 5.390 | 20912.1 |
348 | 2023-07-14 08:13:26 | smiths | 1 | 48755 | 4 | 0.750 | 65006.7 |
347 | 2023-06-08 21:47:00 | smiths | 2 | 82551 | 62 | 2.563 | 32208.7 |
346 | 2023-05-30 03:52:50 | smiths | 3 | 112716 | 696 | 4.670 | 24136.2 |
345 | 2023-05-23 17:19:26 | smiths | 1 | 48755 | 4 | 0.813 | 59969.2 |
344 | 2023-04-12 01:09:41 | smiths | 3 | 112716 | 696 | 5.503 | 20482.6 |
343 | 2023-04-07 03:23:21 | smiths | 3 | 112716 | 696 | 4.216 | 26735.3 |
342 | 2023-03-23 05:56:48 | smiths | 1 | 48755 | 4 | 0.736 | 66243.2 |
341 | 2023-03-21 12:16:17 | smiths | 3 | 112716 | 696 | 4.733 | 23814.9 |
340 | 2023-03-11 19:55:30 | smiths | 2 | 82551 | 62 | 2.420 | 34112.0 |
339 | 2023-03-06 14:54:29 | smiths | 1 | 48755 | 4 | 1.186 | 41108.8 |
338 | 2023-02-16 16:25:34 | smiths | 3 | 112716 | 696 | 5.360 | 21029.1 |
337 | 2023-01-09 08:11:39 | smiths | 1 | 48755 | 4 | 0.733 | 66514.3 |
336 | 2023-01-05 09:14:41 | smiths | 3 | 112716 | 696 | 4.576 | 24632.0 |
335 | 2022-12-28 03:53:48 | smiths | 3 | 112716 | 696 | 5.280 | 21347.7 |
334 | 2022-12-15 05:12:59 | smiths | 2 | 82551 | 62 | 2.750 | 30018.5 |
333 | 2022-12-11 17:55:06 | smiths | 3 | 112716 | 696 | 4.750 | 23729.7 |
332 | 2022-11-18 01:24:08 | smiths | 3 | 112716 | 696 | 4.656 | 24208.8 |
331 | 2022-11-13 11:49:44 | smiths | 3 | 112716 | 696 | 4.733 | 23814.9 |
330 | 2022-10-20 14:21:44 | smiths | 1 | 48755 | 4 | 0.716 | 68093.6 |
329 | 2022-10-05 14:16:25 | smiths | 1 | 48755 | 4 | 0.766 | 63648.8 |
328 | 2022-09-10 12:43:38 | smiths | 3 | 112716 | 696 | 4.703 | 23966.8 |
327 | 2022-08-02 11:49:16 | smiths | 2 | 82551 | 62 | 2.123 | 38884.1 |
326 | 2022-07-31 04:53:15 | smiths | 2 | 82551 | 62 | 2.110 | 39123.7 |
325 | 2022-07-29 06:16:08 | smiths | 1 | 48755 | 4 | 0.813 | 59969.2 |
324 | 2022-06-15 09:42:31 | smiths | 1 | 48755 | 4 | 0.826 | 59025.4 |
323 | 2022-05-24 04:32:49 | smiths | 1 | 48755 | 4 | 0.766 | 63648.8 |
322 | 2022-03-01 22:56:43 | smiths | 2 | 82551 | 62 | 2.796 | 29524.7 |
321 | 2022-02-09 20:07:11 | smiths | 1 | 48755 | 4 | 0.796 | 61250.0 |
320 | 2022-02-07 15:57:10 | smiths | 1 | 48755 | 4 | 0.750 | 65006.7 |
319 | 2022-02-07 10:51:28 | smiths | 1 | 48755 | 4 | 0.860 | 56691.9 |
318 | 2021-11-27 22:54:44 | smiths | 2 | 82551 | 62 | 2.580 | 31996.5 |
317 | 2021-11-27 09:23:04 | smiths | 1 | 48755 | 4 | 0.953 | 51159.5 |
316 | 2021-10-14 12:06:48 | smiths | 1 | 48755 | 4 | 0.843 | 57835.1 |
315 | 2021-10-10 23:15:22 | smiths | 1 | 48755 | 4 | 1.780 | 27390.4 |
314 | 2021-10-08 21:38:34 | smiths | 1 | 48755 | 4 | 0.843 | 57835.1 |