History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"porter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
412 | 2024-05-02 00:28:22 | porter | 1 | 48755 | 11 | 1.923 | 25353.6 |
411 | 2024-04-27 14:58:55 | porter | 1 | 48755 | 11 | 2.720 | 17924.6 |
410 | 2024-04-27 08:31:38 | porter | 1 | 48755 | 11 | 0.936 | 52088.7 |
409 | 2024-04-05 19:01:10 | porter | 1 | 48755 | 11 | 2.983 | 16344.3 |
408 | 2024-04-02 11:06:20 | porter | 1 | 48755 | 11 | 0.843 | 57835.1 |
407 | 2024-03-31 17:22:32 | porter | 1 | 48755 | 11 | 1.000 | 48755.0 |
406 | 2024-03-04 20:41:28 | porter | 1 | 48755 | 11 | 1.936 | 25183.4 |
405 | 2024-03-04 20:41:13 | porter | 2 | 82551 | 192 | 4.763 | 17331.7 |
404 | 2024-03-04 14:46:40 | porter | 2 | 82551 | 192 | 8.860 | 9317.3 |
403 | 2024-03-04 09:28:39 | porter | 2 | 82551 | 192 | 6.156 | 13409.8 |
402 | 2024-03-04 09:28:36 | porter | 1 | 48755 | 11 | 0.970 | 50262.9 |
401 | 2024-02-25 20:55:42 | porter | 2 | 82551 | 192 | 2.813 | 29346.2 |
400 | 2024-02-25 18:47:48 | porter | 2 | 82551 | 192 | 3.813 | 21649.9 |
399 | 2024-02-23 22:34:11 | porter | 2 | 82551 | 192 | 2.346 | 35188.0 |
398 | 2024-01-19 05:31:33 | porter | 2 | 82551 | 192 | 2.466 | 33475.7 |
397 | 2024-01-11 01:30:33 | porter | 2 | 82551 | 192 | 2.906 | 28407.1 |
396 | 2023-12-28 09:17:49 | porter | 1 | 48755 | 11 | 0.813 | 59969.2 |
395 | 2023-12-23 15:20:21 | porter | 1 | 48755 | 11 | 0.763 | 63899.1 |
394 | 2023-12-21 20:34:55 | porter | 1 | 48755 | 11 | 0.766 | 63648.8 |
393 | 2023-12-07 21:15:17 | porter | 1 | 48755 | 11 | 0.890 | 54780.9 |
392 | 2023-12-07 21:15:16 | porter | 1 | 48755 | 11 | 1.093 | 44606.6 |
391 | 2023-12-05 14:24:08 | porter | 2 | 82551 | 192 | 2.470 | 33421.5 |
390 | 2023-11-17 17:48:57 | porter | 2 | 82551 | 192 | 2.140 | 38575.2 |
389 | 2023-11-15 13:19:43 | porter | 1 | 48755 | 11 | 0.843 | 57835.1 |
388 | 2023-11-12 21:11:12 | porter | 1 | 48755 | 11 | 0.890 | 54780.9 |
387 | 2023-11-11 10:56:27 | porter | 1 | 48755 | 11 | 0.843 | 57835.1 |
386 | 2023-11-11 06:11:18 | porter | 1 | 48755 | 11 | 0.783 | 62266.9 |
385 | 2023-10-22 19:26:24 | porter | 1 | 48755 | 11 | 0.843 | 57835.1 |
384 | 2023-10-18 07:59:35 | porter | 1 | 48755 | 11 | 0.843 | 57835.1 |
383 | 2023-10-13 16:39:44 | porter | 1 | 48755 | 11 | 0.843 | 57835.1 |
382 | 2023-10-10 21:49:10 | porter | 1 | 48755 | 11 | 0.893 | 54596.9 |
381 | 2023-10-08 13:45:46 | porter | 1 | 48755 | 11 | 0.766 | 63648.8 |
380 | 2023-09-27 14:42:43 | porter | 1 | 48755 | 11 | 0.783 | 62266.9 |
379 | 2023-09-14 07:49:43 | porter | 1 | 48755 | 11 | 0.826 | 59025.4 |
378 | 2023-08-22 11:01:55 | porter | 1 | 48755 | 11 | 0.813 | 59969.2 |
377 | 2023-08-19 01:18:49 | porter | 2 | 82551 | 192 | 2.440 | 33832.4 |
376 | 2023-08-08 07:42:42 | porter | 1 | 48755 | 11 | 0.750 | 65006.7 |
375 | 2023-05-05 01:43:50 | porter | 1 | 48755 | 11 | 0.766 | 63648.8 |
374 | 2023-05-04 00:16:20 | porter | 2 | 82551 | 192 | 6.703 | 12315.5 |
373 | 2023-05-01 05:54:16 | porter | 1 | 48755 | 11 | 0.750 | 65006.7 |
372 | 2023-02-24 01:09:10 | porter | 1 | 48755 | 11 | 0.750 | 65006.7 |
371 | 2023-02-09 06:57:51 | porter | 2 | 82551 | 192 | 2.106 | 39198.0 |
370 | 2023-01-22 19:25:39 | porter | 1 | 48755 | 11 | 0.826 | 59025.4 |
369 | 2022-12-22 14:23:58 | porter | 1 | 48755 | 11 | 0.750 | 65006.7 |
368 | 2022-11-20 14:14:18 | porter | 2 | 82551 | 192 | 2.143 | 38521.2 |
367 | 2022-09-03 09:55:13 | porter | 1 | 48755 | 11 | 0.763 | 63899.1 |
366 | 2022-06-29 09:38:55 | porter | 1 | 48755 | 11 | 0.750 | 65006.7 |
365 | 2022-06-24 05:25:35 | porter | 2 | 82551 | 192 | 2.170 | 38041.9 |
364 | 2022-04-18 19:36:09 | porter | 1 | 48755 | 11 | 0.920 | 52994.6 |
363 | 2022-04-16 15:41:25 | porter | 1 | 48755 | 11 | 0.766 | 63648.8 |
362 | 2022-03-05 23:23:44 | porter | 1 | 48755 | 11 | 0.846 | 57630.0 |
361 | 2022-01-12 09:55:23 | porter | 1 | 48755 | 11 | 0.796 | 61250.0 |
360 | 2022-01-10 05:51:15 | porter | 1 | 48755 | 11 | 0.796 | 61250.0 |
359 | 2021-11-15 12:57:28 | porter | 1 | 48755 | 11 | 0.890 | 54780.9 |
358 | 2021-11-10 09:28:22 | porter | 1 | 48755 | 11 | 1.046 | 46610.9 |
357 | 2021-09-30 03:21:09 | porter | 1 | 48755 | 11 | 0.766 | 63648.8 |
356 | 2021-08-28 14:42:39 | porter | 1 | 48755 | 11 | 0.796 | 61250.0 |
355 | 2021-08-26 10:15:54 | porter | 1 | 48755 | 11 | 0.826 | 59025.4 |
354 | 2021-08-12 17:10:02 | porter | 1 | 48755 | 11 | 0.923 | 52822.3 |
353 | 2021-07-06 22:49:43 | porter | 1 | 48755 | 11 | 0.873 | 55847.7 |
352 | 2021-06-06 15:21:42 | porter | 1 | 48755 | 11 | 0.876 | 55656.4 |
351 | 2021-05-12 19:13:47 | porter | 1 | 48755 | 11 | 0.750 | 65006.7 |
350 | 2021-05-12 17:36:46 | porter | 1 | 48755 | 11 | 0.890 | 54780.9 |
349 | 2021-05-05 03:49:41 | porter | 1 | 48755 | 11 | 0.856 | 56956.8 |
348 | 2021-04-11 14:14:32 | porter | 1 | 48755 | 11 | 0.890 | 54780.9 |
347 | 2021-02-02 15:09:15 | porter | 1 | 48755 | 11 | 0.893 | 54596.9 |
346 | 2020-11-30 11:35:43 | porter | 1 | 48755 | 11 | 0.860 | 56691.9 |
345 | 2020-11-14 02:15:56 | porter | 1 | 48755 | 11 | 0.766 | 63648.8 |
344 | 2020-11-02 13:00:19 | porter | 1 | 48755 | 11 | 1.720 | 28345.9 |
343 | 2020-10-31 18:24:20 | porter | 1 | 48755 | 11 | 0.876 | 55656.4 |
342 | 2020-10-30 13:14:26 | porter | 1 | 48755 | 11 | 0.750 | 65006.7 |
341 | 2020-09-10 05:34:48 | porter | 1 | 48755 | 11 | 0.860 | 56691.9 |
340 | 2020-09-04 22:29:07 | porter | 1 | 48755 | 11 | 0.826 | 59025.4 |
339 | 2020-08-29 19:59:13 | porter | 1 | 48755 | 11 | 0.813 | 59969.2 |
338 | 2020-08-29 19:51:55 | porter | 1 | 48755 | 11 | 0.796 | 61250.0 |
337 | 2020-08-28 19:54:20 | porter | 1 | 48755 | 11 | 0.860 | 56691.9 |
336 | 2020-08-24 12:26:51 | porter | 1 | 48755 | 11 | 0.830 | 58741.0 |
335 | 2020-08-01 18:22:25 | porter | 1 | 48755 | 11 | 0.920 | 52994.6 |
334 | 2020-06-15 20:35:03 | porter | 1 | 48755 | 11 | 0.813 | 59969.2 |
333 | 2020-04-30 07:07:21 | porter | 1 | 48755 | 11 | 0.813 | 59969.2 |
332 | 2020-03-26 22:03:08 | porter | 1 | 48755 | 11 | 0.890 | 54780.9 |
331 | 2020-03-26 19:50:38 | porter | 1 | 48755 | 11 | 0.953 | 51159.5 |
330 | 2020-03-25 16:04:53 | porter | 1 | 48755 | 11 | 0.860 | 56691.9 |
329 | 2020-03-23 13:50:36 | porter | 1 | 48755 | 11 | 1.253 | 38910.6 |
328 | 2020-03-22 09:09:22 | porter | 1 | 48755 | 11 | 0.920 | 52994.6 |
327 | 2020-03-18 19:01:23 | porter | 1 | 48755 | 11 | 0.873 | 55847.7 |
326 | 2020-03-02 00:28:38 | porter | 1 | 48755 | 11 | 0.780 | 62506.4 |
325 | 2020-02-24 01:28:48 | porter | 1 | 48755 | 11 | 1.950 | 25002.6 |
324 | 2020-02-22 06:39:56 | porter | 1 | 48755 | 11 | 0.970 | 50262.9 |
323 | 2020-02-19 18:15:45 | porter | 1 | 48755 | 11 | 0.780 | 62506.4 |
322 | 2020-02-17 01:43:57 | porter | 1 | 48755 | 11 | 0.953 | 51159.5 |
321 | 2020-02-10 01:46:06 | porter | 1 | 48755 | 11 | 0.953 | 51159.5 |
320 | 2020-01-31 13:38:00 | porter | 1 | 48755 | 11 | 1.940 | 25131.4 |
319 | 2020-01-30 17:40:15 | porter | 1 | 48755 | 11 | 0.906 | 53813.5 |
318 | 2020-01-30 05:42:04 | porter | 1 | 48755 | 11 | 0.903 | 53992.2 |
317 | 2020-01-29 08:14:46 | porter | 1 | 48755 | 11 | 0.890 | 54780.9 |
316 | 2020-01-24 15:17:26 | porter | 1 | 48755 | 11 | 0.906 | 53813.5 |
315 | 2020-01-23 00:46:24 | porter | 1 | 48755 | 11 | 0.906 | 53813.5 |
314 | 2020-01-22 07:13:47 | porter | 1 | 48755 | 11 | 2.876 | 16952.4 |
313 | 2020-01-13 02:47:34 | porter | 1 | 48755 | 11 | 2.846 | 17131.1 |