History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"potholed"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
231 | 2024-04-06 08:27:38 | potholed | 2 | 121059 | 13 | 9.046 | 13382.6 |
230 | 2024-04-06 00:45:07 | potholed | 3 | 146162 | 118 | 18.486 | 7906.6 |
229 | 2024-04-05 11:10:09 | potholed | 2 | 121059 | 13 | 9.406 | 12870.4 |
228 | 2024-04-05 11:09:24 | potholed | 3 | 146162 | 118 | 9.126 | 16016.0 |
227 | 2024-04-05 07:22:43 | potholed | 3 | 146162 | 118 | 10.923 | 13381.1 |
226 | 2024-04-05 07:22:43 | potholed | 2 | 121059 | 13 | 4.470 | 27082.6 |
225 | 2024-04-05 07:22:41 | potholed | 1 | 82945 | 3 | 2.173 | 38170.7 |
224 | 2024-04-01 01:51:15 | potholed | 1 | 82945 | 3 | 1.640 | 50576.2 |
223 | 2024-03-30 21:09:48 | potholed | 2 | 121059 | 13 | 5.546 | 21828.2 |
222 | 2024-03-30 21:08:04 | potholed | 3 | 146162 | 118 | 8.656 | 16885.6 |
221 | 2024-03-30 07:35:59 | potholed | 2 | 121059 | 13 | 12.670 | 9554.8 |
220 | 2024-03-30 07:32:26 | potholed | 1 | 82945 | 3 | 3.016 | 27501.7 |
219 | 2024-03-30 01:54:49 | potholed | 3 | 146162 | 118 | 24.860 | 5879.4 |
218 | 2024-03-29 17:57:19 | potholed | 3 | 146162 | 118 | 8.530 | 17135.1 |
217 | 2024-03-29 17:57:22 | potholed | 2 | 121059 | 13 | 4.263 | 28397.6 |
216 | 2024-03-29 17:57:09 | potholed | 1 | 82945 | 3 | 1.420 | 58412.0 |
215 | 2024-03-29 08:16:13 | potholed | 1 | 82945 | 3 | 1.393 | 59544.1 |
214 | 2024-03-23 17:57:01 | potholed | 1 | 82945 | 3 | 4.233 | 19594.8 |
213 | 2024-03-05 23:20:32 | potholed | 1 | 82945 | 3 | 3.330 | 24908.4 |
212 | 2024-03-03 14:06:12 | potholed | 2 | 121059 | 13 | 3.546 | 34139.6 |
211 | 2024-03-03 14:05:56 | potholed | 3 | 146162 | 118 | 7.296 | 20033.2 |
210 | 2024-02-29 04:59:40 | potholed | 1 | 82945 | 3 | 1.546 | 53651.4 |
209 | 2024-02-26 23:42:24 | potholed | 2 | 121059 | 13 | 7.140 | 16955.0 |
208 | 2024-02-26 14:42:14 | potholed | 3 | 146162 | 118 | 7.750 | 18859.6 |
207 | 2024-02-26 02:17:27 | potholed | 1 | 82945 | 3 | 4.750 | 17462.1 |
206 | 2024-02-26 02:14:34 | potholed | 3 | 146162 | 118 | 15.516 | 9420.1 |
205 | 2024-02-26 00:28:23 | potholed | 3 | 146162 | 118 | 8.780 | 16647.2 |
204 | 2024-02-22 20:01:30 | potholed | 3 | 146162 | 118 | 7.530 | 19410.6 |
203 | 2024-02-22 20:01:31 | potholed | 2 | 121059 | 13 | 3.780 | 32026.2 |
202 | 2024-02-22 15:37:35 | potholed | 1 | 82945 | 3 | 1.436 | 57761.1 |
201 | 2024-01-14 12:33:20 | potholed | 2 | 121059 | 13 | 3.703 | 32692.1 |
200 | 2024-01-13 04:46:53 | potholed | 1 | 82945 | 3 | 1.280 | 64800.8 |
199 | 2024-01-02 15:59:17 | potholed | 1 | 82945 | 3 | 1.500 | 55296.7 |
198 | 2023-12-18 09:50:47 | potholed | 1 | 82945 | 3 | 1.466 | 56579.1 |
197 | 2023-11-20 17:14:09 | potholed | 3 | 146162 | 118 | 6.720 | 21750.3 |
196 | 2023-11-03 17:56:13 | potholed | 1 | 82945 | 3 | 1.406 | 58993.6 |
195 | 2023-10-23 10:40:03 | potholed | 2 | 121059 | 13 | 5.060 | 23924.7 |
194 | 2023-09-14 03:31:43 | potholed | 1 | 82945 | 3 | 1.373 | 60411.5 |
193 | 2023-08-29 11:40:41 | potholed | 1 | 82945 | 3 | 1.330 | 62364.7 |
192 | 2023-08-24 12:04:00 | potholed | 1 | 82945 | 3 | 1.500 | 55296.7 |
191 | 2023-08-21 13:27:06 | potholed | 3 | 146162 | 118 | 6.153 | 23754.6 |
190 | 2023-08-02 05:46:51 | potholed | 2 | 121059 | 13 | 3.203 | 37795.5 |
189 | 2023-05-27 07:41:08 | potholed | 1 | 82945 | 3 | 2.546 | 32578.6 |
188 | 2023-05-01 23:27:08 | potholed | 3 | 146162 | 118 | 6.156 | 23743.0 |
187 | 2023-04-29 20:40:40 | potholed | 1 | 82945 | 3 | 2.126 | 39014.6 |
186 | 2023-04-08 13:39:07 | potholed | 2 | 121059 | 13 | 3.720 | 32542.7 |
185 | 2023-03-21 20:11:06 | potholed | 1 | 82945 | 3 | 1.266 | 65517.4 |
184 | 2023-02-05 07:17:12 | potholed | 3 | 146162 | 118 | 6.140 | 23804.9 |
183 | 2023-01-08 07:07:25 | potholed | 1 | 82945 | 3 | 1.250 | 66356.0 |
182 | 2023-01-06 07:18:36 | potholed | 2 | 121059 | 13 | 3.343 | 36212.7 |
181 | 2023-01-02 15:13:48 | potholed | 1 | 82945 | 3 | 1.250 | 66356.0 |
180 | 2022-11-17 18:22:31 | potholed | 3 | 146162 | 118 | 6.233 | 23449.7 |
179 | 2022-10-03 09:52:00 | potholed | 1 | 82945 | 3 | 1.280 | 64800.8 |
178 | 2022-09-12 06:21:30 | potholed | 2 | 121059 | 13 | 3.140 | 38553.8 |
177 | 2022-09-01 14:17:49 | potholed | 1 | 82945 | 3 | 1.280 | 64800.8 |
176 | 2022-06-20 12:00:23 | potholed | 3 | 146162 | 118 | 7.190 | 20328.5 |
175 | 2022-05-17 11:38:24 | potholed | 1 | 82945 | 3 | 1.593 | 52068.4 |
174 | 2022-05-13 02:44:15 | potholed | 1 | 82945 | 3 | 1.436 | 57761.1 |
173 | 2022-04-18 08:02:25 | potholed | 1 | 82945 | 3 | 1.530 | 54212.4 |
172 | 2022-04-02 13:15:26 | potholed | 2 | 121059 | 13 | 3.873 | 31257.2 |
171 | 2022-01-27 17:38:50 | potholed | 1 | 82945 | 3 | 1.516 | 54713.1 |
170 | 2022-01-25 13:30:49 | potholed | 1 | 82945 | 3 | 1.516 | 54713.1 |
169 | 2022-01-02 01:21:08 | potholed | 2 | 121059 | 13 | 3.296 | 36729.1 |
168 | 2021-12-23 20:33:38 | potholed | 1 | 82945 | 3 | 1.563 | 53067.8 |
167 | 2021-11-16 19:51:49 | potholed | 1 | 82945 | 3 | 1.356 | 61168.9 |
166 | 2021-10-15 00:07:57 | potholed | 1 | 82945 | 3 | 2.656 | 31229.3 |
165 | 2021-09-10 05:06:10 | potholed | 1 | 82945 | 3 | 1.280 | 64800.8 |
164 | 2021-08-28 09:34:42 | potholed | 1 | 82945 | 3 | 1.296 | 64000.8 |
163 | 2021-06-09 07:35:42 | potholed | 1 | 82945 | 3 | 1.296 | 64000.8 |
162 | 2021-03-10 07:36:17 | potholed | 1 | 82945 | 3 | 1.550 | 53512.9 |
161 | 2021-01-01 13:17:28 | potholed | 1 | 82945 | 3 | 1.283 | 64649.3 |
160 | 2020-12-06 22:48:10 | potholed | 1 | 82945 | 3 | 1.326 | 62552.8 |
159 | 2020-11-06 23:12:41 | potholed | 1 | 82945 | 3 | 1.483 | 55930.5 |
158 | 2020-10-31 13:51:14 | potholed | 1 | 82945 | 3 | 1.343 | 61761.0 |
157 | 2020-10-30 08:58:13 | potholed | 1 | 82945 | 3 | 1.343 | 61761.0 |
156 | 2020-09-05 09:08:45 | potholed | 1 | 82945 | 3 | 1.266 | 65517.4 |
155 | 2020-08-22 04:10:11 | potholed | 1 | 82945 | 3 | 1.313 | 63172.1 |
154 | 2020-05-14 13:36:58 | potholed | 1 | 82945 | 3 | 1.390 | 59672.7 |
153 | 2020-03-30 00:24:23 | potholed | 1 | 82945 | 3 | 1.483 | 55930.5 |
152 | 2020-03-21 05:24:12 | potholed | 1 | 82945 | 3 | 1.453 | 57085.3 |
151 | 2020-03-05 19:14:41 | potholed | 1 | 82945 | 3 | 1.563 | 53067.8 |
150 | 2020-02-19 01:22:23 | potholed | 1 | 82945 | 3 | 3.156 | 26281.7 |
149 | 2020-02-13 06:15:26 | potholed | 1 | 82945 | 3 | 3.296 | 25165.4 |
148 | 2020-02-10 05:28:33 | potholed | 1 | 82945 | 3 | 1.986 | 41764.9 |
147 | 2020-02-06 01:56:47 | potholed | 1 | 82945 | 3 | 1.453 | 57085.3 |
146 | 2020-02-03 15:01:07 | potholed | 1 | 82945 | 3 | 3.826 | 21679.3 |
145 | 2020-02-03 13:40:31 | potholed | 1 | 82945 | 3 | 1.436 | 57761.1 |
144 | 2020-02-03 10:22:46 | potholed | 1 | 82945 | 3 | 3.250 | 25521.5 |
143 | 2020-02-01 11:53:44 | potholed | 1 | 82945 | 3 | 2.110 | 39310.4 |
142 | 2020-01-22 00:34:42 | potholed | 1 | 82945 | 3 | 2.280 | 36379.4 |
141 | 2020-01-20 12:49:59 | potholed | 1 | 82945 | 3 | 1.736 | 47779.4 |
140 | 2020-01-15 10:53:25 | potholed | 1 | 82945 | 3 | 3.140 | 26415.6 |
139 | 2020-01-11 16:58:38 | potholed | 1 | 82945 | 3 | 1.516 | 54713.1 |
138 | 2020-01-02 13:06:50 | potholed | 1 | 82945 | 3 | 1.623 | 51106.0 |
137 | 2019-12-30 02:53:28 | potholed | 1 | 82945 | 3 | 1.423 | 58288.8 |
136 | 2019-12-29 17:15:10 | potholed | 1 | 82945 | 3 | 2.720 | 30494.5 |
135 | 2019-11-02 06:54:24 | potholed | 1 | 82945 | 3 | 1.483 | 55930.5 |
134 | 2019-08-01 03:19:48 | potholed | 1 | 82945 | 3 | 1.260 | 65829.4 |
133 | 2019-06-16 12:30:04 | potholed | 2 | 121059 | 13 | 3.470 | 34887.3 |
132 | 2019-06-14 07:38:09 | potholed | 3 | 146162 | 118 | 7.296 | 20033.2 |