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

97 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
costumed136503(None) 
costume1157851costume_
costumer1275101costumer
costumes1258011costumes
costumey1563521costumey
coassumed14112932coassumed
consumed1337922consumed
contused1138442contused
costed95623112cost__ed
costumers1374852costumers
costumery1663112costumery
costumier1343422costumier
postured1139492postured
assumed1065293_assumed
bosomed1238003bos_omed
bottomed1344673bottomed
captured1336573captured
casqued19235633casqu_ed
castled104311513cast_led
cestuses1038083cestuses
cisted95217523cist__ed
cistuses1038283cistuses
closured11266353clos_ured
clotured11246163clotured
coassume12103973coassume_
coassumes13103893coassumes
coasted104015953coast__ed
coated94927043coat__ed
coituses1039623coituses
colluded12296463colluded
coloured1148313coloured
columel1136273co_lumel
columned1334923co_lumned
communed15338213communed
commuted15288983commuted
computed154110953computed
conduced14136963conduced
confused1437033confused
confuted1437683confuted
conjured18117903conjured
construed1247313construed
consume11510133consume_
consumer1238503consumer
consumes12310413consumes
contemned1446793contemned
contoured1237303contoured
contumely1644243contumely
contuse9311413contuse_
contuses10413453contuses
cornuted1137473cornuted
coshed124217543cos__hed
coshered14610293coshered
cosied94819883cos__ied
cosigned1235723cosigned
cosmid11810643cos__mid
cosseted1178343cosseted
costae85319683cost_ae_
costard104113353cost_ard
costarred1244703costarred
costate94019273costate_
coster84331293cost__er
costive12312843costive_
costlier1038523costlier
costrel9310373cost_rel
costumiers1442973costumiers
costuming1445283costuming
coted85033853co_t__ed
cottered112511733cottered
cottoned1138033cottoned
couped115019313co__uped
couture9310623couture_
coutures10311993coutures
cultured1137233cultured
customer1245383customer
custumal12113593custumal
fortuned1285323fortuned
fostered122210453fostered
gestured1036993gestured
hosted105020343host__ed
hosteled1237293hosteled
jostled15267083jost_led
mistimed1339123mistimed
mistuned1157723mistuned
pastured1138233pastured
posted93722493post__ed
postmen113110423post_men
posture9313253posture_
posturer1038923posturer
postures10313783postures
pustuled1134953pustuled
resumed10310623res_umed
spumed114711543__spumed
stummed12348553__stummed
stumped124210153__stumped
tortured935843tortured
vestured1237463vestured
volumed13285683vo_lumed

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.423422437.4
2DLD Change Limit146162977.59319249.6
3Display Results97970.0462108.7
 (SQL Overall)178691978.06222164.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.