History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lamppost"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
212 | 2024-05-11 15:36:06 | lamppost | 1 | 82945 | 2 | 3.216 | 25791.4 |
211 | 2024-05-02 14:24:52 | lamppost | 4 | 161609 | 345 | 13.750 | 11753.4 |
210 | 2024-05-02 14:24:59 | lamppost | 2 | 121059 | 2 | 3.686 | 32842.9 |
209 | 2024-05-02 14:24:48 | lamppost | 3 | 146162 | 33 | 12.170 | 12010.0 |
208 | 2024-05-02 14:24:58 | lamppost | 1 | 82945 | 2 | 1.453 | 57085.3 |
207 | 2024-05-01 17:19:46 | lamppost | 2 | 121059 | 2 | 3.780 | 32026.2 |
206 | 2024-05-01 17:19:43 | lamppost | 1 | 82945 | 2 | 2.783 | 29804.2 |
205 | 2024-04-29 12:41:35 | lamppost | 4 | 161609 | 345 | 11.783 | 13715.4 |
204 | 2024-04-29 12:41:22 | lamppost | 2 | 121059 | 2 | 4.016 | 30144.2 |
203 | 2024-04-29 12:38:44 | lamppost | 3 | 146162 | 33 | 7.860 | 18595.7 |
202 | 2024-04-29 12:38:43 | lamppost | 1 | 82945 | 2 | 1.483 | 55930.5 |
201 | 2024-04-29 12:38:29 | lamppost | 3 | 146162 | 33 | 7.093 | 20606.5 |
200 | 2024-04-29 12:38:24 | lamppost | 2 | 121059 | 2 | 3.280 | 36908.2 |
199 | 2024-04-29 12:37:57 | lamppost | 1 | 82945 | 2 | 1.483 | 55930.5 |
198 | 2024-04-28 08:41:09 | lamppost | 4 | 161609 | 345 | 35.956 | 4494.6 |
197 | 2024-04-27 20:53:28 | lamppost | 2 | 121059 | 2 | 15.233 | 7947.2 |
196 | 2024-04-27 19:06:27 | lamppost | 1 | 82945 | 2 | 1.813 | 45750.1 |
195 | 2024-04-27 10:53:10 | lamppost | 4 | 161609 | 345 | 31.500 | 5130.4 |
194 | 2024-04-27 10:50:17 | lamppost | 4 | 161609 | 345 | 40.626 | 3978.0 |
193 | 2024-04-09 23:54:46 | lamppost | 1 | 82945 | 2 | 7.000 | 11849.3 |
192 | 2024-04-01 05:23:05 | lamppost | 3 | 146162 | 33 | 9.783 | 14940.4 |
191 | 2024-04-01 05:23:04 | lamppost | 2 | 121059 | 2 | 7.563 | 16006.7 |
190 | 2024-04-01 05:23:01 | lamppost | 1 | 82945 | 2 | 3.250 | 25521.5 |
189 | 2024-04-01 00:49:29 | lamppost | 4 | 161609 | 345 | 34.063 | 4744.4 |
188 | 2024-03-30 07:37:34 | lamppost | 3 | 146162 | 33 | 11.563 | 12640.5 |
187 | 2024-03-29 23:45:20 | lamppost | 4 | 161609 | 345 | 33.220 | 4864.8 |
186 | 2024-03-29 21:04:25 | lamppost | 3 | 146162 | 33 | 7.390 | 19778.3 |
185 | 2024-03-29 21:04:23 | lamppost | 2 | 121059 | 2 | 3.800 | 31857.6 |
184 | 2024-03-29 21:04:23 | lamppost | 1 | 82945 | 2 | 1.343 | 61761.0 |
183 | 2024-03-26 16:13:57 | lamppost | 4 | 161609 | 345 | 10.720 | 15075.5 |
182 | 2024-03-21 22:59:52 | lamppost | 4 | 161609 | 345 | 37.783 | 4277.3 |
181 | 2024-03-15 08:01:58 | lamppost | 4 | 161609 | 345 | 20.516 | 7877.2 |
180 | 2024-03-15 08:01:58 | lamppost | 3 | 146162 | 33 | 17.373 | 8413.2 |
179 | 2024-03-15 08:01:59 | lamppost | 2 | 121059 | 2 | 4.376 | 27664.3 |
178 | 2024-03-15 08:01:53 | lamppost | 1 | 82945 | 2 | 1.593 | 52068.4 |
177 | 2024-03-08 01:08:09 | lamppost | 1 | 82945 | 2 | 5.046 | 16437.8 |
176 | 2024-02-29 06:56:59 | lamppost | 1 | 82945 | 2 | 1.513 | 54821.5 |
175 | 2024-02-28 16:06:35 | lamppost | 4 | 161609 | 345 | 24.546 | 6583.9 |
174 | 2024-02-26 09:39:07 | lamppost | 1 | 82945 | 2 | 1.673 | 49578.6 |
173 | 2024-02-25 07:45:07 | lamppost | 4 | 161609 | 345 | 13.453 | 12012.9 |
172 | 2024-02-12 16:32:42 | lamppost | 4 | 161609 | 345 | 32.376 | 4991.6 |
171 | 2024-02-07 05:16:43 | lamppost | 2 | 121059 | 2 | 3.906 | 30993.1 |
170 | 2024-02-07 05:16:31 | lamppost | 3 | 146162 | 33 | 7.110 | 20557.2 |
169 | 2024-02-07 00:57:26 | lamppost | 2 | 121059 | 2 | 3.593 | 33693.0 |
168 | 2024-02-07 00:56:02 | lamppost | 3 | 146162 | 33 | 8.486 | 17223.9 |
167 | 2024-02-06 09:59:18 | lamppost | 1 | 82945 | 2 | 1.500 | 55296.7 |
166 | 2024-02-06 09:58:42 | lamppost | 4 | 161609 | 345 | 11.813 | 13680.6 |
165 | 2024-02-06 09:58:50 | lamppost | 2 | 121059 | 2 | 3.766 | 32145.2 |
164 | 2024-02-06 09:58:46 | lamppost | 3 | 146162 | 33 | 7.313 | 19986.6 |
163 | 2024-02-05 00:57:31 | lamppost | 1 | 82945 | 2 | 1.563 | 53067.8 |
162 | 2024-01-24 16:57:28 | lamppost | 3 | 146162 | 33 | 18.343 | 7968.3 |
161 | 2024-01-24 16:57:23 | lamppost | 4 | 161609 | 345 | 14.656 | 11026.8 |
160 | 2024-01-24 16:57:23 | lamppost | 2 | 121059 | 2 | 4.360 | 27765.8 |
159 | 2024-01-24 05:22:52 | lamppost | 1 | 82945 | 2 | 1.250 | 66356.0 |
158 | 2024-01-23 16:59:45 | lamppost | 1 | 82945 | 2 | 6.190 | 13399.8 |
157 | 2024-01-23 16:59:06 | lamppost | 4 | 161609 | 345 | 23.750 | 6804.6 |
156 | 2024-01-23 16:59:08 | lamppost | 2 | 121059 | 2 | 8.580 | 14109.4 |
155 | 2024-01-23 16:58:57 | lamppost | 3 | 146162 | 33 | 10.393 | 14063.5 |
154 | 2024-01-23 14:51:44 | lamppost | 1 | 82945 | 2 | 1.656 | 50087.6 |
153 | 2023-11-20 02:01:59 | lamppost | 1 | 82945 | 2 | 1.266 | 65517.4 |
152 | 2023-10-14 06:29:04 | lamppost | 1 | 82945 | 2 | 1.436 | 57761.1 |
151 | 2023-09-17 12:30:04 | lamppost | 1 | 82945 | 2 | 1.530 | 54212.4 |
150 | 2021-09-21 05:42:35 | lamppost | 1 | 82945 | 2 | 1.470 | 56425.2 |
149 | 2021-09-20 20:54:26 | lamppost | 1 | 82945 | 2 | 1.466 | 56579.1 |
148 | 2021-09-20 03:48:38 | lamppost | 1 | 82945 | 2 | 1.423 | 58288.8 |
147 | 2021-09-14 08:46:58 | lamppost | 1 | 82945 | 2 | 1.420 | 58412.0 |
146 | 2021-07-22 23:10:49 | lamppost | 4 | 161609 | 345 | 10.830 | 14922.3 |
145 | 2021-05-30 00:03:29 | lamppost | 4 | 161609 | 345 | 12.390 | 13043.5 |
144 | 2021-05-12 16:42:05 | lamppost | 4 | 161609 | 345 | 17.800 | 9079.2 |
143 | 2021-05-01 23:54:16 | lamppost | 2 | 121059 | 2 | 3.746 | 32316.9 |
142 | 2021-03-31 07:05:31 | lamppost | 2 | 121059 | 2 | 3.563 | 33976.7 |
141 | 2021-02-24 16:59:10 | lamppost | 1 | 82945 | 2 | 1.560 | 53169.9 |
140 | 2021-01-31 22:02:47 | lamppost | 1 | 82945 | 2 | 1.406 | 58993.6 |
139 | 2021-01-25 18:11:04 | lamppost | 4 | 161609 | 345 | 10.890 | 14840.1 |
138 | 2021-01-14 22:43:37 | lamppost | 2 | 121059 | 2 | 3.186 | 37997.2 |
137 | 2020-12-07 01:22:29 | lamppost | 1 | 82945 | 2 | 1.280 | 64800.8 |
136 | 2020-11-11 14:49:51 | lamppost | 1 | 82945 | 2 | 1.500 | 55296.7 |
135 | 2020-11-06 00:12:42 | lamppost | 4 | 161609 | 345 | 12.813 | 12612.9 |
134 | 2020-11-01 16:28:08 | lamppost | 1 | 82945 | 2 | 1.266 | 65517.4 |
133 | 2020-10-28 21:19:45 | lamppost | 4 | 161609 | 345 | 12.346 | 13090.0 |
132 | 2020-10-27 02:17:36 | lamppost | 2 | 121059 | 2 | 3.453 | 35059.1 |
131 | 2020-03-26 08:53:56 | lamppost | 1 | 82945 | 2 | 1.483 | 55930.5 |
130 | 2020-03-19 04:27:08 | lamppost | 1 | 82945 | 2 | 1.280 | 64800.8 |
129 | 2020-03-16 09:17:35 | lamppost | 1 | 82945 | 2 | 1.516 | 54713.1 |
128 | 2020-03-03 15:04:28 | lamppost | 1 | 82945 | 2 | 1.453 | 57085.3 |
127 | 2020-02-13 08:33:13 | lamppost | 1 | 82945 | 2 | 3.640 | 22787.1 |
126 | 2020-02-03 19:37:53 | lamppost | 1 | 82945 | 2 | 1.716 | 48336.2 |
125 | 2020-02-03 13:42:32 | lamppost | 1 | 82945 | 2 | 3.283 | 25265.0 |
124 | 2020-01-31 15:14:57 | lamppost | 1 | 82945 | 2 | 1.643 | 50483.9 |
123 | 2020-01-27 20:03:19 | lamppost | 1 | 82945 | 2 | 1.530 | 54212.4 |
122 | 2020-01-20 23:09:34 | lamppost | 1 | 82945 | 2 | 4.906 | 16906.8 |
121 | 2020-01-15 22:27:35 | lamppost | 1 | 82945 | 2 | 2.186 | 37943.7 |
120 | 2020-01-15 15:32:48 | lamppost | 1 | 82945 | 2 | 1.486 | 55817.6 |
119 | 2020-01-05 03:11:56 | lamppost | 1 | 82945 | 2 | 1.436 | 57761.1 |
118 | 2019-12-31 22:14:16 | lamppost | 1 | 82945 | 2 | 1.796 | 46183.2 |
117 | 2019-12-04 21:32:06 | lamppost | 1 | 82945 | 2 | 1.373 | 60411.5 |
116 | 2019-09-02 16:40:22 | lamppost | 1 | 82945 | 2 | 1.413 | 58701.3 |
115 | 2019-08-20 09:25:29 | lamppost | 4 | 161609 | 345 | 10.653 | 15170.3 |
114 | 2019-08-16 23:50:34 | lamppost | 4 | 161609 | 345 | 13.260 | 12187.7 |
113 | 2019-05-21 14:28:34 | lamppost | 1 | 82945 | 2 | 1.486 | 55817.6 |