History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"psychosis"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
202 | 2024-05-12 00:25:07 | psychosis | 4 | 165329 | 133 | 36.250 | 4560.8 |
201 | 2024-05-12 00:25:09 | psychosis | 3 | 148641 | 25 | 20.296 | 7323.7 |
200 | 2024-05-12 00:25:09 | psychosis | 2 | 121436 | 7 | 11.953 | 10159.5 |
199 | 2024-05-11 23:58:06 | psychosis | 1 | 81242 | 2 | 1.593 | 50999.4 |
198 | 2024-05-11 23:57:53 | psychosis | 1 | 81242 | 2 | 4.690 | 17322.4 |
197 | 2024-05-04 17:19:38 | psychosis | 3 | 148641 | 25 | 24.423 | 6086.1 |
196 | 2024-05-04 17:19:40 | psychosis | 2 | 121436 | 7 | 16.266 | 7465.6 |
195 | 2024-05-04 05:08:15 | psychosis | 1 | 81242 | 2 | 2.953 | 27511.7 |
194 | 2024-04-29 23:39:16 | psychosis | 4 | 165329 | 133 | 17.093 | 9672.3 |
193 | 2024-04-29 23:39:07 | psychosis | 2 | 121436 | 7 | 7.640 | 15894.8 |
192 | 2024-04-29 23:39:05 | psychosis | 3 | 148641 | 25 | 7.813 | 19024.8 |
191 | 2024-04-29 23:33:27 | psychosis | 1 | 81242 | 2 | 1.406 | 57782.4 |
190 | 2024-04-27 11:48:04 | psychosis | 4 | 165329 | 133 | 34.876 | 4740.5 |
189 | 2024-04-11 09:33:06 | psychosis | 1 | 81242 | 2 | 1.376 | 59042.2 |
188 | 2024-04-08 19:04:54 | psychosis | 1 | 81242 | 2 | 1.233 | 65889.7 |
187 | 2024-03-31 19:19:42 | psychosis | 1 | 81242 | 2 | 1.420 | 57212.7 |
186 | 2024-03-26 19:45:48 | psychosis | 4 | 165329 | 133 | 27.080 | 6105.2 |
185 | 2024-03-26 19:45:45 | psychosis | 2 | 121436 | 7 | 10.173 | 11937.1 |
184 | 2024-03-26 19:45:46 | psychosis | 3 | 148641 | 25 | 8.376 | 17746.1 |
183 | 2024-03-26 16:49:40 | psychosis | 1 | 81242 | 2 | 1.360 | 59736.8 |
182 | 2024-03-22 12:35:08 | psychosis | 4 | 165329 | 133 | 42.970 | 3847.5 |
181 | 2024-03-22 12:35:09 | psychosis | 3 | 148641 | 25 | 24.910 | 5967.1 |
180 | 2024-03-22 12:35:03 | psychosis | 2 | 121436 | 7 | 12.546 | 9679.3 |
179 | 2024-03-22 10:47:43 | psychosis | 1 | 81242 | 2 | 1.406 | 57782.4 |
178 | 2024-03-19 22:51:27 | psychosis | 1 | 81242 | 2 | 1.360 | 59736.8 |
177 | 2024-03-14 15:04:31 | psychosis | 4 | 165329 | 133 | 18.673 | 8853.9 |
176 | 2024-03-13 15:42:03 | psychosis | 4 | 165329 | 133 | 28.516 | 5797.8 |
175 | 2024-03-12 03:45:17 | psychosis | 4 | 165329 | 133 | 16.813 | 9833.4 |
174 | 2024-03-12 03:45:15 | psychosis | 3 | 148641 | 25 | 12.843 | 11573.7 |
173 | 2024-03-12 03:45:16 | psychosis | 2 | 121436 | 7 | 10.420 | 11654.1 |
172 | 2024-03-12 03:45:13 | psychosis | 1 | 81242 | 2 | 3.190 | 25467.7 |
171 | 2024-03-12 03:45:07 | psychosis | 1 | 81242 | 2 | 2.030 | 40020.7 |
170 | 2024-02-18 05:19:34 | psychosis | 1 | 81242 | 2 | 3.093 | 26266.4 |
169 | 2024-01-31 21:17:08 | psychosis | 1 | 81242 | 2 | 1.423 | 57092.1 |
168 | 2024-01-31 18:32:28 | psychosis | 1 | 81242 | 2 | 1.326 | 61268.5 |
167 | 2024-01-30 12:13:43 | psychosis | 1 | 81242 | 2 | 1.440 | 56418.1 |
166 | 2024-01-29 05:12:16 | psychosis | 1 | 81242 | 2 | 1.360 | 59736.8 |
165 | 2024-01-25 20:33:47 | psychosis | 1 | 81242 | 2 | 1.453 | 55913.3 |
164 | 2023-12-26 17:22:54 | psychosis | 1 | 81242 | 2 | 1.233 | 65889.7 |
163 | 2023-12-20 03:44:04 | psychosis | 1 | 81242 | 2 | 1.470 | 55266.7 |
162 | 2023-12-14 14:58:30 | psychosis | 1 | 81242 | 2 | 1.263 | 64324.6 |
161 | 2023-11-02 23:33:39 | psychosis | 1 | 81242 | 2 | 1.440 | 56418.1 |
160 | 2023-10-15 06:22:06 | psychosis | 1 | 81242 | 2 | 1.533 | 52995.4 |
159 | 2023-09-14 11:42:01 | psychosis | 1 | 81242 | 2 | 1.233 | 65889.7 |
158 | 2023-08-10 09:15:35 | psychosis | 1 | 81242 | 2 | 1.343 | 60492.9 |
157 | 2023-05-11 07:29:24 | psychosis | 1 | 81242 | 2 | 1.373 | 59171.2 |
156 | 2023-05-08 12:33:00 | psychosis | 1 | 81242 | 2 | 1.233 | 65889.7 |
155 | 2023-03-05 11:33:12 | psychosis | 1 | 81242 | 2 | 1.360 | 59736.8 |
154 | 2023-01-10 14:51:36 | psychosis | 1 | 81242 | 2 | 1.390 | 58447.5 |
153 | 2022-12-27 12:04:26 | psychosis | 1 | 81242 | 2 | 1.203 | 67532.8 |
152 | 2022-09-13 06:32:29 | psychosis | 1 | 81242 | 2 | 1.296 | 62686.7 |
151 | 2022-08-29 19:34:38 | psychosis | 1 | 81242 | 2 | 1.216 | 66810.9 |
150 | 2022-07-19 18:36:35 | psychosis | 1 | 81242 | 2 | 1.216 | 66810.9 |
149 | 2022-04-08 08:27:17 | psychosis | 1 | 81242 | 2 | 1.750 | 46424.0 |
148 | 2022-04-04 21:56:06 | psychosis | 1 | 81242 | 2 | 1.593 | 50999.4 |
147 | 2022-03-17 04:16:35 | psychosis | 1 | 81242 | 2 | 1.466 | 55417.5 |
146 | 2022-03-15 01:30:05 | psychosis | 1 | 81242 | 2 | 1.690 | 48072.2 |
145 | 2022-01-07 01:39:34 | psychosis | 1 | 81242 | 2 | 1.486 | 54671.6 |
144 | 2021-12-08 05:38:54 | psychosis | 1 | 81242 | 2 | 1.390 | 58447.5 |
143 | 2021-08-18 12:22:44 | psychosis | 1 | 81242 | 2 | 1.236 | 65729.8 |
142 | 2021-05-07 16:11:01 | psychosis | 1 | 81242 | 2 | 1.436 | 56575.2 |
141 | 2021-02-13 02:17:07 | psychosis | 1 | 81242 | 2 | 1.250 | 64993.6 |
140 | 2021-01-20 04:41:28 | psychosis | 1 | 81242 | 2 | 1.233 | 65889.7 |
139 | 2021-01-14 22:39:56 | psychosis | 1 | 81242 | 2 | 1.453 | 55913.3 |
138 | 2020-10-13 17:20:12 | psychosis | 1 | 81242 | 2 | 1.763 | 46081.7 |
137 | 2020-10-05 14:03:06 | psychosis | 1 | 81242 | 2 | 1.233 | 65889.7 |
136 | 2020-09-30 10:43:50 | psychosis | 1 | 81242 | 2 | 1.216 | 66810.9 |
135 | 2020-08-02 01:20:17 | psychosis | 1 | 81242 | 2 | 1.376 | 59042.2 |
134 | 2020-06-11 10:19:24 | psychosis | 1 | 81242 | 2 | 1.266 | 64172.2 |
133 | 2020-03-21 16:08:26 | psychosis | 1 | 81242 | 2 | 1.326 | 61268.5 |
132 | 2020-03-09 20:08:36 | psychosis | 1 | 81242 | 2 | 1.233 | 65889.7 |
131 | 2020-02-25 19:49:48 | psychosis | 1 | 81242 | 2 | 1.423 | 57092.1 |
130 | 2020-02-24 20:05:53 | psychosis | 1 | 81242 | 2 | 1.343 | 60492.9 |
129 | 2020-02-23 16:52:38 | psychosis | 1 | 81242 | 2 | 1.593 | 50999.4 |
128 | 2020-02-20 00:33:02 | psychosis | 1 | 81242 | 2 | 1.343 | 60492.9 |
127 | 2020-02-04 19:03:31 | psychosis | 1 | 81242 | 2 | 3.063 | 26523.7 |
126 | 2020-02-04 16:06:40 | psychosis | 1 | 81242 | 2 | 3.813 | 21306.6 |
125 | 2020-01-29 09:18:51 | psychosis | 1 | 81242 | 2 | 3.093 | 26266.4 |
124 | 2020-01-24 13:08:37 | psychosis | 1 | 81242 | 2 | 1.403 | 57905.9 |
123 | 2020-01-22 06:14:00 | psychosis | 1 | 81242 | 2 | 1.670 | 48647.9 |
122 | 2020-01-16 19:59:24 | psychosis | 4 | 165329 | 133 | 27.643 | 5980.9 |
121 | 2020-01-16 14:30:27 | psychosis | 4 | 165329 | 133 | 12.720 | 12997.6 |
120 | 2020-01-16 08:56:52 | psychosis | 2 | 121436 | 7 | 3.530 | 34401.1 |
119 | 2020-01-16 08:56:39 | psychosis | 4 | 165329 | 133 | 11.966 | 13816.6 |
118 | 2020-01-16 08:55:50 | psychosis | 3 | 148641 | 25 | 7.953 | 18689.9 |
117 | 2020-01-16 04:04:34 | psychosis | 1 | 81242 | 2 | 3.403 | 23873.6 |
116 | 2020-01-12 05:57:53 | psychosis | 1 | 81242 | 2 | 1.500 | 54161.3 |
115 | 2019-12-31 00:00:51 | psychosis | 1 | 81242 | 2 | 2.580 | 31489.1 |
114 | 2019-12-30 03:54:55 | psychosis | 1 | 81242 | 2 | 1.466 | 55417.5 |
113 | 2019-12-06 20:47:56 | psychosis | 1 | 81242 | 2 | 1.220 | 66591.8 |
112 | 2019-09-04 19:10:55 | psychosis | 1 | 81242 | 2 | 1.240 | 65517.7 |
111 | 2019-06-02 01:01:10 | psychosis | 1 | 81242 | 2 | 1.253 | 64838.0 |
110 | 2019-05-29 22:44:00 | psychosis | 1 | 81242 | 2 | 1.280 | 63470.3 |
109 | 2019-05-26 20:23:50 | psychosis | 1 | 81242 | 2 | 1.406 | 57782.4 |
108 | 2019-04-03 21:08:18 | psychosis | 1 | 81242 | 2 | 1.293 | 62832.2 |
107 | 2019-02-09 15:03:12 | psychosis | 1 | 81242 | 2 | 1.196 | 67928.1 |
106 | 2019-02-08 01:55:32 | psychosis | 1 | 81242 | 2 | 1.540 | 52754.5 |
105 | 2018-12-30 06:21:58 | psychosis | 1 | 81242 | 2 | 1.186 | 68500.8 |
104 | 2018-10-17 02:27:18 | psychosis | 1 | 81242 | 2 | 1.310 | 62016.8 |
103 | 2018-07-15 16:21:46 | psychosis | 1 | 81242 | 2 | 2.716 | 29912.4 |