History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"survey"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
412 | 2024-04-30 06:44:36 | survey | 1 | 48755 | 5 | 3.346 | 14571.1 |
411 | 2024-04-28 02:04:02 | survey | 1 | 48755 | 5 | 0.953 | 51159.5 |
410 | 2024-04-11 19:13:17 | survey | 2 | 82551 | 48 | 6.703 | 12315.5 |
409 | 2024-04-03 11:34:25 | survey | 3 | 112716 | 593 | 21.516 | 5238.7 |
408 | 2024-03-30 20:32:13 | survey | 3 | 112716 | 593 | 11.893 | 9477.5 |
407 | 2024-03-30 20:05:25 | survey | 3 | 112716 | 593 | 20.783 | 5423.5 |
406 | 2024-03-30 07:47:49 | survey | 3 | 112716 | 593 | 17.050 | 6610.9 |
405 | 2024-03-30 02:30:39 | survey | 3 | 112716 | 593 | 5.720 | 19705.6 |
404 | 2024-03-30 02:30:41 | survey | 2 | 82551 | 48 | 2.716 | 30394.3 |
403 | 2024-03-06 21:03:57 | survey | 1 | 48755 | 5 | 0.796 | 61250.0 |
402 | 2024-02-29 21:41:55 | survey | 1 | 48755 | 5 | 0.940 | 51867.0 |
401 | 2024-02-29 06:58:41 | survey | 2 | 82551 | 48 | 2.516 | 32810.4 |
400 | 2024-02-29 06:58:16 | survey | 3 | 112716 | 593 | 8.156 | 13820.0 |
399 | 2024-02-28 22:08:15 | survey | 2 | 82551 | 48 | 3.970 | 20793.7 |
398 | 2024-02-28 13:43:13 | survey | 3 | 112716 | 593 | 6.080 | 18538.8 |
397 | 2024-02-28 13:43:12 | survey | 2 | 82551 | 48 | 5.296 | 15587.4 |
396 | 2024-02-25 20:32:23 | survey | 3 | 112716 | 593 | 12.110 | 9307.7 |
395 | 2024-02-22 02:47:50 | survey | 2 | 82551 | 48 | 4.503 | 18332.4 |
394 | 2024-02-22 02:46:58 | survey | 3 | 112716 | 593 | 6.796 | 16585.6 |
393 | 2024-02-21 13:17:37 | survey | 3 | 112716 | 593 | 13.423 | 8397.2 |
392 | 2024-02-19 18:07:23 | survey | 2 | 82551 | 48 | 5.953 | 13867.1 |
391 | 2024-02-19 18:06:50 | survey | 3 | 112716 | 593 | 6.360 | 17722.6 |
390 | 2024-02-19 10:58:00 | survey | 3 | 112716 | 593 | 4.686 | 24053.8 |
389 | 2024-01-19 03:51:21 | survey | 3 | 112716 | 593 | 5.783 | 19490.9 |
388 | 2024-01-12 06:35:53 | survey | 3 | 112716 | 593 | 5.720 | 19705.6 |
387 | 2023-12-13 20:19:20 | survey | 1 | 48755 | 5 | 0.783 | 62266.9 |
386 | 2023-12-12 22:24:51 | survey | 1 | 48755 | 5 | 0.826 | 59025.4 |
385 | 2023-12-11 12:37:33 | survey | 2 | 82551 | 48 | 2.140 | 38575.2 |
384 | 2023-12-03 18:38:46 | survey | 1 | 48755 | 5 | 0.890 | 54780.9 |
383 | 2023-12-03 18:38:44 | survey | 1 | 48755 | 5 | 0.890 | 54780.9 |
382 | 2023-11-18 13:14:28 | survey | 1 | 48755 | 5 | 0.986 | 49447.3 |
381 | 2023-11-18 00:57:07 | survey | 3 | 112716 | 593 | 4.906 | 22975.1 |
380 | 2023-11-18 00:18:56 | survey | 1 | 48755 | 5 | 0.830 | 58741.0 |
379 | 2023-11-05 04:24:49 | survey | 1 | 48755 | 5 | 0.763 | 63899.1 |
378 | 2023-11-04 16:56:48 | survey | 1 | 48755 | 5 | 0.936 | 52088.7 |
377 | 2023-10-23 06:01:26 | survey | 1 | 48755 | 5 | 0.843 | 57835.1 |
376 | 2023-10-19 05:06:53 | survey | 1 | 48755 | 5 | 0.766 | 63648.8 |
375 | 2023-10-16 16:59:20 | survey | 1 | 48755 | 5 | 0.750 | 65006.7 |
374 | 2023-10-16 03:16:03 | survey | 1 | 48755 | 5 | 0.860 | 56691.9 |
373 | 2023-10-05 06:04:00 | survey | 1 | 48755 | 5 | 0.800 | 60943.8 |
372 | 2023-09-30 04:34:11 | survey | 1 | 48755 | 5 | 0.890 | 54780.9 |
371 | 2023-09-27 06:23:00 | survey | 1 | 48755 | 5 | 0.826 | 59025.4 |
370 | 2023-09-13 20:27:47 | survey | 2 | 82551 | 48 | 2.593 | 31836.1 |
369 | 2023-09-13 13:41:13 | survey | 1 | 48755 | 5 | 0.840 | 58041.7 |
368 | 2023-09-10 09:39:43 | survey | 2 | 82551 | 48 | 2.140 | 38575.2 |
367 | 2023-09-09 16:03:35 | survey | 2 | 82551 | 48 | 2.220 | 37185.1 |
366 | 2023-08-18 14:40:49 | survey | 3 | 112716 | 593 | 5.343 | 21096.0 |
365 | 2023-07-28 12:50:59 | survey | 1 | 48755 | 5 | 0.783 | 62266.9 |
364 | 2023-07-25 03:47:38 | survey | 3 | 112716 | 593 | 4.733 | 23814.9 |
363 | 2023-07-02 23:54:08 | survey | 2 | 82551 | 48 | 2.410 | 34253.5 |
362 | 2023-06-12 18:47:50 | survey | 1 | 48755 | 5 | 0.780 | 62506.4 |
361 | 2023-06-09 08:53:47 | survey | 3 | 112716 | 593 | 5.376 | 20966.5 |
360 | 2023-06-02 03:14:30 | survey | 2 | 82551 | 48 | 2.203 | 37472.1 |
359 | 2023-05-05 09:53:18 | survey | 3 | 112716 | 593 | 4.906 | 22975.1 |
358 | 2023-04-24 02:37:41 | survey | 1 | 48755 | 5 | 0.843 | 57835.1 |
357 | 2023-03-19 12:58:20 | survey | 3 | 112716 | 593 | 4.623 | 24381.6 |
356 | 2023-03-07 16:58:24 | survey | 2 | 82551 | 48 | 2.140 | 38575.2 |
355 | 2023-02-15 18:53:53 | survey | 3 | 112716 | 593 | 5.283 | 21335.6 |
354 | 2023-02-14 12:43:47 | survey | 1 | 48755 | 5 | 0.830 | 58741.0 |
353 | 2023-02-13 16:49:44 | survey | 3 | 112716 | 593 | 4.716 | 23900.8 |
352 | 2023-01-31 13:28:21 | survey | 1 | 48755 | 5 | 0.750 | 65006.7 |
351 | 2023-01-19 17:37:45 | survey | 3 | 112716 | 593 | 5.346 | 21084.2 |
350 | 2022-12-23 05:19:04 | survey | 3 | 112716 | 593 | 8.936 | 12613.7 |
349 | 2022-12-12 07:03:15 | survey | 2 | 82551 | 48 | 2.470 | 33421.5 |
348 | 2022-12-11 09:20:04 | survey | 1 | 48755 | 5 | 1.500 | 32503.3 |
347 | 2022-11-24 12:59:16 | survey | 3 | 112716 | 593 | 4.686 | 24053.8 |
346 | 2022-11-04 14:01:41 | survey | 2 | 82551 | 48 | 2.346 | 35188.0 |
345 | 2022-09-28 18:37:02 | survey | 2 | 82551 | 48 | 2.203 | 37472.1 |
344 | 2022-09-25 15:54:21 | survey | 1 | 48755 | 5 | 0.766 | 63648.8 |
343 | 2022-08-16 02:42:44 | survey | 1 | 48755 | 5 | 0.780 | 62506.4 |
342 | 2022-07-29 09:05:33 | survey | 1 | 48755 | 5 | 0.953 | 51159.5 |
341 | 2022-07-28 11:30:05 | survey | 2 | 82551 | 48 | 2.186 | 37763.5 |
340 | 2022-06-17 02:57:47 | survey | 1 | 48755 | 5 | 0.783 | 62266.9 |
339 | 2022-06-08 18:18:35 | survey | 1 | 48755 | 5 | 0.923 | 52822.3 |
338 | 2022-06-01 20:38:11 | survey | 1 | 48755 | 5 | 0.766 | 63648.8 |
337 | 2022-06-01 14:32:11 | survey | 1 | 48755 | 5 | 0.750 | 65006.7 |
336 | 2022-05-25 18:13:26 | survey | 1 | 48755 | 5 | 0.783 | 62266.9 |
335 | 2022-05-05 14:00:48 | survey | 1 | 48755 | 5 | 0.846 | 57630.0 |
334 | 2022-05-01 22:40:31 | survey | 1 | 48755 | 5 | 0.750 | 65006.7 |
333 | 2022-04-16 04:11:42 | survey | 3 | 112716 | 593 | 4.890 | 23050.3 |
332 | 2022-04-02 17:01:10 | survey | 1 | 48755 | 5 | 0.873 | 55847.7 |
331 | 2022-01-06 11:30:41 | survey | 1 | 48755 | 5 | 0.936 | 52088.7 |
330 | 2022-01-04 07:50:49 | survey | 1 | 48755 | 5 | 0.830 | 58741.0 |
329 | 2022-01-01 19:49:59 | survey | 1 | 48755 | 5 | 0.783 | 62266.9 |
328 | 2021-11-04 16:28:40 | survey | 1 | 48755 | 5 | 0.923 | 52822.3 |
327 | 2021-11-02 14:48:43 | survey | 1 | 48755 | 5 | 0.750 | 65006.7 |
326 | 2021-10-11 03:02:27 | survey | 1 | 48755 | 5 | 0.766 | 63648.8 |
325 | 2021-10-09 00:56:57 | survey | 1 | 48755 | 5 | 0.873 | 55847.7 |
324 | 2021-09-06 10:04:23 | survey | 1 | 48755 | 5 | 0.780 | 62506.4 |
323 | 2021-07-16 14:18:30 | survey | 2 | 82551 | 48 | 2.156 | 38289.0 |
322 | 2021-06-17 08:27:50 | survey | 1 | 48755 | 5 | 0.796 | 61250.0 |
321 | 2021-05-23 11:29:53 | survey | 1 | 48755 | 5 | 0.906 | 53813.5 |
320 | 2021-05-05 20:32:24 | survey | 2 | 82551 | 48 | 2.593 | 31836.1 |
319 | 2021-04-04 00:04:08 | survey | 2 | 82551 | 48 | 2.436 | 33887.9 |
318 | 2021-03-28 03:23:05 | survey | 1 | 48755 | 5 | 0.783 | 62266.9 |
317 | 2021-02-12 08:10:18 | survey | 2 | 82551 | 48 | 2.736 | 30172.1 |
316 | 2021-01-31 07:19:35 | survey | 1 | 48755 | 5 | 0.766 | 63648.8 |
315 | 2021-01-11 10:46:11 | survey | 1 | 48755 | 5 | 0.766 | 63648.8 |
314 | 2020-12-19 20:27:53 | survey | 2 | 82551 | 48 | 2.250 | 36689.3 |
313 | 2020-11-13 11:17:07 | survey | 2 | 82551 | 48 | 2.393 | 34496.9 |