History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knittable"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 194 | 2024-04-27 10:58:53 | knittable | 1 | 81242 | 1 | 5.030 | 16151.5 |
| 193 | 2024-04-16 21:13:47 | knittable | 1 | 81242 | 1 | 4.826 | 16834.2 |
| 192 | 2024-04-10 16:22:29 | knittable | 2 | 121436 | 4 | 14.406 | 8429.5 |
| 191 | 2024-04-10 08:52:24 | knittable | 1 | 81242 | 1 | 1.516 | 53589.7 |
| 190 | 2024-04-08 08:39:13 | knittable | 3 | 148641 | 54 | 24.720 | 6013.0 |
| 189 | 2024-04-08 08:39:17 | knittable | 2 | 121436 | 4 | 4.796 | 25320.3 |
| 188 | 2024-04-08 08:28:05 | knittable | 1 | 81242 | 1 | 1.406 | 57782.4 |
| 187 | 2024-04-07 19:44:35 | knittable | 4 | 165329 | 385 | 35.610 | 4642.8 |
| 186 | 2024-04-07 10:22:00 | knittable | 4 | 165329 | 385 | 39.813 | 4152.6 |
| 185 | 2024-04-07 02:18:39 | knittable | 4 | 165329 | 385 | 51.486 | 3211.1 |
| 184 | 2024-04-04 07:16:30 | knittable | 4 | 165329 | 385 | 30.973 | 5337.8 |
| 183 | 2024-04-04 07:16:28 | knittable | 3 | 148641 | 54 | 24.876 | 5975.3 |
| 182 | 2024-04-04 07:16:29 | knittable | 2 | 121436 | 4 | 4.313 | 28155.8 |
| 181 | 2024-04-04 07:13:48 | knittable | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 180 | 2024-03-30 03:39:25 | knittable | 1 | 81242 | 1 | 1.483 | 54782.2 |
| 179 | 2024-03-27 13:20:23 | knittable | 1 | 81242 | 1 | 3.203 | 25364.3 |
| 178 | 2024-03-27 11:33:45 | knittable | 4 | 165329 | 385 | 14.766 | 11196.6 |
| 177 | 2024-03-27 11:33:49 | knittable | 2 | 121436 | 4 | 4.953 | 24517.7 |
| 176 | 2024-03-27 11:33:41 | knittable | 3 | 148641 | 54 | 6.966 | 21338.1 |
| 175 | 2024-03-27 11:32:25 | knittable | 1 | 81242 | 1 | 1.330 | 61084.2 |
| 174 | 2024-03-15 04:09:48 | knittable | 1 | 81242 | 1 | 4.516 | 17989.8 |
| 173 | 2024-03-07 18:16:41 | knittable | 1 | 81242 | 1 | 1.343 | 60492.9 |
| 172 | 2024-03-06 06:27:10 | knittable | 2 | 121436 | 4 | 6.983 | 17390.2 |
| 171 | 2024-03-04 21:26:28 | knittable | 4 | 165329 | 385 | 27.410 | 6031.7 |
| 170 | 2024-03-04 21:26:28 | knittable | 3 | 148641 | 54 | 12.406 | 11981.4 |
| 169 | 2024-03-04 21:26:26 | knittable | 2 | 121436 | 4 | 8.423 | 14417.2 |
| 168 | 2024-03-04 20:59:09 | knittable | 1 | 81242 | 1 | 1.313 | 61875.1 |
| 167 | 2024-02-18 08:34:07 | knittable | 1 | 81242 | 1 | 3.440 | 23616.9 |
| 166 | 2024-02-12 05:20:11 | knittable | 1 | 81242 | 1 | 1.186 | 68500.8 |
| 165 | 2024-02-07 01:47:14 | knittable | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 164 | 2024-01-19 06:57:44 | knittable | 1 | 81242 | 1 | 1.173 | 69260.0 |
| 163 | 2023-12-02 18:01:12 | knittable | 1 | 81242 | 1 | 1.186 | 68500.8 |
| 162 | 2023-10-04 11:39:11 | knittable | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 161 | 2023-09-17 09:17:19 | knittable | 1 | 81242 | 1 | 1.173 | 69260.0 |
| 160 | 2023-09-08 23:54:53 | knittable | 1 | 81242 | 1 | 1.173 | 69260.0 |
| 159 | 2023-07-16 09:06:16 | knittable | 1 | 81242 | 1 | 1.300 | 62493.8 |
| 158 | 2023-05-05 12:05:46 | knittable | 1 | 81242 | 1 | 1.300 | 62493.8 |
| 157 | 2023-01-08 05:45:13 | knittable | 1 | 81242 | 1 | 1.280 | 63470.3 |
| 156 | 2022-08-24 03:59:16 | knittable | 1 | 81242 | 1 | 1.186 | 68500.8 |
| 155 | 2022-04-06 03:46:56 | knittable | 1 | 81242 | 1 | 1.283 | 63321.9 |
| 154 | 2021-12-02 20:26:34 | knittable | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 153 | 2021-08-16 09:36:17 | knittable | 1 | 81242 | 1 | 1.216 | 66810.9 |
| 152 | 2021-05-09 02:59:28 | knittable | 1 | 81242 | 1 | 1.343 | 60492.9 |
| 151 | 2021-05-05 12:40:01 | knittable | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 150 | 2021-04-07 16:26:35 | knittable | 1 | 81242 | 1 | 1.313 | 61875.1 |
| 149 | 2021-02-15 10:16:44 | knittable | 1 | 81242 | 1 | 1.186 | 68500.8 |
| 148 | 2021-01-16 10:10:09 | knittable | 1 | 81242 | 1 | 1.156 | 70278.5 |
| 147 | 2020-12-23 23:55:12 | knittable | 1 | 81242 | 1 | 1.343 | 60492.9 |
| 146 | 2020-11-01 11:44:17 | knittable | 1 | 81242 | 1 | 1.283 | 63321.9 |
| 145 | 2020-10-01 23:51:11 | knittable | 1 | 81242 | 1 | 1.250 | 64993.6 |
| 144 | 2020-06-06 14:00:54 | knittable | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 143 | 2020-03-24 05:24:47 | knittable | 1 | 81242 | 1 | 1.356 | 59913.0 |
| 142 | 2020-03-01 10:34:12 | knittable | 1 | 81242 | 1 | 1.513 | 53696.0 |
| 141 | 2020-02-28 22:20:22 | knittable | 1 | 81242 | 1 | 1.190 | 68270.6 |
| 140 | 2020-02-26 22:54:01 | knittable | 1 | 81242 | 1 | 1.376 | 59042.2 |
| 139 | 2020-02-26 17:03:04 | knittable | 1 | 81242 | 1 | 1.720 | 47233.7 |
| 138 | 2020-02-25 04:31:51 | knittable | 1 | 81242 | 1 | 1.356 | 59913.0 |
| 137 | 2020-02-20 03:56:17 | knittable | 4 | 165329 | 385 | 30.126 | 5487.9 |
| 136 | 2020-02-17 16:35:11 | knittable | 4 | 165329 | 385 | 36.316 | 4552.5 |
| 135 | 2020-02-15 07:34:16 | knittable | 1 | 81242 | 1 | 4.533 | 17922.3 |
| 134 | 2020-02-13 09:41:41 | knittable | 4 | 165329 | 385 | 12.003 | 13774.0 |
| 133 | 2020-02-09 12:12:09 | knittable | 4 | 165329 | 385 | 40.096 | 4123.3 |
| 132 | 2020-02-08 06:26:44 | knittable | 4 | 165329 | 385 | 28.390 | 5823.5 |
| 131 | 2020-02-08 06:19:00 | knittable | 4 | 165329 | 385 | 12.893 | 12823.2 |
| 130 | 2020-02-07 23:55:42 | knittable | 4 | 165329 | 385 | 19.093 | 8659.1 |
| 129 | 2020-02-07 18:06:57 | knittable | 1 | 81242 | 1 | 3.016 | 26937.0 |
| 128 | 2020-02-06 11:20:05 | knittable | 1 | 81242 | 1 | 2.830 | 28707.4 |
| 127 | 2020-01-27 19:17:51 | knittable | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 126 | 2020-01-24 13:23:55 | knittable | 3 | 148641 | 54 | 16.156 | 9200.4 |
| 125 | 2020-01-24 13:24:02 | knittable | 2 | 121436 | 4 | 4.326 | 28071.2 |
| 124 | 2020-01-24 08:22:43 | knittable | 1 | 81242 | 1 | 3.656 | 22221.6 |
| 123 | 2020-01-20 05:50:33 | knittable | 4 | 165329 | 385 | 13.330 | 12402.8 |
| 122 | 2020-01-19 12:36:44 | knittable | 3 | 148641 | 54 | 14.690 | 10118.5 |
| 121 | 2020-01-19 12:36:02 | knittable | 4 | 165329 | 385 | 25.376 | 6515.2 |
| 120 | 2020-01-19 12:35:54 | knittable | 2 | 121436 | 4 | 3.860 | 31460.1 |
| 119 | 2020-01-19 07:33:53 | knittable | 1 | 81242 | 1 | 1.483 | 54782.2 |
| 118 | 2020-01-18 22:05:58 | knittable | 1 | 81242 | 1 | 1.376 | 59042.2 |
| 117 | 2020-01-01 13:57:18 | knittable | 1 | 81242 | 1 | 2.780 | 29223.7 |
| 116 | 2020-01-01 10:51:20 | knittable | 1 | 81242 | 1 | 1.440 | 56418.1 |
| 115 | 2019-11-23 09:32:06 | knittable | 1 | 81242 | 1 | 1.170 | 69437.6 |
| 114 | 2019-08-24 12:48:54 | knittable | 1 | 81242 | 1 | 1.280 | 63470.3 |
| 113 | 2019-05-18 14:04:35 | knittable | 1 | 81242 | 1 | 1.256 | 64683.1 |
| 112 | 2019-03-27 18:35:48 | knittable | 1 | 81242 | 1 | 1.203 | 67532.8 |
| 111 | 2019-02-26 10:39:32 | knittable | 1 | 81242 | 1 | 1.133 | 71705.2 |
| 110 | 2019-01-27 13:22:16 | knittable | 1 | 81242 | 1 | 1.346 | 60358.1 |
| 109 | 2019-01-26 11:30:45 | knittable | 1 | 81242 | 1 | 1.136 | 71515.8 |
| 108 | 2018-10-06 07:05:34 | knittable | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 107 | 2018-06-30 21:21:41 | knittable | 1 | 81242 | 1 | 1.220 | 66591.8 |
| 106 | 2018-06-28 11:48:08 | knittable | 1 | 81242 | 1 | 1.750 | 46424.0 |
| 105 | 2018-06-27 00:40:18 | knittable | 1 | 81242 | 1 | 1.150 | 70645.2 |
| 104 | 2018-06-27 00:13:05 | knittable | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 103 | 2018-06-26 15:23:54 | knittable | 1 | 81242 | 1 | 1.156 | 70278.5 |
| 102 | 2018-06-19 15:11:46 | knittable | 1 | 81242 | 1 | 1.156 | 70278.5 |
| 101 | 2018-06-19 10:57:33 | knittable | 1 | 81242 | 1 | 1.136 | 71515.8 |
| 100 | 2018-01-01 07:13:39 | knittable | 1 | 81242 | 1 | 1.720 | 47233.7 |
| 99 | 2017-11-22 16:45:17 | knittable | 1 | 81242 | 1 | 2.223 | 36546.1 |
| 98 | 2017-10-20 17:54:13 | knittable | 1 | 81242 | 1 | 1.763 | 46081.7 |
| 97 | 2017-07-19 12:08:50 | knittable | 1 | 81242 | 1 | 1.793 | 45310.7 |
| 96 | 2017-07-16 11:45:19 | knittable | 1 | 81242 | 1 | 2.173 | 37387.0 |
| 95 | 2017-07-08 15:20:58 | knittable | 1 | 81242 | 1 | 1.513 | 53696.0 |