History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pharmacist"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
188 | 2024-04-13 04:42:25 | pharmacist | 1 | 67641 | 2 | 1.216 | 55625.8 |
187 | 2024-04-04 18:27:44 | pharmacist | 3 | 140603 | 7 | 9.860 | 14259.9 |
186 | 2024-04-04 18:27:32 | pharmacist | 3 | 140603 | 7 | 13.816 | 10176.8 |
185 | 2024-04-03 18:13:58 | pharmacist | 3 | 140603 | 7 | 5.513 | 25503.9 |
184 | 2024-03-23 03:02:30 | pharmacist | 1 | 67641 | 2 | 1.796 | 37662.0 |
183 | 2024-03-05 06:58:13 | pharmacist | 4 | 161450 | 64 | 44.816 | 3602.5 |
182 | 2024-03-04 17:34:38 | pharmacist | 4 | 161450 | 64 | 34.190 | 4722.1 |
181 | 2024-03-03 15:02:56 | pharmacist | 3 | 140603 | 7 | 14.796 | 9502.8 |
180 | 2024-03-03 15:02:55 | pharmacist | 2 | 108824 | 3 | 7.046 | 15444.8 |
179 | 2024-03-03 13:47:19 | pharmacist | 1 | 67641 | 2 | 1.203 | 56226.9 |
178 | 2024-03-02 21:21:53 | pharmacist | 4 | 161450 | 64 | 32.953 | 4899.4 |
177 | 2024-03-02 19:16:22 | pharmacist | 4 | 161450 | 64 | 23.406 | 6897.8 |
176 | 2024-03-02 19:16:23 | pharmacist | 3 | 140603 | 7 | 8.093 | 17373.4 |
175 | 2024-03-02 19:16:24 | pharmacist | 2 | 108824 | 3 | 3.750 | 29019.7 |
174 | 2024-03-02 19:12:07 | pharmacist | 4 | 161450 | 64 | 19.033 | 8482.6 |
173 | 2024-03-02 19:12:09 | pharmacist | 3 | 140603 | 7 | 15.580 | 9024.6 |
172 | 2024-03-02 19:12:13 | pharmacist | 2 | 108824 | 3 | 9.393 | 11585.6 |
171 | 2024-03-02 19:11:56 | pharmacist | 1 | 67641 | 2 | 1.280 | 52844.5 |
170 | 2024-03-02 19:11:49 | pharmacist | 1 | 67641 | 2 | 2.563 | 26391.3 |
169 | 2024-03-02 18:22:37 | pharmacist | 5 | 173545 | 548 | 51.816 | 3349.3 |
168 | 2024-03-02 04:53:29 | pharmacist | 5 | 173545 | 548 | 39.190 | 4428.3 |
167 | 2024-02-21 14:19:39 | pharmacist | 5 | 173545 | 548 | 50.083 | 3465.1 |
166 | 2024-02-20 13:57:14 | pharmacist | 4 | 161450 | 64 | 13.250 | 12184.9 |
165 | 2024-02-20 13:57:11 | pharmacist | 3 | 140603 | 7 | 7.453 | 18865.3 |
164 | 2024-02-20 13:57:09 | pharmacist | 2 | 108824 | 3 | 3.890 | 27975.3 |
163 | 2024-02-19 21:21:47 | pharmacist | 1 | 67641 | 2 | 2.860 | 23650.7 |
162 | 2024-02-18 05:28:53 | pharmacist | 5 | 173545 | 548 | 58.080 | 2988.0 |
161 | 2024-02-16 11:13:37 | pharmacist | 5 | 173545 | 548 | 33.423 | 5192.4 |
160 | 2024-02-16 11:13:37 | pharmacist | 3 | 140603 | 7 | 19.096 | 7363.0 |
159 | 2024-02-16 11:13:36 | pharmacist | 2 | 108824 | 3 | 8.283 | 13138.2 |
158 | 2024-02-16 07:45:42 | pharmacist | 1 | 67641 | 2 | 2.513 | 26916.4 |
157 | 2024-02-01 01:40:12 | pharmacist | 1 | 67641 | 2 | 1.126 | 60071.9 |
156 | 2024-01-31 19:21:28 | pharmacist | 1 | 67641 | 2 | 1.093 | 61885.6 |
155 | 2024-01-31 19:21:24 | pharmacist | 1 | 67641 | 2 | 1.190 | 56841.2 |
154 | 2024-01-29 05:09:35 | pharmacist | 2 | 108824 | 3 | 2.703 | 40260.5 |
153 | 2024-01-12 12:02:03 | pharmacist | 1 | 67641 | 2 | 1.093 | 61885.6 |
152 | 2023-12-24 11:15:18 | pharmacist | 4 | 161450 | 64 | 10.736 | 15038.2 |
151 | 2023-12-18 12:57:49 | pharmacist | 1 | 67641 | 2 | 1.000 | 67641.0 |
150 | 2023-12-06 02:55:50 | pharmacist | 3 | 140603 | 7 | 5.530 | 25425.5 |
149 | 2023-12-02 23:28:00 | pharmacist | 1 | 67641 | 2 | 1.156 | 58513.0 |
148 | 2023-11-07 05:54:10 | pharmacist | 2 | 108824 | 3 | 2.906 | 37448.0 |
147 | 2023-10-06 16:19:31 | pharmacist | 1 | 67641 | 2 | 1.000 | 67641.0 |
146 | 2023-09-26 03:40:20 | pharmacist | 4 | 161450 | 64 | 9.626 | 16772.3 |
145 | 2023-09-03 01:49:13 | pharmacist | 3 | 140603 | 7 | 6.393 | 21993.3 |
144 | 2023-08-16 16:48:37 | pharmacist | 1 | 67641 | 2 | 1.030 | 65670.9 |
143 | 2023-08-11 16:04:05 | pharmacist | 2 | 108824 | 3 | 5.716 | 19038.5 |
142 | 2023-08-02 06:16:07 | pharmacist | 1 | 67641 | 2 | 1.126 | 60071.9 |
141 | 2023-07-07 03:29:51 | pharmacist | 4 | 161450 | 64 | 9.593 | 16830.0 |
140 | 2023-05-19 08:09:34 | pharmacist | 3 | 140603 | 7 | 5.403 | 26023.1 |
139 | 2023-04-26 10:54:12 | pharmacist | 1 | 67641 | 2 | 1.016 | 66575.8 |
138 | 2023-04-23 12:09:07 | pharmacist | 2 | 108824 | 3 | 2.783 | 39103.1 |
137 | 2023-04-02 20:47:00 | pharmacist | 1 | 67641 | 2 | 1.093 | 61885.6 |
136 | 2023-03-27 07:58:04 | pharmacist | 4 | 161450 | 64 | 9.546 | 16912.8 |
135 | 2023-02-28 03:29:06 | pharmacist | 3 | 140603 | 7 | 5.783 | 24313.2 |
134 | 2023-02-16 11:13:43 | pharmacist | 1 | 67641 | 2 | 1.000 | 67641.0 |
133 | 2023-02-03 03:24:03 | pharmacist | 4 | 161450 | 64 | 11.673 | 13831.1 |
132 | 2023-01-28 14:47:25 | pharmacist | 2 | 108824 | 3 | 2.580 | 42179.8 |
131 | 2022-12-25 01:13:09 | pharmacist | 4 | 161450 | 64 | 9.813 | 16452.7 |
130 | 2022-12-18 05:03:18 | pharmacist | 4 | 161450 | 64 | 9.513 | 16971.5 |
129 | 2022-12-14 02:19:52 | pharmacist | 1 | 67641 | 2 | 1.200 | 56367.5 |
128 | 2022-12-08 08:04:58 | pharmacist | 3 | 140603 | 7 | 5.343 | 26315.4 |
127 | 2022-11-14 11:08:48 | pharmacist | 1 | 67641 | 2 | 1.063 | 63632.2 |
126 | 2022-11-10 21:11:54 | pharmacist | 2 | 108824 | 3 | 2.626 | 41441.0 |
125 | 2022-11-10 18:35:23 | pharmacist | 1 | 67641 | 2 | 1.016 | 66575.8 |
124 | 2022-11-01 00:57:48 | pharmacist | 4 | 161450 | 64 | 10.280 | 15705.3 |
123 | 2022-08-23 11:23:34 | pharmacist | 4 | 161450 | 64 | 9.846 | 16397.5 |
122 | 2022-08-19 12:25:51 | pharmacist | 1 | 67641 | 2 | 1.016 | 66575.8 |
121 | 2022-07-23 18:08:35 | pharmacist | 3 | 140603 | 7 | 5.503 | 25550.2 |
120 | 2022-06-15 07:07:44 | pharmacist | 1 | 67641 | 2 | 1.000 | 67641.0 |
119 | 2022-06-09 05:04:56 | pharmacist | 2 | 108824 | 3 | 2.716 | 40067.7 |
118 | 2022-04-03 15:12:27 | pharmacist | 1 | 67641 | 2 | 1.123 | 60232.4 |
117 | 2022-04-01 10:30:16 | pharmacist | 1 | 67641 | 2 | 1.156 | 58513.0 |
116 | 2022-02-12 12:05:20 | pharmacist | 2 | 108824 | 3 | 2.653 | 41019.2 |
115 | 2022-01-20 18:30:08 | pharmacist | 1 | 67641 | 2 | 1.000 | 67641.0 |
114 | 2022-01-17 12:00:20 | pharmacist | 1 | 67641 | 2 | 1.140 | 59334.2 |
113 | 2022-01-15 21:07:08 | pharmacist | 1 | 67641 | 2 | 1.063 | 63632.2 |
112 | 2022-01-14 05:17:30 | pharmacist | 1 | 67641 | 2 | 0.983 | 68810.8 |
111 | 2021-09-15 13:29:43 | pharmacist | 1 | 67641 | 2 | 1.000 | 67641.0 |
110 | 2021-06-14 01:16:46 | pharmacist | 1 | 67641 | 2 | 1.000 | 67641.0 |
109 | 2021-06-01 18:55:16 | pharmacist | 1 | 67641 | 2 | 1.000 | 67641.0 |
108 | 2021-05-11 20:46:51 | pharmacist | 1 | 67641 | 2 | 2.326 | 29080.4 |
107 | 2021-03-02 14:50:50 | pharmacist | 1 | 67641 | 2 | 1.063 | 63632.2 |
106 | 2020-11-17 10:29:28 | pharmacist | 1 | 67641 | 2 | 1.000 | 67641.0 |
105 | 2020-11-14 20:01:05 | pharmacist | 1 | 67641 | 2 | 2.093 | 32317.7 |
104 | 2020-08-05 20:33:38 | pharmacist | 1 | 67641 | 2 | 1.060 | 63812.3 |
103 | 2020-04-12 12:15:55 | pharmacist | 1 | 67641 | 2 | 1.106 | 61158.2 |
102 | 2020-03-26 23:24:25 | pharmacist | 1 | 67641 | 2 | 1.220 | 55443.4 |
101 | 2020-02-19 04:10:13 | pharmacist | 1 | 67641 | 2 | 3.516 | 19238.1 |
100 | 2020-02-12 19:40:41 | pharmacist | 1 | 67641 | 2 | 1.203 | 56226.9 |
99 | 2020-02-05 03:38:32 | pharmacist | 1 | 67641 | 2 | 2.063 | 32787.7 |
98 | 2020-02-05 00:10:54 | pharmacist | 2 | 108824 | 3 | 2.920 | 37268.5 |
97 | 2020-02-04 19:25:03 | pharmacist | 1 | 67641 | 2 | 2.563 | 26391.3 |
96 | 2020-01-30 07:18:23 | pharmacist | 1 | 67641 | 2 | 1.296 | 52192.1 |
95 | 2020-01-23 00:15:50 | pharmacist | 1 | 67641 | 2 | 1.280 | 52844.5 |
94 | 2020-01-18 02:33:03 | pharmacist | 1 | 67641 | 2 | 2.546 | 26567.6 |
93 | 2020-01-03 12:31:05 | pharmacist | 1 | 67641 | 2 | 1.080 | 62630.6 |
92 | 2020-01-01 14:25:43 | pharmacist | 1 | 67641 | 2 | 1.313 | 51516.4 |
91 | 2019-12-17 02:12:32 | pharmacist | 1 | 67641 | 2 | 1.110 | 60937.8 |
90 | 2019-09-15 16:10:20 | pharmacist | 1 | 67641 | 2 | 1.063 | 63632.2 |
89 | 2019-07-14 20:01:11 | pharmacist | 1 | 67641 | 2 | 0.976 | 69304.3 |