History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bertha"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
398 | 2024-05-02 05:09:53 | bertha | 1 | 48755 | 4 | 0.893 | 54596.9 |
397 | 2024-04-28 08:26:22 | bertha | 1 | 48755 | 4 | 0.923 | 52822.3 |
396 | 2024-04-28 04:55:45 | bertha | 1 | 48755 | 4 | 2.046 | 23829.4 |
395 | 2024-04-27 19:20:01 | bertha | 2 | 82551 | 13 | 2.593 | 31836.1 |
394 | 2024-04-03 07:53:40 | bertha | 1 | 48755 | 4 | 1.170 | 41670.9 |
393 | 2024-03-28 23:57:43 | bertha | 2 | 82551 | 13 | 7.596 | 10867.7 |
392 | 2024-03-28 08:44:10 | bertha | 1 | 48755 | 4 | 0.830 | 58741.0 |
391 | 2024-03-28 08:44:01 | bertha | 2 | 82551 | 13 | 2.483 | 33246.5 |
390 | 2024-03-28 08:43:57 | bertha | 1 | 48755 | 4 | 0.873 | 55847.7 |
389 | 2024-03-04 23:06:15 | bertha | 3 | 112716 | 271 | 18.483 | 6098.4 |
388 | 2024-03-04 14:48:05 | bertha | 3 | 112716 | 271 | 18.393 | 6128.2 |
387 | 2024-03-04 07:01:24 | bertha | 3 | 112716 | 271 | 6.466 | 17432.1 |
386 | 2024-03-04 03:44:08 | bertha | 2 | 82551 | 13 | 5.686 | 14518.3 |
385 | 2024-03-04 03:44:12 | bertha | 1 | 48755 | 4 | 1.860 | 26212.4 |
384 | 2024-03-04 03:44:06 | bertha | 3 | 112716 | 271 | 6.453 | 17467.2 |
383 | 2024-02-27 22:41:26 | bertha | 1 | 48755 | 4 | 1.953 | 24964.2 |
382 | 2024-02-06 03:32:33 | bertha | 2 | 82551 | 13 | 2.656 | 31080.9 |
381 | 2024-02-06 03:32:17 | bertha | 3 | 112716 | 271 | 5.470 | 20606.2 |
380 | 2024-01-30 20:10:28 | bertha | 2 | 82551 | 13 | 5.220 | 15814.4 |
379 | 2024-01-30 20:09:56 | bertha | 3 | 112716 | 271 | 5.843 | 19290.8 |
378 | 2024-01-30 00:06:16 | bertha | 1 | 48755 | 4 | 0.876 | 55656.4 |
377 | 2024-01-26 04:12:07 | bertha | 2 | 82551 | 13 | 5.373 | 15364.0 |
376 | 2024-01-26 04:11:55 | bertha | 3 | 112716 | 271 | 6.580 | 17130.1 |
375 | 2024-01-22 11:08:07 | bertha | 3 | 112716 | 271 | 12.376 | 9107.6 |
374 | 2024-01-22 02:27:04 | bertha | 3 | 112716 | 271 | 4.733 | 23814.9 |
373 | 2024-01-22 02:27:00 | bertha | 2 | 82551 | 13 | 2.546 | 32423.8 |
372 | 2024-01-17 03:04:35 | bertha | 1 | 48755 | 4 | 0.763 | 63899.1 |
371 | 2024-01-06 03:23:15 | bertha | 3 | 112716 | 271 | 5.560 | 20272.7 |
370 | 2023-12-09 23:08:12 | bertha | 1 | 48755 | 4 | 0.873 | 55847.7 |
369 | 2023-11-25 09:14:24 | bertha | 1 | 48755 | 4 | 0.796 | 61250.0 |
368 | 2023-11-18 16:54:37 | bertha | 1 | 48755 | 4 | 0.763 | 63899.1 |
367 | 2023-11-13 01:34:09 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
366 | 2023-11-12 16:35:12 | bertha | 1 | 48755 | 4 | 0.830 | 58741.0 |
365 | 2023-11-02 00:15:40 | bertha | 1 | 48755 | 4 | 0.846 | 57630.0 |
364 | 2023-11-01 15:13:57 | bertha | 3 | 112716 | 271 | 5.220 | 21593.1 |
363 | 2023-11-01 15:13:55 | bertha | 2 | 82551 | 13 | 2.560 | 32246.5 |
362 | 2023-10-31 11:47:54 | bertha | 3 | 112716 | 271 | 7.970 | 14142.5 |
361 | 2023-10-19 08:16:35 | bertha | 1 | 48755 | 4 | 0.890 | 54780.9 |
360 | 2023-10-17 13:50:57 | bertha | 3 | 112716 | 271 | 5.940 | 18975.8 |
359 | 2023-10-17 13:50:58 | bertha | 2 | 82551 | 13 | 3.483 | 23701.1 |
358 | 2023-10-11 00:12:30 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
357 | 2023-10-04 16:18:47 | bertha | 1 | 48755 | 4 | 0.826 | 59025.4 |
356 | 2023-09-24 04:33:31 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
355 | 2023-09-13 16:24:11 | bertha | 1 | 48755 | 4 | 0.890 | 54780.9 |
354 | 2023-08-31 21:08:27 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
353 | 2023-06-07 21:54:57 | bertha | 1 | 48755 | 4 | 0.813 | 59969.2 |
352 | 2023-06-04 16:16:41 | bertha | 1 | 48755 | 4 | 0.733 | 66514.3 |
351 | 2023-03-26 14:08:39 | bertha | 1 | 48755 | 4 | 0.813 | 59969.2 |
350 | 2023-02-23 04:19:04 | bertha | 1 | 48755 | 4 | 0.733 | 66514.3 |
349 | 2023-01-10 05:29:38 | bertha | 1 | 48755 | 4 | 1.673 | 29142.3 |
348 | 2022-11-02 18:48:43 | bertha | 1 | 48755 | 4 | 0.860 | 56691.9 |
347 | 2022-10-30 05:00:28 | bertha | 1 | 48755 | 4 | 0.780 | 62506.4 |
346 | 2022-10-16 08:24:42 | bertha | 1 | 48755 | 4 | 0.813 | 59969.2 |
345 | 2022-07-10 20:32:14 | bertha | 1 | 48755 | 4 | 0.733 | 66514.3 |
344 | 2022-07-03 03:02:44 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
343 | 2022-06-06 15:58:05 | bertha | 1 | 48755 | 4 | 0.860 | 56691.9 |
342 | 2022-03-09 05:05:33 | bertha | 1 | 48755 | 4 | 0.780 | 62506.4 |
341 | 2022-02-14 08:17:58 | bertha | 1 | 48755 | 4 | 0.796 | 61250.0 |
340 | 2021-12-07 21:31:41 | bertha | 1 | 48755 | 4 | 0.970 | 50262.9 |
339 | 2021-12-05 19:05:09 | bertha | 1 | 48755 | 4 | 0.890 | 54780.9 |
338 | 2021-11-28 20:30:27 | bertha | 1 | 48755 | 4 | 0.843 | 57835.1 |
337 | 2021-10-13 04:31:40 | bertha | 1 | 48755 | 4 | 0.766 | 63648.8 |
336 | 2021-09-11 09:43:44 | bertha | 1 | 48755 | 4 | 0.873 | 55847.7 |
335 | 2021-09-09 06:06:27 | bertha | 1 | 48755 | 4 | 0.893 | 54596.9 |
334 | 2021-08-24 19:10:46 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
333 | 2021-08-22 14:14:50 | bertha | 1 | 48755 | 4 | 0.813 | 59969.2 |
332 | 2021-08-15 21:53:44 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
331 | 2021-08-12 11:52:26 | bertha | 1 | 48755 | 4 | 0.910 | 53576.9 |
330 | 2021-05-01 15:50:55 | bertha | 1 | 48755 | 4 | 0.906 | 53813.5 |
329 | 2021-05-01 07:04:49 | bertha | 1 | 48755 | 4 | 1.156 | 42175.6 |
328 | 2021-02-08 08:42:48 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
327 | 2021-01-29 05:44:46 | bertha | 1 | 48755 | 4 | 0.876 | 55656.4 |
326 | 2021-01-27 06:44:55 | bertha | 1 | 48755 | 4 | 0.843 | 57835.1 |
325 | 2021-01-27 03:31:31 | bertha | 1 | 48755 | 4 | 0.813 | 59969.2 |
324 | 2020-12-15 07:29:38 | bertha | 1 | 48755 | 4 | 0.783 | 62266.9 |
323 | 2020-10-26 11:16:17 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
322 | 2020-10-15 10:56:12 | bertha | 1 | 48755 | 4 | 0.890 | 54780.9 |
321 | 2020-10-09 18:33:13 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
320 | 2020-09-25 18:47:38 | bertha | 1 | 48755 | 4 | 0.736 | 66243.2 |
319 | 2020-09-09 23:23:16 | bertha | 1 | 48755 | 4 | 0.826 | 59025.4 |
318 | 2020-08-23 11:33:25 | bertha | 1 | 48755 | 4 | 0.766 | 63648.8 |
317 | 2020-08-12 06:22:02 | bertha | 1 | 48755 | 4 | 0.970 | 50262.9 |
316 | 2020-07-25 18:40:37 | bertha | 1 | 48755 | 4 | 0.766 | 63648.8 |
315 | 2020-07-22 18:26:09 | bertha | 1 | 48755 | 4 | 0.766 | 63648.8 |
314 | 2020-07-21 17:27:11 | bertha | 1 | 48755 | 4 | 0.813 | 59969.2 |
313 | 2020-05-07 05:11:24 | bertha | 1 | 48755 | 4 | 0.750 | 65006.7 |
312 | 2020-04-20 19:58:55 | bertha | 1 | 48755 | 4 | 0.796 | 61250.0 |
311 | 2020-03-28 17:31:00 | bertha | 1 | 48755 | 4 | 0.920 | 52994.6 |
310 | 2020-03-28 05:37:27 | bertha | 1 | 48755 | 4 | 0.920 | 52994.6 |
309 | 2020-03-24 20:20:17 | bertha | 1 | 48755 | 4 | 1.186 | 41108.8 |
308 | 2020-03-23 13:15:32 | bertha | 1 | 48755 | 4 | 0.873 | 55847.7 |
307 | 2020-03-22 19:18:55 | bertha | 1 | 48755 | 4 | 0.920 | 52994.6 |
306 | 2020-03-19 22:52:16 | bertha | 1 | 48755 | 4 | 0.780 | 62506.4 |
305 | 2020-03-01 09:22:10 | bertha | 3 | 112716 | 271 | 9.420 | 11965.6 |
304 | 2020-03-01 08:48:55 | bertha | 1 | 48755 | 4 | 2.906 | 16777.4 |
303 | 2020-02-28 10:05:56 | bertha | 3 | 112716 | 271 | 17.826 | 6323.1 |
302 | 2020-02-28 09:00:05 | bertha | 3 | 112716 | 271 | 6.673 | 16891.4 |
301 | 2020-02-28 06:59:16 | bertha | 3 | 112716 | 271 | 6.123 | 18408.6 |
300 | 2020-02-27 15:48:45 | bertha | 3 | 112716 | 271 | 6.233 | 18083.7 |
299 | 2020-02-25 07:01:14 | bertha | 1 | 48755 | 4 | 1.706 | 28578.5 |