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

96 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
costumer127510(None) 
costume1157851costume_
costumed1365031costumed
costumers1374851costumers
costumery1663111costumery
costumes1258011costumes
costumey1563521costumey
costumier1343421costumier
consumer1238502consumer
coster84331292cost__er
costlier1038522costlier
costumiers1442972costumiers
customer1245382customer
posturer1038922posturer
assumer965363_assumer
bottomer1245103bottomer
capturer1246093capturer
caster85232573cast__er
cestuses1038083cestuses
cistuses1038283cistuses
coassume12103973coassume_
coassumed14112933coassumed
coassumes13103893coassumes
coaster94219043coast__er
coater84329573coat__er
coituses1039623coituses
colluder11276873colluder
colourer1037563colourer
colter84625093colt__er
columel1136273co_lumel
comer95832693co___mer
communer14349303communer
commuter143010153commuter
computer144511513computer
conducer13127373conducer
confuter1338513confuter
conjurer17117683conjurer
conquer1838623conqu_er
construer1146913construer
consume11510133consume_
consumed1337923consumed
consumers1337203consumers
consumes12310413consumes
contemner1347183contemner
contumely1644243contumely
contuse9311413contuse_
contused1138443contused
contuses10413453contuses
cooter85128613coot__er
copter109822013copt__er
coruler9311713co_ruler
cosher114819903cos__her
cosier84423763cos__ier
cosigner1135953cosigner
costae85319683cost_ae_
costar85518613cost__ar
costate94019273costate_
costed95623123cost__ed
costers94128343cost__ers
costive12312843costive_
costmary1545053cost_mary
costrel9310373cost_rel
costumeries1554113costumeries
costuming1445283costuming
cottager11306813cottager
cotter84926673co_t_ter
cottier93814173co_ttier
couter84930223co__uter
couther123914633cout_her
couthier13218913couthier
couture9310623couture_
coutures10311993coutures
couturier1145423couturier
customers1344783customers
custumal12113593custumal
foster94322223fost__er
fosterer11239523fosterer
gesturer935983gesturer
gossamer1143633gossamer
hosteler1137283hosteler
hostler103411023host_ler
jostler14288223jost_ler
obtuser9134453_obtuser
ostler63312193_ost_ler
pasturer1037523pasturer
poster84129173post__er
postmen113110423post_men
posture9313253posture_
postured1139493postured
posturers1137053posturers
postures10313783postures
resumer9410113res_umer
roster64329083rost__er
stumper113610093__stumper
torturer835493torturer
zoster153715853zost__er

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 Limit146162967.87618557.9
3Display Results96960.0303200.0
 (SQL Overall)178691968.32921454.1
 
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.