History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"travesty"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
206 | 2024-05-31 04:45:36 | travesty | 2 | 121059 | 4 | 5.203 | 23267.2 |
205 | 2024-05-31 04:43:37 | travesty | 3 | 146162 | 71 | 8.126 | 17987.0 |
204 | 2024-05-30 18:58:05 | travesty | 3 | 146162 | 71 | 9.670 | 15115.0 |
203 | 2024-05-30 18:58:12 | travesty | 1 | 82945 | 1 | 1.670 | 49667.7 |
202 | 2024-05-30 18:58:09 | travesty | 2 | 121059 | 4 | 4.860 | 24909.3 |
201 | 2024-05-16 14:08:36 | travesty | 1 | 82945 | 1 | 1.466 | 56579.1 |
200 | 2024-05-14 08:02:27 | travesty | 2 | 121059 | 4 | 3.750 | 32282.4 |
199 | 2024-05-09 00:56:58 | travesty | 4 | 161609 | 665 | 45.283 | 3568.9 |
198 | 2024-05-07 14:22:20 | travesty | 4 | 161609 | 665 | 22.626 | 7142.6 |
197 | 2024-05-06 18:13:32 | travesty | 1 | 82945 | 1 | 1.736 | 47779.4 |
196 | 2024-05-06 17:23:44 | travesty | 4 | 161609 | 665 | 14.830 | 10897.4 |
195 | 2024-05-06 04:40:53 | travesty | 4 | 161609 | 665 | 27.173 | 5947.4 |
194 | 2024-05-04 18:39:27 | travesty | 3 | 146162 | 71 | 7.876 | 18557.9 |
193 | 2024-05-04 14:26:00 | travesty | 4 | 161609 | 665 | 17.940 | 9008.3 |
192 | 2024-05-04 14:26:04 | travesty | 2 | 121059 | 4 | 7.093 | 17067.4 |
191 | 2024-05-04 14:26:08 | travesty | 1 | 82945 | 1 | 2.470 | 33581.0 |
190 | 2024-05-04 14:24:44 | travesty | 3 | 146162 | 71 | 7.923 | 18447.8 |
189 | 2024-04-28 23:15:01 | travesty | 3 | 146162 | 71 | 8.843 | 16528.6 |
188 | 2024-04-28 07:05:05 | travesty | 2 | 121059 | 4 | 3.736 | 32403.4 |
187 | 2024-04-28 07:04:59 | travesty | 3 | 146162 | 71 | 7.923 | 18447.8 |
186 | 2024-04-28 07:04:45 | travesty | 3 | 146162 | 71 | 15.546 | 9401.9 |
185 | 2024-04-28 07:04:55 | travesty | 1 | 82945 | 1 | 1.516 | 54713.1 |
184 | 2024-04-28 07:04:46 | travesty | 2 | 121059 | 4 | 4.326 | 27984.0 |
183 | 2024-04-28 07:03:21 | travesty | 1 | 82945 | 1 | 1.640 | 50576.2 |
182 | 2024-04-25 23:54:50 | travesty | 1 | 82945 | 1 | 3.656 | 22687.4 |
181 | 2024-04-13 04:32:40 | travesty | 2 | 121059 | 4 | 4.000 | 30264.8 |
180 | 2024-04-10 21:48:11 | travesty | 1 | 82945 | 1 | 3.326 | 24938.4 |
179 | 2024-04-10 21:47:57 | travesty | 2 | 121059 | 4 | 9.360 | 12933.7 |
178 | 2024-04-10 09:21:13 | travesty | 2 | 121059 | 4 | 9.233 | 13111.6 |
177 | 2024-04-10 09:06:21 | travesty | 1 | 82945 | 1 | 1.720 | 48223.8 |
176 | 2024-04-07 13:13:20 | travesty | 4 | 161609 | 665 | 25.266 | 6396.3 |
175 | 2024-04-06 17:07:18 | travesty | 4 | 161609 | 665 | 41.220 | 3920.6 |
174 | 2024-04-05 22:47:48 | travesty | 4 | 161609 | 665 | 20.033 | 8067.1 |
173 | 2024-04-03 12:37:14 | travesty | 1 | 82945 | 1 | 2.796 | 29665.6 |
172 | 2024-04-01 16:37:40 | travesty | 3 | 146162 | 71 | 29.143 | 5015.3 |
171 | 2024-04-01 16:37:17 | travesty | 4 | 161609 | 665 | 32.486 | 4974.7 |
170 | 2024-04-01 16:37:33 | travesty | 2 | 121059 | 4 | 7.030 | 17220.3 |
169 | 2024-04-01 16:35:58 | travesty | 1 | 82945 | 1 | 1.563 | 53067.8 |
168 | 2024-03-29 15:56:06 | travesty | 3 | 146162 | 71 | 23.906 | 6114.0 |
167 | 2024-03-29 05:15:55 | travesty | 3 | 146162 | 71 | 17.783 | 8219.2 |
166 | 2024-03-28 09:30:37 | travesty | 3 | 146162 | 71 | 8.423 | 17352.7 |
165 | 2024-03-28 09:30:36 | travesty | 2 | 121059 | 4 | 6.153 | 19674.8 |
164 | 2024-03-28 09:30:25 | travesty | 1 | 82945 | 1 | 2.750 | 30161.8 |
163 | 2024-03-28 08:06:07 | travesty | 3 | 146162 | 71 | 9.110 | 16044.1 |
162 | 2024-03-28 08:06:14 | travesty | 1 | 82945 | 1 | 1.423 | 58288.8 |
161 | 2024-03-28 08:06:06 | travesty | 2 | 121059 | 4 | 4.046 | 29920.7 |
160 | 2024-03-28 08:06:02 | travesty | 1 | 82945 | 1 | 1.623 | 51106.0 |
159 | 2024-03-07 20:09:12 | travesty | 4 | 161609 | 665 | 12.610 | 12815.9 |
158 | 2024-03-06 23:38:22 | travesty | 4 | 161609 | 665 | 30.266 | 5339.6 |
157 | 2024-03-06 12:04:50 | travesty | 4 | 161609 | 665 | 22.580 | 7157.2 |
156 | 2024-03-06 10:56:12 | travesty | 1 | 82945 | 1 | 3.280 | 25288.1 |
155 | 2024-03-06 10:21:46 | travesty | 4 | 161609 | 665 | 14.423 | 11205.0 |
154 | 2024-03-02 09:04:04 | travesty | 4 | 161609 | 665 | 20.313 | 7955.9 |
153 | 2024-03-02 09:04:06 | travesty | 3 | 146162 | 71 | 14.360 | 10178.4 |
152 | 2024-03-02 09:04:07 | travesty | 2 | 121059 | 4 | 4.093 | 29577.1 |
151 | 2024-03-02 09:04:03 | travesty | 1 | 82945 | 1 | 1.420 | 58412.0 |
150 | 2024-03-01 02:39:15 | travesty | 1 | 82945 | 1 | 1.406 | 58993.6 |
149 | 2024-02-06 02:08:29 | travesty | 2 | 121059 | 4 | 3.393 | 35679.0 |
148 | 2024-02-06 02:07:41 | travesty | 3 | 146162 | 71 | 6.626 | 22058.9 |
147 | 2024-02-06 02:02:25 | travesty | 4 | 161609 | 665 | 11.860 | 13626.4 |
146 | 2024-02-04 10:25:18 | travesty | 3 | 146162 | 71 | 10.873 | 13442.7 |
145 | 2024-02-04 08:38:39 | travesty | 4 | 161609 | 665 | 24.250 | 6664.3 |
144 | 2024-02-04 06:17:14 | travesty | 2 | 121059 | 4 | 7.720 | 15681.2 |
143 | 2024-02-04 06:16:50 | travesty | 4 | 161609 | 665 | 14.220 | 11364.9 |
142 | 2024-02-04 06:16:54 | travesty | 3 | 146162 | 71 | 7.876 | 18557.9 |
141 | 2024-02-04 06:15:51 | travesty | 4 | 161609 | 665 | 13.440 | 12024.5 |
140 | 2024-02-04 06:15:55 | travesty | 3 | 146162 | 71 | 8.076 | 18098.3 |
139 | 2024-02-04 06:15:47 | travesty | 2 | 121059 | 4 | 3.236 | 37410.1 |
138 | 2024-02-01 23:06:09 | travesty | 1 | 82945 | 1 | 1.330 | 62364.7 |
137 | 2024-01-26 20:37:43 | travesty | 1 | 82945 | 1 | 1.436 | 57761.1 |
136 | 2024-01-19 21:27:58 | travesty | 1 | 82945 | 1 | 2.546 | 32578.6 |
135 | 2023-11-17 22:49:48 | travesty | 1 | 82945 | 1 | 1.296 | 64000.8 |
134 | 2023-11-15 20:27:26 | travesty | 1 | 82945 | 1 | 1.343 | 61761.0 |
133 | 2023-10-30 01:39:25 | travesty | 1 | 82945 | 1 | 1.423 | 58288.8 |
132 | 2023-10-09 18:03:23 | travesty | 1 | 82945 | 1 | 1.280 | 64800.8 |
131 | 2023-08-20 05:17:38 | travesty | 1 | 82945 | 1 | 1.283 | 64649.3 |
130 | 2023-07-03 23:55:49 | travesty | 1 | 82945 | 1 | 2.970 | 27927.6 |
129 | 2023-05-29 22:53:49 | travesty | 1 | 82945 | 1 | 2.486 | 33364.8 |
128 | 2023-01-04 21:00:30 | travesty | 1 | 82945 | 1 | 1.360 | 60989.0 |
127 | 2022-07-25 01:30:49 | travesty | 1 | 82945 | 1 | 1.390 | 59672.7 |
126 | 2022-01-31 01:40:21 | travesty | 1 | 82945 | 1 | 1.326 | 62552.8 |
125 | 2022-01-27 14:40:28 | travesty | 1 | 82945 | 1 | 1.483 | 55930.5 |
124 | 2021-09-12 03:53:25 | travesty | 1 | 82945 | 1 | 1.280 | 64800.8 |
123 | 2021-05-16 00:59:12 | travesty | 1 | 82945 | 1 | 1.420 | 58412.0 |
122 | 2021-05-12 16:53:48 | travesty | 1 | 82945 | 1 | 1.470 | 56425.2 |
121 | 2021-04-15 16:07:15 | travesty | 1 | 82945 | 1 | 1.576 | 52630.1 |
120 | 2021-02-21 18:04:22 | travesty | 1 | 82945 | 1 | 1.390 | 59672.7 |
119 | 2021-02-08 17:45:15 | travesty | 1 | 82945 | 1 | 1.516 | 54713.1 |
118 | 2020-11-14 06:51:30 | travesty | 1 | 82945 | 1 | 1.313 | 63172.1 |
117 | 2020-11-06 23:39:54 | travesty | 1 | 82945 | 1 | 1.373 | 60411.5 |
116 | 2020-07-23 14:37:10 | travesty | 1 | 82945 | 1 | 1.500 | 55296.7 |
115 | 2020-04-09 05:27:32 | travesty | 1 | 82945 | 1 | 1.576 | 52630.1 |
114 | 2020-03-28 23:09:21 | travesty | 1 | 82945 | 1 | 1.293 | 64149.3 |
113 | 2020-03-26 11:14:28 | travesty | 1 | 82945 | 1 | 1.296 | 64000.8 |
112 | 2020-02-29 15:02:30 | travesty | 1 | 82945 | 1 | 1.486 | 55817.6 |
111 | 2020-02-26 12:26:19 | travesty | 1 | 82945 | 1 | 2.046 | 40540.1 |
110 | 2020-02-23 03:04:21 | travesty | 1 | 82945 | 1 | 1.500 | 55296.7 |
109 | 2020-02-05 01:11:54 | travesty | 1 | 82945 | 1 | 1.530 | 54212.4 |
108 | 2020-01-31 16:58:47 | travesty | 1 | 82945 | 1 | 1.423 | 58288.8 |
107 | 2020-01-31 15:07:00 | travesty | 1 | 82945 | 1 | 1.720 | 48223.8 |