History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
422 | 2024-04-22 18:16:29 | substates | 3 | 148641 | 107 | 33.156 | 4483.1 |
421 | 2024-04-22 18:16:43 | substates | 2 | 121436 | 15 | 10.220 | 11882.2 |
420 | 2024-04-22 16:51:27 | substates | 1 | 81242 | 4 | 1.470 | 55266.7 |
419 | 2024-04-13 17:24:48 | substates | 1 | 81242 | 4 | 1.420 | 57212.7 |
418 | 2024-04-05 22:19:43 | substates | 1 | 81242 | 4 | 1.453 | 55913.3 |
417 | 2024-04-03 10:47:38 | substates | 3 | 148641 | 107 | 16.156 | 9200.4 |
416 | 2024-04-03 06:03:56 | substates | 1 | 81242 | 4 | 1.250 | 64993.6 |
415 | 2024-03-30 11:58:43 | substates | 1 | 81242 | 4 | 1.373 | 59171.2 |
414 | 2024-03-25 04:18:35 | substates | 2 | 121436 | 15 | 3.546 | 34245.9 |
413 | 2024-03-25 03:56:15 | substates | 3 | 148641 | 107 | 7.406 | 20070.3 |
412 | 2024-03-24 14:46:07 | substates | 3 | 148641 | 107 | 17.656 | 8418.7 |
411 | 2024-03-23 08:54:08 | substates | 3 | 148641 | 107 | 17.956 | 8278.1 |
410 | 2024-03-23 08:53:59 | substates | 2 | 121436 | 15 | 8.673 | 14001.6 |
409 | 2024-03-23 07:07:36 | substates | 1 | 81242 | 4 | 1.516 | 53589.7 |
408 | 2024-03-05 22:20:14 | substates | 1 | 81242 | 4 | 2.153 | 37734.3 |
407 | 2024-03-01 01:53:53 | substates | 1 | 81242 | 4 | 1.483 | 54782.2 |
406 | 2024-02-22 04:42:34 | substates | 3 | 148641 | 107 | 8.390 | 17716.4 |
405 | 2024-02-22 04:42:32 | substates | 2 | 121436 | 15 | 8.330 | 14578.2 |
404 | 2024-02-21 20:47:45 | substates | 1 | 81242 | 4 | 1.390 | 58447.5 |
403 | 2024-01-31 01:17:04 | substates | 1 | 81242 | 4 | 1.420 | 57212.7 |
402 | 2024-01-21 09:23:31 | substates | 1 | 81242 | 4 | 1.250 | 64993.6 |
401 | 2023-12-25 00:00:06 | substates | 1 | 81242 | 4 | 1.470 | 55266.7 |
400 | 2023-12-22 11:28:24 | substates | 1 | 81242 | 4 | 1.420 | 57212.7 |
399 | 2023-11-12 13:16:38 | substates | 1 | 81242 | 4 | 1.343 | 60492.9 |
398 | 2023-10-12 16:16:44 | substates | 1 | 81242 | 4 | 1.283 | 63321.9 |
397 | 2023-10-06 11:18:13 | substates | 1 | 81242 | 4 | 1.313 | 61875.1 |
396 | 2023-09-14 04:27:11 | substates | 1 | 81242 | 4 | 1.423 | 57092.1 |
395 | 2023-08-09 09:58:00 | substates | 1 | 81242 | 4 | 1.250 | 64993.6 |
394 | 2023-05-14 17:14:27 | substates | 1 | 81242 | 4 | 1.233 | 65889.7 |
393 | 2023-05-06 23:01:17 | substates | 1 | 81242 | 4 | 1.220 | 66591.8 |
392 | 2023-03-01 08:55:57 | substates | 1 | 81242 | 4 | 2.233 | 36382.4 |
391 | 2023-01-14 01:05:04 | substates | 1 | 81242 | 4 | 2.703 | 30056.2 |
390 | 2022-12-26 11:15:26 | substates | 1 | 81242 | 4 | 1.233 | 65889.7 |
389 | 2022-09-11 20:15:55 | substates | 1 | 81242 | 4 | 1.360 | 59736.8 |
388 | 2022-09-09 18:00:12 | substates | 1 | 81242 | 4 | 1.263 | 64324.6 |
387 | 2022-09-07 19:50:06 | substates | 3 | 148641 | 107 | 6.063 | 24516.1 |
386 | 2022-09-05 00:00:37 | substates | 1 | 81242 | 4 | 1.420 | 57212.7 |
385 | 2022-09-01 09:00:33 | substates | 3 | 148641 | 107 | 7.030 | 21143.8 |
384 | 2022-07-19 08:13:28 | substates | 3 | 148641 | 107 | 6.190 | 24013.1 |
383 | 2022-04-18 19:17:50 | substates | 1 | 81242 | 4 | 1.360 | 59736.8 |
382 | 2022-04-18 12:17:20 | substates | 1 | 81242 | 4 | 1.826 | 44491.8 |
381 | 2022-01-19 10:14:17 | substates | 1 | 81242 | 4 | 1.236 | 65729.8 |
380 | 2022-01-12 09:01:29 | substates | 1 | 81242 | 4 | 1.296 | 62686.7 |
379 | 2021-12-20 19:16:46 | substates | 1 | 81242 | 4 | 1.360 | 59736.8 |
378 | 2021-12-09 08:01:57 | substates | 1 | 81242 | 4 | 1.423 | 57092.1 |
377 | 2021-11-10 10:08:13 | substates | 1 | 81242 | 4 | 1.686 | 48186.2 |
376 | 2021-11-08 09:03:34 | substates | 1 | 81242 | 4 | 1.436 | 56575.2 |
375 | 2021-11-06 07:57:40 | substates | 1 | 81242 | 4 | 1.296 | 62686.7 |
374 | 2021-10-12 17:22:32 | substates | 1 | 81242 | 4 | 1.500 | 54161.3 |
373 | 2021-10-10 14:25:34 | substates | 1 | 81242 | 4 | 1.436 | 56575.2 |
372 | 2021-08-31 13:39:57 | substates | 1 | 81242 | 4 | 1.296 | 62686.7 |
371 | 2021-05-29 22:57:18 | substates | 2 | 121436 | 15 | 3.533 | 34371.9 |
370 | 2021-05-24 03:00:49 | substates | 1 | 81242 | 4 | 1.483 | 54782.2 |
369 | 2021-05-04 12:24:01 | substates | 2 | 121436 | 15 | 3.623 | 33518.1 |
368 | 2021-04-02 14:34:56 | substates | 2 | 121436 | 15 | 3.436 | 35342.3 |
367 | 2021-02-18 10:20:19 | substates | 1 | 81242 | 4 | 1.296 | 62686.7 |
366 | 2021-02-11 14:49:26 | substates | 1 | 81242 | 4 | 1.313 | 61875.1 |
365 | 2021-02-11 03:41:52 | substates | 2 | 121436 | 15 | 3.236 | 37526.6 |
364 | 2021-01-17 15:20:51 | substates | 2 | 121436 | 15 | 3.063 | 39646.1 |
363 | 2020-11-23 06:09:13 | substates | 2 | 121436 | 15 | 3.186 | 38115.5 |
362 | 2020-11-14 09:05:29 | substates | 1 | 81242 | 4 | 1.376 | 59042.2 |
361 | 2020-11-05 13:17:36 | substates | 1 | 81242 | 4 | 1.326 | 61268.5 |
360 | 2020-11-01 22:18:36 | substates | 1 | 81242 | 4 | 1.440 | 56418.1 |
359 | 2020-10-29 01:21:04 | substates | 2 | 121436 | 15 | 3.546 | 34245.9 |
358 | 2020-10-27 05:09:01 | substates | 1 | 81242 | 4 | 1.296 | 62686.7 |
357 | 2020-10-22 12:53:43 | substates | 1 | 81242 | 4 | 2.530 | 32111.5 |
356 | 2020-10-04 01:58:23 | substates | 1 | 81242 | 4 | 1.250 | 64993.6 |
355 | 2020-08-09 23:41:48 | substates | 1 | 81242 | 4 | 1.266 | 64172.2 |
354 | 2020-05-08 19:10:06 | substates | 1 | 81242 | 4 | 1.346 | 60358.1 |
353 | 2020-03-21 07:44:50 | substates | 1 | 81242 | 4 | 1.436 | 56575.2 |
352 | 2020-02-27 17:20:52 | substates | 1 | 81242 | 4 | 3.343 | 24302.1 |
351 | 2020-02-27 05:00:45 | substates | 1 | 81242 | 4 | 3.190 | 25467.7 |
350 | 2020-02-27 00:59:22 | substates | 1 | 81242 | 4 | 1.580 | 51419.0 |
349 | 2020-02-26 11:56:03 | substates | 3 | 148641 | 107 | 7.330 | 20278.4 |
348 | 2020-02-25 22:50:08 | substates | 3 | 148641 | 107 | 16.283 | 9128.6 |
347 | 2020-02-22 11:56:57 | substates | 1 | 81242 | 4 | 2.470 | 32891.5 |
346 | 2020-02-22 08:08:45 | substates | 1 | 81242 | 4 | 1.626 | 49964.3 |
345 | 2020-02-20 09:55:56 | substates | 1 | 81242 | 4 | 3.123 | 26014.1 |
344 | 2020-02-12 20:18:22 | substates | 3 | 148641 | 107 | 7.716 | 19264.0 |
343 | 2020-02-11 17:24:52 | substates | 3 | 148641 | 107 | 19.266 | 7715.2 |
342 | 2020-02-06 05:17:53 | substates | 1 | 81242 | 4 | 1.440 | 56418.1 |
341 | 2020-02-05 12:31:46 | substates | 1 | 81242 | 4 | 1.546 | 52549.8 |
340 | 2020-02-02 03:56:01 | substates | 1 | 81242 | 4 | 1.266 | 64172.2 |
339 | 2020-01-29 00:04:28 | substates | 1 | 81242 | 4 | 1.486 | 54671.6 |
338 | 2020-01-28 19:40:24 | substates | 1 | 81242 | 4 | 1.470 | 55266.7 |
337 | 2020-01-24 09:58:08 | substates | 3 | 148641 | 107 | 9.016 | 16486.4 |
336 | 2020-01-22 12:03:37 | substates | 1 | 81242 | 4 | 1.716 | 47343.8 |
335 | 2020-01-22 11:01:45 | substates | 1 | 81242 | 4 | 1.596 | 50903.5 |
334 | 2020-01-18 06:25:22 | substates | 3 | 148641 | 107 | 8.796 | 16898.7 |
333 | 2020-01-18 06:25:01 | substates | 2 | 121436 | 15 | 8.390 | 14473.9 |
332 | 2020-01-18 04:32:03 | substates | 1 | 81242 | 4 | 1.500 | 54161.3 |
331 | 2020-01-07 23:53:29 | substates | 1 | 81242 | 4 | 3.263 | 24897.9 |
330 | 2020-01-06 18:05:40 | substates | 1 | 81242 | 4 | 1.513 | 53696.0 |
329 | 2020-01-02 05:32:08 | substates | 1 | 81242 | 4 | 1.546 | 52549.8 |
328 | 2020-01-01 10:47:33 | substates | 1 | 81242 | 4 | 1.546 | 52549.8 |
327 | 2019-11-02 10:49:54 | substates | 1 | 81242 | 4 | 1.236 | 65729.8 |
326 | 2019-10-22 19:31:45 | substates | 1 | 81242 | 4 | 1.250 | 64993.6 |
325 | 2019-08-01 06:58:46 | substates | 1 | 81242 | 4 | 1.450 | 56029.0 |
324 | 2019-07-24 12:49:12 | substates | 1 | 81242 | 4 | 1.226 | 66265.9 |
323 | 2019-04-25 00:43:33 | substates | 1 | 81242 | 4 | 1.503 | 54053.2 |