History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"troubled"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
200 | 2024-03-23 12:44:55 | troubled | 1 | 82945 | 4 | 1.546 | 53651.4 |
199 | 2024-02-27 22:20:59 | troubled | 2 | 121059 | 17 | 4.110 | 29454.7 |
198 | 2024-02-27 22:20:45 | troubled | 3 | 146162 | 176 | 7.563 | 19325.9 |
197 | 2024-02-27 20:52:03 | troubled | 3 | 146162 | 176 | 6.940 | 21060.8 |
196 | 2024-02-27 20:52:01 | troubled | 1 | 82945 | 4 | 1.313 | 63172.1 |
195 | 2024-02-22 12:52:57 | troubled | 2 | 121059 | 17 | 8.640 | 14011.5 |
194 | 2024-02-19 05:30:44 | troubled | 2 | 121059 | 17 | 3.860 | 31362.4 |
193 | 2024-01-29 18:46:43 | troubled | 1 | 82945 | 4 | 1.373 | 60411.5 |
192 | 2024-01-29 10:44:21 | troubled | 1 | 82945 | 4 | 1.533 | 54106.3 |
191 | 2024-01-27 06:28:57 | troubled | 3 | 146162 | 176 | 7.140 | 20470.9 |
190 | 2024-01-26 07:27:59 | troubled | 1 | 82945 | 4 | 3.170 | 26165.6 |
189 | 2024-01-22 18:35:23 | troubled | 3 | 146162 | 176 | 13.003 | 11240.6 |
188 | 2024-01-15 13:08:21 | troubled | 3 | 146162 | 176 | 6.923 | 21112.5 |
187 | 2024-01-15 13:08:24 | troubled | 2 | 121059 | 17 | 3.640 | 33258.0 |
186 | 2024-01-11 09:42:21 | troubled | 2 | 121059 | 17 | 3.626 | 33386.4 |
185 | 2023-12-23 07:33:48 | troubled | 3 | 146162 | 176 | 6.233 | 23449.7 |
184 | 2023-12-18 12:04:09 | troubled | 1 | 82945 | 4 | 1.263 | 65673.0 |
183 | 2023-11-23 15:46:20 | troubled | 1 | 82945 | 4 | 1.470 | 56425.2 |
182 | 2023-11-19 21:15:13 | troubled | 1 | 82945 | 4 | 1.423 | 58288.8 |
181 | 2023-11-16 10:42:16 | troubled | 1 | 82945 | 4 | 1.406 | 58993.6 |
180 | 2023-11-15 21:56:59 | troubled | 2 | 121059 | 17 | 3.263 | 37100.5 |
179 | 2023-10-31 23:30:45 | troubled | 1 | 82945 | 4 | 1.453 | 57085.3 |
178 | 2023-10-23 03:24:52 | troubled | 1 | 82945 | 4 | 1.406 | 58993.6 |
177 | 2023-10-07 03:11:05 | troubled | 3 | 146162 | 176 | 14.500 | 10080.1 |
176 | 2023-10-06 12:10:35 | troubled | 1 | 82945 | 4 | 3.220 | 25759.3 |
175 | 2023-09-29 12:12:54 | troubled | 3 | 146162 | 176 | 8.580 | 17035.2 |
174 | 2023-09-24 19:36:31 | troubled | 3 | 146162 | 176 | 6.983 | 20931.1 |
173 | 2023-09-14 03:32:57 | troubled | 1 | 82945 | 4 | 1.376 | 60279.8 |
172 | 2023-09-01 15:18:13 | troubled | 1 | 82945 | 4 | 1.390 | 59672.7 |
171 | 2023-08-17 12:18:34 | troubled | 2 | 121059 | 17 | 3.186 | 37997.2 |
170 | 2023-08-02 01:24:35 | troubled | 1 | 82945 | 4 | 1.483 | 55930.5 |
169 | 2023-07-04 08:15:16 | troubled | 3 | 146162 | 176 | 7.190 | 20328.5 |
168 | 2023-05-01 23:36:04 | troubled | 2 | 121059 | 17 | 3.186 | 37997.2 |
167 | 2023-04-29 23:30:51 | troubled | 1 | 82945 | 4 | 1.330 | 62364.7 |
166 | 2023-04-12 19:43:31 | troubled | 1 | 82945 | 4 | 1.263 | 65673.0 |
165 | 2023-03-27 21:24:12 | troubled | 3 | 146162 | 176 | 7.626 | 19166.3 |
164 | 2023-02-19 05:19:46 | troubled | 1 | 82945 | 4 | 1.250 | 66356.0 |
163 | 2023-02-07 00:29:55 | troubled | 2 | 121059 | 17 | 3.110 | 38925.7 |
162 | 2022-12-26 00:04:02 | troubled | 3 | 146162 | 176 | 6.110 | 23921.8 |
161 | 2022-12-17 18:03:43 | troubled | 1 | 82945 | 4 | 1.236 | 67107.6 |
160 | 2022-12-03 21:04:29 | troubled | 1 | 82945 | 4 | 1.220 | 67987.7 |
159 | 2022-11-19 00:20:00 | troubled | 2 | 121059 | 17 | 6.703 | 18060.4 |
158 | 2022-08-28 18:26:46 | troubled | 1 | 82945 | 4 | 1.250 | 66356.0 |
157 | 2022-08-26 14:32:01 | troubled | 3 | 146162 | 176 | 6.376 | 22923.8 |
156 | 2022-07-03 04:06:56 | troubled | 1 | 82945 | 4 | 1.263 | 65673.0 |
155 | 2022-06-26 11:04:56 | troubled | 1 | 82945 | 4 | 1.563 | 53067.8 |
154 | 2022-06-23 08:39:18 | troubled | 2 | 121059 | 17 | 3.580 | 33815.4 |
153 | 2022-04-13 10:36:53 | troubled | 1 | 82945 | 4 | 1.280 | 64800.8 |
152 | 2022-02-06 07:19:57 | troubled | 1 | 82945 | 4 | 1.406 | 58993.6 |
151 | 2022-01-24 06:18:33 | troubled | 1 | 82945 | 4 | 1.283 | 64649.3 |
150 | 2021-09-27 07:57:42 | troubled | 1 | 82945 | 4 | 1.423 | 58288.8 |
149 | 2021-09-20 11:34:52 | troubled | 1 | 82945 | 4 | 1.486 | 55817.6 |
148 | 2021-06-17 23:15:52 | troubled | 1 | 82945 | 4 | 1.420 | 58412.0 |
147 | 2021-06-03 07:27:37 | troubled | 1 | 82945 | 4 | 1.280 | 64800.8 |
146 | 2021-04-07 13:47:49 | troubled | 1 | 82945 | 4 | 1.313 | 63172.1 |
145 | 2021-03-15 03:04:16 | troubled | 1 | 82945 | 4 | 2.906 | 28542.7 |
144 | 2021-03-11 19:51:40 | troubled | 1 | 82945 | 4 | 1.266 | 65517.4 |
143 | 2021-02-15 08:40:11 | troubled | 1 | 82945 | 4 | 1.390 | 59672.7 |
142 | 2020-12-12 02:27:04 | troubled | 1 | 82945 | 4 | 1.296 | 64000.8 |
141 | 2020-11-07 21:31:25 | troubled | 1 | 82945 | 4 | 1.393 | 59544.1 |
140 | 2020-11-03 22:03:56 | troubled | 1 | 82945 | 4 | 1.576 | 52630.1 |
139 | 2020-08-29 16:12:00 | troubled | 1 | 82945 | 4 | 1.310 | 63316.8 |
138 | 2020-08-21 19:57:44 | troubled | 1 | 82945 | 4 | 1.420 | 58412.0 |
137 | 2020-06-12 18:22:24 | troubled | 1 | 82945 | 4 | 1.326 | 62552.8 |
136 | 2020-05-06 15:30:07 | troubled | 1 | 82945 | 4 | 1.546 | 53651.4 |
135 | 2020-03-22 22:58:30 | troubled | 1 | 82945 | 4 | 1.343 | 61761.0 |
134 | 2020-03-17 17:47:30 | troubled | 1 | 82945 | 4 | 1.296 | 64000.8 |
133 | 2020-02-28 02:47:05 | troubled | 3 | 146162 | 176 | 13.876 | 10533.4 |
132 | 2020-02-22 22:36:27 | troubled | 1 | 82945 | 4 | 1.453 | 57085.3 |
131 | 2020-02-22 20:43:23 | troubled | 1 | 82945 | 4 | 3.783 | 21925.7 |
130 | 2020-02-21 01:11:30 | troubled | 1 | 82945 | 4 | 1.623 | 51106.0 |
129 | 2020-02-19 10:49:03 | troubled | 3 | 146162 | 176 | 8.156 | 17920.8 |
128 | 2020-02-18 18:45:37 | troubled | 3 | 146162 | 176 | 8.800 | 16609.3 |
127 | 2020-02-18 03:40:57 | troubled | 3 | 146162 | 176 | 24.220 | 6034.8 |
126 | 2020-02-17 19:06:26 | troubled | 1 | 82945 | 4 | 3.170 | 26165.6 |
125 | 2020-02-11 09:11:47 | troubled | 1 | 82945 | 4 | 1.640 | 50576.2 |
124 | 2020-02-03 22:48:39 | troubled | 1 | 82945 | 4 | 1.516 | 54713.1 |
123 | 2020-02-03 19:28:04 | troubled | 1 | 82945 | 4 | 1.483 | 55930.5 |
122 | 2020-01-26 07:31:21 | troubled | 1 | 82945 | 4 | 1.640 | 50576.2 |
121 | 2020-01-24 04:20:49 | troubled | 1 | 82945 | 4 | 1.486 | 55817.6 |
120 | 2020-01-24 01:49:05 | troubled | 1 | 82945 | 4 | 1.593 | 52068.4 |
119 | 2020-01-18 17:24:12 | troubled | 3 | 146162 | 176 | 9.156 | 15963.5 |
118 | 2020-01-17 16:08:54 | troubled | 3 | 146162 | 176 | 16.843 | 8677.9 |
117 | 2020-01-17 16:09:05 | troubled | 2 | 121059 | 17 | 4.186 | 28920.0 |
116 | 2020-01-17 12:50:03 | troubled | 1 | 82945 | 4 | 1.656 | 50087.6 |
115 | 2020-01-17 11:20:36 | troubled | 1 | 82945 | 4 | 1.596 | 51970.6 |
114 | 2020-01-16 02:43:02 | troubled | 1 | 82945 | 4 | 5.030 | 16490.1 |
113 | 2020-01-12 13:22:41 | troubled | 1 | 82945 | 4 | 4.983 | 16645.6 |
112 | 2019-12-31 05:27:05 | troubled | 1 | 82945 | 4 | 1.530 | 54212.4 |
111 | 2019-12-24 08:23:40 | troubled | 1 | 82945 | 4 | 1.423 | 58288.8 |
110 | 2019-10-24 20:26:25 | troubled | 1 | 82945 | 4 | 1.310 | 63316.8 |
109 | 2019-09-07 23:35:03 | troubled | 1 | 82945 | 4 | 1.273 | 65157.1 |
108 | 2019-09-06 23:08:13 | troubled | 1 | 82945 | 4 | 1.190 | 69701.7 |
107 | 2019-09-02 08:55:27 | troubled | 1 | 82945 | 4 | 1.386 | 59844.9 |
106 | 2019-08-26 06:50:17 | troubled | 1 | 82945 | 4 | 1.240 | 66891.1 |
105 | 2019-08-24 02:51:54 | troubled | 1 | 82945 | 4 | 1.220 | 67987.7 |
104 | 2019-08-22 01:08:54 | troubled | 1 | 82945 | 4 | 1.283 | 64649.3 |
103 | 2019-08-20 01:01:54 | troubled | 1 | 82945 | 4 | 1.180 | 70292.4 |
102 | 2019-08-18 01:05:08 | troubled | 1 | 82945 | 4 | 1.193 | 69526.4 |
101 | 2019-08-17 08:20:55 | troubled | 1 | 82945 | 4 | 1.313 | 63172.1 |