History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ratified"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
266 | 2024-05-16 11:41:51 | ratified | 2 | 121059 | 27 | 4.513 | 26824.5 |
265 | 2024-05-16 11:29:01 | ratified | 3 | 146162 | 189 | 16.703 | 8750.6 |
264 | 2024-05-16 10:51:45 | ratified | 1 | 82945 | 6 | 1.640 | 50576.2 |
263 | 2024-05-15 08:53:49 | ratified | 2 | 121059 | 27 | 4.313 | 28068.4 |
262 | 2024-05-09 20:59:57 | ratified | 1 | 82945 | 6 | 3.313 | 25036.2 |
261 | 2024-05-07 00:29:37 | ratified | 2 | 121059 | 27 | 4.280 | 28284.8 |
260 | 2024-05-07 00:27:48 | ratified | 3 | 146162 | 189 | 7.720 | 18932.9 |
259 | 2024-05-06 09:04:55 | ratified | 2 | 121059 | 27 | 4.233 | 28598.9 |
258 | 2024-05-05 20:44:48 | ratified | 2 | 121059 | 27 | 8.313 | 14562.6 |
257 | 2024-05-05 20:40:36 | ratified | 3 | 146162 | 189 | 8.626 | 16944.4 |
256 | 2024-05-05 19:06:08 | ratified | 3 | 146162 | 189 | 21.266 | 6873.0 |
255 | 2024-05-05 11:01:36 | ratified | 2 | 121059 | 27 | 8.970 | 13496.0 |
254 | 2024-05-05 11:01:32 | ratified | 3 | 146162 | 189 | 11.890 | 12292.9 |
253 | 2024-05-05 11:01:16 | ratified | 1 | 82945 | 6 | 1.906 | 43517.8 |
252 | 2024-05-05 11:01:05 | ratified | 2 | 121059 | 27 | 9.750 | 12416.3 |
251 | 2024-05-05 11:01:10 | ratified | 1 | 82945 | 6 | 1.563 | 53067.8 |
250 | 2024-05-05 11:01:01 | ratified | 3 | 146162 | 189 | 8.843 | 16528.6 |
249 | 2024-05-05 03:23:40 | ratified | 1 | 82945 | 6 | 1.470 | 56425.2 |
248 | 2024-04-08 04:46:32 | ratified | 1 | 82945 | 6 | 3.106 | 26704.8 |
247 | 2024-03-30 21:33:45 | ratified | 1 | 82945 | 6 | 6.716 | 12350.4 |
246 | 2024-03-04 23:10:44 | ratified | 1 | 82945 | 6 | 1.703 | 48705.2 |
245 | 2024-01-31 06:53:44 | ratified | 1 | 82945 | 6 | 1.580 | 52496.8 |
244 | 2024-01-13 14:23:47 | ratified | 1 | 82945 | 6 | 1.530 | 54212.4 |
243 | 2024-01-06 01:21:32 | ratified | 2 | 121059 | 27 | 3.860 | 31362.4 |
242 | 2023-12-08 10:48:25 | ratified | 1 | 82945 | 6 | 1.330 | 62364.7 |
241 | 2023-11-27 01:57:01 | ratified | 1 | 82945 | 6 | 1.766 | 46967.7 |
240 | 2023-11-23 11:29:36 | ratified | 1 | 82945 | 6 | 3.343 | 24811.5 |
239 | 2023-11-22 08:59:18 | ratified | 1 | 82945 | 6 | 1.343 | 61761.0 |
238 | 2023-11-05 00:51:34 | ratified | 1 | 82945 | 6 | 1.296 | 64000.8 |
237 | 2023-10-31 08:01:35 | ratified | 1 | 82945 | 6 | 3.173 | 26140.9 |
236 | 2023-10-12 21:02:09 | ratified | 2 | 121059 | 27 | 3.453 | 35059.1 |
235 | 2023-09-27 22:58:34 | ratified | 1 | 82945 | 6 | 1.440 | 57600.7 |
234 | 2023-08-29 18:27:44 | ratified | 1 | 82945 | 6 | 1.483 | 55930.5 |
233 | 2023-07-29 09:37:37 | ratified | 1 | 82945 | 6 | 1.470 | 56425.2 |
232 | 2023-07-26 13:00:47 | ratified | 2 | 121059 | 27 | 3.186 | 37997.2 |
231 | 2023-05-28 07:34:35 | ratified | 1 | 82945 | 6 | 1.280 | 64800.8 |
230 | 2023-04-10 02:40:40 | ratified | 1 | 82945 | 6 | 1.296 | 64000.8 |
229 | 2023-04-06 22:40:04 | ratified | 2 | 121059 | 27 | 3.610 | 33534.3 |
228 | 2023-03-22 15:32:00 | ratified | 1 | 82945 | 6 | 1.296 | 64000.8 |
227 | 2023-01-20 07:07:35 | ratified | 3 | 146162 | 189 | 6.513 | 22441.6 |
226 | 2023-01-08 20:58:47 | ratified | 1 | 82945 | 6 | 1.280 | 64800.8 |
225 | 2023-01-03 02:48:31 | ratified | 2 | 121059 | 27 | 3.200 | 37830.9 |
224 | 2022-12-21 03:06:28 | ratified | 1 | 82945 | 6 | 1.360 | 60989.0 |
223 | 2022-12-06 08:11:19 | ratified | 3 | 146162 | 189 | 7.220 | 20244.0 |
222 | 2022-10-31 02:11:08 | ratified | 3 | 146162 | 189 | 6.783 | 21548.3 |
221 | 2022-10-31 00:35:18 | ratified | 3 | 146162 | 189 | 6.856 | 21318.8 |
220 | 2022-10-06 20:55:45 | ratified | 1 | 82945 | 6 | 1.280 | 64800.8 |
219 | 2022-09-06 11:11:37 | ratified | 2 | 121059 | 27 | 3.313 | 36540.6 |
218 | 2022-08-25 11:05:39 | ratified | 3 | 146162 | 189 | 6.406 | 22816.4 |
217 | 2022-08-20 22:49:35 | ratified | 1 | 82945 | 6 | 1.500 | 55296.7 |
216 | 2022-05-26 00:28:30 | ratified | 1 | 82945 | 6 | 1.296 | 64000.8 |
215 | 2022-04-22 16:42:00 | ratified | 3 | 146162 | 189 | 9.076 | 16104.2 |
214 | 2022-04-20 08:59:53 | ratified | 1 | 82945 | 6 | 2.000 | 41472.5 |
213 | 2022-04-16 23:26:29 | ratified | 1 | 82945 | 6 | 1.283 | 64649.3 |
212 | 2022-03-24 22:51:50 | ratified | 3 | 146162 | 189 | 8.376 | 17450.1 |
211 | 2022-02-11 15:15:34 | ratified | 1 | 82945 | 6 | 1.623 | 51106.0 |
210 | 2022-02-09 11:47:24 | ratified | 1 | 82945 | 6 | 1.360 | 60989.0 |
209 | 2022-01-26 14:11:30 | ratified | 1 | 82945 | 6 | 1.593 | 52068.4 |
208 | 2021-12-25 19:38:46 | ratified | 1 | 82945 | 6 | 3.623 | 22894.0 |
207 | 2021-12-11 16:24:39 | ratified | 1 | 82945 | 6 | 1.546 | 53651.4 |
206 | 2021-11-29 01:51:48 | ratified | 1 | 82945 | 6 | 1.436 | 57761.1 |
205 | 2021-10-08 13:19:36 | ratified | 1 | 82945 | 6 | 1.343 | 61761.0 |
204 | 2021-10-06 11:49:09 | ratified | 1 | 82945 | 6 | 1.516 | 54713.1 |
203 | 2021-09-15 05:30:21 | ratified | 1 | 82945 | 6 | 1.283 | 64649.3 |
202 | 2021-09-12 04:32:46 | ratified | 1 | 82945 | 6 | 1.346 | 61623.3 |
201 | 2021-07-23 11:10:07 | ratified | 1 | 82945 | 6 | 1.313 | 63172.1 |
200 | 2021-06-11 21:37:09 | ratified | 1 | 82945 | 6 | 1.466 | 56579.1 |
199 | 2021-05-13 03:20:47 | ratified | 1 | 82945 | 6 | 1.403 | 59119.7 |
198 | 2021-05-03 07:07:23 | ratified | 1 | 82945 | 6 | 1.450 | 57203.4 |
197 | 2021-04-11 23:42:21 | ratified | 1 | 82945 | 6 | 1.420 | 58412.0 |
196 | 2021-03-15 22:48:48 | ratified | 1 | 82945 | 6 | 2.953 | 28088.4 |
195 | 2021-03-08 20:31:12 | ratified | 1 | 82945 | 6 | 1.423 | 58288.8 |
194 | 2020-12-05 09:24:50 | ratified | 1 | 82945 | 6 | 1.280 | 64800.8 |
193 | 2020-11-30 19:13:32 | ratified | 1 | 82945 | 6 | 1.296 | 64000.8 |
192 | 2020-11-19 04:17:31 | ratified | 1 | 82945 | 6 | 1.423 | 58288.8 |
191 | 2020-10-25 14:13:35 | ratified | 1 | 82945 | 6 | 1.313 | 63172.1 |
190 | 2020-10-19 20:15:30 | ratified | 1 | 82945 | 6 | 1.436 | 57761.1 |
189 | 2020-10-08 23:56:57 | ratified | 1 | 82945 | 6 | 1.310 | 63316.8 |
188 | 2020-09-21 08:09:29 | ratified | 1 | 82945 | 6 | 1.313 | 63172.1 |
187 | 2020-09-02 17:17:09 | ratified | 1 | 82945 | 6 | 1.326 | 62552.8 |
186 | 2020-08-02 00:55:52 | ratified | 1 | 82945 | 6 | 1.406 | 58993.6 |
185 | 2020-07-28 08:45:09 | ratified | 1 | 82945 | 6 | 1.466 | 56579.1 |
184 | 2020-05-28 18:27:21 | ratified | 1 | 82945 | 6 | 1.453 | 57085.3 |
183 | 2020-03-29 21:46:37 | ratified | 1 | 82945 | 6 | 2.326 | 35659.9 |
182 | 2020-03-29 13:59:47 | ratified | 1 | 82945 | 6 | 1.796 | 46183.2 |
181 | 2020-03-29 06:42:59 | ratified | 1 | 82945 | 6 | 1.280 | 64800.8 |
180 | 2020-03-27 05:29:19 | ratified | 1 | 82945 | 6 | 1.403 | 59119.7 |
179 | 2020-03-21 09:51:34 | ratified | 1 | 82945 | 6 | 1.296 | 64000.8 |
178 | 2020-03-08 07:45:24 | ratified | 1 | 82945 | 6 | 1.283 | 64649.3 |
177 | 2020-03-03 15:43:05 | ratified | 1 | 82945 | 6 | 1.440 | 57600.7 |
176 | 2020-02-28 00:02:48 | ratified | 1 | 82945 | 6 | 4.970 | 16689.1 |
175 | 2020-02-27 21:44:20 | ratified | 1 | 82945 | 6 | 1.593 | 52068.4 |
174 | 2020-02-27 03:31:20 | ratified | 1 | 82945 | 6 | 1.783 | 46519.9 |
173 | 2020-02-25 12:15:45 | ratified | 1 | 82945 | 6 | 1.546 | 53651.4 |
172 | 2020-02-18 02:29:12 | ratified | 1 | 82945 | 6 | 1.703 | 48705.2 |
171 | 2020-02-13 02:32:06 | ratified | 1 | 82945 | 6 | 1.606 | 51646.9 |
170 | 2020-02-09 13:17:26 | ratified | 1 | 82945 | 6 | 3.063 | 27079.7 |
169 | 2020-02-02 00:30:45 | ratified | 1 | 82945 | 6 | 1.500 | 55296.7 |
168 | 2020-01-30 17:03:21 | ratified | 1 | 82945 | 6 | 3.373 | 24590.9 |
167 | 2020-01-30 15:10:49 | ratified | 1 | 82945 | 6 | 3.326 | 24938.4 |