History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"underpart"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
141 | 2024-04-10 16:58:48 | underpart | 4 | 165329 | 267 | 60.880 | 2715.7 |
140 | 2024-03-31 18:23:04 | underpart | 3 | 148641 | 72 | 22.440 | 6623.9 |
139 | 2024-03-31 18:23:06 | underpart | 2 | 121436 | 14 | 13.266 | 9153.9 |
138 | 2024-03-31 18:14:34 | underpart | 1 | 81242 | 2 | 1.330 | 61084.2 |
137 | 2024-03-29 23:04:48 | underpart | 2 | 121436 | 14 | 12.360 | 9824.9 |
136 | 2024-03-29 21:47:31 | underpart | 4 | 165329 | 267 | 36.363 | 4546.6 |
135 | 2024-03-29 21:36:10 | underpart | 1 | 81242 | 2 | 3.873 | 20976.5 |
134 | 2024-03-28 09:41:33 | underpart | 3 | 148641 | 72 | 19.690 | 7549.1 |
133 | 2024-03-28 09:41:34 | underpart | 4 | 165329 | 267 | 15.296 | 10808.6 |
132 | 2024-03-28 09:41:33 | underpart | 2 | 121436 | 14 | 8.236 | 14744.5 |
131 | 2024-03-28 09:38:13 | underpart | 1 | 81242 | 2 | 1.436 | 56575.2 |
130 | 2024-03-12 04:15:12 | underpart | 1 | 81242 | 2 | 1.310 | 62016.8 |
129 | 2024-03-07 13:11:52 | underpart | 1 | 81242 | 2 | 1.420 | 57212.7 |
128 | 2024-02-29 06:10:35 | underpart | 1 | 81242 | 2 | 1.420 | 57212.7 |
127 | 2024-02-07 08:14:22 | underpart | 1 | 81242 | 2 | 1.440 | 56418.1 |
126 | 2024-02-02 16:42:39 | underpart | 1 | 81242 | 2 | 1.186 | 68500.8 |
125 | 2024-01-31 14:52:11 | underpart | 1 | 81242 | 2 | 1.626 | 49964.3 |
124 | 2024-01-30 00:47:12 | underpart | 1 | 81242 | 2 | 1.453 | 55913.3 |
123 | 2023-12-21 01:15:56 | underpart | 1 | 81242 | 2 | 1.250 | 64993.6 |
122 | 2023-12-11 08:46:33 | underpart | 1 | 81242 | 2 | 1.220 | 66591.8 |
121 | 2023-11-26 01:11:41 | underpart | 1 | 81242 | 2 | 1.313 | 61875.1 |
120 | 2023-11-24 18:19:15 | underpart | 1 | 81242 | 2 | 1.190 | 68270.6 |
119 | 2023-10-26 20:48:17 | underpart | 1 | 81242 | 2 | 4.986 | 16294.0 |
118 | 2023-09-10 22:19:30 | underpart | 1 | 81242 | 2 | 1.296 | 62686.7 |
117 | 2023-07-16 10:18:40 | underpart | 1 | 81242 | 2 | 1.216 | 66810.9 |
116 | 2023-06-25 05:18:09 | underpart | 1 | 81242 | 2 | 1.390 | 58447.5 |
115 | 2023-04-06 12:08:17 | underpart | 1 | 81242 | 2 | 1.346 | 60358.1 |
114 | 2023-03-08 09:51:18 | underpart | 1 | 81242 | 2 | 1.250 | 64993.6 |
113 | 2023-01-20 02:09:36 | underpart | 1 | 81242 | 2 | 1.186 | 68500.8 |
112 | 2022-11-16 09:28:53 | underpart | 1 | 81242 | 2 | 1.410 | 57618.4 |
111 | 2022-10-22 13:08:29 | underpart | 1 | 81242 | 2 | 1.326 | 61268.5 |
110 | 2022-07-08 15:14:47 | underpart | 1 | 81242 | 2 | 1.186 | 68500.8 |
109 | 2022-06-06 12:16:34 | underpart | 1 | 81242 | 2 | 1.220 | 66591.8 |
108 | 2022-01-22 18:28:36 | underpart | 1 | 81242 | 2 | 1.373 | 59171.2 |
107 | 2021-12-22 01:56:54 | underpart | 1 | 81242 | 2 | 1.436 | 56575.2 |
106 | 2021-11-22 06:06:27 | underpart | 1 | 81242 | 2 | 1.516 | 53589.7 |
105 | 2021-09-18 14:45:55 | underpart | 1 | 81242 | 2 | 1.280 | 63470.3 |
104 | 2021-09-17 09:18:35 | underpart | 1 | 81242 | 2 | 1.406 | 57782.4 |
103 | 2021-09-14 03:58:45 | underpart | 1 | 81242 | 2 | 1.203 | 67532.8 |
102 | 2021-08-03 05:42:35 | underpart | 1 | 81242 | 2 | 1.186 | 68500.8 |
101 | 2021-05-28 02:13:05 | underpart | 1 | 81242 | 2 | 1.420 | 57212.7 |
100 | 2021-05-24 16:43:26 | underpart | 1 | 81242 | 2 | 2.203 | 36877.9 |
99 | 2021-04-24 18:56:54 | underpart | 1 | 81242 | 2 | 1.516 | 53589.7 |
98 | 2021-03-26 16:16:20 | underpart | 1 | 81242 | 2 | 1.390 | 58447.5 |
97 | 2021-02-19 03:47:01 | underpart | 1 | 81242 | 2 | 1.406 | 57782.4 |
96 | 2021-02-04 12:10:37 | underpart | 4 | 165329 | 267 | 11.393 | 14511.5 |
95 | 2021-01-09 23:15:06 | underpart | 1 | 81242 | 2 | 1.483 | 54782.2 |
94 | 2020-11-10 06:12:27 | underpart | 1 | 81242 | 2 | 1.250 | 64993.6 |
93 | 2020-10-30 14:25:15 | underpart | 1 | 81242 | 2 | 2.453 | 33119.4 |
92 | 2020-10-22 07:48:12 | underpart | 1 | 81242 | 2 | 1.203 | 67532.8 |
91 | 2020-10-16 12:32:14 | underpart | 1 | 81242 | 2 | 1.220 | 66591.8 |
90 | 2020-09-24 14:26:06 | underpart | 1 | 81242 | 2 | 1.203 | 67532.8 |
89 | 2020-07-15 22:15:34 | underpart | 1 | 81242 | 2 | 1.283 | 63321.9 |
88 | 2020-04-11 05:15:53 | underpart | 1 | 81242 | 2 | 1.263 | 64324.6 |
87 | 2020-03-23 19:49:07 | underpart | 1 | 81242 | 2 | 1.390 | 58447.5 |
86 | 2020-02-26 09:00:31 | underpart | 1 | 81242 | 2 | 1.423 | 57092.1 |
85 | 2020-02-25 23:06:08 | underpart | 1 | 81242 | 2 | 1.470 | 55266.7 |
84 | 2020-02-06 19:40:54 | underpart | 1 | 81242 | 2 | 4.406 | 18438.9 |
83 | 2020-01-31 17:51:37 | underpart | 1 | 81242 | 2 | 1.483 | 54782.2 |
82 | 2020-01-30 10:07:25 | underpart | 1 | 81242 | 2 | 2.953 | 27511.7 |
81 | 2020-01-30 02:50:19 | underpart | 1 | 81242 | 2 | 3.046 | 26671.7 |
80 | 2020-01-26 12:16:21 | underpart | 1 | 81242 | 2 | 1.576 | 51549.5 |
79 | 2020-01-22 12:30:12 | underpart | 1 | 81242 | 2 | 1.530 | 53099.3 |
78 | 2020-01-08 22:06:07 | underpart | 1 | 81242 | 2 | 1.936 | 41963.8 |
77 | 2020-01-03 14:01:04 | underpart | 1 | 81242 | 2 | 1.343 | 60492.9 |
76 | 2020-01-02 23:25:19 | underpart | 1 | 81242 | 2 | 2.593 | 31331.3 |
75 | 2019-12-27 10:52:30 | underpart | 1 | 81242 | 2 | 1.420 | 57212.7 |
74 | 2019-09-26 19:51:32 | underpart | 1 | 81242 | 2 | 1.210 | 67142.1 |
73 | 2019-09-20 12:06:35 | underpart | 1 | 81242 | 2 | 1.126 | 72151.0 |
72 | 2019-06-14 15:39:23 | underpart | 1 | 81242 | 2 | 1.210 | 67142.1 |
71 | 2019-02-24 02:16:49 | underpart | 1 | 81242 | 2 | 1.233 | 65889.7 |
70 | 2019-02-05 21:22:09 | underpart | 1 | 81242 | 2 | 1.180 | 68849.2 |
69 | 2019-01-28 15:34:36 | underpart | 1 | 81242 | 2 | 1.216 | 66810.9 |
68 | 2019-01-05 13:55:06 | underpart | 1 | 81242 | 2 | 1.220 | 66591.8 |
67 | 2019-01-03 15:14:42 | underpart | 1 | 81242 | 2 | 1.293 | 62832.2 |
66 | 2018-11-19 03:30:29 | underpart | 1 | 81242 | 2 | 1.153 | 70461.4 |
65 | 2018-11-01 06:51:33 | underpart | 1 | 81242 | 2 | 1.193 | 68098.9 |
64 | 2018-09-18 11:34:47 | underpart | 1 | 81242 | 2 | 1.450 | 56029.0 |
63 | 2018-07-19 01:07:52 | underpart | 1 | 81242 | 2 | 1.366 | 59474.4 |
62 | 2018-07-07 10:46:18 | underpart | 1 | 81242 | 2 | 1.180 | 68849.2 |
61 | 2018-07-02 22:38:13 | underpart | 1 | 81242 | 2 | 1.226 | 66265.9 |
60 | 2018-06-27 20:27:17 | underpart | 1 | 81242 | 2 | 1.326 | 61268.5 |
59 | 2018-03-25 19:56:19 | underpart | 1 | 81242 | 2 | 2.150 | 37787.0 |
58 | 2018-03-25 01:56:18 | underpart | 1 | 81242 | 2 | 1.673 | 48560.7 |
57 | 2018-03-19 14:33:56 | underpart | 1 | 81242 | 2 | 1.943 | 41812.7 |
56 | 2018-01-03 21:05:39 | underpart | 1 | 81242 | 2 | 2.183 | 37215.8 |
55 | 2017-12-05 23:39:37 | underpart | 1 | 81242 | 2 | 1.753 | 46344.6 |
54 | 2017-11-09 15:24:28 | underpart | 1 | 81242 | 2 | 1.960 | 41450.0 |
53 | 2017-10-22 19:30:58 | underpart | 1 | 81242 | 2 | 2.380 | 34135.3 |
52 | 2017-10-07 16:28:55 | underpart | 1 | 81242 | 2 | 2.216 | 36661.6 |
51 | 2017-08-24 06:40:19 | underpart | 1 | 81242 | 2 | 2.150 | 37787.0 |
50 | 2017-07-05 09:06:14 | underpart | 1 | 81242 | 2 | 1.613 | 50367.0 |
49 | 2017-05-19 18:29:39 | underpart | 1 | 81242 | 2 | 1.740 | 46690.8 |
48 | 2017-04-07 18:44:39 | underpart | 1 | 81242 | 2 | 1.750 | 46424.0 |
47 | 2017-03-13 04:51:13 | underpart | 1 | 81242 | 2 | 1.720 | 47233.7 |
46 | 2017-02-13 20:02:47 | underpart | 1 | 81242 | 2 | 1.843 | 44081.4 |
45 | 2017-02-13 20:01:33 | underpart | 1 | 81242 | 2 | 1.913 | 42468.4 |
44 | 2017-02-13 18:43:45 | underpart | 1 | 81242 | 2 | 1.543 | 52652.0 |
43 | 2016-12-09 06:25:12 | underpart | 1 | 81242 | 2 | 1.806 | 44984.5 |
42 | 2016-11-09 08:45:18 | underpart | 1 | 81242 | 2 | 1.890 | 42985.2 |