History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nameplate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
233 | 2024-05-15 12:24:16 | nameplate | 3 | 148641 | 24 | 9.750 | 15245.2 |
232 | 2024-05-14 23:53:14 | nameplate | 3 | 148641 | 24 | 18.406 | 8075.7 |
231 | 2024-05-14 23:53:15 | nameplate | 2 | 121436 | 5 | 13.376 | 9078.6 |
230 | 2024-05-14 23:48:21 | nameplate | 1 | 81242 | 2 | 1.360 | 59736.8 |
229 | 2024-05-12 22:34:12 | nameplate | 1 | 81242 | 2 | 1.563 | 51978.2 |
228 | 2024-05-09 20:01:46 | nameplate | 1 | 81242 | 2 | 3.060 | 26549.7 |
227 | 2024-05-05 00:00:24 | nameplate | 1 | 81242 | 2 | 1.563 | 51978.2 |
226 | 2024-05-03 21:26:16 | nameplate | 1 | 81242 | 2 | 1.483 | 54782.2 |
225 | 2024-05-03 16:58:23 | nameplate | 1 | 81242 | 2 | 1.470 | 55266.7 |
224 | 2024-05-03 06:21:49 | nameplate | 4 | 165329 | 224 | 17.143 | 9644.1 |
223 | 2024-04-28 01:52:38 | nameplate | 4 | 165329 | 224 | 20.046 | 8247.5 |
222 | 2024-04-18 18:38:11 | nameplate | 2 | 121436 | 5 | 8.780 | 13831.0 |
221 | 2024-04-18 18:35:55 | nameplate | 1 | 81242 | 2 | 1.720 | 47233.7 |
220 | 2024-04-13 04:04:16 | nameplate | 1 | 81242 | 2 | 1.390 | 58447.5 |
219 | 2024-04-09 17:52:13 | nameplate | 1 | 81242 | 2 | 3.563 | 22801.6 |
218 | 2024-04-08 08:51:46 | nameplate | 3 | 148641 | 24 | 25.830 | 5754.6 |
217 | 2024-04-08 08:51:45 | nameplate | 2 | 121436 | 5 | 8.173 | 14858.2 |
216 | 2024-04-08 07:41:01 | nameplate | 1 | 81242 | 2 | 1.406 | 57782.4 |
215 | 2024-04-01 19:35:16 | nameplate | 4 | 165329 | 224 | 43.516 | 3799.3 |
214 | 2024-03-31 19:19:21 | nameplate | 1 | 81242 | 2 | 1.860 | 43678.5 |
213 | 2024-03-31 02:44:09 | nameplate | 1 | 81242 | 2 | 2.830 | 28707.4 |
212 | 2024-03-28 15:27:04 | nameplate | 4 | 165329 | 224 | 12.576 | 13146.4 |
211 | 2024-03-12 04:02:22 | nameplate | 1 | 81242 | 2 | 4.796 | 16939.5 |
210 | 2024-03-08 00:48:15 | nameplate | 1 | 81242 | 2 | 3.093 | 26266.4 |
209 | 2024-02-27 11:18:12 | nameplate | 1 | 81242 | 2 | 2.736 | 29693.7 |
208 | 2024-02-26 11:29:33 | nameplate | 1 | 81242 | 2 | 1.406 | 57782.4 |
207 | 2024-02-19 06:49:23 | nameplate | 4 | 165329 | 224 | 22.940 | 7207.0 |
206 | 2024-02-18 06:54:46 | nameplate | 4 | 165329 | 224 | 29.953 | 5519.6 |
205 | 2024-02-14 17:20:29 | nameplate | 4 | 165329 | 224 | 25.720 | 6428.0 |
204 | 2024-02-11 15:48:52 | nameplate | 4 | 165329 | 224 | 15.580 | 10611.6 |
203 | 2024-02-11 02:12:17 | nameplate | 4 | 165329 | 224 | 28.863 | 5728.1 |
202 | 2024-02-11 02:12:17 | nameplate | 3 | 148641 | 24 | 8.703 | 17079.3 |
201 | 2024-02-11 02:12:16 | nameplate | 2 | 121436 | 5 | 4.156 | 29219.4 |
200 | 2024-02-03 01:39:34 | nameplate | 1 | 81242 | 2 | 1.486 | 54671.6 |
199 | 2024-01-28 06:29:51 | nameplate | 1 | 81242 | 2 | 1.206 | 67364.8 |
198 | 2024-01-20 04:14:22 | nameplate | 1 | 81242 | 2 | 1.296 | 62686.7 |
197 | 2023-12-28 16:06:14 | nameplate | 1 | 81242 | 2 | 1.330 | 61084.2 |
196 | 2023-12-23 06:58:53 | nameplate | 1 | 81242 | 2 | 1.296 | 62686.7 |
195 | 2023-12-04 03:04:29 | nameplate | 4 | 165329 | 224 | 14.890 | 11103.4 |
194 | 2023-11-30 15:40:25 | nameplate | 1 | 81242 | 2 | 1.406 | 57782.4 |
193 | 2023-10-12 14:29:03 | nameplate | 1 | 81242 | 2 | 1.360 | 59736.8 |
192 | 2023-09-01 14:19:25 | nameplate | 4 | 165329 | 224 | 10.453 | 15816.4 |
191 | 2023-08-15 16:52:58 | nameplate | 4 | 165329 | 224 | 12.906 | 12810.2 |
190 | 2023-08-09 02:50:37 | nameplate | 1 | 81242 | 2 | 1.236 | 65729.8 |
189 | 2023-05-18 11:10:26 | nameplate | 4 | 165329 | 224 | 10.376 | 15933.8 |
188 | 2023-05-05 22:28:14 | nameplate | 1 | 81242 | 2 | 1.186 | 68500.8 |
187 | 2023-03-05 12:04:08 | nameplate | 4 | 165329 | 224 | 12.110 | 13652.3 |
186 | 2023-03-02 02:12:23 | nameplate | 4 | 165329 | 224 | 10.643 | 15534.1 |
185 | 2023-03-01 12:22:04 | nameplate | 1 | 81242 | 2 | 1.190 | 68270.6 |
184 | 2023-02-24 15:54:34 | nameplate | 4 | 165329 | 224 | 10.876 | 15201.3 |
183 | 2022-12-25 21:16:35 | nameplate | 1 | 81242 | 2 | 1.216 | 66810.9 |
182 | 2022-12-05 06:39:16 | nameplate | 4 | 165329 | 224 | 11.250 | 14695.9 |
181 | 2022-09-13 11:19:33 | nameplate | 1 | 81242 | 2 | 1.343 | 60492.9 |
180 | 2022-07-16 23:09:17 | nameplate | 1 | 81242 | 2 | 1.313 | 61875.1 |
179 | 2022-07-14 13:52:07 | nameplate | 1 | 81242 | 2 | 1.203 | 67532.8 |
178 | 2022-05-03 20:13:05 | nameplate | 4 | 165329 | 224 | 10.780 | 15336.6 |
177 | 2022-04-17 15:59:39 | nameplate | 4 | 165329 | 224 | 10.970 | 15071.0 |
176 | 2022-03-29 13:28:42 | nameplate | 1 | 81242 | 2 | 1.326 | 61268.5 |
175 | 2022-03-27 10:06:23 | nameplate | 1 | 81242 | 2 | 1.250 | 64993.6 |
174 | 2021-11-18 17:09:01 | nameplate | 4 | 165329 | 224 | 12.016 | 13759.1 |
173 | 2021-07-28 19:20:41 | nameplate | 4 | 165329 | 224 | 11.610 | 14240.2 |
172 | 2021-06-15 17:38:16 | nameplate | 4 | 165329 | 224 | 17.550 | 9420.5 |
171 | 2021-06-10 11:35:42 | nameplate | 4 | 165329 | 224 | 12.033 | 13739.6 |
170 | 2021-05-20 08:15:24 | nameplate | 4 | 165329 | 224 | 11.390 | 14515.3 |
169 | 2021-05-09 08:05:25 | nameplate | 1 | 81242 | 2 | 1.360 | 59736.8 |
168 | 2021-04-11 22:40:50 | nameplate | 3 | 148641 | 24 | 7.016 | 21186.0 |
167 | 2021-04-01 00:51:17 | nameplate | 4 | 165329 | 224 | 17.720 | 9330.1 |
166 | 2021-03-23 05:45:23 | nameplate | 4 | 165329 | 224 | 11.203 | 14757.6 |
165 | 2021-03-15 20:57:33 | nameplate | 3 | 148641 | 24 | 8.643 | 17197.8 |
164 | 2021-03-08 00:39:31 | nameplate | 4 | 165329 | 224 | 11.436 | 14456.9 |
163 | 2021-02-18 21:41:18 | nameplate | 3 | 148641 | 24 | 6.233 | 23847.4 |
162 | 2021-01-22 21:40:20 | nameplate | 1 | 81242 | 2 | 2.483 | 32719.3 |
161 | 2021-01-05 05:18:46 | nameplate | 4 | 165329 | 224 | 12.156 | 13600.6 |
160 | 2020-12-24 06:36:57 | nameplate | 1 | 81242 | 2 | 1.266 | 64172.2 |
159 | 2020-11-20 14:51:04 | nameplate | 4 | 165329 | 224 | 12.250 | 13496.2 |
158 | 2020-10-31 23:11:38 | nameplate | 4 | 165329 | 224 | 12.253 | 13492.9 |
157 | 2020-10-30 05:10:56 | nameplate | 4 | 165329 | 224 | 12.876 | 12840.1 |
156 | 2020-10-28 09:45:52 | nameplate | 1 | 81242 | 2 | 1.483 | 54782.2 |
155 | 2020-10-19 12:03:02 | nameplate | 4 | 165329 | 224 | 10.750 | 15379.4 |
154 | 2020-10-16 06:10:15 | nameplate | 4 | 165329 | 224 | 11.000 | 15029.9 |
153 | 2020-08-04 20:53:25 | nameplate | 4 | 165329 | 224 | 12.126 | 13634.3 |
152 | 2020-06-17 07:13:36 | nameplate | 4 | 165329 | 224 | 12.110 | 13652.3 |
151 | 2020-04-23 20:38:33 | nameplate | 4 | 165329 | 224 | 10.453 | 15816.4 |
150 | 2020-03-24 17:17:19 | nameplate | 1 | 81242 | 2 | 2.186 | 37164.7 |
149 | 2020-03-19 04:04:12 | nameplate | 1 | 81242 | 2 | 1.410 | 57618.4 |
148 | 2020-03-16 09:01:14 | nameplate | 1 | 81242 | 2 | 1.453 | 55913.3 |
147 | 2020-02-21 02:06:40 | nameplate | 4 | 165329 | 224 | 18.953 | 8723.1 |
146 | 2020-02-18 12:43:39 | nameplate | 1 | 81242 | 2 | 2.016 | 40298.6 |
145 | 2020-02-05 22:14:46 | nameplate | 1 | 81242 | 2 | 1.500 | 54161.3 |
144 | 2020-02-05 02:50:01 | nameplate | 1 | 81242 | 2 | 1.546 | 52549.8 |
143 | 2020-02-03 22:14:12 | nameplate | 1 | 81242 | 2 | 1.423 | 57092.1 |
142 | 2020-02-03 20:41:27 | nameplate | 1 | 81242 | 2 | 2.966 | 27391.1 |
141 | 2020-01-25 00:08:40 | nameplate | 4 | 165329 | 224 | 15.640 | 10570.9 |
140 | 2020-01-24 21:36:07 | nameplate | 4 | 165329 | 224 | 29.280 | 5646.5 |
139 | 2020-01-24 20:59:41 | nameplate | 4 | 165329 | 224 | 15.393 | 10740.5 |
138 | 2020-01-24 17:45:35 | nameplate | 4 | 165329 | 224 | 28.800 | 5740.6 |
137 | 2020-01-24 13:25:32 | nameplate | 4 | 165329 | 224 | 15.096 | 10951.8 |
136 | 2020-01-24 13:25:03 | nameplate | 2 | 121436 | 5 | 3.720 | 32644.1 |
135 | 2020-01-24 13:24:42 | nameplate | 3 | 148641 | 24 | 8.403 | 17689.0 |
134 | 2020-01-24 08:53:27 | nameplate | 1 | 81242 | 2 | 1.610 | 50460.9 |