History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mecca"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
412 | 2024-04-27 10:59:32 | mecca | 1 | 28756 | 2 | 0.593 | 48492.4 |
411 | 2024-04-27 10:03:57 | mecca | 2 | 53800 | 28 | 5.330 | 10093.8 |
410 | 2024-04-24 13:33:17 | mecca | 1 | 28756 | 2 | 1.470 | 19561.9 |
409 | 2024-04-20 19:06:54 | mecca | 1 | 28756 | 2 | 0.690 | 41675.4 |
408 | 2024-04-03 07:50:16 | mecca | 3 | 83667 | 528 | 9.186 | 9108.1 |
407 | 2024-04-03 07:50:11 | mecca | 2 | 53800 | 28 | 2.906 | 18513.4 |
406 | 2024-04-03 07:41:35 | mecca | 1 | 28756 | 2 | 0.546 | 52666.7 |
405 | 2024-03-31 15:42:27 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
404 | 2024-03-30 19:31:57 | mecca | 3 | 83667 | 528 | 10.690 | 7826.7 |
403 | 2024-03-29 15:44:15 | mecca | 2 | 53800 | 28 | 5.796 | 9282.3 |
402 | 2024-03-29 15:43:24 | mecca | 3 | 83667 | 528 | 6.640 | 12600.5 |
401 | 2024-03-29 09:54:02 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
400 | 2024-03-29 09:53:43 | mecca | 3 | 83667 | 528 | 3.780 | 22134.1 |
399 | 2024-03-29 09:53:39 | mecca | 1 | 28756 | 2 | 0.483 | 59536.2 |
398 | 2024-03-04 01:31:04 | mecca | 2 | 53800 | 28 | 1.656 | 32487.9 |
397 | 2024-03-04 01:31:02 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
396 | 2024-03-01 12:01:27 | mecca | 1 | 28756 | 2 | 0.530 | 54256.6 |
395 | 2024-03-01 03:59:58 | mecca | 2 | 53800 | 28 | 2.983 | 18035.5 |
394 | 2024-03-01 03:59:36 | mecca | 3 | 83667 | 528 | 4.170 | 20064.0 |
393 | 2024-02-28 13:43:29 | mecca | 2 | 53800 | 28 | 1.610 | 33416.1 |
392 | 2024-02-28 13:43:15 | mecca | 3 | 83667 | 528 | 4.250 | 19686.4 |
391 | 2024-02-28 07:41:06 | mecca | 3 | 83667 | 528 | 11.736 | 7129.1 |
390 | 2024-02-28 07:41:05 | mecca | 2 | 53800 | 28 | 3.686 | 14595.8 |
389 | 2024-02-28 07:41:00 | mecca | 1 | 28756 | 2 | 0.700 | 41080.0 |
388 | 2024-02-05 11:14:30 | mecca | 1 | 28756 | 2 | 0.533 | 53951.2 |
387 | 2024-02-04 14:11:51 | mecca | 1 | 28756 | 2 | 1.656 | 17364.7 |
386 | 2024-01-29 06:05:27 | mecca | 1 | 28756 | 2 | 0.483 | 59536.2 |
385 | 2024-01-29 03:56:01 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
384 | 2023-12-31 06:55:23 | mecca | 3 | 83667 | 528 | 3.656 | 22884.8 |
383 | 2023-12-31 06:55:21 | mecca | 2 | 53800 | 28 | 1.360 | 39558.8 |
382 | 2023-12-30 05:45:22 | mecca | 3 | 83667 | 528 | 3.250 | 25743.7 |
381 | 2023-12-30 05:45:20 | mecca | 2 | 53800 | 28 | 1.360 | 39558.8 |
380 | 2023-12-27 19:22:27 | mecca | 2 | 53800 | 28 | 1.466 | 36698.5 |
379 | 2023-12-12 14:39:16 | mecca | 1 | 28756 | 2 | 0.453 | 63479.0 |
378 | 2023-12-08 22:35:35 | mecca | 1 | 28756 | 2 | 0.466 | 61708.2 |
377 | 2023-11-30 00:32:47 | mecca | 1 | 28756 | 2 | 0.453 | 63479.0 |
376 | 2023-11-26 16:38:21 | mecca | 3 | 83667 | 528 | 3.360 | 24900.9 |
375 | 2023-11-26 16:38:19 | mecca | 2 | 53800 | 28 | 1.406 | 38264.6 |
374 | 2023-11-13 23:11:13 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
373 | 2023-11-13 15:24:09 | mecca | 1 | 28756 | 2 | 0.440 | 65354.5 |
372 | 2023-11-05 09:11:27 | mecca | 1 | 28756 | 2 | 0.483 | 59536.2 |
371 | 2023-10-22 01:44:06 | mecca | 1 | 28756 | 2 | 0.483 | 59536.2 |
370 | 2023-10-18 18:34:40 | mecca | 1 | 28756 | 2 | 0.560 | 51350.0 |
369 | 2023-10-14 02:43:37 | mecca | 1 | 28756 | 2 | 0.423 | 67981.1 |
368 | 2023-10-05 01:35:19 | mecca | 1 | 28756 | 2 | 0.420 | 68466.7 |
367 | 2023-09-29 12:40:11 | mecca | 1 | 28756 | 2 | 0.470 | 61183.0 |
366 | 2023-09-28 20:32:15 | mecca | 2 | 53800 | 28 | 1.346 | 39970.3 |
365 | 2023-09-14 18:18:13 | mecca | 1 | 28756 | 2 | 0.533 | 53951.2 |
364 | 2023-09-12 20:51:19 | mecca | 1 | 28756 | 2 | 0.423 | 67981.1 |
363 | 2023-08-13 01:33:05 | mecca | 1 | 28756 | 2 | 0.530 | 54256.6 |
362 | 2023-07-08 13:01:26 | mecca | 2 | 53800 | 28 | 1.390 | 38705.0 |
361 | 2023-06-29 01:08:32 | mecca | 1 | 28756 | 2 | 0.470 | 61183.0 |
360 | 2023-04-20 20:49:28 | mecca | 1 | 28756 | 2 | 0.486 | 59168.7 |
359 | 2023-04-17 12:02:29 | mecca | 1 | 28756 | 2 | 0.420 | 68466.7 |
358 | 2023-04-10 09:15:43 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
357 | 2023-03-26 11:27:30 | mecca | 2 | 53800 | 28 | 1.346 | 39970.3 |
356 | 2023-03-19 10:14:19 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
355 | 2023-02-02 03:59:16 | mecca | 1 | 28756 | 2 | 0.470 | 61183.0 |
354 | 2022-12-24 14:03:44 | mecca | 1 | 28756 | 2 | 0.453 | 63479.0 |
353 | 2022-12-23 02:33:58 | mecca | 2 | 53800 | 28 | 1.326 | 40573.2 |
352 | 2022-11-30 07:09:32 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
351 | 2022-08-31 19:02:58 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
350 | 2022-08-21 23:36:49 | mecca | 2 | 53800 | 28 | 1.390 | 38705.0 |
349 | 2022-08-20 18:23:09 | mecca | 1 | 28756 | 2 | 0.440 | 65354.5 |
348 | 2022-07-25 04:53:52 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
347 | 2022-04-13 07:32:08 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
346 | 2022-04-01 12:53:40 | mecca | 2 | 53800 | 28 | 1.343 | 40059.6 |
345 | 2022-03-26 12:10:43 | mecca | 1 | 28756 | 2 | 0.440 | 65354.5 |
344 | 2022-01-03 12:55:09 | mecca | 1 | 28756 | 2 | 0.466 | 61708.2 |
343 | 2022-01-01 09:35:46 | mecca | 1 | 28756 | 2 | 0.466 | 61708.2 |
342 | 2021-12-25 15:52:29 | mecca | 1 | 28756 | 2 | 0.516 | 55728.7 |
341 | 2021-11-01 20:14:33 | mecca | 1 | 28756 | 2 | 0.453 | 63479.0 |
340 | 2021-10-30 19:08:32 | mecca | 1 | 28756 | 2 | 0.423 | 67981.1 |
339 | 2021-10-01 22:20:02 | mecca | 1 | 28756 | 2 | 0.483 | 59536.2 |
338 | 2021-09-15 05:45:21 | mecca | 1 | 28756 | 2 | 0.953 | 30174.2 |
337 | 2021-06-15 06:20:10 | mecca | 1 | 28756 | 2 | 0.453 | 63479.0 |
336 | 2021-06-14 04:01:32 | mecca | 1 | 28756 | 2 | 0.483 | 59536.2 |
335 | 2021-05-06 04:52:07 | mecca | 1 | 28756 | 2 | 0.513 | 56054.6 |
334 | 2021-03-25 20:10:01 | mecca | 3 | 83667 | 528 | 3.406 | 24564.6 |
333 | 2021-03-24 05:21:53 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
332 | 2021-03-15 21:20:43 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
331 | 2021-02-19 22:52:02 | mecca | 1 | 28756 | 2 | 0.453 | 63479.0 |
330 | 2021-01-09 02:41:37 | mecca | 3 | 83667 | 528 | 3.483 | 24021.5 |
329 | 2021-01-06 21:20:20 | mecca | 1 | 28756 | 2 | 0.546 | 52666.7 |
328 | 2020-12-12 21:47:36 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
327 | 2020-11-08 06:34:54 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
326 | 2020-10-30 23:07:41 | mecca | 1 | 28756 | 2 | 0.563 | 51076.4 |
325 | 2020-10-20 23:43:20 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
324 | 2020-10-20 07:44:38 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
323 | 2020-09-27 15:14:25 | mecca | 3 | 83667 | 528 | 3.250 | 25743.7 |
322 | 2020-09-12 12:28:27 | mecca | 1 | 28756 | 2 | 0.450 | 63902.2 |
321 | 2020-09-12 04:24:35 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
320 | 2020-09-05 09:35:07 | mecca | 3 | 83667 | 528 | 3.296 | 25384.4 |
319 | 2020-06-03 21:39:41 | mecca | 1 | 28756 | 2 | 0.470 | 61183.0 |
318 | 2020-05-24 23:37:06 | mecca | 3 | 83667 | 528 | 3.233 | 25879.1 |
317 | 2020-03-25 20:23:53 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
316 | 2020-03-24 21:44:49 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
315 | 2020-03-22 12:16:45 | mecca | 1 | 28756 | 2 | 0.486 | 59168.7 |
314 | 2020-03-22 02:11:05 | mecca | 1 | 28756 | 2 | 0.516 | 55728.7 |
313 | 2020-03-21 11:14:36 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |