History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subtests"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
230 | 2024-04-10 20:09:58 | subtests | 1 | 82945 | 3 | 6.000 | 13824.2 |
229 | 2024-04-09 23:13:26 | subtests | 2 | 121059 | 18 | 15.796 | 7663.9 |
228 | 2024-04-09 23:10:56 | subtests | 2 | 121059 | 18 | 9.453 | 12806.4 |
227 | 2024-04-09 23:03:20 | subtests | 1 | 82945 | 3 | 1.750 | 47397.1 |
226 | 2024-04-09 23:02:35 | subtests | 1 | 82945 | 3 | 1.796 | 46183.2 |
225 | 2024-04-05 03:35:51 | subtests | 3 | 146162 | 126 | 19.190 | 7616.6 |
224 | 2024-04-03 11:36:33 | subtests | 3 | 146162 | 126 | 11.140 | 13120.5 |
223 | 2024-03-31 23:56:06 | subtests | 3 | 146162 | 126 | 12.283 | 11899.5 |
222 | 2024-03-30 09:46:42 | subtests | 1 | 82945 | 3 | 3.576 | 23194.9 |
221 | 2024-03-30 09:46:17 | subtests | 2 | 121059 | 18 | 10.906 | 11100.2 |
220 | 2024-03-29 18:47:39 | subtests | 3 | 146162 | 126 | 11.483 | 12728.6 |
219 | 2024-03-29 10:50:20 | subtests | 3 | 146162 | 126 | 15.720 | 9297.8 |
218 | 2024-03-29 10:50:19 | subtests | 2 | 121059 | 18 | 4.716 | 25669.8 |
217 | 2024-03-29 10:50:16 | subtests | 1 | 82945 | 3 | 1.626 | 51011.7 |
216 | 2024-03-18 10:50:57 | subtests | 1 | 82945 | 3 | 4.003 | 20720.7 |
215 | 2024-03-06 02:31:35 | subtests | 3 | 146162 | 126 | 8.423 | 17352.7 |
214 | 2024-03-06 02:31:34 | subtests | 2 | 121059 | 18 | 8.360 | 14480.7 |
213 | 2024-03-06 02:31:25 | subtests | 1 | 82945 | 3 | 1.546 | 53651.4 |
212 | 2024-03-04 23:06:19 | subtests | 1 | 82945 | 3 | 3.233 | 25655.7 |
211 | 2024-02-29 14:09:17 | subtests | 3 | 146162 | 126 | 9.876 | 14799.7 |
210 | 2024-02-28 03:03:59 | subtests | 3 | 146162 | 126 | 10.170 | 14371.9 |
209 | 2024-02-28 03:03:57 | subtests | 2 | 121059 | 18 | 8.500 | 14242.2 |
208 | 2024-02-28 01:18:54 | subtests | 3 | 146162 | 126 | 8.640 | 16916.9 |
207 | 2024-02-28 01:18:58 | subtests | 2 | 121059 | 18 | 5.360 | 22585.6 |
206 | 2024-02-28 01:18:51 | subtests | 1 | 82945 | 3 | 2.610 | 31779.7 |
205 | 2024-02-12 10:56:19 | subtests | 1 | 82945 | 3 | 1.453 | 57085.3 |
204 | 2024-01-31 19:55:56 | subtests | 1 | 82945 | 3 | 2.703 | 30686.3 |
203 | 2023-12-11 06:05:04 | subtests | 1 | 82945 | 3 | 1.516 | 54713.1 |
202 | 2023-12-02 19:04:09 | subtests | 1 | 82945 | 3 | 1.406 | 58993.6 |
201 | 2023-11-20 20:54:12 | subtests | 1 | 82945 | 3 | 1.296 | 64000.8 |
200 | 2023-11-06 11:15:57 | subtests | 1 | 82945 | 3 | 1.263 | 65673.0 |
199 | 2023-11-03 17:00:10 | subtests | 1 | 82945 | 3 | 1.296 | 64000.8 |
198 | 2023-09-17 16:40:19 | subtests | 1 | 82945 | 3 | 1.360 | 60989.0 |
197 | 2023-07-31 14:58:58 | subtests | 1 | 82945 | 3 | 1.310 | 63316.8 |
196 | 2023-07-10 01:52:18 | subtests | 1 | 82945 | 3 | 1.343 | 61761.0 |
195 | 2023-04-12 04:25:42 | subtests | 1 | 82945 | 3 | 1.266 | 65517.4 |
194 | 2023-04-04 20:58:15 | subtests | 1 | 82945 | 3 | 1.436 | 57761.1 |
193 | 2023-02-03 01:37:03 | subtests | 1 | 82945 | 3 | 1.296 | 64000.8 |
192 | 2022-12-09 22:30:24 | subtests | 1 | 82945 | 3 | 1.313 | 63172.1 |
191 | 2022-12-02 07:59:39 | subtests | 1 | 82945 | 3 | 1.283 | 64649.3 |
190 | 2022-07-30 15:29:21 | subtests | 1 | 82945 | 3 | 1.263 | 65673.0 |
189 | 2022-07-26 00:32:31 | subtests | 1 | 82945 | 3 | 1.423 | 58288.8 |
188 | 2022-04-01 16:06:53 | subtests | 1 | 82945 | 3 | 1.296 | 64000.8 |
187 | 2022-03-22 23:26:39 | subtests | 1 | 82945 | 3 | 1.406 | 58993.6 |
186 | 2021-12-28 21:22:35 | subtests | 1 | 82945 | 3 | 1.326 | 62552.8 |
185 | 2021-12-11 16:08:40 | subtests | 1 | 82945 | 3 | 1.326 | 62552.8 |
184 | 2021-11-12 21:43:33 | subtests | 1 | 82945 | 3 | 1.373 | 60411.5 |
183 | 2021-10-09 14:30:26 | subtests | 1 | 82945 | 3 | 1.296 | 64000.8 |
182 | 2021-10-08 10:44:52 | subtests | 1 | 82945 | 3 | 1.610 | 51518.6 |
181 | 2021-10-07 10:01:52 | subtests | 1 | 82945 | 3 | 1.483 | 55930.5 |
180 | 2021-10-06 10:52:15 | subtests | 1 | 82945 | 3 | 1.516 | 54713.1 |
179 | 2021-10-05 08:40:04 | subtests | 1 | 82945 | 3 | 1.450 | 57203.4 |
178 | 2021-10-04 13:25:15 | subtests | 1 | 82945 | 3 | 1.406 | 58993.6 |
177 | 2021-10-03 10:23:45 | subtests | 1 | 82945 | 3 | 1.436 | 57761.1 |
176 | 2021-10-02 10:04:46 | subtests | 1 | 82945 | 3 | 1.466 | 56579.1 |
175 | 2021-09-18 05:20:10 | subtests | 1 | 82945 | 3 | 1.403 | 59119.7 |
174 | 2021-09-17 13:00:52 | subtests | 1 | 82945 | 3 | 1.440 | 57600.7 |
173 | 2021-09-16 22:27:37 | subtests | 1 | 82945 | 3 | 1.796 | 46183.2 |
172 | 2021-09-10 13:36:21 | subtests | 1 | 82945 | 3 | 1.436 | 57761.1 |
171 | 2021-09-01 01:21:33 | subtests | 1 | 82945 | 3 | 1.283 | 64649.3 |
170 | 2021-05-24 14:16:27 | subtests | 1 | 82945 | 3 | 1.546 | 53651.4 |
169 | 2021-04-27 00:59:44 | subtests | 1 | 82945 | 3 | 1.313 | 63172.1 |
168 | 2021-03-27 05:13:23 | subtests | 1 | 82945 | 3 | 1.330 | 62364.7 |
167 | 2021-02-19 01:09:35 | subtests | 1 | 82945 | 3 | 1.453 | 57085.3 |
166 | 2021-01-28 07:16:45 | subtests | 1 | 82945 | 3 | 1.283 | 64649.3 |
165 | 2021-01-10 13:10:09 | subtests | 1 | 82945 | 3 | 1.280 | 64800.8 |
164 | 2020-12-16 14:47:25 | subtests | 3 | 146162 | 126 | 6.126 | 23859.3 |
163 | 2020-12-08 04:08:42 | subtests | 1 | 82945 | 3 | 1.390 | 59672.7 |
162 | 2020-11-15 04:21:31 | subtests | 1 | 82945 | 3 | 1.423 | 58288.8 |
161 | 2020-11-13 13:23:16 | subtests | 3 | 146162 | 126 | 6.330 | 23090.4 |
160 | 2020-11-07 09:19:16 | subtests | 1 | 82945 | 3 | 1.376 | 60279.8 |
159 | 2020-11-02 16:59:21 | subtests | 1 | 82945 | 3 | 1.343 | 61761.0 |
158 | 2020-10-16 09:56:07 | subtests | 1 | 82945 | 3 | 1.530 | 54212.4 |
157 | 2020-09-28 19:35:57 | subtests | 1 | 82945 | 3 | 1.373 | 60411.5 |
156 | 2020-08-13 08:20:27 | subtests | 1 | 82945 | 3 | 1.580 | 52496.8 |
155 | 2020-05-12 06:20:22 | subtests | 1 | 82945 | 3 | 1.500 | 55296.7 |
154 | 2020-03-21 07:49:16 | subtests | 1 | 82945 | 3 | 1.483 | 55930.5 |
153 | 2020-02-28 02:54:02 | subtests | 1 | 82945 | 3 | 1.470 | 56425.2 |
152 | 2020-02-22 22:52:01 | subtests | 1 | 82945 | 3 | 1.483 | 55930.5 |
151 | 2020-02-13 20:39:58 | subtests | 1 | 82945 | 3 | 1.533 | 54106.3 |
150 | 2020-02-11 02:12:57 | subtests | 1 | 82945 | 3 | 1.763 | 47047.6 |
149 | 2020-02-07 01:30:10 | subtests | 1 | 82945 | 3 | 3.423 | 24231.7 |
148 | 2020-02-06 16:02:28 | subtests | 1 | 82945 | 3 | 1.300 | 63803.8 |
147 | 2020-02-03 17:29:29 | subtests | 1 | 82945 | 3 | 4.906 | 16906.8 |
146 | 2020-02-02 01:26:16 | subtests | 1 | 82945 | 3 | 1.610 | 51518.6 |
145 | 2020-02-01 07:45:28 | subtests | 1 | 82945 | 3 | 3.296 | 25165.4 |
144 | 2020-01-22 17:55:41 | subtests | 1 | 82945 | 3 | 5.580 | 14864.7 |
143 | 2020-01-22 12:03:40 | subtests | 1 | 82945 | 3 | 1.890 | 43886.2 |
142 | 2020-01-15 17:58:11 | subtests | 1 | 82945 | 3 | 3.203 | 25896.0 |
141 | 2020-01-10 15:42:47 | subtests | 1 | 82945 | 3 | 1.576 | 52630.1 |
140 | 2020-01-09 00:51:07 | subtests | 1 | 82945 | 3 | 1.563 | 53067.8 |
139 | 2020-01-01 10:52:59 | subtests | 1 | 82945 | 3 | 1.580 | 52496.8 |
138 | 2019-12-30 07:57:22 | subtests | 1 | 82945 | 3 | 1.576 | 52630.1 |
137 | 2019-11-02 22:22:16 | subtests | 1 | 82945 | 3 | 1.280 | 64800.8 |
136 | 2019-08-01 18:21:16 | subtests | 1 | 82945 | 3 | 1.496 | 55444.5 |
135 | 2019-07-23 21:08:25 | subtests | 1 | 82945 | 3 | 1.283 | 64649.3 |
134 | 2019-06-07 22:05:18 | subtests | 1 | 82945 | 3 | 1.373 | 60411.5 |
133 | 2019-04-25 12:09:44 | subtests | 1 | 82945 | 3 | 1.446 | 57361.7 |
132 | 2019-01-05 19:30:37 | subtests | 1 | 82945 | 3 | 1.240 | 66891.1 |
131 | 2019-01-02 11:41:34 | subtests | 1 | 82945 | 3 | 1.393 | 59544.1 |