History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grandsirs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
147 | 2024-05-01 10:33:16 | grandsirs | 1 | 81242 | 4 | 2.860 | 28406.3 |
146 | 2024-05-01 06:06:04 | grandsirs | 1 | 81242 | 4 | 1.453 | 55913.3 |
145 | 2024-04-28 14:55:20 | grandsirs | 4 | 165329 | 331 | 14.080 | 11742.1 |
144 | 2024-04-13 16:29:08 | grandsirs | 1 | 81242 | 4 | 1.563 | 51978.2 |
143 | 2024-04-07 18:34:33 | grandsirs | 1 | 81242 | 4 | 3.203 | 25364.3 |
142 | 2024-04-05 17:25:15 | grandsirs | 1 | 81242 | 4 | 3.050 | 26636.7 |
141 | 2024-04-05 11:24:51 | grandsirs | 3 | 148641 | 37 | 22.610 | 6574.1 |
140 | 2024-04-05 11:24:50 | grandsirs | 2 | 121436 | 7 | 9.813 | 12375.0 |
139 | 2024-04-05 11:13:29 | grandsirs | 1 | 81242 | 4 | 5.420 | 14989.3 |
138 | 2024-03-31 02:17:16 | grandsirs | 1 | 81242 | 4 | 1.580 | 51419.0 |
137 | 2024-03-14 22:00:44 | grandsirs | 4 | 165329 | 331 | 26.390 | 6264.8 |
136 | 2024-03-14 17:38:37 | grandsirs | 4 | 165329 | 331 | 25.500 | 6483.5 |
135 | 2024-03-14 17:38:37 | grandsirs | 3 | 148641 | 37 | 19.780 | 7514.7 |
134 | 2024-03-14 17:38:38 | grandsirs | 2 | 121436 | 7 | 8.923 | 13609.3 |
133 | 2024-03-14 13:14:51 | grandsirs | 1 | 81242 | 4 | 1.250 | 64993.6 |
132 | 2024-03-07 03:37:54 | grandsirs | 1 | 81242 | 4 | 4.690 | 17322.4 |
131 | 2024-03-06 16:58:09 | grandsirs | 1 | 81242 | 4 | 1.373 | 59171.2 |
130 | 2024-03-02 11:19:20 | grandsirs | 1 | 81242 | 4 | 2.453 | 33119.4 |
129 | 2024-02-26 10:16:59 | grandsirs | 1 | 81242 | 4 | 1.453 | 55913.3 |
128 | 2024-02-04 16:34:51 | grandsirs | 1 | 81242 | 4 | 1.780 | 45641.6 |
127 | 2024-02-01 04:08:12 | grandsirs | 1 | 81242 | 4 | 1.436 | 56575.2 |
126 | 2024-01-30 17:00:12 | grandsirs | 2 | 121436 | 7 | 3.423 | 35476.5 |
125 | 2024-01-26 11:35:23 | grandsirs | 1 | 81242 | 4 | 1.406 | 57782.4 |
124 | 2024-01-12 00:15:05 | grandsirs | 1 | 81242 | 4 | 1.330 | 61084.2 |
123 | 2023-12-12 02:06:56 | grandsirs | 4 | 165329 | 331 | 10.673 | 15490.4 |
122 | 2023-12-03 11:28:31 | grandsirs | 1 | 81242 | 4 | 1.470 | 55266.7 |
121 | 2023-11-07 17:10:52 | grandsirs | 2 | 121436 | 7 | 3.406 | 35653.6 |
120 | 2023-11-06 08:40:35 | grandsirs | 1 | 81242 | 4 | 1.373 | 59171.2 |
119 | 2023-11-04 16:04:54 | grandsirs | 1 | 81242 | 4 | 1.453 | 55913.3 |
118 | 2023-10-26 03:47:11 | grandsirs | 1 | 81242 | 4 | 1.906 | 42624.3 |
117 | 2023-09-14 18:05:49 | grandsirs | 4 | 165329 | 331 | 17.656 | 9363.9 |
116 | 2023-09-09 03:00:33 | grandsirs | 4 | 165329 | 331 | 11.470 | 14414.0 |
115 | 2023-08-28 13:20:36 | grandsirs | 1 | 81242 | 4 | 1.263 | 64324.6 |
114 | 2023-08-11 02:07:46 | grandsirs | 2 | 121436 | 7 | 7.216 | 16828.7 |
113 | 2023-06-02 08:00:06 | grandsirs | 1 | 81242 | 4 | 1.326 | 61268.5 |
112 | 2023-05-29 09:01:44 | grandsirs | 1 | 81242 | 4 | 1.186 | 68500.8 |
111 | 2023-05-05 05:36:48 | grandsirs | 4 | 165329 | 331 | 12.343 | 13394.6 |
110 | 2023-04-25 07:47:10 | grandsirs | 4 | 165329 | 331 | 10.720 | 15422.5 |
109 | 2023-04-22 08:57:21 | grandsirs | 2 | 121436 | 7 | 3.063 | 39646.1 |
108 | 2023-03-27 13:39:33 | grandsirs | 4 | 165329 | 331 | 12.673 | 13045.8 |
107 | 2023-03-24 05:15:13 | grandsirs | 1 | 81242 | 4 | 1.313 | 61875.1 |
106 | 2023-03-04 09:53:31 | grandsirs | 4 | 165329 | 331 | 10.283 | 16077.9 |
105 | 2023-02-16 17:53:39 | grandsirs | 4 | 165329 | 331 | 10.296 | 16057.6 |
104 | 2023-01-25 19:40:55 | grandsirs | 2 | 121436 | 7 | 3.033 | 40038.2 |
103 | 2023-01-19 03:03:40 | grandsirs | 1 | 81242 | 4 | 1.236 | 65729.8 |
102 | 2023-01-08 06:27:32 | grandsirs | 1 | 81242 | 4 | 1.326 | 61268.5 |
101 | 2023-01-08 02:07:13 | grandsirs | 4 | 165329 | 331 | 12.826 | 12890.1 |
100 | 2022-12-11 13:56:22 | grandsirs | 4 | 165329 | 331 | 10.220 | 16177.0 |
99 | 2022-12-05 16:43:08 | grandsirs | 4 | 165329 | 331 | 10.376 | 15933.8 |
98 | 2022-11-07 03:57:01 | grandsirs | 2 | 121436 | 7 | 3.126 | 38847.1 |
97 | 2022-10-20 20:54:00 | grandsirs | 4 | 165329 | 331 | 10.643 | 15534.1 |
96 | 2022-10-04 16:36:29 | grandsirs | 1 | 81242 | 4 | 1.220 | 66591.8 |
95 | 2022-09-26 15:26:15 | grandsirs | 4 | 165329 | 331 | 10.406 | 15887.9 |
94 | 2022-09-02 22:18:21 | grandsirs | 1 | 81242 | 4 | 1.203 | 67532.8 |
93 | 2022-08-30 16:32:09 | grandsirs | 1 | 81242 | 4 | 1.280 | 63470.3 |
92 | 2022-08-25 07:13:54 | grandsirs | 4 | 165329 | 331 | 10.563 | 15651.7 |
91 | 2022-07-30 00:09:37 | grandsirs | 4 | 165329 | 331 | 11.343 | 14575.4 |
90 | 2022-06-10 05:12:33 | grandsirs | 2 | 121436 | 7 | 3.093 | 39261.6 |
89 | 2022-05-18 06:19:14 | grandsirs | 1 | 81242 | 4 | 1.373 | 59171.2 |
88 | 2022-03-26 11:22:27 | grandsirs | 1 | 81242 | 4 | 1.216 | 66810.9 |
87 | 2021-11-12 08:31:16 | grandsirs | 1 | 81242 | 4 | 1.250 | 64993.6 |
86 | 2021-07-26 14:55:54 | grandsirs | 1 | 81242 | 4 | 1.266 | 64172.2 |
85 | 2021-04-04 12:07:54 | grandsirs | 1 | 81242 | 4 | 1.220 | 66591.8 |
84 | 2021-03-08 21:17:14 | grandsirs | 1 | 81242 | 4 | 1.500 | 54161.3 |
83 | 2021-02-19 18:40:28 | grandsirs | 1 | 81242 | 4 | 1.436 | 56575.2 |
82 | 2020-10-31 04:40:16 | grandsirs | 1 | 81242 | 4 | 1.233 | 65889.7 |
81 | 2020-03-30 07:42:55 | grandsirs | 1 | 81242 | 4 | 1.310 | 62016.8 |
80 | 2020-03-25 03:44:36 | grandsirs | 1 | 81242 | 4 | 1.266 | 64172.2 |
79 | 2020-02-29 09:37:24 | grandsirs | 1 | 81242 | 4 | 2.326 | 34927.8 |
78 | 2020-02-17 11:54:32 | grandsirs | 1 | 81242 | 4 | 2.953 | 27511.7 |
77 | 2020-02-07 13:31:13 | grandsirs | 1 | 81242 | 4 | 3.110 | 26122.8 |
76 | 2020-01-31 11:37:28 | grandsirs | 1 | 81242 | 4 | 1.610 | 50460.9 |
75 | 2020-01-31 08:55:30 | grandsirs | 1 | 81242 | 4 | 1.576 | 51549.5 |
74 | 2020-01-30 20:51:10 | grandsirs | 1 | 81242 | 4 | 2.390 | 33992.5 |
73 | 2020-01-22 03:08:34 | grandsirs | 1 | 81242 | 4 | 3.000 | 27080.7 |
72 | 2020-01-18 00:56:24 | grandsirs | 1 | 81242 | 4 | 1.436 | 56575.2 |
71 | 2020-01-05 04:57:12 | grandsirs | 1 | 81242 | 4 | 1.500 | 54161.3 |
70 | 2020-01-02 07:28:04 | grandsirs | 1 | 81242 | 4 | 1.500 | 54161.3 |
69 | 2019-12-19 06:58:40 | grandsirs | 1 | 81242 | 4 | 1.423 | 57092.1 |
68 | 2019-09-18 00:22:27 | grandsirs | 1 | 81242 | 4 | 1.300 | 62493.8 |
67 | 2019-06-12 03:44:30 | grandsirs | 1 | 81242 | 4 | 1.353 | 60045.8 |
66 | 2019-02-21 13:36:02 | grandsirs | 1 | 81242 | 4 | 1.263 | 64324.6 |
65 | 2019-01-25 03:32:50 | grandsirs | 1 | 81242 | 4 | 1.323 | 61407.4 |
64 | 2018-10-29 21:03:19 | grandsirs | 1 | 81242 | 4 | 1.260 | 64477.8 |
63 | 2018-09-16 14:28:30 | grandsirs | 1 | 81242 | 4 | 1.360 | 59736.8 |
62 | 2018-07-22 17:47:53 | grandsirs | 1 | 81242 | 4 | 1.510 | 53802.6 |
61 | 2017-12-26 16:33:53 | grandsirs | 1 | 81242 | 4 | 2.053 | 39572.3 |
60 | 2017-12-21 11:36:47 | grandsirs | 1 | 81242 | 4 | 2.266 | 35852.6 |
59 | 2017-07-26 15:58:33 | grandsirs | 1 | 81242 | 4 | 1.676 | 48473.7 |
58 | 2017-06-25 03:11:27 | grandsirs | 1 | 81242 | 4 | 1.580 | 51419.0 |
57 | 2017-01-01 04:16:21 | grandsirs | 1 | 81242 | 4 | 1.466 | 55417.5 |
56 | 2016-12-21 02:15:52 | grandsirs | 1 | 81242 | 4 | 1.520 | 53448.7 |
55 | 2016-10-21 16:54:20 | grandsirs | 1 | 81242 | 4 | 1.703 | 47705.2 |
54 | 2016-10-19 01:43:47 | grandsirs | 1 | 81242 | 4 | 4.083 | 19897.6 |
53 | 2016-09-15 13:48:10 | grandsirs | 1 | 81242 | 4 | 1.956 | 41534.8 |
52 | 2016-08-17 13:46:23 | grandsirs | 1 | 81242 | 4 | 1.596 | 50903.5 |
51 | 2016-08-12 11:17:04 | grandsirs | 1 | 81242 | 4 | 2.013 | 40358.7 |
50 | 2016-08-02 09:41:29 | grandsirs | 2 | 121436 | 7 | 12.576 | 9656.2 |
49 | 2016-07-27 20:38:51 | grandsirs | 4 | 165329 | 331 | 17.510 | 9442.0 |
48 | 2016-07-26 00:13:53 | grandsirs | 1 | 81242 | 4 | 2.130 | 38141.8 |