History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"meccas"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
385 | 2024-05-01 18:21:08 | meccas | 1 | 48755 | 2 | 0.936 | 52088.7 |
384 | 2024-04-19 08:48:39 | meccas | 1 | 48755 | 2 | 0.873 | 55847.7 |
383 | 2024-04-06 13:37:13 | meccas | 3 | 112716 | 431 | 14.736 | 7649.0 |
382 | 2024-04-06 13:37:13 | meccas | 2 | 82551 | 18 | 8.610 | 9587.8 |
381 | 2024-04-06 13:36:57 | meccas | 1 | 48755 | 2 | 1.826 | 26700.4 |
380 | 2024-04-02 13:32:14 | meccas | 1 | 48755 | 2 | 0.826 | 59025.4 |
379 | 2024-03-31 02:09:47 | meccas | 3 | 112716 | 431 | 10.783 | 10453.1 |
378 | 2024-03-29 22:07:25 | meccas | 3 | 112716 | 431 | 13.376 | 8426.7 |
377 | 2024-03-29 19:07:20 | meccas | 3 | 112716 | 431 | 5.796 | 19447.2 |
376 | 2024-03-29 19:07:15 | meccas | 2 | 82551 | 18 | 2.923 | 28241.9 |
375 | 2024-03-29 19:07:08 | meccas | 1 | 48755 | 2 | 0.953 | 51159.5 |
374 | 2024-01-18 21:10:20 | meccas | 3 | 112716 | 431 | 5.563 | 20261.7 |
373 | 2024-01-18 21:10:19 | meccas | 2 | 82551 | 18 | 2.576 | 32046.2 |
372 | 2024-01-01 19:01:53 | meccas | 1 | 48755 | 2 | 0.920 | 52994.6 |
371 | 2023-12-15 07:50:59 | meccas | 1 | 48755 | 2 | 0.750 | 65006.7 |
370 | 2023-12-11 21:57:33 | meccas | 1 | 48755 | 2 | 0.876 | 55656.4 |
369 | 2023-11-22 14:58:47 | meccas | 1 | 48755 | 2 | 0.766 | 63648.8 |
368 | 2023-11-20 16:11:10 | meccas | 1 | 48755 | 2 | 0.766 | 63648.8 |
367 | 2023-11-17 18:48:31 | meccas | 1 | 48755 | 2 | 0.796 | 61250.0 |
366 | 2023-11-04 23:13:13 | meccas | 1 | 48755 | 2 | 0.733 | 66514.3 |
365 | 2023-10-25 10:06:19 | meccas | 1 | 48755 | 2 | 0.810 | 60191.4 |
364 | 2023-10-22 14:05:12 | meccas | 1 | 48755 | 2 | 0.736 | 66243.2 |
363 | 2023-10-11 07:32:28 | meccas | 1 | 48755 | 2 | 0.783 | 62266.9 |
362 | 2023-09-28 04:15:26 | meccas | 1 | 48755 | 2 | 0.830 | 58741.0 |
361 | 2023-09-12 20:06:40 | meccas | 1 | 48755 | 2 | 0.860 | 56691.9 |
360 | 2023-08-20 09:30:48 | meccas | 1 | 48755 | 2 | 0.796 | 61250.0 |
359 | 2023-08-08 20:27:19 | meccas | 1 | 48755 | 2 | 0.860 | 56691.9 |
358 | 2023-05-18 12:42:36 | meccas | 1 | 48755 | 2 | 0.796 | 61250.0 |
357 | 2023-04-20 05:06:52 | meccas | 1 | 48755 | 2 | 0.876 | 55656.4 |
356 | 2023-03-12 00:24:53 | meccas | 1 | 48755 | 2 | 0.716 | 68093.6 |
355 | 2023-01-04 01:52:54 | meccas | 1 | 48755 | 2 | 0.733 | 66514.3 |
354 | 2022-12-31 07:32:11 | meccas | 1 | 48755 | 2 | 0.733 | 66514.3 |
353 | 2022-09-21 07:45:50 | meccas | 1 | 48755 | 2 | 0.733 | 66514.3 |
352 | 2022-09-06 02:58:19 | meccas | 1 | 48755 | 2 | 0.750 | 65006.7 |
351 | 2022-08-15 05:56:42 | meccas | 1 | 48755 | 2 | 0.843 | 57835.1 |
350 | 2022-08-06 21:29:44 | meccas | 1 | 48755 | 2 | 0.843 | 57835.1 |
349 | 2022-07-29 13:44:37 | meccas | 1 | 48755 | 2 | 0.843 | 57835.1 |
348 | 2022-05-03 20:58:32 | meccas | 1 | 48755 | 2 | 0.890 | 54780.9 |
347 | 2022-04-30 08:33:45 | meccas | 1 | 48755 | 2 | 0.750 | 65006.7 |
346 | 2022-03-22 10:14:36 | meccas | 1 | 48755 | 2 | 1.080 | 45143.5 |
345 | 2022-03-22 08:21:36 | meccas | 1 | 48755 | 2 | 0.906 | 53813.5 |
344 | 2022-01-22 21:19:31 | meccas | 1 | 48755 | 2 | 0.830 | 58741.0 |
343 | 2022-01-20 16:49:07 | meccas | 1 | 48755 | 2 | 0.736 | 66243.2 |
342 | 2022-01-06 19:57:35 | meccas | 1 | 48755 | 2 | 1.016 | 47987.2 |
341 | 2021-11-20 05:46:46 | meccas | 1 | 48755 | 2 | 0.750 | 65006.7 |
340 | 2021-11-16 08:20:01 | meccas | 1 | 48755 | 2 | 0.750 | 65006.7 |
339 | 2021-11-14 06:49:56 | meccas | 1 | 48755 | 2 | 0.906 | 53813.5 |
338 | 2021-11-12 05:48:38 | meccas | 1 | 48755 | 2 | 0.986 | 49447.3 |
337 | 2021-10-14 12:53:19 | meccas | 1 | 48755 | 2 | 0.826 | 59025.4 |
336 | 2021-09-30 15:39:18 | meccas | 1 | 48755 | 2 | 0.813 | 59969.2 |
335 | 2021-08-28 00:49:11 | meccas | 3 | 112716 | 431 | 5.300 | 21267.2 |
334 | 2021-07-01 06:29:49 | meccas | 1 | 48755 | 2 | 0.843 | 57835.1 |
333 | 2021-06-30 23:37:59 | meccas | 1 | 48755 | 2 | 0.766 | 63648.8 |
332 | 2021-06-20 10:27:01 | meccas | 3 | 112716 | 431 | 5.436 | 20735.1 |
331 | 2021-06-14 15:01:12 | meccas | 2 | 82551 | 18 | 2.500 | 33020.4 |
330 | 2021-05-17 14:29:12 | meccas | 2 | 82551 | 18 | 2.140 | 38575.2 |
329 | 2021-05-16 04:18:03 | meccas | 1 | 48755 | 2 | 0.890 | 54780.9 |
328 | 2021-05-13 21:37:30 | meccas | 1 | 48755 | 2 | 0.860 | 56691.9 |
327 | 2021-05-13 13:55:55 | meccas | 3 | 112716 | 431 | 5.406 | 20850.2 |
326 | 2021-04-21 09:23:12 | meccas | 1 | 48755 | 2 | 0.750 | 65006.7 |
325 | 2021-04-18 21:43:42 | meccas | 1 | 48755 | 2 | 0.830 | 58741.0 |
324 | 2021-04-17 22:47:58 | meccas | 1 | 48755 | 2 | 1.783 | 27344.4 |
323 | 2021-04-12 19:43:24 | meccas | 1 | 48755 | 2 | 0.810 | 60191.4 |
322 | 2021-03-31 07:15:40 | meccas | 1 | 48755 | 2 | 0.750 | 65006.7 |
321 | 2021-02-19 15:17:24 | meccas | 1 | 48755 | 2 | 0.843 | 57835.1 |
320 | 2021-01-31 05:39:04 | meccas | 1 | 48755 | 2 | 0.860 | 56691.9 |
319 | 2021-01-28 03:27:42 | meccas | 1 | 48755 | 2 | 0.733 | 66514.3 |
318 | 2020-12-29 19:03:16 | meccas | 1 | 48755 | 2 | 0.860 | 56691.9 |
317 | 2020-12-26 20:09:22 | meccas | 1 | 48755 | 2 | 0.843 | 57835.1 |
316 | 2020-11-13 20:54:45 | meccas | 1 | 48755 | 2 | 0.733 | 66514.3 |
315 | 2020-10-16 05:48:20 | meccas | 1 | 48755 | 2 | 0.860 | 56691.9 |
314 | 2020-10-15 15:23:38 | meccas | 1 | 48755 | 2 | 0.813 | 59969.2 |
313 | 2020-10-14 21:33:28 | meccas | 1 | 48755 | 2 | 0.736 | 66243.2 |
312 | 2020-09-23 03:57:36 | meccas | 1 | 48755 | 2 | 0.750 | 65006.7 |
311 | 2020-09-05 01:03:24 | meccas | 1 | 48755 | 2 | 0.736 | 66243.2 |
310 | 2020-08-30 08:28:07 | meccas | 1 | 48755 | 2 | 0.766 | 63648.8 |
309 | 2020-08-28 12:39:55 | meccas | 1 | 48755 | 2 | 0.873 | 55847.7 |
308 | 2020-08-23 14:10:38 | meccas | 1 | 48755 | 2 | 0.783 | 62266.9 |
307 | 2020-07-24 05:53:10 | meccas | 1 | 48755 | 2 | 0.796 | 61250.0 |
306 | 2020-06-15 03:10:12 | meccas | 1 | 48755 | 2 | 0.796 | 61250.0 |
305 | 2020-06-12 03:34:19 | meccas | 1 | 48755 | 2 | 0.780 | 62506.4 |
304 | 2020-04-18 06:30:37 | meccas | 1 | 48755 | 2 | 0.830 | 58741.0 |
303 | 2020-04-17 06:49:36 | meccas | 1 | 48755 | 2 | 0.843 | 57835.1 |
302 | 2020-04-16 07:07:33 | meccas | 1 | 48755 | 2 | 0.843 | 57835.1 |
301 | 2020-04-15 06:29:20 | meccas | 1 | 48755 | 2 | 0.796 | 61250.0 |
300 | 2020-03-27 20:48:22 | meccas | 1 | 48755 | 2 | 1.220 | 39963.1 |
299 | 2020-03-26 18:02:37 | meccas | 1 | 48755 | 2 | 0.750 | 65006.7 |
298 | 2020-03-23 07:24:57 | meccas | 1 | 48755 | 2 | 0.920 | 52994.6 |
297 | 2020-03-23 01:02:33 | meccas | 1 | 48755 | 2 | 0.860 | 56691.9 |
296 | 2020-03-22 13:50:15 | meccas | 1 | 48755 | 2 | 0.876 | 55656.4 |
295 | 2020-03-20 02:01:20 | meccas | 1 | 48755 | 2 | 0.856 | 56956.8 |
294 | 2020-03-18 22:52:48 | meccas | 1 | 48755 | 2 | 0.906 | 53813.5 |
293 | 2020-03-01 20:09:49 | meccas | 1 | 48755 | 2 | 0.750 | 65006.7 |
292 | 2020-02-26 13:07:44 | meccas | 3 | 112716 | 431 | 5.500 | 20493.8 |
291 | 2020-02-25 19:06:02 | meccas | 1 | 48755 | 2 | 0.890 | 54780.9 |
290 | 2020-02-22 23:20:31 | meccas | 1 | 48755 | 2 | 0.906 | 53813.5 |
289 | 2020-02-13 20:13:35 | meccas | 1 | 48755 | 2 | 0.830 | 58741.0 |
288 | 2020-02-09 03:37:42 | meccas | 3 | 112716 | 431 | 5.656 | 19928.6 |
287 | 2020-02-08 20:51:18 | meccas | 3 | 112716 | 431 | 19.063 | 5912.8 |
286 | 2020-02-03 16:14:33 | meccas | 1 | 48755 | 2 | 1.780 | 27390.4 |