History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bakehouses"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
234 | 2024-04-20 04:30:04 | bakehouses | 3 | 140603 | 41 | 27.046 | 5198.7 |
233 | 2024-04-20 04:30:03 | bakehouses | 2 | 108824 | 9 | 12.813 | 8493.2 |
232 | 2024-04-20 04:27:23 | bakehouses | 1 | 67641 | 2 | 2.610 | 25916.1 |
231 | 2024-04-16 17:59:59 | bakehouses | 1 | 67641 | 2 | 1.250 | 54112.8 |
230 | 2024-04-13 22:23:03 | bakehouses | 4 | 161450 | 147 | 38.550 | 4188.1 |
229 | 2024-04-13 22:22:22 | bakehouses | 4 | 161450 | 147 | 26.046 | 6198.6 |
228 | 2024-04-13 18:57:55 | bakehouses | 4 | 161450 | 147 | 37.893 | 4260.7 |
227 | 2024-04-13 18:58:03 | bakehouses | 3 | 140603 | 41 | 24.080 | 5839.0 |
226 | 2024-04-13 17:43:35 | bakehouses | 1 | 67641 | 2 | 1.296 | 52192.1 |
225 | 2024-03-29 17:00:07 | bakehouses | 2 | 108824 | 9 | 7.670 | 14188.3 |
224 | 2024-03-27 07:26:33 | bakehouses | 1 | 67641 | 2 | 1.203 | 56226.9 |
223 | 2024-03-26 09:55:21 | bakehouses | 2 | 108824 | 9 | 7.063 | 15407.6 |
222 | 2024-03-26 07:17:29 | bakehouses | 1 | 67641 | 2 | 1.250 | 54112.8 |
221 | 2024-03-25 14:16:46 | bakehouses | 1 | 67641 | 2 | 1.140 | 59334.2 |
220 | 2024-03-13 14:55:48 | bakehouses | 1 | 67641 | 2 | 2.703 | 25024.4 |
219 | 2024-03-07 10:51:52 | bakehouses | 2 | 108824 | 9 | 12.093 | 8998.9 |
218 | 2024-03-07 05:31:16 | bakehouses | 1 | 67641 | 2 | 2.343 | 28869.4 |
217 | 2024-03-06 12:27:15 | bakehouses | 3 | 140603 | 41 | 13.890 | 10122.6 |
216 | 2024-02-26 01:17:09 | bakehouses | 1 | 67641 | 2 | 1.140 | 59334.2 |
215 | 2024-02-23 03:00:11 | bakehouses | 4 | 161450 | 147 | 11.780 | 13705.4 |
214 | 2024-02-23 03:00:12 | bakehouses | 3 | 140603 | 41 | 6.783 | 20728.7 |
213 | 2024-02-23 03:00:15 | bakehouses | 2 | 108824 | 9 | 3.266 | 33320.3 |
212 | 2024-02-22 22:48:46 | bakehouses | 1 | 67641 | 2 | 1.110 | 60937.8 |
211 | 2024-02-19 18:34:38 | bakehouses | 1 | 67641 | 2 | 1.266 | 53428.9 |
210 | 2024-02-10 06:57:18 | bakehouses | 4 | 161450 | 147 | 13.893 | 11621.0 |
209 | 2024-02-07 02:04:22 | bakehouses | 1 | 67641 | 2 | 1.140 | 59334.2 |
208 | 2024-02-01 09:52:56 | bakehouses | 1 | 67641 | 2 | 1.140 | 59334.2 |
207 | 2024-01-23 01:37:29 | bakehouses | 1 | 67641 | 2 | 1.250 | 54112.8 |
206 | 2024-01-17 18:00:42 | bakehouses | 4 | 161450 | 147 | 13.233 | 12200.6 |
205 | 2024-01-17 18:00:44 | bakehouses | 2 | 108824 | 9 | 6.393 | 17022.4 |
204 | 2024-01-17 18:00:41 | bakehouses | 3 | 140603 | 41 | 7.326 | 19192.3 |
203 | 2024-01-08 01:50:39 | bakehouses | 4 | 161450 | 147 | 9.513 | 16971.5 |
202 | 2023-12-29 21:31:11 | bakehouses | 1 | 67641 | 2 | 1.156 | 58513.0 |
201 | 2023-12-26 16:26:37 | bakehouses | 1 | 67641 | 2 | 1.093 | 61885.6 |
200 | 2023-12-07 07:10:12 | bakehouses | 1 | 67641 | 2 | 1.123 | 60232.4 |
199 | 2023-11-29 01:26:18 | bakehouses | 1 | 67641 | 2 | 1.080 | 62630.6 |
198 | 2023-11-25 05:04:23 | bakehouses | 3 | 140603 | 41 | 5.220 | 26935.4 |
197 | 2023-11-02 09:17:25 | bakehouses | 1 | 67641 | 2 | 1.173 | 57665.0 |
196 | 2023-10-19 18:32:38 | bakehouses | 1 | 67641 | 2 | 1.093 | 61885.6 |
195 | 2023-10-15 07:25:16 | bakehouses | 4 | 161450 | 147 | 11.050 | 14610.9 |
194 | 2023-09-22 14:58:37 | bakehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
193 | 2023-08-25 11:30:27 | bakehouses | 3 | 140603 | 41 | 5.610 | 25062.9 |
192 | 2023-08-14 05:50:00 | bakehouses | 1 | 67641 | 2 | 1.033 | 65480.2 |
191 | 2023-08-10 19:00:58 | bakehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
190 | 2023-07-26 03:38:00 | bakehouses | 4 | 161450 | 147 | 10.453 | 15445.3 |
189 | 2023-07-19 16:24:56 | bakehouses | 1 | 67641 | 2 | 1.093 | 61885.6 |
188 | 2023-07-07 19:11:48 | bakehouses | 4 | 161450 | 147 | 9.390 | 17193.8 |
187 | 2023-06-04 02:21:50 | bakehouses | 4 | 161450 | 147 | 9.236 | 17480.5 |
186 | 2023-05-10 01:49:13 | bakehouses | 3 | 140603 | 41 | 5.283 | 26614.2 |
185 | 2023-05-03 18:05:09 | bakehouses | 1 | 67641 | 2 | 1.030 | 65670.9 |
184 | 2023-04-22 12:20:55 | bakehouses | 1 | 67641 | 2 | 1.016 | 66575.8 |
183 | 2023-04-07 13:42:29 | bakehouses | 1 | 67641 | 2 | 1.123 | 60232.4 |
182 | 2023-04-06 08:02:16 | bakehouses | 4 | 161450 | 147 | 9.876 | 16347.7 |
181 | 2023-04-03 20:07:32 | bakehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
180 | 2023-03-23 11:37:41 | bakehouses | 1 | 67641 | 2 | 0.983 | 68810.8 |
179 | 2023-02-15 04:38:44 | bakehouses | 3 | 140603 | 41 | 6.610 | 21271.3 |
178 | 2023-02-11 05:08:38 | bakehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
177 | 2023-01-04 06:16:43 | bakehouses | 4 | 161450 | 147 | 10.376 | 15559.9 |
176 | 2022-12-08 16:53:24 | bakehouses | 1 | 67641 | 2 | 0.983 | 68810.8 |
175 | 2022-11-29 02:56:24 | bakehouses | 1 | 67641 | 2 | 1.063 | 63632.2 |
174 | 2022-11-27 12:14:56 | bakehouses | 3 | 140603 | 41 | 5.266 | 26700.2 |
173 | 2022-11-25 19:58:04 | bakehouses | 1 | 67641 | 2 | 0.983 | 68810.8 |
172 | 2022-09-06 05:58:36 | bakehouses | 4 | 161450 | 147 | 10.640 | 15173.9 |
171 | 2022-09-04 03:35:22 | bakehouses | 4 | 161450 | 147 | 9.406 | 17164.6 |
170 | 2022-08-25 13:43:04 | bakehouses | 1 | 67641 | 2 | 1.013 | 66773.0 |
169 | 2022-08-10 16:20:57 | bakehouses | 1 | 67641 | 2 | 1.093 | 61885.6 |
168 | 2022-08-08 06:53:16 | bakehouses | 1 | 67641 | 2 | 1.390 | 48662.6 |
167 | 2022-07-18 20:32:01 | bakehouses | 1 | 67641 | 2 | 1.080 | 62630.6 |
166 | 2022-06-26 07:52:51 | bakehouses | 1 | 67641 | 2 | 0.986 | 68601.4 |
165 | 2022-06-08 06:26:30 | bakehouses | 4 | 161450 | 147 | 9.970 | 16193.6 |
164 | 2022-05-25 21:25:19 | bakehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
163 | 2022-04-24 15:51:07 | bakehouses | 4 | 161450 | 147 | 9.296 | 17367.7 |
162 | 2022-04-10 10:08:40 | bakehouses | 3 | 140603 | 41 | 5.720 | 24580.9 |
161 | 2022-03-28 19:35:23 | bakehouses | 1 | 67641 | 2 | 1.263 | 53555.8 |
160 | 2022-03-26 14:56:17 | bakehouses | 1 | 67641 | 2 | 0.983 | 68810.8 |
159 | 2022-03-25 09:30:09 | bakehouses | 4 | 161450 | 147 | 12.326 | 13098.3 |
158 | 2022-03-04 08:04:23 | bakehouses | 1 | 67641 | 2 | 1.110 | 60937.8 |
157 | 2022-02-28 22:00:15 | bakehouses | 1 | 67641 | 2 | 3.250 | 20812.6 |
156 | 2022-02-11 07:01:41 | bakehouses | 1 | 67641 | 2 | 1.063 | 63632.2 |
155 | 2021-12-28 06:45:22 | bakehouses | 1 | 67641 | 2 | 1.030 | 65670.9 |
154 | 2021-11-06 03:27:59 | bakehouses | 1 | 67641 | 2 | 1.110 | 60937.8 |
153 | 2021-10-28 03:44:32 | bakehouses | 1 | 67641 | 2 | 1.016 | 66575.8 |
152 | 2021-10-12 12:46:56 | bakehouses | 1 | 67641 | 2 | 2.233 | 30291.5 |
151 | 2021-09-08 10:24:42 | bakehouses | 1 | 67641 | 2 | 0.983 | 68810.8 |
150 | 2021-08-27 02:42:59 | bakehouses | 1 | 67641 | 2 | 1.016 | 66575.8 |
149 | 2021-07-27 09:52:12 | bakehouses | 1 | 67641 | 2 | 1.186 | 57032.9 |
148 | 2021-07-17 19:51:42 | bakehouses | 1 | 67641 | 2 | 1.016 | 66575.8 |
147 | 2021-05-31 01:03:11 | bakehouses | 2 | 108824 | 9 | 2.986 | 36444.7 |
146 | 2021-05-05 18:45:16 | bakehouses | 2 | 108824 | 9 | 3.190 | 34114.1 |
145 | 2021-04-15 01:12:11 | bakehouses | 1 | 67641 | 2 | 1.170 | 57812.8 |
144 | 2021-04-03 22:16:30 | bakehouses | 2 | 108824 | 9 | 3.220 | 33796.3 |
143 | 2021-02-18 11:02:44 | bakehouses | 1 | 67641 | 2 | 2.216 | 30523.9 |
142 | 2021-02-12 06:12:26 | bakehouses | 2 | 108824 | 9 | 2.593 | 41968.4 |
141 | 2021-01-01 11:40:21 | bakehouses | 1 | 67641 | 2 | 1.016 | 66575.8 |
140 | 2020-12-19 18:39:13 | bakehouses | 2 | 108824 | 9 | 2.703 | 40260.5 |
139 | 2020-11-19 20:04:06 | bakehouses | 2 | 108824 | 9 | 2.623 | 41488.4 |
138 | 2020-11-08 12:05:35 | bakehouses | 1 | 67641 | 2 | 1.170 | 57812.8 |
137 | 2020-10-18 02:47:01 | bakehouses | 1 | 67641 | 2 | 1.110 | 60937.8 |
136 | 2020-10-13 21:48:57 | bakehouses | 1 | 67641 | 2 | 1.013 | 66773.0 |
135 | 2020-10-06 00:00:35 | bakehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |