History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pneumonias"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
205 | 2024-05-12 17:51:25 | pneumonias | 5 | 173545 | 485 | 65.596 | 2645.7 |
204 | 2024-05-12 17:50:48 | pneumonias | 3 | 140603 | 7 | 23.550 | 5970.4 |
203 | 2024-05-12 17:49:46 | pneumonias | 5 | 173545 | 485 | 51.846 | 3347.3 |
202 | 2024-05-12 17:49:53 | pneumonias | 4 | 161450 | 60 | 23.033 | 7009.5 |
201 | 2024-05-12 17:49:47 | pneumonias | 2 | 108824 | 4 | 7.000 | 15546.3 |
200 | 2024-05-12 17:49:12 | pneumonias | 1 | 67641 | 2 | 1.233 | 54858.9 |
199 | 2024-05-12 17:48:54 | pneumonias | 1 | 67641 | 2 | 1.203 | 56226.9 |
198 | 2024-05-03 23:12:24 | pneumonias | 1 | 67641 | 2 | 1.200 | 56367.5 |
197 | 2024-05-02 04:36:59 | pneumonias | 3 | 140603 | 7 | 6.906 | 20359.5 |
196 | 2024-04-30 11:45:17 | pneumonias | 1 | 67641 | 2 | 1.140 | 59334.2 |
195 | 2024-04-17 07:58:23 | pneumonias | 4 | 161450 | 60 | 18.453 | 8749.3 |
194 | 2024-04-15 12:31:36 | pneumonias | 3 | 140603 | 7 | 13.953 | 10076.9 |
193 | 2024-04-15 12:31:04 | pneumonias | 1 | 67641 | 2 | 5.830 | 11602.2 |
192 | 2024-04-15 12:30:46 | pneumonias | 2 | 108824 | 4 | 7.890 | 13792.6 |
191 | 2024-04-15 10:58:29 | pneumonias | 4 | 161450 | 60 | 42.616 | 3788.5 |
190 | 2024-04-15 05:03:09 | pneumonias | 4 | 161450 | 60 | 33.910 | 4761.1 |
189 | 2024-04-15 05:03:14 | pneumonias | 3 | 140603 | 7 | 27.830 | 5052.2 |
188 | 2024-04-15 05:03:22 | pneumonias | 2 | 108824 | 4 | 16.346 | 6657.5 |
187 | 2024-04-15 05:03:11 | pneumonias | 4 | 161450 | 60 | 21.096 | 7653.1 |
186 | 2024-04-15 05:01:14 | pneumonias | 1 | 67641 | 2 | 3.173 | 21317.7 |
185 | 2024-04-11 04:28:21 | pneumonias | 1 | 67641 | 2 | 1.000 | 67641.0 |
184 | 2024-04-10 05:33:34 | pneumonias | 1 | 67641 | 2 | 1.250 | 54112.8 |
183 | 2024-04-08 03:10:23 | pneumonias | 1 | 67641 | 2 | 1.156 | 58513.0 |
182 | 2024-03-12 04:03:55 | pneumonias | 1 | 67641 | 2 | 3.906 | 17317.2 |
181 | 2024-03-07 13:15:58 | pneumonias | 1 | 67641 | 2 | 1.016 | 66575.8 |
180 | 2024-03-06 06:11:06 | pneumonias | 1 | 67641 | 2 | 1.780 | 38000.6 |
179 | 2024-03-06 06:09:49 | pneumonias | 4 | 161450 | 60 | 39.003 | 4139.4 |
178 | 2024-03-06 06:09:44 | pneumonias | 2 | 108824 | 4 | 11.186 | 9728.6 |
177 | 2024-02-29 12:26:30 | pneumonias | 1 | 67641 | 2 | 1.123 | 60232.4 |
176 | 2024-02-28 12:01:25 | pneumonias | 1 | 67641 | 2 | 1.203 | 56226.9 |
175 | 2024-02-27 02:11:14 | pneumonias | 5 | 173545 | 485 | 34.940 | 4966.9 |
174 | 2024-02-27 02:11:13 | pneumonias | 4 | 161450 | 60 | 30.846 | 5234.1 |
173 | 2024-02-27 02:11:14 | pneumonias | 3 | 140603 | 7 | 11.483 | 12244.4 |
172 | 2024-02-27 02:11:14 | pneumonias | 2 | 108824 | 4 | 3.640 | 29896.7 |
171 | 2024-02-26 23:11:57 | pneumonias | 1 | 67641 | 2 | 1.500 | 45094.0 |
170 | 2024-02-21 15:27:55 | pneumonias | 1 | 67641 | 2 | 1.283 | 52721.0 |
169 | 2024-02-06 02:20:59 | pneumonias | 1 | 67641 | 2 | 2.360 | 28661.4 |
168 | 2024-02-02 06:38:06 | pneumonias | 1 | 67641 | 2 | 1.123 | 60232.4 |
167 | 2024-01-30 10:20:11 | pneumonias | 1 | 67641 | 2 | 1.153 | 58665.2 |
166 | 2023-12-31 19:57:26 | pneumonias | 2 | 108824 | 4 | 2.656 | 40972.9 |
165 | 2023-12-24 11:04:31 | pneumonias | 3 | 140603 | 7 | 11.750 | 11966.2 |
164 | 2023-12-20 16:51:03 | pneumonias | 1 | 67641 | 2 | 1.016 | 66575.8 |
163 | 2023-12-15 08:21:38 | pneumonias | 4 | 161450 | 60 | 10.626 | 15193.9 |
162 | 2023-12-14 08:45:24 | pneumonias | 1 | 67641 | 2 | 1.126 | 60071.9 |
161 | 2023-10-06 05:28:10 | pneumonias | 2 | 108824 | 4 | 3.186 | 34156.9 |
160 | 2023-10-01 05:42:56 | pneumonias | 1 | 67641 | 2 | 1.000 | 67641.0 |
159 | 2023-09-26 02:35:37 | pneumonias | 3 | 140603 | 7 | 5.910 | 23790.7 |
158 | 2023-09-15 13:25:31 | pneumonias | 4 | 161450 | 60 | 9.576 | 16859.9 |
157 | 2023-08-15 05:55:31 | pneumonias | 1 | 67641 | 2 | 1.046 | 64666.3 |
156 | 2023-07-29 13:21:45 | pneumonias | 1 | 67641 | 2 | 1.033 | 65480.2 |
155 | 2023-07-17 09:18:04 | pneumonias | 2 | 108824 | 4 | 2.656 | 40972.9 |
154 | 2023-07-06 07:46:09 | pneumonias | 3 | 140603 | 7 | 5.483 | 25643.4 |
153 | 2023-06-22 09:41:59 | pneumonias | 4 | 161450 | 60 | 9.876 | 16347.7 |
152 | 2023-04-26 01:52:49 | pneumonias | 1 | 67641 | 2 | 1.126 | 60071.9 |
151 | 2023-04-03 03:37:22 | pneumonias | 2 | 108824 | 4 | 2.810 | 38727.4 |
150 | 2023-03-24 09:07:01 | pneumonias | 3 | 140603 | 7 | 5.653 | 24872.3 |
149 | 2023-03-20 15:05:35 | pneumonias | 4 | 161450 | 60 | 10.346 | 15605.1 |
148 | 2023-03-18 05:49:29 | pneumonias | 1 | 67641 | 2 | 1.546 | 43752.3 |
147 | 2022-12-31 09:19:32 | pneumonias | 2 | 108824 | 4 | 2.623 | 41488.4 |
146 | 2022-12-23 04:38:39 | pneumonias | 3 | 140603 | 7 | 6.673 | 21070.4 |
145 | 2022-12-21 01:55:57 | pneumonias | 4 | 161450 | 60 | 9.330 | 17304.4 |
144 | 2022-10-22 12:26:45 | pneumonias | 1 | 67641 | 2 | 0.986 | 68601.4 |
143 | 2022-09-30 17:04:39 | pneumonias | 1 | 67641 | 2 | 0.983 | 68810.8 |
142 | 2022-09-02 04:10:30 | pneumonias | 2 | 108824 | 4 | 2.906 | 37448.0 |
141 | 2022-08-22 23:59:54 | pneumonias | 3 | 140603 | 7 | 5.420 | 25941.5 |
140 | 2022-08-20 17:31:45 | pneumonias | 4 | 161450 | 60 | 10.813 | 14931.1 |
139 | 2022-08-20 17:31:33 | pneumonias | 4 | 161450 | 60 | 9.673 | 16690.8 |
138 | 2022-06-13 04:21:53 | pneumonias | 1 | 67641 | 2 | 1.016 | 66575.8 |
137 | 2022-05-17 12:30:53 | pneumonias | 1 | 67641 | 2 | 1.436 | 47103.8 |
136 | 2022-05-16 08:08:08 | pneumonias | 1 | 67641 | 2 | 1.063 | 63632.2 |
135 | 2022-05-13 23:22:08 | pneumonias | 1 | 67641 | 2 | 2.170 | 31171.0 |
134 | 2021-12-18 02:59:53 | pneumonias | 1 | 67641 | 2 | 1.063 | 63632.2 |
133 | 2021-08-05 06:23:32 | pneumonias | 1 | 67641 | 2 | 1.000 | 67641.0 |
132 | 2021-02-13 06:17:55 | pneumonias | 1 | 67641 | 2 | 1.140 | 59334.2 |
131 | 2021-02-01 19:22:27 | pneumonias | 1 | 67641 | 2 | 1.030 | 65670.9 |
130 | 2021-01-29 20:57:25 | pneumonias | 1 | 67641 | 2 | 1.033 | 65480.2 |
129 | 2021-01-05 09:47:08 | pneumonias | 1 | 67641 | 2 | 1.033 | 65480.2 |
128 | 2020-11-08 11:51:33 | pneumonias | 1 | 67641 | 2 | 1.156 | 58513.0 |
127 | 2020-11-07 05:12:16 | pneumonias | 1 | 67641 | 2 | 1.233 | 54858.9 |
126 | 2020-10-05 13:07:40 | pneumonias | 1 | 67641 | 2 | 1.046 | 64666.3 |
125 | 2020-09-25 23:09:22 | pneumonias | 1 | 67641 | 2 | 1.046 | 64666.3 |
124 | 2020-03-30 09:44:26 | pneumonias | 1 | 67641 | 2 | 1.236 | 54725.7 |
123 | 2020-03-29 04:40:08 | pneumonias | 1 | 67641 | 2 | 1.076 | 62863.4 |
122 | 2020-03-28 22:09:51 | pneumonias | 1 | 67641 | 2 | 2.360 | 28661.4 |
121 | 2020-03-22 09:36:30 | pneumonias | 1 | 67641 | 2 | 1.233 | 54858.9 |
120 | 2020-03-03 06:35:24 | pneumonias | 1 | 67641 | 2 | 1.140 | 59334.2 |
119 | 2020-02-29 21:41:32 | pneumonias | 1 | 67641 | 2 | 2.530 | 26735.6 |
118 | 2020-02-09 17:04:56 | pneumonias | 1 | 67641 | 2 | 1.280 | 52844.5 |
117 | 2020-02-08 11:09:25 | pneumonias | 1 | 67641 | 2 | 1.216 | 55625.8 |
116 | 2020-02-06 22:02:06 | pneumonias | 1 | 67641 | 2 | 2.610 | 25916.1 |
115 | 2020-02-06 18:30:50 | pneumonias | 1 | 67641 | 2 | 1.203 | 56226.9 |
114 | 2020-01-28 03:01:09 | pneumonias | 1 | 67641 | 2 | 1.220 | 55443.4 |
113 | 2020-01-27 05:45:54 | pneumonias | 1 | 67641 | 2 | 1.140 | 59334.2 |
112 | 2020-01-19 08:27:23 | pneumonias | 1 | 67641 | 2 | 1.126 | 60071.9 |
111 | 2020-01-15 10:45:56 | pneumonias | 1 | 67641 | 2 | 1.203 | 56226.9 |
110 | 2020-01-02 13:46:21 | pneumonias | 1 | 67641 | 2 | 1.233 | 54858.9 |
109 | 2019-12-31 14:34:32 | pneumonias | 1 | 67641 | 2 | 1.266 | 53428.9 |
108 | 2019-11-03 00:07:11 | pneumonias | 1 | 67641 | 2 | 1.063 | 63632.2 |
107 | 2019-07-20 04:50:15 | pneumonias | 1 | 67641 | 2 | 1.043 | 64852.3 |
106 | 2019-04-02 04:24:42 | pneumonias | 1 | 67641 | 2 | 1.006 | 67237.6 |