History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
419 | 2025-09-07 06:27:27 | substate | 1 | 82945 | 4 | 1.483 | 55930.5 |
418 | 2025-09-06 22:07:23 | substate | 1 | 82945 | 4 | 1.560 | 53169.9 |
417 | 2025-09-05 17:04:32 | substate | 2 | 121059 | 18 | 3.266 | 37066.4 |
416 | 2025-09-05 15:46:55 | substate | 1 | 82945 | 4 | 1.483 | 55930.5 |
415 | 2025-08-28 07:06:03 | substate | 1 | 82945 | 4 | 1.376 | 60279.8 |
414 | 2025-08-28 00:55:35 | substate | 2 | 121059 | 18 | 3.560 | 34005.3 |
413 | 2025-08-23 10:13:20 | substate | 1 | 82945 | 4 | 6.906 | 12010.6 |
412 | 2025-08-22 19:47:36 | substate | 2 | 121059 | 18 | 15.000 | 8070.6 |
411 | 2025-08-22 03:19:22 | substate | 2 | 121059 | 18 | 4.143 | 29220.1 |
410 | 2025-08-22 02:36:47 | substate | 1 | 82945 | 4 | 1.310 | 63316.8 |
409 | 2025-08-19 03:07:27 | substate | 1 | 82945 | 4 | 2.843 | 29175.2 |
408 | 2025-08-18 12:38:20 | substate | 2 | 121059 | 18 | 3.466 | 34927.6 |
407 | 2025-08-09 12:03:25 | substate | 1 | 82945 | 4 | 7.000 | 11849.3 |
406 | 2025-08-09 02:09:11 | substate | 1 | 82945 | 4 | 6.753 | 12282.7 |
405 | 2025-08-05 08:43:08 | substate | 3 | 146162 | 123 | 23.283 | 6277.6 |
404 | 2025-08-04 06:32:31 | substate | 1 | 82945 | 4 | 6.576 | 12613.3 |
403 | 2025-07-24 08:01:32 | substate | 1 | 82945 | 4 | 6.736 | 12313.7 |
402 | 2025-07-23 03:55:14 | substate | 1 | 82945 | 4 | 3.560 | 23299.2 |
401 | 2025-07-22 14:55:20 | substate | 1 | 82945 | 4 | 6.313 | 13138.8 |
400 | 2025-07-19 07:21:44 | substate | 1 | 82945 | 4 | 1.423 | 58288.8 |
399 | 2025-07-17 05:02:42 | substate | 1 | 82945 | 4 | 6.813 | 12174.5 |
398 | 2025-07-06 22:12:24 | substate | 1 | 82945 | 4 | 3.643 | 22768.3 |
397 | 2025-07-05 08:06:52 | substate | 2 | 121059 | 18 | 17.983 | 6731.9 |
396 | 2025-07-02 02:06:28 | substate | 2 | 121059 | 18 | 16.970 | 7133.7 |
395 | 2025-06-30 02:27:25 | substate | 1 | 82945 | 4 | 10.186 | 8143.0 |
394 | 2025-06-28 19:25:33 | substate | 2 | 121059 | 18 | 3.720 | 32542.7 |
393 | 2025-06-27 12:06:08 | substate | 3 | 146162 | 123 | 21.533 | 6787.8 |
392 | 2025-06-23 19:18:29 | substate | 2 | 121059 | 18 | 4.250 | 28484.5 |
391 | 2025-06-22 08:46:08 | substate | 1 | 82945 | 4 | 12.483 | 6644.6 |
390 | 2025-06-18 02:45:19 | substate | 2 | 121059 | 18 | 15.093 | 8020.9 |
389 | 2025-06-17 16:48:36 | substate | 1 | 82945 | 4 | 1.313 | 63172.1 |
388 | 2025-06-17 15:17:05 | substate | 2 | 121059 | 18 | 4.076 | 29700.4 |
387 | 2025-06-11 10:50:04 | substate | 2 | 121059 | 18 | 29.173 | 4149.7 |
386 | 2025-06-03 22:20:25 | substate | 1 | 82945 | 4 | 4.280 | 19379.7 |
385 | 2025-06-03 18:09:59 | substate | 2 | 121059 | 18 | 3.670 | 32986.1 |
384 | 2025-05-29 12:49:39 | substate | 1 | 82945 | 4 | 6.186 | 13408.5 |
383 | 2025-05-28 16:19:29 | substate | 2 | 121059 | 18 | 3.420 | 35397.4 |
382 | 2025-05-27 09:27:45 | substate | 1 | 82945 | 4 | 9.390 | 8833.3 |
381 | 2025-05-26 09:57:11 | substate | 1 | 82945 | 4 | 6.343 | 13076.6 |
380 | 2025-05-24 02:31:37 | substate | 1 | 82945 | 4 | 4.216 | 19673.9 |
379 | 2025-05-23 19:50:51 | substate | 2 | 121059 | 18 | 17.826 | 6791.1 |
378 | 2025-05-23 03:48:12 | substate | 1 | 82945 | 4 | 1.530 | 54212.4 |
377 | 2025-05-21 16:41:11 | substate | 2 | 121059 | 18 | 3.186 | 37997.2 |
376 | 2025-05-17 18:24:54 | substate | 3 | 146162 | 123 | 7.296 | 20033.2 |
375 | 2025-05-17 18:21:38 | substate | 2 | 121059 | 18 | 9.423 | 12847.2 |
374 | 2025-05-17 06:20:15 | substate | 3 | 146162 | 123 | 38.220 | 3824.2 |
373 | 2025-05-16 16:24:09 | substate | 1 | 82945 | 4 | 7.373 | 11249.8 |
372 | 2025-05-16 04:15:52 | substate | 2 | 121059 | 18 | 13.796 | 8774.9 |
371 | 2025-05-15 08:03:36 | substate | 1 | 82945 | 4 | 1.530 | 54212.4 |
370 | 2025-05-10 02:34:25 | substate | 3 | 146162 | 123 | 44.363 | 3294.7 |
369 | 2025-04-29 03:22:52 | substate | 1 | 82945 | 4 | 3.830 | 21656.7 |
368 | 2025-04-26 01:13:53 | substate | 2 | 121059 | 18 | 16.550 | 7314.7 |
367 | 2025-04-23 17:13:41 | substate | 3 | 146162 | 123 | 46.020 | 3176.1 |
366 | 2025-04-23 02:33:56 | substate | 1 | 82945 | 4 | 5.970 | 13893.6 |
365 | 2025-04-23 02:18:39 | substate | 1 | 82945 | 4 | 6.563 | 12638.3 |
364 | 2025-04-21 01:42:43 | substate | 3 | 146162 | 123 | 37.443 | 3903.6 |
363 | 2025-04-20 23:18:31 | substate | 3 | 146162 | 123 | 42.140 | 3468.5 |
362 | 2025-04-19 08:15:59 | substate | 3 | 146162 | 123 | 7.483 | 19532.5 |
361 | 2025-04-14 15:48:31 | substate | 1 | 82945 | 4 | 8.060 | 10290.9 |
360 | 2025-04-12 03:15:11 | substate | 1 | 82945 | 4 | 9.436 | 8790.3 |
359 | 2025-04-04 09:46:56 | substate | 1 | 82945 | 4 | 9.533 | 8700.8 |
358 | 2025-03-29 22:29:37 | substate | 1 | 82945 | 4 | 5.453 | 15210.9 |
357 | 2025-03-23 01:14:21 | substate | 2 | 121059 | 18 | 15.486 | 7817.3 |
356 | 2025-03-22 03:48:42 | substate | 1 | 82945 | 4 | 2.296 | 36125.9 |
355 | 2025-03-16 04:43:33 | substate | 1 | 82945 | 4 | 3.436 | 24140.0 |
354 | 2025-03-12 07:54:03 | substate | 1 | 82945 | 4 | 3.326 | 24938.4 |
353 | 2025-03-09 01:09:39 | substate | 1 | 82945 | 4 | 3.720 | 22297.0 |
352 | 2025-03-06 15:30:43 | substate | 1 | 82945 | 4 | 7.156 | 11591.0 |
351 | 2025-03-04 10:16:37 | substate | 1 | 82945 | 4 | 7.206 | 11510.5 |
350 | 2025-02-21 21:21:25 | substate | 1 | 82945 | 4 | 7.093 | 11693.9 |
349 | 2025-02-14 09:48:51 | substate | 3 | 146162 | 123 | 34.596 | 4224.8 |
348 | 2025-02-14 05:51:19 | substate | 1 | 82945 | 4 | 7.860 | 10552.8 |
347 | 2025-02-13 13:56:27 | substate | 3 | 146162 | 123 | 39.926 | 3660.8 |
346 | 2025-02-13 13:56:18 | substate | 2 | 121059 | 18 | 20.720 | 5842.6 |
345 | 2025-02-13 13:55:12 | substate | 1 | 82945 | 4 | 5.923 | 14003.9 |
344 | 2025-02-08 14:57:24 | substate | 1 | 82945 | 4 | 3.826 | 21679.3 |
343 | 2025-02-01 10:58:28 | substate | 2 | 121059 | 18 | 16.516 | 7329.8 |
342 | 2025-02-01 10:57:54 | substate | 1 | 82945 | 4 | 3.280 | 25288.1 |
341 | 2025-01-20 13:37:56 | substate | 3 | 146162 | 123 | 36.626 | 3990.7 |
340 | 2025-01-17 18:21:40 | substate | 3 | 146162 | 123 | 23.016 | 6350.5 |
339 | 2025-01-13 18:40:27 | substate | 2 | 121059 | 18 | 17.970 | 6736.7 |
338 | 2025-01-13 11:56:53 | substate | 3 | 146162 | 123 | 28.406 | 5145.5 |
337 | 2025-01-13 08:55:31 | substate | 3 | 146162 | 123 | 21.220 | 6887.9 |
336 | 2025-01-13 08:55:32 | substate | 2 | 121059 | 18 | 10.126 | 11955.3 |
335 | 2025-01-13 08:43:40 | substate | 1 | 82945 | 4 | 1.486 | 55817.6 |
334 | 2024-12-30 16:35:50 | substate | 1 | 82945 | 4 | 6.470 | 12819.9 |
333 | 2024-12-14 01:57:08 | substate | 1 | 82945 | 4 | 8.843 | 9379.7 |
332 | 2024-12-06 23:46:39 | substate | 2 | 121059 | 18 | 3.953 | 30624.6 |
331 | 2024-12-06 20:09:43 | substate | 3 | 146162 | 123 | 22.750 | 6424.7 |
330 | 2024-12-06 17:29:52 | substate | 3 | 146162 | 123 | 33.266 | 4393.7 |
329 | 2024-12-06 17:30:14 | substate | 1 | 82945 | 4 | 9.093 | 9121.9 |
328 | 2024-12-06 17:29:50 | substate | 2 | 121059 | 18 | 9.376 | 12911.6 |
327 | 2024-11-08 11:01:21 | substate | 1 | 82945 | 4 | 10.596 | 7828.0 |
326 | 2024-10-29 01:46:59 | substate | 1 | 82945 | 4 | 3.720 | 22297.0 |
325 | 2024-10-28 04:17:44 | substate | 1 | 82945 | 4 | 4.160 | 19938.7 |
324 | 2024-10-08 20:42:09 | substate | 1 | 82945 | 4 | 8.750 | 9479.4 |
323 | 2024-09-21 14:04:21 | substate | 3 | 146162 | 123 | 66.016 | 2214.0 |
322 | 2024-09-21 03:40:16 | substate | 3 | 146162 | 123 | 52.036 | 2808.9 |
321 | 2024-09-21 03:39:47 | substate | 1 | 82945 | 4 | 8.140 | 10189.8 |
320 | 2024-09-21 03:26:33 | substate | 2 | 121059 | 18 | 27.313 | 4432.3 |