History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"granddad"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
405 | 2025-10-09 20:35:14 | granddad | 2 | 121059 | 14 | 3.503 | 34558.7 |
404 | 2025-09-26 06:53:01 | granddad | 1 | 82945 | 4 | 1.436 | 57761.1 |
403 | 2025-09-19 17:58:59 | granddad | 1 | 82945 | 4 | 1.470 | 56425.2 |
402 | 2025-09-08 22:53:01 | granddad | 4 | 161609 | 385 | 11.033 | 14647.8 |
401 | 2025-08-18 21:02:07 | granddad | 1 | 82945 | 4 | 6.970 | 11900.3 |
400 | 2025-08-17 05:19:10 | granddad | 4 | 161609 | 385 | 70.643 | 2287.7 |
399 | 2025-08-16 00:37:12 | granddad | 4 | 161609 | 385 | 22.063 | 7324.9 |
398 | 2025-08-15 06:19:31 | granddad | 4 | 161609 | 385 | 32.236 | 5013.3 |
397 | 2025-08-13 12:09:21 | granddad | 4 | 161609 | 385 | 59.160 | 2731.7 |
396 | 2025-08-09 23:00:34 | granddad | 4 | 161609 | 385 | 42.503 | 3802.3 |
395 | 2025-08-08 20:13:38 | granddad | 4 | 161609 | 385 | 13.206 | 12237.5 |
394 | 2025-08-04 12:44:15 | granddad | 1 | 82945 | 4 | 5.890 | 14082.3 |
393 | 2025-08-01 03:06:46 | granddad | 1 | 82945 | 4 | 6.456 | 12847.7 |
392 | 2025-07-25 15:18:09 | granddad | 2 | 121059 | 14 | 8.373 | 14458.3 |
391 | 2025-07-24 18:58:52 | granddad | 1 | 82945 | 4 | 3.560 | 23299.2 |
390 | 2025-07-22 17:18:09 | granddad | 1 | 82945 | 4 | 3.470 | 23903.5 |
389 | 2025-07-20 11:06:12 | granddad | 1 | 82945 | 4 | 1.453 | 57085.3 |
388 | 2025-07-17 04:34:29 | granddad | 2 | 121059 | 14 | 11.906 | 10167.9 |
387 | 2025-07-13 17:23:22 | granddad | 1 | 82945 | 4 | 1.610 | 51518.6 |
386 | 2025-07-12 21:48:42 | granddad | 1 | 82945 | 4 | 1.373 | 60411.5 |
385 | 2025-07-12 21:44:48 | granddad | 3 | 146162 | 56 | 10.373 | 14090.6 |
384 | 2025-07-12 13:19:44 | granddad | 3 | 146162 | 56 | 8.126 | 17987.0 |
383 | 2025-07-12 00:24:17 | granddad | 2 | 121059 | 14 | 11.486 | 10539.7 |
382 | 2025-07-09 17:07:50 | granddad | 1 | 82945 | 4 | 1.250 | 66356.0 |
381 | 2025-07-04 11:54:55 | granddad | 1 | 82945 | 4 | 4.030 | 20581.9 |
380 | 2025-07-03 02:21:54 | granddad | 3 | 146162 | 56 | 33.970 | 4302.7 |
379 | 2025-06-30 05:12:08 | granddad | 3 | 146162 | 56 | 30.860 | 4736.3 |
378 | 2025-06-28 16:15:57 | granddad | 3 | 146162 | 56 | 35.986 | 4061.6 |
377 | 2025-06-28 02:04:13 | granddad | 3 | 146162 | 56 | 25.266 | 5784.9 |
376 | 2025-06-28 00:25:29 | granddad | 3 | 146162 | 56 | 42.720 | 3421.4 |
375 | 2025-06-27 06:22:49 | granddad | 3 | 146162 | 56 | 38.333 | 3813.0 |
374 | 2025-06-27 04:52:21 | granddad | 3 | 146162 | 56 | 33.753 | 4330.3 |
373 | 2025-06-27 02:42:22 | granddad | 1 | 82945 | 4 | 4.343 | 19098.5 |
372 | 2025-06-24 02:43:54 | granddad | 3 | 146162 | 56 | 56.146 | 2603.2 |
371 | 2025-06-23 22:30:04 | granddad | 4 | 161609 | 385 | 63.896 | 2529.3 |
370 | 2025-06-23 13:15:52 | granddad | 1 | 82945 | 4 | 1.470 | 56425.2 |
369 | 2025-05-26 13:59:49 | granddad | 1 | 82945 | 4 | 9.643 | 8601.6 |
368 | 2025-05-26 07:40:35 | granddad | 4 | 161609 | 385 | 59.390 | 2721.1 |
367 | 2025-05-24 14:34:14 | granddad | 2 | 121059 | 14 | 15.186 | 7971.8 |
366 | 2025-05-22 13:17:37 | granddad | 1 | 82945 | 4 | 6.986 | 11873.0 |
365 | 2025-05-22 00:49:55 | granddad | 4 | 161609 | 385 | 61.566 | 2625.0 |
364 | 2025-05-21 22:50:25 | granddad | 4 | 161609 | 385 | 49.376 | 3273.0 |
363 | 2025-05-21 22:42:17 | granddad | 1 | 82945 | 4 | 9.533 | 8700.8 |
362 | 2025-05-20 13:11:38 | granddad | 1 | 82945 | 4 | 4.123 | 20117.6 |
361 | 2025-05-20 05:32:09 | granddad | 4 | 161609 | 385 | 82.566 | 1957.3 |
360 | 2025-05-19 09:06:31 | granddad | 4 | 161609 | 385 | 13.046 | 12387.6 |
359 | 2025-05-17 16:53:39 | granddad | 2 | 121059 | 14 | 4.360 | 27765.8 |
358 | 2025-05-16 19:50:26 | granddad | 4 | 161609 | 385 | 45.550 | 3547.9 |
357 | 2025-05-13 17:38:08 | granddad | 4 | 161609 | 385 | 12.750 | 12675.2 |
356 | 2025-05-12 04:37:27 | granddad | 1 | 82945 | 4 | 3.330 | 24908.4 |
355 | 2025-05-10 21:53:24 | granddad | 1 | 82945 | 4 | 3.280 | 25288.1 |
354 | 2025-05-01 02:37:01 | granddad | 4 | 161609 | 385 | 49.843 | 3242.4 |
353 | 2025-04-28 16:33:43 | granddad | 1 | 82945 | 4 | 3.326 | 24938.4 |
352 | 2025-04-21 00:46:29 | granddad | 4 | 161609 | 385 | 69.353 | 2330.2 |
351 | 2025-04-20 04:44:58 | granddad | 4 | 161609 | 385 | 63.046 | 2563.4 |
350 | 2025-04-18 23:44:11 | granddad | 4 | 161609 | 385 | 13.470 | 11997.7 |
349 | 2025-04-18 20:59:08 | granddad | 4 | 161609 | 385 | 73.600 | 2195.8 |
348 | 2025-04-16 01:09:55 | granddad | 4 | 161609 | 385 | 71.546 | 2258.8 |
347 | 2025-04-15 02:19:22 | granddad | 1 | 82945 | 4 | 1.486 | 55817.6 |
346 | 2025-04-09 04:35:57 | granddad | 3 | 146162 | 56 | 20.736 | 7048.7 |
345 | 2025-04-08 21:41:06 | granddad | 3 | 146162 | 56 | 37.846 | 3862.0 |
344 | 2025-04-07 14:59:41 | granddad | 3 | 146162 | 56 | 14.936 | 9785.9 |
343 | 2025-04-07 06:41:00 | granddad | 2 | 121059 | 14 | 18.596 | 6509.9 |
342 | 2025-04-04 21:41:15 | granddad | 2 | 121059 | 14 | 18.453 | 6560.4 |
341 | 2025-04-04 21:25:14 | granddad | 3 | 146162 | 56 | 38.326 | 3813.7 |
340 | 2025-04-03 08:56:45 | granddad | 2 | 121059 | 14 | 7.250 | 16697.8 |
339 | 2025-04-03 02:04:29 | granddad | 3 | 146162 | 56 | 10.516 | 13899.0 |
338 | 2025-03-31 14:12:23 | granddad | 1 | 82945 | 4 | 6.783 | 12228.4 |
337 | 2025-03-29 16:52:17 | granddad | 1 | 82945 | 4 | 10.406 | 7970.9 |
336 | 2025-03-20 19:10:27 | granddad | 1 | 82945 | 4 | 6.203 | 13371.8 |
335 | 2025-03-17 12:14:03 | granddad | 1 | 82945 | 4 | 6.983 | 11878.1 |
334 | 2025-03-16 12:35:55 | granddad | 4 | 161609 | 385 | 73.426 | 2201.0 |
333 | 2025-03-16 04:10:01 | granddad | 4 | 161609 | 385 | 61.986 | 2607.2 |
332 | 2025-03-14 23:32:26 | granddad | 4 | 161609 | 385 | 67.850 | 2381.9 |
331 | 2025-03-12 13:12:39 | granddad | 4 | 161609 | 385 | 81.586 | 1980.8 |
330 | 2025-03-12 13:05:35 | granddad | 4 | 161609 | 385 | 75.130 | 2151.1 |
329 | 2025-03-12 08:26:26 | granddad | 4 | 161609 | 385 | 69.596 | 2322.1 |
328 | 2025-03-11 19:01:40 | granddad | 4 | 161609 | 385 | 61.883 | 2611.5 |
327 | 2025-03-11 19:01:33 | granddad | 2 | 121059 | 14 | 22.703 | 5332.3 |
326 | 2025-03-11 18:48:40 | granddad | 1 | 82945 | 4 | 1.393 | 59544.1 |
325 | 2025-03-02 00:45:09 | granddad | 3 | 146162 | 56 | 14.656 | 9972.8 |
324 | 2025-02-28 21:09:21 | granddad | 3 | 146162 | 56 | 31.626 | 4621.6 |
323 | 2025-02-25 08:40:18 | granddad | 2 | 121059 | 14 | 3.796 | 31891.2 |
322 | 2025-02-25 04:19:21 | granddad | 3 | 146162 | 56 | 35.203 | 4152.0 |
321 | 2025-02-24 10:43:03 | granddad | 1 | 82945 | 4 | 6.923 | 11981.1 |
320 | 2025-02-23 21:40:40 | granddad | 3 | 146162 | 56 | 37.566 | 3890.8 |
319 | 2025-02-21 21:54:19 | granddad | 3 | 146162 | 56 | 52.063 | 2807.4 |
318 | 2025-02-19 16:22:21 | granddad | 3 | 146162 | 56 | 33.580 | 4352.7 |
317 | 2025-02-14 08:16:13 | granddad | 1 | 82945 | 4 | 3.110 | 26670.4 |
316 | 2025-02-11 10:34:03 | granddad | 1 | 82945 | 4 | 3.466 | 23931.0 |
315 | 2025-02-05 20:47:04 | granddad | 4 | 161609 | 385 | 37.626 | 4295.1 |
314 | 2025-02-05 18:47:25 | granddad | 4 | 161609 | 385 | 40.173 | 4022.8 |
313 | 2025-02-04 16:50:28 | granddad | 2 | 121059 | 14 | 19.110 | 6334.9 |
312 | 2025-02-01 14:05:54 | granddad | 2 | 121059 | 14 | 15.266 | 7930.0 |
311 | 2025-02-01 12:01:34 | granddad | 3 | 146162 | 56 | 9.546 | 15311.3 |
310 | 2025-02-01 12:01:32 | granddad | 3 | 146162 | 56 | 9.250 | 15801.3 |
309 | 2025-01-31 13:53:26 | granddad | 2 | 121059 | 14 | 13.393 | 9039.0 |
308 | 2025-01-23 11:49:53 | granddad | 2 | 121059 | 14 | 18.733 | 6462.3 |
307 | 2025-01-23 11:48:32 | granddad | 1 | 82945 | 4 | 5.720 | 14500.9 |
306 | 2025-01-22 23:34:53 | granddad | 3 | 146162 | 56 | 50.833 | 2875.3 |