History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"porch"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1115 | 2024-04-05 05:49:21 | porch | 3 | 83667 | 987 | 10.720 | 7804.8 |
| 1114 | 2024-04-05 05:49:19 | porch | 2 | 53800 | 79 | 4.373 | 12302.8 |
| 1113 | 2024-04-05 05:45:52 | porch | 1 | 28756 | 7 | 1.843 | 15602.8 |
| 1112 | 2024-04-03 04:11:26 | porch | 3 | 83667 | 987 | 5.296 | 15798.1 |
| 1111 | 2024-04-03 03:43:39 | porch | 3 | 83667 | 987 | 8.986 | 9310.8 |
| 1110 | 2024-04-03 03:43:40 | porch | 2 | 53800 | 79 | 3.266 | 16472.7 |
| 1109 | 2024-04-03 03:36:42 | porch | 1 | 28756 | 7 | 1.170 | 24577.8 |
| 1108 | 2024-03-31 07:45:51 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1107 | 2024-03-29 09:42:00 | porch | 1 | 28756 | 7 | 0.513 | 56054.6 |
| 1106 | 2024-03-29 05:08:14 | porch | 1 | 28756 | 7 | 0.576 | 49923.6 |
| 1105 | 2024-03-12 17:09:25 | porch | 1 | 28756 | 7 | 0.516 | 55728.7 |
| 1104 | 2024-03-06 01:45:23 | porch | 1 | 28756 | 7 | 1.143 | 25158.4 |
| 1103 | 2024-03-03 21:31:35 | porch | 1 | 28756 | 7 | 0.470 | 61183.0 |
| 1102 | 2024-03-01 04:02:09 | porch | 1 | 28756 | 7 | 0.750 | 38341.3 |
| 1101 | 2024-03-01 03:12:04 | porch | 2 | 53800 | 79 | 1.813 | 29674.6 |
| 1100 | 2024-03-01 03:11:37 | porch | 3 | 83667 | 987 | 4.093 | 20441.5 |
| 1099 | 2024-02-28 23:55:37 | porch | 1 | 28756 | 7 | 0.516 | 55728.7 |
| 1098 | 2024-02-28 19:03:09 | porch | 2 | 53800 | 79 | 1.563 | 34421.0 |
| 1097 | 2024-02-28 18:52:41 | porch | 3 | 83667 | 987 | 3.720 | 22491.1 |
| 1096 | 2024-02-28 01:55:34 | porch | 2 | 53800 | 79 | 3.173 | 16955.6 |
| 1095 | 2024-02-28 01:55:12 | porch | 3 | 83667 | 987 | 4.376 | 19119.5 |
| 1094 | 2024-02-28 01:45:25 | porch | 2 | 53800 | 79 | 3.486 | 15433.2 |
| 1093 | 2024-02-28 01:45:21 | porch | 3 | 83667 | 987 | 4.076 | 20526.7 |
| 1092 | 2024-02-28 01:45:10 | porch | 1 | 28756 | 7 | 0.516 | 55728.7 |
| 1091 | 2024-02-02 20:36:43 | porch | 1 | 28756 | 7 | 0.500 | 57512.0 |
| 1090 | 2024-01-28 22:10:49 | porch | 1 | 28756 | 7 | 0.500 | 57512.0 |
| 1089 | 2024-01-09 04:28:28 | porch | 2 | 53800 | 79 | 1.766 | 30464.3 |
| 1088 | 2024-01-09 04:28:24 | porch | 3 | 83667 | 987 | 3.390 | 24680.5 |
| 1087 | 2024-01-08 18:12:39 | porch | 3 | 83667 | 987 | 3.423 | 24442.6 |
| 1086 | 2023-12-13 23:30:47 | porch | 1 | 28756 | 7 | 0.530 | 54256.6 |
| 1085 | 2023-12-03 18:37:52 | porch | 2 | 53800 | 79 | 1.923 | 27977.1 |
| 1084 | 2023-12-02 14:44:54 | porch | 3 | 83667 | 987 | 3.826 | 21868.0 |
| 1083 | 2023-11-14 22:50:00 | porch | 1 | 28756 | 7 | 0.436 | 65954.1 |
| 1082 | 2023-11-10 14:48:09 | porch | 1 | 28756 | 7 | 1.110 | 25906.3 |
| 1081 | 2023-11-05 07:48:15 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1080 | 2023-10-27 00:22:49 | porch | 3 | 83667 | 987 | 4.470 | 18717.4 |
| 1079 | 2023-10-24 22:00:39 | porch | 3 | 83667 | 987 | 4.140 | 20209.4 |
| 1078 | 2023-10-23 08:48:59 | porch | 3 | 83667 | 987 | 4.156 | 20131.6 |
| 1077 | 2023-10-20 06:20:28 | porch | 1 | 28756 | 7 | 0.483 | 59536.2 |
| 1076 | 2023-10-20 01:51:21 | porch | 3 | 83667 | 987 | 3.796 | 22040.8 |
| 1075 | 2023-10-18 20:09:28 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1074 | 2023-10-18 20:00:04 | porch | 3 | 83667 | 987 | 3.266 | 25617.6 |
| 1073 | 2023-10-11 16:30:29 | porch | 1 | 28756 | 7 | 0.466 | 61708.2 |
| 1072 | 2023-10-10 09:36:44 | porch | 1 | 28756 | 7 | 0.530 | 54256.6 |
| 1071 | 2023-10-07 02:00:52 | porch | 1 | 28756 | 7 | 0.530 | 54256.6 |
| 1070 | 2023-10-03 23:16:14 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1069 | 2023-09-28 00:25:54 | porch | 1 | 28756 | 7 | 0.606 | 47452.1 |
| 1068 | 2023-09-27 14:43:45 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1067 | 2023-07-29 18:42:04 | porch | 3 | 83667 | 987 | 3.300 | 25353.6 |
| 1066 | 2023-07-26 02:43:32 | porch | 1 | 28756 | 7 | 0.466 | 61708.2 |
| 1065 | 2023-06-10 07:56:31 | porch | 1 | 28756 | 7 | 1.046 | 27491.4 |
| 1064 | 2023-06-07 00:51:06 | porch | 1 | 28756 | 7 | 0.436 | 65954.1 |
| 1063 | 2023-04-23 15:26:19 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1062 | 2023-04-09 07:14:36 | porch | 3 | 83667 | 987 | 3.733 | 22412.8 |
| 1061 | 2023-02-13 23:58:38 | porch | 1 | 28756 | 7 | 0.483 | 59536.2 |
| 1060 | 2023-02-08 11:47:38 | porch | 1 | 28756 | 7 | 0.486 | 59168.7 |
| 1059 | 2023-01-13 13:12:56 | porch | 3 | 83667 | 987 | 3.233 | 25879.1 |
| 1058 | 2022-12-12 06:05:38 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1057 | 2022-11-25 08:45:31 | porch | 1 | 28756 | 7 | 0.436 | 65954.1 |
| 1056 | 2022-10-21 04:15:38 | porch | 3 | 83667 | 987 | 3.263 | 25641.1 |
| 1055 | 2022-10-11 00:15:06 | porch | 1 | 28756 | 7 | 0.436 | 65954.1 |
| 1054 | 2022-09-07 15:08:26 | porch | 1 | 28756 | 7 | 0.440 | 65354.5 |
| 1053 | 2022-08-16 11:08:30 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1052 | 2022-08-15 01:47:15 | porch | 1 | 28756 | 7 | 0.436 | 65954.1 |
| 1051 | 2022-06-09 14:14:34 | porch | 1 | 28756 | 7 | 0.500 | 57512.0 |
| 1050 | 2022-06-05 23:27:16 | porch | 1 | 28756 | 7 | 0.436 | 65954.1 |
| 1049 | 2022-06-02 14:33:06 | porch | 1 | 28756 | 7 | 0.436 | 65954.1 |
| 1048 | 2022-05-30 19:02:35 | porch | 3 | 83667 | 987 | 3.296 | 25384.4 |
| 1047 | 2022-05-22 18:46:09 | porch | 3 | 83667 | 987 | 3.310 | 25277.0 |
| 1046 | 2022-05-20 13:51:02 | porch | 3 | 83667 | 987 | 3.610 | 23176.5 |
| 1045 | 2022-05-18 08:44:55 | porch | 3 | 83667 | 987 | 3.500 | 23904.9 |
| 1044 | 2022-04-03 02:00:13 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1043 | 2022-01-29 06:18:05 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1042 | 2022-01-11 09:03:16 | porch | 3 | 83667 | 987 | 3.656 | 22884.8 |
| 1041 | 2022-01-04 15:44:28 | porch | 1 | 28756 | 7 | 0.500 | 57512.0 |
| 1040 | 2022-01-02 12:45:49 | porch | 1 | 28756 | 7 | 0.470 | 61183.0 |
| 1039 | 2021-11-23 04:55:11 | porch | 1 | 28756 | 7 | 0.500 | 57512.0 |
| 1038 | 2021-11-02 21:48:42 | porch | 1 | 28756 | 7 | 0.530 | 54256.6 |
| 1037 | 2021-10-12 12:04:46 | porch | 1 | 28756 | 7 | 0.500 | 57512.0 |
| 1036 | 2021-09-20 07:22:43 | porch | 1 | 28756 | 7 | 0.500 | 57512.0 |
| 1035 | 2021-08-18 12:59:43 | porch | 1 | 28756 | 7 | 0.450 | 63902.2 |
| 1034 | 2021-08-16 08:41:36 | porch | 1 | 28756 | 7 | 0.500 | 57512.0 |
| 1033 | 2021-07-11 08:35:19 | porch | 1 | 28756 | 7 | 0.516 | 55728.7 |
| 1032 | 2021-04-07 10:37:40 | porch | 1 | 28756 | 7 | 0.516 | 55728.7 |
| 1031 | 2021-04-03 06:49:23 | porch | 1 | 28756 | 7 | 0.483 | 59536.2 |
| 1030 | 2021-04-01 07:19:50 | porch | 3 | 83667 | 987 | 3.280 | 25508.2 |
| 1029 | 2021-02-26 10:16:46 | porch | 3 | 83667 | 987 | 3.470 | 24111.5 |
| 1028 | 2021-02-16 18:05:00 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1027 | 2020-12-22 05:33:05 | porch | 1 | 28756 | 7 | 0.500 | 57512.0 |
| 1026 | 2020-10-27 00:24:55 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1025 | 2020-10-26 05:45:25 | porch | 1 | 28756 | 7 | 1.000 | 28756.0 |
| 1024 | 2020-10-24 19:33:56 | porch | 1 | 28756 | 7 | 0.500 | 57512.0 |
| 1023 | 2020-10-23 22:22:23 | porch | 1 | 28756 | 7 | 0.436 | 65954.1 |
| 1022 | 2020-10-07 11:30:28 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1021 | 2020-10-04 12:11:10 | porch | 1 | 28756 | 7 | 0.513 | 56054.6 |
| 1020 | 2020-09-14 11:35:14 | porch | 1 | 28756 | 7 | 0.470 | 61183.0 |
| 1019 | 2020-09-09 15:51:36 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1018 | 2020-09-04 13:47:12 | porch | 1 | 28756 | 7 | 0.453 | 63479.0 |
| 1017 | 2020-09-01 14:12:25 | porch | 1 | 28756 | 7 | 0.470 | 61183.0 |
| 1016 | 2020-08-28 16:34:57 | porch | 1 | 28756 | 7 | 0.560 | 51350.0 |