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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

208 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
beauties1022952(None) 
beasties102514651beasties
banties94324762b_anties
bawties124214312b_awties
beanies93821092bea_nies
beastie92412432beastie_
beautifies1554472beautifies
beautify1643182beautify
beauts86015282beaut__s
blasties102113632blasties
dauties83315762_dauties
deputies1157532deputies
fealties1139992fealties
hearties11315412hearties
lealties8310792lealties
realties8514852realties
agouties9337693agouties
aunties73920073__aunties
babies106123653b_a_bies
baddies114017873b_addies
baffies153612943b_affies
baggies113814853b_aggies
bailies94120203b_ailies
baldies105317703b_aldies
ballies93725743b_allies
bandies104124863b_andies
baptise1139553b_aptise
baptises1238923b_aptises
baptizes2136843b_aptizes
barbies114519593b_arbies
barites94322333b_arites
bastes85330383b_ast_es
bastiles10313353b_astiles
bates75846343b_a_t_es
bathes116524833b_a_thes
batiks1239373b_a_tiks
battier93515713b_attier
battiest104115553b_attiest
battiks1337143b_attiks
battles94517683b_attles
battues94610193b_attues
baubees11348713b_aubees
baubles113611863b_aubles
bauxites1735153b_auxites
bawdies134613393b_awdies
bawtie113812143b_awtie_
beaches144120653bea_ches
beachier1538803beachier
beachiest1638443beachiest
beadier103513913bea_dier
beadiest113815533bea_diest
beadles103414733bea_dles
beagles103212123bea_gles
beakier134012163bea_kier
beakiest143313463bea_kiest
beamier113411943bea_mier
beamiest123212763bea_miest
beaneries11310903beaneries
beanie83618593bea_nie_
beastings12387653beastings
beastlier1144193beastlier
beastliest1244663beastliest
beasts84519723beast__s
beaten84617063bea_t_en
beater84729393bea_t_er
beaters94925043bea_ters
beatifies1459283beatifies
beatify1536593bea_tify
beating104326873bea_ting
beatings114113233bea_tings
beatless103311593bea_tless
beatniks1444043beatniks
beats76042243bea_t__s
beauish12268513beau_ish
beaus75127113beau___s
beaut75135213beaut___
beauteous1143433beauteous
beautified1654223beautified
beautifier1543483beautifier
beautifiers1662213beautifiers
beautiful1442403beautiful
beauty115410163beaut__y
becurses1236723becurses
bedirties1275683bedirties
bedtimes1336593be_dtimes
beduins1039123bedu_ins
bedunces1345513bedunces
beedies10314203be_edies
beetles9312083be_etles
beguiles1146103beguiles
beguines11127213beguines
beladies11310423beladies
belfries1336983belfries
belies84631053be__lies
bellies94023723be_llies
bemuses1139293bemu_ses
bennies93917313be_nnies
berates94126873berat_es
berries94423553be_rries
bestirs9311133be_stirs
betides104915263be__tides
betimes115114413be__times
betise85616273be__tise
betises94816123be__tises
betonies10413063betonies
bevies114017303be__vies
bhaktis1633433bhakti_s
bheesties1443923bheesties
bhisties1339003bhisties
bialies93618413bia_lies
blastie92411393blastie_
blastier10249493blastier
blastiest111710043blastiest
booties94124613b_ooties
bougies103715183b_ougies
bounties10311403bounties
brandies11714563brandies
brassies103613533brassies
brattices1345553brattices
brattier1047663brattier
brattiest1148103brattiest
brattles10199333brattles
braunites1146723braunites
braxies16711463bra_xies
breathes134212903brea_thes
brevities1446423brevities
brutes86118683b_rut_es
buries84633273b__uries
busies85525263b__usies
butes714535873b__ut_es
butles84423913b__utles
buttes84822563b__uttes
butties93217953b_utties
catties94023053_catties
cecities12312043cecities
chanties132615803chanties
cuties84927363__cuties
dautie72914703_dautie_
dawties113312703_dawties
dearies83526273dea_ries
decuries11312223decuries
deities82621923de_ities
deputes104911783deput_es
deputizes2144983deputizes
duties74921903__duties
easies64126633_ea_sies
elutes64020313_elut_es
empties11712243_empties
equites162212493_equites
equities17310773_equities
fatties103018203_fatties
features11310333features
ferities111416713ferities
gaudies9311973_gaudies
heartier1139093heartier
heartiest12311103heartiest
heaumes1237423heau_mes
heavies132713873hea_vies
jetties143613123je_tties
kauries113613193_kauries
laities7320343_laities
lefties10312073le_fties
lenities8315943lenities
levities11310713levities
mealies92821933mea_lies
mealtimes1345243mealtimes
meanies93620743mea_nies
meantimes1345883meantimes
meatier93214613mea_tier
meatiest102816793mea_tiest
meatuses1038203meatuses
nasties73520493_nasties
neckties1445903neckties
obesities1145843obesities
panties94230933_panties
parties93230863_parties
pasties94529813_pasties
patties93425143_patties
peatier94017233pea_tier
peatiest103118803pea_tiest
peavies122213403pea_vies
penalties11139503penalties
penuries10311663penuries
platies93722543pla_ties
readies83324713rea_dies
realities9316313realities
reburies10311143reburies
refutes104515723refut_es
reputes94615963reput_es
requites171511763requites
reties65436193re__ties
salties73725773_salties
sauries72821623_sauries
sautes63924913_saut_es
scanties103215423scanties
shanties113116583shanties
smarties10312873smarties
tatties74120343_tatties
teatimes1039443tea_times
tenuities949763tenuities
treaties8316983trea_ties
verities111418043verities
wearies103020223wea_ries
yautias1046333_yautias
yearlies1137603yearlies
yeastier1135393yeastier
yeastiest1237203yeastiest
zeatins16311733zea_tins

Search took 8 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622087.45319611.2
3Display Results2082080.0762736.8
 (SQL Overall)1786912087.70223200.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.