History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"abracadabra"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
249 | 2024-04-27 09:05:10 | abracadabra | 4 | 148819 | 3 | 15.016 | 9910.7 |
248 | 2024-04-12 13:09:21 | abracadabra | 5 | 164607 | 13 | 51.813 | 3176.9 |
247 | 2024-04-07 18:38:40 | abracadabra | 4 | 148819 | 3 | 13.876 | 10724.9 |
246 | 2024-04-05 13:56:57 | abracadabra | 4 | 148819 | 3 | 31.550 | 4716.9 |
245 | 2024-04-05 13:56:57 | abracadabra | 3 | 121633 | 2 | 13.750 | 8846.0 |
244 | 2024-04-05 13:56:59 | abracadabra | 2 | 86808 | 2 | 2.780 | 31225.9 |
243 | 2024-04-05 13:54:58 | abracadabra | 1 | 49908 | 2 | 2.356 | 21183.4 |
242 | 2024-04-03 12:25:00 | abracadabra | 4 | 148819 | 3 | 30.330 | 4906.7 |
241 | 2024-04-03 11:19:31 | abracadabra | 5 | 164607 | 13 | 37.330 | 4409.5 |
240 | 2024-04-03 11:19:32 | abracadabra | 4 | 148819 | 3 | 34.593 | 4302.0 |
239 | 2024-04-03 11:19:30 | abracadabra | 5 | 164607 | 13 | 24.236 | 6791.8 |
238 | 2024-04-03 11:19:32 | abracadabra | 3 | 121633 | 2 | 17.843 | 6816.8 |
237 | 2024-04-03 11:19:33 | abracadabra | 2 | 86808 | 2 | 2.860 | 30352.4 |
236 | 2024-04-03 11:18:25 | abracadabra | 6 | 173545 | 184 | 53.300 | 3256.0 |
235 | 2024-04-03 11:18:26 | abracadabra | 5 | 164607 | 13 | 47.613 | 3457.2 |
234 | 2024-04-03 11:18:30 | abracadabra | 4 | 148819 | 3 | 24.346 | 6112.7 |
233 | 2024-04-03 11:18:35 | abracadabra | 3 | 121633 | 2 | 19.423 | 6262.3 |
232 | 2024-04-03 11:18:44 | abracadabra | 2 | 86808 | 2 | 7.203 | 12051.6 |
231 | 2024-04-03 11:16:10 | abracadabra | 1 | 49908 | 2 | 2.593 | 19247.2 |
230 | 2024-04-03 11:16:00 | abracadabra | 1 | 49908 | 2 | 2.703 | 18463.9 |
229 | 2024-04-02 03:08:13 | abracadabra | 5 | 164607 | 13 | 13.016 | 12646.5 |
228 | 2024-04-02 03:01:47 | abracadabra | 5 | 164607 | 13 | 14.780 | 11137.1 |
227 | 2024-03-28 14:59:41 | abracadabra | 1 | 49908 | 2 | 0.890 | 56076.4 |
226 | 2024-02-19 05:04:26 | abracadabra | 5 | 164607 | 13 | 36.753 | 4478.7 |
225 | 2024-02-14 12:24:05 | abracadabra | 5 | 164607 | 13 | 27.503 | 5985.1 |
224 | 2024-02-13 14:51:28 | abracadabra | 4 | 148819 | 3 | 20.983 | 7092.4 |
223 | 2024-02-13 12:33:10 | abracadabra | 5 | 164607 | 13 | 51.736 | 3181.7 |
222 | 2024-02-13 12:33:13 | abracadabra | 3 | 121633 | 2 | 7.733 | 15729.1 |
221 | 2024-02-13 12:33:10 | abracadabra | 2 | 86808 | 2 | 3.156 | 27505.7 |
220 | 2024-02-13 09:47:31 | abracadabra | 1 | 49908 | 2 | 0.843 | 59202.8 |
219 | 2024-02-10 10:28:28 | abracadabra | 4 | 148819 | 3 | 30.800 | 4831.8 |
218 | 2024-02-10 10:28:32 | abracadabra | 3 | 121633 | 2 | 10.326 | 11779.3 |
217 | 2024-02-10 10:28:26 | abracadabra | 2 | 86808 | 2 | 5.610 | 15473.8 |
216 | 2024-02-10 10:19:31 | abracadabra | 6 | 173545 | 184 | 47.723 | 3636.5 |
215 | 2024-02-10 09:45:35 | abracadabra | 1 | 49908 | 2 | 0.810 | 61614.8 |
214 | 2024-02-08 22:44:22 | abracadabra | 5 | 164607 | 13 | 24.110 | 6827.3 |
213 | 2024-02-08 22:44:31 | abracadabra | 1 | 49908 | 2 | 1.860 | 26832.3 |
212 | 2024-02-08 22:44:22 | abracadabra | 3 | 121633 | 2 | 6.250 | 19461.3 |
211 | 2024-02-08 22:44:20 | abracadabra | 1 | 49908 | 2 | 1.843 | 27079.8 |
210 | 2024-01-19 22:29:15 | abracadabra | 1 | 49908 | 2 | 1.500 | 33272.0 |
209 | 2024-01-19 09:05:49 | abracadabra | 3 | 121633 | 2 | 4.373 | 27814.5 |
208 | 2024-01-12 10:24:13 | abracadabra | 4 | 148819 | 3 | 8.436 | 17640.9 |
207 | 2024-01-02 04:57:58 | abracadabra | 1 | 49908 | 2 | 0.750 | 66544.0 |
206 | 2023-12-07 00:03:05 | abracadabra | 6 | 173545 | 184 | 20.423 | 8497.5 |
205 | 2023-11-25 15:16:13 | abracadabra | 1 | 49908 | 2 | 0.796 | 62698.5 |
204 | 2023-11-15 19:42:56 | abracadabra | 5 | 164607 | 13 | 17.376 | 9473.2 |
203 | 2023-10-30 23:37:21 | abracadabra | 1 | 49908 | 2 | 0.780 | 63984.6 |
202 | 2023-10-29 23:21:44 | abracadabra | 3 | 121633 | 2 | 4.390 | 27706.8 |
201 | 2023-10-24 03:09:09 | abracadabra | 1 | 49908 | 2 | 0.830 | 60130.1 |
200 | 2023-10-20 13:16:11 | abracadabra | 4 | 148819 | 3 | 8.000 | 18602.4 |
199 | 2023-09-25 04:23:47 | abracadabra | 1 | 49908 | 2 | 0.783 | 63739.5 |
198 | 2023-09-05 07:16:41 | abracadabra | 6 | 173545 | 184 | 21.343 | 8131.2 |
197 | 2023-08-21 21:15:49 | abracadabra | 1 | 49908 | 2 | 0.890 | 56076.4 |
196 | 2023-08-16 23:55:12 | abracadabra | 5 | 164607 | 13 | 13.016 | 12646.5 |
195 | 2023-08-07 01:15:15 | abracadabra | 3 | 121633 | 2 | 4.546 | 26756.0 |
194 | 2023-08-02 08:46:32 | abracadabra | 4 | 148819 | 3 | 8.000 | 18602.4 |
193 | 2023-05-23 07:55:22 | abracadabra | 1 | 49908 | 2 | 0.733 | 68087.3 |
192 | 2023-04-28 04:13:50 | abracadabra | 5 | 164607 | 13 | 12.360 | 13317.7 |
191 | 2023-04-19 21:50:44 | abracadabra | 3 | 121633 | 2 | 4.356 | 27923.1 |
190 | 2023-04-10 03:11:53 | abracadabra | 4 | 148819 | 3 | 8.936 | 16653.9 |
189 | 2023-03-20 16:36:52 | abracadabra | 1 | 49908 | 2 | 1.610 | 30998.8 |
188 | 2023-02-24 00:16:02 | abracadabra | 6 | 173545 | 184 | 18.186 | 9542.8 |
187 | 2023-02-04 11:52:10 | abracadabra | 5 | 164607 | 13 | 12.706 | 12955.1 |
186 | 2023-01-22 11:38:34 | abracadabra | 3 | 121633 | 2 | 4.623 | 26310.4 |
185 | 2023-01-14 03:58:53 | abracadabra | 4 | 148819 | 3 | 7.796 | 19089.1 |
184 | 2023-01-07 10:44:08 | abracadabra | 1 | 49908 | 2 | 0.720 | 69316.7 |
183 | 2022-12-02 21:51:47 | abracadabra | 6 | 173545 | 184 | 19.300 | 8992.0 |
182 | 2022-11-17 04:07:20 | abracadabra | 5 | 164607 | 13 | 14.783 | 11134.9 |
181 | 2022-11-02 04:19:00 | abracadabra | 3 | 121633 | 2 | 4.233 | 28734.5 |
180 | 2022-10-20 19:02:39 | abracadabra | 4 | 148819 | 3 | 7.813 | 19047.6 |
179 | 2022-10-06 22:17:26 | abracadabra | 1 | 49908 | 2 | 0.720 | 69316.7 |
178 | 2022-07-11 11:24:18 | abracadabra | 6 | 173545 | 184 | 18.610 | 9325.4 |
177 | 2022-06-19 23:38:27 | abracadabra | 5 | 164607 | 13 | 12.686 | 12975.5 |
176 | 2022-05-29 03:52:52 | abracadabra | 1 | 49908 | 2 | 0.720 | 69316.7 |
175 | 2022-05-26 22:02:52 | abracadabra | 1 | 49908 | 2 | 0.940 | 53093.6 |
174 | 2022-05-24 16:43:47 | abracadabra | 1 | 49908 | 2 | 0.813 | 61387.5 |
173 | 2022-05-22 03:10:30 | abracadabra | 4 | 148819 | 3 | 9.173 | 16223.6 |
172 | 2022-05-10 22:37:52 | abracadabra | 3 | 121633 | 2 | 6.156 | 19758.4 |
171 | 2022-05-08 18:08:42 | abracadabra | 3 | 121633 | 2 | 4.420 | 27518.8 |
170 | 2022-02-20 07:35:31 | abracadabra | 6 | 173545 | 184 | 19.766 | 8780.0 |
169 | 2022-02-18 03:57:49 | abracadabra | 6 | 173545 | 184 | 19.893 | 8723.9 |
168 | 2022-02-06 01:07:31 | abracadabra | 1 | 49908 | 2 | 0.733 | 68087.3 |
167 | 2022-01-30 04:47:13 | abracadabra | 4 | 148819 | 3 | 7.876 | 18895.3 |
166 | 2022-01-21 05:49:18 | abracadabra | 3 | 121633 | 2 | 4.720 | 25769.7 |
165 | 2022-01-12 23:57:00 | abracadabra | 6 | 173545 | 184 | 25.253 | 6872.3 |
164 | 2021-12-09 13:48:28 | abracadabra | 6 | 173545 | 184 | 26.720 | 6494.9 |
163 | 2021-12-01 23:31:50 | abracadabra | 1 | 49908 | 2 | 0.830 | 60130.1 |
162 | 2021-11-14 13:24:03 | abracadabra | 6 | 173545 | 184 | 24.203 | 7170.4 |
161 | 2021-10-09 09:03:54 | abracadabra | 1 | 49908 | 2 | 0.736 | 67809.8 |
160 | 2021-10-05 05:52:27 | abracadabra | 6 | 173545 | 184 | 21.373 | 8119.8 |
159 | 2021-09-15 05:13:34 | abracadabra | 6 | 173545 | 184 | 21.016 | 8257.8 |
158 | 2021-08-31 15:43:02 | abracadabra | 1 | 49908 | 2 | 0.733 | 68087.3 |
157 | 2021-08-18 14:36:49 | abracadabra | 1 | 49908 | 2 | 0.733 | 68087.3 |
156 | 2021-08-16 10:00:03 | abracadabra | 1 | 49908 | 2 | 0.813 | 61387.5 |
155 | 2021-08-15 13:09:27 | abracadabra | 6 | 173545 | 184 | 18.346 | 9459.6 |
154 | 2021-08-11 03:00:06 | abracadabra | 6 | 173545 | 184 | 20.093 | 8637.1 |
153 | 2020-12-22 20:35:42 | abracadabra | 1 | 49908 | 2 | 0.810 | 61614.8 |
152 | 2020-11-20 00:54:55 | abracadabra | 1 | 49908 | 2 | 0.720 | 69316.7 |
151 | 2020-01-25 00:05:50 | abracadabra | 1 | 49908 | 2 | 0.810 | 61614.8 |
150 | 2018-04-18 15:39:34 | abracadabra | 6 | 173545 | 184 | 19.643 | 8835.0 |