History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"approximate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
294 | 2024-05-07 04:31:04 | approximate | 4 | 148819 | 27 | 23.313 | 6383.5 |
293 | 2024-05-07 04:30:54 | approximate | 2 | 86808 | 6 | 4.936 | 17586.7 |
292 | 2024-05-07 04:27:27 | approximate | 1 | 49908 | 3 | 0.906 | 55086.1 |
291 | 2024-05-07 04:26:35 | approximate | 3 | 121633 | 11 | 7.110 | 17107.3 |
290 | 2024-05-07 00:50:32 | approximate | 2 | 86808 | 6 | 2.673 | 32475.9 |
289 | 2024-05-07 00:17:12 | approximate | 4 | 148819 | 27 | 10.406 | 14301.3 |
288 | 2024-05-06 22:37:38 | approximate | 3 | 121633 | 11 | 8.626 | 14100.7 |
287 | 2024-05-04 16:14:13 | approximate | 4 | 148819 | 27 | 16.360 | 9096.5 |
286 | 2024-04-26 06:51:03 | approximate | 1 | 49908 | 3 | 1.313 | 38010.7 |
285 | 2024-04-24 11:55:14 | approximate | 5 | 164607 | 136 | 19.033 | 8648.5 |
284 | 2024-04-24 05:47:35 | approximate | 5 | 164607 | 136 | 28.063 | 5865.6 |
283 | 2024-04-23 19:34:39 | approximate | 5 | 164607 | 136 | 45.520 | 3616.1 |
282 | 2024-04-23 08:34:30 | approximate | 4 | 148819 | 27 | 23.250 | 6400.8 |
281 | 2024-04-23 08:34:29 | approximate | 3 | 121633 | 11 | 13.466 | 9032.6 |
280 | 2024-04-23 08:34:32 | approximate | 2 | 86808 | 6 | 6.906 | 12569.9 |
279 | 2024-04-23 08:27:43 | approximate | 1 | 49908 | 3 | 2.236 | 22320.2 |
278 | 2024-04-23 08:24:51 | approximate | 5 | 164607 | 136 | 44.783 | 3675.7 |
277 | 2024-04-22 13:40:51 | approximate | 5 | 164607 | 136 | 59.130 | 2783.8 |
276 | 2024-04-22 11:52:09 | approximate | 5 | 164607 | 136 | 41.733 | 3944.3 |
275 | 2024-04-22 11:52:13 | approximate | 4 | 148819 | 27 | 28.170 | 5282.9 |
274 | 2024-04-22 11:52:18 | approximate | 3 | 121633 | 11 | 19.843 | 6129.8 |
273 | 2024-04-22 11:52:06 | approximate | 2 | 86808 | 6 | 7.266 | 11947.2 |
272 | 2024-04-22 11:51:03 | approximate | 2 | 86808 | 6 | 5.560 | 15612.9 |
271 | 2024-04-22 11:50:43 | approximate | 3 | 121633 | 11 | 9.736 | 12493.1 |
270 | 2024-04-22 11:50:38 | approximate | 1 | 49908 | 3 | 1.500 | 33272.0 |
269 | 2024-04-22 11:50:11 | approximate | 1 | 49908 | 3 | 2.970 | 16804.0 |
268 | 2024-03-30 10:22:01 | approximate | 5 | 164607 | 136 | 31.783 | 5179.1 |
267 | 2024-03-30 10:22:00 | approximate | 5 | 164607 | 136 | 26.173 | 6289.2 |
266 | 2024-03-26 09:37:06 | approximate | 4 | 148819 | 27 | 22.266 | 6683.7 |
265 | 2024-03-21 23:57:06 | approximate | 4 | 148819 | 27 | 17.140 | 8682.6 |
264 | 2024-03-21 16:35:04 | approximate | 4 | 148819 | 27 | 17.846 | 8339.1 |
263 | 2024-03-21 16:35:00 | approximate | 2 | 86808 | 6 | 8.393 | 10342.9 |
262 | 2024-03-21 16:33:32 | approximate | 3 | 121633 | 11 | 5.596 | 21735.7 |
261 | 2024-03-21 14:35:57 | approximate | 3 | 121633 | 11 | 17.753 | 6851.4 |
260 | 2024-03-21 07:28:09 | approximate | 5 | 164607 | 136 | 52.860 | 3114.0 |
259 | 2024-03-19 07:39:43 | approximate | 5 | 164607 | 136 | 30.580 | 5382.8 |
258 | 2024-03-19 07:01:23 | approximate | 5 | 164607 | 136 | 19.216 | 8566.1 |
257 | 2024-03-17 10:59:24 | approximate | 5 | 164607 | 136 | 16.313 | 10090.5 |
256 | 2024-03-17 10:59:29 | approximate | 4 | 148819 | 27 | 10.656 | 13965.7 |
255 | 2024-03-17 10:59:28 | approximate | 3 | 121633 | 11 | 7.546 | 16118.9 |
254 | 2024-03-17 10:59:31 | approximate | 1 | 49908 | 3 | 1.810 | 27573.5 |
253 | 2024-03-17 10:59:25 | approximate | 2 | 86808 | 6 | 2.203 | 39404.4 |
252 | 2024-03-17 10:58:44 | approximate | 1 | 49908 | 3 | 0.873 | 57168.4 |
251 | 2024-02-20 17:57:29 | approximate | 1 | 49908 | 3 | 2.783 | 17933.2 |
250 | 2024-02-20 05:07:17 | approximate | 4 | 148819 | 27 | 23.970 | 6208.6 |
249 | 2024-02-20 05:07:23 | approximate | 3 | 121633 | 11 | 17.296 | 7032.4 |
248 | 2024-02-20 05:07:23 | approximate | 2 | 86808 | 6 | 5.343 | 16247.1 |
247 | 2024-02-19 20:20:26 | approximate | 1 | 49908 | 3 | 1.830 | 27272.1 |
246 | 2024-02-19 15:02:49 | approximate | 1 | 49908 | 3 | 0.906 | 55086.1 |
245 | 2024-02-19 14:09:33 | approximate | 3 | 121633 | 11 | 4.966 | 24493.2 |
244 | 2024-02-19 14:09:33 | approximate | 2 | 86808 | 6 | 2.346 | 37002.6 |
243 | 2024-02-17 04:26:38 | approximate | 2 | 86808 | 6 | 5.626 | 15429.8 |
242 | 2024-02-16 11:03:48 | approximate | 2 | 86808 | 6 | 2.733 | 31762.9 |
241 | 2024-02-16 08:24:26 | approximate | 1 | 49908 | 3 | 0.750 | 66544.0 |
240 | 2024-02-13 13:09:36 | approximate | 4 | 148819 | 27 | 19.110 | 7787.5 |
239 | 2024-02-13 13:09:32 | approximate | 3 | 121633 | 11 | 8.923 | 13631.4 |
238 | 2024-02-13 13:09:27 | approximate | 2 | 86808 | 6 | 2.796 | 31047.2 |
237 | 2024-02-13 11:39:58 | approximate | 1 | 49908 | 3 | 3.000 | 16636.0 |
236 | 2024-02-08 16:40:54 | approximate | 5 | 164607 | 136 | 39.830 | 4132.7 |
235 | 2024-02-04 14:01:38 | approximate | 5 | 164607 | 136 | 65.050 | 2530.5 |
234 | 2024-02-04 08:58:52 | approximate | 4 | 148819 | 27 | 24.220 | 6144.5 |
233 | 2024-02-04 08:57:58 | approximate | 5 | 164607 | 136 | 35.096 | 4690.2 |
232 | 2024-02-04 08:57:49 | approximate | 2 | 86808 | 6 | 2.656 | 32683.7 |
231 | 2024-02-04 05:09:34 | approximate | 1 | 49908 | 3 | 0.750 | 66544.0 |
230 | 2024-01-29 21:12:17 | approximate | 3 | 121633 | 11 | 10.923 | 11135.5 |
229 | 2024-01-29 20:03:15 | approximate | 1 | 49908 | 3 | 0.860 | 58032.6 |
228 | 2024-01-18 19:14:26 | approximate | 1 | 49908 | 3 | 0.860 | 58032.6 |
227 | 2023-12-25 03:44:23 | approximate | 4 | 148819 | 27 | 9.000 | 16535.4 |
226 | 2023-12-22 08:47:55 | approximate | 1 | 49908 | 3 | 0.906 | 55086.1 |
225 | 2023-12-09 12:17:19 | approximate | 3 | 121633 | 11 | 5.700 | 21339.1 |
224 | 2023-12-06 21:56:37 | approximate | 1 | 49908 | 3 | 0.766 | 65154.0 |
223 | 2023-12-05 03:05:12 | approximate | 5 | 164607 | 136 | 14.643 | 11241.3 |
222 | 2023-11-23 13:45:42 | approximate | 1 | 49908 | 3 | 0.826 | 60421.3 |
221 | 2023-11-07 07:41:09 | approximate | 1 | 49908 | 3 | 0.766 | 65154.0 |
220 | 2023-11-06 08:32:10 | approximate | 3 | 121633 | 11 | 4.296 | 28313.1 |
219 | 2023-10-22 09:16:44 | approximate | 1 | 49908 | 3 | 0.766 | 65154.0 |
218 | 2023-09-25 23:02:28 | approximate | 4 | 148819 | 27 | 10.906 | 13645.6 |
217 | 2023-09-10 01:04:31 | approximate | 1 | 49908 | 3 | 0.750 | 66544.0 |
216 | 2023-09-03 01:40:39 | approximate | 5 | 164607 | 136 | 14.406 | 11426.3 |
215 | 2023-09-02 18:08:44 | approximate | 5 | 164607 | 136 | 14.266 | 11538.4 |
214 | 2023-08-11 16:03:46 | approximate | 3 | 121633 | 11 | 4.330 | 28090.8 |
213 | 2023-08-08 04:55:19 | approximate | 5 | 164607 | 136 | 13.923 | 11822.7 |
212 | 2023-07-15 16:10:04 | approximate | 5 | 164607 | 136 | 15.610 | 10545.0 |
211 | 2023-07-11 12:15:53 | approximate | 5 | 164607 | 136 | 13.813 | 11916.8 |
210 | 2023-07-04 08:19:36 | approximate | 4 | 148819 | 27 | 9.140 | 16282.2 |
209 | 2023-06-14 23:56:41 | approximate | 1 | 49908 | 3 | 0.736 | 67809.8 |
208 | 2023-06-01 10:37:15 | approximate | 1 | 49908 | 3 | 0.733 | 68087.3 |
207 | 2023-05-25 22:53:34 | approximate | 5 | 164607 | 136 | 13.343 | 12336.6 |
206 | 2023-04-25 07:11:10 | approximate | 3 | 121633 | 11 | 4.203 | 28939.6 |
205 | 2023-03-29 16:34:21 | approximate | 1 | 49908 | 3 | 0.733 | 68087.3 |
204 | 2023-03-22 17:12:31 | approximate | 4 | 148819 | 27 | 8.076 | 18427.3 |
203 | 2023-03-06 22:12:18 | approximate | 5 | 164607 | 136 | 13.563 | 12136.5 |
202 | 2023-02-04 02:18:10 | approximate | 5 | 164607 | 136 | 14.423 | 11412.8 |
201 | 2023-01-29 22:47:38 | approximate | 1 | 49908 | 3 | 0.733 | 68087.3 |
200 | 2023-01-29 18:26:24 | approximate | 3 | 121633 | 11 | 4.233 | 28734.5 |
199 | 2023-01-14 00:11:51 | approximate | 1 | 49908 | 3 | 0.736 | 67809.8 |
198 | 2022-12-27 06:09:41 | approximate | 5 | 164607 | 136 | 14.313 | 11500.5 |
197 | 2022-12-22 05:03:39 | approximate | 4 | 148819 | 27 | 8.873 | 16772.1 |
196 | 2022-12-13 17:05:08 | approximate | 5 | 164607 | 136 | 13.233 | 12439.1 |
195 | 2022-11-26 11:12:41 | approximate | 5 | 164607 | 136 | 15.860 | 10378.8 |