History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tzaddik"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
115 | 2024-04-30 08:33:09 | tzaddik | 4 | 151207 | 321 | 22.800 | 6631.9 |
114 | 2024-04-29 00:27:45 | tzaddik | 1 | 69583 | 3 | 1.250 | 55666.4 |
113 | 2024-04-29 00:27:33 | tzaddik | 2 | 107671 | 5 | 3.110 | 34620.9 |
112 | 2024-04-29 00:27:29 | tzaddik | 3 | 134027 | 20 | 6.500 | 20619.5 |
111 | 2024-04-19 09:20:04 | tzaddik | 2 | 107671 | 5 | 3.830 | 28112.5 |
110 | 2024-04-17 17:39:52 | tzaddik | 3 | 134027 | 20 | 6.813 | 19672.2 |
109 | 2024-04-13 05:39:28 | tzaddik | 3 | 134027 | 20 | 6.906 | 19407.3 |
108 | 2024-04-13 05:39:15 | tzaddik | 2 | 107671 | 5 | 3.343 | 32207.9 |
107 | 2024-04-11 03:18:30 | tzaddik | 1 | 69583 | 3 | 1.156 | 60192.9 |
106 | 2024-04-10 04:07:27 | tzaddik | 2 | 107671 | 5 | 3.780 | 28484.4 |
105 | 2024-04-08 08:27:31 | tzaddik | 1 | 69583 | 3 | 1.203 | 57841.2 |
104 | 2024-04-08 08:27:06 | tzaddik | 3 | 134027 | 20 | 9.330 | 14365.2 |
103 | 2024-04-08 08:27:04 | tzaddik | 2 | 107671 | 5 | 4.000 | 26917.8 |
102 | 2024-04-08 04:22:40 | tzaddik | 4 | 151207 | 321 | 13.720 | 11020.9 |
101 | 2024-04-07 23:23:31 | tzaddik | 1 | 69583 | 3 | 3.970 | 17527.2 |
100 | 2024-04-05 17:31:52 | tzaddik | 4 | 151207 | 321 | 25.643 | 5896.6 |
99 | 2024-04-05 05:13:11 | tzaddik | 4 | 151207 | 321 | 22.876 | 6609.9 |
98 | 2024-04-05 04:54:56 | tzaddik | 4 | 151207 | 321 | 22.920 | 6597.2 |
97 | 2024-04-05 04:54:54 | tzaddik | 3 | 134027 | 20 | 20.173 | 6643.9 |
96 | 2024-04-05 04:55:08 | tzaddik | 1 | 69583 | 3 | 2.563 | 27149.0 |
95 | 2024-04-05 04:54:52 | tzaddik | 2 | 107671 | 5 | 5.456 | 19734.4 |
94 | 2024-04-05 04:54:45 | tzaddik | 1 | 69583 | 3 | 3.250 | 21410.2 |
93 | 2024-03-31 05:54:21 | tzaddik | 1 | 69583 | 3 | 2.720 | 25582.0 |
92 | 2024-03-11 04:47:00 | tzaddik | 1 | 69583 | 3 | 2.720 | 25582.0 |
91 | 2024-03-05 09:08:51 | tzaddik | 4 | 151207 | 321 | 16.050 | 9421.0 |
90 | 2024-03-05 08:44:10 | tzaddik | 4 | 151207 | 321 | 25.673 | 5889.7 |
89 | 2024-03-04 21:14:49 | tzaddik | 3 | 134027 | 20 | 16.986 | 7890.4 |
88 | 2024-03-04 16:24:15 | tzaddik | 4 | 151207 | 321 | 26.360 | 5736.2 |
87 | 2024-03-04 16:24:11 | tzaddik | 3 | 134027 | 20 | 22.220 | 6031.8 |
86 | 2024-03-04 16:00:16 | tzaddik | 1 | 69583 | 3 | 3.986 | 17456.8 |
85 | 2024-03-04 09:41:10 | tzaddik | 4 | 151207 | 321 | 35.236 | 4291.3 |
84 | 2024-03-04 02:38:48 | tzaddik | 2 | 107671 | 5 | 3.360 | 32044.9 |
83 | 2024-03-04 02:38:34 | tzaddik | 3 | 134027 | 20 | 6.970 | 19229.1 |
82 | 2024-03-03 11:07:25 | tzaddik | 4 | 151207 | 321 | 48.580 | 3112.5 |
81 | 2024-03-03 11:07:24 | tzaddik | 3 | 134027 | 20 | 21.220 | 6316.1 |
80 | 2024-03-03 11:07:22 | tzaddik | 2 | 107671 | 5 | 9.486 | 11350.5 |
79 | 2024-03-03 11:07:18 | tzaddik | 1 | 69583 | 3 | 3.563 | 19529.3 |
78 | 2024-01-30 20:45:11 | tzaddik | 1 | 69583 | 3 | 1.233 | 56433.9 |
77 | 2024-01-19 07:57:11 | tzaddik | 1 | 69583 | 3 | 1.033 | 67360.1 |
76 | 2023-12-28 04:01:08 | tzaddik | 1 | 69583 | 3 | 1.030 | 67556.3 |
75 | 2023-12-17 00:38:18 | tzaddik | 1 | 69583 | 3 | 1.046 | 66522.9 |
74 | 2023-10-16 17:08:57 | tzaddik | 1 | 69583 | 3 | 1.076 | 64668.2 |
73 | 2023-09-26 13:09:59 | tzaddik | 1 | 69583 | 3 | 2.250 | 30925.8 |
72 | 2023-08-14 20:35:49 | tzaddik | 1 | 69583 | 3 | 1.046 | 66522.9 |
71 | 2023-05-13 23:14:06 | tzaddik | 1 | 69583 | 3 | 1.033 | 67360.1 |
70 | 2021-07-02 18:40:39 | tzaddik | 1 | 69583 | 3 | 1.190 | 58473.1 |
69 | 2021-06-03 12:07:43 | tzaddik | 1 | 69583 | 3 | 1.126 | 61796.6 |
68 | 2021-01-28 16:14:41 | tzaddik | 1 | 69583 | 3 | 1.186 | 58670.3 |
67 | 2020-10-24 07:45:31 | tzaddik | 1 | 69583 | 3 | 1.173 | 59320.5 |
66 | 2020-10-11 08:03:41 | tzaddik | 1 | 69583 | 3 | 1.140 | 61037.7 |
65 | 2020-03-28 03:47:16 | tzaddik | 1 | 69583 | 3 | 1.250 | 55666.4 |
64 | 2020-03-28 01:04:23 | tzaddik | 1 | 69583 | 3 | 2.563 | 27149.0 |
63 | 2020-02-19 18:55:04 | tzaddik | 1 | 69583 | 3 | 1.266 | 54962.9 |
62 | 2020-02-10 21:09:01 | tzaddik | 1 | 69583 | 3 | 2.376 | 29285.8 |
61 | 2020-02-08 15:32:18 | tzaddik | 1 | 69583 | 3 | 1.860 | 37410.2 |
60 | 2020-01-27 23:47:11 | tzaddik | 1 | 69583 | 3 | 2.156 | 32274.1 |
59 | 2020-01-19 04:03:51 | tzaddik | 1 | 69583 | 3 | 3.423 | 20328.1 |
58 | 2020-01-19 03:16:41 | tzaddik | 1 | 69583 | 3 | 1.200 | 57985.8 |
57 | 2020-01-12 05:42:06 | tzaddik | 1 | 69583 | 3 | 2.533 | 27470.6 |
56 | 2020-01-08 01:16:18 | tzaddik | 1 | 69583 | 3 | 1.220 | 57035.2 |
55 | 2019-11-04 09:50:19 | tzaddik | 1 | 69583 | 3 | 1.186 | 58670.3 |
54 | 2019-07-02 06:25:48 | tzaddik | 1 | 69583 | 3 | 1.033 | 67360.1 |
53 | 2019-02-09 18:20:53 | tzaddik | 1 | 69583 | 3 | 1.006 | 69168.0 |
52 | 2018-09-16 03:29:16 | tzaddik | 1 | 69583 | 3 | 1.113 | 62518.4 |
51 | 2018-09-13 04:11:14 | tzaddik | 1 | 69583 | 3 | 1.170 | 59472.6 |
50 | 2017-10-07 01:03:52 | tzaddik | 1 | 69583 | 3 | 1.430 | 48659.4 |
49 | 2017-04-19 02:07:02 | tzaddik | 1 | 69583 | 3 | 1.406 | 49490.0 |
48 | 2017-03-16 18:34:21 | tzaddik | 1 | 69583 | 3 | 1.766 | 39401.5 |
47 | 2017-01-07 19:57:12 | tzaddik | 1 | 69583 | 3 | 1.360 | 51164.0 |
46 | 2016-08-15 22:03:18 | tzaddik | 4 | 151207 | 321 | 16.783 | 9009.5 |
45 | 2016-08-14 09:59:06 | tzaddik | 3 | 134027 | 20 | 10.793 | 12418.0 |
44 | 2016-07-24 22:20:45 | tzaddik | 2 | 107671 | 5 | 5.536 | 19449.2 |
43 | 2016-07-20 12:36:04 | tzaddik | 1 | 69583 | 3 | 1.733 | 40151.8 |
42 | 2016-06-17 05:18:59 | tzaddik | 1 | 69583 | 3 | 3.333 | 20877.0 |
41 | 2016-06-12 02:22:07 | tzaddik | 1 | 69583 | 3 | 1.763 | 39468.5 |
40 | 2016-05-11 18:03:06 | tzaddik | 1 | 69583 | 3 | 1.113 | 62518.4 |
39 | 2016-04-10 12:04:31 | tzaddik | 1 | 69583 | 3 | 3.406 | 20429.5 |
38 | 2016-03-29 08:23:49 | tzaddik | 1 | 69583 | 3 | 4.833 | 14397.5 |
37 | 2016-03-04 21:12:43 | tzaddik | 1 | 69583 | 3 | 1.130 | 61577.9 |
36 | 2016-02-27 23:48:23 | tzaddik | 1 | 69583 | 3 | 1.226 | 56756.1 |
35 | 2016-02-06 10:36:13 | tzaddik | 3 | 134027 | 20 | 7.366 | 18195.4 |
34 | 2016-02-05 14:51:30 | tzaddik | 2 | 107671 | 5 | 3.160 | 34073.1 |
33 | 2016-02-05 14:47:46 | tzaddik | 2 | 107671 | 5 | 3.326 | 32372.5 |
32 | 2016-01-11 12:12:40 | tzaddik | 1 | 69583 | 3 | 3.553 | 19584.3 |
31 | 2016-01-05 12:11:11 | tzaddik | 1 | 69583 | 3 | 1.196 | 58179.8 |
30 | 2015-12-22 07:50:46 | tzaddik | 1 | 69583 | 3 | 3.780 | 18408.2 |
29 | 2015-11-11 08:28:57 | tzaddik | 1 | 69583 | 3 | 1.193 | 58326.1 |
28 | 2015-09-15 23:51:43 | tzaddik | 1 | 69583 | 3 | 1.240 | 56115.3 |
27 | 2015-07-11 20:47:11 | tzaddik | 4 | 151207 | 321 | 30.006 | 5039.2 |
26 | 2015-07-11 20:47:07 | tzaddik | 3 | 134027 | 20 | 9.273 | 14453.5 |
25 | 2015-07-11 20:47:06 | tzaddik | 2 | 107671 | 5 | 3.450 | 31209.0 |
24 | 2015-07-11 20:42:07 | tzaddik | 1 | 69583 | 3 | 1.376 | 50569.0 |
23 | 2015-06-01 18:42:13 | tzaddik | 1 | 69583 | 3 | 1.400 | 49702.1 |
22 | 2015-05-10 00:08:43 | tzaddik | 2 | 107671 | 5 | 6.966 | 15456.6 |
21 | 2015-04-30 09:56:48 | tzaddik | 3 | 134027 | 20 | 14.430 | 9288.1 |
20 | 2015-04-28 18:33:11 | tzaddik | 4 | 151207 | 321 | 14.190 | 10655.9 |
19 | 2015-04-28 18:32:38 | tzaddik | 2 | 107671 | 5 | 7.093 | 15179.9 |
18 | 2015-04-27 04:48:34 | tzaddik | 3 | 134027 | 20 | 7.940 | 16880.0 |
17 | 2015-03-11 05:27:25 | tzaddik | 1 | 69583 | 3 | 1.993 | 34913.7 |
16 | 2015-03-05 03:46:07 | tzaddik | 3 | 134027 | 20 | 8.216 | 16312.9 |