History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"poorhouses"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
164 | 2024-04-08 12:32:13 | poorhouses | 1 | 67641 | 2 | 1.046 | 64666.3 |
163 | 2024-04-03 14:56:14 | poorhouses | 4 | 161450 | 189 | 19.330 | 8352.3 |
162 | 2024-04-03 14:55:44 | poorhouses | 4 | 161450 | 189 | 31.470 | 5130.3 |
161 | 2024-03-31 20:27:31 | poorhouses | 2 | 108824 | 6 | 13.046 | 8341.6 |
160 | 2024-03-31 20:27:34 | poorhouses | 3 | 140603 | 34 | 7.750 | 18142.3 |
159 | 2024-03-31 20:19:16 | poorhouses | 1 | 67641 | 2 | 1.390 | 48662.6 |
158 | 2024-03-27 07:17:05 | poorhouses | 1 | 67641 | 2 | 1.313 | 51516.4 |
157 | 2024-03-26 17:28:05 | poorhouses | 1 | 67641 | 2 | 2.310 | 29281.8 |
156 | 2024-03-26 09:56:32 | poorhouses | 4 | 161450 | 189 | 22.173 | 7281.4 |
155 | 2024-03-26 09:56:09 | poorhouses | 3 | 140603 | 34 | 7.860 | 17888.4 |
154 | 2024-03-26 09:56:05 | poorhouses | 2 | 108824 | 6 | 9.873 | 11022.4 |
153 | 2024-03-24 18:40:42 | poorhouses | 4 | 161450 | 189 | 27.736 | 5821.0 |
152 | 2024-03-24 18:40:46 | poorhouses | 3 | 140603 | 34 | 18.563 | 7574.4 |
151 | 2024-03-24 18:40:44 | poorhouses | 2 | 108824 | 6 | 14.626 | 7440.4 |
150 | 2024-03-24 16:39:59 | poorhouses | 1 | 67641 | 2 | 1.250 | 54112.8 |
149 | 2024-02-27 22:07:09 | poorhouses | 1 | 67641 | 2 | 1.250 | 54112.8 |
148 | 2024-02-21 01:17:11 | poorhouses | 1 | 67641 | 2 | 1.390 | 48662.6 |
147 | 2024-02-10 07:03:30 | poorhouses | 1 | 67641 | 2 | 3.673 | 18415.7 |
146 | 2024-02-07 14:22:30 | poorhouses | 1 | 67641 | 2 | 1.063 | 63632.2 |
145 | 2024-02-07 01:53:59 | poorhouses | 1 | 67641 | 2 | 2.670 | 25333.7 |
144 | 2024-01-29 08:59:30 | poorhouses | 1 | 67641 | 2 | 1.233 | 54858.9 |
143 | 2024-01-28 11:43:16 | poorhouses | 1 | 67641 | 2 | 2.046 | 33060.1 |
142 | 2024-01-18 15:10:24 | poorhouses | 3 | 140603 | 34 | 5.436 | 25865.2 |
141 | 2024-01-17 18:07:25 | poorhouses | 3 | 140603 | 34 | 5.626 | 24991.6 |
140 | 2024-01-10 14:19:12 | poorhouses | 2 | 108824 | 6 | 2.733 | 39818.5 |
139 | 2024-01-03 23:09:47 | poorhouses | 1 | 67641 | 2 | 1.203 | 56226.9 |
138 | 2023-12-06 16:48:40 | poorhouses | 3 | 140603 | 34 | 14.343 | 9802.9 |
137 | 2023-12-04 16:33:05 | poorhouses | 4 | 161450 | 189 | 9.860 | 16374.2 |
136 | 2023-11-30 03:11:59 | poorhouses | 1 | 67641 | 2 | 1.016 | 66575.8 |
135 | 2023-10-27 13:39:01 | poorhouses | 3 | 140603 | 34 | 5.410 | 25989.5 |
134 | 2023-10-15 18:38:35 | poorhouses | 2 | 108824 | 6 | 2.656 | 40972.9 |
133 | 2023-09-20 06:18:06 | poorhouses | 1 | 67641 | 2 | 1.046 | 64666.3 |
132 | 2023-09-14 16:39:11 | poorhouses | 1 | 67641 | 2 | 1.063 | 63632.2 |
131 | 2023-09-02 11:41:14 | poorhouses | 4 | 161450 | 189 | 9.406 | 17164.6 |
130 | 2023-08-05 21:48:51 | poorhouses | 3 | 140603 | 34 | 6.126 | 22951.8 |
129 | 2023-07-26 19:29:53 | poorhouses | 2 | 108824 | 6 | 2.953 | 36852.0 |
128 | 2023-05-24 05:49:36 | poorhouses | 1 | 67641 | 2 | 1.030 | 65670.9 |
127 | 2023-05-22 09:53:03 | poorhouses | 4 | 161450 | 189 | 10.016 | 16119.2 |
126 | 2023-05-08 11:17:34 | poorhouses | 1 | 67641 | 2 | 2.033 | 33271.5 |
125 | 2023-04-13 06:10:38 | poorhouses | 3 | 140603 | 34 | 5.313 | 26464.0 |
124 | 2023-04-06 14:46:37 | poorhouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
123 | 2023-04-05 22:30:29 | poorhouses | 2 | 108824 | 6 | 2.953 | 36852.0 |
122 | 2023-03-20 11:54:16 | poorhouses | 1 | 67641 | 2 | 1.143 | 59178.5 |
121 | 2023-03-04 09:52:57 | poorhouses | 4 | 161450 | 189 | 9.266 | 17423.9 |
120 | 2023-01-24 12:59:48 | poorhouses | 1 | 67641 | 2 | 1.190 | 56841.2 |
119 | 2023-01-20 07:02:49 | poorhouses | 1 | 67641 | 2 | 1.016 | 66575.8 |
118 | 2023-01-15 20:29:42 | poorhouses | 3 | 140603 | 34 | 5.753 | 24439.9 |
117 | 2023-01-05 16:40:09 | poorhouses | 2 | 108824 | 6 | 2.610 | 41695.0 |
116 | 2022-12-11 15:27:49 | poorhouses | 4 | 161450 | 189 | 9.220 | 17510.8 |
115 | 2022-11-16 10:38:07 | poorhouses | 1 | 67641 | 2 | 1.046 | 64666.3 |
114 | 2022-10-18 07:39:21 | poorhouses | 3 | 140603 | 34 | 5.483 | 25643.4 |
113 | 2022-10-01 04:20:06 | poorhouses | 1 | 67641 | 2 | 1.030 | 65670.9 |
112 | 2022-09-18 14:39:15 | poorhouses | 1 | 67641 | 2 | 1.123 | 60232.4 |
111 | 2022-09-11 15:39:31 | poorhouses | 2 | 108824 | 6 | 2.606 | 41759.0 |
110 | 2022-07-07 22:56:06 | poorhouses | 1 | 67641 | 2 | 1.030 | 65670.9 |
109 | 2022-07-01 17:30:00 | poorhouses | 4 | 161450 | 189 | 9.706 | 16634.0 |
108 | 2022-05-20 21:06:32 | poorhouses | 3 | 140603 | 34 | 5.456 | 25770.3 |
107 | 2022-05-18 13:46:56 | poorhouses | 1 | 67641 | 2 | 1.093 | 61885.6 |
106 | 2022-05-05 17:48:32 | poorhouses | 1 | 67641 | 2 | 1.220 | 55443.4 |
105 | 2022-03-12 16:57:18 | poorhouses | 1 | 67641 | 2 | 1.173 | 57665.0 |
104 | 2022-03-10 13:37:03 | poorhouses | 1 | 67641 | 2 | 1.190 | 56841.2 |
103 | 2022-02-13 00:05:22 | poorhouses | 4 | 161450 | 189 | 10.470 | 15420.2 |
102 | 2022-01-05 03:29:16 | poorhouses | 1 | 67641 | 2 | 1.110 | 60937.8 |
101 | 2021-12-25 03:29:07 | poorhouses | 1 | 67641 | 2 | 1.203 | 56226.9 |
100 | 2021-11-11 17:14:34 | poorhouses | 4 | 161450 | 189 | 11.220 | 14389.5 |
99 | 2021-10-27 22:55:20 | poorhouses | 1 | 67641 | 2 | 1.110 | 60937.8 |
98 | 2021-10-25 21:32:10 | poorhouses | 1 | 67641 | 2 | 1.190 | 56841.2 |
97 | 2021-09-28 22:51:30 | poorhouses | 1 | 67641 | 2 | 1.013 | 66773.0 |
96 | 2021-09-19 11:02:48 | poorhouses | 1 | 67641 | 2 | 1.173 | 57665.0 |
95 | 2021-03-21 14:15:19 | poorhouses | 1 | 67641 | 2 | 3.720 | 18183.1 |
94 | 2020-11-11 18:49:35 | poorhouses | 1 | 67641 | 2 | 1.033 | 65480.2 |
93 | 2020-10-21 23:45:48 | poorhouses | 1 | 67641 | 2 | 1.110 | 60937.8 |
92 | 2020-03-25 22:27:22 | poorhouses | 1 | 67641 | 2 | 1.186 | 57032.9 |
91 | 2020-03-24 19:42:34 | poorhouses | 1 | 67641 | 2 | 1.266 | 53428.9 |
90 | 2020-03-23 03:13:03 | poorhouses | 1 | 67641 | 2 | 1.110 | 60937.8 |
89 | 2020-03-05 20:21:42 | poorhouses | 1 | 67641 | 2 | 1.186 | 57032.9 |
88 | 2020-02-28 10:18:48 | poorhouses | 1 | 67641 | 2 | 1.330 | 50857.9 |
87 | 2020-02-15 00:45:46 | poorhouses | 1 | 67641 | 2 | 2.453 | 27574.8 |
86 | 2020-02-07 00:58:23 | poorhouses | 1 | 67641 | 2 | 2.596 | 26055.9 |
85 | 2020-02-01 05:33:30 | poorhouses | 1 | 67641 | 2 | 2.656 | 25467.2 |
84 | 2020-01-27 19:41:28 | poorhouses | 1 | 67641 | 2 | 1.296 | 52192.1 |
83 | 2020-01-23 18:21:08 | poorhouses | 1 | 67641 | 2 | 3.423 | 19760.7 |
82 | 2020-01-23 17:28:08 | poorhouses | 1 | 67641 | 2 | 2.406 | 28113.5 |
81 | 2020-01-15 18:47:46 | poorhouses | 1 | 67641 | 2 | 1.356 | 49882.7 |
80 | 2020-01-04 21:11:36 | poorhouses | 1 | 67641 | 2 | 1.440 | 46972.9 |
79 | 2019-12-31 01:19:32 | poorhouses | 1 | 67641 | 2 | 2.440 | 27721.7 |
78 | 2019-12-17 16:39:02 | poorhouses | 1 | 67641 | 2 | 1.110 | 60937.8 |
77 | 2019-09-16 07:38:59 | poorhouses | 1 | 67641 | 2 | 1.123 | 60232.4 |
76 | 2019-07-23 23:04:42 | poorhouses | 1 | 67641 | 2 | 0.976 | 69304.3 |
75 | 2019-06-10 11:07:26 | poorhouses | 1 | 67641 | 2 | 1.180 | 57322.9 |
74 | 2019-02-22 23:17:22 | poorhouses | 1 | 67641 | 2 | 1.043 | 64852.3 |
73 | 2018-10-31 05:09:51 | poorhouses | 1 | 67641 | 2 | 1.280 | 52844.5 |
72 | 2018-09-06 13:58:38 | poorhouses | 1 | 67641 | 2 | 1.363 | 49626.6 |
71 | 2018-09-03 00:50:41 | poorhouses | 1 | 67641 | 2 | 1.020 | 66314.7 |
70 | 2018-07-24 03:10:37 | poorhouses | 1 | 67641 | 2 | 1.120 | 60393.8 |
69 | 2018-06-20 03:09:13 | poorhouses | 1 | 67641 | 2 | 1.156 | 58513.0 |
68 | 2018-06-15 04:46:36 | poorhouses | 1 | 67641 | 2 | 0.973 | 69518.0 |
67 | 2018-05-28 00:47:54 | poorhouses | 1 | 67641 | 2 | 1.116 | 60610.2 |
66 | 2018-05-09 05:25:35 | poorhouses | 1 | 67641 | 2 | 1.023 | 66120.2 |
65 | 2018-04-07 03:22:03 | poorhouses | 1 | 67641 | 2 | 1.400 | 48315.0 |