History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"confessor"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
199 | 2024-04-20 05:45:28 | confessor | 3 | 148641 | 36 | 20.876 | 7120.2 |
198 | 2024-04-19 16:38:30 | confessor | 3 | 148641 | 36 | 28.613 | 5194.9 |
197 | 2024-04-19 16:38:42 | confessor | 2 | 121436 | 7 | 9.766 | 12434.6 |
196 | 2024-04-19 15:25:54 | confessor | 1 | 81242 | 2 | 1.376 | 59042.2 |
195 | 2024-04-17 19:11:37 | confessor | 2 | 121436 | 7 | 11.626 | 10445.2 |
194 | 2024-04-17 18:52:34 | confessor | 1 | 81242 | 2 | 4.580 | 17738.4 |
193 | 2024-04-14 19:10:43 | confessor | 4 | 165329 | 222 | 51.753 | 3194.6 |
192 | 2024-04-10 06:10:03 | confessor | 1 | 81242 | 2 | 1.546 | 52549.8 |
191 | 2024-04-01 18:59:10 | confessor | 4 | 165329 | 222 | 34.736 | 4759.6 |
190 | 2024-04-01 08:00:20 | confessor | 4 | 165329 | 222 | 25.390 | 6511.6 |
189 | 2024-04-01 08:00:21 | confessor | 3 | 148641 | 36 | 10.063 | 14771.0 |
188 | 2024-04-01 08:00:21 | confessor | 2 | 121436 | 7 | 4.373 | 27769.5 |
187 | 2024-04-01 07:59:41 | confessor | 1 | 81242 | 2 | 2.530 | 32111.5 |
186 | 2024-03-20 04:18:54 | confessor | 3 | 148641 | 36 | 25.033 | 5937.8 |
185 | 2024-03-19 14:10:12 | confessor | 1 | 81242 | 2 | 3.156 | 25742.1 |
184 | 2024-03-19 14:09:57 | confessor | 2 | 121436 | 7 | 8.733 | 13905.4 |
183 | 2024-03-19 14:09:52 | confessor | 1 | 81242 | 2 | 2.923 | 27794.0 |
182 | 2024-03-18 09:53:07 | confessor | 1 | 81242 | 2 | 2.906 | 27956.6 |
181 | 2024-03-17 17:57:44 | confessor | 3 | 148641 | 36 | 22.643 | 6564.5 |
180 | 2024-03-14 13:58:17 | confessor | 2 | 121436 | 7 | 3.486 | 34835.3 |
179 | 2024-03-12 09:05:36 | confessor | 3 | 148641 | 36 | 16.376 | 9076.8 |
178 | 2024-03-12 09:05:33 | confessor | 2 | 121436 | 7 | 9.360 | 12973.9 |
177 | 2024-03-12 07:41:31 | confessor | 1 | 81242 | 2 | 1.610 | 50460.9 |
176 | 2024-03-11 19:35:09 | confessor | 4 | 165329 | 222 | 36.110 | 4578.5 |
175 | 2024-03-04 19:51:40 | confessor | 4 | 165329 | 222 | 47.393 | 3488.5 |
174 | 2024-03-04 19:51:46 | confessor | 3 | 148641 | 36 | 9.766 | 15220.3 |
173 | 2024-03-03 18:27:18 | confessor | 2 | 121436 | 7 | 4.326 | 28071.2 |
172 | 2024-03-03 18:27:11 | confessor | 1 | 81242 | 2 | 1.343 | 60492.9 |
171 | 2024-03-02 05:52:14 | confessor | 3 | 148641 | 36 | 28.003 | 5308.0 |
170 | 2024-03-02 05:51:53 | confessor | 4 | 165329 | 222 | 25.016 | 6608.9 |
169 | 2024-03-02 05:51:51 | confessor | 2 | 121436 | 7 | 4.296 | 28267.2 |
168 | 2024-03-02 05:51:43 | confessor | 1 | 81242 | 2 | 4.610 | 17623.0 |
167 | 2024-02-25 18:34:21 | confessor | 3 | 148641 | 36 | 7.216 | 20598.8 |
166 | 2024-02-18 01:01:35 | confessor | 3 | 148641 | 36 | 15.643 | 9502.1 |
165 | 2024-02-18 01:01:33 | confessor | 3 | 148641 | 36 | 12.893 | 11528.8 |
164 | 2024-02-10 18:03:46 | confessor | 3 | 148641 | 36 | 30.813 | 4824.0 |
163 | 2024-02-10 18:03:46 | confessor | 4 | 165329 | 222 | 24.126 | 6852.7 |
162 | 2024-02-10 18:03:43 | confessor | 2 | 121436 | 7 | 11.483 | 10575.3 |
161 | 2024-02-06 22:01:54 | confessor | 1 | 81242 | 2 | 1.453 | 55913.3 |
160 | 2024-01-31 04:33:51 | confessor | 1 | 81242 | 2 | 1.483 | 54782.2 |
159 | 2024-01-30 18:04:39 | confessor | 1 | 81242 | 2 | 2.813 | 28880.9 |
158 | 2024-01-30 18:04:35 | confessor | 1 | 81242 | 2 | 1.420 | 57212.7 |
157 | 2024-01-20 22:09:24 | confessor | 1 | 81242 | 2 | 1.293 | 62832.2 |
156 | 2023-11-29 23:17:54 | confessor | 2 | 121436 | 7 | 3.233 | 37561.4 |
155 | 2023-11-22 22:44:52 | confessor | 3 | 148641 | 36 | 6.093 | 24395.4 |
154 | 2023-11-17 14:00:33 | confessor | 1 | 81242 | 2 | 1.266 | 64172.2 |
153 | 2023-10-31 02:49:52 | confessor | 1 | 81242 | 2 | 1.440 | 56418.1 |
152 | 2023-10-07 11:02:06 | confessor | 1 | 81242 | 2 | 1.390 | 58447.5 |
151 | 2023-09-04 07:02:54 | confessor | 1 | 81242 | 2 | 1.280 | 63470.3 |
150 | 2023-08-28 08:53:24 | confessor | 2 | 121436 | 7 | 3.173 | 38271.7 |
149 | 2023-08-24 04:49:29 | confessor | 3 | 148641 | 36 | 6.173 | 24079.2 |
148 | 2023-05-25 07:12:44 | confessor | 1 | 81242 | 2 | 1.250 | 64993.6 |
147 | 2023-05-21 22:55:20 | confessor | 1 | 81242 | 2 | 1.266 | 64172.2 |
146 | 2023-05-15 16:19:49 | confessor | 2 | 121436 | 7 | 3.326 | 36511.1 |
145 | 2023-05-11 08:08:14 | confessor | 3 | 148641 | 36 | 6.156 | 24145.7 |
144 | 2023-02-23 19:57:01 | confessor | 2 | 121436 | 7 | 3.516 | 34538.1 |
143 | 2023-02-16 13:18:11 | confessor | 3 | 148641 | 36 | 6.000 | 24773.5 |
142 | 2023-01-18 06:27:34 | confessor | 1 | 81242 | 2 | 1.423 | 57092.1 |
141 | 2023-01-11 17:42:11 | confessor | 1 | 81242 | 2 | 1.436 | 56575.2 |
140 | 2022-12-04 00:22:29 | confessor | 2 | 121436 | 7 | 3.110 | 39046.9 |
139 | 2022-11-26 15:29:03 | confessor | 3 | 148641 | 36 | 6.106 | 24343.4 |
138 | 2022-10-30 10:34:19 | confessor | 1 | 81242 | 2 | 1.373 | 59171.2 |
137 | 2022-09-08 23:12:49 | confessor | 1 | 81242 | 2 | 1.233 | 65889.7 |
136 | 2022-06-19 20:42:39 | confessor | 1 | 81242 | 2 | 1.266 | 64172.2 |
135 | 2022-04-18 23:29:57 | confessor | 1 | 81242 | 2 | 1.250 | 64993.6 |
134 | 2022-04-18 13:25:51 | confessor | 3 | 148641 | 36 | 6.983 | 21286.1 |
133 | 2022-04-08 08:04:26 | confessor | 2 | 121436 | 7 | 3.673 | 33061.8 |
132 | 2022-02-25 03:33:14 | confessor | 1 | 81242 | 2 | 1.610 | 50460.9 |
131 | 2022-02-22 23:20:18 | confessor | 1 | 81242 | 2 | 1.360 | 59736.8 |
130 | 2022-01-09 23:21:21 | confessor | 3 | 148641 | 36 | 6.440 | 23080.9 |
129 | 2022-01-03 12:00:23 | confessor | 2 | 121436 | 7 | 3.733 | 32530.4 |
128 | 2021-12-28 22:41:58 | confessor | 1 | 81242 | 2 | 1.436 | 56575.2 |
127 | 2021-12-14 19:56:22 | confessor | 1 | 81242 | 2 | 1.516 | 53589.7 |
126 | 2021-11-28 23:16:46 | confessor | 1 | 81242 | 2 | 1.500 | 54161.3 |
125 | 2021-08-18 16:30:08 | confessor | 1 | 81242 | 2 | 1.346 | 60358.1 |
124 | 2021-04-30 23:14:16 | confessor | 1 | 81242 | 2 | 1.453 | 55913.3 |
123 | 2021-01-28 06:08:35 | confessor | 1 | 81242 | 2 | 1.486 | 54671.6 |
122 | 2021-01-06 11:59:55 | confessor | 1 | 81242 | 2 | 1.266 | 64172.2 |
121 | 2020-11-29 20:45:04 | confessor | 1 | 81242 | 2 | 1.330 | 61084.2 |
120 | 2020-10-17 22:11:53 | confessor | 1 | 81242 | 2 | 1.283 | 63321.9 |
119 | 2020-09-26 10:05:11 | confessor | 1 | 81242 | 2 | 1.283 | 63321.9 |
118 | 2020-06-08 14:11:50 | confessor | 1 | 81242 | 2 | 1.500 | 54161.3 |
117 | 2020-03-23 21:35:06 | confessor | 1 | 81242 | 2 | 2.436 | 33350.6 |
116 | 2020-03-05 19:55:33 | confessor | 1 | 81242 | 2 | 1.576 | 51549.5 |
115 | 2020-02-27 07:35:04 | confessor | 1 | 81242 | 2 | 1.390 | 58447.5 |
114 | 2020-02-17 11:53:50 | confessor | 1 | 81242 | 2 | 3.266 | 24875.1 |
113 | 2020-02-07 18:27:20 | confessor | 1 | 81242 | 2 | 1.840 | 44153.3 |
112 | 2020-01-31 17:47:51 | confessor | 1 | 81242 | 2 | 5.000 | 16248.4 |
111 | 2020-01-31 14:36:59 | confessor | 1 | 81242 | 2 | 3.220 | 25230.4 |
110 | 2020-01-30 19:09:41 | confessor | 1 | 81242 | 2 | 1.516 | 53589.7 |
109 | 2020-01-29 02:45:34 | confessor | 1 | 81242 | 2 | 1.640 | 49537.8 |
108 | 2020-01-18 18:53:04 | confessor | 1 | 81242 | 2 | 1.656 | 49059.2 |
107 | 2020-01-07 15:11:49 | confessor | 1 | 81242 | 2 | 2.000 | 40621.0 |
106 | 2020-01-06 17:59:13 | confessor | 1 | 81242 | 2 | 1.843 | 44081.4 |
105 | 2019-11-25 09:32:29 | confessor | 1 | 81242 | 2 | 1.390 | 58447.5 |
104 | 2019-08-26 16:00:54 | confessor | 1 | 81242 | 2 | 1.210 | 67142.1 |
103 | 2019-05-20 18:04:38 | confessor | 1 | 81242 | 2 | 1.300 | 62493.8 |
102 | 2019-01-29 18:05:22 | confessor | 1 | 81242 | 2 | 1.273 | 63819.3 |
101 | 2019-01-14 22:14:46 | confessor | 1 | 81242 | 2 | 1.273 | 63819.3 |
100 | 2018-12-15 14:13:53 | confessor | 1 | 81242 | 2 | 1.230 | 66050.4 |