History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"orange"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
411 | 2024-02-21 06:30:34 | orange | 2 | 82551 | 48 | 3.436 | 24025.3 |
410 | 2024-02-08 21:45:07 | orange | 3 | 112716 | 664 | 7.266 | 15512.8 |
409 | 2024-02-07 10:07:38 | orange | 2 | 82551 | 48 | 2.560 | 32246.5 |
408 | 2024-02-07 10:05:50 | orange | 3 | 112716 | 664 | 5.656 | 19928.6 |
407 | 2024-02-03 07:28:54 | orange | 2 | 82551 | 48 | 2.626 | 31436.0 |
406 | 2024-02-03 07:28:26 | orange | 3 | 112716 | 664 | 5.843 | 19290.8 |
405 | 2024-02-03 00:46:49 | orange | 3 | 112716 | 664 | 6.203 | 18171.2 |
404 | 2024-02-03 00:45:09 | orange | 2 | 82551 | 48 | 5.233 | 15775.1 |
403 | 2024-02-03 00:05:32 | orange | 3 | 112716 | 664 | 6.110 | 18447.8 |
402 | 2024-02-03 00:05:36 | orange | 2 | 82551 | 48 | 2.593 | 31836.1 |
401 | 2023-12-26 15:59:22 | orange | 1 | 48755 | 8 | 0.736 | 66243.2 |
400 | 2023-12-12 11:56:48 | orange | 3 | 112716 | 664 | 5.076 | 22205.7 |
399 | 2023-12-08 08:39:41 | orange | 1 | 48755 | 8 | 0.843 | 57835.1 |
398 | 2023-12-08 08:39:40 | orange | 1 | 48755 | 8 | 0.826 | 59025.4 |
397 | 2023-12-05 11:49:08 | orange | 3 | 112716 | 664 | 6.220 | 18121.5 |
396 | 2023-12-05 11:49:07 | orange | 2 | 82551 | 48 | 2.700 | 30574.4 |
395 | 2023-12-04 04:25:21 | orange | 2 | 82551 | 48 | 2.296 | 35954.3 |
394 | 2023-11-29 14:24:43 | orange | 3 | 112716 | 664 | 9.203 | 12247.7 |
393 | 2023-11-18 05:32:44 | orange | 2 | 82551 | 48 | 2.190 | 37694.5 |
392 | 2023-11-17 00:27:29 | orange | 1 | 48755 | 8 | 0.796 | 61250.0 |
391 | 2023-11-13 14:06:26 | orange | 1 | 48755 | 8 | 0.766 | 63648.8 |
390 | 2023-11-11 11:37:24 | orange | 1 | 48755 | 8 | 0.766 | 63648.8 |
389 | 2023-11-10 10:29:23 | orange | 3 | 112716 | 664 | 8.126 | 13871.0 |
388 | 2023-11-10 10:28:24 | orange | 2 | 82551 | 48 | 2.656 | 31080.9 |
387 | 2023-10-29 01:11:31 | orange | 1 | 48755 | 8 | 0.860 | 56691.9 |
386 | 2023-10-21 09:20:32 | orange | 1 | 48755 | 8 | 0.826 | 59025.4 |
385 | 2023-10-18 17:03:40 | orange | 1 | 48755 | 8 | 0.876 | 55656.4 |
384 | 2023-10-14 10:03:08 | orange | 1 | 48755 | 8 | 0.923 | 52822.3 |
383 | 2023-10-13 18:52:51 | orange | 1 | 48755 | 8 | 0.736 | 66243.2 |
382 | 2023-10-04 13:35:00 | orange | 1 | 48755 | 8 | 1.796 | 27146.4 |
381 | 2023-09-26 13:03:14 | orange | 1 | 48755 | 8 | 0.843 | 57835.1 |
380 | 2023-09-14 19:42:04 | orange | 1 | 48755 | 8 | 0.750 | 65006.7 |
379 | 2023-08-19 12:59:40 | orange | 2 | 82551 | 48 | 2.233 | 36968.7 |
378 | 2023-08-10 18:48:03 | orange | 1 | 48755 | 8 | 0.780 | 62506.4 |
377 | 2023-07-05 06:54:48 | orange | 1 | 48755 | 8 | 0.846 | 57630.0 |
376 | 2023-05-08 17:06:58 | orange | 1 | 48755 | 8 | 0.826 | 59025.4 |
375 | 2023-05-03 17:01:23 | orange | 2 | 82551 | 48 | 2.186 | 37763.5 |
374 | 2023-03-18 11:41:32 | orange | 1 | 48755 | 8 | 0.750 | 65006.7 |
373 | 2023-02-24 21:19:44 | orange | 1 | 48755 | 8 | 0.843 | 57835.1 |
372 | 2023-02-08 14:30:38 | orange | 2 | 82551 | 48 | 2.533 | 32590.2 |
371 | 2022-12-22 18:34:26 | orange | 1 | 48755 | 8 | 0.736 | 66243.2 |
370 | 2022-11-23 19:51:05 | orange | 1 | 48755 | 8 | 0.750 | 65006.7 |
369 | 2022-11-21 11:22:55 | orange | 2 | 82551 | 48 | 2.173 | 37989.4 |
368 | 2022-09-18 13:18:36 | orange | 1 | 48755 | 8 | 0.890 | 54780.9 |
367 | 2022-09-12 17:46:35 | orange | 2 | 82551 | 48 | 2.233 | 36968.7 |
366 | 2022-09-12 17:44:48 | orange | 3 | 112716 | 664 | 4.856 | 23211.7 |
365 | 2022-09-10 14:59:58 | orange | 1 | 48755 | 8 | 0.826 | 59025.4 |
364 | 2022-09-04 16:00:49 | orange | 2 | 82551 | 48 | 2.250 | 36689.3 |
363 | 2022-09-04 16:00:02 | orange | 3 | 112716 | 664 | 4.813 | 23419.1 |
362 | 2022-09-04 10:12:41 | orange | 1 | 48755 | 8 | 0.750 | 65006.7 |
361 | 2022-08-31 02:07:46 | orange | 1 | 48755 | 8 | 0.750 | 65006.7 |
360 | 2022-08-26 03:35:06 | orange | 1 | 48755 | 8 | 0.800 | 60943.8 |
359 | 2022-07-28 18:46:52 | orange | 1 | 48755 | 8 | 0.796 | 61250.0 |
358 | 2022-07-23 21:53:32 | orange | 1 | 48755 | 8 | 0.796 | 61250.0 |
357 | 2022-07-10 04:11:27 | orange | 1 | 48755 | 8 | 0.860 | 56691.9 |
356 | 2022-07-02 15:53:31 | orange | 1 | 48755 | 8 | 0.750 | 65006.7 |
355 | 2022-06-23 01:19:36 | orange | 2 | 82551 | 48 | 2.250 | 36689.3 |
354 | 2022-04-26 09:12:09 | orange | 1 | 48755 | 8 | 0.903 | 53992.2 |
353 | 2022-04-21 22:09:48 | orange | 1 | 48755 | 8 | 0.766 | 63648.8 |
352 | 2022-03-22 17:02:12 | orange | 1 | 48755 | 8 | 0.873 | 55847.7 |
351 | 2022-01-31 03:38:01 | orange | 2 | 82551 | 48 | 2.623 | 31472.0 |
350 | 2022-01-13 09:14:48 | orange | 1 | 48755 | 8 | 0.766 | 63648.8 |
349 | 2021-12-08 18:03:58 | orange | 1 | 48755 | 8 | 0.860 | 56691.9 |
348 | 2021-11-16 00:28:41 | orange | 1 | 48755 | 8 | 0.780 | 62506.4 |
347 | 2021-11-09 08:07:18 | orange | 1 | 48755 | 8 | 0.750 | 65006.7 |
346 | 2021-11-07 06:23:33 | orange | 1 | 48755 | 8 | 0.876 | 55656.4 |
345 | 2021-09-26 20:59:19 | orange | 1 | 48755 | 8 | 0.766 | 63648.8 |
344 | 2021-09-24 17:59:12 | orange | 1 | 48755 | 8 | 0.860 | 56691.9 |
343 | 2021-09-19 01:45:22 | orange | 1 | 48755 | 8 | 0.846 | 57630.0 |
342 | 2021-09-11 19:57:14 | orange | 1 | 48755 | 8 | 0.766 | 63648.8 |
341 | 2021-09-01 08:51:50 | orange | 1 | 48755 | 8 | 0.890 | 54780.9 |
340 | 2021-08-25 06:53:10 | orange | 1 | 48755 | 8 | 0.860 | 56691.9 |
339 | 2021-08-23 02:48:44 | orange | 1 | 48755 | 8 | 0.750 | 65006.7 |
338 | 2021-07-16 00:31:45 | orange | 1 | 48755 | 8 | 0.783 | 62266.9 |
337 | 2021-05-31 15:56:26 | orange | 1 | 48755 | 8 | 0.860 | 56691.9 |
336 | 2021-05-05 07:45:15 | orange | 1 | 48755 | 8 | 1.453 | 33554.7 |
335 | 2021-04-30 11:51:41 | orange | 3 | 112716 | 664 | 7.843 | 14371.5 |
334 | 2021-04-03 11:13:26 | orange | 1 | 48755 | 8 | 1.690 | 28849.1 |
333 | 2021-02-25 06:44:32 | orange | 1 | 48755 | 8 | 0.890 | 54780.9 |
332 | 2021-02-11 21:07:36 | orange | 1 | 48755 | 8 | 0.750 | 65006.7 |
331 | 2021-01-18 10:25:32 | orange | 1 | 48755 | 8 | 1.516 | 32160.3 |
330 | 2021-01-13 13:25:49 | orange | 3 | 112716 | 664 | 5.280 | 21347.7 |
329 | 2020-11-24 00:35:25 | orange | 1 | 48755 | 8 | 0.830 | 58741.0 |
328 | 2020-11-23 15:20:12 | orange | 1 | 48755 | 8 | 0.733 | 66514.3 |
327 | 2020-11-20 08:12:54 | orange | 1 | 48755 | 8 | 0.843 | 57835.1 |
326 | 2020-10-28 07:09:15 | orange | 1 | 48755 | 8 | 1.220 | 39963.1 |
325 | 2020-10-25 17:16:30 | orange | 3 | 112716 | 664 | 5.720 | 19705.6 |
324 | 2020-08-22 06:17:56 | orange | 1 | 48755 | 8 | 0.766 | 63648.8 |
323 | 2020-08-19 22:28:31 | orange | 1 | 48755 | 8 | 0.860 | 56691.9 |
322 | 2020-08-17 09:42:29 | orange | 1 | 48755 | 8 | 0.766 | 63648.8 |
321 | 2020-08-16 18:50:57 | orange | 1 | 48755 | 8 | 0.766 | 63648.8 |
320 | 2020-08-09 04:53:17 | orange | 1 | 48755 | 8 | 0.766 | 63648.8 |
319 | 2020-07-28 17:20:16 | orange | 1 | 48755 | 8 | 0.796 | 61250.0 |
318 | 2020-07-25 08:24:33 | orange | 1 | 48755 | 8 | 0.780 | 62506.4 |
317 | 2020-06-19 05:38:49 | orange | 1 | 48755 | 8 | 0.890 | 54780.9 |
316 | 2020-05-09 12:22:19 | orange | 1 | 48755 | 8 | 0.750 | 65006.7 |
315 | 2020-03-28 22:20:27 | orange | 1 | 48755 | 8 | 0.920 | 52994.6 |
314 | 2020-03-28 05:20:37 | orange | 1 | 48755 | 8 | 0.843 | 57835.1 |
313 | 2020-03-27 03:40:47 | orange | 1 | 48755 | 8 | 0.843 | 57835.1 |
312 | 2020-03-25 13:22:52 | orange | 1 | 48755 | 8 | 0.966 | 50471.0 |