History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"overture"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
280 | 2024-05-09 18:23:38 | overture | 3 | 146162 | 202 | 6.420 | 22766.7 |
279 | 2024-05-08 02:07:58 | overture | 1 | 82945 | 8 | 3.986 | 20809.1 |
278 | 2024-05-01 13:46:18 | overture | 1 | 82945 | 8 | 4.700 | 17647.9 |
277 | 2024-05-01 04:50:58 | overture | 2 | 121059 | 35 | 6.080 | 19911.0 |
276 | 2024-05-01 04:50:17 | overture | 3 | 146162 | 202 | 6.876 | 21256.8 |
275 | 2024-04-30 16:43:46 | overture | 2 | 121059 | 35 | 8.046 | 15045.9 |
274 | 2024-04-29 23:19:25 | overture | 1 | 82945 | 8 | 1.516 | 54713.1 |
273 | 2024-04-29 16:58:22 | overture | 2 | 121059 | 35 | 5.220 | 23191.4 |
272 | 2024-04-29 16:58:18 | overture | 3 | 146162 | 202 | 8.190 | 17846.4 |
271 | 2024-04-29 15:13:30 | overture | 2 | 121059 | 35 | 3.563 | 33976.7 |
270 | 2024-04-29 15:11:58 | overture | 3 | 146162 | 202 | 7.310 | 19994.8 |
269 | 2024-04-28 17:52:52 | overture | 1 | 82945 | 8 | 1.483 | 55930.5 |
268 | 2024-04-28 17:52:47 | overture | 2 | 121059 | 35 | 3.720 | 32542.7 |
267 | 2024-04-28 17:48:35 | overture | 3 | 146162 | 202 | 7.423 | 19690.4 |
266 | 2024-04-28 05:12:38 | overture | 3 | 146162 | 202 | 21.170 | 6904.2 |
265 | 2024-04-27 00:49:21 | overture | 1 | 82945 | 8 | 4.406 | 18825.5 |
264 | 2024-04-07 16:38:47 | overture | 1 | 82945 | 8 | 5.190 | 15981.7 |
263 | 2024-04-07 00:18:35 | overture | 1 | 82945 | 8 | 5.343 | 15524.1 |
262 | 2024-03-30 08:00:39 | overture | 2 | 121059 | 35 | 4.410 | 27451.0 |
261 | 2024-03-30 07:54:44 | overture | 1 | 82945 | 8 | 1.466 | 56579.1 |
260 | 2024-03-29 12:19:20 | overture | 2 | 121059 | 35 | 9.843 | 12299.0 |
259 | 2024-03-29 00:34:08 | overture | 3 | 146162 | 202 | 16.843 | 8677.9 |
258 | 2024-03-28 16:45:14 | overture | 3 | 146162 | 202 | 20.390 | 7168.3 |
257 | 2024-03-27 16:14:58 | overture | 1 | 82945 | 8 | 1.423 | 58288.8 |
256 | 2024-03-27 10:30:49 | overture | 2 | 121059 | 35 | 3.843 | 31501.2 |
255 | 2024-03-27 10:30:45 | overture | 3 | 146162 | 202 | 7.626 | 19166.3 |
254 | 2024-03-27 10:30:41 | overture | 3 | 146162 | 202 | 7.610 | 19206.6 |
253 | 2024-03-27 10:30:41 | overture | 1 | 82945 | 8 | 1.390 | 59672.7 |
252 | 2024-03-27 10:30:33 | overture | 2 | 121059 | 35 | 3.250 | 37248.9 |
251 | 2024-03-24 17:24:19 | overture | 2 | 121059 | 35 | 4.173 | 29010.1 |
250 | 2024-03-12 06:17:13 | overture | 1 | 82945 | 8 | 1.466 | 56579.1 |
249 | 2024-03-07 05:42:33 | overture | 1 | 82945 | 8 | 1.453 | 57085.3 |
248 | 2024-03-01 14:06:37 | overture | 1 | 82945 | 8 | 1.733 | 47862.1 |
247 | 2024-01-03 19:49:01 | overture | 3 | 146162 | 202 | 8.890 | 16441.2 |
246 | 2023-12-18 19:56:07 | overture | 1 | 82945 | 8 | 1.283 | 64649.3 |
245 | 2023-12-16 02:37:12 | overture | 1 | 82945 | 8 | 1.266 | 65517.4 |
244 | 2023-12-14 12:33:08 | overture | 1 | 82945 | 8 | 1.263 | 65673.0 |
243 | 2023-12-12 06:22:13 | overture | 3 | 146162 | 202 | 15.986 | 9143.1 |
242 | 2023-12-12 04:03:09 | overture | 3 | 146162 | 202 | 8.123 | 17993.6 |
241 | 2023-12-10 15:06:08 | overture | 1 | 82945 | 8 | 1.406 | 58993.6 |
240 | 2023-11-30 09:08:48 | overture | 2 | 121059 | 35 | 3.063 | 39523.0 |
239 | 2023-11-29 14:21:46 | overture | 1 | 82945 | 8 | 1.250 | 66356.0 |
238 | 2023-11-11 05:35:17 | overture | 3 | 146162 | 202 | 7.876 | 18557.9 |
237 | 2023-11-04 19:44:44 | overture | 3 | 146162 | 202 | 16.983 | 8606.4 |
236 | 2023-10-22 17:50:37 | overture | 1 | 82945 | 8 | 1.326 | 62552.8 |
235 | 2023-10-18 01:50:25 | overture | 1 | 82945 | 8 | 2.780 | 29836.3 |
234 | 2023-10-17 07:01:16 | overture | 3 | 146162 | 202 | 9.533 | 15332.2 |
233 | 2023-10-15 16:51:49 | overture | 1 | 82945 | 8 | 1.686 | 49196.3 |
232 | 2023-10-09 03:43:40 | overture | 3 | 146162 | 202 | 10.813 | 13517.2 |
231 | 2023-10-09 01:50:22 | overture | 1 | 82945 | 8 | 1.343 | 61761.0 |
230 | 2023-10-03 09:56:30 | overture | 1 | 82945 | 8 | 1.250 | 66356.0 |
229 | 2023-09-25 21:06:19 | overture | 1 | 82945 | 8 | 1.373 | 60411.5 |
228 | 2023-09-14 21:47:37 | overture | 1 | 82945 | 8 | 1.516 | 54713.1 |
227 | 2023-08-30 03:23:16 | overture | 2 | 121059 | 35 | 3.216 | 37642.7 |
226 | 2023-08-13 05:35:32 | overture | 1 | 82945 | 8 | 1.233 | 67270.9 |
225 | 2023-07-31 08:17:38 | overture | 1 | 82945 | 8 | 1.390 | 59672.7 |
224 | 2023-07-19 07:44:37 | overture | 3 | 146162 | 202 | 7.173 | 20376.7 |
223 | 2023-05-10 20:38:33 | overture | 2 | 121059 | 35 | 3.216 | 37642.7 |
222 | 2023-04-26 14:56:27 | overture | 1 | 82945 | 8 | 1.280 | 64800.8 |
221 | 2023-04-21 01:13:39 | overture | 1 | 82945 | 8 | 1.220 | 67987.7 |
220 | 2023-04-01 19:38:55 | overture | 3 | 146162 | 202 | 7.453 | 19611.2 |
219 | 2023-02-19 19:34:14 | overture | 2 | 121059 | 35 | 3.686 | 32842.9 |
218 | 2023-02-16 14:05:07 | overture | 1 | 82945 | 8 | 1.220 | 67987.7 |
217 | 2022-12-29 00:52:04 | overture | 3 | 146162 | 202 | 7.173 | 20376.7 |
216 | 2022-12-28 11:25:19 | overture | 1 | 82945 | 8 | 1.436 | 57761.1 |
215 | 2022-12-14 04:40:42 | overture | 1 | 82945 | 8 | 1.390 | 59672.7 |
214 | 2022-11-30 19:17:34 | overture | 2 | 121059 | 35 | 3.046 | 39743.6 |
213 | 2022-08-28 06:44:08 | overture | 3 | 146162 | 202 | 7.046 | 20744.0 |
212 | 2022-08-24 13:45:45 | overture | 1 | 82945 | 8 | 1.250 | 66356.0 |
211 | 2022-08-18 17:36:45 | overture | 1 | 82945 | 8 | 1.376 | 60279.8 |
210 | 2022-07-08 07:49:58 | overture | 2 | 121059 | 35 | 3.096 | 39101.7 |
209 | 2022-04-23 20:08:41 | overture | 1 | 82945 | 8 | 1.266 | 65517.4 |
208 | 2022-04-07 05:09:32 | overture | 1 | 82945 | 8 | 1.250 | 66356.0 |
207 | 2022-03-27 12:08:40 | overture | 3 | 146162 | 202 | 6.206 | 23551.7 |
206 | 2022-01-08 19:01:03 | overture | 1 | 82945 | 8 | 1.466 | 56579.1 |
205 | 2021-12-28 22:46:55 | overture | 1 | 82945 | 8 | 1.346 | 61623.3 |
204 | 2021-11-23 11:35:25 | overture | 1 | 82945 | 8 | 1.486 | 55817.6 |
203 | 2021-09-12 04:35:19 | overture | 1 | 82945 | 8 | 1.343 | 61761.0 |
202 | 2021-06-11 21:57:06 | overture | 1 | 82945 | 8 | 1.233 | 67270.9 |
201 | 2021-05-26 22:20:17 | overture | 1 | 82945 | 8 | 1.373 | 60411.5 |
200 | 2021-05-01 03:34:54 | overture | 1 | 82945 | 8 | 1.470 | 56425.2 |
199 | 2021-03-30 11:05:25 | overture | 1 | 82945 | 8 | 1.266 | 65517.4 |
198 | 2021-03-12 12:19:27 | overture | 1 | 82945 | 8 | 1.360 | 60989.0 |
197 | 2021-02-23 13:13:49 | overture | 3 | 146162 | 202 | 7.500 | 19488.3 |
196 | 2021-02-08 05:29:08 | overture | 1 | 82945 | 8 | 1.250 | 66356.0 |
195 | 2021-01-14 01:10:08 | overture | 1 | 82945 | 8 | 1.390 | 59672.7 |
194 | 2020-12-09 08:05:56 | overture | 1 | 82945 | 8 | 1.373 | 60411.5 |
193 | 2020-10-18 14:09:41 | overture | 1 | 82945 | 8 | 1.390 | 59672.7 |
192 | 2020-10-01 02:59:20 | overture | 1 | 82945 | 8 | 1.233 | 67270.9 |
191 | 2020-09-06 07:29:55 | overture | 1 | 82945 | 8 | 1.296 | 64000.8 |
190 | 2020-08-15 07:05:02 | overture | 1 | 82945 | 8 | 1.313 | 63172.1 |
189 | 2020-07-22 09:43:36 | overture | 1 | 82945 | 8 | 1.330 | 62364.7 |
188 | 2020-05-31 21:39:47 | overture | 1 | 82945 | 8 | 1.266 | 65517.4 |
187 | 2020-03-30 09:36:20 | overture | 1 | 82945 | 8 | 1.483 | 55930.5 |
186 | 2020-03-22 06:06:54 | overture | 1 | 82945 | 8 | 1.483 | 55930.5 |
185 | 2020-03-01 19:46:03 | overture | 1 | 82945 | 8 | 1.453 | 57085.3 |
184 | 2020-02-25 12:17:14 | overture | 1 | 82945 | 8 | 2.906 | 28542.7 |
183 | 2020-02-22 09:33:52 | overture | 1 | 82945 | 8 | 2.966 | 27965.3 |
182 | 2020-02-18 19:07:00 | overture | 1 | 82945 | 8 | 1.546 | 53651.4 |
181 | 2020-02-14 12:06:20 | overture | 1 | 82945 | 8 | 1.453 | 57085.3 |