History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coastguard"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
220 | 2024-05-27 21:37:11 | coastguard | 3 | 140603 | 9 | 27.000 | 5207.5 |
219 | 2024-05-27 21:36:44 | coastguard | 4 | 161450 | 42 | 39.126 | 4126.4 |
218 | 2024-05-27 21:37:03 | coastguard | 2 | 108824 | 3 | 5.953 | 18280.5 |
217 | 2024-05-24 03:43:48 | coastguard | 4 | 161450 | 42 | 25.550 | 6319.0 |
216 | 2024-05-20 22:25:55 | coastguard | 1 | 67641 | 2 | 5.406 | 12512.2 |
215 | 2024-05-20 20:50:52 | coastguard | 4 | 161450 | 42 | 43.643 | 3699.3 |
214 | 2024-05-19 09:09:18 | coastguard | 5 | 173545 | 291 | 32.830 | 5286.2 |
213 | 2024-05-19 09:09:19 | coastguard | 4 | 161450 | 42 | 12.610 | 12803.3 |
212 | 2024-05-19 04:16:49 | coastguard | 4 | 161450 | 42 | 22.610 | 7140.6 |
211 | 2024-05-17 22:25:57 | coastguard | 1 | 67641 | 2 | 1.390 | 48662.6 |
210 | 2024-05-12 20:21:23 | coastguard | 5 | 173545 | 291 | 34.363 | 5050.3 |
209 | 2024-05-12 13:52:22 | coastguard | 5 | 173545 | 291 | 35.816 | 4845.5 |
208 | 2024-05-06 10:02:18 | coastguard | 4 | 161450 | 42 | 26.593 | 6071.1 |
207 | 2024-05-04 02:48:49 | coastguard | 1 | 67641 | 2 | 1.186 | 57032.9 |
206 | 2024-05-01 06:51:01 | coastguard | 1 | 67641 | 2 | 2.360 | 28661.4 |
205 | 2024-04-18 03:35:22 | coastguard | 4 | 161450 | 42 | 27.766 | 5814.7 |
204 | 2024-04-16 11:10:49 | coastguard | 4 | 161450 | 42 | 47.190 | 3421.3 |
203 | 2024-04-15 20:07:31 | coastguard | 4 | 161450 | 42 | 24.186 | 6675.3 |
202 | 2024-04-14 22:13:18 | coastguard | 1 | 67641 | 2 | 2.140 | 31607.9 |
201 | 2024-04-14 22:12:28 | coastguard | 3 | 140603 | 9 | 15.906 | 8839.6 |
200 | 2024-04-14 11:44:53 | coastguard | 2 | 108824 | 3 | 5.423 | 20067.1 |
199 | 2024-04-14 11:22:38 | coastguard | 4 | 161450 | 42 | 30.266 | 5334.4 |
198 | 2024-04-14 11:01:54 | coastguard | 1 | 67641 | 2 | 1.233 | 54858.9 |
197 | 2024-04-14 10:36:46 | coastguard | 4 | 161450 | 42 | 41.036 | 3934.4 |
196 | 2024-04-14 05:10:34 | coastguard | 4 | 161450 | 42 | 37.486 | 4306.9 |
195 | 2024-04-14 05:10:34 | coastguard | 3 | 140603 | 9 | 23.016 | 6108.9 |
194 | 2024-04-14 05:10:39 | coastguard | 2 | 108824 | 3 | 10.626 | 10241.3 |
193 | 2024-04-14 05:08:16 | coastguard | 5 | 173545 | 291 | 56.736 | 3058.8 |
192 | 2024-04-14 05:08:43 | coastguard | 2 | 108824 | 3 | 15.576 | 6986.6 |
191 | 2024-04-14 05:08:17 | coastguard | 4 | 161450 | 42 | 38.190 | 4227.5 |
190 | 2024-04-14 05:08:26 | coastguard | 3 | 140603 | 9 | 22.673 | 6201.3 |
189 | 2024-04-14 05:05:49 | coastguard | 1 | 67641 | 2 | 1.766 | 38301.8 |
188 | 2024-04-14 05:05:42 | coastguard | 1 | 67641 | 2 | 4.046 | 16718.0 |
187 | 2024-04-12 09:23:24 | coastguard | 1 | 67641 | 2 | 1.076 | 62863.4 |
186 | 2024-04-01 21:23:27 | coastguard | 5 | 173545 | 291 | 17.033 | 10188.8 |
185 | 2024-03-20 13:53:27 | coastguard | 5 | 173545 | 291 | 58.863 | 2948.3 |
184 | 2024-03-18 13:21:02 | coastguard | 5 | 173545 | 291 | 61.770 | 2809.5 |
183 | 2024-03-18 12:37:21 | coastguard | 3 | 140603 | 9 | 14.983 | 9384.2 |
182 | 2024-03-15 01:34:40 | coastguard | 5 | 173545 | 291 | 54.410 | 3189.6 |
181 | 2024-03-13 21:07:25 | coastguard | 5 | 173545 | 291 | 38.380 | 4521.8 |
180 | 2024-03-13 21:07:29 | coastguard | 4 | 161450 | 42 | 20.830 | 7750.8 |
179 | 2024-03-13 21:07:24 | coastguard | 3 | 140603 | 9 | 26.283 | 5349.6 |
178 | 2024-03-13 21:07:20 | coastguard | 2 | 108824 | 3 | 11.140 | 9768.8 |
177 | 2024-03-13 21:05:41 | coastguard | 1 | 67641 | 2 | 1.330 | 50857.9 |
176 | 2024-03-07 16:10:01 | coastguard | 1 | 67641 | 2 | 1.203 | 56226.9 |
175 | 2024-02-20 16:02:56 | coastguard | 4 | 161450 | 42 | 25.330 | 6373.9 |
174 | 2024-02-15 12:05:09 | coastguard | 4 | 161450 | 42 | 12.846 | 12568.1 |
173 | 2024-02-11 19:28:05 | coastguard | 1 | 67641 | 2 | 4.076 | 16594.9 |
172 | 2024-02-06 21:02:03 | coastguard | 1 | 67641 | 2 | 1.156 | 58513.0 |
171 | 2024-02-03 19:57:10 | coastguard | 1 | 67641 | 2 | 1.090 | 62056.0 |
170 | 2024-02-03 19:57:05 | coastguard | 1 | 67641 | 2 | 1.076 | 62863.4 |
169 | 2024-01-02 03:18:00 | coastguard | 5 | 173545 | 291 | 16.800 | 10330.1 |
168 | 2023-12-30 03:27:49 | coastguard | 1 | 67641 | 2 | 1.173 | 57665.0 |
167 | 2023-12-29 22:08:11 | coastguard | 4 | 161450 | 42 | 17.780 | 9080.4 |
166 | 2023-12-14 13:12:34 | coastguard | 1 | 67641 | 2 | 1.046 | 64666.3 |
165 | 2023-12-11 13:19:36 | coastguard | 5 | 173545 | 291 | 15.763 | 11009.6 |
164 | 2023-12-08 13:55:24 | coastguard | 5 | 173545 | 291 | 18.580 | 9340.4 |
163 | 2023-11-10 21:51:19 | coastguard | 5 | 173545 | 291 | 18.530 | 9365.6 |
162 | 2023-11-05 10:39:16 | coastguard | 1 | 67641 | 2 | 1.046 | 64666.3 |
161 | 2023-10-19 22:37:04 | coastguard | 1 | 67641 | 2 | 1.216 | 55625.8 |
160 | 2023-10-07 14:57:52 | coastguard | 5 | 173545 | 291 | 15.453 | 11230.5 |
159 | 2023-10-04 15:28:05 | coastguard | 4 | 161450 | 42 | 10.216 | 15803.6 |
158 | 2023-08-15 22:01:22 | coastguard | 1 | 67641 | 2 | 2.360 | 28661.4 |
157 | 2023-07-18 01:26:49 | coastguard | 5 | 173545 | 291 | 15.890 | 10921.6 |
156 | 2023-07-15 08:34:03 | coastguard | 4 | 161450 | 42 | 9.940 | 16242.5 |
155 | 2023-06-05 08:13:18 | coastguard | 1 | 67641 | 2 | 1.050 | 64420.0 |
154 | 2023-05-15 07:28:48 | coastguard | 1 | 67641 | 2 | 1.033 | 65480.2 |
153 | 2023-04-01 18:01:01 | coastguard | 5 | 173545 | 291 | 16.000 | 10846.6 |
152 | 2023-04-01 08:09:27 | coastguard | 4 | 161450 | 42 | 11.503 | 14035.5 |
151 | 2023-03-11 01:50:26 | coastguard | 1 | 67641 | 2 | 1.080 | 62630.6 |
150 | 2023-01-08 11:31:18 | coastguard | 1 | 67641 | 2 | 1.046 | 64666.3 |
149 | 2022-12-31 19:25:32 | coastguard | 1 | 67641 | 2 | 1.046 | 64666.3 |
148 | 2022-12-29 04:07:01 | coastguard | 5 | 173545 | 291 | 15.266 | 11368.1 |
147 | 2022-12-28 22:41:34 | coastguard | 4 | 161450 | 42 | 9.610 | 16800.2 |
146 | 2022-09-21 18:58:25 | coastguard | 1 | 67641 | 2 | 1.063 | 63632.2 |
145 | 2022-08-30 19:18:12 | coastguard | 4 | 161450 | 42 | 9.813 | 16452.7 |
144 | 2022-08-29 08:06:58 | coastguard | 5 | 173545 | 291 | 19.613 | 8848.5 |
143 | 2022-07-24 21:55:45 | coastguard | 1 | 67641 | 2 | 1.046 | 64666.3 |
142 | 2022-05-04 04:40:15 | coastguard | 1 | 67641 | 2 | 1.060 | 63812.3 |
141 | 2022-02-10 09:34:58 | coastguard | 1 | 67641 | 2 | 1.033 | 65480.2 |
140 | 2021-11-03 12:36:09 | coastguard | 1 | 67641 | 2 | 1.236 | 54725.7 |
139 | 2021-09-08 18:48:20 | coastguard | 1 | 67641 | 2 | 1.080 | 62630.6 |
138 | 2021-05-12 13:36:48 | coastguard | 1 | 67641 | 2 | 1.203 | 56226.9 |
137 | 2021-03-22 23:52:33 | coastguard | 1 | 67641 | 2 | 1.063 | 63632.2 |
136 | 2021-02-25 08:17:46 | coastguard | 1 | 67641 | 2 | 1.110 | 60937.8 |
135 | 2021-01-20 08:01:27 | coastguard | 1 | 67641 | 2 | 1.156 | 58513.0 |
134 | 2020-10-17 05:37:06 | coastguard | 1 | 67641 | 2 | 1.046 | 64666.3 |
133 | 2020-06-15 15:35:07 | coastguard | 1 | 67641 | 2 | 1.063 | 63632.2 |
132 | 2020-03-24 04:14:55 | coastguard | 5 | 173545 | 291 | 27.233 | 6372.6 |
131 | 2020-03-24 00:19:43 | coastguard | 2 | 108824 | 3 | 3.076 | 35378.4 |
130 | 2020-03-24 00:03:38 | coastguard | 5 | 173545 | 291 | 17.753 | 9775.5 |
129 | 2020-03-23 20:40:54 | coastguard | 3 | 140603 | 9 | 7.093 | 19822.8 |
128 | 2020-03-23 00:51:07 | coastguard | 5 | 173545 | 291 | 19.673 | 8821.5 |
127 | 2020-03-22 22:56:45 | coastguard | 4 | 161450 | 42 | 12.423 | 12996.1 |
126 | 2020-03-22 21:35:06 | coastguard | 1 | 67641 | 2 | 1.250 | 54112.8 |
125 | 2020-03-06 04:07:54 | coastguard | 2 | 108824 | 3 | 3.483 | 31244.3 |
124 | 2020-03-06 04:03:06 | coastguard | 3 | 140603 | 9 | 10.063 | 13972.3 |
123 | 2020-03-06 03:59:03 | coastguard | 4 | 161450 | 42 | 20.920 | 7717.5 |
122 | 2020-03-06 01:47:56 | coastguard | 1 | 67641 | 2 | 2.326 | 29080.4 |
121 | 2020-02-28 21:09:22 | coastguard | 5 | 173545 | 291 | 29.016 | 5981.0 |