History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sourpusses"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 170 | 2024-04-19 12:56:28 | sourpusses | 4 | 161450 | 135 | 37.923 | 4257.3 |
| 169 | 2024-04-16 16:37:56 | sourpusses | 4 | 161450 | 135 | 34.813 | 4637.6 |
| 168 | 2024-04-16 16:35:55 | sourpusses | 3 | 140603 | 17 | 18.406 | 7639.0 |
| 167 | 2024-04-16 16:35:56 | sourpusses | 2 | 108824 | 5 | 13.186 | 8253.0 |
| 166 | 2024-04-16 16:22:20 | sourpusses | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 165 | 2024-04-14 05:55:47 | sourpusses | 4 | 161450 | 135 | 37.130 | 4348.2 |
| 164 | 2024-04-08 17:22:37 | sourpusses | 3 | 140603 | 17 | 18.253 | 7703.0 |
| 163 | 2024-04-08 17:22:38 | sourpusses | 2 | 108824 | 5 | 9.656 | 11270.1 |
| 162 | 2024-04-08 16:53:08 | sourpusses | 1 | 67641 | 1 | 1.326 | 51011.3 |
| 161 | 2024-04-05 06:52:35 | sourpusses | 4 | 161450 | 135 | 31.236 | 5168.7 |
| 160 | 2024-04-05 06:52:37 | sourpusses | 2 | 108824 | 5 | 14.110 | 7712.5 |
| 159 | 2024-04-05 06:52:36 | sourpusses | 3 | 140603 | 17 | 9.173 | 15327.9 |
| 158 | 2024-04-05 06:52:17 | sourpusses | 1 | 67641 | 1 | 4.250 | 15915.5 |
| 157 | 2024-04-02 12:46:04 | sourpusses | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 156 | 2024-03-25 23:51:38 | sourpusses | 3 | 140603 | 17 | 26.470 | 5311.8 |
| 155 | 2024-03-25 23:51:30 | sourpusses | 2 | 108824 | 5 | 4.970 | 21896.2 |
| 154 | 2024-03-25 23:22:09 | sourpusses | 1 | 67641 | 1 | 1.233 | 54858.9 |
| 153 | 2024-03-14 17:02:54 | sourpusses | 4 | 161450 | 135 | 32.440 | 4976.9 |
| 152 | 2024-03-11 20:12:50 | sourpusses | 4 | 161450 | 135 | 38.893 | 4151.1 |
| 151 | 2024-03-11 16:03:36 | sourpusses | 4 | 161450 | 135 | 36.690 | 4400.4 |
| 150 | 2024-03-05 15:36:39 | sourpusses | 1 | 67641 | 1 | 1.080 | 62630.6 |
| 149 | 2024-03-04 21:39:12 | sourpusses | 4 | 161450 | 135 | 37.656 | 4287.5 |
| 148 | 2024-03-04 21:39:09 | sourpusses | 3 | 140603 | 17 | 19.436 | 7234.2 |
| 147 | 2024-03-04 21:39:08 | sourpusses | 2 | 108824 | 5 | 9.750 | 11161.4 |
| 146 | 2024-03-04 21:03:16 | sourpusses | 1 | 67641 | 1 | 1.546 | 43752.3 |
| 145 | 2024-02-17 01:32:05 | sourpusses | 4 | 161450 | 135 | 13.360 | 12084.6 |
| 144 | 2024-02-14 21:15:00 | sourpusses | 1 | 67641 | 1 | 1.220 | 55443.4 |
| 143 | 2024-02-10 15:39:10 | sourpusses | 4 | 161450 | 135 | 43.736 | 3691.5 |
| 142 | 2024-02-10 02:04:33 | sourpusses | 4 | 161450 | 135 | 40.050 | 4031.2 |
| 141 | 2024-02-10 02:04:34 | sourpusses | 3 | 140603 | 17 | 15.860 | 8865.3 |
| 140 | 2024-02-10 02:04:33 | sourpusses | 2 | 108824 | 5 | 7.266 | 14977.2 |
| 139 | 2024-02-10 00:52:43 | sourpusses | 1 | 67641 | 1 | 1.296 | 52192.1 |
| 138 | 2024-02-06 04:57:50 | sourpusses | 1 | 67641 | 1 | 1.216 | 55625.8 |
| 137 | 2024-02-02 13:58:32 | sourpusses | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 136 | 2024-01-12 12:54:34 | sourpusses | 1 | 67641 | 1 | 1.090 | 62056.0 |
| 135 | 2023-12-24 07:34:03 | sourpusses | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 134 | 2023-12-05 00:46:40 | sourpusses | 1 | 67641 | 1 | 1.310 | 51634.4 |
| 133 | 2023-10-11 20:04:27 | sourpusses | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 132 | 2023-08-08 01:19:17 | sourpusses | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 131 | 2023-05-09 17:42:02 | sourpusses | 1 | 67641 | 1 | 1.266 | 53428.9 |
| 130 | 2023-05-05 17:52:38 | sourpusses | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 129 | 2023-03-01 08:21:57 | sourpusses | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 128 | 2022-12-27 01:59:05 | sourpusses | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 127 | 2022-09-15 03:07:03 | sourpusses | 1 | 67641 | 1 | 1.013 | 66773.0 |
| 126 | 2022-09-02 22:45:26 | sourpusses | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 125 | 2021-09-16 01:49:58 | sourpusses | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 124 | 2021-08-02 03:33:25 | sourpusses | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 123 | 2021-03-23 23:23:40 | sourpusses | 1 | 67641 | 1 | 1.063 | 63632.2 |
| 122 | 2021-02-02 08:17:46 | sourpusses | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 121 | 2021-01-31 17:14:18 | sourpusses | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 120 | 2020-12-18 03:58:25 | sourpusses | 1 | 67641 | 1 | 1.033 | 65480.2 |
| 119 | 2020-12-15 22:22:11 | sourpusses | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 118 | 2020-12-11 11:53:03 | sourpusses | 1 | 67641 | 1 | 1.203 | 56226.9 |
| 117 | 2020-12-09 17:45:21 | sourpusses | 1 | 67641 | 1 | 1.033 | 65480.2 |
| 116 | 2020-11-12 06:08:00 | sourpusses | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 115 | 2020-11-09 23:19:20 | sourpusses | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 114 | 2020-10-24 08:08:47 | sourpusses | 1 | 67641 | 1 | 1.143 | 59178.5 |
| 113 | 2020-09-03 11:40:44 | sourpusses | 1 | 67641 | 1 | 1.250 | 54112.8 |
| 112 | 2020-08-30 02:40:41 | sourpusses | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 111 | 2020-08-27 03:24:31 | sourpusses | 1 | 67641 | 1 | 1.063 | 63632.2 |
| 110 | 2020-03-25 21:30:45 | sourpusses | 1 | 67641 | 1 | 1.170 | 57812.8 |
| 109 | 2020-03-24 15:13:39 | sourpusses | 1 | 67641 | 1 | 1.220 | 55443.4 |
| 108 | 2020-03-21 20:12:18 | sourpusses | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 107 | 2020-02-15 01:59:53 | sourpusses | 1 | 67641 | 1 | 1.343 | 50365.6 |
| 106 | 2020-02-09 14:33:54 | sourpusses | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 105 | 2020-02-04 20:30:41 | sourpusses | 1 | 67641 | 1 | 3.826 | 17679.3 |
| 104 | 2020-02-03 18:22:39 | sourpusses | 1 | 67641 | 1 | 2.626 | 25758.2 |
| 103 | 2020-02-02 23:22:52 | sourpusses | 1 | 67641 | 1 | 2.610 | 25916.1 |
| 102 | 2020-01-31 15:05:26 | sourpusses | 1 | 67641 | 1 | 2.593 | 26086.0 |
| 101 | 2020-01-16 12:51:33 | sourpusses | 1 | 67641 | 1 | 2.093 | 32317.7 |
| 100 | 2020-01-06 19:01:10 | sourpusses | 1 | 67641 | 1 | 1.393 | 48557.8 |
| 99 | 2020-01-06 18:11:22 | sourpusses | 1 | 67641 | 1 | 1.296 | 52192.1 |
| 98 | 2019-12-01 20:45:30 | sourpusses | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 97 | 2019-08-30 10:37:02 | sourpusses | 1 | 67641 | 1 | 0.996 | 67912.7 |
| 96 | 2019-07-27 16:45:45 | sourpusses | 1 | 67641 | 1 | 1.020 | 66314.7 |
| 95 | 2019-07-23 09:13:44 | sourpusses | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 94 | 2019-07-18 14:18:33 | sourpusses | 1 | 67641 | 1 | 1.136 | 59543.1 |
| 93 | 2019-06-25 04:55:46 | sourpusses | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 92 | 2019-06-18 20:00:09 | sourpusses | 1 | 67641 | 1 | 1.096 | 61716.2 |
| 91 | 2019-06-05 10:46:44 | sourpusses | 1 | 67641 | 1 | 1.166 | 58011.1 |
| 90 | 2019-06-02 05:51:41 | sourpusses | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 89 | 2019-05-30 04:26:56 | sourpusses | 1 | 67641 | 1 | 1.060 | 63812.3 |
| 88 | 2019-05-15 03:37:00 | sourpusses | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 87 | 2019-01-11 02:38:42 | sourpusses | 1 | 67641 | 1 | 1.116 | 60610.2 |
| 86 | 2018-10-27 16:48:43 | sourpusses | 1 | 67641 | 1 | 1.136 | 59543.1 |
| 85 | 2018-10-08 13:53:26 | sourpusses | 2 | 108824 | 5 | 3.040 | 35797.4 |
| 84 | 2018-09-08 08:12:37 | sourpusses | 1 | 67641 | 1 | 2.310 | 29281.8 |
| 83 | 2018-08-28 22:42:34 | sourpusses | 1 | 67641 | 1 | 1.033 | 65480.2 |
| 82 | 2018-08-25 08:33:04 | sourpusses | 1 | 67641 | 1 | 2.086 | 32426.2 |
| 81 | 2018-08-19 04:02:27 | sourpusses | 1 | 67641 | 1 | 1.076 | 62863.4 |
| 80 | 2018-07-28 09:36:12 | sourpusses | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 79 | 2018-06-30 02:02:52 | sourpusses | 1 | 67641 | 1 | 1.200 | 56367.5 |
| 78 | 2018-06-29 08:58:42 | sourpusses | 1 | 67641 | 1 | 1.006 | 67237.6 |
| 77 | 2018-06-02 17:14:07 | sourpusses | 1 | 67641 | 1 | 1.026 | 65926.9 |
| 76 | 2018-06-02 12:03:53 | sourpusses | 1 | 67641 | 1 | 1.206 | 56087.1 |
| 75 | 2018-06-02 12:02:24 | sourpusses | 1 | 67641 | 1 | 1.176 | 57517.9 |
| 74 | 2017-11-13 08:16:24 | sourpusses | 1 | 67641 | 1 | 1.470 | 46014.3 |
| 73 | 2017-11-12 21:38:41 | sourpusses | 1 | 67641 | 1 | 1.420 | 47634.5 |
| 72 | 2017-11-10 18:17:16 | sourpusses | 1 | 67641 | 1 | 3.306 | 20460.1 |
| 71 | 2017-11-01 13:53:19 | sourpusses | 1 | 67641 | 1 | 2.283 | 29628.1 |