History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"penthouses"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 173 | 2024-04-17 10:07:51 | penthouses | 4 | 161450 | 238 | 41.936 | 3849.9 |
| 172 | 2024-04-14 23:12:40 | penthouses | 4 | 161450 | 238 | 40.770 | 3960.0 |
| 171 | 2024-04-13 18:54:19 | penthouses | 4 | 161450 | 238 | 38.800 | 4161.1 |
| 170 | 2024-04-13 18:54:25 | penthouses | 3 | 140603 | 39 | 17.296 | 8129.2 |
| 169 | 2024-04-13 18:54:29 | penthouses | 2 | 108824 | 9 | 10.203 | 10665.9 |
| 168 | 2024-04-13 17:50:19 | penthouses | 1 | 67641 | 3 | 3.936 | 17185.2 |
| 167 | 2024-04-13 07:18:24 | penthouses | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 166 | 2024-04-11 10:29:39 | penthouses | 1 | 67641 | 3 | 1.200 | 56367.5 |
| 165 | 2024-03-27 06:59:41 | penthouses | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 164 | 2024-03-27 06:59:41 | penthouses | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 163 | 2024-03-16 12:47:40 | penthouses | 3 | 140603 | 39 | 12.066 | 11652.8 |
| 162 | 2024-03-16 12:47:32 | penthouses | 4 | 161450 | 238 | 19.030 | 8484.0 |
| 161 | 2024-03-16 12:47:37 | penthouses | 2 | 108824 | 9 | 7.643 | 14238.4 |
| 160 | 2024-03-16 12:47:24 | penthouses | 1 | 67641 | 3 | 1.326 | 51011.3 |
| 159 | 2024-03-11 23:24:08 | penthouses | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 158 | 2024-03-11 02:34:03 | penthouses | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 157 | 2024-03-04 17:32:36 | penthouses | 3 | 140603 | 39 | 23.330 | 6026.7 |
| 156 | 2024-03-03 14:59:54 | penthouses | 3 | 140603 | 39 | 8.236 | 17071.8 |
| 155 | 2024-02-23 01:17:07 | penthouses | 3 | 140603 | 39 | 6.500 | 21631.2 |
| 154 | 2024-02-23 01:17:05 | penthouses | 2 | 108824 | 9 | 3.360 | 32388.1 |
| 153 | 2024-02-22 22:37:33 | penthouses | 4 | 161450 | 238 | 13.703 | 11782.1 |
| 152 | 2024-02-22 17:45:14 | penthouses | 1 | 67641 | 3 | 1.263 | 53555.8 |
| 151 | 2024-02-21 01:17:12 | penthouses | 1 | 67641 | 3 | 1.500 | 45094.0 |
| 150 | 2024-02-16 05:16:16 | penthouses | 4 | 161450 | 238 | 16.423 | 9830.7 |
| 149 | 2024-02-16 05:16:13 | penthouses | 3 | 140603 | 39 | 15.076 | 9326.3 |
| 148 | 2024-02-16 05:16:12 | penthouses | 2 | 108824 | 9 | 3.716 | 29285.3 |
| 147 | 2024-02-09 21:19:46 | penthouses | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 146 | 2024-02-07 01:50:03 | penthouses | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 145 | 2024-02-05 13:15:18 | penthouses | 1 | 67641 | 3 | 2.546 | 26567.6 |
| 144 | 2024-02-01 20:04:21 | penthouses | 1 | 67641 | 3 | 1.153 | 58665.2 |
| 143 | 2024-01-22 19:04:44 | penthouses | 1 | 67641 | 3 | 2.593 | 26086.0 |
| 142 | 2024-01-07 19:13:31 | penthouses | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 141 | 2023-12-28 20:11:29 | penthouses | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 140 | 2023-12-12 02:04:42 | penthouses | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 139 | 2023-10-19 06:17:45 | penthouses | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 138 | 2023-10-14 20:41:37 | penthouses | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 137 | 2023-08-16 06:41:45 | penthouses | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 136 | 2023-06-11 03:23:06 | penthouses | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 135 | 2023-05-20 00:33:53 | penthouses | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 134 | 2023-03-15 15:40:11 | penthouses | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 133 | 2023-02-12 20:48:20 | penthouses | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 132 | 2023-01-04 09:05:24 | penthouses | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 131 | 2022-12-12 06:14:39 | penthouses | 1 | 67641 | 3 | 1.153 | 58665.2 |
| 130 | 2022-11-18 09:27:10 | penthouses | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 129 | 2022-10-08 05:37:46 | penthouses | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 128 | 2022-10-01 12:31:50 | penthouses | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 127 | 2022-05-24 17:20:46 | penthouses | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 126 | 2022-05-15 09:32:36 | penthouses | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 125 | 2022-02-03 09:24:37 | penthouses | 1 | 67641 | 3 | 1.160 | 58311.2 |
| 124 | 2022-02-01 05:29:29 | penthouses | 1 | 67641 | 3 | 1.393 | 48557.8 |
| 123 | 2022-01-19 16:48:10 | penthouses | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 122 | 2022-01-16 10:27:26 | penthouses | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 121 | 2022-01-13 03:36:27 | penthouses | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 120 | 2021-11-23 03:34:56 | penthouses | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 119 | 2021-11-21 02:01:43 | penthouses | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 118 | 2021-10-19 04:23:57 | penthouses | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 117 | 2021-09-20 22:59:00 | penthouses | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 116 | 2021-06-02 22:16:37 | penthouses | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 115 | 2021-05-21 21:19:32 | penthouses | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 114 | 2021-05-01 06:10:02 | penthouses | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 113 | 2021-04-12 17:37:05 | penthouses | 4 | 161450 | 238 | 10.406 | 15515.1 |
| 112 | 2021-02-19 11:41:47 | penthouses | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 111 | 2021-01-26 14:54:15 | penthouses | 4 | 161450 | 238 | 10.123 | 15948.8 |
| 110 | 2021-01-07 02:20:39 | penthouses | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 109 | 2020-11-06 21:38:37 | penthouses | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 108 | 2020-10-26 05:54:25 | penthouses | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 107 | 2020-10-20 12:54:29 | penthouses | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 106 | 2020-03-24 23:25:28 | penthouses | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 105 | 2020-03-10 08:35:50 | penthouses | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 104 | 2020-02-27 02:59:16 | penthouses | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 103 | 2020-02-26 01:26:22 | penthouses | 1 | 67641 | 3 | 2.436 | 27767.2 |
| 102 | 2020-02-24 07:47:23 | penthouses | 1 | 67641 | 3 | 1.343 | 50365.6 |
| 101 | 2020-02-11 11:02:24 | penthouses | 1 | 67641 | 3 | 2.703 | 25024.4 |
| 100 | 2020-02-04 23:42:30 | penthouses | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 99 | 2020-01-31 05:03:13 | penthouses | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 98 | 2020-01-28 01:53:00 | penthouses | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 97 | 2020-01-27 00:22:50 | penthouses | 1 | 67641 | 3 | 2.563 | 26391.3 |
| 96 | 2020-01-18 22:24:03 | penthouses | 1 | 67641 | 3 | 2.606 | 25955.9 |
| 95 | 2020-01-16 13:36:03 | penthouses | 1 | 67641 | 3 | 4.063 | 16648.0 |
| 94 | 2020-01-04 22:56:50 | penthouses | 1 | 67641 | 3 | 3.296 | 20522.1 |
| 93 | 2020-01-01 20:05:48 | penthouses | 1 | 67641 | 3 | 1.343 | 50365.6 |
| 92 | 2019-11-28 17:06:50 | penthouses | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 91 | 2019-11-25 19:09:25 | penthouses | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 90 | 2019-08-24 00:03:12 | penthouses | 1 | 67641 | 3 | 1.090 | 62056.0 |
| 89 | 2019-07-25 12:51:42 | penthouses | 1 | 67641 | 3 | 1.196 | 56556.0 |
| 88 | 2019-05-14 21:21:12 | penthouses | 1 | 67641 | 3 | 1.026 | 65926.9 |
| 87 | 2019-01-27 00:11:14 | penthouses | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 86 | 2019-01-23 19:25:15 | penthouses | 1 | 67641 | 3 | 1.043 | 64852.3 |
| 85 | 2018-10-06 04:03:56 | penthouses | 1 | 67641 | 3 | 2.313 | 29243.8 |
| 84 | 2018-09-29 21:04:26 | penthouses | 1 | 67641 | 3 | 1.226 | 55172.1 |
| 83 | 2018-09-21 14:34:46 | penthouses | 1 | 67641 | 3 | 1.196 | 56556.0 |
| 82 | 2018-08-24 01:23:40 | penthouses | 2 | 108824 | 9 | 2.803 | 38824.1 |
| 81 | 2018-08-19 02:12:05 | penthouses | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 80 | 2018-08-09 16:41:13 | penthouses | 2 | 108824 | 9 | 3.330 | 32679.9 |
| 79 | 2018-06-30 08:29:22 | penthouses | 1 | 67641 | 3 | 1.380 | 49015.2 |
| 78 | 2018-05-25 14:07:32 | penthouses | 2 | 108824 | 9 | 3.243 | 33556.6 |
| 77 | 2018-04-28 01:18:48 | penthouses | 1 | 67641 | 3 | 1.146 | 59023.6 |
| 76 | 2018-02-26 04:06:26 | penthouses | 1 | 67641 | 3 | 1.540 | 43922.7 |
| 75 | 2018-02-13 14:27:11 | penthouses | 1 | 67641 | 3 | 1.573 | 43001.3 |
| 74 | 2017-12-04 06:47:42 | penthouses | 1 | 67641 | 3 | 1.530 | 44209.8 |