History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"videophile"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
209 | 2024-04-27 01:33:03 | videophile | 1 | 67641 | 2 | 1.203 | 56226.9 |
208 | 2024-03-26 13:30:28 | videophile | 3 | 140603 | 11 | 14.656 | 9593.5 |
207 | 2024-03-26 13:30:20 | videophile | 2 | 108824 | 3 | 3.483 | 31244.3 |
206 | 2024-03-22 15:01:06 | videophile | 4 | 161450 | 45 | 15.250 | 10586.9 |
205 | 2024-03-19 06:46:45 | videophile | 1 | 67641 | 2 | 3.703 | 18266.5 |
204 | 2024-03-13 12:20:54 | videophile | 3 | 140603 | 11 | 11.173 | 12584.2 |
203 | 2024-03-10 11:24:39 | videophile | 4 | 161450 | 45 | 43.143 | 3742.2 |
202 | 2024-03-10 11:24:12 | videophile | 3 | 140603 | 11 | 11.796 | 11919.5 |
201 | 2024-03-09 07:41:47 | videophile | 5 | 173545 | 211 | 27.143 | 6393.7 |
200 | 2024-03-08 09:16:14 | videophile | 4 | 161450 | 45 | 19.363 | 8338.1 |
199 | 2024-03-08 09:16:19 | videophile | 2 | 108824 | 3 | 13.126 | 8290.7 |
198 | 2024-03-08 09:16:16 | videophile | 3 | 140603 | 11 | 14.813 | 9491.9 |
197 | 2024-03-08 09:14:16 | videophile | 4 | 161450 | 45 | 27.940 | 5778.5 |
196 | 2024-03-08 09:14:30 | videophile | 2 | 108824 | 3 | 10.546 | 10319.0 |
195 | 2024-03-08 09:14:16 | videophile | 3 | 140603 | 11 | 7.546 | 18632.8 |
194 | 2024-03-08 09:13:18 | videophile | 1 | 67641 | 2 | 1.263 | 53555.8 |
193 | 2024-03-07 14:00:58 | videophile | 1 | 67641 | 2 | 1.016 | 66575.8 |
192 | 2024-03-06 17:48:07 | videophile | 5 | 173545 | 211 | 37.080 | 4680.3 |
191 | 2024-03-06 15:29:12 | videophile | 5 | 173545 | 211 | 44.736 | 3879.3 |
190 | 2024-02-22 23:28:23 | videophile | 2 | 108824 | 3 | 3.826 | 28443.3 |
189 | 2024-02-21 19:11:06 | videophile | 1 | 67641 | 2 | 2.406 | 28113.5 |
188 | 2024-02-20 03:02:53 | videophile | 1 | 67641 | 2 | 1.716 | 39417.8 |
187 | 2024-02-19 08:34:05 | videophile | 3 | 140603 | 11 | 14.203 | 9899.5 |
186 | 2024-02-14 05:29:38 | videophile | 2 | 108824 | 3 | 6.966 | 15622.2 |
185 | 2024-02-14 05:26:54 | videophile | 1 | 67641 | 2 | 2.420 | 27950.8 |
184 | 2024-02-10 07:38:37 | videophile | 2 | 108824 | 3 | 3.906 | 27860.7 |
183 | 2024-02-10 06:48:45 | videophile | 1 | 67641 | 2 | 1.000 | 67641.0 |
182 | 2024-02-03 11:53:10 | videophile | 1 | 67641 | 2 | 0.966 | 70021.7 |
181 | 2024-01-26 13:52:33 | videophile | 5 | 173545 | 211 | 19.703 | 8808.0 |
180 | 2024-01-26 13:52:22 | videophile | 4 | 161450 | 45 | 11.050 | 14610.9 |
179 | 2024-01-26 13:52:15 | videophile | 3 | 140603 | 11 | 6.500 | 21631.2 |
178 | 2024-01-26 13:52:12 | videophile | 2 | 108824 | 3 | 2.873 | 37878.2 |
177 | 2024-01-26 13:10:12 | videophile | 1 | 67641 | 2 | 2.326 | 29080.4 |
176 | 2024-01-24 04:54:15 | videophile | 4 | 161450 | 45 | 9.063 | 17814.2 |
175 | 2023-12-13 22:49:27 | videophile | 1 | 67641 | 2 | 0.986 | 68601.4 |
174 | 2023-12-10 08:28:25 | videophile | 1 | 67641 | 2 | 1.093 | 61885.6 |
173 | 2023-12-05 20:23:00 | videophile | 1 | 67641 | 2 | 1.093 | 61885.6 |
172 | 2023-11-19 14:42:05 | videophile | 2 | 108824 | 3 | 2.563 | 42459.6 |
171 | 2023-11-16 08:59:57 | videophile | 3 | 140603 | 11 | 5.233 | 26868.5 |
170 | 2023-11-02 23:18:57 | videophile | 4 | 161450 | 45 | 9.516 | 16966.2 |
169 | 2023-10-20 02:50:54 | videophile | 1 | 67641 | 2 | 1.123 | 60232.4 |
168 | 2023-09-19 21:59:55 | videophile | 1 | 67641 | 2 | 0.983 | 68810.8 |
167 | 2023-08-19 13:48:18 | videophile | 2 | 108824 | 3 | 2.593 | 41968.4 |
166 | 2023-08-17 23:05:52 | videophile | 3 | 140603 | 11 | 5.266 | 26700.2 |
165 | 2023-08-10 13:25:07 | videophile | 4 | 161450 | 45 | 9.253 | 17448.4 |
164 | 2023-07-09 04:42:38 | videophile | 1 | 67641 | 2 | 1.000 | 67641.0 |
163 | 2023-06-26 11:31:38 | videophile | 1 | 67641 | 2 | 1.080 | 62630.6 |
162 | 2023-05-06 15:44:39 | videophile | 2 | 108824 | 3 | 2.500 | 43529.6 |
161 | 2023-05-04 12:08:42 | videophile | 3 | 140603 | 11 | 5.060 | 27787.2 |
160 | 2023-04-20 18:06:43 | videophile | 4 | 161450 | 45 | 9.033 | 17873.4 |
159 | 2023-04-16 03:02:21 | videophile | 1 | 67641 | 2 | 0.970 | 69733.0 |
158 | 2023-02-12 20:31:19 | videophile | 2 | 108824 | 3 | 2.796 | 38921.3 |
157 | 2023-02-10 15:04:35 | videophile | 1 | 67641 | 2 | 0.953 | 70976.9 |
156 | 2023-02-09 05:01:53 | videophile | 3 | 140603 | 11 | 5.970 | 23551.6 |
155 | 2023-01-28 11:48:37 | videophile | 1 | 67641 | 2 | 0.983 | 68810.8 |
154 | 2023-01-26 16:22:12 | videophile | 4 | 161450 | 45 | 9.173 | 17600.6 |
153 | 2023-01-04 17:30:30 | videophile | 4 | 161450 | 45 | 9.156 | 17633.2 |
152 | 2022-12-13 18:40:32 | videophile | 4 | 161450 | 45 | 9.076 | 17788.7 |
151 | 2022-12-08 06:08:56 | videophile | 1 | 67641 | 2 | 0.936 | 72266.0 |
150 | 2022-11-25 02:49:37 | videophile | 2 | 108824 | 3 | 2.623 | 41488.4 |
149 | 2022-11-20 20:05:53 | videophile | 3 | 140603 | 11 | 5.093 | 27607.1 |
148 | 2022-11-07 18:24:56 | videophile | 4 | 161450 | 45 | 10.423 | 15489.8 |
147 | 2022-08-12 03:53:08 | videophile | 1 | 67641 | 2 | 1.110 | 60937.8 |
146 | 2022-08-10 21:33:33 | videophile | 1 | 67641 | 2 | 0.986 | 68601.4 |
145 | 2022-06-23 17:05:12 | videophile | 3 | 140603 | 11 | 5.140 | 27354.7 |
144 | 2022-06-11 03:54:33 | videophile | 4 | 161450 | 45 | 9.236 | 17480.5 |
143 | 2022-04-26 11:32:26 | videophile | 2 | 108824 | 3 | 2.860 | 38050.3 |
142 | 2022-03-29 01:20:28 | videophile | 1 | 67641 | 2 | 1.203 | 56226.9 |
141 | 2022-03-26 20:16:36 | videophile | 1 | 67641 | 2 | 1.063 | 63632.2 |
140 | 2022-03-04 10:38:42 | videophile | 1 | 67641 | 2 | 1.406 | 48108.8 |
139 | 2022-02-22 10:03:14 | videophile | 3 | 140603 | 11 | 6.343 | 22166.6 |
138 | 2022-01-14 13:48:22 | videophile | 1 | 67641 | 2 | 1.126 | 60071.9 |
137 | 2021-10-02 12:19:17 | videophile | 1 | 67641 | 2 | 1.063 | 63632.2 |
136 | 2021-06-30 20:11:26 | videophile | 1 | 67641 | 2 | 0.983 | 68810.8 |
135 | 2021-06-16 14:29:44 | videophile | 1 | 67641 | 2 | 0.966 | 70021.7 |
134 | 2021-05-21 07:47:49 | videophile | 1 | 67641 | 2 | 1.013 | 66773.0 |
133 | 2021-04-12 09:08:01 | videophile | 1 | 67641 | 2 | 2.360 | 28661.4 |
132 | 2021-03-13 17:33:42 | videophile | 1 | 67641 | 2 | 0.986 | 68601.4 |
131 | 2021-01-26 08:12:32 | videophile | 1 | 67641 | 2 | 1.030 | 65670.9 |
130 | 2020-12-28 10:03:24 | videophile | 1 | 67641 | 2 | 1.000 | 67641.0 |
129 | 2020-11-28 04:21:28 | videophile | 1 | 67641 | 2 | 0.983 | 68810.8 |
128 | 2020-08-30 08:54:17 | videophile | 1 | 67641 | 2 | 0.983 | 68810.8 |
127 | 2020-07-31 08:10:57 | videophile | 1 | 67641 | 2 | 1.110 | 60937.8 |
126 | 2020-07-11 03:30:54 | videophile | 1 | 67641 | 2 | 1.016 | 66575.8 |
125 | 2020-04-10 07:47:09 | videophile | 1 | 67641 | 2 | 1.033 | 65480.2 |
124 | 2020-03-28 03:30:41 | videophile | 1 | 67641 | 2 | 1.140 | 59334.2 |
123 | 2020-02-25 03:26:12 | videophile | 1 | 67641 | 2 | 1.140 | 59334.2 |
122 | 2020-02-10 05:07:56 | videophile | 1 | 67641 | 2 | 3.860 | 17523.6 |
121 | 2020-02-05 14:28:52 | videophile | 1 | 67641 | 2 | 1.173 | 57665.0 |
120 | 2020-02-05 04:11:00 | videophile | 1 | 67641 | 2 | 2.343 | 28869.4 |
119 | 2020-01-24 01:45:22 | videophile | 1 | 67641 | 2 | 2.483 | 27241.6 |
118 | 2020-01-18 21:34:23 | videophile | 1 | 67641 | 2 | 1.173 | 57665.0 |
117 | 2020-01-04 21:14:40 | videophile | 1 | 67641 | 2 | 1.156 | 58513.0 |
116 | 2019-12-15 00:57:14 | videophile | 1 | 67641 | 2 | 1.140 | 59334.2 |
115 | 2019-09-13 11:36:56 | videophile | 1 | 67641 | 2 | 0.996 | 67912.7 |
114 | 2019-08-28 09:13:14 | videophile | 1 | 67641 | 2 | 0.936 | 72266.0 |
113 | 2019-08-24 09:18:49 | videophile | 1 | 67641 | 2 | 0.946 | 71502.1 |
112 | 2019-08-09 05:11:59 | videophile | 1 | 67641 | 2 | 1.123 | 60232.4 |
111 | 2019-08-04 06:04:01 | videophile | 1 | 67641 | 2 | 0.930 | 72732.3 |
110 | 2019-05-29 08:47:05 | videophile | 1 | 67641 | 2 | 1.093 | 61885.6 |