Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “acutes” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
acutes8391772(None) 
acute74720361acute_
acuter84412861acuter
acutest94410601acutest
cutes79438311_cutes
scutes85219191scutes
abates85825032abates
abuses85119102abuses
abuts75417072abut_s
accuses114112192accuses
aces67645092ac__es
aches106132292ac_hes
ackees124914572ackees
acmes96020652ac_mes
acnes75922622ac_nes
acres76327762ac_res
acted88521732ac_ted
acts66929862ac_t_s
actuates10310302actuates
acuate8315632acuate_
acuities10312442acuities
aculei839792aculei
aculeus937512aculeus
acumen1049012acumen
acumens1136952acumens
acutely1246122acutely
agates76121332agates
agues64919052agu_es
alates64833962alates
amuses85117942amuses
antes56334322a_ntes
anuses66218772anuses
arbutes939702arbutes
arcuses94814692arcuses
aretes64425352aretes
ascites9312602ascites
ates45047922a__tes
aures55137092a_ures
autos56523322a_utos
axites134913832axites
azotes154312222azotes
azures15510182azures
brutes86118682brutes
butes714535872_butes
cartes86239472cartes
castes85631862castes
cates75951872_cates
caules85927252caules
causes88026472causes
cetes75731102_cetes
chutes114615762chutes
cites74435582_cites
cotes76347842_cotes
cubes95028162_cubes
cues65438982_cu_es
cukes115422092_cukes
cures75645432_cures
cute66440452_cute_
cuter74728222_cuter
cutest85820142_cutest
cutesy114810732_cutesy
cutey105819792_cutey
cuteys11569972_cuteys
cuties84927362_cuties
cutis77723752_cutis
cuts65841152_cut_s
dacites101114592dacites
elutes64020312elutes
flutes95421782flutes
glutes74517672glutes
jutes125125132_jutes
lacunes9159622lacunes
lutes55836662_lutes
macules114015132macules
mutes75033782_mutes
routes66129312routes
salutes73716252salutes
sautes63924912sautes
scute75520942scute_
scuts74522522scut_s
shutes93518212shutes
utes45930882__utes
vacates12312832vacates

Search took 4 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.1231452772.4
2DLD Change Limit82551832.89328534.7
3Display Results83830.0136384.6
 (SQL Overall)178691833.02958993.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.