History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"superfirms"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 181 | 2024-05-04 00:32:46 | superfirms | 1 | 67641 | 3 | 2.783 | 24305.1 |
| 180 | 2024-04-30 19:37:37 | superfirms | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 179 | 2024-04-30 19:37:33 | superfirms | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 178 | 2024-04-25 21:51:09 | superfirms | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 177 | 2024-04-25 21:34:24 | superfirms | 1 | 67641 | 3 | 1.593 | 42461.4 |
| 176 | 2024-04-25 17:37:56 | superfirms | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 175 | 2024-03-26 18:04:46 | superfirms | 1 | 67641 | 3 | 1.313 | 51516.4 |
| 174 | 2024-03-26 18:04:45 | superfirms | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 173 | 2024-03-26 01:30:30 | superfirms | 3 | 140603 | 29 | 21.376 | 6577.6 |
| 172 | 2024-03-25 21:33:39 | superfirms | 3 | 140603 | 29 | 28.406 | 4949.8 |
| 171 | 2024-03-22 03:11:34 | superfirms | 3 | 140603 | 29 | 23.420 | 6003.5 |
| 170 | 2024-03-22 03:11:30 | superfirms | 2 | 108824 | 5 | 9.500 | 11455.2 |
| 169 | 2024-03-22 02:31:48 | superfirms | 1 | 67641 | 3 | 1.236 | 54725.7 |
| 168 | 2024-03-20 02:39:06 | superfirms | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 167 | 2024-03-09 19:00:05 | superfirms | 4 | 161450 | 147 | 45.690 | 3533.6 |
| 166 | 2024-03-08 20:31:25 | superfirms | 4 | 161450 | 147 | 9.923 | 16270.3 |
| 165 | 2024-03-07 15:45:52 | superfirms | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 164 | 2024-02-24 21:45:23 | superfirms | 4 | 161450 | 147 | 32.593 | 4953.5 |
| 163 | 2024-02-24 21:45:23 | superfirms | 3 | 140603 | 29 | 11.373 | 12362.9 |
| 162 | 2024-02-24 21:45:23 | superfirms | 2 | 108824 | 5 | 7.453 | 14601.4 |
| 161 | 2024-02-24 21:07:35 | superfirms | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 160 | 2024-02-24 12:23:24 | superfirms | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 159 | 2024-02-14 06:28:22 | superfirms | 1 | 67641 | 3 | 2.750 | 24596.7 |
| 158 | 2024-02-04 18:03:53 | superfirms | 4 | 161450 | 147 | 13.690 | 11793.3 |
| 157 | 2024-02-04 18:01:33 | superfirms | 3 | 140603 | 29 | 11.653 | 12065.8 |
| 156 | 2024-02-04 18:01:31 | superfirms | 2 | 108824 | 5 | 4.470 | 24345.4 |
| 155 | 2024-02-04 17:58:33 | superfirms | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 154 | 2024-02-03 06:41:45 | superfirms | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 153 | 2024-02-02 22:06:32 | superfirms | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 152 | 2024-01-25 19:48:59 | superfirms | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 151 | 2023-12-14 17:48:40 | superfirms | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 150 | 2023-12-06 04:55:54 | superfirms | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 149 | 2023-11-28 02:27:23 | superfirms | 4 | 161450 | 147 | 13.860 | 11648.6 |
| 148 | 2023-10-20 07:21:36 | superfirms | 1 | 67641 | 3 | 2.436 | 27767.2 |
| 147 | 2023-09-19 17:16:49 | superfirms | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 146 | 2023-08-28 00:05:38 | superfirms | 4 | 161450 | 147 | 11.656 | 13851.2 |
| 145 | 2023-07-20 21:38:32 | superfirms | 2 | 108824 | 5 | 3.046 | 35726.9 |
| 144 | 2023-07-20 21:14:31 | superfirms | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 143 | 2023-07-09 08:35:54 | superfirms | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 142 | 2023-05-14 10:47:03 | superfirms | 4 | 161450 | 147 | 9.936 | 16249.0 |
| 141 | 2023-04-19 22:20:02 | superfirms | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 140 | 2023-02-21 00:28:24 | superfirms | 4 | 161450 | 147 | 9.466 | 17055.8 |
| 139 | 2023-02-07 07:02:41 | superfirms | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 138 | 2022-12-05 17:12:26 | superfirms | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 137 | 2022-12-02 14:21:27 | superfirms | 4 | 161450 | 147 | 9.563 | 16882.8 |
| 136 | 2022-11-25 07:06:25 | superfirms | 2 | 108824 | 5 | 2.686 | 40515.3 |
| 135 | 2022-08-02 19:08:06 | superfirms | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 134 | 2022-07-19 16:05:38 | superfirms | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 133 | 2022-05-07 12:12:26 | superfirms | 2 | 108824 | 5 | 2.716 | 40067.7 |
| 132 | 2022-04-22 01:03:33 | superfirms | 4 | 161450 | 147 | 9.733 | 16587.9 |
| 131 | 2022-04-11 08:25:21 | superfirms | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 130 | 2021-04-22 04:26:23 | superfirms | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 129 | 2021-03-24 13:28:59 | superfirms | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 128 | 2021-02-20 18:59:36 | superfirms | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 127 | 2020-11-01 20:26:26 | superfirms | 1 | 67641 | 3 | 1.236 | 54725.7 |
| 126 | 2020-10-23 22:06:06 | superfirms | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 125 | 2020-10-21 22:20:05 | superfirms | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 124 | 2020-08-22 14:22:31 | superfirms | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 123 | 2020-03-24 18:55:05 | superfirms | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 122 | 2020-03-07 22:48:40 | superfirms | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 121 | 2020-03-03 05:43:01 | superfirms | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 120 | 2020-03-02 23:20:47 | superfirms | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 119 | 2020-02-29 18:50:54 | superfirms | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 118 | 2020-02-29 04:58:42 | superfirms | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 117 | 2020-02-26 19:46:50 | superfirms | 1 | 67641 | 3 | 1.313 | 51516.4 |
| 116 | 2020-02-08 07:07:04 | superfirms | 1 | 67641 | 3 | 1.716 | 39417.8 |
| 115 | 2020-02-01 04:21:59 | superfirms | 1 | 67641 | 3 | 4.030 | 16784.4 |
| 114 | 2020-01-28 08:11:14 | superfirms | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 113 | 2020-01-27 06:20:36 | superfirms | 1 | 67641 | 3 | 1.326 | 51011.3 |
| 112 | 2020-01-18 11:28:56 | superfirms | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 111 | 2020-01-17 23:51:51 | superfirms | 1 | 67641 | 3 | 1.376 | 49157.7 |
| 110 | 2020-01-05 02:48:33 | superfirms | 1 | 67641 | 3 | 1.236 | 54725.7 |
| 109 | 2019-12-31 16:26:01 | superfirms | 1 | 67641 | 3 | 1.343 | 50365.6 |
| 108 | 2019-11-29 05:09:53 | superfirms | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 107 | 2019-08-30 16:58:35 | superfirms | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 106 | 2019-06-09 04:15:04 | superfirms | 1 | 67641 | 3 | 2.123 | 31861.0 |
| 105 | 2019-05-18 14:09:54 | superfirms | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 104 | 2019-01-21 03:39:22 | superfirms | 1 | 67641 | 3 | 0.990 | 68324.2 |
| 103 | 2018-09-18 14:27:32 | superfirms | 1 | 67641 | 3 | 1.193 | 56698.2 |
| 102 | 2018-06-17 01:14:43 | superfirms | 1 | 67641 | 3 | 1.206 | 56087.1 |
| 101 | 2018-06-16 01:45:19 | superfirms | 1 | 67641 | 3 | 1.006 | 67237.6 |
| 100 | 2018-05-14 19:35:05 | superfirms | 1 | 67641 | 3 | 1.193 | 56698.2 |
| 99 | 2018-04-16 07:51:01 | superfirms | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 98 | 2018-01-03 21:10:12 | superfirms | 1 | 67641 | 3 | 1.783 | 37936.6 |
| 97 | 2017-12-10 22:58:55 | superfirms | 1 | 67641 | 3 | 1.890 | 35788.9 |
| 96 | 2017-11-17 20:25:13 | superfirms | 1 | 67641 | 3 | 2.016 | 33552.1 |
| 95 | 2017-11-13 11:22:23 | superfirms | 1 | 67641 | 3 | 3.906 | 17317.2 |
| 94 | 2017-10-30 21:47:39 | superfirms | 1 | 67641 | 3 | 1.460 | 46329.5 |
| 93 | 2017-07-17 08:24:08 | superfirms | 1 | 67641 | 3 | 1.360 | 49736.0 |
| 92 | 2017-06-13 02:40:52 | superfirms | 1 | 67641 | 3 | 1.650 | 40994.5 |
| 91 | 2017-04-14 20:57:31 | superfirms | 1 | 67641 | 3 | 1.436 | 47103.8 |
| 90 | 2017-01-28 04:16:38 | superfirms | 1 | 67641 | 3 | 1.656 | 40846.0 |
| 89 | 2017-01-09 08:16:46 | superfirms | 2 | 108824 | 5 | 5.130 | 21213.3 |
| 88 | 2017-01-08 10:22:28 | superfirms | 1 | 67641 | 3 | 1.366 | 49517.6 |
| 87 | 2017-01-06 05:36:14 | superfirms | 1 | 67641 | 3 | 1.273 | 53135.1 |
| 86 | 2017-01-02 06:15:09 | superfirms | 4 | 161450 | 147 | 25.150 | 6419.5 |
| 85 | 2017-01-01 22:18:25 | superfirms | 2 | 108824 | 5 | 3.903 | 27882.1 |
| 84 | 2016-12-31 14:05:08 | superfirms | 1 | 67641 | 3 | 1.323 | 51127.0 |
| 83 | 2016-12-30 18:23:58 | superfirms | 3 | 140603 | 29 | 10.613 | 13248.2 |
| 82 | 2016-12-30 10:30:14 | superfirms | 1 | 67641 | 3 | 1.273 | 53135.1 |