History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"originators"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
184 | 2024-03-21 18:51:38 | originators | 4 | 148819 | 73 | 28.936 | 5143.0 |
183 | 2024-03-21 08:31:18 | originators | 4 | 148819 | 73 | 32.580 | 4567.8 |
182 | 2024-03-21 03:35:47 | originators | 5 | 164607 | 401 | 23.860 | 6898.9 |
181 | 2024-03-19 13:10:52 | originators | 2 | 86808 | 4 | 7.656 | 11338.6 |
180 | 2024-03-19 13:10:20 | originators | 1 | 49908 | 2 | 0.940 | 53093.6 |
179 | 2024-03-19 01:51:18 | originators | 4 | 148819 | 73 | 19.423 | 7662.0 |
178 | 2024-03-18 22:24:12 | originators | 5 | 164607 | 401 | 34.720 | 4741.0 |
177 | 2024-03-17 23:08:26 | originators | 5 | 164607 | 401 | 60.110 | 2738.4 |
176 | 2024-03-17 21:51:26 | originators | 5 | 164607 | 401 | 58.380 | 2819.6 |
175 | 2024-03-17 21:51:24 | originators | 3 | 121633 | 14 | 19.140 | 6354.9 |
174 | 2024-03-17 21:51:26 | originators | 4 | 148819 | 73 | 17.263 | 8620.7 |
173 | 2024-03-17 07:56:43 | originators | 1 | 49908 | 2 | 0.923 | 54071.5 |
172 | 2024-03-17 07:56:35 | originators | 2 | 86808 | 4 | 2.326 | 37320.7 |
171 | 2024-03-17 07:55:28 | originators | 5 | 164607 | 401 | 17.440 | 9438.5 |
170 | 2024-03-17 07:55:30 | originators | 3 | 121633 | 14 | 10.750 | 11314.7 |
169 | 2024-03-17 07:55:28 | originators | 4 | 148819 | 73 | 10.576 | 14071.4 |
168 | 2024-03-17 07:55:20 | originators | 1 | 49908 | 2 | 1.766 | 28260.5 |
167 | 2024-03-10 00:57:28 | originators | 1 | 49908 | 2 | 1.873 | 26646.0 |
166 | 2024-03-09 18:00:50 | originators | 2 | 86808 | 4 | 8.046 | 10789.0 |
165 | 2024-03-08 14:20:05 | originators | 2 | 86808 | 4 | 5.766 | 15055.2 |
164 | 2024-03-08 14:17:34 | originators | 1 | 49908 | 2 | 2.046 | 24393.0 |
163 | 2024-02-13 09:22:05 | originators | 3 | 121633 | 14 | 15.936 | 7632.6 |
162 | 2024-02-13 09:22:06 | originators | 2 | 86808 | 4 | 7.876 | 11021.8 |
161 | 2024-02-13 07:31:44 | originators | 1 | 49908 | 2 | 0.750 | 66544.0 |
160 | 2024-02-12 12:17:37 | originators | 4 | 148819 | 73 | 22.283 | 6678.6 |
159 | 2024-02-12 12:17:37 | originators | 5 | 164607 | 401 | 18.860 | 8727.8 |
158 | 2024-02-12 12:17:29 | originators | 1 | 49908 | 2 | 0.813 | 61387.5 |
157 | 2024-02-12 10:08:34 | originators | 3 | 121633 | 14 | 12.253 | 9926.8 |
156 | 2024-02-12 10:08:32 | originators | 2 | 86808 | 4 | 4.360 | 19910.1 |
155 | 2024-02-11 22:11:06 | originators | 3 | 121633 | 14 | 4.750 | 25606.9 |
154 | 2024-02-11 22:11:08 | originators | 2 | 86808 | 4 | 2.356 | 36845.5 |
153 | 2024-02-11 17:06:06 | originators | 1 | 49908 | 2 | 0.733 | 68087.3 |
152 | 2024-02-08 00:37:25 | originators | 3 | 121633 | 14 | 15.220 | 7991.7 |
151 | 2024-02-06 17:31:48 | originators | 5 | 164607 | 401 | 49.176 | 3347.3 |
150 | 2024-02-06 17:31:51 | originators | 3 | 121633 | 14 | 15.453 | 7871.2 |
149 | 2024-02-06 17:31:50 | originators | 4 | 148819 | 73 | 14.016 | 10617.8 |
148 | 2024-02-06 17:31:49 | originators | 2 | 86808 | 4 | 5.406 | 16057.7 |
147 | 2024-02-06 15:56:22 | originators | 1 | 49908 | 2 | 0.903 | 55269.1 |
146 | 2024-01-30 17:10:11 | originators | 1 | 49908 | 2 | 0.890 | 56076.4 |
145 | 2024-01-28 19:54:13 | originators | 1 | 49908 | 2 | 0.780 | 63984.6 |
144 | 2024-01-08 10:37:57 | originators | 1 | 49908 | 2 | 1.140 | 43778.9 |
143 | 2023-12-21 13:51:11 | originators | 1 | 49908 | 2 | 0.766 | 65154.0 |
142 | 2023-11-23 01:43:48 | originators | 1 | 49908 | 2 | 0.796 | 62698.5 |
141 | 2023-10-15 14:35:47 | originators | 1 | 49908 | 2 | 1.483 | 33653.4 |
140 | 2023-09-27 07:57:54 | originators | 1 | 49908 | 2 | 0.763 | 65410.2 |
139 | 2023-09-10 10:30:35 | originators | 1 | 49908 | 2 | 0.720 | 69316.7 |
138 | 2023-06-18 07:19:53 | originators | 1 | 49908 | 2 | 0.830 | 60130.1 |
137 | 2023-04-01 18:26:27 | originators | 1 | 49908 | 2 | 0.720 | 69316.7 |
136 | 2023-03-27 22:20:55 | originators | 1 | 49908 | 2 | 0.720 | 69316.7 |
135 | 2023-01-14 17:01:23 | originators | 1 | 49908 | 2 | 0.733 | 68087.3 |
134 | 2022-11-01 12:01:52 | originators | 1 | 49908 | 2 | 0.873 | 57168.4 |
133 | 2022-07-13 05:08:19 | originators | 2 | 86808 | 4 | 2.236 | 38822.9 |
132 | 2022-06-28 11:03:32 | originators | 3 | 121633 | 14 | 4.373 | 27814.5 |
131 | 2022-06-21 13:46:50 | originators | 1 | 49908 | 2 | 0.750 | 66544.0 |
130 | 2022-06-19 09:56:28 | originators | 1 | 49908 | 2 | 0.733 | 68087.3 |
129 | 2022-05-16 20:49:39 | originators | 1 | 49908 | 2 | 0.830 | 60130.1 |
128 | 2022-03-01 17:29:38 | originators | 4 | 148819 | 73 | 9.813 | 15165.5 |
127 | 2022-02-28 17:59:41 | originators | 4 | 148819 | 73 | 9.390 | 15848.7 |
126 | 2022-02-27 18:30:46 | originators | 4 | 148819 | 73 | 8.500 | 17508.1 |
125 | 2022-02-26 20:17:40 | originators | 4 | 148819 | 73 | 8.313 | 17902.0 |
124 | 2022-02-25 12:36:59 | originators | 4 | 148819 | 73 | 9.190 | 16193.6 |
123 | 2021-11-07 22:30:29 | originators | 4 | 148819 | 73 | 9.530 | 15615.8 |
122 | 2021-09-10 23:56:49 | originators | 1 | 49908 | 2 | 0.890 | 56076.4 |
121 | 2021-09-10 21:19:17 | originators | 1 | 49908 | 2 | 0.733 | 68087.3 |
120 | 2021-06-06 04:24:49 | originators | 1 | 49908 | 2 | 0.750 | 66544.0 |
119 | 2021-05-22 13:25:18 | originators | 4 | 148819 | 73 | 9.373 | 15877.4 |
118 | 2021-05-19 07:03:17 | originators | 1 | 49908 | 2 | 1.063 | 46950.1 |
117 | 2021-03-25 15:26:36 | originators | 4 | 148819 | 73 | 8.486 | 17537.0 |
116 | 2021-02-01 20:35:14 | originators | 5 | 164607 | 401 | 13.000 | 12662.1 |
115 | 2021-01-08 21:42:02 | originators | 4 | 148819 | 73 | 9.016 | 16506.1 |
114 | 2020-11-19 17:57:08 | originators | 1 | 49908 | 2 | 0.783 | 63739.5 |
113 | 2020-10-18 19:07:16 | originators | 4 | 148819 | 73 | 9.763 | 15243.2 |
112 | 2020-09-12 13:54:05 | originators | 4 | 148819 | 73 | 8.830 | 16853.8 |
111 | 2020-09-06 06:35:25 | originators | 4 | 148819 | 73 | 8.080 | 18418.2 |
110 | 2020-07-18 03:35:40 | originators | 4 | 148819 | 73 | 10.030 | 14837.4 |
109 | 2020-03-26 10:39:13 | originators | 1 | 49908 | 2 | 0.813 | 61387.5 |
108 | 2020-03-24 08:32:01 | originators | 1 | 49908 | 2 | 0.876 | 56972.6 |
107 | 2020-03-15 15:41:50 | originators | 1 | 49908 | 2 | 0.813 | 61387.5 |
106 | 2020-02-19 20:39:24 | originators | 1 | 49908 | 2 | 0.860 | 58032.6 |
105 | 2020-02-19 18:52:24 | originators | 1 | 49908 | 2 | 1.000 | 49908.0 |
104 | 2020-02-09 02:52:21 | originators | 1 | 49908 | 2 | 0.843 | 59202.8 |
103 | 2020-02-05 00:13:07 | originators | 1 | 49908 | 2 | 0.923 | 54071.5 |
102 | 2020-02-02 06:22:49 | originators | 1 | 49908 | 2 | 1.763 | 28308.6 |
101 | 2020-02-02 03:44:39 | originators | 1 | 49908 | 2 | 0.830 | 60130.1 |
100 | 2020-01-31 16:55:21 | originators | 1 | 49908 | 2 | 1.873 | 26646.0 |
99 | 2020-01-19 06:29:45 | originators | 1 | 49908 | 2 | 0.920 | 54247.8 |
98 | 2020-01-10 15:45:02 | originators | 1 | 49908 | 2 | 0.843 | 59202.8 |
97 | 2020-01-07 00:24:04 | originators | 1 | 49908 | 2 | 1.936 | 25778.9 |
96 | 2019-12-07 01:04:26 | originators | 1 | 49908 | 2 | 0.826 | 60421.3 |
95 | 2019-09-04 23:36:15 | originators | 1 | 49908 | 2 | 0.693 | 72017.3 |
94 | 2019-08-14 08:34:27 | originators | 4 | 148819 | 73 | 8.490 | 17528.7 |
93 | 2019-08-09 12:15:17 | originators | 4 | 148819 | 73 | 9.266 | 16060.8 |
92 | 2019-05-27 00:33:56 | originators | 1 | 49908 | 2 | 0.856 | 58303.7 |
91 | 2019-04-01 20:54:23 | originators | 1 | 49908 | 2 | 0.733 | 68087.3 |
90 | 2019-01-26 14:26:08 | originators | 1 | 49908 | 2 | 0.826 | 60421.3 |
89 | 2019-01-23 09:36:24 | originators | 1 | 49908 | 2 | 0.890 | 56076.4 |
88 | 2018-09-17 17:21:24 | originators | 1 | 49908 | 2 | 0.820 | 60863.4 |
87 | 2018-06-23 17:46:15 | originators | 1 | 49908 | 2 | 0.820 | 60863.4 |
86 | 2018-06-16 13:17:50 | originators | 1 | 49908 | 2 | 0.790 | 63174.7 |
85 | 2018-03-23 09:58:18 | originators | 1 | 49908 | 2 | 1.013 | 49267.5 |