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 “glutton” with Change Limit: [1] [2] [3] [4]

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

100 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
glutton84489(None) 
gluttons944271gluttons
gluttony1242511gluttony
button8310272_button
elution72913822elution
gluon6311222glu__on
gluten74210752glu_ten
glutted937242glutted
glutting10247642glutting
grutten885282grutten
mutton8510452_mutton
pluton838852plu_ton
ablution1047223ablution
alation72920553alation
blotto8198443blotto_
bouton8311533bou_ton
burton8311273_burton
buttons9310333_buttons
buttony1236173_buttony
calutron1045553calutron
caution93013523caution
clutter94211663clutter
cotton8312993_cotton
dilution9239143dilution
elation73620453elation
elusion72310953elusion
elutions82513053elutions
elytron1045463elytron
flatten10429653flatten
flattop1244403flattop
flutter104012093flutter
fluxion1735043fluxion
futon83113773_fu_ton
gelation93014433gelation
ghetto1036073ghetto_
ghettos1134473ghettos
gigaton946343gigaton
gittin72910553g_ittin
glisten8418083glisten
glitter84211803glitter
glottal835103glottal
glottic1036653glottic
glottis837173glottis
glucagon1241823glucagon
glucan936183glu_can
gluepot1045103gluepot
gluons738503glu__ons
glut56331293glu_t__
glute66020903glu_t_e
gluteal854243gluteal
glutei7409743glu_tei
glutelin944083glutelin
glutenin944033glutenin
glutens8437593glutens
glutes74517673glu_tes
gluteus8386253gluteus
gluts66120133glu_t_s
gluttonies1143333gluttonies
gluttonous1151943gluttonous
gotten73410113g_otten
grotto7349813grotto_
grottos8337333grottos
grunion835433grunion
guenon736403g_uenon
guidon837373g_uidon
gusto65414643g_usto_
gutta64613383g_utt_a
guttae73210583g_uttae
gutted84716363g_utted
gutter73817713g_utter
gutting93415923g_utting
guttle74111973g_uttle
gutty94516993g_utt_y
jetton1338033_jetton
latten65018203_latten
lattin64316223_lattin
lepton82510803_lepton
litten64014873_litten
lotion65716523_lotion
lotto55217573_lotto_
lottos64613103_lottos
lutein6311263_lutein
mouton8410853mou_ton
multiton1087343multiton
muton73817003_mu_ton
muttons949283_muttons
muttony1235323_muttony
neuston736083neuston
neutron737763neutron
platoon938953platoon
pleuston1044193pleuston
plutons938343plu_tons
puton73617913_pu_ton
putto75617663_putto_
ratton64116123_ratton
rebutton1043833rebutton
slutty9248003slutt_y
solution889593solution
unbutton1042463unbutton
volution1198603volution

Search took 7 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 Filter1786911340270.440406115.9
2DLD Change Limit1340271006.51620568.9
3Display Results1001000.0303333.3
 (SQL Overall)1786911006.98625578.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.