History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subcolony"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
223 | 2025-08-09 11:24:13 | subcolony | 1 | 81242 | 1 | 3.233 | 25129.0 |
222 | 2025-08-02 05:35:55 | subcolony | 1 | 81242 | 1 | 3.126 | 25989.1 |
221 | 2025-07-25 09:23:47 | subcolony | 1 | 81242 | 1 | 4.030 | 20159.3 |
220 | 2025-07-25 00:49:08 | subcolony | 1 | 81242 | 1 | 5.796 | 14016.9 |
219 | 2025-07-15 09:28:49 | subcolony | 1 | 81242 | 1 | 6.813 | 11924.6 |
218 | 2025-07-05 04:53:54 | subcolony | 2 | 121436 | 1 | 23.500 | 5167.5 |
217 | 2025-07-04 11:22:39 | subcolony | 1 | 81242 | 1 | 1.280 | 63470.3 |
216 | 2025-06-23 22:47:29 | subcolony | 1 | 81242 | 1 | 6.720 | 12089.6 |
215 | 2025-06-20 11:27:40 | subcolony | 1 | 81242 | 1 | 11.203 | 7251.8 |
214 | 2025-05-06 11:03:50 | subcolony | 1 | 81242 | 1 | 10.766 | 7546.2 |
213 | 2025-04-30 09:49:21 | subcolony | 1 | 81242 | 1 | 5.736 | 14163.5 |
212 | 2025-04-10 19:21:52 | subcolony | 1 | 81242 | 1 | 1.563 | 51978.2 |
211 | 2025-03-29 13:05:05 | subcolony | 1 | 81242 | 1 | 7.030 | 11556.5 |
210 | 2025-03-28 12:05:40 | subcolony | 1 | 81242 | 1 | 4.360 | 18633.5 |
209 | 2025-02-26 05:06:52 | subcolony | 3 | 148641 | 13 | 43.283 | 3434.2 |
208 | 2025-02-26 05:06:50 | subcolony | 3 | 148641 | 13 | 26.686 | 5570.0 |
207 | 2025-02-26 05:06:52 | subcolony | 2 | 121436 | 1 | 15.003 | 8094.1 |
206 | 2025-02-26 05:05:41 | subcolony | 1 | 81242 | 1 | 3.326 | 24426.3 |
205 | 2025-02-18 10:00:47 | subcolony | 1 | 81242 | 1 | 6.483 | 12531.5 |
204 | 2025-02-10 09:32:47 | subcolony | 2 | 121436 | 1 | 23.610 | 5143.4 |
203 | 2025-02-10 09:02:11 | subcolony | 1 | 81242 | 1 | 1.436 | 56575.2 |
202 | 2025-01-19 17:04:37 | subcolony | 1 | 81242 | 1 | 8.923 | 9104.8 |
201 | 2025-01-19 11:23:16 | subcolony | 2 | 121436 | 1 | 25.456 | 4770.4 |
200 | 2025-01-19 11:17:14 | subcolony | 3 | 148641 | 13 | 39.940 | 3721.6 |
199 | 2025-01-19 11:10:18 | subcolony | 1 | 81242 | 1 | 7.170 | 11330.8 |
198 | 2025-01-19 10:54:46 | subcolony | 3 | 148641 | 13 | 7.500 | 19818.8 |
197 | 2025-01-17 22:35:04 | subcolony | 3 | 148641 | 13 | 37.330 | 3981.8 |
196 | 2025-01-17 07:13:08 | subcolony | 3 | 148641 | 13 | 38.360 | 3874.9 |
195 | 2025-01-17 07:00:08 | subcolony | 4 | 165329 | 107 | 61.833 | 2673.8 |
194 | 2025-01-16 00:14:21 | subcolony | 4 | 165329 | 107 | 59.440 | 2781.4 |
193 | 2025-01-05 16:54:23 | subcolony | 2 | 121436 | 1 | 13.953 | 8703.2 |
192 | 2025-01-05 15:39:58 | subcolony | 1 | 81242 | 1 | 1.470 | 55266.7 |
191 | 2024-12-26 12:58:50 | subcolony | 1 | 81242 | 1 | 2.123 | 38267.5 |
190 | 2024-12-19 09:00:17 | subcolony | 1 | 81242 | 1 | 3.923 | 20709.2 |
189 | 2024-12-18 21:27:28 | subcolony | 4 | 165329 | 107 | 77.926 | 2121.6 |
188 | 2024-12-17 12:28:04 | subcolony | 4 | 165329 | 107 | 67.630 | 2444.6 |
187 | 2024-12-16 21:08:39 | subcolony | 4 | 165329 | 107 | 38.190 | 4329.1 |
186 | 2024-12-16 15:20:24 | subcolony | 2 | 121436 | 1 | 25.926 | 4683.9 |
185 | 2024-12-16 15:01:29 | subcolony | 4 | 165329 | 107 | 14.016 | 11795.7 |
184 | 2024-12-16 15:01:22 | subcolony | 1 | 81242 | 1 | 1.266 | 64172.2 |
183 | 2024-12-16 14:59:01 | subcolony | 3 | 148641 | 13 | 25.800 | 5761.3 |
182 | 2024-12-15 14:40:22 | subcolony | 3 | 148641 | 13 | 37.003 | 4017.0 |
181 | 2024-12-13 21:10:58 | subcolony | 3 | 148641 | 13 | 35.616 | 4173.4 |
180 | 2024-11-30 14:22:12 | subcolony | 1 | 81242 | 1 | 8.560 | 9490.9 |
179 | 2024-11-08 06:37:18 | subcolony | 1 | 81242 | 1 | 9.046 | 8981.0 |
178 | 2024-11-03 09:47:38 | subcolony | 1 | 81242 | 1 | 6.186 | 13133.2 |
177 | 2024-10-28 23:26:35 | subcolony | 1 | 81242 | 1 | 3.766 | 21572.5 |
176 | 2024-10-25 08:28:24 | subcolony | 3 | 148641 | 13 | 45.956 | 3234.4 |
175 | 2024-10-19 10:04:49 | subcolony | 3 | 148641 | 13 | 30.923 | 4806.8 |
174 | 2024-10-16 00:48:27 | subcolony | 3 | 148641 | 13 | 35.723 | 4160.9 |
173 | 2024-10-03 20:49:15 | subcolony | 1 | 81242 | 1 | 20.890 | 3889.0 |
172 | 2024-09-18 07:18:55 | subcolony | 1 | 81242 | 1 | 14.220 | 5713.2 |
171 | 2024-08-26 04:03:33 | subcolony | 1 | 81242 | 1 | 10.080 | 8059.7 |
170 | 2024-08-18 04:48:03 | subcolony | 1 | 81242 | 1 | 2.593 | 31331.3 |
169 | 2024-08-17 19:15:03 | subcolony | 1 | 81242 | 1 | 7.140 | 11378.4 |
168 | 2024-08-15 08:50:32 | subcolony | 1 | 81242 | 1 | 4.720 | 17212.3 |
167 | 2024-08-08 07:57:13 | subcolony | 3 | 148641 | 13 | 13.690 | 10857.6 |
166 | 2024-08-05 11:47:27 | subcolony | 3 | 148641 | 13 | 37.943 | 3917.5 |
165 | 2024-08-04 10:57:46 | subcolony | 3 | 148641 | 13 | 22.220 | 6689.5 |
164 | 2024-08-04 10:57:50 | subcolony | 2 | 121436 | 1 | 17.360 | 6995.2 |
163 | 2024-08-04 10:57:19 | subcolony | 3 | 148641 | 13 | 27.326 | 5439.5 |
162 | 2024-08-04 10:56:17 | subcolony | 1 | 81242 | 1 | 5.170 | 15714.1 |
161 | 2024-07-26 14:09:45 | subcolony | 3 | 148641 | 13 | 37.846 | 3927.5 |
160 | 2024-07-26 14:09:46 | subcolony | 2 | 121436 | 1 | 11.283 | 10762.7 |
159 | 2024-07-26 14:09:13 | subcolony | 3 | 148641 | 13 | 29.926 | 4967.0 |
158 | 2024-07-26 14:06:44 | subcolony | 1 | 81242 | 1 | 2.656 | 30588.1 |
157 | 2024-06-13 05:42:15 | subcolony | 3 | 148641 | 13 | 29.566 | 5027.4 |
156 | 2024-06-10 18:26:38 | subcolony | 3 | 148641 | 13 | 46.050 | 3227.8 |
155 | 2024-06-10 18:26:40 | subcolony | 2 | 121436 | 1 | 15.156 | 8012.4 |
154 | 2024-06-10 18:22:13 | subcolony | 1 | 81242 | 1 | 2.390 | 33992.5 |
153 | 2024-06-10 16:55:20 | subcolony | 3 | 148641 | 13 | 17.750 | 8374.1 |
152 | 2024-06-08 17:07:27 | subcolony | 1 | 81242 | 1 | 7.470 | 10875.8 |
151 | 2024-06-08 14:54:23 | subcolony | 3 | 148641 | 13 | 27.766 | 5353.3 |
150 | 2024-06-08 14:53:47 | subcolony | 3 | 148641 | 13 | 33.890 | 4386.0 |
149 | 2024-06-06 00:44:43 | subcolony | 3 | 148641 | 13 | 31.473 | 4722.8 |
148 | 2024-06-05 05:00:37 | subcolony | 4 | 165329 | 107 | 33.830 | 4887.1 |
147 | 2024-06-05 05:00:46 | subcolony | 3 | 148641 | 13 | 21.113 | 7040.3 |
146 | 2024-06-05 05:00:49 | subcolony | 2 | 121436 | 1 | 14.516 | 8365.7 |
145 | 2024-06-05 05:00:09 | subcolony | 1 | 81242 | 1 | 4.860 | 16716.5 |
144 | 2024-05-29 09:05:13 | subcolony | 1 | 81242 | 1 | 7.080 | 11474.9 |
143 | 2024-05-27 17:32:59 | subcolony | 1 | 81242 | 1 | 6.266 | 12965.5 |
142 | 2024-04-27 06:29:29 | subcolony | 2 | 121436 | 1 | 9.800 | 12391.4 |
141 | 2024-04-27 06:17:45 | subcolony | 1 | 81242 | 1 | 1.470 | 55266.7 |
140 | 2024-04-19 04:26:19 | subcolony | 3 | 148641 | 13 | 18.516 | 8027.7 |
139 | 2024-04-18 13:27:08 | subcolony | 3 | 148641 | 13 | 22.546 | 6592.8 |
138 | 2024-04-18 13:27:09 | subcolony | 2 | 121436 | 1 | 12.656 | 9595.1 |
137 | 2024-04-18 13:26:25 | subcolony | 1 | 81242 | 1 | 5.796 | 14016.9 |
136 | 2024-04-13 11:07:52 | subcolony | 1 | 81242 | 1 | 1.296 | 62686.7 |
135 | 2024-04-11 01:04:12 | subcolony | 1 | 81242 | 1 | 1.313 | 61875.1 |
134 | 2024-04-04 20:36:27 | subcolony | 4 | 165329 | 107 | 20.016 | 8259.8 |
133 | 2024-03-28 00:46:39 | subcolony | 1 | 81242 | 1 | 1.516 | 53589.7 |
132 | 2024-03-25 13:26:04 | subcolony | 4 | 165329 | 107 | 12.063 | 13705.5 |
131 | 2024-03-18 09:54:56 | subcolony | 4 | 165329 | 107 | 42.596 | 3881.3 |
130 | 2024-03-18 09:54:53 | subcolony | 3 | 148641 | 13 | 21.750 | 6834.1 |
129 | 2024-03-18 09:54:51 | subcolony | 2 | 121436 | 1 | 7.406 | 16397.0 |
128 | 2024-03-18 09:07:32 | subcolony | 1 | 81242 | 1 | 1.703 | 47705.2 |
127 | 2024-03-10 08:52:31 | subcolony | 4 | 165329 | 107 | 46.583 | 3549.1 |
126 | 2024-03-08 07:30:50 | subcolony | 2 | 121436 | 1 | 10.110 | 12011.5 |
125 | 2024-03-08 07:30:24 | subcolony | 1 | 81242 | 1 | 4.780 | 16996.2 |
124 | 2024-03-08 07:29:33 | subcolony | 4 | 165329 | 107 | 35.970 | 4596.3 |