History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"esquires"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
413 | 2024-04-27 02:58:52 | esquires | 1 | 82945 | 5 | 4.860 | 17066.9 |
412 | 2024-04-22 20:04:34 | esquires | 1 | 82945 | 5 | 1.376 | 60279.8 |
411 | 2024-04-06 06:21:21 | esquires | 3 | 146162 | 107 | 16.346 | 8941.8 |
410 | 2024-04-05 06:01:13 | esquires | 3 | 146162 | 107 | 9.376 | 15589.0 |
409 | 2024-03-31 21:22:18 | esquires | 2 | 121059 | 20 | 8.296 | 14592.5 |
408 | 2024-03-31 04:31:11 | esquires | 3 | 146162 | 107 | 18.706 | 7813.6 |
407 | 2024-03-31 04:31:10 | esquires | 2 | 121059 | 20 | 12.546 | 9649.2 |
406 | 2024-03-31 04:22:32 | esquires | 1 | 82945 | 5 | 1.623 | 51106.0 |
405 | 2024-03-29 05:24:12 | esquires | 3 | 146162 | 107 | 11.610 | 12589.3 |
404 | 2024-03-29 05:24:13 | esquires | 2 | 121059 | 20 | 7.310 | 16560.7 |
403 | 2024-03-29 05:24:06 | esquires | 1 | 82945 | 5 | 1.546 | 53651.4 |
402 | 2024-03-29 05:23:55 | esquires | 2 | 121059 | 20 | 6.576 | 18409.2 |
401 | 2024-03-29 05:23:35 | esquires | 1 | 82945 | 5 | 1.716 | 48336.2 |
400 | 2024-03-07 18:26:08 | esquires | 3 | 146162 | 107 | 15.233 | 9595.1 |
399 | 2024-03-07 03:38:03 | esquires | 3 | 146162 | 107 | 8.936 | 16356.5 |
398 | 2024-03-07 00:07:09 | esquires | 1 | 82945 | 5 | 3.373 | 24590.9 |
397 | 2024-03-05 22:59:26 | esquires | 3 | 146162 | 107 | 25.453 | 5742.4 |
396 | 2024-03-05 16:23:28 | esquires | 3 | 146162 | 107 | 7.483 | 19532.5 |
395 | 2024-02-29 20:24:21 | esquires | 1 | 82945 | 5 | 1.560 | 53169.9 |
394 | 2024-02-28 04:50:06 | esquires | 1 | 82945 | 5 | 3.826 | 21679.3 |
393 | 2024-01-17 18:31:33 | esquires | 2 | 121059 | 20 | 3.126 | 38726.5 |
392 | 2024-01-03 09:10:54 | esquires | 1 | 82945 | 5 | 1.546 | 53651.4 |
391 | 2023-12-26 05:20:26 | esquires | 1 | 82945 | 5 | 1.283 | 64649.3 |
390 | 2023-12-08 14:24:48 | esquires | 1 | 82945 | 5 | 1.533 | 54106.3 |
389 | 2023-11-28 23:59:58 | esquires | 1 | 82945 | 5 | 1.407 | 58951.7 |
388 | 2023-11-27 20:05:48 | esquires | 3 | 146162 | 107 | 6.656 | 21959.4 |
387 | 2023-11-19 20:43:31 | esquires | 1 | 82945 | 5 | 1.310 | 63316.8 |
386 | 2023-10-28 00:53:28 | esquires | 2 | 121059 | 20 | 3.263 | 37100.5 |
385 | 2023-10-25 10:33:22 | esquires | 1 | 82945 | 5 | 1.546 | 53651.4 |
384 | 2023-09-26 05:46:00 | esquires | 1 | 82945 | 5 | 1.373 | 60411.5 |
383 | 2023-09-14 21:23:53 | esquires | 1 | 82945 | 5 | 1.343 | 61761.0 |
382 | 2023-08-27 18:05:44 | esquires | 3 | 146162 | 107 | 6.046 | 24175.0 |
381 | 2023-08-27 07:18:03 | esquires | 1 | 82945 | 5 | 1.436 | 57761.1 |
380 | 2023-08-19 02:52:58 | esquires | 1 | 82945 | 5 | 1.360 | 60989.0 |
379 | 2023-08-05 20:28:10 | esquires | 2 | 121059 | 20 | 3.000 | 40353.0 |
378 | 2023-05-18 11:17:49 | esquires | 1 | 82945 | 5 | 1.376 | 60279.8 |
377 | 2023-05-13 19:24:23 | esquires | 3 | 146162 | 107 | 6.203 | 23563.1 |
376 | 2023-05-10 00:18:19 | esquires | 1 | 82945 | 5 | 1.250 | 66356.0 |
375 | 2023-04-19 23:44:21 | esquires | 2 | 121059 | 20 | 3.046 | 39743.6 |
374 | 2023-03-14 06:38:06 | esquires | 1 | 82945 | 5 | 1.356 | 61168.9 |
373 | 2023-02-20 11:31:07 | esquires | 3 | 146162 | 107 | 5.890 | 24815.3 |
372 | 2023-01-20 19:25:19 | esquires | 2 | 121059 | 20 | 3.030 | 39953.5 |
371 | 2023-01-20 11:24:22 | esquires | 1 | 82945 | 5 | 1.283 | 64649.3 |
370 | 2023-01-01 20:02:20 | esquires | 1 | 82945 | 5 | 1.236 | 67107.6 |
369 | 2022-12-13 06:38:55 | esquires | 3 | 146162 | 107 | 7.656 | 19091.2 |
368 | 2022-12-04 23:09:01 | esquires | 3 | 146162 | 107 | 6.813 | 21453.4 |
367 | 2022-12-03 15:48:21 | esquires | 3 | 146162 | 107 | 6.580 | 22213.1 |
366 | 2022-11-19 02:22:53 | esquires | 3 | 146162 | 107 | 5.986 | 24417.3 |
365 | 2022-10-30 22:17:46 | esquires | 2 | 121059 | 20 | 4.030 | 30039.5 |
364 | 2022-09-23 06:31:42 | esquires | 1 | 82945 | 5 | 1.436 | 57761.1 |
363 | 2022-09-21 20:10:17 | esquires | 1 | 82945 | 5 | 1.403 | 59119.7 |
362 | 2022-07-11 09:30:34 | esquires | 3 | 146162 | 107 | 6.096 | 23976.7 |
361 | 2022-06-01 08:47:07 | esquires | 2 | 121059 | 20 | 3.173 | 38152.9 |
360 | 2022-05-26 05:34:12 | esquires | 1 | 82945 | 5 | 1.326 | 62552.8 |
359 | 2022-05-06 18:32:42 | esquires | 1 | 82945 | 5 | 1.500 | 55296.7 |
358 | 2022-05-04 14:01:14 | esquires | 1 | 82945 | 5 | 1.376 | 60279.8 |
357 | 2022-03-20 08:28:03 | esquires | 3 | 146162 | 107 | 6.033 | 24227.1 |
356 | 2022-03-15 17:37:46 | esquires | 3 | 146162 | 107 | 6.970 | 20970.2 |
355 | 2022-03-15 04:15:08 | esquires | 3 | 146162 | 107 | 7.720 | 18932.9 |
354 | 2022-03-14 15:03:19 | esquires | 3 | 146162 | 107 | 6.720 | 21750.3 |
353 | 2022-03-13 15:46:54 | esquires | 3 | 146162 | 107 | 7.236 | 20199.3 |
352 | 2022-03-12 19:30:45 | esquires | 3 | 146162 | 107 | 7.606 | 19216.7 |
351 | 2022-03-12 03:40:32 | esquires | 3 | 146162 | 107 | 6.936 | 21073.0 |
350 | 2022-03-01 16:21:25 | esquires | 3 | 146162 | 107 | 7.623 | 19173.8 |
349 | 2022-03-01 10:28:49 | esquires | 3 | 146162 | 107 | 7.860 | 18595.7 |
348 | 2022-02-28 19:31:17 | esquires | 3 | 146162 | 107 | 7.593 | 19249.6 |
347 | 2022-02-27 23:13:30 | esquires | 3 | 146162 | 107 | 7.216 | 20255.3 |
346 | 2022-02-27 10:07:13 | esquires | 3 | 146162 | 107 | 7.016 | 20832.7 |
345 | 2022-02-26 13:49:48 | esquires | 3 | 146162 | 107 | 7.266 | 20115.9 |
344 | 2022-02-25 20:48:40 | esquires | 3 | 146162 | 107 | 6.140 | 23804.9 |
343 | 2022-02-25 11:51:31 | esquires | 3 | 146162 | 107 | 7.470 | 19566.5 |
342 | 2022-02-23 09:06:39 | esquires | 1 | 82945 | 5 | 1.470 | 56425.2 |
341 | 2022-02-13 11:34:44 | esquires | 3 | 146162 | 107 | 6.813 | 21453.4 |
340 | 2022-02-12 15:53:29 | esquires | 3 | 146162 | 107 | 6.423 | 22756.0 |
339 | 2022-02-11 21:00:10 | esquires | 3 | 146162 | 107 | 7.093 | 20606.5 |
338 | 2022-02-11 05:23:25 | esquires | 3 | 146162 | 107 | 6.250 | 23385.9 |
337 | 2022-02-10 18:37:52 | esquires | 3 | 146162 | 107 | 6.766 | 21602.4 |
336 | 2022-02-10 18:15:11 | esquires | 3 | 146162 | 107 | 6.000 | 24360.3 |
335 | 2022-02-10 06:36:04 | esquires | 3 | 146162 | 107 | 7.046 | 20744.0 |
334 | 2022-02-10 00:54:12 | esquires | 3 | 146162 | 107 | 6.170 | 23689.1 |
333 | 2022-02-09 21:16:31 | esquires | 3 | 146162 | 107 | 6.376 | 22923.8 |
332 | 2022-02-09 12:10:39 | esquires | 3 | 146162 | 107 | 6.843 | 21359.3 |
331 | 2022-02-09 11:39:25 | esquires | 3 | 146162 | 107 | 6.796 | 21507.1 |
330 | 2022-02-08 20:11:57 | esquires | 3 | 146162 | 107 | 7.423 | 19690.4 |
329 | 2022-02-08 19:54:30 | esquires | 3 | 146162 | 107 | 6.453 | 22650.2 |
328 | 2022-02-08 10:45:13 | esquires | 3 | 146162 | 107 | 7.263 | 20124.2 |
327 | 2022-02-08 02:22:21 | esquires | 3 | 146162 | 107 | 5.986 | 24417.3 |
326 | 2022-02-07 18:47:01 | esquires | 3 | 146162 | 107 | 6.516 | 22431.2 |
325 | 2022-02-06 23:23:35 | esquires | 3 | 146162 | 107 | 6.970 | 20970.2 |
324 | 2022-02-06 11:06:06 | esquires | 3 | 146162 | 107 | 6.970 | 20970.2 |
323 | 2022-02-05 13:27:33 | esquires | 3 | 146162 | 107 | 6.033 | 24227.1 |
322 | 2022-02-04 20:24:38 | esquires | 3 | 146162 | 107 | 6.436 | 22710.1 |
321 | 2022-02-03 23:21:27 | esquires | 3 | 146162 | 107 | 6.766 | 21602.4 |
320 | 2022-02-03 12:05:52 | esquires | 3 | 146162 | 107 | 7.016 | 20832.7 |
319 | 2022-02-03 03:27:23 | esquires | 3 | 146162 | 107 | 6.236 | 23438.4 |
318 | 2022-02-02 11:13:31 | esquires | 3 | 146162 | 107 | 7.233 | 20207.7 |
317 | 2022-02-01 15:44:25 | esquires | 3 | 146162 | 107 | 7.513 | 19454.5 |
316 | 2022-02-01 04:20:54 | esquires | 3 | 146162 | 107 | 5.890 | 24815.3 |
315 | 2022-01-31 11:17:49 | esquires | 3 | 146162 | 107 | 6.720 | 21750.3 |
314 | 2022-01-31 03:23:31 | esquires | 3 | 146162 | 107 | 6.063 | 24107.2 |