History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"certain"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
406 | 2024-04-25 18:52:52 | certain | 2 | 107671 | 29 | 7.373 | 14603.4 |
405 | 2024-04-25 18:52:40 | certain | 3 | 134027 | 225 | 8.186 | 16372.7 |
404 | 2024-04-25 06:21:24 | certain | 3 | 134027 | 225 | 7.093 | 18895.7 |
403 | 2024-04-25 06:19:02 | certain | 2 | 107671 | 29 | 3.546 | 30364.1 |
402 | 2024-04-24 18:48:18 | certain | 2 | 107671 | 29 | 3.576 | 30109.3 |
401 | 2024-03-30 21:38:53 | certain | 1 | 69583 | 4 | 4.280 | 16257.7 |
400 | 2024-03-25 18:01:53 | certain | 3 | 134027 | 225 | 21.626 | 6197.5 |
399 | 2024-03-24 03:01:09 | certain | 2 | 107671 | 29 | 3.923 | 27446.1 |
398 | 2024-03-23 08:30:30 | certain | 3 | 134027 | 225 | 19.703 | 6802.4 |
397 | 2024-03-22 06:30:43 | certain | 2 | 107671 | 29 | 3.346 | 32179.0 |
396 | 2024-03-22 06:24:25 | certain | 3 | 134027 | 225 | 7.843 | 17088.7 |
395 | 2024-03-21 22:55:37 | certain | 2 | 107671 | 29 | 5.576 | 19309.7 |
394 | 2024-03-21 22:55:05 | certain | 3 | 134027 | 225 | 8.296 | 16155.6 |
393 | 2024-03-20 19:35:44 | certain | 3 | 134027 | 225 | 7.923 | 16916.2 |
392 | 2024-02-16 06:25:21 | certain | 1 | 69583 | 4 | 1.263 | 55093.4 |
391 | 2023-12-20 13:19:25 | certain | 2 | 107671 | 29 | 3.516 | 30623.2 |
390 | 2023-12-08 17:09:21 | certain | 1 | 69583 | 4 | 1.296 | 53690.6 |
389 | 2023-12-01 09:27:51 | certain | 1 | 69583 | 4 | 1.123 | 61961.7 |
388 | 2023-11-30 18:59:41 | certain | 3 | 134027 | 225 | 7.096 | 18887.7 |
387 | 2023-11-27 21:58:07 | certain | 1 | 69583 | 4 | 1.310 | 53116.8 |
386 | 2023-11-23 16:08:02 | certain | 1 | 69583 | 4 | 1.233 | 56433.9 |
385 | 2023-11-20 09:08:58 | certain | 1 | 69583 | 4 | 1.610 | 43219.3 |
384 | 2023-11-16 00:38:11 | certain | 1 | 69583 | 4 | 1.093 | 63662.4 |
383 | 2023-10-14 00:57:20 | certain | 1 | 69583 | 4 | 1.140 | 61037.7 |
382 | 2023-10-07 08:26:24 | certain | 1 | 69583 | 4 | 1.186 | 58670.3 |
381 | 2023-09-25 00:54:02 | certain | 2 | 107671 | 29 | 3.296 | 32667.2 |
380 | 2023-09-24 11:23:43 | certain | 1 | 69583 | 4 | 1.110 | 62687.4 |
379 | 2023-09-23 16:25:27 | certain | 1 | 69583 | 4 | 1.906 | 36507.3 |
378 | 2023-09-19 10:18:26 | certain | 2 | 107671 | 29 | 2.936 | 36672.7 |
377 | 2023-09-15 00:11:07 | certain | 1 | 69583 | 4 | 1.063 | 65459.1 |
376 | 2023-08-30 00:14:38 | certain | 3 | 134027 | 225 | 5.876 | 22809.2 |
375 | 2023-08-02 12:44:23 | certain | 1 | 69583 | 4 | 1.093 | 63662.4 |
374 | 2023-07-29 18:23:19 | certain | 1 | 69583 | 4 | 1.093 | 63662.4 |
373 | 2023-07-03 17:54:19 | certain | 1 | 69583 | 4 | 1.096 | 63488.1 |
372 | 2023-06-21 17:21:22 | certain | 2 | 107671 | 29 | 2.873 | 37476.9 |
371 | 2023-05-15 02:12:52 | certain | 3 | 134027 | 225 | 5.940 | 22563.5 |
370 | 2023-04-21 10:20:42 | certain | 1 | 69583 | 4 | 1.186 | 58670.3 |
369 | 2023-04-10 15:45:04 | certain | 1 | 69583 | 4 | 1.110 | 62687.4 |
368 | 2023-03-16 04:25:31 | certain | 2 | 107671 | 29 | 2.846 | 37832.4 |
367 | 2023-02-17 01:09:47 | certain | 3 | 134027 | 225 | 6.860 | 19537.5 |
366 | 2023-01-18 02:54:33 | certain | 3 | 134027 | 225 | 7.220 | 18563.3 |
365 | 2023-01-05 06:47:44 | certain | 1 | 69583 | 4 | 1.063 | 65459.1 |
364 | 2022-12-18 12:53:47 | certain | 2 | 107671 | 29 | 3.546 | 30364.1 |
363 | 2022-11-30 09:32:02 | certain | 3 | 134027 | 225 | 6.610 | 20276.4 |
362 | 2022-11-11 14:29:42 | certain | 3 | 134027 | 225 | 7.093 | 18895.7 |
361 | 2022-09-25 05:56:18 | certain | 3 | 134027 | 225 | 6.703 | 19995.1 |
360 | 2022-09-21 14:58:38 | certain | 1 | 69583 | 4 | 1.093 | 63662.4 |
359 | 2022-08-28 20:20:47 | certain | 3 | 134027 | 225 | 6.063 | 22105.7 |
358 | 2022-08-09 15:22:56 | certain | 2 | 107671 | 29 | 2.890 | 37256.4 |
357 | 2022-07-29 01:18:19 | certain | 1 | 69583 | 4 | 1.093 | 63662.4 |
356 | 2022-07-09 06:03:52 | certain | 3 | 134027 | 225 | 6.313 | 21230.3 |
355 | 2022-06-08 05:32:28 | certain | 1 | 69583 | 4 | 1.093 | 63662.4 |
354 | 2022-05-30 05:51:52 | certain | 1 | 69583 | 4 | 1.080 | 64428.7 |
353 | 2022-05-28 01:21:14 | certain | 1 | 69583 | 4 | 1.093 | 63662.4 |
352 | 2022-03-17 04:54:40 | certain | 2 | 107671 | 29 | 3.690 | 29179.1 |
351 | 2022-02-24 19:06:58 | certain | 1 | 69583 | 4 | 1.140 | 61037.7 |
350 | 2022-02-09 06:16:52 | certain | 1 | 69583 | 4 | 1.250 | 55666.4 |
349 | 2022-02-07 02:43:18 | certain | 1 | 69583 | 4 | 1.156 | 60192.9 |
348 | 2021-12-21 00:46:35 | certain | 2 | 107671 | 29 | 3.393 | 31733.3 |
347 | 2021-12-03 01:00:00 | certain | 1 | 69583 | 4 | 1.233 | 56433.9 |
346 | 2021-11-19 23:08:45 | certain | 1 | 69583 | 4 | 1.140 | 61037.7 |
345 | 2021-10-30 22:07:03 | certain | 1 | 69583 | 4 | 1.076 | 64668.2 |
344 | 2021-10-29 20:48:11 | certain | 1 | 69583 | 4 | 1.250 | 55666.4 |
343 | 2021-10-14 13:47:37 | certain | 1 | 69583 | 4 | 2.623 | 26528.0 |
342 | 2021-09-22 11:34:17 | certain | 1 | 69583 | 4 | 1.170 | 59472.6 |
341 | 2021-09-21 14:54:48 | certain | 1 | 69583 | 4 | 1.313 | 52995.4 |
340 | 2021-09-15 01:55:26 | certain | 1 | 69583 | 4 | 1.126 | 61796.6 |
339 | 2021-09-06 06:31:40 | certain | 1 | 69583 | 4 | 1.220 | 57035.2 |
338 | 2021-08-19 16:13:46 | certain | 1 | 69583 | 4 | 1.266 | 54962.9 |
337 | 2021-08-17 02:05:39 | certain | 1 | 69583 | 4 | 1.250 | 55666.4 |
336 | 2021-06-01 22:18:07 | certain | 1 | 69583 | 4 | 1.106 | 62914.1 |
335 | 2021-05-16 10:01:42 | certain | 1 | 69583 | 4 | 1.250 | 55666.4 |
334 | 2021-05-13 01:14:05 | certain | 1 | 69583 | 4 | 1.203 | 57841.2 |
333 | 2021-05-07 17:28:04 | certain | 1 | 69583 | 4 | 1.110 | 62687.4 |
332 | 2021-05-02 22:47:59 | certain | 1 | 69583 | 4 | 1.296 | 53690.6 |
331 | 2021-03-11 05:24:06 | certain | 1 | 69583 | 4 | 1.110 | 62687.4 |
330 | 2021-02-14 03:38:34 | certain | 1 | 69583 | 4 | 1.093 | 63662.4 |
329 | 2021-02-09 06:40:52 | certain | 1 | 69583 | 4 | 1.096 | 63488.1 |
328 | 2020-12-22 04:03:42 | certain | 1 | 69583 | 4 | 1.126 | 61796.6 |
327 | 2020-11-07 13:04:47 | certain | 1 | 69583 | 4 | 1.220 | 57035.2 |
326 | 2020-11-03 03:06:53 | certain | 1 | 69583 | 4 | 1.156 | 60192.9 |
325 | 2020-11-01 23:04:48 | certain | 1 | 69583 | 4 | 1.296 | 53690.6 |
324 | 2020-10-25 09:12:08 | certain | 1 | 69583 | 4 | 1.096 | 63488.1 |
323 | 2020-10-12 13:38:37 | certain | 1 | 69583 | 4 | 1.153 | 60349.5 |
322 | 2020-09-02 10:16:53 | certain | 1 | 69583 | 4 | 1.093 | 63662.4 |
321 | 2020-07-30 12:51:54 | certain | 1 | 69583 | 4 | 1.173 | 59320.5 |
320 | 2020-06-08 12:59:17 | certain | 1 | 69583 | 4 | 1.250 | 55666.4 |
319 | 2020-05-01 08:09:10 | certain | 1 | 69583 | 4 | 1.156 | 60192.9 |
318 | 2020-03-29 21:19:43 | certain | 1 | 69583 | 4 | 1.110 | 62687.4 |
317 | 2020-03-28 09:20:43 | certain | 1 | 69583 | 4 | 1.466 | 47464.5 |
316 | 2020-03-24 03:20:57 | certain | 1 | 69583 | 4 | 1.546 | 45008.4 |
315 | 2020-03-23 03:01:36 | certain | 1 | 69583 | 4 | 1.216 | 57222.9 |
314 | 2020-03-20 16:38:10 | certain | 1 | 69583 | 4 | 1.186 | 58670.3 |
313 | 2020-03-19 23:13:22 | certain | 1 | 69583 | 4 | 1.266 | 54962.9 |
312 | 2020-03-18 22:01:53 | certain | 1 | 69583 | 4 | 1.186 | 58670.3 |
311 | 2020-02-24 23:22:52 | certain | 1 | 69583 | 4 | 2.783 | 25002.9 |
310 | 2020-02-24 22:21:07 | certain | 1 | 69583 | 4 | 1.343 | 51811.6 |
309 | 2020-02-17 06:11:03 | certain | 1 | 69583 | 4 | 2.953 | 23563.5 |
308 | 2020-02-08 08:01:43 | certain | 1 | 69583 | 4 | 1.093 | 63662.4 |
307 | 2020-02-07 23:55:03 | certain | 1 | 69583 | 4 | 1.423 | 48898.8 |