History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substantial"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
393 | 2025-06-27 20:53:47 | substantial | 1 | 49908 | 3 | 1.796 | 27788.4 |
392 | 2025-06-13 23:21:20 | substantial | 1 | 49908 | 3 | 1.860 | 26832.3 |
391 | 2025-06-12 13:00:06 | substantial | 4 | 148819 | 41 | 24.283 | 6128.5 |
390 | 2025-06-12 10:05:05 | substantial | 2 | 86808 | 8 | 9.846 | 8816.6 |
389 | 2025-06-12 04:20:52 | substantial | 3 | 121633 | 16 | 20.643 | 5892.2 |
388 | 2025-06-07 19:06:33 | substantial | 4 | 148819 | 41 | 42.383 | 3511.3 |
387 | 2025-06-07 08:10:00 | substantial | 2 | 86808 | 8 | 3.313 | 26202.2 |
386 | 2025-06-07 06:15:13 | substantial | 3 | 121633 | 16 | 4.360 | 27897.5 |
385 | 2025-05-28 19:26:50 | substantial | 1 | 49908 | 3 | 0.873 | 57168.4 |
384 | 2025-05-26 04:03:36 | substantial | 1 | 49908 | 3 | 4.390 | 11368.6 |
383 | 2025-05-21 23:32:01 | substantial | 1 | 49908 | 3 | 4.170 | 11968.3 |
382 | 2025-05-12 01:54:06 | substantial | 1 | 49908 | 3 | 3.923 | 12721.9 |
381 | 2025-05-04 01:23:55 | substantial | 1 | 49908 | 3 | 1.860 | 26832.3 |
380 | 2025-04-23 03:17:54 | substantial | 1 | 49908 | 3 | 2.143 | 23288.8 |
379 | 2025-04-22 19:25:32 | substantial | 1 | 49908 | 3 | 3.000 | 16636.0 |
378 | 2025-04-19 22:36:46 | substantial | 1 | 49908 | 3 | 2.220 | 22481.1 |
377 | 2025-03-20 23:08:37 | substantial | 1 | 49908 | 3 | 2.173 | 22967.3 |
376 | 2025-03-19 20:39:04 | substantial | 1 | 49908 | 3 | 2.966 | 16826.7 |
375 | 2025-02-21 05:01:16 | substantial | 1 | 49908 | 3 | 2.233 | 22350.2 |
374 | 2025-02-20 04:34:29 | substantial | 3 | 121633 | 16 | 25.860 | 4703.5 |
373 | 2025-02-20 04:34:17 | substantial | 2 | 86808 | 8 | 11.986 | 7242.4 |
372 | 2025-02-19 07:41:37 | substantial | 3 | 121633 | 16 | 25.783 | 4717.6 |
371 | 2025-02-19 07:41:38 | substantial | 2 | 86808 | 8 | 16.580 | 5235.7 |
370 | 2025-02-19 07:25:04 | substantial | 1 | 49908 | 3 | 3.703 | 13477.7 |
369 | 2025-02-17 21:17:38 | substantial | 4 | 148819 | 41 | 47.736 | 3117.5 |
368 | 2025-02-16 17:26:59 | substantial | 1 | 49908 | 3 | 4.046 | 12335.1 |
367 | 2025-02-13 13:57:39 | substantial | 4 | 148819 | 41 | 49.486 | 3007.3 |
366 | 2025-02-11 18:01:12 | substantial | 4 | 148819 | 41 | 45.753 | 3252.7 |
365 | 2025-02-11 11:21:00 | substantial | 3 | 121633 | 16 | 12.940 | 9399.8 |
364 | 2025-02-11 11:20:55 | substantial | 2 | 86808 | 8 | 5.376 | 16147.3 |
363 | 2025-02-11 10:10:13 | substantial | 1 | 49908 | 3 | 0.876 | 56972.6 |
362 | 2025-01-21 02:16:33 | substantial | 3 | 121633 | 16 | 29.940 | 4062.6 |
361 | 2025-01-21 02:16:47 | substantial | 2 | 86808 | 8 | 11.750 | 7387.9 |
360 | 2025-01-21 02:15:53 | substantial | 1 | 49908 | 3 | 2.626 | 19005.3 |
359 | 2025-01-14 21:50:23 | substantial | 4 | 148819 | 41 | 58.483 | 2544.7 |
358 | 2025-01-13 22:59:18 | substantial | 4 | 148819 | 41 | 44.203 | 3366.7 |
357 | 2025-01-13 11:02:49 | substantial | 5 | 164607 | 174 | 93.473 | 1761.0 |
356 | 2025-01-13 11:02:48 | substantial | 4 | 148819 | 41 | 44.656 | 3332.6 |
355 | 2025-01-13 11:02:48 | substantial | 3 | 121633 | 16 | 16.173 | 7520.7 |
354 | 2025-01-13 11:02:48 | substantial | 2 | 86808 | 8 | 10.923 | 7947.3 |
353 | 2025-01-13 09:34:51 | substantial | 5 | 164607 | 174 | 87.223 | 1887.2 |
352 | 2025-01-13 09:34:58 | substantial | 3 | 121633 | 16 | 23.643 | 5144.6 |
351 | 2025-01-13 09:34:54 | substantial | 2 | 86808 | 8 | 7.220 | 12023.3 |
350 | 2025-01-07 09:23:53 | substantial | 4 | 148819 | 41 | 24.093 | 6176.9 |
349 | 2025-01-07 05:59:54 | substantial | 1 | 49908 | 3 | 4.640 | 10756.0 |
348 | 2025-01-07 03:10:19 | substantial | 1 | 49908 | 3 | 4.060 | 12292.6 |
347 | 2025-01-04 08:34:39 | substantial | 1 | 49908 | 3 | 4.016 | 12427.3 |
346 | 2024-12-16 01:25:07 | substantial | 1 | 49908 | 3 | 4.033 | 12374.9 |
345 | 2024-12-15 02:45:15 | substantial | 3 | 121633 | 16 | 23.983 | 5071.6 |
344 | 2024-12-13 03:10:40 | substantial | 4 | 148819 | 41 | 36.953 | 4027.3 |
343 | 2024-12-11 21:26:54 | substantial | 3 | 121633 | 16 | 25.986 | 4680.7 |
342 | 2024-12-11 21:26:46 | substantial | 2 | 86808 | 8 | 13.140 | 6606.4 |
341 | 2024-12-07 17:34:32 | substantial | 3 | 121633 | 16 | 21.046 | 5779.4 |
340 | 2024-12-07 17:34:34 | substantial | 2 | 86808 | 8 | 5.813 | 14933.4 |
339 | 2024-12-07 17:33:15 | substantial | 1 | 49908 | 3 | 5.233 | 9537.2 |
338 | 2024-12-05 01:54:30 | substantial | 2 | 86808 | 8 | 11.626 | 7466.7 |
337 | 2024-12-05 01:07:27 | substantial | 4 | 148819 | 41 | 33.063 | 4501.1 |
336 | 2024-12-03 11:25:28 | substantial | 4 | 148819 | 41 | 61.080 | 2436.5 |
335 | 2024-12-03 00:41:13 | substantial | 4 | 148819 | 41 | 45.843 | 3246.3 |
334 | 2024-12-03 00:41:10 | substantial | 4 | 148819 | 41 | 39.300 | 3786.7 |
333 | 2024-12-03 00:41:17 | substantial | 2 | 86808 | 8 | 11.716 | 7409.4 |
332 | 2024-12-03 00:40:16 | substantial | 1 | 49908 | 3 | 1.810 | 27573.5 |
331 | 2024-11-30 23:15:13 | substantial | 1 | 49908 | 3 | 3.936 | 12679.9 |
330 | 2024-11-16 15:44:07 | substantial | 4 | 148819 | 41 | 56.880 | 2616.4 |
329 | 2024-11-14 22:05:04 | substantial | 3 | 121633 | 16 | 26.016 | 4675.3 |
328 | 2024-11-13 01:01:57 | substantial | 3 | 121633 | 16 | 26.843 | 4531.3 |
327 | 2024-11-12 12:17:33 | substantial | 1 | 49908 | 3 | 2.016 | 24756.0 |
326 | 2024-11-02 05:54:18 | substantial | 4 | 148819 | 41 | 45.503 | 3270.5 |
325 | 2024-11-02 05:54:15 | substantial | 3 | 121633 | 16 | 34.593 | 3516.1 |
324 | 2024-11-02 05:54:07 | substantial | 2 | 86808 | 8 | 9.110 | 9528.9 |
323 | 2024-11-01 19:53:15 | substantial | 4 | 148819 | 41 | 46.096 | 3228.5 |
322 | 2024-11-01 19:53:09 | substantial | 4 | 148819 | 41 | 49.100 | 3030.9 |
321 | 2024-11-01 19:53:12 | substantial | 3 | 121633 | 16 | 23.430 | 5191.3 |
320 | 2024-11-01 19:53:15 | substantial | 2 | 86808 | 8 | 9.986 | 8693.0 |
319 | 2024-11-01 19:52:00 | substantial | 1 | 49908 | 3 | 4.096 | 12184.6 |
318 | 2024-10-28 17:27:02 | substantial | 4 | 148819 | 41 | 46.753 | 3183.1 |
317 | 2024-10-28 17:27:05 | substantial | 4 | 148819 | 41 | 34.143 | 4358.7 |
316 | 2024-10-28 17:27:05 | substantial | 2 | 86808 | 8 | 11.406 | 7610.7 |
315 | 2024-10-28 17:23:36 | substantial | 1 | 49908 | 3 | 1.283 | 38899.5 |
314 | 2024-10-25 20:25:48 | substantial | 3 | 121633 | 16 | 24.623 | 4939.8 |
313 | 2024-10-25 20:21:29 | substantial | 1 | 49908 | 3 | 4.033 | 12374.9 |
312 | 2024-10-23 21:52:08 | substantial | 1 | 49908 | 3 | 3.750 | 13308.8 |
311 | 2024-10-22 07:31:26 | substantial | 1 | 49908 | 3 | 4.076 | 12244.4 |
310 | 2024-10-04 11:26:14 | substantial | 3 | 121633 | 16 | 59.783 | 2034.6 |
309 | 2024-10-02 05:17:36 | substantial | 3 | 121633 | 16 | 49.703 | 2447.2 |
308 | 2024-10-02 05:17:50 | substantial | 3 | 121633 | 16 | 27.376 | 4443.1 |
307 | 2024-10-02 05:17:44 | substantial | 2 | 86808 | 8 | 22.296 | 3893.4 |
306 | 2024-10-02 05:17:29 | substantial | 3 | 121633 | 16 | 21.000 | 5792.0 |
305 | 2024-10-02 05:14:41 | substantial | 1 | 49908 | 3 | 2.936 | 16998.6 |
304 | 2024-09-18 00:20:57 | substantial | 3 | 121633 | 16 | 52.346 | 2323.6 |
303 | 2024-09-18 00:20:09 | substantial | 1 | 49908 | 3 | 5.046 | 9890.6 |
302 | 2024-09-17 22:55:04 | substantial | 3 | 121633 | 16 | 35.876 | 3390.4 |
301 | 2024-09-17 22:55:00 | substantial | 3 | 121633 | 16 | 36.516 | 3331.0 |
300 | 2024-09-17 15:55:25 | substantial | 1 | 49908 | 3 | 8.343 | 5982.0 |
299 | 2024-09-17 15:41:57 | substantial | 3 | 121633 | 16 | 52.923 | 2298.3 |
298 | 2024-09-05 19:48:04 | substantial | 2 | 86808 | 8 | 26.440 | 3283.2 |
297 | 2024-09-04 06:54:31 | substantial | 3 | 121633 | 16 | 52.220 | 2329.2 |
296 | 2024-09-03 09:52:52 | substantial | 1 | 49908 | 3 | 7.890 | 6325.5 |
295 | 2024-08-30 04:43:35 | substantial | 3 | 121633 | 16 | 27.423 | 4435.4 |
294 | 2024-08-29 01:12:48 | substantial | 1 | 49908 | 3 | 2.920 | 17091.8 |