History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chocolate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
232 | 2024-04-09 14:35:24 | chocolate | 1 | 81242 | 4 | 1.593 | 50999.4 |
231 | 2024-04-08 17:05:38 | chocolate | 1 | 81242 | 4 | 2.126 | 38213.5 |
230 | 2024-04-07 15:48:12 | chocolate | 4 | 165329 | 264 | 31.266 | 5287.8 |
229 | 2024-04-05 08:54:08 | chocolate | 4 | 165329 | 264 | 15.953 | 10363.5 |
228 | 2024-04-05 08:54:10 | chocolate | 2 | 121436 | 6 | 8.610 | 14104.1 |
227 | 2024-04-05 08:50:06 | chocolate | 1 | 81242 | 4 | 1.423 | 57092.1 |
226 | 2024-04-01 01:26:39 | chocolate | 1 | 81242 | 4 | 3.203 | 25364.3 |
225 | 2024-03-15 22:11:54 | chocolate | 2 | 121436 | 6 | 12.686 | 9572.4 |
224 | 2024-03-06 12:49:40 | chocolate | 3 | 148641 | 40 | 20.720 | 7173.8 |
223 | 2024-03-06 10:41:33 | chocolate | 1 | 81242 | 4 | 2.796 | 29056.5 |
222 | 2024-03-06 01:29:55 | chocolate | 3 | 148641 | 40 | 17.203 | 8640.4 |
221 | 2024-03-05 22:12:08 | chocolate | 4 | 165329 | 264 | 36.126 | 4576.5 |
220 | 2024-03-05 18:12:53 | chocolate | 4 | 165329 | 264 | 31.143 | 5308.7 |
219 | 2024-03-05 18:13:00 | chocolate | 3 | 148641 | 40 | 10.766 | 13806.5 |
218 | 2024-03-05 18:12:50 | chocolate | 2 | 121436 | 6 | 12.610 | 9630.1 |
217 | 2024-03-05 16:04:08 | chocolate | 1 | 81242 | 4 | 1.576 | 51549.5 |
216 | 2024-02-21 18:27:40 | chocolate | 3 | 148641 | 40 | 17.546 | 8471.5 |
215 | 2024-02-21 10:13:41 | chocolate | 4 | 165329 | 264 | 31.220 | 5295.6 |
214 | 2024-02-20 08:11:51 | chocolate | 4 | 165329 | 264 | 49.800 | 3319.9 |
213 | 2024-02-20 08:11:50 | chocolate | 2 | 121436 | 6 | 7.593 | 15993.2 |
212 | 2024-02-19 22:11:59 | chocolate | 1 | 81242 | 4 | 5.093 | 15951.7 |
211 | 2024-02-19 11:56:30 | chocolate | 3 | 148641 | 40 | 15.736 | 9445.9 |
210 | 2024-02-16 09:49:18 | chocolate | 3 | 148641 | 40 | 7.063 | 21045.0 |
209 | 2024-02-13 09:09:06 | chocolate | 3 | 148641 | 40 | 12.236 | 12147.8 |
208 | 2024-01-31 20:23:16 | chocolate | 1 | 81242 | 4 | 1.360 | 59736.8 |
207 | 2024-01-31 20:01:24 | chocolate | 1 | 81242 | 4 | 1.423 | 57092.1 |
206 | 2024-01-29 21:58:59 | chocolate | 1 | 81242 | 4 | 1.423 | 57092.1 |
205 | 2023-12-28 03:02:33 | chocolate | 1 | 81242 | 4 | 1.376 | 59042.2 |
204 | 2023-12-23 20:39:14 | chocolate | 1 | 81242 | 4 | 1.466 | 55417.5 |
203 | 2023-11-25 21:17:25 | chocolate | 1 | 81242 | 4 | 1.406 | 57782.4 |
202 | 2023-11-22 09:23:16 | chocolate | 1 | 81242 | 4 | 1.360 | 59736.8 |
201 | 2023-10-10 20:43:12 | chocolate | 1 | 81242 | 4 | 1.390 | 58447.5 |
200 | 2023-08-07 16:19:49 | chocolate | 1 | 81242 | 4 | 1.436 | 56575.2 |
199 | 2023-07-29 15:35:23 | chocolate | 1 | 81242 | 4 | 1.360 | 59736.8 |
198 | 2023-05-07 16:18:58 | chocolate | 1 | 81242 | 4 | 1.203 | 67532.8 |
197 | 2023-04-10 08:39:24 | chocolate | 1 | 81242 | 4 | 1.236 | 65729.8 |
196 | 2023-03-02 21:27:55 | chocolate | 1 | 81242 | 4 | 1.203 | 67532.8 |
195 | 2022-12-27 02:32:58 | chocolate | 1 | 81242 | 4 | 1.376 | 59042.2 |
194 | 2022-12-17 21:12:41 | chocolate | 1 | 81242 | 4 | 1.296 | 62686.7 |
193 | 2022-09-14 21:56:58 | chocolate | 1 | 81242 | 4 | 1.313 | 61875.1 |
192 | 2022-08-11 06:53:06 | chocolate | 1 | 81242 | 4 | 1.313 | 61875.1 |
191 | 2022-07-19 19:20:50 | chocolate | 1 | 81242 | 4 | 1.216 | 66810.9 |
190 | 2022-07-17 12:32:50 | chocolate | 1 | 81242 | 4 | 1.330 | 61084.2 |
189 | 2022-04-10 05:06:41 | chocolate | 1 | 81242 | 4 | 1.280 | 63470.3 |
188 | 2022-03-10 18:14:23 | chocolate | 1 | 81242 | 4 | 1.423 | 57092.1 |
187 | 2021-12-27 12:16:23 | chocolate | 1 | 81242 | 4 | 1.280 | 63470.3 |
186 | 2021-12-25 08:11:45 | chocolate | 1 | 81242 | 4 | 1.453 | 55913.3 |
185 | 2021-12-19 15:10:12 | chocolate | 1 | 81242 | 4 | 1.486 | 54671.6 |
184 | 2021-11-11 12:22:44 | chocolate | 1 | 81242 | 4 | 1.376 | 59042.2 |
183 | 2021-10-11 18:02:00 | chocolate | 1 | 81242 | 4 | 1.376 | 59042.2 |
182 | 2021-08-31 23:50:21 | chocolate | 1 | 81242 | 4 | 1.373 | 59171.2 |
181 | 2021-08-30 07:36:10 | chocolate | 1 | 81242 | 4 | 2.673 | 30393.6 |
180 | 2021-08-27 00:39:30 | chocolate | 1 | 81242 | 4 | 1.216 | 66810.9 |
179 | 2021-08-14 13:06:26 | chocolate | 1 | 81242 | 4 | 1.390 | 58447.5 |
178 | 2021-05-19 14:23:33 | chocolate | 1 | 81242 | 4 | 1.250 | 64993.6 |
177 | 2021-04-30 10:33:13 | chocolate | 1 | 81242 | 4 | 1.420 | 57212.7 |
176 | 2021-03-24 07:07:54 | chocolate | 1 | 81242 | 4 | 1.266 | 64172.2 |
175 | 2021-02-16 17:08:13 | chocolate | 1 | 81242 | 4 | 1.233 | 65889.7 |
174 | 2021-02-02 15:56:33 | chocolate | 1 | 81242 | 4 | 2.500 | 32496.8 |
173 | 2021-01-06 22:12:42 | chocolate | 1 | 81242 | 4 | 1.233 | 65889.7 |
172 | 2020-11-12 10:52:23 | chocolate | 1 | 81242 | 4 | 1.236 | 65729.8 |
171 | 2020-11-01 00:58:59 | chocolate | 1 | 81242 | 4 | 1.296 | 62686.7 |
170 | 2020-10-29 07:43:03 | chocolate | 1 | 81242 | 4 | 1.390 | 58447.5 |
169 | 2020-10-20 08:35:05 | chocolate | 1 | 81242 | 4 | 1.436 | 56575.2 |
168 | 2020-08-11 20:14:41 | chocolate | 1 | 81242 | 4 | 1.313 | 61875.1 |
167 | 2020-05-10 15:40:42 | chocolate | 1 | 81242 | 4 | 1.250 | 64993.6 |
166 | 2020-03-30 07:55:22 | chocolate | 1 | 81242 | 4 | 1.233 | 65889.7 |
165 | 2020-03-26 16:14:40 | chocolate | 1 | 81242 | 4 | 1.513 | 53696.0 |
164 | 2020-03-23 02:03:02 | chocolate | 1 | 81242 | 4 | 1.423 | 57092.1 |
163 | 2020-02-25 23:16:06 | chocolate | 1 | 81242 | 4 | 2.390 | 33992.5 |
162 | 2020-02-20 09:56:23 | chocolate | 1 | 81242 | 4 | 3.813 | 21306.6 |
161 | 2020-02-06 10:13:50 | chocolate | 1 | 81242 | 4 | 2.236 | 36333.6 |
160 | 2020-02-05 03:20:33 | chocolate | 1 | 81242 | 4 | 1.576 | 51549.5 |
159 | 2020-02-04 20:23:19 | chocolate | 1 | 81242 | 4 | 1.560 | 52078.2 |
158 | 2020-01-27 21:00:50 | chocolate | 1 | 81242 | 4 | 3.080 | 26377.3 |
157 | 2020-01-26 13:04:47 | chocolate | 1 | 81242 | 4 | 1.720 | 47233.7 |
156 | 2020-01-25 16:37:20 | chocolate | 1 | 81242 | 4 | 4.483 | 18122.2 |
155 | 2020-01-19 07:33:04 | chocolate | 1 | 81242 | 4 | 1.563 | 51978.2 |
154 | 2020-01-14 14:02:32 | chocolate | 1 | 81242 | 4 | 3.190 | 25467.7 |
153 | 2020-01-14 13:04:07 | chocolate | 1 | 81242 | 4 | 1.360 | 59736.8 |
152 | 2020-01-03 19:17:29 | chocolate | 1 | 81242 | 4 | 1.296 | 62686.7 |
151 | 2020-01-01 22:03:11 | chocolate | 1 | 81242 | 4 | 1.610 | 50460.9 |
150 | 2019-12-27 23:15:11 | chocolate | 1 | 81242 | 4 | 3.110 | 26122.8 |
149 | 2019-11-04 10:22:12 | chocolate | 1 | 81242 | 4 | 1.390 | 58447.5 |
148 | 2019-09-12 01:37:23 | chocolate | 1 | 81242 | 4 | 1.276 | 63669.3 |
147 | 2019-08-03 06:36:00 | chocolate | 1 | 81242 | 4 | 1.373 | 59171.2 |
146 | 2019-06-24 20:47:45 | chocolate | 1 | 81242 | 4 | 1.266 | 64172.2 |
145 | 2019-06-18 06:39:52 | chocolate | 1 | 81242 | 4 | 1.233 | 65889.7 |
144 | 2019-04-30 04:24:19 | chocolate | 1 | 81242 | 4 | 1.270 | 63970.1 |
143 | 2019-03-18 11:33:38 | chocolate | 1 | 81242 | 4 | 1.270 | 63970.1 |
142 | 2019-03-08 13:57:59 | chocolate | 1 | 81242 | 4 | 1.276 | 63669.3 |
141 | 2019-03-04 08:42:19 | chocolate | 1 | 81242 | 4 | 1.310 | 62016.8 |
140 | 2019-01-12 00:05:18 | chocolate | 1 | 81242 | 4 | 1.366 | 59474.4 |
139 | 2018-09-16 03:58:33 | chocolate | 1 | 81242 | 4 | 1.526 | 53238.5 |
138 | 2018-09-13 04:43:23 | chocolate | 1 | 81242 | 4 | 1.323 | 61407.4 |
137 | 2018-06-27 09:26:11 | chocolate | 1 | 81242 | 4 | 1.263 | 64324.6 |
136 | 2018-06-25 09:15:40 | chocolate | 1 | 81242 | 4 | 1.206 | 67364.8 |
135 | 2018-06-25 07:29:10 | chocolate | 1 | 81242 | 4 | 1.510 | 53802.6 |
134 | 2018-06-24 15:00:09 | chocolate | 1 | 81242 | 4 | 1.866 | 43538.0 |
133 | 2018-06-14 00:15:28 | chocolate | 1 | 81242 | 4 | 1.430 | 56812.6 |