History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subagent"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
250 | 2024-04-15 21:12:55 | subagent | 2 | 121059 | 5 | 3.483 | 34757.1 |
249 | 2024-04-11 07:00:07 | subagent | 2 | 121059 | 5 | 3.686 | 32842.9 |
248 | 2024-04-11 06:59:55 | subagent | 3 | 146162 | 49 | 6.983 | 20931.1 |
247 | 2024-04-10 20:12:41 | subagent | 4 | 161609 | 507 | 47.626 | 3393.3 |
246 | 2024-04-10 20:10:06 | subagent | 1 | 82945 | 2 | 1.780 | 46598.3 |
245 | 2024-04-09 23:12:19 | subagent | 2 | 121059 | 5 | 10.626 | 11392.7 |
244 | 2024-04-09 23:10:41 | subagent | 1 | 82945 | 2 | 5.076 | 16340.6 |
243 | 2024-04-09 23:04:04 | subagent | 1 | 82945 | 2 | 3.796 | 21850.6 |
242 | 2024-04-07 21:27:43 | subagent | 4 | 161609 | 507 | 36.500 | 4427.6 |
241 | 2024-04-07 07:29:01 | subagent | 4 | 161609 | 507 | 29.500 | 5478.3 |
240 | 2024-04-07 07:29:02 | subagent | 3 | 146162 | 49 | 27.643 | 5287.5 |
239 | 2024-04-03 20:07:52 | subagent | 3 | 146162 | 49 | 15.016 | 9733.8 |
238 | 2024-04-03 20:07:24 | subagent | 4 | 161609 | 507 | 25.626 | 6306.4 |
237 | 2024-04-03 16:36:29 | subagent | 3 | 146162 | 49 | 8.766 | 16673.7 |
236 | 2024-04-03 16:36:28 | subagent | 2 | 121059 | 5 | 4.673 | 25906.1 |
235 | 2024-04-02 18:23:50 | subagent | 4 | 161609 | 507 | 36.346 | 4446.4 |
234 | 2024-04-02 06:39:06 | subagent | 1 | 82945 | 2 | 1.563 | 53067.8 |
233 | 2024-04-02 06:38:53 | subagent | 4 | 161609 | 507 | 13.706 | 11791.1 |
232 | 2024-04-02 06:38:55 | subagent | 3 | 146162 | 49 | 9.876 | 14799.7 |
231 | 2024-04-02 06:38:57 | subagent | 2 | 121059 | 5 | 4.296 | 28179.5 |
230 | 2024-04-02 06:38:49 | subagent | 1 | 82945 | 2 | 1.360 | 60989.0 |
229 | 2024-04-01 12:20:11 | subagent | 1 | 82945 | 2 | 3.326 | 24938.4 |
228 | 2024-03-11 12:14:26 | subagent | 1 | 82945 | 2 | 1.783 | 46519.9 |
227 | 2024-03-07 18:21:20 | subagent | 4 | 161609 | 507 | 24.550 | 6582.9 |
226 | 2024-03-07 14:04:00 | subagent | 4 | 161609 | 507 | 23.376 | 6913.5 |
225 | 2024-03-07 14:04:02 | subagent | 3 | 146162 | 49 | 17.456 | 8373.2 |
224 | 2024-03-05 19:17:25 | subagent | 2 | 121059 | 5 | 10.983 | 11022.4 |
223 | 2024-03-05 16:20:01 | subagent | 1 | 82945 | 2 | 1.643 | 50483.9 |
222 | 2024-03-03 09:14:01 | subagent | 3 | 146162 | 49 | 7.766 | 18820.8 |
221 | 2024-03-03 09:14:02 | subagent | 2 | 121059 | 5 | 3.796 | 31891.2 |
220 | 2024-03-02 15:39:15 | subagent | 1 | 82945 | 2 | 3.156 | 26281.7 |
219 | 2024-02-29 15:28:36 | subagent | 2 | 121059 | 5 | 7.423 | 16308.6 |
218 | 2024-02-29 15:28:03 | subagent | 3 | 146162 | 49 | 8.486 | 17223.9 |
217 | 2024-02-29 11:15:03 | subagent | 4 | 161609 | 507 | 15.673 | 10311.3 |
216 | 2024-02-29 09:23:15 | subagent | 3 | 146162 | 49 | 24.546 | 5954.6 |
215 | 2024-02-29 09:23:23 | subagent | 1 | 82945 | 2 | 4.813 | 17233.5 |
214 | 2024-02-29 09:23:12 | subagent | 4 | 161609 | 507 | 14.956 | 10805.6 |
213 | 2024-02-29 09:23:20 | subagent | 2 | 121059 | 5 | 5.516 | 21946.9 |
212 | 2024-02-05 21:08:42 | subagent | 2 | 121059 | 5 | 4.860 | 24909.3 |
211 | 2024-02-05 21:08:26 | subagent | 3 | 146162 | 49 | 8.046 | 18165.8 |
210 | 2024-02-05 19:00:13 | subagent | 1 | 82945 | 2 | 1.530 | 54212.4 |
209 | 2024-02-05 08:45:00 | subagent | 3 | 146162 | 49 | 13.530 | 10802.8 |
208 | 2024-02-04 01:06:03 | subagent | 4 | 161609 | 507 | 11.736 | 13770.4 |
207 | 2024-02-01 07:13:07 | subagent | 2 | 121059 | 5 | 3.343 | 36212.7 |
206 | 2024-02-01 07:12:55 | subagent | 3 | 146162 | 49 | 6.423 | 22756.0 |
205 | 2024-01-30 08:54:31 | subagent | 4 | 161609 | 507 | 17.343 | 9318.4 |
204 | 2024-01-30 03:54:47 | subagent | 4 | 161609 | 507 | 14.016 | 11530.3 |
203 | 2024-01-30 03:54:44 | subagent | 3 | 146162 | 49 | 14.533 | 10057.2 |
202 | 2024-01-30 03:54:23 | subagent | 2 | 121059 | 5 | 3.533 | 34265.2 |
201 | 2024-01-30 03:53:57 | subagent | 2 | 121059 | 5 | 3.766 | 32145.2 |
200 | 2024-01-30 03:53:37 | subagent | 1 | 82945 | 2 | 1.343 | 61761.0 |
199 | 2023-12-25 11:51:59 | subagent | 4 | 161609 | 507 | 11.093 | 14568.6 |
198 | 2023-11-28 18:24:47 | subagent | 1 | 82945 | 2 | 1.500 | 55296.7 |
197 | 2023-11-20 20:48:29 | subagent | 1 | 82945 | 2 | 1.470 | 56425.2 |
196 | 2023-11-05 20:31:37 | subagent | 1 | 82945 | 2 | 1.436 | 57761.1 |
195 | 2023-10-18 05:19:57 | subagent | 1 | 82945 | 2 | 1.940 | 42755.2 |
194 | 2023-10-01 20:36:33 | subagent | 4 | 161609 | 507 | 24.500 | 6596.3 |
193 | 2023-09-26 07:35:25 | subagent | 4 | 161609 | 507 | 14.360 | 11254.1 |
192 | 2023-09-14 20:34:07 | subagent | 1 | 82945 | 2 | 1.250 | 66356.0 |
191 | 2023-07-06 02:22:32 | subagent | 4 | 161609 | 507 | 10.533 | 15343.1 |
190 | 2023-06-29 06:37:56 | subagent | 4 | 161609 | 507 | 10.720 | 15075.5 |
189 | 2023-06-28 23:58:23 | subagent | 1 | 82945 | 2 | 1.453 | 57085.3 |
188 | 2023-04-07 16:48:33 | subagent | 1 | 82945 | 2 | 1.406 | 58993.6 |
187 | 2023-03-30 03:17:12 | subagent | 4 | 161609 | 507 | 11.923 | 13554.4 |
186 | 2023-03-28 04:26:59 | subagent | 4 | 161609 | 507 | 12.360 | 13075.2 |
185 | 2023-02-15 01:32:09 | subagent | 4 | 161609 | 507 | 11.423 | 14147.7 |
184 | 2023-01-27 14:17:36 | subagent | 1 | 82945 | 2 | 1.263 | 65673.0 |
183 | 2022-12-26 17:19:49 | subagent | 4 | 161609 | 507 | 10.643 | 15184.5 |
182 | 2022-12-24 17:24:55 | subagent | 4 | 161609 | 507 | 10.360 | 15599.3 |
181 | 2022-12-12 16:24:54 | subagent | 4 | 161609 | 507 | 12.343 | 13093.2 |
180 | 2022-11-25 22:52:21 | subagent | 1 | 82945 | 2 | 1.440 | 57600.7 |
179 | 2022-11-10 02:25:13 | subagent | 4 | 161609 | 507 | 13.720 | 11779.1 |
178 | 2022-11-01 13:14:47 | subagent | 4 | 161609 | 507 | 11.690 | 13824.6 |
177 | 2022-10-30 18:32:22 | subagent | 4 | 161609 | 507 | 11.610 | 13919.8 |
176 | 2022-10-26 05:55:56 | subagent | 4 | 161609 | 507 | 10.376 | 15575.3 |
175 | 2022-10-13 06:50:42 | subagent | 4 | 161609 | 507 | 10.546 | 15324.2 |
174 | 2022-09-29 12:22:43 | subagent | 4 | 161609 | 507 | 10.516 | 15367.9 |
173 | 2022-08-22 13:49:14 | subagent | 4 | 161609 | 507 | 11.423 | 14147.7 |
172 | 2022-07-21 04:28:55 | subagent | 1 | 82945 | 2 | 1.360 | 60989.0 |
171 | 2022-04-10 06:59:16 | subagent | 4 | 161609 | 507 | 10.953 | 14754.8 |
170 | 2022-03-22 18:54:47 | subagent | 1 | 82945 | 2 | 1.690 | 49079.9 |
169 | 2022-03-22 08:12:00 | subagent | 4 | 161609 | 507 | 10.513 | 15372.3 |
168 | 2022-03-20 15:11:57 | subagent | 1 | 82945 | 2 | 1.356 | 61168.9 |
167 | 2021-06-28 14:38:32 | subagent | 4 | 161609 | 507 | 22.016 | 7340.5 |
166 | 2021-06-01 21:43:15 | subagent | 4 | 161609 | 507 | 12.000 | 13467.4 |
165 | 2021-05-17 08:21:11 | subagent | 4 | 161609 | 507 | 12.513 | 12915.3 |
164 | 2021-04-30 16:38:04 | subagent | 1 | 82945 | 2 | 1.513 | 54821.5 |
163 | 2021-04-17 17:28:51 | subagent | 4 | 161609 | 507 | 12.220 | 13225.0 |
162 | 2021-04-12 02:46:27 | subagent | 4 | 161609 | 507 | 10.893 | 14836.0 |
161 | 2021-01-25 13:10:53 | subagent | 4 | 161609 | 507 | 10.703 | 15099.4 |
160 | 2021-01-24 15:22:41 | subagent | 4 | 161609 | 507 | 11.906 | 13573.7 |
159 | 2021-01-13 15:50:43 | subagent | 1 | 82945 | 2 | 1.326 | 62552.8 |
158 | 2020-10-27 04:15:33 | subagent | 1 | 82945 | 2 | 1.313 | 63172.1 |
157 | 2020-09-30 21:23:50 | subagent | 1 | 82945 | 2 | 1.263 | 65673.0 |
156 | 2020-03-23 05:29:37 | subagent | 1 | 82945 | 2 | 3.076 | 26965.2 |
155 | 2020-03-12 22:25:03 | subagent | 1 | 82945 | 2 | 1.390 | 59672.7 |
154 | 2020-02-29 09:59:43 | subagent | 1 | 82945 | 2 | 1.466 | 56579.1 |
153 | 2020-02-25 09:57:32 | subagent | 1 | 82945 | 2 | 1.640 | 50576.2 |
152 | 2020-02-21 00:39:00 | subagent | 4 | 161609 | 507 | 16.800 | 9619.6 |
151 | 2020-02-20 02:10:29 | subagent | 4 | 161609 | 507 | 21.843 | 7398.7 |