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 “beasties” 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.

359 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
beasties10251465(None) 
beastie92412431beastie_
beauties10229521beauties
blasties102113621blasties
banties94324762b_anties
bastes85330382b_ast_es
bastiles10313352b_astiles
bawties124214312b_awties
beanies93821092bea_nies
beastings12387652beastings
beastlier1144192beastlier
beastliest1244662beastliest
beasts84519722beast__s
bestirs9311132be_stirs
bheesties1443922bheesties
bhisties1339002bhisties
blastie92411392blastie_
blastier10249492blastier
blastiest111710042blastiest
brassies103613532brassies
easies64126632_eas_ies
fealties1139992fealties
hearties11315412hearties
lealties8310792lealties
nasties73520492_nasties
pasties94529812_pasties
realties8514852realties
yeastier1135392yeastier
yeastiest1237202yeastiest
baases85218013baas__es
babies106123653b_a_bies
baddies114017873b_addies
baffies153612943b_affies
baggies113814853b_aggies
bailies94120203b_ailies
baldies105317703b_aldies
ballies93725743b_allies
bandies104124863b_andies
banshies131110663banshies
baptise1139553b_aptise
baptises1238923b_aptises
baptizes2136833b_aptizes
barbies114519593b_arbies
barites94322333b_arites
bases75644353b_as__es
bashes115631393b_as_hes
basics104915123b_as_ics
basifies13310493b_asifies
basils85717473b_as_ils
basins85722763b_as_ins
basis75429863b_as_i_s
basques18248673b_asques
basses85428303b_as_ses
baste74829983b_ast_e_
basted95227233b_ast_ed
baster85333593b_ast_er
basters94930303b_asters
bastile9313913b_astile
bastilles1147353b_astilles
basting104227203b_asting
bastings114214693b_astings
bastion9312473b_astion
bastions10411693b_astions
basts75936933b_ast__s
bates75846343b_a_t_es
bathes116524833b_a_thes
batiks1239373b_a_tiks
battier93515713b_attier
battiest104115553b_attiest
battiks1337143b_attiks
battles94517683b_attles
battues94610193b_attues
bawdies134613393b_awdies
bawtie113812143b_awtie_
beaches144120653bea_ches
beachier1538803beachier
beachiest1638443beachiest
beadier103513913bea_dier
beadiest113815533bea_diest
beadles103414723bea_dles
beagles103212123bea_gles
beakier134012163bea_kier
beakiest143313463bea_kiest
beamier113411943bea_mier
beamiest123212763bea_miest
beaneries11310903beaneries
beanie83618593bea_nie_
bearskins1543363bearskins
beast76338643beast___
beastliness1343333beastliness
beastly1277563beast_ly
beaten84617063bea_t_en
beater84729393bea_t_er
beaters94925033bea_ters
beatifies1459283beatifies
beatify1536593bea_tify
beating104326873bea_ting
beatings114113223bea_tings
beatless103311593bea_tless
beatniks1444043beatniks
beats76042243bea_t__s
beautifies1554473beautifies
beautify1643183beautify
beauts86015283beaut__s
bedirties1275683bedirties
bedsides1246533bedsides
bedsits1037563beds_its
bedsores1157633bedsores
bedtimes1336593be_dtimes
beedies10314203be_edies
beestings12335923beestings
beetles9312083be_etles
beladies11310413beladies
belfries1336983belfries
belies84631053be__lies
bellies94023723be_llies
bennies93917313be_nnies
berates94126853berat_es
berries94423553be_rries
beses75830723be_s__es
besides104814533be_sides
beslimes1246953be_slimes
besmiles1237393be_smiles
bested94922753be_st_ed
bestial9311643be_stial
besting104923923be_sting
bestir8311163be_sti_r
bestows1248863be_stows
bestrew1248003be_strew
bestrews1335603be_strews
bestrides1237913be_strides
bests75932613be_st__s
bestuds10326753be_studs
betides104915263be__tides
betimes115114413be__times
betise85616273be__tise
betises94816123be__tises
betonies10413063betonies
bevies114017303be__vies
bhaktis1633423bhakti_s
bheestie1343153bheestie_
bhistie1236763bhistie_
bialies93618413bia_lies
biases84618433bias__es
biasses94911653bias_ses
bistres94017213b_istres
blasted104213473blast_ed
blaster94017303blast_er
blasters104116143blasters
blasting114013423blasting
blastings12347903blastings
blasts85116773blast__s
boasted104113743boast_ed
boaster94616433boast_er
boasters103915653boasters
boasting113512493boasting
boasts85017923boast__s
bolshies1338693bolshies
booties94124613b_ooties
bossies94116833b_ossies
bounties10311393bounties
brandies11714563brandies
brashes124518463bras_hes
brashier13389933brashier
brashiest14359853brashiest
brasier94516753bras_ier
brasiers103710513bras_iers
brasils9410973bras_ils
brasses93818353bras_ses
brassie93411523brassie_
brassier103310533brassier
brassiest11369713brassiest
brattices1345553brattices
brattier1047663brattier
brattiest1148103brattiest
brattles10199333brattles
braxies16711463bra_xies
breasted1138823breast_ed
breastfed1542693breastfed
breasting1239583breasting
breastpins1442713breastpins
breasts939703breast__s
breathes134212903brea_thes
brevities1446423brevities
brewskies18132273brewskies
bristles101510433bristles
busbies113011693b_usbies
busies85525263b_us_ies
bustics11810883b_ustics
bustier93916153b_ustier
bustiers103810043b_ustiers
bustiest102815053b_ustiest
bustles93816323b_ustles
butties93217953b_utties
castes85631863_cast_es
castles94917733_castles
catties94023053_catties
ceases84427073ceas__es
cecities12312043cecities
cerastes101111093cerast_es
chanties132615803chanties
chastise1348173chastise
chastises1437703chastises
clastics122811413clastics
dassies84418663_dassies
dauties83315763_dauties
dawties113312703_dawties
dearies83526273dea_ries
deashes113313903deas_hes
deities82621923de_ities
densities10310793densities
deputies1157533deputies
destines93619663de_stines
dynasties1344063dynasties
eases56041613_eas__es
easier64218463_eas_ier
easiest72318773_eas_iest
easter65027983_east_er
easters75125683_easters
easting84924303_easting
eastings93412953_eastings
easts57530323_east__s
elastics102710883elastics
elastins82111733elastins
empties11712243_empties
enskies1138573_enskies
espies83716803_e_spies
fatties103018203_fatties
feases95422923feas__es
feasted11310843feast_ed
feaster10812983feast_er
feasters11511563feasters
feasting122011323feasting
feastless1235043feastless
feasts95116093feast__s
feistier1136193feistier
feistiest1237073feistiest
felsites1138073felsites
ferities111416713ferities
gestes75721393ge_st_es
glassies94012273glassies
hastes95727073_hast_es
hastier103916623_hastier
hastiest112916493_hastiest
heartier1139093heartier
heartiest12311103heartiest
heavies132713873hea_vies
hessites1138613hessites
jetties143613123je_tties
laities7320343_laities
lassies74420103_lassies
leases65428113leas__es
leashes103514403leas_hes
leasts64616413least__s
leastwise1242063leastwise
lefties10312073le_fties
lenities8315943lenities
levities11310713levities
mashies12318253_mashies
mastics112614783_mastics
mastixes1738253_mastixes
mealies92821933mea_lies
mealtimes1345243mealtimes
meanies93620743mea_nies
meantimes1345883meantimes
measles92412753meas_les
measlier1036013measlier
measliest1147173measliest
measures1038913measures
meatier93214613mea_tier
meatiest102816793mea_tiest
mestees94617753me_stees
nastier74115293_nastier
nastiest83615953_nastiest
neckties1445903neckties
nestles73015463ne_stles
newsies101310383news_ies
obesities1145843obesities
panties94230933_panties
parties93230863_parties
pastes85233913_past_es
pastie85525523_pastie_
pastier94320383_pastier
pastiest103319543_pastiest
pastils94416173_pastils
pastimes123611903_pastimes
pastis84924323_pasti_s
pastises103616053_pastises
pastries101517423_pastries
patsies93919483_patsies
patties93425143_patties
peases85229473peas__es
peatier94017233pea_tier
peatiest103118803pea_tiest
peavies122213393pea_vies
penalties11139483penalties
pestier94317403pe_stier
pestiest103018413pe_stiest
pestles93217693pe_stles
piastres10249303piastres
pigsties1139783pigsties
plastics122412323plastics
plastids11269203plastids
platies93722543pla_ties
posties93128813_posties
prosties101421193prosties
readies83324703rea_dies
realities9316303realities
resites74027793re_sites
retastes82212903retast_es
reties65436193re__ties
salties73725773_salties
sassies74719263_sassies
scanties103215413scanties
seasides938743seasides
sestines82717243se_stines
shanties113116573shanties
smarties10312873smarties
spastics1237503spastics
sties55132983___sties
tassies74918933_tassies
tastes64126423_tast_es
tastier711817093_tastier
tastiest83216633_tastiest
tatties74120343_tatties
teases65426273teas__es
teatimes1039443tea_times
tensities9311333tensities
testees74215913te_stees
testes65125823te_st_es
testier74015643te_stier
testiest82715223te_stiest
testis64916713te_sti_s
toastier846893toastier
toastiest937423toastiest
treaties8316983trea_ties
trusties82712853trusties
vastier103613203_vastier
vastiest112713073_vastiest
verities111418043verities
verstes104014273verst_es
vestees103513163ve_stees
vestiges1238243ve_stiges
vestries11314043ve_stries
wastes96224883_wast_es
wastries111212883_wastries
wearies103020223wea_ries
websites1335183websites
wrastles11328933wrastles
yearlies1137603yearlies
yeasted1138503yeast_ed
yeastily1444573yeastily
yeastiness1344883yeastiness
yeasting12188923yeasting
yeastless1234053yeastless
yeasts96413053yeast__s
zeatins16311733zea_tins
zestier163010223ze_stier
zestiest173011103ze_stiest

Search took 9 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.190940478.9
2DLD Change Limit1461623598.64016916.9
3Display Results3593590.1402564.3
 (SQL Overall)1786913598.97019921.0
 
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.