History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sitcoms"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
232 | 2024-04-27 18:57:46 | sitcoms | 1 | 69583 | 2 | 1.326 | 52475.9 |
231 | 2024-04-25 11:05:47 | sitcoms | 1 | 69583 | 2 | 1.453 | 47889.2 |
230 | 2024-04-10 12:12:32 | sitcoms | 1 | 69583 | 2 | 2.783 | 25002.9 |
229 | 2024-03-30 13:10:26 | sitcoms | 1 | 69583 | 2 | 1.643 | 42351.2 |
228 | 2024-03-28 20:50:32 | sitcoms | 1 | 69583 | 2 | 1.423 | 48898.8 |
227 | 2024-03-22 07:16:43 | sitcoms | 3 | 134027 | 132 | 6.643 | 20175.7 |
226 | 2024-03-22 07:16:44 | sitcoms | 2 | 107671 | 4 | 3.360 | 32044.9 |
225 | 2024-03-22 07:16:38 | sitcoms | 1 | 69583 | 2 | 1.233 | 56433.9 |
224 | 2024-02-22 06:02:45 | sitcoms | 3 | 134027 | 132 | 8.016 | 16719.9 |
223 | 2024-02-21 03:33:19 | sitcoms | 3 | 134027 | 132 | 19.236 | 6967.5 |
222 | 2024-02-21 03:33:20 | sitcoms | 2 | 107671 | 4 | 7.220 | 14912.9 |
221 | 2024-02-21 00:38:16 | sitcoms | 1 | 69583 | 2 | 1.390 | 50059.7 |
220 | 2024-02-05 06:31:29 | sitcoms | 1 | 69583 | 2 | 2.513 | 27689.2 |
219 | 2024-01-12 23:52:36 | sitcoms | 1 | 69583 | 2 | 1.313 | 52995.4 |
218 | 2023-12-30 22:37:06 | sitcoms | 1 | 69583 | 2 | 1.216 | 57222.9 |
217 | 2023-12-26 10:48:12 | sitcoms | 1 | 69583 | 2 | 1.390 | 50059.7 |
216 | 2023-12-24 01:06:25 | sitcoms | 1 | 69583 | 2 | 1.126 | 61796.6 |
215 | 2023-11-28 18:27:24 | sitcoms | 1 | 69583 | 2 | 1.080 | 64428.7 |
214 | 2023-11-11 18:28:33 | sitcoms | 1 | 69583 | 2 | 1.360 | 51164.0 |
213 | 2023-09-29 15:18:55 | sitcoms | 1 | 69583 | 2 | 1.123 | 61961.7 |
212 | 2023-09-12 22:14:49 | sitcoms | 1 | 69583 | 2 | 1.390 | 50059.7 |
211 | 2023-08-10 12:08:30 | sitcoms | 1 | 69583 | 2 | 1.280 | 54361.7 |
210 | 2023-06-23 18:17:38 | sitcoms | 1 | 69583 | 2 | 1.143 | 60877.5 |
209 | 2023-05-27 15:32:49 | sitcoms | 1 | 69583 | 2 | 1.096 | 63488.1 |
208 | 2023-04-13 06:46:08 | sitcoms | 1 | 69583 | 2 | 1.313 | 52995.4 |
207 | 2023-04-08 09:33:01 | sitcoms | 1 | 69583 | 2 | 1.186 | 58670.3 |
206 | 2023-04-03 12:54:22 | sitcoms | 1 | 69583 | 2 | 1.186 | 58670.3 |
205 | 2023-04-02 11:34:47 | sitcoms | 1 | 69583 | 2 | 1.220 | 57035.2 |
204 | 2023-01-14 21:39:05 | sitcoms | 1 | 69583 | 2 | 1.060 | 65644.3 |
203 | 2022-11-25 13:57:26 | sitcoms | 1 | 69583 | 2 | 1.076 | 64668.2 |
202 | 2022-11-07 21:24:19 | sitcoms | 1 | 69583 | 2 | 1.093 | 63662.4 |
201 | 2022-07-14 17:52:43 | sitcoms | 1 | 69583 | 2 | 1.093 | 63662.4 |
200 | 2022-06-27 19:10:44 | sitcoms | 1 | 69583 | 2 | 1.500 | 46388.7 |
199 | 2022-03-19 23:54:38 | sitcoms | 1 | 69583 | 2 | 1.093 | 63662.4 |
198 | 2022-03-17 20:49:47 | sitcoms | 1 | 69583 | 2 | 1.440 | 48321.5 |
197 | 2022-02-28 15:58:22 | sitcoms | 1 | 69583 | 2 | 1.330 | 52318.0 |
196 | 2021-10-31 05:57:18 | sitcoms | 1 | 69583 | 2 | 1.233 | 56433.9 |
195 | 2021-07-14 00:43:01 | sitcoms | 1 | 69583 | 2 | 1.200 | 57985.8 |
194 | 2021-06-10 08:14:53 | sitcoms | 3 | 134027 | 132 | 6.516 | 20568.9 |
193 | 2021-06-04 04:43:10 | sitcoms | 1 | 69583 | 2 | 1.340 | 51927.6 |
192 | 2021-05-09 23:04:40 | sitcoms | 1 | 69583 | 2 | 1.310 | 53116.8 |
191 | 2021-04-10 17:55:56 | sitcoms | 1 | 69583 | 2 | 1.233 | 56433.9 |
190 | 2021-04-08 14:00:48 | sitcoms | 1 | 69583 | 2 | 1.126 | 61796.6 |
189 | 2021-03-19 15:31:32 | sitcoms | 3 | 134027 | 132 | 5.843 | 22938.0 |
188 | 2021-02-22 10:53:51 | sitcoms | 3 | 134027 | 132 | 5.736 | 23365.9 |
187 | 2021-01-23 12:12:14 | sitcoms | 1 | 69583 | 2 | 1.110 | 62687.4 |
186 | 2020-12-24 23:56:50 | sitcoms | 1 | 69583 | 2 | 1.093 | 63662.4 |
185 | 2020-12-13 22:08:52 | sitcoms | 1 | 69583 | 2 | 1.093 | 63662.4 |
184 | 2020-11-20 18:23:05 | sitcoms | 1 | 69583 | 2 | 1.123 | 61961.7 |
183 | 2020-11-12 12:48:49 | sitcoms | 3 | 134027 | 132 | 6.236 | 21492.5 |
182 | 2020-10-27 05:49:23 | sitcoms | 1 | 69583 | 2 | 1.076 | 64668.2 |
181 | 2020-08-31 04:59:46 | sitcoms | 1 | 69583 | 2 | 1.140 | 61037.7 |
180 | 2020-08-30 06:16:40 | sitcoms | 1 | 69583 | 2 | 1.220 | 57035.2 |
179 | 2020-07-30 14:59:12 | sitcoms | 1 | 69583 | 2 | 1.173 | 59320.5 |
178 | 2020-05-14 02:29:27 | sitcoms | 1 | 69583 | 2 | 1.110 | 62687.4 |
177 | 2020-03-30 07:21:04 | sitcoms | 1 | 69583 | 2 | 1.343 | 51811.6 |
176 | 2020-03-30 00:25:59 | sitcoms | 1 | 69583 | 2 | 1.190 | 58473.1 |
175 | 2020-03-28 23:57:24 | sitcoms | 1 | 69583 | 2 | 2.703 | 25742.9 |
174 | 2020-03-26 07:26:21 | sitcoms | 1 | 69583 | 2 | 1.343 | 51811.6 |
173 | 2020-03-21 14:41:58 | sitcoms | 1 | 69583 | 2 | 1.106 | 62914.1 |
172 | 2020-02-28 19:58:45 | sitcoms | 1 | 69583 | 2 | 1.550 | 44892.3 |
171 | 2020-02-13 02:32:58 | sitcoms | 1 | 69583 | 2 | 2.780 | 25029.9 |
170 | 2020-02-12 11:18:20 | sitcoms | 1 | 69583 | 2 | 4.266 | 16311.1 |
169 | 2020-02-03 17:08:54 | sitcoms | 1 | 69583 | 2 | 1.436 | 48456.1 |
168 | 2020-02-02 16:16:54 | sitcoms | 1 | 69583 | 2 | 1.156 | 60192.9 |
167 | 2020-02-01 07:18:53 | sitcoms | 1 | 69583 | 2 | 1.250 | 55666.4 |
166 | 2020-01-29 17:55:48 | sitcoms | 1 | 69583 | 2 | 1.360 | 51164.0 |
165 | 2020-01-29 01:57:57 | sitcoms | 1 | 69583 | 2 | 2.750 | 25302.9 |
164 | 2020-01-21 19:37:42 | sitcoms | 1 | 69583 | 2 | 2.906 | 23944.6 |
163 | 2020-01-15 07:01:24 | sitcoms | 1 | 69583 | 2 | 1.296 | 53690.6 |
162 | 2020-01-07 15:14:28 | sitcoms | 1 | 69583 | 2 | 1.720 | 40455.2 |
161 | 2020-01-07 12:13:58 | sitcoms | 1 | 69583 | 2 | 1.266 | 54962.9 |
160 | 2020-01-02 20:39:51 | sitcoms | 1 | 69583 | 2 | 1.300 | 53525.4 |
159 | 2019-12-29 01:01:37 | sitcoms | 1 | 69583 | 2 | 1.296 | 53690.6 |
158 | 2019-10-26 09:50:28 | sitcoms | 1 | 69583 | 2 | 1.186 | 58670.3 |
157 | 2019-08-10 14:52:16 | sitcoms | 1 | 69583 | 2 | 1.146 | 60718.2 |
156 | 2019-07-25 08:17:19 | sitcoms | 1 | 69583 | 2 | 1.186 | 58670.3 |
155 | 2019-06-20 06:18:18 | sitcoms | 1 | 69583 | 2 | 1.173 | 59320.5 |
154 | 2019-04-17 22:50:33 | sitcoms | 1 | 69583 | 2 | 1.203 | 57841.2 |
153 | 2019-02-28 11:59:26 | sitcoms | 1 | 69583 | 2 | 1.403 | 49595.9 |
152 | 2019-02-18 07:34:46 | sitcoms | 1 | 69583 | 2 | 1.256 | 55400.5 |
151 | 2019-02-13 04:18:18 | sitcoms | 1 | 69583 | 2 | 1.103 | 63085.2 |
150 | 2019-02-09 17:28:15 | sitcoms | 1 | 69583 | 2 | 1.073 | 64849.0 |
149 | 2019-02-09 17:18:36 | sitcoms | 1 | 69583 | 2 | 1.063 | 65459.1 |
148 | 2019-02-07 23:56:09 | sitcoms | 1 | 69583 | 2 | 1.200 | 57985.8 |
147 | 2019-02-06 05:27:48 | sitcoms | 1 | 69583 | 2 | 1.263 | 55093.4 |
146 | 2019-01-12 02:40:52 | sitcoms | 1 | 69583 | 2 | 1.223 | 56895.3 |
145 | 2018-12-25 13:28:06 | sitcoms | 1 | 69583 | 2 | 1.243 | 55979.9 |
144 | 2018-12-20 00:10:38 | sitcoms | 1 | 69583 | 2 | 1.190 | 58473.1 |
143 | 2018-12-03 04:12:48 | sitcoms | 1 | 69583 | 2 | 1.193 | 58326.1 |
142 | 2018-11-23 18:57:05 | sitcoms | 1 | 69583 | 2 | 1.050 | 66269.5 |
141 | 2018-10-29 10:07:17 | sitcoms | 1 | 69583 | 2 | 1.210 | 57506.6 |
140 | 2018-10-04 00:09:24 | sitcoms | 1 | 69583 | 2 | 1.093 | 63662.4 |
139 | 2018-09-01 19:31:55 | sitcoms | 3 | 134027 | 132 | 7.293 | 18377.5 |
138 | 2018-08-17 10:09:38 | sitcoms | 1 | 69583 | 2 | 1.243 | 55979.9 |
137 | 2018-06-30 10:01:55 | sitcoms | 1 | 69583 | 2 | 1.170 | 59472.6 |
136 | 2018-06-23 10:00:11 | sitcoms | 1 | 69583 | 2 | 1.196 | 58179.8 |
135 | 2018-05-19 13:14:28 | sitcoms | 1 | 69583 | 2 | 1.186 | 58670.3 |
134 | 2018-05-16 18:44:11 | sitcoms | 1 | 69583 | 2 | 1.130 | 61577.9 |
133 | 2018-05-14 23:59:01 | sitcoms | 1 | 69583 | 2 | 1.376 | 50569.0 |