History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grandchild"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 137 | 2024-04-07 18:35:00 | grandchild | 1 | 67641 | 1 | 2.000 | 33820.5 |
| 136 | 2024-04-05 09:40:27 | grandchild | 1 | 67641 | 1 | 1.266 | 53428.9 |
| 135 | 2024-03-28 11:23:10 | grandchild | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 134 | 2024-03-27 13:39:31 | grandchild | 4 | 161450 | 37 | 14.376 | 11230.5 |
| 133 | 2024-03-26 20:02:16 | grandchild | 5 | 173545 | 341 | 64.016 | 2711.0 |
| 132 | 2024-03-26 20:02:12 | grandchild | 4 | 161450 | 37 | 36.783 | 4389.3 |
| 131 | 2024-03-26 20:02:08 | grandchild | 2 | 108824 | 1 | 8.813 | 12348.1 |
| 130 | 2024-03-26 20:02:03 | grandchild | 3 | 140603 | 5 | 8.720 | 16124.2 |
| 129 | 2024-03-26 17:53:13 | grandchild | 1 | 67641 | 1 | 1.143 | 59178.5 |
| 128 | 2024-03-26 17:53:13 | grandchild | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 127 | 2024-03-01 03:59:00 | grandchild | 1 | 67641 | 1 | 1.126 | 60071.9 |
| 126 | 2024-02-06 08:48:58 | grandchild | 1 | 67641 | 1 | 1.966 | 34405.4 |
| 125 | 2024-02-03 04:10:38 | grandchild | 1 | 67641 | 1 | 1.170 | 57812.8 |
| 124 | 2024-02-02 16:24:44 | grandchild | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 123 | 2023-11-12 15:49:47 | grandchild | 1 | 67641 | 1 | 1.920 | 35229.7 |
| 122 | 2023-05-26 23:56:19 | grandchild | 1 | 67641 | 1 | 0.970 | 69733.0 |
| 121 | 2022-12-25 02:46:21 | grandchild | 1 | 67641 | 1 | 1.093 | 61885.6 |
| 120 | 2022-07-14 05:19:42 | grandchild | 1 | 67641 | 1 | 1.126 | 60071.9 |
| 119 | 2022-02-03 21:43:23 | grandchild | 1 | 67641 | 1 | 1.266 | 53428.9 |
| 118 | 2021-11-05 11:48:32 | grandchild | 1 | 67641 | 1 | 2.360 | 28661.4 |
| 117 | 2021-09-15 16:36:16 | grandchild | 1 | 67641 | 1 | 0.970 | 69733.0 |
| 116 | 2021-06-23 05:56:08 | grandchild | 1 | 67641 | 1 | 1.360 | 49736.0 |
| 115 | 2021-05-23 02:27:22 | grandchild | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 114 | 2021-02-03 22:39:46 | grandchild | 1 | 67641 | 1 | 1.063 | 63632.2 |
| 113 | 2020-11-08 18:50:12 | grandchild | 1 | 67641 | 1 | 1.060 | 63812.3 |
| 112 | 2020-10-28 06:26:00 | grandchild | 1 | 67641 | 1 | 2.110 | 32057.3 |
| 111 | 2020-06-19 03:53:27 | grandchild | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 110 | 2020-02-29 15:51:28 | grandchild | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 109 | 2020-02-29 13:34:41 | grandchild | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 108 | 2020-02-28 07:06:20 | grandchild | 1 | 67641 | 1 | 2.593 | 26086.0 |
| 107 | 2020-02-28 04:16:08 | grandchild | 1 | 67641 | 1 | 1.966 | 34405.4 |
| 106 | 2020-02-28 02:39:02 | grandchild | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 105 | 2020-02-23 03:06:17 | grandchild | 1 | 67641 | 1 | 1.190 | 56841.2 |
| 104 | 2020-02-16 23:32:22 | grandchild | 1 | 67641 | 1 | 0.986 | 68601.4 |
| 103 | 2020-02-13 06:51:48 | grandchild | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 102 | 2020-01-18 05:58:54 | grandchild | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 101 | 2020-01-08 07:25:58 | grandchild | 1 | 67641 | 1 | 0.983 | 68810.8 |
| 100 | 2019-11-07 16:08:55 | grandchild | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 99 | 2019-07-15 08:48:21 | grandchild | 1 | 67641 | 1 | 1.153 | 58665.2 |
| 98 | 2019-03-03 18:23:56 | grandchild | 1 | 67641 | 1 | 1.040 | 65039.4 |
| 97 | 2018-10-18 18:26:24 | grandchild | 1 | 67641 | 1 | 1.713 | 39486.9 |
| 96 | 2018-06-28 08:16:27 | grandchild | 1 | 67641 | 1 | 1.323 | 51127.0 |
| 95 | 2018-02-27 11:34:21 | grandchild | 1 | 67641 | 1 | 1.953 | 34634.4 |
| 94 | 2017-12-09 19:55:21 | grandchild | 1 | 67641 | 1 | 1.713 | 39486.9 |
| 93 | 2017-12-08 00:16:19 | grandchild | 1 | 67641 | 1 | 1.436 | 47103.8 |
| 92 | 2016-12-28 20:40:06 | grandchild | 1 | 67641 | 1 | 1.566 | 43193.5 |
| 91 | 2016-12-16 13:15:53 | grandchild | 1 | 67641 | 1 | 2.976 | 22728.8 |
| 90 | 2016-12-16 01:31:35 | grandchild | 1 | 67641 | 1 | 1.356 | 49882.7 |
| 89 | 2016-12-10 13:05:35 | grandchild | 1 | 67641 | 1 | 1.663 | 40674.1 |
| 88 | 2016-12-10 05:26:12 | grandchild | 1 | 67641 | 1 | 1.646 | 41094.2 |
| 87 | 2016-12-04 07:28:27 | grandchild | 1 | 67641 | 1 | 1.650 | 40994.5 |
| 86 | 2016-11-24 00:56:38 | grandchild | 1 | 67641 | 1 | 1.296 | 52192.1 |
| 85 | 2016-11-22 02:32:31 | grandchild | 1 | 67641 | 1 | 1.623 | 41676.5 |
| 84 | 2016-11-20 10:13:29 | grandchild | 1 | 67641 | 1 | 1.520 | 44500.7 |
| 83 | 2016-11-11 15:01:16 | grandchild | 5 | 173545 | 341 | 34.953 | 4965.1 |
| 82 | 2016-10-31 12:52:56 | grandchild | 5 | 173545 | 341 | 25.320 | 6854.1 |
| 81 | 2016-10-30 09:43:30 | grandchild | 5 | 173545 | 341 | 21.996 | 7889.8 |
| 80 | 2016-10-02 22:14:02 | grandchild | 5 | 173545 | 341 | 23.986 | 7235.3 |
| 79 | 2016-09-27 16:40:47 | grandchild | 1 | 67641 | 1 | 1.380 | 49015.2 |
| 78 | 2016-08-16 20:14:04 | grandchild | 1 | 67641 | 1 | 1.316 | 51398.9 |
| 77 | 2016-08-10 17:53:06 | grandchild | 4 | 161450 | 37 | 18.683 | 8641.5 |
| 76 | 2016-08-06 19:31:46 | grandchild | 4 | 161450 | 37 | 19.320 | 8356.6 |
| 75 | 2016-07-31 19:30:10 | grandchild | 4 | 161450 | 37 | 17.246 | 9361.6 |
| 74 | 2016-07-26 10:35:05 | grandchild | 4 | 161450 | 37 | 21.946 | 7356.7 |
| 73 | 2016-07-23 14:29:20 | grandchild | 1 | 67641 | 1 | 1.300 | 52031.5 |
| 72 | 2016-07-21 13:23:20 | grandchild | 4 | 161450 | 37 | 18.156 | 8892.4 |
| 71 | 2016-07-12 22:52:51 | grandchild | 2 | 108824 | 1 | 5.026 | 21652.2 |
| 70 | 2016-07-09 00:23:55 | grandchild | 4 | 161450 | 37 | 19.410 | 8317.9 |
| 69 | 2016-07-08 00:59:48 | grandchild | 4 | 161450 | 37 | 19.860 | 8129.4 |
| 68 | 2016-07-06 08:30:48 | grandchild | 4 | 161450 | 37 | 31.510 | 5123.8 |
| 67 | 2016-07-04 01:00:36 | grandchild | 4 | 161450 | 37 | 17.883 | 9028.1 |
| 66 | 2016-06-29 20:58:49 | grandchild | 4 | 161450 | 37 | 37.843 | 4266.3 |
| 65 | 2016-06-28 00:19:09 | grandchild | 4 | 161450 | 37 | 33.246 | 4856.2 |
| 64 | 2016-06-21 03:05:01 | grandchild | 4 | 161450 | 37 | 33.543 | 4813.2 |
| 63 | 2016-06-16 14:31:59 | grandchild | 1 | 67641 | 1 | 1.763 | 38367.0 |
| 62 | 2016-05-26 14:15:50 | grandchild | 4 | 161450 | 37 | 15.090 | 10699.1 |
| 61 | 2016-05-21 03:33:35 | grandchild | 4 | 161450 | 37 | 32.033 | 5040.1 |
| 60 | 2016-05-18 18:45:01 | grandchild | 4 | 161450 | 37 | 16.486 | 9793.2 |
| 59 | 2016-04-24 21:00:35 | grandchild | 1 | 67641 | 1 | 1.093 | 61885.6 |
| 58 | 2016-04-22 15:13:59 | grandchild | 5 | 173545 | 341 | 44.306 | 3917.0 |
| 57 | 2016-04-17 02:56:29 | grandchild | 1 | 67641 | 1 | 1.143 | 59178.5 |
| 56 | 2016-04-16 20:30:56 | grandchild | 5 | 173545 | 341 | 26.680 | 6504.7 |
| 55 | 2016-04-15 10:04:38 | grandchild | 5 | 173545 | 341 | 51.846 | 3347.3 |
| 54 | 2016-04-14 05:27:44 | grandchild | 1 | 67641 | 1 | 2.253 | 30022.6 |
| 53 | 2016-04-12 14:33:16 | grandchild | 5 | 173545 | 341 | 30.500 | 5690.0 |
| 52 | 2016-04-11 10:40:14 | grandchild | 1 | 67641 | 1 | 1.193 | 56698.2 |
| 51 | 2016-04-11 02:18:06 | grandchild | 5 | 173545 | 341 | 40.840 | 4249.4 |
| 50 | 2016-04-08 15:24:36 | grandchild | 1 | 67641 | 1 | 1.563 | 43276.4 |
| 49 | 2016-04-08 09:23:03 | grandchild | 5 | 173545 | 341 | 22.150 | 7835.0 |
| 48 | 2016-03-26 09:46:26 | grandchild | 5 | 173545 | 341 | 19.753 | 8785.8 |
| 47 | 2016-03-19 15:09:28 | grandchild | 1 | 67641 | 1 | 1.086 | 62284.5 |
| 46 | 2016-03-02 12:08:02 | grandchild | 1 | 67641 | 1 | 1.063 | 63632.2 |
| 45 | 2016-03-01 21:38:26 | grandchild | 4 | 161450 | 37 | 16.453 | 9812.8 |
| 44 | 2016-02-29 12:39:19 | grandchild | 2 | 108824 | 1 | 3.163 | 34405.3 |
| 43 | 2016-02-28 23:47:32 | grandchild | 5 | 173545 | 341 | 19.290 | 8996.6 |
| 42 | 2016-02-28 23:20:46 | grandchild | 3 | 140603 | 5 | 6.723 | 20913.7 |
| 41 | 2016-02-26 08:28:12 | grandchild | 1 | 67641 | 1 | 1.126 | 60071.9 |
| 40 | 2016-02-04 11:21:08 | grandchild | 1 | 67641 | 1 | 3.256 | 20774.3 |
| 39 | 2015-11-12 05:30:22 | grandchild | 1 | 67641 | 1 | 1.120 | 60393.8 |
| 38 | 2015-09-11 04:53:04 | grandchild | 4 | 161450 | 37 | 12.630 | 12783.1 |