History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subway"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
264 | 2024-03-07 23:16:20 | subway | 3 | 112716 | 214 | 5.486 | 20546.1 |
263 | 2024-03-06 23:55:10 | subway | 2 | 82551 | 13 | 8.156 | 10121.5 |
262 | 2024-03-06 23:55:09 | subway | 3 | 112716 | 214 | 7.000 | 16102.3 |
261 | 2024-03-06 19:33:57 | subway | 1 | 48755 | 2 | 1.123 | 43415.0 |
260 | 2024-02-29 01:04:06 | subway | 1 | 48755 | 2 | 0.890 | 54780.9 |
259 | 2024-02-28 21:59:35 | subway | 2 | 82551 | 13 | 2.440 | 33832.4 |
258 | 2024-02-28 12:57:12 | subway | 2 | 82551 | 13 | 5.190 | 15905.8 |
257 | 2024-02-28 06:09:47 | subway | 3 | 112716 | 214 | 10.203 | 11047.3 |
256 | 2024-02-27 13:48:16 | subway | 3 | 112716 | 214 | 5.750 | 19602.8 |
255 | 2024-02-27 13:48:14 | subway | 2 | 82551 | 13 | 2.516 | 32810.4 |
254 | 2024-02-27 13:48:13 | subway | 1 | 48755 | 2 | 0.843 | 57835.1 |
253 | 2024-01-21 10:57:14 | subway | 1 | 48755 | 2 | 0.750 | 65006.7 |
252 | 2024-01-15 14:48:19 | subway | 3 | 112716 | 214 | 4.936 | 22835.5 |
251 | 2024-01-15 14:48:18 | subway | 2 | 82551 | 13 | 2.376 | 34743.7 |
250 | 2024-01-06 14:42:01 | subway | 3 | 112716 | 214 | 4.830 | 23336.6 |
249 | 2024-01-06 14:41:59 | subway | 2 | 82551 | 13 | 2.263 | 36478.6 |
248 | 2023-12-09 01:26:54 | subway | 1 | 48755 | 2 | 0.826 | 59025.4 |
247 | 2023-11-16 07:24:25 | subway | 1 | 48755 | 2 | 0.766 | 63648.8 |
246 | 2023-11-15 02:29:56 | subway | 1 | 48755 | 2 | 0.783 | 62266.9 |
245 | 2023-11-03 08:38:32 | subway | 1 | 48755 | 2 | 0.860 | 56691.9 |
244 | 2023-11-02 23:27:20 | subway | 1 | 48755 | 2 | 0.906 | 53813.5 |
243 | 2023-10-11 19:02:21 | subway | 1 | 48755 | 2 | 0.766 | 63648.8 |
242 | 2023-10-05 06:18:29 | subway | 1 | 48755 | 2 | 0.903 | 53992.2 |
241 | 2023-09-24 12:29:55 | subway | 1 | 48755 | 2 | 0.766 | 63648.8 |
240 | 2023-09-23 20:59:25 | subway | 1 | 48755 | 2 | 0.810 | 60191.4 |
239 | 2023-09-13 13:56:54 | subway | 1 | 48755 | 2 | 0.910 | 53576.9 |
238 | 2023-08-31 16:18:59 | subway | 1 | 48755 | 2 | 0.860 | 56691.9 |
237 | 2023-07-19 03:47:56 | subway | 1 | 48755 | 2 | 0.846 | 57630.0 |
236 | 2023-04-22 18:22:52 | subway | 1 | 48755 | 2 | 0.750 | 65006.7 |
235 | 2023-04-19 18:59:15 | subway | 1 | 48755 | 2 | 0.750 | 65006.7 |
234 | 2023-02-05 10:32:15 | subway | 1 | 48755 | 2 | 0.813 | 59969.2 |
233 | 2022-12-12 18:17:40 | subway | 1 | 48755 | 2 | 0.860 | 56691.9 |
232 | 2022-12-05 04:16:19 | subway | 1 | 48755 | 2 | 0.826 | 59025.4 |
231 | 2022-07-30 17:00:15 | subway | 1 | 48755 | 2 | 0.763 | 63899.1 |
230 | 2022-07-28 08:58:42 | subway | 1 | 48755 | 2 | 0.780 | 62506.4 |
229 | 2022-07-26 17:38:08 | subway | 1 | 48755 | 2 | 0.750 | 65006.7 |
228 | 2022-07-23 01:48:55 | subway | 1 | 48755 | 2 | 0.763 | 63899.1 |
227 | 2022-05-17 03:00:39 | subway | 1 | 48755 | 2 | 0.763 | 63899.1 |
226 | 2022-05-16 01:41:17 | subway | 1 | 48755 | 2 | 0.906 | 53813.5 |
225 | 2022-03-01 11:01:41 | subway | 1 | 48755 | 2 | 0.766 | 63648.8 |
224 | 2021-11-04 10:57:32 | subway | 1 | 48755 | 2 | 0.750 | 65006.7 |
223 | 2021-11-01 00:04:29 | subway | 1 | 48755 | 2 | 1.000 | 48755.0 |
222 | 2021-07-24 17:29:46 | subway | 1 | 48755 | 2 | 0.843 | 57835.1 |
221 | 2021-07-11 07:48:40 | subway | 1 | 48755 | 2 | 0.843 | 57835.1 |
220 | 2021-06-15 09:01:35 | subway | 1 | 48755 | 2 | 0.843 | 57835.1 |
219 | 2021-04-07 09:26:23 | subway | 1 | 48755 | 2 | 0.893 | 54596.9 |
218 | 2021-04-03 05:43:26 | subway | 1 | 48755 | 2 | 0.890 | 54780.9 |
217 | 2021-03-25 19:54:52 | subway | 1 | 48755 | 2 | 0.766 | 63648.8 |
216 | 2021-02-28 00:30:25 | subway | 1 | 48755 | 2 | 0.876 | 55656.4 |
215 | 2021-01-09 02:15:57 | subway | 1 | 48755 | 2 | 0.766 | 63648.8 |
214 | 2020-12-18 09:51:44 | subway | 1 | 48755 | 2 | 0.800 | 60943.8 |
213 | 2020-11-02 13:20:55 | subway | 1 | 48755 | 2 | 0.986 | 49447.3 |
212 | 2020-09-21 00:55:55 | subway | 1 | 48755 | 2 | 0.763 | 63899.1 |
211 | 2020-09-06 10:43:45 | subway | 1 | 48755 | 2 | 0.750 | 65006.7 |
210 | 2020-09-04 09:13:20 | subway | 1 | 48755 | 2 | 0.766 | 63648.8 |
209 | 2020-07-21 17:11:30 | subway | 1 | 48755 | 2 | 0.796 | 61250.0 |
208 | 2020-05-21 02:24:42 | subway | 1 | 48755 | 2 | 0.766 | 63648.8 |
207 | 2020-03-29 14:49:01 | subway | 1 | 48755 | 2 | 0.936 | 52088.7 |
206 | 2020-03-28 12:30:41 | subway | 1 | 48755 | 2 | 1.783 | 27344.4 |
205 | 2020-03-24 01:40:55 | subway | 1 | 48755 | 2 | 1.843 | 26454.2 |
204 | 2020-03-23 17:35:33 | subway | 1 | 48755 | 2 | 0.860 | 56691.9 |
203 | 2020-03-19 20:56:09 | subway | 1 | 48755 | 2 | 0.966 | 50471.0 |
202 | 2020-03-01 05:41:09 | subway | 1 | 48755 | 2 | 0.966 | 50471.0 |
201 | 2020-02-25 07:03:52 | subway | 1 | 48755 | 2 | 2.750 | 17729.1 |
200 | 2020-02-14 11:09:23 | subway | 1 | 48755 | 2 | 0.983 | 49598.2 |
199 | 2020-02-09 06:26:28 | subway | 1 | 48755 | 2 | 0.890 | 54780.9 |
198 | 2020-02-08 21:00:17 | subway | 1 | 48755 | 2 | 1.856 | 26268.9 |
197 | 2020-02-08 17:09:12 | subway | 1 | 48755 | 2 | 0.940 | 51867.0 |
196 | 2020-02-05 06:18:40 | subway | 1 | 48755 | 2 | 1.813 | 26891.9 |
195 | 2020-02-03 22:32:06 | subway | 1 | 48755 | 2 | 1.843 | 26454.2 |
194 | 2020-01-27 23:40:12 | subway | 1 | 48755 | 2 | 0.906 | 53813.5 |
193 | 2020-01-22 10:03:55 | subway | 1 | 48755 | 2 | 1.000 | 48755.0 |
192 | 2020-01-16 04:36:06 | subway | 1 | 48755 | 2 | 0.876 | 55656.4 |
191 | 2020-01-16 04:31:26 | subway | 1 | 48755 | 2 | 1.936 | 25183.4 |
190 | 2020-01-12 21:13:10 | subway | 1 | 48755 | 2 | 1.906 | 25579.7 |
189 | 2020-01-07 08:37:03 | subway | 1 | 48755 | 2 | 0.860 | 56691.9 |
188 | 2019-12-27 13:45:27 | subway | 1 | 48755 | 2 | 0.843 | 57835.1 |
187 | 2019-12-27 04:42:32 | subway | 1 | 48755 | 2 | 1.846 | 26411.2 |
186 | 2019-12-27 02:22:20 | subway | 1 | 48755 | 2 | 0.936 | 52088.7 |
185 | 2019-12-26 09:35:46 | subway | 1 | 48755 | 2 | 1.843 | 26454.2 |
184 | 2019-11-08 20:21:58 | subway | 1 | 48755 | 2 | 0.766 | 63648.8 |
183 | 2019-08-10 17:20:39 | subway | 1 | 48755 | 2 | 0.846 | 57630.0 |
182 | 2019-05-01 10:04:16 | subway | 1 | 48755 | 2 | 0.843 | 57835.1 |
181 | 2019-02-22 13:51:45 | subway | 1 | 48755 | 2 | 0.766 | 63648.8 |
180 | 2019-02-20 12:52:53 | subway | 1 | 48755 | 2 | 0.756 | 64490.7 |
179 | 2019-02-13 07:32:22 | subway | 1 | 48755 | 2 | 0.740 | 65885.1 |
178 | 2019-01-25 02:28:49 | subway | 1 | 48755 | 2 | 1.583 | 30799.1 |
177 | 2019-01-07 12:24:56 | subway | 1 | 48755 | 2 | 0.736 | 66243.2 |
176 | 2019-01-07 05:08:34 | subway | 1 | 48755 | 2 | 0.853 | 57157.1 |
175 | 2019-01-05 09:09:17 | subway | 1 | 48755 | 2 | 0.876 | 55656.4 |
174 | 2019-01-02 01:10:44 | subway | 1 | 48755 | 2 | 0.736 | 66243.2 |
173 | 2018-12-20 18:53:41 | subway | 1 | 48755 | 2 | 0.753 | 64747.7 |
172 | 2018-12-20 18:49:03 | subway | 1 | 48755 | 2 | 0.736 | 66243.2 |
171 | 2018-12-09 15:56:02 | subway | 1 | 48755 | 2 | 0.853 | 57157.1 |
170 | 2018-12-07 20:04:23 | subway | 1 | 48755 | 2 | 0.760 | 64151.3 |
169 | 2018-12-02 00:06:59 | subway | 1 | 48755 | 2 | 1.686 | 28917.6 |
168 | 2018-11-30 01:05:53 | subway | 1 | 48755 | 2 | 0.743 | 65619.1 |
167 | 2018-11-30 00:58:27 | subway | 1 | 48755 | 2 | 0.736 | 66243.2 |
166 | 2018-11-24 14:17:38 | subway | 1 | 48755 | 2 | 0.830 | 58741.0 |
165 | 2018-11-07 04:16:45 | subway | 1 | 48755 | 2 | 0.740 | 65885.1 |