History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prairie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
246 | 2024-04-29 11:41:28 | prairie | 1 | 69583 | 2 | 4.233 | 16438.2 |
245 | 2024-04-27 23:58:46 | prairie | 1 | 69583 | 2 | 1.360 | 51164.0 |
244 | 2024-04-20 04:41:55 | prairie | 1 | 69583 | 2 | 2.703 | 25742.9 |
243 | 2024-04-05 07:11:26 | prairie | 3 | 134027 | 111 | 20.360 | 6582.9 |
242 | 2024-04-03 19:55:37 | prairie | 3 | 134027 | 111 | 16.706 | 8022.7 |
241 | 2024-04-03 19:55:24 | prairie | 2 | 107671 | 3 | 3.983 | 27032.6 |
240 | 2024-04-03 19:55:16 | prairie | 1 | 69583 | 2 | 1.326 | 52475.9 |
239 | 2024-04-03 16:05:44 | prairie | 3 | 134027 | 111 | 14.656 | 9144.9 |
238 | 2024-04-03 16:05:44 | prairie | 2 | 107671 | 3 | 7.423 | 14505.1 |
237 | 2024-04-03 16:05:36 | prairie | 1 | 69583 | 2 | 1.466 | 47464.5 |
236 | 2024-04-03 16:05:18 | prairie | 3 | 134027 | 111 | 13.610 | 9847.7 |
235 | 2024-04-03 16:05:17 | prairie | 2 | 107671 | 3 | 8.143 | 13222.5 |
234 | 2024-04-03 16:04:45 | prairie | 1 | 69583 | 2 | 1.563 | 44518.9 |
233 | 2024-03-31 12:09:09 | prairie | 1 | 69583 | 2 | 2.843 | 24475.2 |
232 | 2024-03-15 00:20:24 | prairie | 1 | 69583 | 2 | 3.153 | 22068.8 |
231 | 2024-02-09 22:30:10 | prairie | 1 | 69583 | 2 | 2.203 | 31585.6 |
230 | 2024-01-15 01:44:49 | prairie | 2 | 107671 | 3 | 3.546 | 30364.1 |
229 | 2024-01-12 07:12:17 | prairie | 3 | 134027 | 111 | 6.063 | 22105.7 |
228 | 2023-12-31 07:15:21 | prairie | 1 | 69583 | 2 | 1.280 | 54361.7 |
227 | 2023-12-15 09:38:50 | prairie | 1 | 69583 | 2 | 1.263 | 55093.4 |
226 | 2023-11-17 00:28:33 | prairie | 1 | 69583 | 2 | 1.076 | 64668.2 |
225 | 2023-10-21 00:54:13 | prairie | 1 | 69583 | 2 | 1.200 | 57985.8 |
224 | 2023-10-18 09:04:11 | prairie | 1 | 69583 | 2 | 1.080 | 64428.7 |
223 | 2023-10-15 13:32:55 | prairie | 1 | 69583 | 2 | 1.110 | 62687.4 |
222 | 2023-09-29 16:11:49 | prairie | 1 | 69583 | 2 | 1.076 | 64668.2 |
221 | 2023-09-16 10:09:37 | prairie | 1 | 69583 | 2 | 1.610 | 43219.3 |
220 | 2023-08-17 05:39:52 | prairie | 1 | 69583 | 2 | 1.110 | 62687.4 |
219 | 2023-07-31 13:28:28 | prairie | 1 | 69583 | 2 | 1.140 | 61037.7 |
218 | 2023-05-16 23:50:07 | prairie | 1 | 69583 | 2 | 1.076 | 64668.2 |
217 | 2023-04-26 20:23:37 | prairie | 1 | 69583 | 2 | 1.203 | 57841.2 |
216 | 2023-03-12 13:55:18 | prairie | 1 | 69583 | 2 | 1.076 | 64668.2 |
215 | 2023-01-01 22:05:15 | prairie | 1 | 69583 | 2 | 1.186 | 58670.3 |
214 | 2022-12-26 20:45:48 | prairie | 1 | 69583 | 2 | 1.140 | 61037.7 |
213 | 2022-09-23 08:15:57 | prairie | 1 | 69583 | 2 | 1.063 | 65459.1 |
212 | 2022-08-19 10:25:01 | prairie | 1 | 69583 | 2 | 1.093 | 63662.4 |
211 | 2022-05-16 03:15:46 | prairie | 1 | 69583 | 2 | 1.283 | 54234.6 |
210 | 2022-04-08 11:36:51 | prairie | 1 | 69583 | 2 | 1.513 | 45990.1 |
209 | 2022-04-05 00:58:04 | prairie | 1 | 69583 | 2 | 1.423 | 48898.8 |
208 | 2021-12-14 19:27:41 | prairie | 1 | 69583 | 2 | 1.236 | 56296.9 |
207 | 2021-08-31 23:42:17 | prairie | 1 | 69583 | 2 | 1.203 | 57841.2 |
206 | 2021-05-24 12:48:01 | prairie | 1 | 69583 | 2 | 1.233 | 56433.9 |
205 | 2021-04-28 07:26:58 | prairie | 1 | 69583 | 2 | 1.280 | 54361.7 |
204 | 2021-03-28 04:11:09 | prairie | 1 | 69583 | 2 | 2.390 | 29114.2 |
203 | 2021-02-24 12:30:59 | prairie | 3 | 134027 | 111 | 6.456 | 20760.1 |
202 | 2021-02-18 23:38:07 | prairie | 1 | 69583 | 2 | 1.080 | 64428.7 |
201 | 2021-01-11 11:22:48 | prairie | 1 | 69583 | 2 | 1.200 | 57985.8 |
200 | 2020-11-18 01:57:40 | prairie | 3 | 134027 | 111 | 7.813 | 17154.4 |
199 | 2020-11-15 01:46:46 | prairie | 1 | 69583 | 2 | 1.143 | 60877.5 |
198 | 2020-11-06 16:00:47 | prairie | 1 | 69583 | 2 | 1.266 | 54962.9 |
197 | 2020-10-31 21:27:19 | prairie | 1 | 69583 | 2 | 1.203 | 57841.2 |
196 | 2020-10-23 19:13:19 | prairie | 1 | 69583 | 2 | 1.186 | 58670.3 |
195 | 2020-08-10 09:29:16 | prairie | 1 | 69583 | 2 | 1.250 | 55666.4 |
194 | 2020-05-09 04:05:07 | prairie | 1 | 69583 | 2 | 1.093 | 63662.4 |
193 | 2020-03-29 21:53:20 | prairie | 1 | 69583 | 2 | 1.236 | 56296.9 |
192 | 2020-03-26 14:40:17 | prairie | 1 | 69583 | 2 | 1.263 | 55093.4 |
191 | 2020-03-24 04:33:52 | prairie | 1 | 69583 | 2 | 1.266 | 54962.9 |
190 | 2020-03-21 02:50:29 | prairie | 1 | 69583 | 2 | 1.206 | 57697.3 |
189 | 2020-02-26 00:08:09 | prairie | 1 | 69583 | 2 | 1.440 | 48321.5 |
188 | 2020-02-25 20:58:45 | prairie | 1 | 69583 | 2 | 1.376 | 50569.0 |
187 | 2020-02-22 14:45:21 | prairie | 1 | 69583 | 2 | 1.250 | 55666.4 |
186 | 2020-02-21 04:43:05 | prairie | 1 | 69583 | 2 | 1.296 | 53690.6 |
185 | 2020-02-07 02:52:23 | prairie | 1 | 69583 | 2 | 1.343 | 51811.6 |
184 | 2020-02-06 19:56:32 | prairie | 1 | 69583 | 2 | 2.736 | 25432.4 |
183 | 2020-02-03 23:26:19 | prairie | 1 | 69583 | 2 | 1.513 | 45990.1 |
182 | 2020-02-03 16:02:50 | prairie | 1 | 69583 | 2 | 1.326 | 52475.9 |
181 | 2020-01-31 17:02:20 | prairie | 1 | 69583 | 2 | 2.393 | 29077.7 |
180 | 2020-01-27 18:48:13 | prairie | 1 | 69583 | 2 | 2.453 | 28366.5 |
179 | 2020-01-27 16:29:01 | prairie | 1 | 69583 | 2 | 1.186 | 58670.3 |
178 | 2020-01-24 03:29:56 | prairie | 1 | 69583 | 2 | 4.046 | 17198.0 |
177 | 2020-01-18 11:09:23 | prairie | 1 | 69583 | 2 | 1.296 | 53690.6 |
176 | 2020-01-11 21:19:41 | prairie | 1 | 69583 | 2 | 1.250 | 55666.4 |
175 | 2020-01-08 20:15:40 | prairie | 1 | 69583 | 2 | 1.123 | 61961.7 |
174 | 2020-01-07 15:04:05 | prairie | 1 | 69583 | 2 | 1.390 | 50059.7 |
173 | 2020-01-07 13:39:35 | prairie | 1 | 69583 | 2 | 1.096 | 63488.1 |
172 | 2019-12-27 05:11:35 | prairie | 1 | 69583 | 2 | 1.780 | 39091.6 |
171 | 2019-12-25 09:33:03 | prairie | 1 | 69583 | 2 | 1.250 | 55666.4 |
170 | 2019-10-27 11:56:06 | prairie | 1 | 69583 | 2 | 1.250 | 55666.4 |
169 | 2019-09-09 22:35:16 | prairie | 1 | 69583 | 2 | 1.003 | 69374.9 |
168 | 2019-07-29 13:34:22 | prairie | 1 | 69583 | 2 | 1.163 | 59830.6 |
167 | 2019-06-25 12:48:39 | prairie | 1 | 69583 | 2 | 1.083 | 64250.2 |
166 | 2019-06-13 03:53:14 | prairie | 1 | 69583 | 2 | 1.223 | 56895.3 |
165 | 2019-05-30 01:28:39 | prairie | 1 | 69583 | 2 | 1.203 | 57841.2 |
164 | 2019-04-28 07:50:54 | prairie | 1 | 69583 | 2 | 1.076 | 64668.2 |
163 | 2019-04-22 06:16:35 | prairie | 1 | 69583 | 2 | 1.230 | 56571.5 |
162 | 2019-02-25 13:01:41 | prairie | 1 | 69583 | 2 | 1.170 | 59472.6 |
161 | 2019-02-04 22:00:25 | prairie | 1 | 69583 | 2 | 1.353 | 51428.7 |
160 | 2019-01-30 14:05:44 | prairie | 1 | 69583 | 2 | 2.186 | 31831.2 |
159 | 2019-01-21 21:25:40 | prairie | 1 | 69583 | 2 | 1.150 | 60507.0 |
158 | 2019-01-11 00:06:07 | prairie | 3 | 134027 | 111 | 6.133 | 21853.4 |
157 | 2019-01-08 10:49:09 | prairie | 3 | 134027 | 111 | 6.283 | 21331.7 |
156 | 2018-12-30 02:50:18 | prairie | 1 | 69583 | 2 | 1.183 | 58819.1 |
155 | 2018-12-15 18:19:33 | prairie | 3 | 134027 | 111 | 6.286 | 21321.5 |
154 | 2018-12-10 07:33:22 | prairie | 1 | 69583 | 2 | 1.133 | 61414.8 |
153 | 2018-12-05 18:34:05 | prairie | 3 | 134027 | 111 | 5.933 | 22590.1 |
152 | 2018-12-04 13:40:17 | prairie | 1 | 69583 | 2 | 1.066 | 65274.9 |
151 | 2018-11-24 12:48:33 | prairie | 3 | 134027 | 111 | 5.900 | 22716.4 |
150 | 2018-11-13 17:35:33 | prairie | 1 | 69583 | 2 | 1.110 | 62687.4 |
149 | 2018-11-05 21:40:30 | prairie | 1 | 69583 | 2 | 1.130 | 61577.9 |
148 | 2018-10-30 09:04:43 | prairie | 3 | 134027 | 111 | 6.230 | 21513.2 |
147 | 2018-10-28 03:29:48 | prairie | 3 | 134027 | 111 | 6.063 | 22105.7 |