History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparrow"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
223 | 2024-04-23 06:35:48 | sparrow | 1 | 69583 | 2 | 1.736 | 40082.4 |
222 | 2024-04-13 08:05:12 | sparrow | 2 | 107671 | 13 | 5.923 | 18178.5 |
221 | 2024-04-13 07:59:04 | sparrow | 3 | 134027 | 118 | 7.610 | 17612.0 |
220 | 2024-04-12 08:23:54 | sparrow | 3 | 134027 | 118 | 11.250 | 11913.5 |
219 | 2024-04-10 22:46:28 | sparrow | 3 | 134027 | 118 | 7.376 | 18170.7 |
218 | 2024-04-10 22:46:17 | sparrow | 2 | 107671 | 13 | 7.373 | 14603.4 |
217 | 2024-04-09 02:16:28 | sparrow | 2 | 107671 | 13 | 3.766 | 28590.3 |
216 | 2024-04-06 19:28:56 | sparrow | 1 | 69583 | 2 | 2.720 | 25582.0 |
215 | 2024-02-25 10:23:12 | sparrow | 3 | 134027 | 118 | 30.360 | 4414.6 |
214 | 2024-02-18 18:45:02 | sparrow | 3 | 134027 | 118 | 6.766 | 19808.9 |
213 | 2024-01-30 20:20:16 | sparrow | 3 | 134027 | 118 | 6.513 | 20578.4 |
212 | 2024-01-29 23:13:52 | sparrow | 3 | 134027 | 118 | 7.483 | 17910.9 |
211 | 2024-01-28 19:05:54 | sparrow | 3 | 134027 | 118 | 6.110 | 21935.7 |
210 | 2024-01-27 12:18:36 | sparrow | 3 | 134027 | 118 | 8.206 | 16332.8 |
209 | 2024-01-26 19:01:51 | sparrow | 3 | 134027 | 118 | 6.673 | 20085.0 |
208 | 2024-01-26 10:42:03 | sparrow | 3 | 134027 | 118 | 14.813 | 9047.9 |
207 | 2024-01-24 00:33:56 | sparrow | 3 | 134027 | 118 | 6.456 | 20760.1 |
206 | 2024-01-18 23:26:04 | sparrow | 3 | 134027 | 118 | 6.970 | 19229.1 |
205 | 2024-01-18 14:23:15 | sparrow | 3 | 134027 | 118 | 5.860 | 22871.5 |
204 | 2024-01-17 17:12:46 | sparrow | 1 | 69583 | 2 | 1.203 | 57841.2 |
203 | 2024-01-10 14:42:31 | sparrow | 1 | 69583 | 2 | 1.123 | 61961.7 |
202 | 2023-12-29 19:23:19 | sparrow | 3 | 134027 | 118 | 5.876 | 22809.2 |
201 | 2023-12-27 13:04:27 | sparrow | 3 | 134027 | 118 | 6.000 | 22337.8 |
200 | 2023-12-10 15:56:27 | sparrow | 2 | 107671 | 13 | 3.266 | 32967.2 |
199 | 2023-12-08 16:57:51 | sparrow | 3 | 134027 | 118 | 6.076 | 22058.4 |
198 | 2023-12-07 17:10:23 | sparrow | 3 | 134027 | 118 | 12.470 | 10748.0 |
197 | 2023-12-06 16:38:08 | sparrow | 3 | 134027 | 118 | 5.703 | 23501.1 |
196 | 2023-11-27 05:25:01 | sparrow | 1 | 69583 | 2 | 1.173 | 59320.5 |
195 | 2023-11-26 08:12:08 | sparrow | 1 | 69583 | 2 | 1.170 | 59472.6 |
194 | 2023-11-15 07:21:01 | sparrow | 1 | 69583 | 2 | 1.173 | 59320.5 |
193 | 2023-11-03 21:05:26 | sparrow | 1 | 69583 | 2 | 1.110 | 62687.4 |
192 | 2023-10-31 06:54:57 | sparrow | 1 | 69583 | 2 | 1.190 | 58473.1 |
191 | 2023-10-30 01:41:37 | sparrow | 3 | 134027 | 118 | 5.830 | 22989.2 |
190 | 2023-09-14 07:15:23 | sparrow | 1 | 69583 | 2 | 1.220 | 57035.2 |
189 | 2023-09-09 04:46:00 | sparrow | 2 | 107671 | 13 | 2.830 | 38046.3 |
188 | 2023-08-26 15:24:16 | sparrow | 1 | 69583 | 2 | 1.266 | 54962.9 |
187 | 2023-08-20 19:28:29 | sparrow | 3 | 134027 | 118 | 6.703 | 19995.1 |
186 | 2023-08-07 19:05:54 | sparrow | 3 | 134027 | 118 | 5.860 | 22871.5 |
185 | 2023-07-28 20:52:57 | sparrow | 3 | 134027 | 118 | 6.843 | 19586.0 |
184 | 2023-07-21 16:38:08 | sparrow | 3 | 134027 | 118 | 12.110 | 11067.5 |
183 | 2023-07-18 23:27:30 | sparrow | 3 | 134027 | 118 | 6.546 | 20474.6 |
182 | 2023-06-26 14:07:51 | sparrow | 3 | 134027 | 118 | 6.266 | 21389.6 |
181 | 2023-05-30 11:43:16 | sparrow | 2 | 107671 | 13 | 3.203 | 33615.7 |
180 | 2023-05-29 01:53:20 | sparrow | 1 | 69583 | 2 | 1.170 | 59472.6 |
179 | 2023-05-26 04:14:39 | sparrow | 3 | 134027 | 118 | 5.703 | 23501.1 |
178 | 2023-04-20 04:15:15 | sparrow | 3 | 134027 | 118 | 5.860 | 22871.5 |
177 | 2023-03-25 09:24:34 | sparrow | 1 | 69583 | 2 | 2.296 | 30306.2 |
176 | 2023-03-07 16:53:56 | sparrow | 2 | 107671 | 13 | 2.813 | 38276.2 |
175 | 2023-01-22 19:02:22 | sparrow | 3 | 134027 | 118 | 5.923 | 22628.2 |
174 | 2023-01-09 07:10:49 | sparrow | 1 | 69583 | 2 | 1.063 | 65459.1 |
173 | 2022-12-12 06:07:33 | sparrow | 2 | 107671 | 13 | 2.843 | 37872.3 |
172 | 2022-11-03 16:23:07 | sparrow | 3 | 134027 | 118 | 6.343 | 21129.9 |
171 | 2022-10-07 03:03:25 | sparrow | 1 | 69583 | 2 | 1.080 | 64428.7 |
170 | 2022-07-27 06:13:19 | sparrow | 2 | 107671 | 13 | 2.813 | 38276.2 |
169 | 2022-05-29 17:54:11 | sparrow | 3 | 134027 | 118 | 9.046 | 14816.2 |
168 | 2022-05-27 13:28:31 | sparrow | 1 | 69583 | 2 | 1.063 | 65459.1 |
167 | 2022-05-25 07:09:39 | sparrow | 1 | 69583 | 2 | 1.123 | 61961.7 |
166 | 2022-05-17 07:31:19 | sparrow | 3 | 134027 | 118 | 5.893 | 22743.4 |
165 | 2022-04-11 04:47:34 | sparrow | 3 | 134027 | 118 | 5.910 | 22678.0 |
164 | 2022-04-08 23:27:46 | sparrow | 3 | 134027 | 118 | 6.703 | 19995.1 |
163 | 2022-03-13 08:32:50 | sparrow | 1 | 69583 | 2 | 1.173 | 59320.5 |
162 | 2021-06-30 23:54:32 | sparrow | 3 | 134027 | 118 | 5.826 | 23005.0 |
161 | 2021-06-05 02:13:11 | sparrow | 3 | 134027 | 118 | 5.876 | 22809.2 |
160 | 2021-05-23 01:41:10 | sparrow | 1 | 69583 | 2 | 1.310 | 53116.8 |
159 | 2021-05-10 20:27:02 | sparrow | 3 | 134027 | 118 | 6.953 | 19276.1 |
158 | 2021-04-24 05:42:20 | sparrow | 1 | 69583 | 2 | 1.266 | 54962.9 |
157 | 2021-04-12 18:47:50 | sparrow | 3 | 134027 | 118 | 5.860 | 22871.5 |
156 | 2021-04-08 09:54:50 | sparrow | 2 | 107671 | 13 | 3.326 | 32372.5 |
155 | 2021-03-16 14:32:05 | sparrow | 3 | 134027 | 118 | 6.610 | 20276.4 |
154 | 2021-02-28 09:14:33 | sparrow | 1 | 69583 | 2 | 1.110 | 62687.4 |
153 | 2021-02-21 01:41:39 | sparrow | 1 | 69583 | 2 | 1.250 | 55666.4 |
152 | 2021-01-23 08:07:27 | sparrow | 2 | 107671 | 13 | 3.593 | 29966.9 |
151 | 2021-01-09 11:52:29 | sparrow | 1 | 69583 | 2 | 1.076 | 64668.2 |
150 | 2020-12-28 18:16:26 | sparrow | 3 | 134027 | 118 | 5.936 | 22578.7 |
149 | 2020-12-01 07:30:06 | sparrow | 3 | 134027 | 118 | 5.873 | 22820.9 |
148 | 2020-11-28 03:30:47 | sparrow | 2 | 107671 | 13 | 3.063 | 35152.1 |
147 | 2020-11-08 13:34:09 | sparrow | 1 | 69583 | 2 | 1.356 | 51314.9 |
146 | 2020-11-01 07:22:25 | sparrow | 2 | 107671 | 13 | 2.936 | 36672.7 |
145 | 2020-10-26 15:06:42 | sparrow | 3 | 134027 | 118 | 6.483 | 20673.6 |
144 | 2020-10-26 11:18:38 | sparrow | 3 | 134027 | 118 | 6.203 | 21606.8 |
143 | 2020-10-15 18:56:28 | sparrow | 3 | 134027 | 118 | 6.970 | 19229.1 |
142 | 2020-10-05 18:24:06 | sparrow | 2 | 107671 | 13 | 2.876 | 37437.8 |
141 | 2020-09-21 07:47:04 | sparrow | 3 | 134027 | 118 | 5.860 | 22871.5 |
140 | 2020-09-14 01:01:06 | sparrow | 3 | 134027 | 118 | 5.966 | 22465.1 |
139 | 2020-08-31 01:25:22 | sparrow | 3 | 134027 | 118 | 5.986 | 22390.1 |
138 | 2020-08-30 16:06:02 | sparrow | 3 | 134027 | 118 | 6.030 | 22226.7 |
137 | 2020-08-30 10:21:40 | sparrow | 1 | 69583 | 2 | 1.423 | 48898.8 |
136 | 2020-08-30 04:56:50 | sparrow | 3 | 134027 | 118 | 6.966 | 19240.2 |
135 | 2020-08-27 13:17:20 | sparrow | 3 | 134027 | 118 | 6.503 | 20610.0 |
134 | 2020-08-18 00:29:36 | sparrow | 3 | 134027 | 118 | 6.970 | 19229.1 |
133 | 2020-08-14 00:05:38 | sparrow | 2 | 107671 | 13 | 2.923 | 36835.8 |
132 | 2020-07-30 20:16:13 | sparrow | 2 | 107671 | 13 | 3.406 | 31612.2 |
131 | 2020-07-30 06:31:11 | sparrow | 3 | 134027 | 118 | 6.140 | 21828.5 |
130 | 2020-07-29 14:45:39 | sparrow | 3 | 134027 | 118 | 6.046 | 22167.9 |
129 | 2020-03-29 18:10:14 | sparrow | 1 | 69583 | 2 | 1.283 | 54234.6 |
128 | 2020-03-28 03:36:28 | sparrow | 1 | 69583 | 2 | 1.330 | 52318.0 |
127 | 2020-03-22 07:46:22 | sparrow | 1 | 69583 | 2 | 1.593 | 43680.5 |
126 | 2020-03-20 05:13:43 | sparrow | 1 | 69583 | 2 | 1.140 | 61037.7 |
125 | 2020-03-17 09:57:06 | sparrow | 1 | 69583 | 2 | 1.220 | 57035.2 |
124 | 2020-02-27 03:46:17 | sparrow | 3 | 134027 | 118 | 12.203 | 10983.1 |