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

152 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
costumes125801(None) 
costume1157851costume_
costumed1365031costumed
costumer1275101costumer
costumers1374851costumers
costumey1563521costumey
cestuses1038082cestuses
cistuses1038282cistuses
coassumes13103892coassumes
coituses1039622coituses
consumes12310412consumes
contuses10413452contuses
costumery1663112costumery
costumier1343422costumier
costumiers1442972costumiers
coutures10311992coutures
postures10313782postures
assumes967163_assumes
bosques18217973bosqu_es
cactuses1237933cactuses
caestuses1144893caestuses
captures1239443captures
casques18278983casqu_es
castes85631863cast__es
castles94917733cast_les
centimes124012613centimes
centums11398783centum_s
cesiums1136303cesium_s
cestodes1138203cestodes
cestus84412913cestu__s
chowtimes1943143chowtimes
cistus84611343cistu__s
closures10228953clos_ures
clotures10299023clotures
coassume12103973coassume_
coassumed14112933coassumed
coatees93816553coat_ees
coelomes1239293coelomes
coenures1048683coenures
cohunes1249713co_hunes
coitus8511893coitu__s
coleuses1039723coleuses
colludes11279223colludes
columel1136273co_lumel
columels1244813co_lumels
columns1136473co_lumns
colures9315143co_lures
comes97246993co___mes
communes143411243communes
commutes143011893commutes
computes143914553computes
comtes106222813comt__es
conduces13129783conduces
confuses13310363confuses
confutes1339843confutes
coniums11311863conium_s
conjures17119913conjures
consommes1545633consommes
construes11410133construes
consume11510133consume_
consumed1337923consumed
consumer1238503consumer
consumers1337203consumers
contemns1237403contemns
contes84432913cont__es
contumely1644243contumely
contuse9311413contuse_
contused1138443contused
cooties93725733coot_ies
cornuses10310033cornuses
corpuses12310063corpuses
corteges1198823corteges
cortexes1797613cortexes
cortices12615013cortices
coses76949493cos___es
coshes115022783cos__hes
cosies84932153cos__ies
cosines94122673cos_ines
cosmos10311753cos__mos
cosmoses1239703cosmoses
costae85319683cost_ae_
costards113510793costards
costars94218013cost_ars
costate94019273costate_
costed95623113cost__ed
coster84331293cost__er
costers94128333cost_ers
costive12312843costive_
costless10310003costless
costlier1038523costlier
costliest1138563costliest
costrel9310373cost_rel
costrels1038933costrels
costs77231143cost___s
costumeries1554103costumeries
costuming1445283costuming
cotes76347843co_t__es
cottages113310493cottages
cotypes1437943co_types
coupes105022523co__upes
couture9310623couture_
cultures10310153cultures
cultuses1037753cultuses
cuscuses1235863cuscuses
custodes1136653custodes
customer1245383customer
customers1344783customers
customs11348263custom_s
custumal12113593custumal
custumals1382543custumals
cystines1339473cystines
distomes11314163distomes
foetuses1136083foetuses
fortunes1158283fortunes
gestures9310013gestures
hostages122311693hostages
hostiles11312213hostiles
impostumes1652693impostumes
jostles143411143jost_les
lotuses74011253lo_tuses
mistimes12612613mistimes
mistunes10311133mistunes
moistures1147323moistures
mosques18256913mosqu_es
noctules1036583noctules
nostrums1045683nostrum_s
optimes1148473_optimes
oscules938123_oscules
ostomies10310583_ostomies
ostoses71213553_ostoses
pastimes123611903pastimes
pastures10311963pastures
possums1145753possum_s
postages112815323postages
posties93128813post_ies
postludes1244623postludes
postmen113110423post_men
posture9313253posture_
postured1139493postured
posturer1038923posturer
posturers1137053posturers
pustules1038443pustules
resumes9313373res_umes
rostrums1046083rostrum_s
spumes1021314883__spumes
stimes85920573__stimes
stumps104912283__stumps
stums75320083__stum_s
stupes84116953__stupes
tortures838913tortures
vestures11311043vestures
volumes12298233vo_lumes

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.406440125.6
2DLD Change Limit1461621526.82621412.5
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.29524495.0
 
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.