History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"choristers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
418 | 2024-05-04 14:23:33 | choristers | 3 | 140603 | 49 | 7.936 | 17717.1 |
417 | 2024-05-04 14:23:25 | choristers | 4 | 161450 | 483 | 15.030 | 10741.8 |
416 | 2024-05-04 14:23:29 | choristers | 2 | 108824 | 6 | 3.376 | 32234.6 |
415 | 2024-05-04 14:22:33 | choristers | 1 | 67641 | 2 | 1.390 | 48662.6 |
414 | 2024-04-28 16:32:54 | choristers | 1 | 67641 | 2 | 1.076 | 62863.4 |
413 | 2024-04-28 03:15:33 | choristers | 3 | 140603 | 49 | 19.626 | 7164.1 |
412 | 2024-04-27 15:03:29 | choristers | 1 | 67641 | 2 | 1.046 | 64666.3 |
411 | 2024-04-19 09:12:06 | choristers | 1 | 67641 | 2 | 1.170 | 57812.8 |
410 | 2024-04-13 14:10:56 | choristers | 1 | 67641 | 2 | 1.143 | 59178.5 |
409 | 2024-04-04 00:56:22 | choristers | 1 | 67641 | 2 | 1.313 | 51516.4 |
408 | 2024-04-01 19:19:02 | choristers | 3 | 140603 | 49 | 7.843 | 17927.2 |
407 | 2024-03-30 15:04:55 | choristers | 3 | 140603 | 49 | 16.376 | 8585.9 |
406 | 2024-03-30 07:50:52 | choristers | 3 | 140603 | 49 | 18.140 | 7751.0 |
405 | 2024-03-27 03:02:34 | choristers | 3 | 140603 | 49 | 20.186 | 6965.4 |
404 | 2024-03-27 03:02:30 | choristers | 2 | 108824 | 6 | 8.686 | 12528.7 |
403 | 2024-03-27 01:30:34 | choristers | 1 | 67641 | 2 | 1.033 | 65480.2 |
402 | 2024-03-27 01:30:28 | choristers | 1 | 67641 | 2 | 1.186 | 57032.9 |
401 | 2024-03-04 23:57:36 | choristers | 1 | 67641 | 2 | 2.376 | 28468.4 |
400 | 2024-02-29 13:47:39 | choristers | 1 | 67641 | 2 | 1.220 | 55443.4 |
399 | 2024-02-22 11:52:22 | choristers | 4 | 161450 | 483 | 27.376 | 5897.5 |
398 | 2024-02-22 11:52:26 | choristers | 3 | 140603 | 49 | 12.766 | 11013.9 |
397 | 2024-02-22 11:52:25 | choristers | 2 | 108824 | 6 | 7.313 | 14880.9 |
396 | 2024-02-22 01:03:46 | choristers | 1 | 67641 | 2 | 1.313 | 51516.4 |
395 | 2024-01-31 01:43:55 | choristers | 1 | 67641 | 2 | 1.143 | 59178.5 |
394 | 2024-01-30 12:37:36 | choristers | 1 | 67641 | 2 | 1.013 | 66773.0 |
393 | 2024-01-30 03:12:25 | choristers | 1 | 67641 | 2 | 1.106 | 61158.2 |
392 | 2024-01-26 21:06:27 | choristers | 1 | 67641 | 2 | 1.203 | 56226.9 |
391 | 2024-01-22 17:29:15 | choristers | 1 | 67641 | 2 | 1.110 | 60937.8 |
390 | 2024-01-10 04:07:41 | choristers | 4 | 161450 | 483 | 10.406 | 15515.1 |
389 | 2023-12-01 09:40:31 | choristers | 4 | 161450 | 483 | 11.423 | 14133.8 |
388 | 2023-11-26 14:53:52 | choristers | 1 | 67641 | 2 | 1.046 | 64666.3 |
387 | 2023-11-22 18:10:38 | choristers | 4 | 161450 | 483 | 28.643 | 5636.6 |
386 | 2023-11-22 09:47:53 | choristers | 1 | 67641 | 2 | 1.360 | 49736.0 |
385 | 2023-11-07 22:27:15 | choristers | 1 | 67641 | 2 | 1.000 | 67641.0 |
384 | 2023-11-06 09:51:36 | choristers | 4 | 161450 | 483 | 11.096 | 14550.3 |
383 | 2023-11-03 04:55:34 | choristers | 4 | 161450 | 483 | 9.596 | 16824.7 |
382 | 2023-10-29 09:13:41 | choristers | 4 | 161450 | 483 | 13.876 | 11635.2 |
381 | 2023-10-25 14:14:56 | choristers | 4 | 161450 | 483 | 15.783 | 10229.4 |
380 | 2023-10-22 23:26:50 | choristers | 1 | 67641 | 2 | 1.110 | 60937.8 |
379 | 2023-10-22 20:59:25 | choristers | 4 | 161450 | 483 | 10.453 | 15445.3 |
378 | 2023-10-16 07:35:16 | choristers | 4 | 161450 | 483 | 10.780 | 14976.8 |
377 | 2023-09-11 22:39:31 | choristers | 1 | 67641 | 2 | 1.016 | 66575.8 |
376 | 2023-07-26 11:20:34 | choristers | 4 | 161450 | 483 | 10.376 | 15559.9 |
375 | 2023-07-12 20:16:39 | choristers | 1 | 67641 | 2 | 1.156 | 58513.0 |
374 | 2023-06-19 22:47:50 | choristers | 4 | 161450 | 483 | 10.220 | 15797.5 |
373 | 2023-06-18 14:41:04 | choristers | 1 | 67641 | 2 | 1.123 | 60232.4 |
372 | 2023-05-29 16:57:46 | choristers | 4 | 161450 | 483 | 11.233 | 14372.8 |
371 | 2023-05-04 04:37:40 | choristers | 4 | 161450 | 483 | 10.453 | 15445.3 |
370 | 2023-04-18 23:06:59 | choristers | 1 | 67641 | 2 | 1.160 | 58311.2 |
369 | 2023-04-11 00:16:35 | choristers | 4 | 161450 | 483 | 11.296 | 14292.7 |
368 | 2023-04-06 17:02:47 | choristers | 4 | 161450 | 483 | 9.513 | 16971.5 |
367 | 2023-04-02 10:11:46 | choristers | 1 | 67641 | 2 | 0.986 | 68601.4 |
366 | 2023-03-25 03:35:39 | choristers | 1 | 67641 | 2 | 1.000 | 67641.0 |
365 | 2023-03-19 19:27:05 | choristers | 1 | 67641 | 2 | 1.140 | 59334.2 |
364 | 2023-03-10 23:57:59 | choristers | 4 | 161450 | 483 | 10.843 | 14889.8 |
363 | 2023-01-17 03:18:17 | choristers | 4 | 161450 | 483 | 10.080 | 16016.9 |
362 | 2023-01-15 04:48:53 | choristers | 1 | 67641 | 2 | 1.000 | 67641.0 |
361 | 2023-01-03 02:05:50 | choristers | 4 | 161450 | 483 | 9.453 | 17079.2 |
360 | 2022-12-27 16:50:15 | choristers | 4 | 161450 | 483 | 9.940 | 16242.5 |
359 | 2022-12-03 06:50:08 | choristers | 4 | 161450 | 483 | 12.266 | 13162.4 |
358 | 2022-11-23 20:45:17 | choristers | 1 | 67641 | 2 | 1.156 | 58513.0 |
357 | 2022-11-23 16:17:35 | choristers | 4 | 161450 | 483 | 10.266 | 15726.7 |
356 | 2022-11-10 19:47:50 | choristers | 4 | 161450 | 483 | 9.733 | 16587.9 |
355 | 2022-11-06 19:49:41 | choristers | 1 | 67641 | 2 | 1.000 | 67641.0 |
354 | 2022-11-01 07:52:37 | choristers | 4 | 161450 | 483 | 9.983 | 16172.5 |
353 | 2022-10-06 14:03:31 | choristers | 4 | 161450 | 483 | 10.530 | 15332.4 |
352 | 2022-10-02 23:51:52 | choristers | 4 | 161450 | 483 | 9.670 | 16696.0 |
351 | 2022-09-06 12:36:32 | choristers | 4 | 161450 | 483 | 10.516 | 15352.8 |
350 | 2022-09-04 10:15:56 | choristers | 4 | 161450 | 483 | 9.920 | 16275.2 |
349 | 2022-07-23 22:46:28 | choristers | 1 | 67641 | 2 | 1.033 | 65480.2 |
348 | 2022-06-27 09:04:23 | choristers | 1 | 67641 | 2 | 1.000 | 67641.0 |
347 | 2022-06-26 16:06:48 | choristers | 1 | 67641 | 2 | 1.033 | 65480.2 |
346 | 2022-06-25 04:05:26 | choristers | 1 | 67641 | 2 | 1.003 | 67438.7 |
345 | 2022-06-19 21:27:48 | choristers | 4 | 161450 | 483 | 9.626 | 16772.3 |
344 | 2022-05-03 15:24:15 | choristers | 4 | 161450 | 483 | 12.733 | 12679.7 |
343 | 2022-04-03 23:12:21 | choristers | 4 | 161450 | 483 | 10.673 | 15127.0 |
342 | 2022-03-29 22:24:46 | choristers | 4 | 161450 | 483 | 11.596 | 13922.9 |
341 | 2022-03-26 02:47:22 | choristers | 1 | 67641 | 2 | 1.013 | 66773.0 |
340 | 2022-02-28 04:51:52 | choristers | 1 | 67641 | 2 | 1.016 | 66575.8 |
339 | 2022-02-26 01:14:27 | choristers | 1 | 67641 | 2 | 1.203 | 56226.9 |
338 | 2021-12-25 13:53:05 | choristers | 1 | 67641 | 2 | 1.280 | 52844.5 |
337 | 2021-12-23 11:39:06 | choristers | 1 | 67641 | 2 | 1.220 | 55443.4 |
336 | 2021-12-15 19:41:06 | choristers | 1 | 67641 | 2 | 1.143 | 59178.5 |
335 | 2021-12-05 12:14:35 | choristers | 1 | 67641 | 2 | 1.093 | 61885.6 |
334 | 2021-09-22 11:18:40 | choristers | 1 | 67641 | 2 | 1.156 | 58513.0 |
333 | 2021-09-15 05:32:14 | choristers | 1 | 67641 | 2 | 1.030 | 65670.9 |
332 | 2021-08-19 02:18:07 | choristers | 1 | 67641 | 2 | 1.016 | 66575.8 |
331 | 2021-05-26 21:01:55 | choristers | 4 | 161450 | 483 | 12.453 | 12964.7 |
330 | 2021-05-15 03:06:24 | choristers | 1 | 67641 | 2 | 1.046 | 64666.3 |
329 | 2021-03-15 07:10:08 | choristers | 3 | 140603 | 49 | 6.360 | 22107.4 |
328 | 2021-02-16 22:26:30 | choristers | 4 | 161450 | 483 | 9.890 | 16324.6 |
327 | 2021-02-12 09:52:17 | choristers | 1 | 67641 | 2 | 1.013 | 66773.0 |
326 | 2021-02-09 23:16:33 | choristers | 4 | 161450 | 483 | 9.876 | 16347.7 |
325 | 2020-12-27 15:01:01 | choristers | 3 | 140603 | 49 | 5.503 | 25550.2 |
324 | 2020-11-10 16:17:02 | choristers | 1 | 67641 | 2 | 1.190 | 56841.2 |
323 | 2020-11-08 08:15:26 | choristers | 4 | 161450 | 483 | 10.216 | 15803.6 |
322 | 2020-11-02 13:46:15 | choristers | 3 | 140603 | 49 | 6.953 | 20221.9 |
321 | 2020-10-30 00:09:04 | choristers | 4 | 161450 | 483 | 10.453 | 15445.3 |
320 | 2020-10-25 20:39:36 | choristers | 1 | 67641 | 2 | 1.186 | 57032.9 |
319 | 2020-10-24 08:25:08 | choristers | 1 | 67641 | 2 | 1.110 | 60937.8 |