History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subfamily"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
259 | 2025-09-08 17:57:32 | subfamily | 1 | 81242 | 1 | 1.436 | 56575.2 |
258 | 2025-09-03 03:30:25 | subfamily | 1 | 81242 | 1 | 1.330 | 61084.2 |
257 | 2025-08-28 17:04:18 | subfamily | 2 | 121436 | 1 | 15.346 | 7913.2 |
256 | 2025-08-27 12:24:45 | subfamily | 1 | 81242 | 1 | 1.453 | 55913.3 |
255 | 2025-08-19 13:34:15 | subfamily | 3 | 148641 | 16 | 20.406 | 7284.2 |
254 | 2025-08-19 04:56:00 | subfamily | 3 | 148641 | 16 | 18.093 | 8215.4 |
253 | 2025-08-18 03:21:09 | subfamily | 1 | 81242 | 1 | 1.280 | 63470.3 |
252 | 2025-08-06 23:02:50 | subfamily | 1 | 81242 | 1 | 3.923 | 20709.2 |
251 | 2025-07-30 22:50:45 | subfamily | 1 | 81242 | 1 | 3.563 | 22801.6 |
250 | 2025-07-25 04:21:30 | subfamily | 1 | 81242 | 1 | 3.673 | 22118.7 |
249 | 2025-07-22 04:48:58 | subfamily | 1 | 81242 | 1 | 1.410 | 57618.4 |
248 | 2025-07-17 14:40:40 | subfamily | 1 | 81242 | 1 | 3.310 | 24544.4 |
247 | 2025-06-25 21:48:41 | subfamily | 1 | 81242 | 1 | 7.453 | 10900.6 |
246 | 2025-06-20 06:50:34 | subfamily | 1 | 81242 | 1 | 7.310 | 11113.8 |
245 | 2025-06-10 14:00:00 | subfamily | 1 | 81242 | 1 | 6.330 | 12834.4 |
244 | 2025-06-03 05:44:03 | subfamily | 1 | 81242 | 1 | 1.376 | 59042.2 |
243 | 2025-06-01 07:03:24 | subfamily | 1 | 81242 | 1 | 6.923 | 11735.1 |
242 | 2025-06-01 02:59:38 | subfamily | 1 | 81242 | 1 | 3.250 | 24997.5 |
241 | 2025-05-31 20:30:27 | subfamily | 1 | 81242 | 1 | 9.423 | 8621.7 |
240 | 2025-05-30 03:50:20 | subfamily | 1 | 81242 | 1 | 6.390 | 12713.9 |
239 | 2025-05-07 04:50:10 | subfamily | 1 | 81242 | 1 | 1.483 | 54782.2 |
238 | 2025-04-06 13:49:35 | subfamily | 1 | 81242 | 1 | 6.330 | 12834.4 |
237 | 2025-03-21 04:54:30 | subfamily | 3 | 148641 | 16 | 35.266 | 4214.9 |
236 | 2025-03-20 21:44:35 | subfamily | 1 | 81242 | 1 | 3.783 | 21475.5 |
235 | 2025-03-17 07:41:39 | subfamily | 3 | 148641 | 16 | 45.273 | 3283.2 |
234 | 2025-03-17 07:41:34 | subfamily | 3 | 148641 | 16 | 36.163 | 4110.3 |
233 | 2025-03-17 07:41:37 | subfamily | 2 | 121436 | 1 | 26.440 | 4592.9 |
232 | 2025-03-17 07:37:23 | subfamily | 1 | 81242 | 1 | 3.140 | 25873.2 |
231 | 2025-02-19 23:59:21 | subfamily | 1 | 81242 | 1 | 6.923 | 11735.1 |
230 | 2025-02-02 13:13:12 | subfamily | 1 | 81242 | 1 | 6.233 | 13034.2 |
229 | 2025-01-29 15:30:51 | subfamily | 1 | 81242 | 1 | 6.436 | 12623.1 |
228 | 2025-01-25 18:15:08 | subfamily | 1 | 81242 | 1 | 1.483 | 54782.2 |
227 | 2025-01-06 13:27:29 | subfamily | 3 | 148641 | 16 | 47.020 | 3161.2 |
226 | 2025-01-02 23:55:10 | subfamily | 3 | 148641 | 16 | 35.500 | 4187.1 |
225 | 2025-01-02 01:46:48 | subfamily | 1 | 81242 | 1 | 10.300 | 7887.6 |
224 | 2024-12-29 08:56:33 | subfamily | 1 | 81242 | 1 | 7.343 | 11063.9 |
223 | 2024-12-20 17:28:13 | subfamily | 1 | 81242 | 1 | 9.940 | 8173.2 |
222 | 2024-11-23 18:10:14 | subfamily | 2 | 121436 | 1 | 14.126 | 8596.6 |
221 | 2024-11-23 18:08:07 | subfamily | 1 | 81242 | 1 | 7.190 | 11299.3 |
220 | 2024-11-17 22:27:05 | subfamily | 2 | 121436 | 1 | 14.453 | 8402.1 |
219 | 2024-11-17 22:21:27 | subfamily | 1 | 81242 | 1 | 1.576 | 51549.5 |
218 | 2024-11-17 05:52:14 | subfamily | 3 | 148641 | 16 | 50.533 | 2941.5 |
217 | 2024-11-09 14:17:21 | subfamily | 1 | 81242 | 1 | 9.030 | 8996.9 |
216 | 2024-11-08 01:38:46 | subfamily | 3 | 148641 | 16 | 35.923 | 4137.8 |
215 | 2024-11-01 07:32:17 | subfamily | 1 | 81242 | 1 | 6.530 | 12441.3 |
214 | 2024-10-26 15:03:30 | subfamily | 3 | 148641 | 16 | 50.893 | 2920.7 |
213 | 2024-10-21 11:18:59 | subfamily | 3 | 148641 | 16 | 35.753 | 4157.4 |
212 | 2024-10-21 06:56:18 | subfamily | 3 | 148641 | 16 | 53.630 | 2771.6 |
211 | 2024-10-21 06:56:01 | subfamily | 3 | 148641 | 16 | 35.423 | 4196.2 |
210 | 2024-10-21 02:45:58 | subfamily | 4 | 165329 | 119 | 64.533 | 2561.9 |
209 | 2024-10-21 02:46:09 | subfamily | 3 | 148641 | 16 | 48.143 | 3087.5 |
208 | 2024-10-21 02:46:01 | subfamily | 2 | 121436 | 1 | 19.110 | 6354.6 |
207 | 2024-10-21 01:37:35 | subfamily | 1 | 81242 | 1 | 3.686 | 22040.7 |
206 | 2024-09-23 03:56:56 | subfamily | 1 | 81242 | 1 | 13.593 | 5976.8 |
205 | 2024-09-09 06:32:05 | subfamily | 1 | 81242 | 1 | 4.830 | 16820.3 |
204 | 2024-08-05 22:23:51 | subfamily | 1 | 81242 | 1 | 8.470 | 9591.7 |
203 | 2024-07-29 17:08:26 | subfamily | 1 | 81242 | 1 | 1.436 | 56575.2 |
202 | 2024-07-14 22:07:44 | subfamily | 3 | 148641 | 16 | 26.580 | 5592.2 |
201 | 2024-07-14 22:07:49 | subfamily | 2 | 121436 | 1 | 13.203 | 9197.6 |
200 | 2024-07-14 22:04:02 | subfamily | 1 | 81242 | 1 | 5.280 | 15386.7 |
199 | 2024-07-08 20:11:56 | subfamily | 3 | 148641 | 16 | 34.016 | 4369.7 |
198 | 2024-07-08 20:11:58 | subfamily | 3 | 148641 | 16 | 13.956 | 10650.7 |
197 | 2024-07-08 06:45:08 | subfamily | 4 | 165329 | 119 | 42.143 | 3923.0 |
196 | 2024-07-08 06:45:07 | subfamily | 3 | 148641 | 16 | 33.550 | 4430.4 |
195 | 2024-07-08 05:45:42 | subfamily | 4 | 165329 | 119 | 75.266 | 2196.6 |
194 | 2024-07-07 04:44:00 | subfamily | 4 | 165329 | 119 | 47.436 | 3485.3 |
193 | 2024-07-07 04:44:03 | subfamily | 3 | 148641 | 16 | 29.143 | 5100.4 |
192 | 2024-07-07 04:44:10 | subfamily | 2 | 121436 | 1 | 18.390 | 6603.4 |
191 | 2024-07-07 04:43:42 | subfamily | 1 | 81242 | 1 | 4.483 | 18122.2 |
190 | 2024-07-05 06:38:08 | subfamily | 1 | 81242 | 1 | 2.093 | 38816.1 |
189 | 2024-07-05 06:36:34 | subfamily | 1 | 81242 | 1 | 4.690 | 17322.4 |
188 | 2024-07-01 05:11:11 | subfamily | 1 | 81242 | 1 | 3.406 | 23852.6 |
187 | 2024-05-20 20:41:12 | subfamily | 2 | 121436 | 1 | 5.763 | 21071.7 |
186 | 2024-05-20 20:36:14 | subfamily | 1 | 81242 | 1 | 3.170 | 25628.4 |
185 | 2024-05-09 08:55:37 | subfamily | 4 | 165329 | 119 | 40.456 | 4086.6 |
184 | 2024-05-09 08:55:38 | subfamily | 3 | 148641 | 16 | 20.906 | 7110.0 |
183 | 2024-05-09 08:55:40 | subfamily | 2 | 121436 | 1 | 12.093 | 10041.8 |
182 | 2024-05-09 08:55:15 | subfamily | 2 | 121436 | 1 | 5.986 | 20286.7 |
181 | 2024-05-09 08:55:06 | subfamily | 1 | 81242 | 1 | 1.483 | 54782.2 |
180 | 2024-05-09 08:54:59 | subfamily | 1 | 81242 | 1 | 1.486 | 54671.6 |
179 | 2024-05-03 13:48:35 | subfamily | 3 | 148641 | 16 | 7.280 | 20417.7 |
178 | 2024-05-03 13:48:31 | subfamily | 2 | 121436 | 1 | 3.560 | 34111.2 |
177 | 2024-05-03 06:44:31 | subfamily | 1 | 81242 | 1 | 3.953 | 20552.0 |
176 | 2024-04-29 16:03:42 | subfamily | 3 | 148641 | 16 | 14.046 | 10582.4 |
175 | 2024-04-29 16:03:46 | subfamily | 2 | 121436 | 1 | 4.580 | 26514.4 |
174 | 2024-04-29 15:14:25 | subfamily | 1 | 81242 | 1 | 1.470 | 55266.7 |
173 | 2024-04-29 07:39:36 | subfamily | 2 | 121436 | 1 | 4.080 | 29763.7 |
172 | 2024-04-29 07:39:31 | subfamily | 3 | 148641 | 16 | 7.143 | 20809.3 |
171 | 2024-04-29 07:39:27 | subfamily | 1 | 81242 | 1 | 1.266 | 64172.2 |
170 | 2024-04-29 03:07:44 | subfamily | 4 | 165329 | 119 | 45.020 | 3672.3 |
169 | 2024-04-28 09:33:43 | subfamily | 4 | 165329 | 119 | 36.126 | 4576.5 |
168 | 2024-04-28 06:20:34 | subfamily | 4 | 165329 | 119 | 14.610 | 11316.2 |
167 | 2024-04-26 15:36:00 | subfamily | 2 | 121436 | 1 | 3.483 | 34865.3 |
166 | 2024-04-08 09:04:19 | subfamily | 4 | 165329 | 119 | 34.503 | 4791.7 |
165 | 2024-04-08 09:04:18 | subfamily | 3 | 148641 | 16 | 19.876 | 7478.4 |
164 | 2024-04-08 09:04:16 | subfamily | 2 | 121436 | 1 | 14.360 | 8456.5 |
163 | 2024-04-08 07:04:19 | subfamily | 1 | 81242 | 1 | 2.516 | 32290.1 |
162 | 2024-03-31 01:13:11 | subfamily | 3 | 148641 | 16 | 8.640 | 17203.8 |
161 | 2024-03-27 17:35:25 | subfamily | 3 | 148641 | 16 | 8.720 | 17046.0 |
160 | 2024-03-27 08:24:20 | subfamily | 4 | 165329 | 119 | 44.016 | 3756.1 |