History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drainage"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
242 | 2024-03-25 10:19:01 | drainage | 4 | 161609 | 844 | 11.220 | 14403.7 |
241 | 2024-03-08 16:30:00 | drainage | 3 | 146162 | 71 | 21.066 | 6938.3 |
240 | 2024-03-07 13:57:05 | drainage | 3 | 146162 | 71 | 7.796 | 18748.3 |
239 | 2024-03-07 11:18:03 | drainage | 1 | 82945 | 2 | 4.296 | 19307.5 |
238 | 2024-03-06 23:00:04 | drainage | 4 | 161609 | 844 | 44.703 | 3615.2 |
237 | 2024-03-06 20:09:27 | drainage | 3 | 146162 | 71 | 24.190 | 6042.2 |
236 | 2024-03-06 13:53:13 | drainage | 2 | 121059 | 4 | 4.326 | 27984.0 |
235 | 2024-03-06 13:47:10 | drainage | 2 | 121059 | 4 | 7.796 | 15528.3 |
234 | 2024-03-06 09:46:10 | drainage | 4 | 161609 | 844 | 39.143 | 4128.7 |
233 | 2024-03-06 08:36:46 | drainage | 4 | 161609 | 844 | 42.036 | 3844.5 |
232 | 2024-03-06 08:37:06 | drainage | 3 | 146162 | 71 | 17.906 | 8162.7 |
231 | 2024-03-05 22:20:40 | drainage | 3 | 146162 | 71 | 14.326 | 10202.6 |
230 | 2024-03-05 18:32:12 | drainage | 4 | 161609 | 844 | 29.830 | 5417.7 |
229 | 2024-03-05 11:36:33 | drainage | 4 | 161609 | 844 | 20.923 | 7724.0 |
228 | 2024-03-05 11:36:34 | drainage | 2 | 121059 | 4 | 8.533 | 14187.2 |
227 | 2024-03-05 11:36:34 | drainage | 3 | 146162 | 71 | 8.643 | 16911.0 |
226 | 2024-03-05 11:36:27 | drainage | 1 | 82945 | 2 | 1.483 | 55930.5 |
225 | 2024-02-29 17:31:33 | drainage | 1 | 82945 | 2 | 3.156 | 26281.7 |
224 | 2024-02-28 11:27:32 | drainage | 1 | 82945 | 2 | 3.093 | 26817.0 |
223 | 2024-02-20 09:10:38 | drainage | 1 | 82945 | 2 | 2.640 | 31418.6 |
222 | 2024-02-05 05:38:19 | drainage | 2 | 121059 | 4 | 3.780 | 32026.2 |
221 | 2024-01-31 05:13:07 | drainage | 2 | 121059 | 4 | 3.843 | 31501.2 |
220 | 2024-01-31 05:12:47 | drainage | 3 | 146162 | 71 | 8.080 | 18089.4 |
219 | 2024-01-31 03:32:59 | drainage | 4 | 161609 | 844 | 19.873 | 8132.1 |
218 | 2024-01-31 01:41:27 | drainage | 4 | 161609 | 844 | 12.656 | 12769.4 |
217 | 2024-01-30 22:54:41 | drainage | 1 | 82945 | 2 | 1.580 | 52496.8 |
216 | 2024-01-30 22:52:27 | drainage | 4 | 161609 | 844 | 13.763 | 11742.3 |
215 | 2024-01-30 22:52:23 | drainage | 3 | 146162 | 71 | 9.733 | 15017.2 |
214 | 2024-01-30 22:52:19 | drainage | 2 | 121059 | 4 | 5.596 | 21633.1 |
213 | 2024-01-20 11:38:09 | drainage | 2 | 121059 | 4 | 3.263 | 37100.5 |
212 | 2024-01-02 14:53:02 | drainage | 3 | 146162 | 71 | 6.643 | 22002.4 |
211 | 2024-01-01 04:50:59 | drainage | 2 | 121059 | 4 | 3.750 | 32282.4 |
210 | 2023-12-08 13:53:15 | drainage | 2 | 121059 | 4 | 12.736 | 9505.3 |
209 | 2023-12-08 13:53:11 | drainage | 3 | 146162 | 71 | 9.423 | 15511.2 |
208 | 2023-12-02 10:05:49 | drainage | 1 | 82945 | 2 | 1.470 | 56425.2 |
207 | 2023-11-20 05:13:04 | drainage | 1 | 82945 | 2 | 1.503 | 55186.3 |
206 | 2023-11-13 20:06:28 | drainage | 1 | 82945 | 2 | 1.280 | 64800.8 |
205 | 2023-11-11 01:57:07 | drainage | 1 | 82945 | 2 | 1.390 | 59672.7 |
204 | 2023-11-07 07:26:47 | drainage | 1 | 82945 | 2 | 1.236 | 67107.6 |
203 | 2023-11-03 19:20:24 | drainage | 1 | 82945 | 2 | 2.953 | 28088.4 |
202 | 2023-10-31 15:10:32 | drainage | 2 | 121059 | 4 | 3.250 | 37248.9 |
201 | 2023-10-18 17:05:05 | drainage | 1 | 82945 | 2 | 1.360 | 60989.0 |
200 | 2023-09-17 16:46:19 | drainage | 1 | 82945 | 2 | 1.233 | 67270.9 |
199 | 2023-09-17 01:54:27 | drainage | 1 | 82945 | 2 | 1.530 | 54212.4 |
198 | 2023-08-07 06:03:41 | drainage | 2 | 121059 | 4 | 3.516 | 34430.9 |
197 | 2023-07-08 09:08:08 | drainage | 1 | 82945 | 2 | 1.280 | 64800.8 |
196 | 2023-07-06 19:02:14 | drainage | 1 | 82945 | 2 | 1.436 | 57761.1 |
195 | 2023-04-20 01:12:56 | drainage | 2 | 121059 | 4 | 3.156 | 38358.4 |
194 | 2023-04-13 18:56:55 | drainage | 1 | 82945 | 2 | 1.216 | 68211.3 |
193 | 2023-03-14 16:19:27 | drainage | 1 | 82945 | 2 | 1.373 | 60411.5 |
192 | 2023-02-06 13:10:14 | drainage | 1 | 82945 | 2 | 1.423 | 58288.8 |
191 | 2023-01-22 06:52:47 | drainage | 2 | 121059 | 4 | 3.390 | 35710.6 |
190 | 2022-12-05 01:58:43 | drainage | 1 | 82945 | 2 | 1.356 | 61168.9 |
189 | 2022-11-16 03:41:38 | drainage | 1 | 82945 | 2 | 1.406 | 58993.6 |
188 | 2022-11-01 19:10:44 | drainage | 2 | 121059 | 4 | 3.126 | 38726.5 |
187 | 2022-08-01 10:54:29 | drainage | 1 | 82945 | 2 | 1.250 | 66356.0 |
186 | 2022-07-15 21:57:09 | drainage | 1 | 82945 | 2 | 1.263 | 65673.0 |
185 | 2022-05-16 09:13:40 | drainage | 2 | 121059 | 4 | 4.140 | 29241.3 |
184 | 2022-03-24 15:48:41 | drainage | 1 | 82945 | 2 | 1.610 | 51518.6 |
183 | 2022-03-08 11:32:57 | drainage | 1 | 82945 | 2 | 1.643 | 50483.9 |
182 | 2022-01-28 20:06:03 | drainage | 2 | 121059 | 4 | 3.296 | 36729.1 |
181 | 2022-01-03 20:32:00 | drainage | 1 | 82945 | 2 | 1.670 | 49667.7 |
180 | 2021-12-21 03:10:16 | drainage | 1 | 82945 | 2 | 1.390 | 59672.7 |
179 | 2021-11-17 23:53:29 | drainage | 1 | 82945 | 2 | 1.406 | 58993.6 |
178 | 2021-11-08 07:49:40 | drainage | 1 | 82945 | 2 | 1.343 | 61761.0 |
177 | 2021-11-06 07:19:31 | drainage | 1 | 82945 | 2 | 1.420 | 58412.0 |
176 | 2021-09-23 17:49:50 | drainage | 1 | 82945 | 2 | 1.390 | 59672.7 |
175 | 2021-08-19 21:29:10 | drainage | 1 | 82945 | 2 | 1.423 | 58288.8 |
174 | 2021-08-17 17:43:22 | drainage | 1 | 82945 | 2 | 1.296 | 64000.8 |
173 | 2021-08-04 22:36:30 | drainage | 1 | 82945 | 2 | 1.233 | 67270.9 |
172 | 2021-06-06 06:19:00 | drainage | 1 | 82945 | 2 | 1.356 | 61168.9 |
171 | 2021-05-22 19:28:24 | drainage | 1 | 82945 | 2 | 1.530 | 54212.4 |
170 | 2021-04-23 18:49:47 | drainage | 1 | 82945 | 2 | 1.483 | 55930.5 |
169 | 2021-04-23 06:26:29 | drainage | 1 | 82945 | 2 | 2.656 | 31229.3 |
168 | 2021-04-18 23:43:24 | drainage | 1 | 82945 | 2 | 1.686 | 49196.3 |
167 | 2021-04-17 23:30:33 | drainage | 1 | 82945 | 2 | 1.500 | 55296.7 |
166 | 2021-03-25 20:48:44 | drainage | 1 | 82945 | 2 | 1.280 | 64800.8 |
165 | 2021-01-09 03:00:53 | drainage | 1 | 82945 | 2 | 1.266 | 65517.4 |
164 | 2020-12-26 00:52:29 | drainage | 1 | 82945 | 2 | 1.263 | 65673.0 |
163 | 2020-10-19 13:27:44 | drainage | 1 | 82945 | 2 | 1.530 | 54212.4 |
162 | 2020-10-14 14:57:16 | drainage | 1 | 82945 | 2 | 1.250 | 66356.0 |
161 | 2020-10-03 03:50:21 | drainage | 1 | 82945 | 2 | 1.250 | 66356.0 |
160 | 2020-09-18 10:00:31 | drainage | 1 | 82945 | 2 | 1.500 | 55296.7 |
159 | 2020-09-14 13:59:02 | drainage | 1 | 82945 | 2 | 1.423 | 58288.8 |
158 | 2020-08-05 20:02:29 | drainage | 1 | 82945 | 2 | 1.436 | 57761.1 |
157 | 2020-06-08 10:06:45 | drainage | 1 | 82945 | 2 | 1.280 | 64800.8 |
156 | 2020-03-23 10:46:30 | drainage | 1 | 82945 | 2 | 1.470 | 56425.2 |
155 | 2020-03-06 21:50:09 | drainage | 1 | 82945 | 2 | 1.330 | 62364.7 |
154 | 2020-03-01 19:41:18 | drainage | 1 | 82945 | 2 | 1.453 | 57085.3 |
153 | 2020-02-27 01:25:49 | drainage | 1 | 82945 | 2 | 3.190 | 26001.6 |
152 | 2020-02-25 07:18:53 | drainage | 1 | 82945 | 2 | 3.126 | 26533.9 |
151 | 2020-02-18 04:05:53 | drainage | 1 | 82945 | 2 | 1.500 | 55296.7 |
150 | 2020-02-17 22:39:35 | drainage | 1 | 82945 | 2 | 3.063 | 27079.7 |
149 | 2020-02-07 10:28:22 | drainage | 1 | 82945 | 2 | 3.423 | 24231.7 |
148 | 2020-02-02 20:54:44 | drainage | 1 | 82945 | 2 | 1.860 | 44594.1 |
147 | 2020-02-01 12:56:42 | drainage | 1 | 82945 | 2 | 3.096 | 26791.0 |
146 | 2020-01-24 08:09:47 | drainage | 1 | 82945 | 2 | 2.610 | 31779.7 |
145 | 2020-01-23 09:18:31 | drainage | 1 | 82945 | 2 | 1.660 | 49966.9 |
144 | 2020-01-17 04:00:11 | drainage | 1 | 82945 | 2 | 1.626 | 51011.7 |
143 | 2020-01-10 17:45:37 | drainage | 1 | 82945 | 2 | 1.500 | 55296.7 |