History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"unicorns"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
237 | 2024-04-23 03:36:34 | unicorns | 1 | 82945 | 2 | 2.236 | 37095.3 |
236 | 2024-04-23 03:36:27 | unicorns | 2 | 121059 | 8 | 3.783 | 32000.8 |
235 | 2024-04-23 03:35:51 | unicorns | 3 | 146162 | 62 | 9.893 | 14774.3 |
234 | 2024-04-18 23:28:52 | unicorns | 3 | 146162 | 62 | 23.330 | 6265.0 |
233 | 2024-04-17 06:14:18 | unicorns | 3 | 146162 | 62 | 13.046 | 11203.6 |
232 | 2024-04-15 22:52:46 | unicorns | 3 | 146162 | 62 | 22.126 | 6605.9 |
231 | 2024-04-15 22:52:48 | unicorns | 2 | 121059 | 8 | 17.906 | 6760.8 |
230 | 2024-04-15 22:17:05 | unicorns | 1 | 82945 | 2 | 1.610 | 51518.6 |
229 | 2024-04-05 11:11:59 | unicorns | 2 | 121059 | 8 | 4.516 | 26806.7 |
228 | 2024-04-05 11:11:56 | unicorns | 1 | 82945 | 2 | 1.580 | 52496.8 |
227 | 2024-04-05 11:11:19 | unicorns | 4 | 161609 | 598 | 20.313 | 7955.9 |
226 | 2024-04-01 16:12:40 | unicorns | 1 | 82945 | 2 | 4.326 | 19173.6 |
225 | 2024-03-31 19:27:58 | unicorns | 4 | 161609 | 598 | 31.876 | 5069.9 |
224 | 2024-03-30 20:51:15 | unicorns | 4 | 161609 | 598 | 44.520 | 3630.0 |
223 | 2024-03-30 08:42:45 | unicorns | 4 | 161609 | 598 | 36.986 | 4369.5 |
222 | 2024-03-30 08:42:46 | unicorns | 2 | 121059 | 8 | 12.763 | 9485.2 |
221 | 2024-03-30 08:10:56 | unicorns | 1 | 82945 | 2 | 2.406 | 34474.2 |
220 | 2024-03-28 22:51:16 | unicorns | 1 | 82945 | 2 | 4.716 | 17588.0 |
219 | 2024-03-14 16:24:56 | unicorns | 3 | 146162 | 62 | 20.033 | 7296.1 |
218 | 2024-03-11 23:47:32 | unicorns | 3 | 146162 | 62 | 24.750 | 5905.5 |
217 | 2024-03-10 22:28:28 | unicorns | 3 | 146162 | 62 | 8.093 | 18060.3 |
216 | 2024-03-10 22:28:29 | unicorns | 2 | 121059 | 8 | 3.923 | 30858.8 |
215 | 2024-03-10 22:28:25 | unicorns | 1 | 82945 | 2 | 1.530 | 54212.4 |
214 | 2024-03-08 00:42:53 | unicorns | 4 | 161609 | 598 | 18.390 | 8787.9 |
213 | 2024-03-02 12:33:23 | unicorns | 2 | 121059 | 8 | 5.283 | 22914.8 |
212 | 2024-03-02 03:55:56 | unicorns | 3 | 146162 | 62 | 7.440 | 19645.4 |
211 | 2024-03-01 16:41:16 | unicorns | 4 | 161609 | 598 | 19.953 | 8099.5 |
210 | 2024-02-28 21:55:20 | unicorns | 1 | 82945 | 2 | 2.983 | 27805.9 |
209 | 2024-02-27 21:21:27 | unicorns | 1 | 82945 | 2 | 2.656 | 31229.3 |
208 | 2024-02-27 21:21:02 | unicorns | 2 | 121059 | 8 | 3.970 | 30493.5 |
207 | 2024-02-27 21:20:48 | unicorns | 3 | 146162 | 62 | 8.250 | 17716.6 |
206 | 2024-02-27 18:04:07 | unicorns | 4 | 161609 | 598 | 14.623 | 11051.7 |
205 | 2024-02-27 18:04:10 | unicorns | 3 | 146162 | 62 | 7.440 | 19645.4 |
204 | 2024-02-27 18:04:09 | unicorns | 2 | 121059 | 8 | 3.813 | 31749.0 |
203 | 2024-02-27 18:04:03 | unicorns | 1 | 82945 | 2 | 1.360 | 60989.0 |
202 | 2024-02-10 13:04:26 | unicorns | 2 | 121059 | 8 | 3.690 | 32807.3 |
201 | 2024-02-10 12:11:57 | unicorns | 3 | 146162 | 62 | 8.186 | 17855.1 |
200 | 2024-02-07 22:25:22 | unicorns | 3 | 146162 | 62 | 18.080 | 8084.2 |
199 | 2024-02-04 18:29:38 | unicorns | 3 | 146162 | 62 | 13.110 | 11148.9 |
198 | 2024-02-04 18:29:42 | unicorns | 2 | 121059 | 8 | 6.546 | 18493.6 |
197 | 2024-02-04 05:41:03 | unicorns | 4 | 161609 | 598 | 11.983 | 13486.5 |
196 | 2024-01-27 12:07:39 | unicorns | 2 | 121059 | 8 | 3.626 | 33386.4 |
195 | 2024-01-27 12:07:27 | unicorns | 3 | 146162 | 62 | 7.516 | 19446.8 |
194 | 2024-01-27 03:01:57 | unicorns | 3 | 146162 | 62 | 7.173 | 20376.7 |
193 | 2024-01-26 15:55:35 | unicorns | 3 | 146162 | 62 | 8.750 | 16704.2 |
192 | 2024-01-26 08:26:35 | unicorns | 4 | 161609 | 598 | 23.313 | 6932.1 |
191 | 2024-01-26 08:26:31 | unicorns | 4 | 161609 | 598 | 24.596 | 6570.5 |
190 | 2024-01-15 05:46:18 | unicorns | 1 | 82945 | 2 | 1.236 | 67107.6 |
189 | 2024-01-07 22:58:04 | unicorns | 3 | 146162 | 62 | 6.800 | 21494.4 |
188 | 2023-12-24 21:54:17 | unicorns | 4 | 161609 | 598 | 12.030 | 13433.8 |
187 | 2023-12-03 01:49:26 | unicorns | 1 | 82945 | 2 | 1.360 | 60989.0 |
186 | 2023-11-11 02:18:41 | unicorns | 1 | 82945 | 2 | 1.216 | 68211.3 |
185 | 2023-10-14 09:14:28 | unicorns | 1 | 82945 | 2 | 1.263 | 65673.0 |
184 | 2023-10-13 07:10:18 | unicorns | 3 | 146162 | 62 | 6.280 | 23274.2 |
183 | 2023-09-27 10:31:29 | unicorns | 4 | 161609 | 598 | 10.610 | 15231.8 |
182 | 2023-09-19 18:29:41 | unicorns | 1 | 82945 | 2 | 2.970 | 27927.6 |
181 | 2023-08-30 14:35:10 | unicorns | 1 | 82945 | 2 | 1.360 | 60989.0 |
180 | 2023-07-23 22:27:11 | unicorns | 3 | 146162 | 62 | 7.016 | 20832.7 |
179 | 2023-07-07 08:14:08 | unicorns | 4 | 161609 | 598 | 12.156 | 13294.6 |
178 | 2023-06-05 19:50:48 | unicorns | 1 | 82945 | 2 | 1.360 | 60989.0 |
177 | 2023-04-04 14:45:07 | unicorns | 3 | 146162 | 62 | 6.076 | 24055.6 |
176 | 2023-03-30 03:45:54 | unicorns | 1 | 82945 | 2 | 1.233 | 67270.9 |
175 | 2023-03-28 06:31:48 | unicorns | 4 | 161609 | 598 | 10.516 | 15367.9 |
174 | 2023-01-14 17:24:46 | unicorns | 1 | 82945 | 2 | 1.220 | 67987.7 |
173 | 2023-01-01 13:35:25 | unicorns | 3 | 146162 | 62 | 6.013 | 24307.7 |
172 | 2022-12-27 02:34:06 | unicorns | 4 | 161609 | 598 | 10.330 | 15644.6 |
171 | 2022-12-24 03:23:01 | unicorns | 1 | 82945 | 2 | 2.593 | 31988.0 |
170 | 2022-12-23 06:04:05 | unicorns | 4 | 161609 | 598 | 12.110 | 13345.1 |
169 | 2022-11-13 09:23:47 | unicorns | 1 | 82945 | 2 | 1.233 | 67270.9 |
168 | 2022-11-06 19:53:18 | unicorns | 1 | 82945 | 2 | 1.220 | 67987.7 |
167 | 2022-11-06 05:58:19 | unicorns | 4 | 161609 | 598 | 19.876 | 8130.9 |
166 | 2022-10-26 13:25:44 | unicorns | 4 | 161609 | 598 | 25.530 | 6330.2 |
165 | 2022-09-24 09:36:30 | unicorns | 4 | 161609 | 598 | 10.313 | 15670.4 |
164 | 2022-09-18 01:59:28 | unicorns | 1 | 82945 | 2 | 1.236 | 67107.6 |
163 | 2022-09-02 11:01:05 | unicorns | 3 | 146162 | 62 | 6.423 | 22756.0 |
162 | 2022-08-27 05:11:41 | unicorns | 4 | 161609 | 598 | 10.406 | 15530.4 |
161 | 2022-08-23 07:41:58 | unicorns | 1 | 82945 | 2 | 1.280 | 64800.8 |
160 | 2022-06-25 19:01:34 | unicorns | 1 | 82945 | 2 | 1.220 | 67987.7 |
159 | 2021-05-08 22:15:38 | unicorns | 1 | 82945 | 2 | 1.533 | 54106.3 |
158 | 2021-04-07 09:00:52 | unicorns | 1 | 82945 | 2 | 1.453 | 57085.3 |
157 | 2021-01-22 12:38:57 | unicorns | 1 | 82945 | 2 | 1.373 | 60411.5 |
156 | 2020-10-22 12:06:35 | unicorns | 1 | 82945 | 2 | 1.393 | 59544.1 |
155 | 2020-10-16 17:07:24 | unicorns | 1 | 82945 | 2 | 1.250 | 66356.0 |
154 | 2020-10-08 01:47:56 | unicorns | 1 | 82945 | 2 | 1.250 | 66356.0 |
153 | 2020-06-21 23:06:46 | unicorns | 1 | 82945 | 2 | 1.920 | 43200.5 |
152 | 2020-04-03 23:03:42 | unicorns | 1 | 82945 | 2 | 1.296 | 64000.8 |
151 | 2020-03-29 01:40:39 | unicorns | 1 | 82945 | 2 | 1.546 | 53651.4 |
150 | 2020-03-23 03:42:29 | unicorns | 1 | 82945 | 2 | 1.486 | 55817.6 |
149 | 2020-02-29 10:29:07 | unicorns | 1 | 82945 | 2 | 3.360 | 24686.0 |
148 | 2020-02-22 23:41:04 | unicorns | 1 | 82945 | 2 | 1.796 | 46183.2 |
147 | 2020-02-19 02:12:02 | unicorns | 1 | 82945 | 2 | 3.063 | 27079.7 |
146 | 2020-02-19 00:27:16 | unicorns | 1 | 82945 | 2 | 3.126 | 26533.9 |
145 | 2020-02-03 20:25:13 | unicorns | 1 | 82945 | 2 | 2.903 | 28572.2 |
144 | 2020-02-03 18:32:26 | unicorns | 1 | 82945 | 2 | 3.533 | 23477.2 |
143 | 2020-02-03 15:48:08 | unicorns | 1 | 82945 | 2 | 1.516 | 54713.1 |
142 | 2020-01-27 03:47:47 | unicorns | 1 | 82945 | 2 | 4.763 | 17414.4 |
141 | 2020-01-25 15:57:53 | unicorns | 1 | 82945 | 2 | 4.753 | 17451.1 |
140 | 2020-01-24 07:09:24 | unicorns | 1 | 82945 | 2 | 1.516 | 54713.1 |
139 | 2020-01-23 17:02:33 | unicorns | 1 | 82945 | 2 | 3.126 | 26533.9 |
138 | 2020-01-17 03:17:22 | unicorns | 1 | 82945 | 2 | 2.063 | 40206.0 |