History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substation"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
274 | 2024-04-28 00:42:21 | substation | 3 | 140603 | 57 | 22.796 | 6167.9 |
273 | 2024-04-27 17:44:12 | substation | 1 | 67641 | 2 | 1.606 | 42117.7 |
272 | 2024-04-26 15:18:35 | substation | 3 | 140603 | 57 | 6.486 | 21677.9 |
271 | 2024-04-26 05:56:56 | substation | 1 | 67641 | 2 | 1.203 | 56226.9 |
270 | 2024-04-06 05:37:24 | substation | 1 | 67641 | 2 | 1.186 | 57032.9 |
269 | 2024-04-02 07:44:06 | substation | 3 | 140603 | 57 | 7.563 | 18590.9 |
268 | 2024-04-02 07:42:28 | substation | 4 | 161450 | 292 | 34.440 | 4687.9 |
267 | 2024-04-02 07:42:30 | substation | 2 | 108824 | 7 | 8.013 | 13580.9 |
266 | 2024-04-02 06:46:18 | substation | 1 | 67641 | 2 | 1.216 | 55625.8 |
265 | 2024-04-01 21:12:10 | substation | 1 | 67641 | 2 | 1.030 | 65670.9 |
264 | 2024-03-28 00:05:49 | substation | 2 | 108824 | 7 | 7.546 | 14421.4 |
263 | 2024-03-27 22:21:03 | substation | 1 | 67641 | 2 | 1.093 | 61885.6 |
262 | 2024-03-27 18:11:23 | substation | 3 | 140603 | 57 | 11.953 | 11763.0 |
261 | 2024-03-26 13:08:04 | substation | 1 | 67641 | 2 | 1.296 | 52192.1 |
260 | 2024-03-26 09:07:17 | substation | 3 | 140603 | 57 | 10.656 | 13194.7 |
259 | 2024-03-25 04:48:37 | substation | 1 | 67641 | 2 | 1.140 | 59334.2 |
258 | 2024-03-25 04:01:03 | substation | 1 | 67641 | 2 | 1.156 | 58513.0 |
257 | 2024-03-24 08:41:47 | substation | 4 | 161450 | 292 | 28.250 | 5715.0 |
256 | 2024-03-24 08:23:40 | substation | 4 | 161450 | 292 | 30.423 | 5306.8 |
255 | 2024-03-24 08:23:35 | substation | 3 | 140603 | 57 | 15.250 | 9219.9 |
254 | 2024-03-23 12:07:58 | substation | 4 | 161450 | 292 | 29.003 | 5566.7 |
253 | 2024-03-22 05:46:51 | substation | 4 | 161450 | 292 | 28.283 | 5708.4 |
252 | 2024-03-22 05:46:50 | substation | 3 | 140603 | 57 | 19.390 | 7251.3 |
251 | 2024-03-22 05:46:55 | substation | 2 | 108824 | 7 | 3.593 | 30287.8 |
250 | 2024-03-08 06:00:47 | substation | 2 | 108824 | 7 | 7.313 | 14880.9 |
249 | 2024-03-08 05:59:58 | substation | 1 | 67641 | 2 | 1.343 | 50365.6 |
248 | 2024-03-03 03:43:41 | substation | 1 | 67641 | 2 | 2.626 | 25758.2 |
247 | 2024-03-02 11:44:26 | substation | 3 | 140603 | 57 | 15.423 | 9116.4 |
246 | 2024-03-02 11:44:24 | substation | 3 | 140603 | 57 | 15.750 | 8927.2 |
245 | 2024-03-02 11:44:21 | substation | 2 | 108824 | 7 | 7.110 | 15305.8 |
244 | 2024-03-02 11:43:31 | substation | 1 | 67641 | 2 | 1.200 | 56367.5 |
243 | 2024-02-18 10:49:48 | substation | 3 | 140603 | 57 | 30.033 | 4681.6 |
242 | 2024-02-13 14:07:32 | substation | 1 | 67641 | 2 | 3.280 | 20622.3 |
241 | 2024-02-13 09:01:30 | substation | 2 | 108824 | 7 | 6.970 | 15613.2 |
240 | 2024-02-13 08:43:11 | substation | 3 | 140603 | 57 | 9.313 | 15097.5 |
239 | 2024-02-12 14:43:48 | substation | 2 | 108824 | 7 | 9.843 | 11056.0 |
238 | 2024-02-12 14:43:47 | substation | 3 | 140603 | 57 | 8.563 | 16419.8 |
237 | 2024-02-09 22:44:52 | substation | 4 | 161450 | 292 | 17.016 | 9488.1 |
236 | 2024-02-08 16:20:20 | substation | 4 | 161450 | 292 | 16.110 | 10021.7 |
235 | 2024-02-08 14:29:12 | substation | 1 | 67641 | 2 | 1.156 | 58513.0 |
234 | 2024-01-31 05:39:14 | substation | 1 | 67641 | 2 | 1.233 | 54858.9 |
233 | 2024-01-30 22:42:16 | substation | 1 | 67641 | 2 | 2.546 | 26567.6 |
232 | 2024-01-30 22:42:11 | substation | 1 | 67641 | 2 | 1.250 | 54112.8 |
231 | 2024-01-12 19:33:41 | substation | 4 | 161450 | 292 | 11.220 | 14389.5 |
230 | 2024-01-08 01:33:40 | substation | 2 | 108824 | 7 | 2.940 | 37015.0 |
229 | 2024-01-08 01:33:36 | substation | 3 | 140603 | 57 | 5.983 | 23500.4 |
228 | 2023-12-24 16:11:20 | substation | 1 | 67641 | 2 | 1.140 | 59334.2 |
227 | 2023-12-23 16:17:46 | substation | 3 | 140603 | 57 | 5.626 | 24991.6 |
226 | 2023-12-23 16:17:45 | substation | 2 | 108824 | 7 | 2.983 | 36481.4 |
225 | 2023-12-23 15:37:29 | substation | 1 | 67641 | 2 | 1.016 | 66575.8 |
224 | 2023-12-15 07:23:00 | substation | 3 | 140603 | 57 | 5.266 | 26700.2 |
223 | 2023-12-06 09:48:38 | substation | 1 | 67641 | 2 | 1.046 | 64666.3 |
222 | 2023-12-06 09:46:04 | substation | 3 | 140603 | 57 | 6.390 | 22003.6 |
221 | 2023-11-24 21:44:09 | substation | 1 | 67641 | 2 | 1.000 | 67641.0 |
220 | 2023-11-18 10:18:08 | substation | 4 | 161450 | 292 | 26.673 | 6052.9 |
219 | 2023-11-18 06:34:50 | substation | 4 | 161450 | 292 | 25.516 | 6327.4 |
218 | 2023-11-14 19:58:50 | substation | 1 | 67641 | 2 | 1.126 | 60071.9 |
217 | 2023-11-12 18:13:21 | substation | 1 | 67641 | 2 | 1.200 | 56367.5 |
216 | 2023-11-12 17:44:14 | substation | 4 | 161450 | 292 | 13.406 | 12043.1 |
215 | 2023-11-07 08:56:47 | substation | 1 | 67641 | 2 | 1.170 | 57812.8 |
214 | 2023-11-02 18:50:54 | substation | 4 | 161450 | 292 | 30.236 | 5339.7 |
213 | 2023-10-29 04:48:50 | substation | 4 | 161450 | 292 | 14.156 | 11405.1 |
212 | 2023-10-22 00:13:15 | substation | 4 | 161450 | 292 | 19.610 | 8233.0 |
211 | 2023-10-11 02:30:28 | substation | 1 | 67641 | 2 | 1.063 | 63632.2 |
210 | 2023-10-06 11:04:26 | substation | 4 | 161450 | 292 | 10.046 | 16071.1 |
209 | 2023-10-06 11:04:25 | substation | 3 | 140603 | 57 | 6.313 | 22272.0 |
208 | 2023-10-06 11:04:24 | substation | 2 | 108824 | 7 | 2.903 | 37486.7 |
207 | 2023-10-03 11:12:44 | substation | 1 | 67641 | 2 | 1.173 | 57665.0 |
206 | 2023-09-14 13:41:24 | substation | 3 | 140603 | 57 | 5.330 | 26379.5 |
205 | 2023-08-12 04:16:46 | substation | 1 | 67641 | 2 | 1.046 | 64666.3 |
204 | 2023-08-08 11:59:35 | substation | 1 | 67641 | 2 | 1.033 | 65480.2 |
203 | 2023-08-06 14:11:02 | substation | 1 | 67641 | 2 | 1.046 | 64666.3 |
202 | 2023-07-31 18:20:09 | substation | 4 | 161450 | 292 | 9.266 | 17423.9 |
201 | 2023-05-21 00:35:38 | substation | 1 | 67641 | 2 | 1.030 | 65670.9 |
200 | 2023-05-06 11:48:39 | substation | 1 | 67641 | 2 | 1.123 | 60232.4 |
199 | 2023-04-12 10:24:39 | substation | 4 | 161450 | 292 | 9.080 | 17780.8 |
198 | 2023-04-08 22:13:51 | substation | 1 | 67641 | 2 | 0.983 | 68810.8 |
197 | 2023-04-01 21:17:50 | substation | 1 | 67641 | 2 | 1.110 | 60937.8 |
196 | 2023-03-12 06:00:52 | substation | 3 | 140603 | 57 | 5.296 | 26548.9 |
195 | 2023-03-01 20:30:08 | substation | 1 | 67641 | 2 | 1.033 | 65480.2 |
194 | 2023-01-18 23:35:13 | substation | 4 | 161450 | 292 | 10.860 | 14866.5 |
193 | 2022-12-25 22:22:08 | substation | 1 | 67641 | 2 | 1.030 | 65670.9 |
192 | 2022-12-17 00:15:01 | substation | 3 | 140603 | 57 | 5.220 | 26935.4 |
191 | 2022-12-06 22:16:14 | substation | 1 | 67641 | 2 | 1.140 | 59334.2 |
190 | 2022-10-29 03:15:07 | substation | 4 | 161450 | 292 | 9.173 | 17600.6 |
189 | 2022-09-13 18:28:12 | substation | 1 | 67641 | 2 | 1.016 | 66575.8 |
188 | 2022-08-08 22:19:32 | substation | 3 | 140603 | 57 | 5.343 | 26315.4 |
187 | 2022-07-20 03:18:51 | substation | 1 | 67641 | 2 | 1.016 | 66575.8 |
186 | 2022-07-19 14:38:11 | substation | 1 | 67641 | 2 | 1.080 | 62630.6 |
185 | 2022-06-30 21:55:42 | substation | 1 | 67641 | 2 | 1.080 | 62630.6 |
184 | 2022-05-23 19:40:46 | substation | 4 | 161450 | 292 | 9.436 | 17110.0 |
183 | 2022-03-18 19:02:38 | substation | 1 | 67641 | 2 | 1.046 | 64666.3 |
182 | 2022-03-05 14:39:06 | substation | 1 | 67641 | 2 | 1.013 | 66773.0 |
181 | 2021-11-18 17:35:38 | substation | 1 | 67641 | 2 | 1.140 | 59334.2 |
180 | 2021-11-05 05:04:32 | substation | 1 | 67641 | 2 | 1.110 | 60937.8 |
179 | 2021-07-19 03:35:48 | substation | 1 | 67641 | 2 | 1.000 | 67641.0 |
178 | 2021-07-16 00:00:12 | substation | 1 | 67641 | 2 | 1.063 | 63632.2 |
177 | 2021-05-31 14:36:58 | substation | 1 | 67641 | 2 | 1.186 | 57032.9 |
176 | 2021-05-17 03:50:29 | substation | 2 | 108824 | 7 | 2.716 | 40067.7 |
175 | 2021-05-06 20:52:48 | substation | 4 | 161450 | 292 | 11.470 | 14075.9 |