History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"vicar"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
391 | 2024-04-22 19:25:09 | vicar | 1 | 28756 | 2 | 0.470 | 61183.0 |
390 | 2024-04-06 11:17:11 | vicar | 1 | 28756 | 2 | 2.046 | 14054.7 |
389 | 2024-03-31 15:18:29 | vicar | 1 | 28756 | 2 | 0.500 | 57512.0 |
388 | 2024-03-29 06:49:55 | vicar | 3 | 83667 | 808 | 13.516 | 6190.2 |
387 | 2024-03-29 06:49:56 | vicar | 2 | 53800 | 70 | 1.780 | 30224.7 |
386 | 2024-03-29 04:27:17 | vicar | 1 | 28756 | 2 | 0.530 | 54256.6 |
385 | 2024-03-09 02:06:27 | vicar | 2 | 53800 | 70 | 1.970 | 27309.6 |
384 | 2024-03-09 02:05:36 | vicar | 3 | 83667 | 808 | 4.530 | 18469.5 |
383 | 2024-03-08 18:55:56 | vicar | 2 | 53800 | 70 | 5.313 | 10126.1 |
382 | 2024-03-08 18:55:27 | vicar | 1 | 28756 | 2 | 1.623 | 17717.8 |
381 | 2024-03-08 18:54:54 | vicar | 3 | 83667 | 808 | 4.503 | 18580.3 |
380 | 2024-03-07 08:22:57 | vicar | 3 | 83667 | 808 | 13.580 | 6161.0 |
379 | 2024-03-07 08:23:02 | vicar | 2 | 53800 | 70 | 5.486 | 9806.8 |
378 | 2024-03-07 05:26:55 | vicar | 1 | 28756 | 2 | 0.423 | 67981.1 |
377 | 2024-03-01 12:03:29 | vicar | 1 | 28756 | 2 | 0.516 | 55728.7 |
376 | 2024-02-28 02:27:49 | vicar | 1 | 28756 | 2 | 1.420 | 20250.7 |
375 | 2024-02-04 06:41:56 | vicar | 1 | 28756 | 2 | 0.983 | 29253.3 |
374 | 2024-02-03 23:43:11 | vicar | 1 | 28756 | 2 | 0.470 | 61183.0 |
373 | 2024-01-29 09:01:15 | vicar | 1 | 28756 | 2 | 0.513 | 56054.6 |
372 | 2024-01-29 01:11:25 | vicar | 1 | 28756 | 2 | 0.420 | 68466.7 |
371 | 2024-01-05 06:49:53 | vicar | 1 | 28756 | 2 | 0.436 | 65954.1 |
370 | 2023-12-25 01:04:38 | vicar | 3 | 83667 | 808 | 3.360 | 24900.9 |
369 | 2023-12-25 01:04:39 | vicar | 2 | 53800 | 70 | 1.516 | 35488.1 |
368 | 2023-11-28 02:14:06 | vicar | 3 | 83667 | 808 | 3.626 | 23074.2 |
367 | 2023-11-28 02:14:03 | vicar | 2 | 53800 | 70 | 1.453 | 37026.8 |
366 | 2023-11-18 00:35:59 | vicar | 3 | 83667 | 808 | 3.716 | 22515.3 |
365 | 2023-11-18 00:35:55 | vicar | 2 | 53800 | 70 | 1.530 | 35163.4 |
364 | 2023-11-12 09:38:40 | vicar | 1 | 28756 | 2 | 0.436 | 65954.1 |
363 | 2023-11-10 05:56:53 | vicar | 1 | 28756 | 2 | 1.063 | 27051.7 |
362 | 2023-11-03 13:22:41 | vicar | 1 | 28756 | 2 | 0.423 | 67981.1 |
361 | 2023-10-27 20:24:45 | vicar | 1 | 28756 | 2 | 0.516 | 55728.7 |
360 | 2023-10-21 12:37:46 | vicar | 1 | 28756 | 2 | 0.530 | 54256.6 |
359 | 2023-10-18 11:33:59 | vicar | 1 | 28756 | 2 | 0.486 | 59168.7 |
358 | 2023-10-16 19:42:24 | vicar | 2 | 53800 | 70 | 4.860 | 11070.0 |
357 | 2023-10-16 19:26:57 | vicar | 3 | 83667 | 808 | 6.720 | 12450.4 |
356 | 2023-10-16 16:24:12 | vicar | 3 | 83667 | 808 | 3.220 | 25983.5 |
355 | 2023-10-16 16:24:09 | vicar | 2 | 53800 | 70 | 1.313 | 40974.9 |
354 | 2023-10-11 00:32:23 | vicar | 1 | 28756 | 2 | 0.436 | 65954.1 |
353 | 2023-10-05 04:21:17 | vicar | 1 | 28756 | 2 | 0.420 | 68466.7 |
352 | 2023-09-28 03:37:10 | vicar | 2 | 53800 | 70 | 1.483 | 36277.8 |
351 | 2023-09-26 06:34:32 | vicar | 1 | 28756 | 2 | 0.436 | 65954.1 |
350 | 2023-09-19 20:40:53 | vicar | 1 | 28756 | 2 | 0.483 | 59536.2 |
349 | 2023-09-19 19:34:05 | vicar | 3 | 83667 | 808 | 3.843 | 21771.3 |
348 | 2023-09-17 07:57:41 | vicar | 3 | 83667 | 808 | 3.686 | 22698.6 |
347 | 2023-09-17 07:57:40 | vicar | 2 | 53800 | 70 | 1.530 | 35163.4 |
346 | 2023-09-10 17:23:34 | vicar | 1 | 28756 | 2 | 0.423 | 67981.1 |
345 | 2023-08-22 19:18:30 | vicar | 1 | 28756 | 2 | 0.440 | 65354.5 |
344 | 2023-05-27 03:39:18 | vicar | 1 | 28756 | 2 | 0.420 | 68466.7 |
343 | 2023-05-23 02:09:58 | vicar | 1 | 28756 | 2 | 0.423 | 67981.1 |
342 | 2023-03-18 06:10:14 | vicar | 1 | 28756 | 2 | 0.423 | 67981.1 |
341 | 2023-02-03 16:25:18 | vicar | 1 | 28756 | 2 | 0.420 | 68466.7 |
340 | 2023-01-05 21:24:49 | vicar | 1 | 28756 | 2 | 0.466 | 61708.2 |
339 | 2022-12-21 17:05:39 | vicar | 1 | 28756 | 2 | 0.500 | 57512.0 |
338 | 2022-11-29 02:26:24 | vicar | 1 | 28756 | 2 | 0.483 | 59536.2 |
337 | 2022-10-06 04:20:55 | vicar | 1 | 28756 | 2 | 0.440 | 65354.5 |
336 | 2022-09-29 16:53:52 | vicar | 1 | 28756 | 2 | 0.423 | 67981.1 |
335 | 2022-09-20 03:51:28 | vicar | 1 | 28756 | 2 | 0.423 | 67981.1 |
334 | 2022-08-14 22:25:01 | vicar | 1 | 28756 | 2 | 0.423 | 67981.1 |
333 | 2022-07-29 06:36:07 | vicar | 1 | 28756 | 2 | 0.436 | 65954.1 |
332 | 2022-07-19 01:15:14 | vicar | 1 | 28756 | 2 | 0.483 | 59536.2 |
331 | 2022-06-08 09:00:33 | vicar | 1 | 28756 | 2 | 0.533 | 53951.2 |
330 | 2022-06-04 17:51:04 | vicar | 1 | 28756 | 2 | 0.436 | 65954.1 |
329 | 2022-02-04 01:42:49 | vicar | 1 | 28756 | 2 | 0.436 | 65954.1 |
328 | 2022-01-25 18:38:25 | vicar | 1 | 28756 | 2 | 0.436 | 65954.1 |
327 | 2022-01-23 14:07:01 | vicar | 1 | 28756 | 2 | 0.500 | 57512.0 |
326 | 2021-11-17 00:34:32 | vicar | 1 | 28756 | 2 | 0.440 | 65354.5 |
325 | 2021-11-14 23:09:18 | vicar | 1 | 28756 | 2 | 0.500 | 57512.0 |
324 | 2021-10-14 16:52:43 | vicar | 1 | 28756 | 2 | 1.406 | 20452.3 |
323 | 2021-07-09 21:52:27 | vicar | 1 | 28756 | 2 | 0.513 | 56054.6 |
322 | 2021-05-31 15:05:09 | vicar | 1 | 28756 | 2 | 0.500 | 57512.0 |
321 | 2021-04-06 01:29:48 | vicar | 1 | 28756 | 2 | 0.513 | 56054.6 |
320 | 2021-04-04 13:41:13 | vicar | 1 | 28756 | 2 | 0.420 | 68466.7 |
319 | 2021-04-01 21:18:03 | vicar | 1 | 28756 | 2 | 0.470 | 61183.0 |
318 | 2021-02-12 19:45:48 | vicar | 1 | 28756 | 2 | 0.486 | 59168.7 |
317 | 2020-12-20 23:15:06 | vicar | 1 | 28756 | 2 | 0.436 | 65954.1 |
316 | 2020-12-20 12:24:15 | vicar | 1 | 28756 | 2 | 0.420 | 68466.7 |
315 | 2020-10-30 19:25:39 | vicar | 1 | 28756 | 2 | 0.483 | 59536.2 |
314 | 2020-10-24 22:24:18 | vicar | 1 | 28756 | 2 | 0.483 | 59536.2 |
313 | 2020-10-23 07:33:00 | vicar | 1 | 28756 | 2 | 0.483 | 59536.2 |
312 | 2020-10-16 05:30:15 | vicar | 1 | 28756 | 2 | 0.483 | 59536.2 |
311 | 2020-10-15 08:51:16 | vicar | 1 | 28756 | 2 | 0.453 | 63479.0 |
310 | 2020-09-17 00:01:52 | vicar | 1 | 28756 | 2 | 0.466 | 61708.2 |
309 | 2020-05-26 04:38:24 | vicar | 1 | 28756 | 2 | 0.440 | 65354.5 |
308 | 2020-03-28 00:28:30 | vicar | 1 | 28756 | 2 | 0.593 | 48492.4 |
307 | 2020-03-26 06:04:02 | vicar | 1 | 28756 | 2 | 0.986 | 29164.3 |
306 | 2020-03-25 04:04:14 | vicar | 1 | 28756 | 2 | 0.483 | 59536.2 |
305 | 2020-03-23 01:16:45 | vicar | 1 | 28756 | 2 | 0.516 | 55728.7 |
304 | 2020-03-23 00:04:22 | vicar | 1 | 28756 | 2 | 0.530 | 54256.6 |
303 | 2020-03-21 03:30:05 | vicar | 1 | 28756 | 2 | 0.483 | 59536.2 |
302 | 2020-03-20 16:24:19 | vicar | 1 | 28756 | 2 | 0.470 | 61183.0 |
301 | 2020-03-18 02:15:47 | vicar | 1 | 28756 | 2 | 0.423 | 67981.1 |
300 | 2020-02-26 22:33:05 | vicar | 1 | 28756 | 2 | 0.610 | 47141.0 |
299 | 2020-02-23 17:23:01 | vicar | 1 | 28756 | 2 | 0.923 | 31154.9 |
298 | 2020-02-20 08:23:51 | vicar | 1 | 28756 | 2 | 1.063 | 27051.7 |
297 | 2020-02-18 18:50:17 | vicar | 1 | 28756 | 2 | 0.513 | 56054.6 |
296 | 2020-02-17 02:44:00 | vicar | 1 | 28756 | 2 | 1.106 | 26000.0 |
295 | 2020-02-14 08:21:04 | vicar | 1 | 28756 | 2 | 0.593 | 48492.4 |
294 | 2020-02-10 15:57:34 | vicar | 1 | 28756 | 2 | 0.546 | 52666.7 |
293 | 2020-01-30 06:51:35 | vicar | 1 | 28756 | 2 | 1.096 | 26237.2 |
292 | 2020-01-30 00:57:13 | vicar | 1 | 28756 | 2 | 0.763 | 37688.1 |