History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gatehouses"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
213 | 2024-04-23 15:14:11 | gatehouses | 1 | 67641 | 2 | 2.766 | 24454.4 |
212 | 2024-03-30 23:51:23 | gatehouses | 1 | 67641 | 2 | 1.153 | 58665.2 |
211 | 2024-03-27 07:16:17 | gatehouses | 1 | 67641 | 2 | 1.186 | 57032.9 |
210 | 2024-03-26 07:17:25 | gatehouses | 1 | 67641 | 2 | 1.190 | 56841.2 |
209 | 2024-03-25 14:09:26 | gatehouses | 1 | 67641 | 2 | 0.966 | 70021.7 |
208 | 2024-03-24 15:07:12 | gatehouses | 4 | 161450 | 178 | 41.660 | 3875.4 |
207 | 2024-03-24 15:07:22 | gatehouses | 2 | 108824 | 9 | 11.266 | 9659.5 |
206 | 2024-03-24 15:07:18 | gatehouses | 3 | 140603 | 47 | 13.656 | 10296.1 |
205 | 2024-03-24 15:06:20 | gatehouses | 1 | 67641 | 2 | 3.796 | 17819.0 |
204 | 2024-02-27 05:17:12 | gatehouses | 1 | 67641 | 2 | 1.186 | 57032.9 |
203 | 2024-02-18 14:03:48 | gatehouses | 1 | 67641 | 2 | 1.126 | 60071.9 |
202 | 2024-02-11 01:27:10 | gatehouses | 3 | 140603 | 47 | 12.406 | 11333.5 |
201 | 2024-02-11 01:27:09 | gatehouses | 2 | 108824 | 9 | 3.516 | 30951.1 |
200 | 2024-02-03 04:01:46 | gatehouses | 1 | 67641 | 2 | 1.046 | 64666.3 |
199 | 2024-02-01 09:53:20 | gatehouses | 1 | 67641 | 2 | 1.123 | 60232.4 |
198 | 2024-01-29 16:11:34 | gatehouses | 4 | 161450 | 178 | 10.763 | 15000.5 |
197 | 2024-01-25 22:29:43 | gatehouses | 1 | 67641 | 2 | 1.220 | 55443.4 |
196 | 2024-01-21 02:41:05 | gatehouses | 1 | 67641 | 2 | 1.140 | 59334.2 |
195 | 2024-01-17 18:26:11 | gatehouses | 4 | 161450 | 178 | 10.453 | 15445.3 |
194 | 2024-01-17 18:26:07 | gatehouses | 3 | 140603 | 47 | 6.563 | 21423.6 |
193 | 2024-01-17 18:26:05 | gatehouses | 2 | 108824 | 9 | 3.140 | 34657.3 |
192 | 2023-12-26 16:58:24 | gatehouses | 1 | 67641 | 2 | 0.986 | 68601.4 |
191 | 2023-11-23 10:20:37 | gatehouses | 4 | 161450 | 178 | 12.563 | 12851.2 |
190 | 2023-11-16 20:59:59 | gatehouses | 1 | 67641 | 2 | 1.123 | 60232.4 |
189 | 2023-11-16 10:05:19 | gatehouses | 4 | 161450 | 178 | 12.000 | 13454.2 |
188 | 2023-11-07 12:59:55 | gatehouses | 4 | 161450 | 178 | 9.830 | 16424.2 |
187 | 2023-11-07 01:07:19 | gatehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
186 | 2023-11-02 09:19:08 | gatehouses | 1 | 67641 | 2 | 0.983 | 68810.8 |
185 | 2023-09-04 05:26:33 | gatehouses | 1 | 67641 | 2 | 1.093 | 61885.6 |
184 | 2023-08-12 08:14:21 | gatehouses | 4 | 161450 | 178 | 10.936 | 14763.2 |
183 | 2023-04-23 17:01:00 | gatehouses | 4 | 161450 | 178 | 11.373 | 14195.9 |
182 | 2023-02-09 08:48:01 | gatehouses | 1 | 67641 | 2 | 1.046 | 64666.3 |
181 | 2023-01-30 04:28:18 | gatehouses | 4 | 161450 | 178 | 11.690 | 13810.9 |
180 | 2022-12-07 07:12:43 | gatehouses | 1 | 67641 | 2 | 1.016 | 66575.8 |
179 | 2022-11-13 00:35:08 | gatehouses | 4 | 161450 | 178 | 9.390 | 17193.8 |
178 | 2022-08-08 17:09:39 | gatehouses | 1 | 67641 | 2 | 0.983 | 68810.8 |
177 | 2022-05-19 15:50:33 | gatehouses | 4 | 161450 | 178 | 10.076 | 16023.2 |
176 | 2022-04-04 13:29:06 | gatehouses | 1 | 67641 | 2 | 1.203 | 56226.9 |
175 | 2022-04-02 09:42:49 | gatehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
174 | 2022-02-18 07:43:49 | gatehouses | 1 | 67641 | 2 | 1.030 | 65670.9 |
173 | 2022-02-09 15:10:20 | gatehouses | 1 | 67641 | 2 | 0.983 | 68810.8 |
172 | 2021-12-22 06:12:35 | gatehouses | 1 | 67641 | 2 | 1.123 | 60232.4 |
171 | 2021-05-21 00:38:47 | gatehouses | 1 | 67641 | 2 | 1.170 | 57812.8 |
170 | 2021-02-19 18:28:45 | gatehouses | 1 | 67641 | 2 | 1.140 | 59334.2 |
169 | 2021-02-02 08:23:43 | gatehouses | 1 | 67641 | 2 | 1.033 | 65480.2 |
168 | 2020-11-11 18:26:25 | gatehouses | 3 | 140603 | 47 | 6.283 | 22378.3 |
167 | 2020-11-07 19:35:55 | gatehouses | 1 | 67641 | 2 | 1.216 | 55625.8 |
166 | 2020-11-07 03:51:48 | gatehouses | 1 | 67641 | 2 | 1.050 | 64420.0 |
165 | 2020-10-20 23:36:01 | gatehouses | 1 | 67641 | 2 | 1.123 | 60232.4 |
164 | 2020-10-20 02:03:01 | gatehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
163 | 2020-03-29 16:11:08 | gatehouses | 1 | 67641 | 2 | 1.093 | 61885.6 |
162 | 2020-03-24 20:38:53 | gatehouses | 1 | 67641 | 2 | 3.686 | 18350.8 |
161 | 2020-03-24 15:17:22 | gatehouses | 1 | 67641 | 2 | 1.123 | 60232.4 |
160 | 2020-03-22 01:31:21 | gatehouses | 1 | 67641 | 2 | 1.186 | 57032.9 |
159 | 2020-02-26 23:28:14 | gatehouses | 1 | 67641 | 2 | 1.203 | 56226.9 |
158 | 2020-02-17 02:20:13 | gatehouses | 1 | 67641 | 2 | 2.643 | 25592.5 |
157 | 2020-02-11 13:40:30 | gatehouses | 3 | 140603 | 47 | 6.970 | 20172.6 |
156 | 2020-02-09 15:49:20 | gatehouses | 3 | 140603 | 47 | 7.220 | 19474.1 |
155 | 2020-02-09 12:45:36 | gatehouses | 4 | 161450 | 178 | 15.393 | 10488.5 |
154 | 2020-02-08 20:03:16 | gatehouses | 4 | 161450 | 178 | 18.860 | 8560.4 |
153 | 2020-02-08 13:23:57 | gatehouses | 4 | 161450 | 178 | 20.906 | 7722.7 |
152 | 2020-02-08 06:21:38 | gatehouses | 3 | 140603 | 47 | 7.266 | 19350.8 |
151 | 2020-02-08 05:26:48 | gatehouses | 4 | 161450 | 178 | 12.923 | 12493.2 |
150 | 2020-02-06 08:29:49 | gatehouses | 4 | 161450 | 178 | 13.280 | 12157.4 |
149 | 2020-02-06 08:06:24 | gatehouses | 3 | 140603 | 47 | 7.593 | 18517.5 |
148 | 2020-02-06 08:05:50 | gatehouses | 2 | 108824 | 9 | 6.690 | 16266.7 |
147 | 2020-02-06 02:36:14 | gatehouses | 1 | 67641 | 2 | 3.000 | 22547.0 |
146 | 2020-01-30 14:57:15 | gatehouses | 1 | 67641 | 2 | 1.110 | 60937.8 |
145 | 2020-01-30 10:13:11 | gatehouses | 1 | 67641 | 2 | 1.076 | 62863.4 |
144 | 2020-01-30 04:26:08 | gatehouses | 1 | 67641 | 2 | 1.123 | 60232.4 |
143 | 2020-01-20 18:21:11 | gatehouses | 1 | 67641 | 2 | 1.373 | 49265.1 |
142 | 2020-01-20 17:12:36 | gatehouses | 1 | 67641 | 2 | 1.690 | 40024.3 |
141 | 2020-01-17 02:58:18 | gatehouses | 1 | 67641 | 2 | 1.220 | 55443.4 |
140 | 2020-01-06 18:11:32 | gatehouses | 1 | 67641 | 2 | 2.500 | 27056.4 |
139 | 2020-01-02 13:53:30 | gatehouses | 1 | 67641 | 2 | 3.126 | 21638.2 |
138 | 2019-12-19 11:47:30 | gatehouses | 1 | 67641 | 2 | 1.016 | 66575.8 |
137 | 2019-09-18 05:27:57 | gatehouses | 1 | 67641 | 2 | 1.096 | 61716.2 |
136 | 2019-06-12 08:53:13 | gatehouses | 1 | 67641 | 2 | 1.103 | 61324.6 |
135 | 2019-02-21 18:50:12 | gatehouses | 1 | 67641 | 2 | 1.076 | 62863.4 |
134 | 2018-10-30 01:53:42 | gatehouses | 1 | 67641 | 2 | 1.133 | 59700.8 |
133 | 2018-07-19 20:32:25 | gatehouses | 1 | 67641 | 2 | 1.080 | 62630.6 |
132 | 2018-07-09 07:38:37 | gatehouses | 1 | 67641 | 2 | 1.040 | 65039.4 |
131 | 2018-06-20 19:20:50 | gatehouses | 1 | 67641 | 2 | 1.240 | 54549.2 |
130 | 2018-06-20 19:02:43 | gatehouses | 1 | 67641 | 2 | 1.063 | 63632.2 |
129 | 2018-06-20 18:38:57 | gatehouses | 1 | 67641 | 2 | 1.053 | 64236.5 |
128 | 2018-06-20 18:30:04 | gatehouses | 1 | 67641 | 2 | 1.150 | 58818.3 |
127 | 2018-04-28 12:51:29 | gatehouses | 1 | 67641 | 2 | 1.126 | 60071.9 |
126 | 2018-03-19 14:35:55 | gatehouses | 1 | 67641 | 2 | 1.753 | 38585.9 |
125 | 2018-03-19 13:52:25 | gatehouses | 1 | 67641 | 2 | 1.606 | 42117.7 |
124 | 2018-01-05 02:25:14 | gatehouses | 1 | 67641 | 2 | 1.333 | 50743.4 |
123 | 2017-11-07 05:55:00 | gatehouses | 1 | 67641 | 2 | 1.543 | 43837.3 |
122 | 2017-05-07 22:42:06 | gatehouses | 1 | 67641 | 2 | 1.286 | 52598.0 |
121 | 2016-11-28 02:34:04 | gatehouses | 3 | 140603 | 47 | 8.080 | 17401.4 |
120 | 2016-11-22 17:20:35 | gatehouses | 1 | 67641 | 2 | 1.370 | 49373.0 |
119 | 2016-10-30 09:55:42 | gatehouses | 1 | 67641 | 2 | 1.320 | 51243.2 |
118 | 2016-10-03 17:31:09 | gatehouses | 1 | 67641 | 2 | 1.506 | 44914.3 |
117 | 2016-09-21 23:55:20 | gatehouses | 3 | 140603 | 47 | 9.276 | 15157.7 |
116 | 2016-09-17 20:25:16 | gatehouses | 1 | 67641 | 2 | 1.303 | 51911.7 |
115 | 2016-09-17 10:22:48 | gatehouses | 4 | 161450 | 178 | 16.546 | 9757.6 |
114 | 2016-07-28 11:24:05 | gatehouses | 2 | 108824 | 9 | 5.670 | 19192.9 |