History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"zebra"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
281 | 2024-05-08 23:19:41 | zebra | 1 | 28756 | 2 | 0.440 | 65354.5 |
280 | 2024-05-06 15:19:47 | zebra | 1 | 28756 | 2 | 0.983 | 29253.3 |
279 | 2024-04-30 23:53:39 | zebra | 1 | 28756 | 2 | 0.500 | 57512.0 |
278 | 2024-04-30 04:40:25 | zebra | 1 | 28756 | 2 | 0.530 | 54256.6 |
277 | 2024-04-28 11:21:20 | zebra | 1 | 28756 | 2 | 1.016 | 28303.1 |
276 | 2024-04-18 17:38:32 | zebra | 1 | 28756 | 2 | 0.656 | 43835.4 |
275 | 2024-04-18 01:00:42 | zebra | 1 | 28756 | 2 | 0.593 | 48492.4 |
274 | 2024-04-18 00:01:01 | zebra | 1 | 28756 | 2 | 0.593 | 48492.4 |
273 | 2024-04-15 04:23:43 | zebra | 1 | 28756 | 2 | 0.970 | 29645.4 |
272 | 2024-04-06 13:13:24 | zebra | 3 | 83667 | 521 | 12.343 | 6778.5 |
271 | 2024-04-06 13:13:20 | zebra | 2 | 53800 | 28 | 4.953 | 10862.1 |
270 | 2024-04-06 13:10:06 | zebra | 1 | 28756 | 2 | 1.063 | 27051.7 |
269 | 2024-03-31 14:52:33 | zebra | 3 | 83667 | 521 | 9.140 | 9153.9 |
268 | 2024-03-31 14:52:32 | zebra | 2 | 53800 | 28 | 1.906 | 28226.7 |
267 | 2024-03-31 14:39:05 | zebra | 1 | 28756 | 2 | 1.656 | 17364.7 |
266 | 2024-03-29 09:10:32 | zebra | 1 | 28756 | 2 | 1.063 | 27051.7 |
265 | 2024-03-07 07:56:24 | zebra | 3 | 83667 | 521 | 6.360 | 13155.2 |
264 | 2024-03-07 07:56:22 | zebra | 2 | 53800 | 28 | 6.703 | 8026.3 |
263 | 2024-03-07 05:49:23 | zebra | 1 | 28756 | 2 | 0.470 | 61183.0 |
262 | 2024-03-01 13:04:08 | zebra | 1 | 28756 | 2 | 0.436 | 65954.1 |
261 | 2024-02-28 07:15:58 | zebra | 1 | 28756 | 2 | 2.953 | 9737.9 |
260 | 2024-02-03 20:55:07 | zebra | 1 | 28756 | 2 | 0.470 | 61183.0 |
259 | 2024-01-29 12:30:04 | zebra | 1 | 28756 | 2 | 0.470 | 61183.0 |
258 | 2024-01-29 03:26:41 | zebra | 1 | 28756 | 2 | 0.466 | 61708.2 |
257 | 2024-01-22 03:12:30 | zebra | 3 | 83667 | 521 | 3.436 | 24350.1 |
256 | 2024-01-19 08:39:10 | zebra | 1 | 28756 | 2 | 0.466 | 61708.2 |
255 | 2023-12-31 02:44:07 | zebra | 3 | 83667 | 521 | 3.703 | 22594.4 |
254 | 2023-12-31 02:44:09 | zebra | 2 | 53800 | 28 | 1.576 | 34137.1 |
253 | 2023-12-11 06:27:00 | zebra | 3 | 83667 | 521 | 3.470 | 24111.5 |
252 | 2023-12-11 06:27:02 | zebra | 2 | 53800 | 28 | 1.546 | 34799.5 |
251 | 2023-11-13 23:16:03 | zebra | 1 | 28756 | 2 | 0.436 | 65954.1 |
250 | 2023-11-13 07:50:02 | zebra | 1 | 28756 | 2 | 0.436 | 65954.1 |
249 | 2023-11-11 01:38:51 | zebra | 1 | 28756 | 2 | 0.486 | 59168.7 |
248 | 2023-11-04 03:19:47 | zebra | 3 | 83667 | 521 | 3.906 | 21420.1 |
247 | 2023-11-03 06:19:13 | zebra | 1 | 28756 | 2 | 0.436 | 65954.1 |
246 | 2023-11-02 13:45:04 | zebra | 3 | 83667 | 521 | 4.766 | 17555.0 |
245 | 2023-11-02 13:45:08 | zebra | 2 | 53800 | 28 | 1.593 | 33772.8 |
244 | 2023-10-23 18:54:48 | zebra | 1 | 28756 | 2 | 0.533 | 53951.2 |
243 | 2023-10-21 09:18:32 | zebra | 1 | 28756 | 2 | 0.483 | 59536.2 |
242 | 2023-10-13 06:18:12 | zebra | 1 | 28756 | 2 | 1.000 | 28756.0 |
241 | 2023-10-08 23:05:34 | zebra | 1 | 28756 | 2 | 0.423 | 67981.1 |
240 | 2023-09-12 02:51:45 | zebra | 1 | 28756 | 2 | 0.486 | 59168.7 |
239 | 2023-09-01 23:21:56 | zebra | 1 | 28756 | 2 | 0.423 | 67981.1 |
238 | 2023-08-09 22:07:43 | zebra | 3 | 83667 | 521 | 3.313 | 25254.2 |
237 | 2023-06-05 10:39:08 | zebra | 1 | 28756 | 2 | 0.453 | 63479.0 |
236 | 2023-04-24 23:23:19 | zebra | 3 | 83667 | 521 | 3.173 | 26368.4 |
235 | 2023-03-25 03:07:21 | zebra | 1 | 28756 | 2 | 0.453 | 63479.0 |
234 | 2023-01-31 09:28:42 | zebra | 3 | 83667 | 521 | 3.156 | 26510.5 |
233 | 2023-01-09 02:09:53 | zebra | 1 | 28756 | 2 | 0.420 | 68466.7 |
232 | 2022-11-11 20:21:06 | zebra | 3 | 83667 | 521 | 3.173 | 26368.4 |
231 | 2022-10-07 04:01:24 | zebra | 1 | 28756 | 2 | 0.440 | 65354.5 |
230 | 2022-09-03 20:14:20 | zebra | 1 | 28756 | 2 | 0.610 | 47141.0 |
229 | 2022-08-14 05:29:46 | zebra | 1 | 28756 | 2 | 0.470 | 61183.0 |
228 | 2022-07-30 05:37:21 | zebra | 1 | 28756 | 2 | 0.436 | 65954.1 |
227 | 2022-07-28 14:32:55 | zebra | 1 | 28756 | 2 | 0.470 | 61183.0 |
226 | 2022-06-13 19:06:25 | zebra | 3 | 83667 | 521 | 3.186 | 26260.8 |
225 | 2022-05-21 22:35:41 | zebra | 1 | 28756 | 2 | 0.440 | 65354.5 |
224 | 2022-02-09 19:47:23 | zebra | 1 | 28756 | 2 | 0.423 | 67981.1 |
223 | 2021-12-03 12:40:32 | zebra | 1 | 28756 | 2 | 0.440 | 65354.5 |
222 | 2021-11-10 18:08:02 | zebra | 1 | 28756 | 2 | 0.453 | 63479.0 |
221 | 2021-10-31 10:03:17 | zebra | 1 | 28756 | 2 | 0.483 | 59536.2 |
220 | 2021-05-31 14:43:29 | zebra | 1 | 28756 | 2 | 0.516 | 55728.7 |
219 | 2021-05-06 09:50:20 | zebra | 1 | 28756 | 2 | 0.453 | 63479.0 |
218 | 2021-02-23 12:38:58 | zebra | 1 | 28756 | 2 | 0.423 | 67981.1 |
217 | 2021-01-19 20:19:56 | zebra | 1 | 28756 | 2 | 0.420 | 68466.7 |
216 | 2020-11-24 22:35:18 | zebra | 1 | 28756 | 2 | 0.420 | 68466.7 |
215 | 2020-11-04 14:24:02 | zebra | 1 | 28756 | 2 | 0.453 | 63479.0 |
214 | 2020-10-17 20:52:06 | zebra | 1 | 28756 | 2 | 0.436 | 65954.1 |
213 | 2020-10-06 20:16:30 | zebra | 1 | 28756 | 2 | 0.423 | 67981.1 |
212 | 2020-09-13 21:59:58 | zebra | 1 | 28756 | 2 | 0.436 | 65954.1 |
211 | 2020-09-13 20:24:05 | zebra | 1 | 28756 | 2 | 0.420 | 68466.7 |
210 | 2020-07-20 18:49:05 | zebra | 1 | 28756 | 2 | 0.470 | 61183.0 |
209 | 2020-03-26 07:52:16 | zebra | 1 | 28756 | 2 | 0.500 | 57512.0 |
208 | 2020-03-24 09:34:06 | zebra | 1 | 28756 | 2 | 0.500 | 57512.0 |
207 | 2020-03-22 11:20:13 | zebra | 1 | 28756 | 2 | 0.500 | 57512.0 |
206 | 2020-03-21 23:22:32 | zebra | 1 | 28756 | 2 | 0.453 | 63479.0 |
205 | 2020-03-21 04:07:52 | zebra | 1 | 28756 | 2 | 1.530 | 18794.8 |
204 | 2020-03-18 15:02:30 | zebra | 1 | 28756 | 2 | 0.483 | 59536.2 |
203 | 2020-03-12 06:59:09 | zebra | 1 | 28756 | 2 | 0.483 | 59536.2 |
202 | 2020-02-23 13:16:59 | zebra | 1 | 28756 | 2 | 0.530 | 54256.6 |
201 | 2020-02-23 02:55:22 | zebra | 1 | 28756 | 2 | 0.513 | 56054.6 |
200 | 2020-02-19 15:31:50 | zebra | 1 | 28756 | 2 | 0.453 | 63479.0 |
199 | 2020-02-03 16:33:58 | zebra | 1 | 28756 | 2 | 0.970 | 29645.4 |
198 | 2020-01-31 12:01:31 | zebra | 1 | 28756 | 2 | 0.546 | 52666.7 |
197 | 2020-01-31 00:06:34 | zebra | 1 | 28756 | 2 | 1.030 | 27918.4 |
196 | 2020-01-30 12:59:26 | zebra | 1 | 28756 | 2 | 1.266 | 22714.1 |
195 | 2020-01-26 22:45:01 | zebra | 1 | 28756 | 2 | 0.530 | 54256.6 |
194 | 2020-01-21 19:57:07 | zebra | 1 | 28756 | 2 | 0.656 | 43835.4 |
193 | 2020-01-13 01:43:18 | zebra | 1 | 28756 | 2 | 1.093 | 26309.2 |
192 | 2020-01-12 11:30:53 | zebra | 1 | 28756 | 2 | 0.513 | 56054.6 |
191 | 2020-01-10 05:37:58 | zebra | 1 | 28756 | 2 | 0.516 | 55728.7 |
190 | 2020-01-10 04:19:36 | zebra | 1 | 28756 | 2 | 0.893 | 32201.6 |
189 | 2020-01-09 19:12:51 | zebra | 1 | 28756 | 2 | 1.076 | 26724.9 |
188 | 2020-01-03 06:13:28 | zebra | 1 | 28756 | 2 | 0.500 | 57512.0 |
187 | 2019-12-27 12:30:17 | zebra | 1 | 28756 | 2 | 0.436 | 65954.1 |
186 | 2019-12-25 13:47:38 | zebra | 1 | 28756 | 2 | 0.530 | 54256.6 |
185 | 2019-12-24 15:21:06 | zebra | 1 | 28756 | 2 | 0.466 | 61708.2 |
184 | 2019-12-24 03:06:23 | zebra | 1 | 28756 | 2 | 0.500 | 57512.0 |
183 | 2019-12-06 11:18:22 | zebra | 1 | 28756 | 2 | 0.436 | 65954.1 |
182 | 2019-09-07 10:45:12 | zebra | 1 | 28756 | 2 | 0.403 | 71354.8 |