History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prefab"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
244 | 2024-04-22 14:29:19 | prefab | 1 | 48755 | 2 | 1.626 | 29984.6 |
243 | 2024-04-19 21:24:32 | prefab | 1 | 48755 | 2 | 1.906 | 25579.7 |
242 | 2024-04-10 23:05:21 | prefab | 3 | 112716 | 234 | 13.140 | 8578.1 |
241 | 2024-04-10 23:05:23 | prefab | 2 | 82551 | 14 | 2.860 | 28864.0 |
240 | 2024-04-10 01:21:11 | prefab | 3 | 112716 | 234 | 15.690 | 7183.9 |
239 | 2024-04-09 20:47:24 | prefab | 3 | 112716 | 234 | 9.610 | 11729.0 |
238 | 2024-04-09 20:47:25 | prefab | 2 | 82551 | 14 | 8.156 | 10121.5 |
237 | 2024-04-09 20:47:23 | prefab | 1 | 48755 | 2 | 2.296 | 21234.8 |
236 | 2024-03-28 23:41:51 | prefab | 1 | 48755 | 2 | 2.110 | 23106.6 |
235 | 2024-02-25 21:46:35 | prefab | 1 | 48755 | 2 | 1.016 | 47987.2 |
234 | 2024-01-31 00:42:23 | prefab | 2 | 82551 | 14 | 4.406 | 18736.0 |
233 | 2024-01-31 00:41:59 | prefab | 3 | 112716 | 234 | 8.216 | 13719.1 |
232 | 2024-01-30 04:01:58 | prefab | 2 | 82551 | 14 | 2.203 | 37472.1 |
231 | 2024-01-30 04:01:34 | prefab | 3 | 112716 | 234 | 5.500 | 20493.8 |
230 | 2024-01-30 00:25:11 | prefab | 3 | 112716 | 234 | 10.626 | 10607.6 |
229 | 2024-01-03 18:34:50 | prefab | 1 | 48755 | 2 | 0.860 | 56691.9 |
228 | 2023-12-06 15:01:19 | prefab | 1 | 48755 | 2 | 0.856 | 56956.8 |
227 | 2023-12-03 20:49:57 | prefab | 2 | 82551 | 14 | 2.250 | 36689.3 |
226 | 2023-11-18 22:22:21 | prefab | 1 | 48755 | 2 | 0.830 | 58741.0 |
225 | 2023-11-17 11:45:28 | prefab | 3 | 112716 | 234 | 4.766 | 23650.0 |
224 | 2023-11-10 19:32:00 | prefab | 3 | 112716 | 234 | 5.343 | 21096.0 |
223 | 2023-11-07 21:05:25 | prefab | 3 | 112716 | 234 | 4.656 | 24208.8 |
222 | 2023-11-03 06:31:39 | prefab | 1 | 48755 | 2 | 0.813 | 59969.2 |
221 | 2023-10-25 21:39:04 | prefab | 1 | 48755 | 2 | 0.830 | 58741.0 |
220 | 2023-10-24 03:25:52 | prefab | 1 | 48755 | 2 | 0.860 | 56691.9 |
219 | 2023-10-18 16:53:36 | prefab | 1 | 48755 | 2 | 0.766 | 63648.8 |
218 | 2023-10-08 08:46:45 | prefab | 1 | 48755 | 2 | 0.766 | 63648.8 |
217 | 2023-09-29 01:59:11 | prefab | 1 | 48755 | 2 | 0.766 | 63648.8 |
216 | 2023-09-14 12:21:07 | prefab | 1 | 48755 | 2 | 0.766 | 63648.8 |
215 | 2023-08-19 16:26:32 | prefab | 1 | 48755 | 2 | 0.736 | 66243.2 |
214 | 2023-08-11 23:08:09 | prefab | 3 | 112716 | 234 | 4.593 | 24540.8 |
213 | 2023-06-16 00:44:11 | prefab | 1 | 48755 | 2 | 0.766 | 63648.8 |
212 | 2023-05-20 00:19:34 | prefab | 1 | 48755 | 2 | 0.750 | 65006.7 |
211 | 2023-04-22 21:03:29 | prefab | 3 | 112716 | 234 | 5.080 | 22188.2 |
210 | 2023-03-17 02:07:29 | prefab | 1 | 48755 | 2 | 0.733 | 66514.3 |
209 | 2023-03-04 03:02:17 | prefab | 1 | 48755 | 2 | 0.813 | 59969.2 |
208 | 2023-02-03 22:32:01 | prefab | 1 | 48755 | 2 | 0.876 | 55656.4 |
207 | 2023-01-26 02:54:11 | prefab | 3 | 112716 | 234 | 4.610 | 24450.3 |
206 | 2023-01-04 03:07:12 | prefab | 1 | 48755 | 2 | 0.826 | 59025.4 |
205 | 2022-11-08 12:25:21 | prefab | 3 | 112716 | 234 | 5.296 | 21283.2 |
204 | 2022-09-25 15:22:44 | prefab | 1 | 48755 | 2 | 1.046 | 46610.9 |
203 | 2022-09-25 10:24:10 | prefab | 1 | 48755 | 2 | 0.813 | 59969.2 |
202 | 2022-06-11 22:40:51 | prefab | 3 | 112716 | 234 | 5.516 | 20434.4 |
201 | 2022-05-16 02:00:25 | prefab | 1 | 48755 | 2 | 0.800 | 60943.8 |
200 | 2022-05-16 01:55:15 | prefab | 1 | 48755 | 2 | 1.233 | 39541.8 |
199 | 2022-05-11 23:14:16 | prefab | 1 | 48755 | 2 | 0.876 | 55656.4 |
198 | 2022-01-11 10:59:54 | prefab | 1 | 48755 | 2 | 0.936 | 52088.7 |
197 | 2021-09-19 06:59:36 | prefab | 1 | 48755 | 2 | 0.766 | 63648.8 |
196 | 2021-06-12 16:59:49 | prefab | 1 | 48755 | 2 | 1.733 | 28133.3 |
195 | 2021-04-23 13:51:20 | prefab | 1 | 48755 | 2 | 0.843 | 57835.1 |
194 | 2021-03-25 17:10:06 | prefab | 1 | 48755 | 2 | 0.766 | 63648.8 |
193 | 2021-03-13 07:21:37 | prefab | 1 | 48755 | 2 | 0.876 | 55656.4 |
192 | 2021-02-11 21:47:48 | prefab | 1 | 48755 | 2 | 0.923 | 52822.3 |
191 | 2021-01-08 23:12:57 | prefab | 1 | 48755 | 2 | 0.826 | 59025.4 |
190 | 2020-12-10 11:18:58 | prefab | 1 | 48755 | 2 | 0.750 | 65006.7 |
189 | 2020-12-06 05:03:38 | prefab | 1 | 48755 | 2 | 0.860 | 56691.9 |
188 | 2020-11-20 17:49:10 | prefab | 1 | 48755 | 2 | 0.763 | 63899.1 |
187 | 2020-10-31 04:13:18 | prefab | 1 | 48755 | 2 | 0.843 | 57835.1 |
186 | 2020-10-27 04:38:21 | prefab | 1 | 48755 | 2 | 0.763 | 63899.1 |
185 | 2020-09-06 09:06:44 | prefab | 1 | 48755 | 2 | 0.763 | 63899.1 |
184 | 2020-08-24 17:58:37 | prefab | 1 | 48755 | 2 | 0.783 | 62266.9 |
183 | 2020-08-22 09:10:42 | prefab | 1 | 48755 | 2 | 0.826 | 59025.4 |
182 | 2020-07-28 04:06:00 | prefab | 1 | 48755 | 2 | 0.813 | 59969.2 |
181 | 2020-06-13 06:25:16 | prefab | 1 | 48755 | 2 | 0.813 | 59969.2 |
180 | 2020-05-08 02:39:54 | prefab | 1 | 48755 | 2 | 0.876 | 55656.4 |
179 | 2020-03-29 17:02:54 | prefab | 1 | 48755 | 2 | 0.763 | 63899.1 |
178 | 2020-03-28 05:38:23 | prefab | 1 | 48755 | 2 | 0.920 | 52994.6 |
177 | 2020-03-25 00:46:37 | prefab | 1 | 48755 | 2 | 0.766 | 63648.8 |
176 | 2020-03-23 17:03:01 | prefab | 1 | 48755 | 2 | 0.953 | 51159.5 |
175 | 2020-03-23 15:16:54 | prefab | 1 | 48755 | 2 | 0.856 | 56956.8 |
174 | 2020-03-19 21:04:28 | prefab | 1 | 48755 | 2 | 1.626 | 29984.6 |
173 | 2020-03-18 07:02:20 | prefab | 1 | 48755 | 2 | 0.813 | 59969.2 |
172 | 2020-02-29 14:28:53 | prefab | 1 | 48755 | 2 | 0.903 | 53992.2 |
171 | 2020-02-28 13:32:43 | prefab | 3 | 112716 | 234 | 9.720 | 11596.3 |
170 | 2020-02-28 10:55:11 | prefab | 3 | 112716 | 234 | 7.250 | 15547.0 |
169 | 2020-02-28 10:24:04 | prefab | 3 | 112716 | 234 | 10.203 | 11047.3 |
168 | 2020-02-28 07:10:47 | prefab | 3 | 112716 | 234 | 6.703 | 16815.8 |
167 | 2020-02-28 05:36:18 | prefab | 3 | 112716 | 234 | 13.936 | 8088.1 |
166 | 2020-02-27 19:14:00 | prefab | 3 | 112716 | 234 | 6.360 | 17722.6 |
165 | 2020-02-21 06:43:05 | prefab | 1 | 48755 | 2 | 1.940 | 25131.4 |
164 | 2020-02-10 09:55:53 | prefab | 1 | 48755 | 2 | 1.656 | 29441.4 |
163 | 2020-02-08 12:23:37 | prefab | 1 | 48755 | 2 | 0.936 | 52088.7 |
162 | 2020-02-08 08:15:57 | prefab | 1 | 48755 | 2 | 0.906 | 53813.5 |
161 | 2020-02-06 07:24:49 | prefab | 1 | 48755 | 2 | 0.906 | 53813.5 |
160 | 2020-02-05 11:29:37 | prefab | 1 | 48755 | 2 | 0.983 | 49598.2 |
159 | 2020-02-02 14:56:39 | prefab | 1 | 48755 | 2 | 0.846 | 57630.0 |
158 | 2020-01-30 11:52:54 | prefab | 1 | 48755 | 2 | 0.890 | 54780.9 |
157 | 2020-01-23 17:21:17 | prefab | 1 | 48755 | 2 | 2.673 | 18239.8 |
156 | 2020-01-16 16:55:30 | prefab | 1 | 48755 | 2 | 0.923 | 52822.3 |
155 | 2020-01-16 02:18:22 | prefab | 1 | 48755 | 2 | 1.170 | 41670.9 |
154 | 2020-01-13 23:23:43 | prefab | 1 | 48755 | 2 | 0.873 | 55847.7 |
153 | 2020-01-13 06:27:54 | prefab | 3 | 112716 | 234 | 6.096 | 18490.2 |
152 | 2020-01-13 02:51:24 | prefab | 3 | 112716 | 234 | 6.030 | 18692.5 |
151 | 2020-01-12 21:52:52 | prefab | 3 | 112716 | 234 | 5.170 | 21801.9 |
150 | 2020-01-12 17:14:11 | prefab | 1 | 48755 | 2 | 1.796 | 27146.4 |
149 | 2020-01-07 22:45:12 | prefab | 1 | 48755 | 2 | 2.873 | 16970.1 |
148 | 2019-12-29 01:02:18 | prefab | 1 | 48755 | 2 | 0.873 | 55847.7 |
147 | 2019-12-26 18:32:42 | prefab | 1 | 48755 | 2 | 0.860 | 56691.9 |
146 | 2019-12-26 13:30:02 | prefab | 1 | 48755 | 2 | 1.893 | 25755.4 |
145 | 2019-12-25 17:07:00 | prefab | 1 | 48755 | 2 | 0.766 | 63648.8 |