History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"traffic"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
264 | 2024-04-16 15:46:57 | traffic | 1 | 69583 | 2 | 1.390 | 50059.7 |
263 | 2024-04-07 13:39:15 | traffic | 4 | 151207 | 847 | 29.720 | 5087.7 |
262 | 2024-04-05 19:05:15 | traffic | 4 | 151207 | 847 | 18.033 | 8385.0 |
261 | 2024-04-05 13:48:05 | traffic | 4 | 151207 | 847 | 37.033 | 4083.0 |
260 | 2024-04-05 13:48:06 | traffic | 3 | 134027 | 73 | 27.563 | 4862.6 |
259 | 2024-04-05 06:55:15 | traffic | 1 | 69583 | 2 | 1.453 | 47889.2 |
258 | 2024-04-05 06:54:56 | traffic | 3 | 134027 | 73 | 8.063 | 16622.5 |
257 | 2024-04-05 02:00:21 | traffic | 4 | 151207 | 847 | 16.440 | 9197.5 |
256 | 2024-04-05 02:00:21 | traffic | 3 | 134027 | 73 | 12.360 | 10843.6 |
255 | 2024-04-05 02:00:19 | traffic | 2 | 107671 | 5 | 12.360 | 8711.2 |
254 | 2024-04-05 01:59:55 | traffic | 1 | 69583 | 2 | 3.093 | 22496.9 |
253 | 2024-03-11 06:28:01 | traffic | 1 | 69583 | 2 | 4.110 | 16930.2 |
252 | 2024-03-06 22:51:14 | traffic | 3 | 134027 | 73 | 25.206 | 5317.3 |
251 | 2024-03-06 05:28:21 | traffic | 3 | 134027 | 73 | 23.190 | 5779.5 |
250 | 2024-03-06 05:28:17 | traffic | 4 | 151207 | 847 | 16.830 | 8984.4 |
249 | 2024-03-05 13:12:40 | traffic | 2 | 107671 | 5 | 3.703 | 29076.7 |
248 | 2024-03-05 13:11:10 | traffic | 3 | 134027 | 73 | 6.796 | 19721.5 |
247 | 2024-03-05 02:35:48 | traffic | 4 | 151207 | 847 | 14.173 | 10668.7 |
246 | 2024-03-04 18:36:26 | traffic | 4 | 151207 | 847 | 23.783 | 6357.8 |
245 | 2024-03-04 16:31:10 | traffic | 3 | 134027 | 73 | 24.720 | 5421.8 |
244 | 2024-03-04 16:31:15 | traffic | 4 | 151207 | 847 | 18.220 | 8299.0 |
243 | 2024-03-04 12:43:09 | traffic | 4 | 151207 | 847 | 30.973 | 4881.9 |
242 | 2024-03-04 12:43:09 | traffic | 2 | 107671 | 5 | 9.953 | 10817.9 |
241 | 2024-03-04 12:43:05 | traffic | 3 | 134027 | 73 | 10.703 | 12522.4 |
240 | 2024-03-04 12:33:13 | traffic | 1 | 69583 | 2 | 1.330 | 52318.0 |
239 | 2024-02-13 08:38:31 | traffic | 1 | 69583 | 2 | 1.063 | 65459.1 |
238 | 2024-02-02 23:58:24 | traffic | 4 | 151207 | 847 | 10.093 | 14981.4 |
237 | 2024-02-02 23:22:35 | traffic | 4 | 151207 | 847 | 14.753 | 10249.2 |
236 | 2024-02-02 23:22:39 | traffic | 3 | 134027 | 73 | 10.300 | 13012.3 |
235 | 2024-02-02 23:18:09 | traffic | 3 | 134027 | 73 | 7.280 | 18410.3 |
234 | 2024-02-02 23:17:57 | traffic | 4 | 151207 | 847 | 11.893 | 12713.9 |
233 | 2024-02-02 23:18:05 | traffic | 1 | 69583 | 2 | 1.266 | 54962.9 |
232 | 2024-02-02 23:18:01 | traffic | 2 | 107671 | 5 | 3.376 | 31893.1 |
231 | 2024-01-30 23:20:35 | traffic | 1 | 69583 | 2 | 1.173 | 59320.5 |
230 | 2024-01-02 09:11:53 | traffic | 1 | 69583 | 2 | 1.236 | 56296.9 |
229 | 2023-12-31 16:33:24 | traffic | 2 | 107671 | 5 | 2.843 | 37872.3 |
228 | 2023-11-29 22:50:02 | traffic | 1 | 69583 | 2 | 1.080 | 64428.7 |
227 | 2023-11-25 15:00:02 | traffic | 1 | 69583 | 2 | 1.250 | 55666.4 |
226 | 2023-11-14 03:01:04 | traffic | 1 | 69583 | 2 | 1.060 | 65644.3 |
225 | 2023-10-19 14:23:32 | traffic | 1 | 69583 | 2 | 1.093 | 63662.4 |
224 | 2023-10-16 12:09:26 | traffic | 1 | 69583 | 2 | 1.156 | 60192.9 |
223 | 2023-10-04 03:41:26 | traffic | 2 | 107671 | 5 | 4.050 | 26585.4 |
222 | 2023-09-28 10:43:22 | traffic | 1 | 69583 | 2 | 1.170 | 59472.6 |
221 | 2023-09-15 10:37:12 | traffic | 1 | 69583 | 2 | 1.140 | 61037.7 |
220 | 2023-07-15 14:58:36 | traffic | 2 | 107671 | 5 | 3.436 | 31336.1 |
219 | 2023-06-27 07:34:07 | traffic | 1 | 69583 | 2 | 1.080 | 64428.7 |
218 | 2023-05-23 09:06:06 | traffic | 1 | 69583 | 2 | 1.483 | 46920.4 |
217 | 2023-05-12 00:25:06 | traffic | 1 | 69583 | 2 | 1.046 | 66522.9 |
216 | 2023-04-08 15:47:48 | traffic | 1 | 69583 | 2 | 1.046 | 66522.9 |
215 | 2023-04-08 14:16:51 | traffic | 1 | 69583 | 2 | 1.203 | 57841.2 |
214 | 2023-04-01 13:03:10 | traffic | 2 | 107671 | 5 | 2.860 | 37647.2 |
213 | 2023-01-08 15:57:10 | traffic | 1 | 69583 | 2 | 1.063 | 65459.1 |
212 | 2023-01-02 14:29:53 | traffic | 1 | 69583 | 2 | 1.283 | 54234.6 |
211 | 2022-12-27 04:44:57 | traffic | 2 | 107671 | 5 | 3.453 | 31181.9 |
210 | 2022-11-21 05:24:05 | traffic | 1 | 69583 | 2 | 1.250 | 55666.4 |
209 | 2022-08-28 08:55:18 | traffic | 2 | 107671 | 5 | 2.810 | 38317.1 |
208 | 2022-08-04 12:10:12 | traffic | 1 | 69583 | 2 | 1.156 | 60192.9 |
207 | 2022-08-01 01:18:51 | traffic | 1 | 69583 | 2 | 1.093 | 63662.4 |
206 | 2022-05-27 19:01:23 | traffic | 1 | 69583 | 2 | 1.236 | 56296.9 |
205 | 2022-05-25 12:40:44 | traffic | 1 | 69583 | 2 | 1.250 | 55666.4 |
204 | 2022-02-24 10:50:44 | traffic | 1 | 69583 | 2 | 1.673 | 41591.8 |
203 | 2022-01-11 11:47:29 | traffic | 1 | 69583 | 2 | 1.326 | 52475.9 |
202 | 2021-12-19 06:10:09 | traffic | 1 | 69583 | 2 | 1.296 | 53690.6 |
201 | 2021-11-15 01:12:32 | traffic | 1 | 69583 | 2 | 1.216 | 57222.9 |
200 | 2021-10-04 13:58:04 | traffic | 1 | 69583 | 2 | 2.530 | 27503.2 |
199 | 2021-08-27 05:01:32 | traffic | 4 | 151207 | 847 | 9.766 | 15483.0 |
198 | 2021-08-08 11:00:02 | traffic | 4 | 151207 | 847 | 9.703 | 15583.5 |
197 | 2021-06-28 13:59:13 | traffic | 1 | 69583 | 2 | 1.123 | 61961.7 |
196 | 2021-03-28 00:31:03 | traffic | 1 | 69583 | 2 | 1.156 | 60192.9 |
195 | 2021-03-24 16:21:46 | traffic | 1 | 69583 | 2 | 1.080 | 64428.7 |
194 | 2021-03-23 15:52:11 | traffic | 1 | 69583 | 2 | 1.280 | 54361.7 |
193 | 2021-01-07 08:24:28 | traffic | 1 | 69583 | 2 | 1.140 | 61037.7 |
192 | 2020-12-16 18:06:58 | traffic | 1 | 69583 | 2 | 1.076 | 64668.2 |
191 | 2020-12-09 11:54:07 | traffic | 1 | 69583 | 2 | 1.110 | 62687.4 |
190 | 2020-10-03 15:24:05 | traffic | 1 | 69583 | 2 | 1.063 | 65459.1 |
189 | 2020-09-06 07:34:48 | traffic | 1 | 69583 | 2 | 1.296 | 53690.6 |
188 | 2020-08-26 13:07:17 | traffic | 1 | 69583 | 2 | 1.156 | 60192.9 |
187 | 2020-05-16 12:23:35 | traffic | 1 | 69583 | 2 | 1.186 | 58670.3 |
186 | 2020-03-27 19:11:35 | traffic | 1 | 69583 | 2 | 1.123 | 61961.7 |
185 | 2020-03-25 13:23:00 | traffic | 1 | 69583 | 2 | 1.343 | 51811.6 |
184 | 2020-03-21 20:17:24 | traffic | 1 | 69583 | 2 | 1.080 | 64428.7 |
183 | 2020-02-25 02:34:26 | traffic | 1 | 69583 | 2 | 1.153 | 60349.5 |
182 | 2020-02-24 23:47:23 | traffic | 1 | 69583 | 2 | 1.233 | 56433.9 |
181 | 2020-02-23 21:30:46 | traffic | 1 | 69583 | 2 | 1.626 | 42794.0 |
180 | 2020-02-17 11:12:54 | traffic | 1 | 69583 | 2 | 1.360 | 51164.0 |
179 | 2020-02-13 23:54:56 | traffic | 4 | 151207 | 847 | 14.893 | 10152.9 |
178 | 2020-02-13 22:02:37 | traffic | 4 | 151207 | 847 | 11.656 | 12972.5 |
177 | 2020-02-13 21:01:27 | traffic | 4 | 151207 | 847 | 15.813 | 9562.2 |
176 | 2020-02-13 20:22:39 | traffic | 4 | 151207 | 847 | 13.516 | 11187.3 |
175 | 2020-02-13 08:32:30 | traffic | 4 | 151207 | 847 | 22.876 | 6609.9 |
174 | 2020-02-04 00:26:09 | traffic | 1 | 69583 | 2 | 1.326 | 52475.9 |
173 | 2020-01-30 13:37:50 | traffic | 1 | 69583 | 2 | 2.783 | 25002.9 |
172 | 2020-01-29 23:58:31 | traffic | 1 | 69583 | 2 | 1.233 | 56433.9 |
171 | 2020-01-27 00:48:46 | traffic | 1 | 69583 | 2 | 2.503 | 27799.8 |
170 | 2020-01-25 12:51:23 | traffic | 1 | 69583 | 2 | 1.593 | 43680.5 |
169 | 2020-01-23 08:18:18 | traffic | 1 | 69583 | 2 | 1.796 | 38743.3 |
168 | 2020-01-22 04:00:31 | traffic | 1 | 69583 | 2 | 4.076 | 17071.4 |
167 | 2020-01-20 00:39:46 | traffic | 1 | 69583 | 2 | 1.266 | 54962.9 |
166 | 2020-01-12 03:14:10 | traffic | 4 | 151207 | 847 | 13.063 | 11575.2 |
165 | 2020-01-12 03:08:33 | traffic | 4 | 151207 | 847 | 11.923 | 12682.0 |