History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"alfalfas"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
265 | 2024-05-02 02:47:21 | alfalfas | 1 | 82945 | 2 | 1.610 | 51518.6 |
264 | 2024-04-30 13:44:26 | alfalfas | 4 | 161609 | 278 | 14.503 | 11143.1 |
263 | 2024-04-25 05:01:36 | alfalfas | 3 | 146162 | 16 | 17.753 | 8233.1 |
262 | 2024-04-25 05:01:33 | alfalfas | 2 | 121059 | 2 | 5.576 | 21710.7 |
261 | 2024-04-25 05:01:23 | alfalfas | 1 | 82945 | 2 | 1.873 | 44284.6 |
260 | 2024-04-16 15:58:50 | alfalfas | 3 | 146162 | 16 | 24.003 | 6089.3 |
259 | 2024-04-16 15:58:48 | alfalfas | 2 | 121059 | 2 | 7.470 | 16206.0 |
258 | 2024-04-16 15:58:48 | alfalfas | 1 | 82945 | 2 | 3.203 | 25896.0 |
257 | 2024-04-16 04:45:51 | alfalfas | 4 | 161609 | 278 | 12.220 | 13225.0 |
256 | 2024-04-15 08:04:58 | alfalfas | 3 | 146162 | 16 | 14.643 | 9981.7 |
255 | 2024-04-15 08:04:59 | alfalfas | 2 | 121059 | 2 | 8.483 | 14270.8 |
254 | 2024-04-15 08:04:44 | alfalfas | 1 | 82945 | 2 | 6.640 | 12491.7 |
253 | 2024-04-13 15:32:39 | alfalfas | 1 | 82945 | 2 | 1.376 | 60279.8 |
252 | 2024-04-13 04:56:05 | alfalfas | 4 | 161609 | 278 | 12.656 | 12769.4 |
251 | 2024-04-12 18:39:45 | alfalfas | 4 | 161609 | 278 | 12.470 | 12959.8 |
250 | 2024-04-12 17:50:40 | alfalfas | 4 | 161609 | 278 | 14.156 | 11416.3 |
249 | 2024-04-11 10:41:16 | alfalfas | 4 | 161609 | 278 | 13.360 | 12096.5 |
248 | 2024-04-11 10:41:17 | alfalfas | 3 | 146162 | 16 | 7.936 | 18417.6 |
247 | 2024-04-11 10:41:18 | alfalfas | 2 | 121059 | 2 | 4.050 | 29891.1 |
246 | 2024-04-11 10:41:14 | alfalfas | 1 | 82945 | 2 | 1.406 | 58993.6 |
245 | 2024-04-08 16:07:07 | alfalfas | 1 | 82945 | 2 | 2.173 | 38170.7 |
244 | 2024-03-26 02:10:54 | alfalfas | 2 | 121059 | 2 | 4.016 | 30144.2 |
243 | 2024-03-14 10:28:50 | alfalfas | 2 | 121059 | 2 | 7.580 | 15970.8 |
242 | 2024-03-14 10:28:32 | alfalfas | 1 | 82945 | 2 | 3.186 | 26034.2 |
241 | 2024-03-14 10:28:02 | alfalfas | 3 | 146162 | 16 | 11.063 | 13211.8 |
240 | 2024-03-12 05:46:17 | alfalfas | 3 | 146162 | 16 | 10.813 | 13517.2 |
239 | 2024-03-12 05:46:16 | alfalfas | 2 | 121059 | 2 | 7.873 | 15376.5 |
238 | 2024-03-12 05:46:10 | alfalfas | 1 | 82945 | 2 | 1.563 | 53067.8 |
237 | 2024-03-06 23:44:32 | alfalfas | 4 | 161609 | 278 | 19.283 | 8380.9 |
236 | 2024-03-06 10:45:33 | alfalfas | 3 | 146162 | 16 | 8.766 | 16673.7 |
235 | 2024-03-06 10:45:33 | alfalfas | 2 | 121059 | 2 | 5.750 | 21053.7 |
234 | 2024-03-06 10:45:02 | alfalfas | 1 | 82945 | 2 | 4.906 | 16906.8 |
233 | 2024-03-06 10:42:26 | alfalfas | 4 | 161609 | 278 | 24.360 | 6634.2 |
232 | 2024-03-06 04:11:40 | alfalfas | 4 | 161609 | 278 | 29.143 | 5545.4 |
231 | 2024-03-06 03:50:22 | alfalfas | 4 | 161609 | 278 | 13.780 | 11727.8 |
230 | 2024-03-05 12:30:48 | alfalfas | 4 | 161609 | 278 | 19.703 | 8202.3 |
229 | 2024-03-05 12:30:51 | alfalfas | 2 | 121059 | 2 | 9.186 | 13178.6 |
228 | 2024-03-05 12:30:49 | alfalfas | 3 | 146162 | 16 | 8.470 | 17256.4 |
227 | 2024-03-05 12:30:47 | alfalfas | 1 | 82945 | 2 | 1.530 | 54212.4 |
226 | 2024-02-21 04:49:38 | alfalfas | 2 | 121059 | 2 | 3.873 | 31257.2 |
225 | 2024-02-20 20:39:36 | alfalfas | 1 | 82945 | 2 | 1.656 | 50087.6 |
224 | 2024-02-15 18:16:48 | alfalfas | 3 | 146162 | 16 | 9.893 | 14774.3 |
223 | 2024-02-10 12:24:16 | alfalfas | 4 | 161609 | 278 | 14.860 | 10875.4 |
222 | 2024-02-09 22:24:17 | alfalfas | 3 | 146162 | 16 | 13.953 | 10475.3 |
221 | 2024-02-07 11:43:02 | alfalfas | 3 | 146162 | 16 | 7.470 | 19566.5 |
220 | 2024-02-07 11:43:06 | alfalfas | 1 | 82945 | 2 | 1.546 | 53651.4 |
219 | 2024-02-07 11:42:58 | alfalfas | 2 | 121059 | 2 | 6.983 | 17336.2 |
218 | 2024-02-05 00:32:47 | alfalfas | 4 | 161609 | 278 | 23.690 | 6821.8 |
217 | 2024-02-04 22:35:53 | alfalfas | 4 | 161609 | 278 | 18.513 | 8729.5 |
216 | 2024-02-01 22:28:03 | alfalfas | 1 | 82945 | 2 | 2.013 | 41204.7 |
215 | 2024-01-31 10:43:15 | alfalfas | 2 | 121059 | 2 | 3.890 | 31120.6 |
214 | 2024-01-31 10:43:07 | alfalfas | 1 | 82945 | 2 | 1.453 | 57085.3 |
213 | 2024-01-31 10:42:27 | alfalfas | 3 | 146162 | 16 | 6.940 | 21060.8 |
212 | 2024-01-31 10:21:23 | alfalfas | 4 | 161609 | 278 | 13.283 | 12166.6 |
211 | 2024-01-31 08:43:15 | alfalfas | 4 | 161609 | 278 | 12.720 | 12705.1 |
210 | 2024-01-31 08:43:07 | alfalfas | 2 | 121059 | 2 | 5.220 | 23191.4 |
209 | 2024-01-31 08:42:59 | alfalfas | 4 | 161609 | 278 | 13.406 | 12055.0 |
208 | 2024-01-31 08:43:03 | alfalfas | 3 | 146162 | 16 | 8.046 | 18165.8 |
207 | 2024-01-31 08:43:07 | alfalfas | 1 | 82945 | 2 | 3.033 | 27347.5 |
206 | 2024-01-31 08:43:03 | alfalfas | 1 | 82945 | 2 | 1.546 | 53651.4 |
205 | 2024-01-31 08:42:54 | alfalfas | 2 | 121059 | 2 | 3.513 | 34460.3 |
204 | 2024-01-30 16:18:31 | alfalfas | 3 | 146162 | 16 | 12.280 | 11902.4 |
203 | 2024-01-24 00:15:14 | alfalfas | 3 | 146162 | 16 | 8.063 | 18127.5 |
202 | 2023-12-31 15:57:15 | alfalfas | 1 | 82945 | 2 | 1.326 | 62552.8 |
201 | 2023-12-27 17:26:05 | alfalfas | 1 | 82945 | 2 | 1.530 | 54212.4 |
200 | 2023-12-13 18:38:56 | alfalfas | 4 | 161609 | 278 | 12.093 | 13363.8 |
199 | 2023-12-06 04:25:17 | alfalfas | 4 | 161609 | 278 | 12.800 | 12625.7 |
198 | 2023-12-01 17:25:51 | alfalfas | 2 | 121059 | 2 | 3.233 | 37444.8 |
197 | 2023-11-27 04:16:05 | alfalfas | 1 | 82945 | 2 | 1.280 | 64800.8 |
196 | 2023-11-11 03:37:49 | alfalfas | 4 | 161609 | 278 | 11.406 | 14168.8 |
195 | 2023-11-03 01:43:04 | alfalfas | 3 | 146162 | 16 | 6.076 | 24055.6 |
194 | 2023-11-02 02:41:10 | alfalfas | 1 | 82945 | 2 | 1.436 | 57761.1 |
193 | 2023-10-16 13:39:04 | alfalfas | 1 | 82945 | 2 | 1.250 | 66356.0 |
192 | 2023-09-21 02:08:07 | alfalfas | 1 | 82945 | 2 | 1.360 | 60989.0 |
191 | 2023-08-30 12:12:30 | alfalfas | 2 | 121059 | 2 | 3.093 | 39139.7 |
190 | 2023-08-17 07:45:50 | alfalfas | 4 | 161609 | 278 | 12.113 | 13341.8 |
189 | 2023-08-11 22:13:58 | alfalfas | 3 | 146162 | 16 | 7.390 | 19778.3 |
188 | 2023-08-11 20:17:21 | alfalfas | 1 | 82945 | 2 | 1.283 | 64649.3 |
187 | 2023-06-20 01:19:52 | alfalfas | 4 | 161609 | 278 | 11.313 | 14285.2 |
186 | 2023-05-24 06:00:46 | alfalfas | 4 | 161609 | 278 | 12.593 | 12833.2 |
185 | 2023-05-18 09:34:22 | alfalfas | 1 | 82945 | 2 | 1.263 | 65673.0 |
184 | 2023-05-17 17:09:33 | alfalfas | 2 | 121059 | 2 | 3.080 | 39304.9 |
183 | 2023-05-10 11:33:59 | alfalfas | 1 | 82945 | 2 | 1.266 | 65517.4 |
182 | 2023-04-24 08:03:17 | alfalfas | 4 | 161609 | 278 | 11.453 | 14110.6 |
181 | 2023-04-20 12:13:34 | alfalfas | 3 | 146162 | 16 | 6.000 | 24360.3 |
180 | 2023-03-07 04:33:07 | alfalfas | 1 | 82945 | 2 | 1.233 | 67270.9 |
179 | 2023-02-25 08:01:38 | alfalfas | 2 | 121059 | 2 | 3.046 | 39743.6 |
178 | 2023-01-27 04:37:06 | alfalfas | 4 | 161609 | 278 | 10.140 | 15937.8 |
177 | 2023-01-22 18:02:46 | alfalfas | 3 | 146162 | 16 | 6.690 | 21847.8 |
176 | 2023-01-18 01:33:58 | alfalfas | 1 | 82945 | 2 | 1.390 | 59672.7 |
175 | 2022-12-28 20:27:03 | alfalfas | 1 | 82945 | 2 | 1.250 | 66356.0 |
174 | 2022-12-03 21:37:13 | alfalfas | 2 | 121059 | 2 | 3.173 | 38152.9 |
173 | 2022-11-24 17:45:03 | alfalfas | 1 | 82945 | 2 | 1.346 | 61623.3 |
172 | 2022-11-08 03:08:45 | alfalfas | 4 | 161609 | 278 | 13.046 | 12387.6 |
171 | 2022-11-02 05:38:02 | alfalfas | 3 | 146162 | 16 | 6.420 | 22766.7 |
170 | 2022-10-17 10:03:59 | alfalfas | 4 | 161609 | 278 | 10.703 | 15099.4 |
169 | 2022-09-15 13:15:43 | alfalfas | 1 | 82945 | 2 | 1.263 | 65673.0 |
168 | 2022-09-12 08:22:17 | alfalfas | 1 | 82945 | 2 | 1.283 | 64649.3 |
167 | 2022-09-03 22:29:23 | alfalfas | 4 | 161609 | 278 | 10.236 | 15788.3 |
166 | 2022-08-30 09:33:14 | alfalfas | 4 | 161609 | 278 | 10.703 | 15099.4 |