History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tipstaff"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
220 | 2024-05-17 09:44:45 | tipstaff | 3 | 146162 | 13 | 24.190 | 6042.2 |
219 | 2024-05-12 23:57:52 | tipstaff | 2 | 121059 | 3 | 13.440 | 9007.4 |
218 | 2024-05-12 23:01:36 | tipstaff | 3 | 146162 | 13 | 7.643 | 19123.6 |
217 | 2024-05-11 08:36:06 | tipstaff | 1 | 82945 | 2 | 3.173 | 26140.9 |
216 | 2024-05-09 05:12:41 | tipstaff | 3 | 146162 | 13 | 7.453 | 19611.2 |
215 | 2024-05-06 23:31:01 | tipstaff | 1 | 82945 | 2 | 1.610 | 51518.6 |
214 | 2024-05-06 23:30:18 | tipstaff | 2 | 121059 | 3 | 6.016 | 20122.8 |
213 | 2024-05-06 23:29:41 | tipstaff | 3 | 146162 | 13 | 15.423 | 9476.9 |
212 | 2024-05-06 06:59:27 | tipstaff | 1 | 82945 | 2 | 1.576 | 52630.1 |
211 | 2024-05-06 00:27:49 | tipstaff | 4 | 161609 | 120 | 21.160 | 7637.5 |
210 | 2024-05-04 19:01:43 | tipstaff | 4 | 161609 | 120 | 13.610 | 11874.3 |
209 | 2024-05-04 00:24:19 | tipstaff | 2 | 121059 | 3 | 7.546 | 16042.8 |
208 | 2024-05-04 00:16:43 | tipstaff | 2 | 121059 | 3 | 3.873 | 31257.2 |
207 | 2024-05-04 00:16:12 | tipstaff | 1 | 82945 | 2 | 1.483 | 55930.5 |
206 | 2024-05-04 00:02:13 | tipstaff | 1 | 82945 | 2 | 4.826 | 17187.1 |
205 | 2024-05-03 23:47:35 | tipstaff | 3 | 146162 | 13 | 7.453 | 19611.2 |
204 | 2024-05-02 13:49:48 | tipstaff | 4 | 161609 | 120 | 11.330 | 14263.8 |
203 | 2024-05-02 06:45:27 | tipstaff | 4 | 161609 | 120 | 13.780 | 11727.8 |
202 | 2024-05-01 21:34:10 | tipstaff | 4 | 161609 | 120 | 15.703 | 10291.6 |
201 | 2024-04-30 21:17:29 | tipstaff | 4 | 161609 | 120 | 29.826 | 5418.4 |
200 | 2024-04-22 15:16:20 | tipstaff | 4 | 161609 | 120 | 20.440 | 7906.5 |
199 | 2024-04-18 23:39:23 | tipstaff | 3 | 146162 | 13 | 27.050 | 5403.4 |
198 | 2024-04-18 23:39:19 | tipstaff | 4 | 161609 | 120 | 29.500 | 5478.3 |
197 | 2024-04-18 23:39:21 | tipstaff | 2 | 121059 | 3 | 12.720 | 9517.2 |
196 | 2024-04-18 22:39:07 | tipstaff | 1 | 82945 | 2 | 1.486 | 55817.6 |
195 | 2024-04-09 20:45:45 | tipstaff | 3 | 146162 | 13 | 9.860 | 14823.7 |
194 | 2024-04-09 01:56:03 | tipstaff | 3 | 146162 | 13 | 9.596 | 15231.6 |
193 | 2024-04-08 08:03:40 | tipstaff | 3 | 146162 | 13 | 9.390 | 15565.7 |
192 | 2024-04-08 08:03:38 | tipstaff | 2 | 121059 | 3 | 4.093 | 29577.1 |
191 | 2024-04-08 08:03:37 | tipstaff | 1 | 82945 | 2 | 2.750 | 30161.8 |
190 | 2024-04-05 20:45:44 | tipstaff | 3 | 146162 | 13 | 25.970 | 5628.1 |
189 | 2024-04-05 20:35:22 | tipstaff | 2 | 121059 | 3 | 4.156 | 29128.7 |
188 | 2024-04-05 20:35:05 | tipstaff | 4 | 161609 | 120 | 13.890 | 11634.9 |
187 | 2024-04-05 20:35:15 | tipstaff | 1 | 82945 | 2 | 1.593 | 52068.4 |
186 | 2024-04-02 22:48:28 | tipstaff | 4 | 161609 | 120 | 45.830 | 3526.3 |
185 | 2024-04-01 07:18:20 | tipstaff | 1 | 82945 | 2 | 6.406 | 12948.0 |
184 | 2024-04-01 07:13:29 | tipstaff | 3 | 146162 | 13 | 8.236 | 17746.7 |
183 | 2024-04-01 07:13:17 | tipstaff | 4 | 161609 | 120 | 14.376 | 11241.6 |
182 | 2024-04-01 07:13:17 | tipstaff | 2 | 121059 | 3 | 4.016 | 30144.2 |
181 | 2024-03-29 07:54:33 | tipstaff | 4 | 161609 | 120 | 31.766 | 5087.5 |
180 | 2024-03-29 07:54:45 | tipstaff | 1 | 82945 | 2 | 4.846 | 17116.2 |
179 | 2024-03-29 07:54:30 | tipstaff | 2 | 121059 | 3 | 8.610 | 14060.3 |
178 | 2024-03-09 01:35:51 | tipstaff | 3 | 146162 | 13 | 24.956 | 5856.8 |
177 | 2024-03-08 21:26:43 | tipstaff | 1 | 82945 | 2 | 1.516 | 54713.1 |
176 | 2024-03-08 14:52:23 | tipstaff | 3 | 146162 | 13 | 13.890 | 10522.8 |
175 | 2024-03-08 01:03:24 | tipstaff | 2 | 121059 | 3 | 4.533 | 26706.2 |
174 | 2024-03-07 18:50:46 | tipstaff | 3 | 146162 | 13 | 11.376 | 12848.3 |
173 | 2024-03-07 18:15:32 | tipstaff | 1 | 82945 | 2 | 2.423 | 34232.4 |
172 | 2024-03-06 03:10:33 | tipstaff | 1 | 82945 | 2 | 1.593 | 52068.4 |
171 | 2024-03-01 17:26:40 | tipstaff | 4 | 161609 | 120 | 25.393 | 6364.3 |
170 | 2024-02-27 04:59:38 | tipstaff | 4 | 161609 | 120 | 34.393 | 4698.9 |
169 | 2024-02-26 22:57:57 | tipstaff | 4 | 161609 | 120 | 34.796 | 4644.5 |
168 | 2024-02-09 19:25:33 | tipstaff | 4 | 161609 | 120 | 12.890 | 12537.5 |
167 | 2024-02-07 01:36:50 | tipstaff | 4 | 161609 | 120 | 12.940 | 12489.1 |
166 | 2024-02-03 03:15:21 | tipstaff | 1 | 82945 | 2 | 1.406 | 58993.6 |
165 | 2024-02-03 03:14:37 | tipstaff | 2 | 121059 | 3 | 3.576 | 33853.2 |
164 | 2024-02-03 03:14:17 | tipstaff | 3 | 146162 | 13 | 7.060 | 20702.8 |
163 | 2024-02-01 01:35:36 | tipstaff | 1 | 82945 | 2 | 1.453 | 57085.3 |
162 | 2024-02-01 01:35:32 | tipstaff | 1 | 82945 | 2 | 1.470 | 56425.2 |
161 | 2024-01-30 13:52:11 | tipstaff | 2 | 121059 | 3 | 3.623 | 33414.0 |
160 | 2024-01-30 13:51:59 | tipstaff | 3 | 146162 | 13 | 8.593 | 17009.4 |
159 | 2024-01-26 16:57:17 | tipstaff | 4 | 161609 | 120 | 16.453 | 9822.5 |
158 | 2024-01-26 06:36:59 | tipstaff | 4 | 161609 | 120 | 16.423 | 9840.4 |
157 | 2024-01-26 06:36:55 | tipstaff | 2 | 121059 | 3 | 3.736 | 32403.4 |
156 | 2024-01-26 06:36:03 | tipstaff | 3 | 146162 | 13 | 8.170 | 17890.1 |
155 | 2024-01-17 10:58:49 | tipstaff | 3 | 146162 | 13 | 6.250 | 23385.9 |
154 | 2024-01-17 10:02:04 | tipstaff | 1 | 82945 | 2 | 1.280 | 64800.8 |
153 | 2024-01-01 07:13:31 | tipstaff | 1 | 82945 | 2 | 1.436 | 57761.1 |
152 | 2023-12-14 16:38:34 | tipstaff | 4 | 161609 | 120 | 11.763 | 13738.8 |
151 | 2023-12-11 20:56:15 | tipstaff | 1 | 82945 | 2 | 1.343 | 61761.0 |
150 | 2023-11-12 12:30:45 | tipstaff | 1 | 82945 | 2 | 1.376 | 60279.8 |
149 | 2023-10-29 03:12:49 | tipstaff | 3 | 146162 | 13 | 6.360 | 22981.4 |
148 | 2023-09-29 03:20:53 | tipstaff | 1 | 82945 | 2 | 1.250 | 66356.0 |
147 | 2023-09-27 18:05:59 | tipstaff | 4 | 161609 | 120 | 12.563 | 12863.9 |
146 | 2023-09-14 15:47:54 | tipstaff | 4 | 161609 | 120 | 11.546 | 13997.0 |
145 | 2023-09-06 16:28:41 | tipstaff | 1 | 82945 | 2 | 1.266 | 65517.4 |
144 | 2023-08-31 21:49:40 | tipstaff | 1 | 82945 | 2 | 1.546 | 53651.4 |
143 | 2023-08-07 12:01:38 | tipstaff | 3 | 146162 | 13 | 6.080 | 24039.8 |
142 | 2023-06-14 19:14:04 | tipstaff | 4 | 161609 | 120 | 10.500 | 15391.3 |
141 | 2023-06-05 10:18:30 | tipstaff | 1 | 82945 | 2 | 1.406 | 58993.6 |
140 | 2023-04-17 23:07:36 | tipstaff | 3 | 146162 | 13 | 6.936 | 21073.0 |
139 | 2023-04-03 13:30:43 | tipstaff | 1 | 82945 | 2 | 1.360 | 60989.0 |
138 | 2023-03-27 05:55:40 | tipstaff | 1 | 82945 | 2 | 1.423 | 58288.8 |
137 | 2023-03-13 07:48:37 | tipstaff | 4 | 161609 | 120 | 10.173 | 15886.1 |
136 | 2023-01-26 08:24:24 | tipstaff | 3 | 146162 | 13 | 7.390 | 19778.3 |
135 | 2023-01-10 18:12:48 | tipstaff | 1 | 82945 | 2 | 1.220 | 67987.7 |
134 | 2022-12-17 05:14:25 | tipstaff | 4 | 161609 | 120 | 17.033 | 9488.0 |
133 | 2022-11-08 21:54:55 | tipstaff | 3 | 146162 | 13 | 6.530 | 22383.2 |
132 | 2022-10-24 18:30:23 | tipstaff | 1 | 82945 | 2 | 1.266 | 65517.4 |
131 | 2022-10-21 04:06:22 | tipstaff | 1 | 82945 | 2 | 1.423 | 58288.8 |
130 | 2022-10-17 05:30:45 | tipstaff | 1 | 82945 | 2 | 1.236 | 67107.6 |
129 | 2022-08-06 17:47:20 | tipstaff | 4 | 161609 | 120 | 11.610 | 13919.8 |
128 | 2022-06-06 12:14:47 | tipstaff | 1 | 82945 | 2 | 1.236 | 67107.6 |
127 | 2022-05-09 10:11:57 | tipstaff | 1 | 82945 | 2 | 1.516 | 54713.1 |
126 | 2022-05-06 17:15:52 | tipstaff | 3 | 146162 | 13 | 6.143 | 23793.3 |
125 | 2022-05-04 12:42:39 | tipstaff | 3 | 146162 | 13 | 7.440 | 19645.4 |
124 | 2022-02-14 02:40:34 | tipstaff | 1 | 82945 | 2 | 1.453 | 57085.3 |
123 | 2021-12-13 17:59:12 | tipstaff | 1 | 82945 | 2 | 1.486 | 55817.6 |
122 | 2021-12-03 12:24:07 | tipstaff | 1 | 82945 | 2 | 1.403 | 59119.7 |
121 | 2021-12-01 11:10:12 | tipstaff | 1 | 82945 | 2 | 1.593 | 52068.4 |