History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"schmears"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
392 | 2025-04-14 19:10:22 | schmears | 3 | 146162 | 88 | 7.096 | 20597.8 |
391 | 2025-04-12 04:05:42 | schmears | 1 | 82945 | 4 | 7.160 | 11584.5 |
390 | 2025-04-04 07:10:51 | schmears | 1 | 82945 | 4 | 6.673 | 12429.9 |
389 | 2025-04-02 12:41:48 | schmears | 1 | 82945 | 4 | 8.673 | 9563.6 |
388 | 2025-04-01 07:09:53 | schmears | 1 | 82945 | 4 | 1.530 | 54212.4 |
387 | 2025-03-31 02:25:48 | schmears | 3 | 146162 | 88 | 36.843 | 3967.2 |
386 | 2025-03-29 15:06:09 | schmears | 1 | 82945 | 4 | 3.330 | 24908.4 |
385 | 2025-03-29 09:38:31 | schmears | 3 | 146162 | 88 | 30.206 | 4838.8 |
384 | 2025-03-29 02:38:35 | schmears | 1 | 82945 | 4 | 4.440 | 18681.3 |
383 | 2025-03-29 01:36:12 | schmears | 3 | 146162 | 88 | 43.456 | 3363.4 |
382 | 2025-03-29 00:25:18 | schmears | 4 | 161609 | 1019 | 61.016 | 2648.6 |
381 | 2025-03-27 17:22:46 | schmears | 1 | 82945 | 4 | 5.500 | 15080.9 |
380 | 2025-03-27 15:09:18 | schmears | 4 | 161609 | 1019 | 52.973 | 3050.8 |
379 | 2025-03-23 11:02:12 | schmears | 1 | 82945 | 4 | 11.233 | 7384.0 |
378 | 2025-03-18 15:17:28 | schmears | 3 | 146162 | 88 | 6.516 | 22431.2 |
377 | 2025-03-09 13:45:21 | schmears | 3 | 146162 | 88 | 52.986 | 2758.5 |
376 | 2025-03-07 23:04:48 | schmears | 3 | 146162 | 88 | 35.940 | 4066.8 |
375 | 2025-03-06 22:31:50 | schmears | 3 | 146162 | 88 | 20.766 | 7038.5 |
374 | 2025-03-06 22:31:41 | schmears | 2 | 121059 | 13 | 22.236 | 5444.3 |
373 | 2025-03-06 02:32:30 | schmears | 3 | 146162 | 88 | 38.270 | 3819.2 |
372 | 2025-03-03 15:08:43 | schmears | 3 | 146162 | 88 | 35.533 | 4113.4 |
371 | 2025-03-03 07:21:53 | schmears | 3 | 146162 | 88 | 40.263 | 3630.2 |
370 | 2025-02-27 08:16:53 | schmears | 1 | 82945 | 4 | 6.440 | 12879.7 |
369 | 2025-02-27 00:53:48 | schmears | 3 | 146162 | 88 | 35.046 | 4170.6 |
368 | 2025-02-27 00:53:28 | schmears | 2 | 121059 | 13 | 27.330 | 4429.5 |
367 | 2025-02-27 00:53:12 | schmears | 1 | 82945 | 4 | 4.596 | 18047.2 |
366 | 2025-02-21 05:29:18 | schmears | 4 | 161609 | 1019 | 79.050 | 2044.4 |
365 | 2025-02-20 22:43:07 | schmears | 4 | 161609 | 1019 | 73.096 | 2210.9 |
364 | 2025-02-20 22:35:52 | schmears | 4 | 161609 | 1019 | 54.163 | 2983.8 |
363 | 2025-02-20 06:32:51 | schmears | 4 | 161609 | 1019 | 65.206 | 2478.4 |
362 | 2025-02-19 21:49:00 | schmears | 4 | 161609 | 1019 | 63.916 | 2528.5 |
361 | 2025-02-14 16:07:48 | schmears | 1 | 82945 | 4 | 8.440 | 9827.6 |
360 | 2025-02-04 06:32:57 | schmears | 1 | 82945 | 4 | 1.546 | 53651.4 |
359 | 2025-01-26 23:21:37 | schmears | 1 | 82945 | 4 | 7.140 | 11616.9 |
358 | 2025-01-19 15:03:17 | schmears | 2 | 121059 | 13 | 17.436 | 6943.0 |
357 | 2025-01-19 11:58:55 | schmears | 2 | 121059 | 13 | 11.546 | 10484.9 |
356 | 2025-01-19 11:58:30 | schmears | 1 | 82945 | 4 | 7.220 | 11488.2 |
355 | 2025-01-18 09:50:46 | schmears | 4 | 161609 | 1019 | 64.116 | 2520.6 |
354 | 2025-01-18 01:33:58 | schmears | 3 | 146162 | 88 | 23.783 | 6145.7 |
353 | 2025-01-18 01:11:02 | schmears | 4 | 161609 | 1019 | 67.143 | 2406.9 |
352 | 2025-01-17 15:05:51 | schmears | 4 | 161609 | 1019 | 59.253 | 2727.4 |
351 | 2025-01-17 15:05:41 | schmears | 1 | 82945 | 4 | 3.780 | 21943.1 |
350 | 2025-01-17 15:03:36 | schmears | 3 | 146162 | 88 | 24.716 | 5913.7 |
349 | 2025-01-09 13:14:17 | schmears | 3 | 146162 | 88 | 28.186 | 5185.6 |
348 | 2025-01-09 05:59:49 | schmears | 3 | 146162 | 88 | 29.706 | 4920.3 |
347 | 2025-01-09 03:56:53 | schmears | 1 | 82945 | 4 | 5.796 | 14310.7 |
346 | 2025-01-05 10:17:26 | schmears | 3 | 146162 | 88 | 36.986 | 3951.8 |
345 | 2025-01-05 00:06:44 | schmears | 3 | 146162 | 88 | 8.920 | 16385.9 |
344 | 2024-12-28 18:25:32 | schmears | 1 | 82945 | 4 | 5.700 | 14551.8 |
343 | 2024-12-28 03:59:19 | schmears | 2 | 121059 | 13 | 16.113 | 7513.1 |
342 | 2024-12-27 18:46:53 | schmears | 2 | 121059 | 13 | 3.733 | 32429.4 |
341 | 2024-12-22 18:28:34 | schmears | 3 | 146162 | 88 | 39.316 | 3717.6 |
340 | 2024-12-17 07:53:35 | schmears | 3 | 146162 | 88 | 40.956 | 3568.8 |
339 | 2024-12-15 23:53:58 | schmears | 1 | 82945 | 4 | 10.640 | 7795.6 |
338 | 2024-12-14 06:08:57 | schmears | 4 | 161609 | 1019 | 60.626 | 2665.7 |
337 | 2024-12-12 10:41:56 | schmears | 4 | 161609 | 1019 | 54.143 | 2984.9 |
336 | 2024-12-09 21:00:50 | schmears | 1 | 82945 | 4 | 10.046 | 8256.5 |
335 | 2024-12-09 02:13:52 | schmears | 1 | 82945 | 4 | 3.266 | 25396.5 |
334 | 2024-12-09 02:13:35 | schmears | 2 | 121059 | 13 | 15.800 | 7662.0 |
333 | 2024-12-08 23:30:55 | schmears | 3 | 146162 | 88 | 7.093 | 20606.5 |
332 | 2024-12-06 12:38:54 | schmears | 3 | 146162 | 88 | 40.423 | 3615.8 |
331 | 2024-12-06 00:20:33 | schmears | 3 | 146162 | 88 | 8.016 | 18233.8 |
330 | 2024-12-06 00:20:34 | schmears | 2 | 121059 | 13 | 3.923 | 30858.8 |
329 | 2024-12-05 13:44:55 | schmears | 4 | 161609 | 1019 | 46.050 | 3509.4 |
328 | 2024-12-05 11:38:53 | schmears | 4 | 161609 | 1019 | 12.673 | 12752.2 |
327 | 2024-12-05 01:59:00 | schmears | 4 | 161609 | 1019 | 72.613 | 2225.6 |
326 | 2024-11-24 15:58:12 | schmears | 1 | 82945 | 4 | 9.956 | 8331.2 |
325 | 2024-11-23 01:03:19 | schmears | 4 | 161609 | 1019 | 37.080 | 4358.4 |
324 | 2024-11-13 17:42:21 | schmears | 1 | 82945 | 4 | 3.063 | 27079.7 |
323 | 2024-11-12 15:07:16 | schmears | 2 | 121059 | 13 | 10.940 | 11065.7 |
322 | 2024-11-12 07:10:29 | schmears | 3 | 146162 | 88 | 28.800 | 5075.1 |
321 | 2024-11-11 18:03:15 | schmears | 3 | 146162 | 88 | 29.500 | 4954.6 |
320 | 2024-11-06 02:24:22 | schmears | 2 | 121059 | 13 | 3.750 | 32282.4 |
319 | 2024-11-05 07:12:11 | schmears | 1 | 82945 | 4 | 5.766 | 14385.2 |
318 | 2024-11-04 11:19:52 | schmears | 3 | 146162 | 88 | 30.236 | 4834.0 |
317 | 2024-11-04 10:51:56 | schmears | 4 | 161609 | 1019 | 59.800 | 2702.5 |
316 | 2024-11-04 10:51:55 | schmears | 3 | 146162 | 88 | 25.940 | 5634.6 |
315 | 2024-11-03 15:49:53 | schmears | 4 | 161609 | 1019 | 69.350 | 2330.3 |
314 | 2024-10-31 02:50:01 | schmears | 4 | 161609 | 1019 | 53.720 | 3008.4 |
313 | 2024-10-31 02:50:00 | schmears | 2 | 121059 | 13 | 13.483 | 8978.6 |
312 | 2024-10-31 01:26:18 | schmears | 3 | 146162 | 88 | 7.750 | 18859.6 |
311 | 2024-10-12 02:14:19 | schmears | 4 | 161609 | 1019 | 71.330 | 2265.7 |
310 | 2024-10-12 02:13:39 | schmears | 1 | 82945 | 4 | 7.123 | 11644.7 |
309 | 2024-10-10 15:10:54 | schmears | 1 | 82945 | 4 | 1.516 | 54713.1 |
308 | 2024-10-08 15:41:02 | schmears | 2 | 121059 | 13 | 46.830 | 2585.1 |
307 | 2024-10-05 08:21:38 | schmears | 2 | 121059 | 13 | 6.563 | 18445.7 |
306 | 2024-10-05 08:21:32 | schmears | 3 | 146162 | 88 | 8.706 | 16788.7 |
305 | 2024-10-05 08:21:31 | schmears | 3 | 146162 | 88 | 7.546 | 19369.5 |
304 | 2024-10-05 08:21:29 | schmears | 1 | 82945 | 4 | 1.406 | 58993.6 |
303 | 2024-10-04 19:33:26 | schmears | 2 | 121059 | 13 | 21.783 | 5557.5 |
302 | 2024-10-01 10:19:10 | schmears | 2 | 121059 | 13 | 44.330 | 2730.9 |
301 | 2024-09-30 16:43:17 | schmears | 2 | 121059 | 13 | 36.300 | 3335.0 |
300 | 2024-09-30 16:43:15 | schmears | 2 | 121059 | 13 | 25.983 | 4659.2 |
299 | 2024-09-30 11:13:53 | schmears | 3 | 146162 | 88 | 70.126 | 2084.3 |
298 | 2024-09-30 11:13:59 | schmears | 3 | 146162 | 88 | 51.186 | 2855.5 |
297 | 2024-09-30 11:13:52 | schmears | 2 | 121059 | 13 | 43.046 | 2812.3 |
296 | 2024-09-23 06:53:51 | schmears | 1 | 82945 | 4 | 9.283 | 8935.2 |
295 | 2024-09-08 11:39:16 | schmears | 1 | 82945 | 4 | 6.220 | 13335.2 |
294 | 2024-09-02 07:16:11 | schmears | 1 | 82945 | 4 | 14.906 | 5564.5 |
293 | 2024-08-29 18:31:55 | schmears | 1 | 82945 | 4 | 14.126 | 5871.8 |