History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"showroom"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
231 | 2024-05-23 23:23:49 | showroom | 1 | 82945 | 2 | 1.813 | 45750.1 |
230 | 2024-05-23 05:58:41 | showroom | 4 | 161609 | 221 | 29.923 | 5400.8 |
229 | 2024-05-11 11:50:25 | showroom | 4 | 161609 | 221 | 37.160 | 4349.0 |
228 | 2024-05-11 11:50:26 | showroom | 2 | 121059 | 2 | 12.530 | 9661.5 |
227 | 2024-05-11 11:50:24 | showroom | 1 | 82945 | 2 | 1.656 | 50087.6 |
226 | 2024-05-09 21:40:14 | showroom | 3 | 146162 | 21 | 24.970 | 5853.5 |
225 | 2024-05-09 18:06:52 | showroom | 3 | 146162 | 21 | 6.233 | 23449.7 |
224 | 2024-05-01 13:27:21 | showroom | 4 | 161609 | 221 | 20.923 | 7724.0 |
223 | 2024-05-01 10:46:56 | showroom | 4 | 161609 | 221 | 39.673 | 4073.5 |
222 | 2024-05-01 02:24:49 | showroom | 4 | 161609 | 221 | 13.393 | 12066.7 |
221 | 2024-05-01 02:24:54 | showroom | 1 | 82945 | 2 | 2.360 | 35146.2 |
220 | 2024-05-01 02:24:41 | showroom | 2 | 121059 | 2 | 5.140 | 23552.3 |
219 | 2024-04-28 19:03:09 | showroom | 3 | 146162 | 21 | 8.393 | 17414.8 |
218 | 2024-04-28 19:03:11 | showroom | 1 | 82945 | 2 | 1.563 | 53067.8 |
217 | 2024-04-28 19:03:05 | showroom | 2 | 121059 | 2 | 3.143 | 38517.0 |
216 | 2024-04-27 12:01:54 | showroom | 3 | 146162 | 21 | 20.000 | 7308.1 |
215 | 2024-04-26 20:13:22 | showroom | 3 | 146162 | 21 | 18.360 | 7960.9 |
214 | 2024-04-26 20:13:24 | showroom | 2 | 121059 | 2 | 11.063 | 10942.7 |
213 | 2024-04-26 20:13:15 | showroom | 3 | 146162 | 21 | 16.826 | 8686.7 |
212 | 2024-04-26 20:13:12 | showroom | 1 | 82945 | 2 | 3.563 | 23279.5 |
211 | 2024-04-19 03:59:43 | showroom | 2 | 121059 | 2 | 9.190 | 13172.9 |
210 | 2024-04-19 03:22:59 | showroom | 1 | 82945 | 2 | 1.483 | 55930.5 |
209 | 2024-04-10 22:14:26 | showroom | 1 | 82945 | 2 | 1.626 | 51011.7 |
208 | 2024-04-10 07:39:32 | showroom | 3 | 146162 | 21 | 31.736 | 4605.6 |
207 | 2024-04-10 07:39:41 | showroom | 2 | 121059 | 2 | 7.690 | 15742.4 |
206 | 2024-04-10 07:39:15 | showroom | 1 | 82945 | 2 | 3.406 | 24352.6 |
205 | 2024-04-09 22:04:16 | showroom | 4 | 161609 | 221 | 17.830 | 9063.9 |
204 | 2024-04-04 03:19:04 | showroom | 4 | 161609 | 221 | 28.346 | 5701.3 |
203 | 2024-04-04 03:18:58 | showroom | 4 | 161609 | 221 | 30.423 | 5312.1 |
202 | 2024-04-01 08:55:43 | showroom | 4 | 161609 | 221 | 14.030 | 11518.8 |
201 | 2024-04-01 07:00:55 | showroom | 2 | 121059 | 2 | 4.690 | 25812.2 |
200 | 2024-03-31 13:07:06 | showroom | 4 | 161609 | 221 | 35.143 | 4598.6 |
199 | 2024-03-30 04:01:57 | showroom | 2 | 121059 | 2 | 8.920 | 13571.6 |
198 | 2024-03-30 03:07:24 | showroom | 3 | 146162 | 21 | 7.703 | 18974.7 |
197 | 2024-03-26 17:00:42 | showroom | 2 | 121059 | 2 | 3.670 | 32986.1 |
196 | 2024-03-26 16:59:49 | showroom | 3 | 146162 | 21 | 10.936 | 13365.2 |
195 | 2024-03-26 16:44:57 | showroom | 1 | 82945 | 2 | 1.343 | 61761.0 |
194 | 2024-03-26 16:39:05 | showroom | 4 | 161609 | 221 | 13.673 | 11819.6 |
193 | 2024-03-26 16:39:09 | showroom | 2 | 121059 | 2 | 4.546 | 26629.8 |
192 | 2024-03-26 16:39:02 | showroom | 3 | 146162 | 21 | 7.703 | 18974.7 |
191 | 2024-03-24 23:03:35 | showroom | 1 | 82945 | 2 | 1.280 | 64800.8 |
190 | 2024-03-20 03:03:18 | showroom | 1 | 82945 | 2 | 3.140 | 26415.6 |
189 | 2024-03-20 03:03:06 | showroom | 2 | 121059 | 2 | 3.783 | 32000.8 |
188 | 2024-03-20 03:02:55 | showroom | 1 | 82945 | 2 | 1.466 | 56579.1 |
187 | 2024-03-18 07:21:54 | showroom | 1 | 82945 | 2 | 1.513 | 54821.5 |
186 | 2024-03-18 03:59:38 | showroom | 1 | 82945 | 2 | 1.280 | 64800.8 |
185 | 2024-03-07 22:42:56 | showroom | 4 | 161609 | 221 | 14.626 | 11049.4 |
184 | 2024-03-07 20:30:53 | showroom | 4 | 161609 | 221 | 17.846 | 9055.8 |
183 | 2024-03-02 12:08:01 | showroom | 2 | 121059 | 2 | 4.360 | 27765.8 |
182 | 2024-03-02 04:00:00 | showroom | 4 | 161609 | 221 | 20.813 | 7764.8 |
181 | 2024-03-02 04:00:04 | showroom | 3 | 146162 | 21 | 8.623 | 16950.2 |
180 | 2024-02-26 06:00:03 | showroom | 2 | 121059 | 2 | 8.876 | 13638.9 |
179 | 2024-02-26 04:03:19 | showroom | 3 | 146162 | 21 | 8.046 | 18165.8 |
178 | 2024-02-25 08:09:53 | showroom | 4 | 161609 | 221 | 16.923 | 9549.7 |
177 | 2024-02-25 08:09:52 | showroom | 2 | 121059 | 2 | 8.343 | 14510.2 |
176 | 2024-02-25 08:09:51 | showroom | 3 | 146162 | 21 | 8.593 | 17009.4 |
175 | 2024-02-25 08:09:50 | showroom | 1 | 82945 | 2 | 3.190 | 26001.6 |
174 | 2024-02-20 18:37:03 | showroom | 1 | 82945 | 2 | 3.096 | 26791.0 |
173 | 2024-02-15 07:50:37 | showroom | 1 | 82945 | 2 | 1.533 | 54106.3 |
172 | 2024-02-04 13:25:29 | showroom | 4 | 161609 | 221 | 41.830 | 3863.5 |
171 | 2024-02-03 04:14:46 | showroom | 2 | 121059 | 2 | 7.720 | 15681.2 |
170 | 2024-02-03 04:14:30 | showroom | 1 | 82945 | 2 | 1.453 | 57085.3 |
169 | 2024-01-30 05:43:53 | showroom | 1 | 82945 | 2 | 1.533 | 54106.3 |
168 | 2024-01-26 10:01:01 | showroom | 2 | 121059 | 2 | 3.106 | 38975.9 |
167 | 2024-01-26 10:00:49 | showroom | 3 | 146162 | 21 | 6.173 | 23677.6 |
166 | 2024-01-26 07:02:39 | showroom | 4 | 161609 | 221 | 26.796 | 6031.1 |
165 | 2024-01-26 07:02:03 | showroom | 4 | 161609 | 221 | 23.236 | 6955.1 |
164 | 2024-01-26 07:02:07 | showroom | 3 | 146162 | 21 | 8.343 | 17519.1 |
163 | 2024-01-15 16:24:46 | showroom | 1 | 82945 | 2 | 1.466 | 56579.1 |
162 | 2024-01-09 06:45:06 | showroom | 1 | 82945 | 2 | 1.453 | 57085.3 |
161 | 2024-01-05 01:29:53 | showroom | 3 | 146162 | 21 | 6.360 | 22981.4 |
160 | 2023-12-17 18:03:47 | showroom | 1 | 82945 | 2 | 1.376 | 60279.8 |
159 | 2023-12-08 08:00:20 | showroom | 4 | 161609 | 221 | 10.280 | 15720.7 |
158 | 2023-11-10 19:58:45 | showroom | 1 | 82945 | 2 | 1.266 | 65517.4 |
157 | 2023-10-12 07:56:18 | showroom | 3 | 146162 | 21 | 6.236 | 23438.4 |
156 | 2023-10-06 01:07:01 | showroom | 1 | 82945 | 2 | 1.280 | 64800.8 |
155 | 2023-09-24 12:26:55 | showroom | 1 | 82945 | 2 | 1.453 | 57085.3 |
154 | 2023-09-14 09:53:38 | showroom | 1 | 82945 | 2 | 1.593 | 52068.4 |
153 | 2023-09-05 16:34:18 | showroom | 4 | 161609 | 221 | 10.233 | 15792.9 |
152 | 2023-08-19 06:12:12 | showroom | 1 | 82945 | 2 | 1.450 | 57203.4 |
151 | 2023-08-03 02:40:24 | showroom | 1 | 82945 | 2 | 1.313 | 63172.1 |
150 | 2023-07-21 23:21:15 | showroom | 3 | 146162 | 21 | 7.156 | 20425.1 |
149 | 2023-05-17 22:47:43 | showroom | 4 | 161609 | 221 | 10.250 | 15766.7 |
148 | 2023-05-01 07:21:05 | showroom | 1 | 82945 | 2 | 1.436 | 57761.1 |
147 | 2023-04-03 05:38:58 | showroom | 3 | 146162 | 21 | 6.940 | 21060.8 |
146 | 2023-03-25 12:05:04 | showroom | 1 | 82945 | 2 | 1.280 | 64800.8 |
145 | 2023-02-27 04:22:04 | showroom | 4 | 161609 | 221 | 10.186 | 15865.8 |
144 | 2023-02-24 00:06:08 | showroom | 1 | 82945 | 2 | 1.263 | 65673.0 |
143 | 2023-02-19 07:26:19 | showroom | 4 | 161609 | 221 | 10.203 | 15839.4 |
142 | 2022-12-31 15:10:09 | showroom | 3 | 146162 | 21 | 6.096 | 23976.7 |
141 | 2022-12-30 13:05:03 | showroom | 4 | 161609 | 221 | 12.486 | 12943.2 |
140 | 2022-12-21 06:01:11 | showroom | 1 | 82945 | 2 | 1.250 | 66356.0 |
139 | 2022-12-08 23:03:26 | showroom | 4 | 161609 | 221 | 10.280 | 15720.7 |
138 | 2022-11-28 11:57:58 | showroom | 3 | 146162 | 21 | 7.266 | 20115.9 |
137 | 2022-11-15 00:05:55 | showroom | 4 | 161609 | 221 | 10.970 | 14731.9 |
136 | 2022-11-14 19:06:19 | showroom | 4 | 161609 | 221 | 12.313 | 13125.1 |
135 | 2022-10-30 10:37:58 | showroom | 1 | 82945 | 2 | 1.483 | 55930.5 |
134 | 2022-10-27 17:38:26 | showroom | 4 | 161609 | 221 | 12.063 | 13397.1 |
133 | 2022-10-26 17:41:47 | showroom | 1 | 82945 | 2 | 1.250 | 66356.0 |
132 | 2022-10-17 11:53:47 | showroom | 4 | 161609 | 221 | 10.360 | 15599.3 |