History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"faithful"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
217 | 2024-05-03 21:44:30 | faithful | 1 | 82945 | 2 | 4.763 | 17414.4 |
216 | 2024-05-03 20:55:07 | faithful | 2 | 121059 | 7 | 4.283 | 28265.0 |
215 | 2024-04-29 16:21:03 | faithful | 2 | 121059 | 7 | 3.623 | 33414.0 |
214 | 2024-04-28 19:47:12 | faithful | 3 | 146162 | 53 | 10.673 | 13694.6 |
213 | 2024-04-26 12:28:30 | faithful | 1 | 82945 | 2 | 4.483 | 18502.1 |
212 | 2024-04-26 08:01:41 | faithful | 3 | 146162 | 53 | 15.720 | 9297.8 |
211 | 2024-04-26 08:01:33 | faithful | 2 | 121059 | 7 | 5.640 | 21464.4 |
210 | 2024-04-10 23:41:48 | faithful | 3 | 146162 | 53 | 17.126 | 8534.5 |
209 | 2024-04-10 04:06:35 | faithful | 4 | 161609 | 208 | 13.876 | 11646.7 |
208 | 2024-04-10 04:06:33 | faithful | 3 | 146162 | 53 | 8.016 | 18233.8 |
207 | 2024-04-08 10:15:40 | faithful | 4 | 161609 | 208 | 39.486 | 4092.8 |
206 | 2024-04-08 09:58:21 | faithful | 3 | 146162 | 53 | 17.703 | 8256.3 |
205 | 2024-04-08 02:43:16 | faithful | 4 | 161609 | 208 | 26.970 | 5992.2 |
204 | 2024-04-07 06:40:48 | faithful | 1 | 82945 | 2 | 1.653 | 50178.5 |
203 | 2024-04-07 06:39:48 | faithful | 4 | 161609 | 208 | 41.393 | 3904.3 |
202 | 2024-04-06 20:56:51 | faithful | 4 | 161609 | 208 | 49.330 | 3276.1 |
201 | 2024-04-06 20:57:12 | faithful | 4 | 161609 | 208 | 25.063 | 6448.1 |
200 | 2024-04-06 20:56:34 | faithful | 3 | 146162 | 53 | 17.623 | 8293.8 |
199 | 2024-04-06 20:56:42 | faithful | 1 | 82945 | 2 | 3.610 | 22976.5 |
198 | 2024-04-06 20:56:35 | faithful | 2 | 121059 | 7 | 4.250 | 28484.5 |
197 | 2024-04-01 07:26:35 | faithful | 1 | 82945 | 2 | 4.783 | 17341.6 |
196 | 2024-03-30 03:38:11 | faithful | 2 | 121059 | 7 | 11.173 | 10835.0 |
195 | 2024-03-30 03:17:53 | faithful | 1 | 82945 | 2 | 3.000 | 27648.3 |
194 | 2024-03-26 04:11:19 | faithful | 1 | 82945 | 2 | 5.013 | 16546.0 |
193 | 2024-03-26 03:52:34 | faithful | 2 | 121059 | 7 | 5.703 | 21227.2 |
192 | 2024-03-26 03:16:09 | faithful | 3 | 146162 | 53 | 7.546 | 19369.5 |
191 | 2024-03-18 09:23:07 | faithful | 3 | 146162 | 53 | 8.253 | 17710.2 |
190 | 2024-03-18 09:23:08 | faithful | 2 | 121059 | 7 | 6.470 | 18710.8 |
189 | 2024-03-11 03:40:42 | faithful | 2 | 121059 | 7 | 3.813 | 31749.0 |
188 | 2024-03-11 02:15:12 | faithful | 3 | 146162 | 53 | 20.220 | 7228.6 |
187 | 2024-03-11 02:14:23 | faithful | 1 | 82945 | 2 | 4.986 | 16635.6 |
186 | 2024-03-11 00:11:14 | faithful | 4 | 161609 | 208 | 14.876 | 10863.7 |
185 | 2024-03-10 20:23:16 | faithful | 1 | 82945 | 2 | 1.546 | 53651.4 |
184 | 2024-03-07 20:18:21 | faithful | 3 | 146162 | 53 | 8.753 | 16698.5 |
183 | 2024-03-05 14:56:00 | faithful | 3 | 146162 | 53 | 8.296 | 17618.4 |
182 | 2024-03-05 14:55:21 | faithful | 2 | 121059 | 7 | 5.360 | 22585.6 |
181 | 2024-03-04 02:42:39 | faithful | 4 | 161609 | 208 | 13.093 | 12343.2 |
180 | 2024-03-01 21:42:16 | faithful | 4 | 161609 | 208 | 17.236 | 9376.2 |
179 | 2024-02-28 09:11:17 | faithful | 2 | 121059 | 7 | 9.533 | 12698.9 |
178 | 2024-02-28 08:08:06 | faithful | 1 | 82945 | 2 | 1.640 | 50576.2 |
177 | 2024-02-27 12:35:24 | faithful | 4 | 161609 | 208 | 17.876 | 9040.6 |
176 | 2024-02-26 23:32:57 | faithful | 4 | 161609 | 208 | 12.423 | 13008.9 |
175 | 2024-02-23 04:19:53 | faithful | 1 | 82945 | 2 | 1.466 | 56579.1 |
174 | 2024-02-09 19:00:57 | faithful | 1 | 82945 | 2 | 1.533 | 54106.3 |
173 | 2024-02-09 19:00:42 | faithful | 4 | 161609 | 208 | 13.816 | 11697.2 |
172 | 2024-02-09 19:00:40 | faithful | 2 | 121059 | 7 | 7.360 | 16448.2 |
171 | 2024-02-09 19:00:11 | faithful | 3 | 146162 | 53 | 9.050 | 16150.5 |
170 | 2024-02-05 18:34:30 | faithful | 3 | 146162 | 53 | 6.406 | 22816.4 |
169 | 2024-02-05 18:34:26 | faithful | 2 | 121059 | 7 | 3.783 | 32000.8 |
168 | 2024-01-25 22:51:20 | faithful | 2 | 121059 | 7 | 3.766 | 32145.2 |
167 | 2024-01-25 22:50:55 | faithful | 3 | 146162 | 53 | 7.860 | 18595.7 |
166 | 2024-01-24 16:04:08 | faithful | 3 | 146162 | 53 | 6.313 | 23152.5 |
165 | 2024-01-23 12:54:13 | faithful | 1 | 82945 | 2 | 2.173 | 38170.7 |
164 | 2024-01-23 10:14:46 | faithful | 4 | 161609 | 208 | 42.846 | 3771.9 |
163 | 2024-01-23 04:50:32 | faithful | 2 | 121059 | 7 | 7.546 | 16042.8 |
162 | 2024-01-20 18:47:39 | faithful | 1 | 82945 | 2 | 1.470 | 56425.2 |
161 | 2024-01-17 20:31:43 | faithful | 1 | 82945 | 2 | 1.300 | 63803.8 |
160 | 2024-01-16 16:34:25 | faithful | 2 | 121059 | 7 | 3.203 | 37795.5 |
159 | 2024-01-13 10:15:38 | faithful | 3 | 146162 | 53 | 8.906 | 16411.6 |
158 | 2023-11-25 04:22:40 | faithful | 4 | 161609 | 208 | 12.296 | 13143.2 |
157 | 2023-11-11 21:40:18 | faithful | 1 | 82945 | 2 | 1.343 | 61761.0 |
156 | 2023-11-04 05:05:39 | faithful | 3 | 146162 | 53 | 6.250 | 23385.9 |
155 | 2023-10-29 04:32:57 | faithful | 2 | 121059 | 7 | 3.703 | 32692.1 |
154 | 2023-10-07 11:02:46 | faithful | 1 | 82945 | 2 | 1.390 | 59672.7 |
153 | 2023-09-29 14:41:32 | faithful | 1 | 82945 | 2 | 1.406 | 58993.6 |
152 | 2023-09-11 08:41:17 | faithful | 4 | 161609 | 208 | 15.516 | 10415.6 |
151 | 2023-09-01 06:23:26 | faithful | 1 | 82945 | 2 | 1.390 | 59672.7 |
150 | 2023-08-25 04:56:24 | faithful | 4 | 161609 | 208 | 10.486 | 15411.9 |
149 | 2023-08-09 17:56:04 | faithful | 3 | 146162 | 53 | 6.796 | 21507.1 |
148 | 2023-08-07 00:19:40 | faithful | 2 | 121059 | 7 | 3.173 | 38152.9 |
147 | 2023-06-05 22:43:39 | faithful | 1 | 82945 | 2 | 1.250 | 66356.0 |
146 | 2023-05-28 14:07:52 | faithful | 1 | 82945 | 2 | 1.453 | 57085.3 |
145 | 2023-05-10 12:41:59 | faithful | 4 | 161609 | 208 | 10.390 | 15554.3 |
144 | 2023-04-20 21:10:13 | faithful | 3 | 146162 | 53 | 6.830 | 21400.0 |
143 | 2023-04-17 14:55:30 | faithful | 2 | 121059 | 7 | 3.140 | 38553.8 |
142 | 2023-03-28 01:25:36 | faithful | 1 | 82945 | 2 | 1.376 | 60279.8 |
141 | 2023-02-17 18:36:13 | faithful | 4 | 161609 | 208 | 15.296 | 10565.4 |
140 | 2023-01-26 13:10:13 | faithful | 3 | 146162 | 53 | 7.173 | 20376.7 |
139 | 2023-01-22 15:31:06 | faithful | 2 | 121059 | 7 | 3.110 | 38925.7 |
138 | 2023-01-22 01:16:24 | faithful | 1 | 82945 | 2 | 1.390 | 59672.7 |
137 | 2023-01-12 15:29:30 | faithful | 1 | 82945 | 2 | 1.376 | 60279.8 |
136 | 2022-11-29 10:39:53 | faithful | 4 | 161609 | 208 | 10.453 | 15460.5 |
135 | 2022-11-09 00:04:37 | faithful | 3 | 146162 | 53 | 6.250 | 23385.9 |
134 | 2022-11-03 21:52:48 | faithful | 2 | 121059 | 7 | 3.173 | 38152.9 |
133 | 2022-10-25 09:49:40 | faithful | 1 | 82945 | 2 | 1.516 | 54713.1 |
132 | 2022-09-16 04:10:00 | faithful | 1 | 82945 | 2 | 1.453 | 57085.3 |
131 | 2022-07-06 12:36:46 | faithful | 4 | 161609 | 208 | 10.483 | 15416.3 |
130 | 2022-06-16 08:59:54 | faithful | 1 | 82945 | 2 | 1.326 | 62552.8 |
129 | 2022-06-05 10:51:01 | faithful | 2 | 121059 | 7 | 3.576 | 33853.2 |
128 | 2022-05-17 01:40:21 | faithful | 3 | 146162 | 53 | 6.626 | 22058.9 |
127 | 2022-05-14 20:57:44 | faithful | 3 | 146162 | 53 | 6.266 | 23326.2 |
126 | 2022-04-22 09:05:27 | faithful | 1 | 82945 | 2 | 2.013 | 41204.7 |
125 | 2022-02-17 08:44:23 | faithful | 1 | 82945 | 2 | 1.326 | 62552.8 |
124 | 2022-01-05 19:50:35 | faithful | 3 | 146162 | 53 | 7.310 | 19994.8 |
123 | 2021-12-19 05:40:39 | faithful | 1 | 82945 | 2 | 2.893 | 28670.9 |
122 | 2021-12-18 00:51:26 | faithful | 1 | 82945 | 2 | 1.453 | 57085.3 |
121 | 2021-10-21 01:55:38 | faithful | 1 | 82945 | 2 | 1.343 | 61761.0 |
120 | 2021-09-09 06:43:15 | faithful | 1 | 82945 | 2 | 1.360 | 60989.0 |
119 | 2021-08-22 04:08:17 | faithful | 1 | 82945 | 2 | 1.406 | 58993.6 |
118 | 2021-08-02 11:37:39 | faithful | 1 | 82945 | 2 | 1.440 | 57600.7 |