History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coattested"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 205 | 2024-05-06 22:16:20 | coattested | 2 | 108824 | 7 | 6.953 | 15651.4 |
| 204 | 2024-05-06 22:15:59 | coattested | 3 | 140603 | 23 | 11.076 | 12694.4 |
| 203 | 2024-05-06 22:15:47 | coattested | 1 | 67641 | 1 | 1.313 | 51516.4 |
| 202 | 2024-04-26 12:18:58 | coattested | 4 | 161450 | 200 | 41.940 | 3849.5 |
| 201 | 2024-04-26 12:19:10 | coattested | 2 | 108824 | 7 | 11.860 | 9175.7 |
| 200 | 2024-04-26 12:19:03 | coattested | 3 | 140603 | 23 | 13.076 | 10752.8 |
| 199 | 2024-04-26 11:43:07 | coattested | 1 | 67641 | 1 | 2.326 | 29080.4 |
| 198 | 2024-04-26 05:02:56 | coattested | 1 | 67641 | 1 | 1.563 | 43276.4 |
| 197 | 2024-04-11 00:59:56 | coattested | 1 | 67641 | 1 | 2.546 | 26567.6 |
| 196 | 2024-03-27 04:57:36 | coattested | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 195 | 2024-03-15 23:11:24 | coattested | 2 | 108824 | 7 | 7.686 | 14158.7 |
| 194 | 2024-03-15 10:52:34 | coattested | 3 | 140603 | 23 | 15.080 | 9323.8 |
| 193 | 2024-03-15 08:47:36 | coattested | 4 | 161450 | 200 | 40.016 | 4034.6 |
| 192 | 2024-03-15 03:50:19 | coattested | 4 | 161450 | 200 | 32.113 | 5027.6 |
| 191 | 2024-03-14 20:10:58 | coattested | 4 | 161450 | 200 | 26.550 | 6081.0 |
| 190 | 2024-03-14 18:02:40 | coattested | 4 | 161450 | 200 | 37.550 | 4299.6 |
| 189 | 2024-03-14 18:02:41 | coattested | 3 | 140603 | 23 | 16.330 | 8610.1 |
| 188 | 2024-03-14 11:44:56 | coattested | 4 | 161450 | 200 | 48.660 | 3317.9 |
| 187 | 2024-03-14 11:45:00 | coattested | 2 | 108824 | 7 | 11.906 | 9140.3 |
| 186 | 2024-03-14 11:44:43 | coattested | 3 | 140603 | 23 | 25.656 | 5480.3 |
| 185 | 2024-03-14 11:42:11 | coattested | 1 | 67641 | 1 | 2.530 | 26735.6 |
| 184 | 2024-03-01 00:50:48 | coattested | 1 | 67641 | 1 | 1.766 | 38301.8 |
| 183 | 2024-02-29 00:05:53 | coattested | 1 | 67641 | 1 | 1.250 | 54112.8 |
| 182 | 2024-02-22 18:11:22 | coattested | 1 | 67641 | 1 | 1.080 | 62630.6 |
| 181 | 2024-02-13 03:14:59 | coattested | 3 | 140603 | 23 | 13.376 | 10511.6 |
| 180 | 2024-02-05 16:46:57 | coattested | 1 | 67641 | 1 | 1.203 | 56226.9 |
| 179 | 2024-02-05 12:06:30 | coattested | 1 | 67641 | 1 | 3.000 | 22547.0 |
| 178 | 2024-02-04 12:37:51 | coattested | 3 | 140603 | 23 | 31.783 | 4423.8 |
| 177 | 2024-02-04 12:38:00 | coattested | 2 | 108824 | 7 | 7.643 | 14238.4 |
| 176 | 2024-02-04 12:37:45 | coattested | 4 | 161450 | 200 | 16.643 | 9700.8 |
| 175 | 2024-02-04 12:08:26 | coattested | 3 | 140603 | 23 | 7.766 | 18104.9 |
| 174 | 2024-02-04 12:07:46 | coattested | 4 | 161450 | 200 | 19.080 | 8461.7 |
| 173 | 2024-02-04 12:07:42 | coattested | 2 | 108824 | 7 | 3.640 | 29896.7 |
| 172 | 2024-02-04 12:07:18 | coattested | 1 | 67641 | 1 | 3.690 | 18330.9 |
| 171 | 2024-01-20 19:11:23 | coattested | 1 | 67641 | 1 | 1.050 | 64420.0 |
| 170 | 2024-01-12 01:31:53 | coattested | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 169 | 2024-01-02 05:48:46 | coattested | 3 | 140603 | 23 | 6.360 | 22107.4 |
| 168 | 2023-11-27 16:26:08 | coattested | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 167 | 2023-10-06 12:12:03 | coattested | 3 | 140603 | 23 | 8.076 | 17410.0 |
| 166 | 2023-09-12 03:11:43 | coattested | 1 | 67641 | 1 | 1.126 | 60071.9 |
| 165 | 2023-09-11 04:39:22 | coattested | 1 | 67641 | 1 | 1.440 | 46972.9 |
| 164 | 2023-08-19 15:39:59 | coattested | 1 | 67641 | 1 | 1.220 | 55443.4 |
| 163 | 2023-07-18 14:15:00 | coattested | 3 | 140603 | 23 | 5.640 | 24929.6 |
| 162 | 2023-06-27 20:16:34 | coattested | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 161 | 2023-04-05 01:23:15 | coattested | 3 | 140603 | 23 | 6.283 | 22378.3 |
| 160 | 2023-04-04 08:09:08 | coattested | 1 | 67641 | 1 | 1.890 | 35788.9 |
| 159 | 2023-04-02 09:52:21 | coattested | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 158 | 2023-01-16 18:35:37 | coattested | 1 | 67641 | 1 | 1.143 | 59178.5 |
| 157 | 2022-12-31 17:56:15 | coattested | 3 | 140603 | 23 | 5.700 | 24667.2 |
| 156 | 2022-11-21 04:41:07 | coattested | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 155 | 2022-11-07 20:19:07 | coattested | 1 | 67641 | 1 | 1.126 | 60071.9 |
| 154 | 2022-09-03 05:33:28 | coattested | 3 | 140603 | 23 | 5.606 | 25080.8 |
| 153 | 2022-06-27 06:48:49 | coattested | 1 | 67641 | 1 | 1.033 | 65480.2 |
| 152 | 2022-06-22 08:46:51 | coattested | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 151 | 2022-05-18 18:20:50 | coattested | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 150 | 2022-04-14 07:23:12 | coattested | 3 | 140603 | 23 | 5.653 | 24872.3 |
| 149 | 2022-03-21 15:34:08 | coattested | 1 | 67641 | 1 | 1.423 | 47534.1 |
| 148 | 2022-01-30 20:36:24 | coattested | 1 | 67641 | 1 | 1.203 | 56226.9 |
| 147 | 2021-09-15 04:16:37 | coattested | 1 | 67641 | 1 | 1.093 | 61885.6 |
| 146 | 2021-06-01 10:24:08 | coattested | 1 | 67641 | 1 | 1.170 | 57812.8 |
| 145 | 2021-03-02 06:08:35 | coattested | 1 | 67641 | 1 | 1.343 | 50365.6 |
| 144 | 2021-01-27 10:59:42 | coattested | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 143 | 2020-11-21 11:57:13 | coattested | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 142 | 2020-11-08 01:17:27 | coattested | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 141 | 2020-08-14 10:09:18 | coattested | 1 | 67641 | 1 | 1.076 | 62863.4 |
| 140 | 2020-04-18 04:32:18 | coattested | 1 | 67641 | 1 | 1.050 | 64420.0 |
| 139 | 2020-03-25 05:45:43 | coattested | 1 | 67641 | 1 | 1.250 | 54112.8 |
| 138 | 2020-02-29 11:31:48 | coattested | 1 | 67641 | 1 | 2.313 | 29243.8 |
| 137 | 2020-02-29 06:05:38 | coattested | 1 | 67641 | 1 | 2.796 | 24192.1 |
| 136 | 2020-02-10 17:56:52 | coattested | 1 | 67641 | 1 | 1.376 | 49157.7 |
| 135 | 2020-02-09 09:39:34 | coattested | 1 | 67641 | 1 | 3.843 | 17601.1 |
| 134 | 2020-02-08 22:22:51 | coattested | 1 | 67641 | 1 | 2.576 | 26258.2 |
| 133 | 2020-02-05 04:40:57 | coattested | 1 | 67641 | 1 | 1.280 | 52844.5 |
| 132 | 2020-01-20 16:32:04 | coattested | 1 | 67641 | 1 | 2.766 | 24454.4 |
| 131 | 2020-01-10 18:22:02 | coattested | 1 | 67641 | 1 | 1.360 | 49736.0 |
| 130 | 2020-01-10 10:14:02 | coattested | 1 | 67641 | 1 | 1.266 | 53428.9 |
| 129 | 2019-12-28 08:51:28 | coattested | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 128 | 2019-09-27 19:55:18 | coattested | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 127 | 2019-06-09 10:45:49 | coattested | 1 | 67641 | 1 | 1.150 | 58818.3 |
| 126 | 2019-03-05 06:13:55 | coattested | 1 | 67641 | 1 | 1.043 | 64852.3 |
| 125 | 2019-02-26 04:42:13 | coattested | 1 | 67641 | 1 | 0.983 | 68810.8 |
| 124 | 2019-02-09 08:42:39 | coattested | 1 | 67641 | 1 | 1.120 | 60393.8 |
| 123 | 2019-01-05 19:38:08 | coattested | 1 | 67641 | 1 | 1.150 | 58818.3 |
| 122 | 2018-09-30 11:27:25 | coattested | 1 | 67641 | 1 | 1.153 | 58665.2 |
| 121 | 2018-06-20 11:08:53 | coattested | 1 | 67641 | 1 | 1.206 | 56087.1 |
| 120 | 2018-06-18 19:27:07 | coattested | 1 | 67641 | 1 | 1.300 | 52031.5 |
| 119 | 2018-04-20 03:17:51 | coattested | 1 | 67641 | 1 | 1.120 | 60393.8 |
| 118 | 2017-11-10 10:15:43 | coattested | 1 | 67641 | 1 | 2.086 | 32426.2 |
| 117 | 2017-10-14 07:53:31 | coattested | 1 | 67641 | 1 | 1.483 | 45610.9 |
| 116 | 2017-05-17 23:12:26 | coattested | 1 | 67641 | 1 | 1.973 | 34283.3 |
| 115 | 2017-04-21 09:35:32 | coattested | 1 | 67641 | 1 | 1.306 | 51792.5 |
| 114 | 2017-01-11 07:53:52 | coattested | 1 | 67641 | 1 | 1.293 | 52313.2 |
| 113 | 2016-12-28 19:58:26 | coattested | 1 | 67641 | 1 | 1.870 | 36171.7 |
| 112 | 2016-12-17 00:16:07 | coattested | 1 | 67641 | 1 | 1.316 | 51398.9 |
| 111 | 2016-12-14 23:05:07 | coattested | 4 | 161450 | 200 | 13.650 | 11827.8 |
| 110 | 2016-12-12 18:22:10 | coattested | 4 | 161450 | 200 | 14.473 | 11155.3 |
| 109 | 2016-11-15 03:46:31 | coattested | 1 | 67641 | 1 | 1.476 | 45827.2 |
| 108 | 2016-10-19 18:53:45 | coattested | 4 | 161450 | 200 | 21.410 | 7540.9 |
| 107 | 2016-10-07 04:11:35 | coattested | 1 | 67641 | 1 | 1.530 | 44209.8 |
| 106 | 2016-10-01 21:06:21 | coattested | 1 | 67641 | 1 | 1.453 | 46552.6 |