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

112 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
consumers133720(None) 
consumer1238501consumer_
consumes12310411consume_s
censurers11256072censurers
coinsurers1243932coinsurers
conducers14136562conducers
confuters1437792confuters
conjurers18126232conjurers
conquers1938222conqu_ers
considers1238932considers
consolers112510922consolers
consulters1297212consulters
consume11510132consume__
consumed1337922consume_d
consumerism1783442consumerism
consumerist1574262consumerist
costumers1374852costumers
assumers1064963_assumers
capsomers1544753capsomers
censers94313903cens__ers
censurer10228133censurer_
censures102211623censure_s
censuses10187543censuse_s
coassumes13103893coassume_s
coasters104317333coas_ters
coinsurer1144773coinsurer_
coinsures1136723coinsure_s
colluders12285613colluders
colourers1136473colourers
columels1244813co_lumels
comers105328083co___mers
communers15338413communers
commuters15378913commuters
computers15339753computers
conceders1437953conceders
concluders1543493concluders
concurs11311473concu__rs
condemners1546023condemners
condolers122710573condolers
condoners122811513condoners
conducer13127373conducer_
conduces13129783conduce_s
confers124120093con__fers
confiders1537483confiders
confiners1439953confiners
confirmers1744963confirmers
conformers1746553conformers
confuses13310363confuse_s
confuter1338513confuter_
confutes1339843confute_s
congeners122511133congeners
congers104223233con__gers
conifers133611703con_ifers
coniums11311863conium__s
conjurer17117683conjurer_
conjures17119913conjure_s
conjurors18134503conjurors
conkers133721043con__kers
conners94023113con__ners
connivers1436933connivers
conquer1838623conqu_er_
conquerers2144223conquerers
consenters12410843consenters
conservers1547683conservers
consider11310393consider_
consigners1346413consigners
consoler102812613consoler_
consoles103216153console_s
consommes1545633consommes
conspirers1444573conspirers
conspires1358483conspires
construers1245873construers
consular1038813consular_
consuls92412313consu__ls
consulter1198223consulter_
consultors1286403consultors
consults10219983consu_lts
consumedly1852753consumedly
consumerisms1872493consumerisms
consumerists1672663consumerists
consumership2162963consumership
consuming1437913consuming
contemners1447073contemners
contumely1644243contumely
contuses10413453contuse_s
conveners142911443conveners
conveyers17267203conveyers
convokers18246103convokers
corulers1039773co_rulers
coshers123618183co_s_hers
costers94128333co_s_ters
costumer1275103costumer_
costumery1663113costumery
costumes1258013costume_s
costumiers1442973costumiers
couters93827303co__uters
ensurers8279373_ensurers
gossamers1243333gossamers
honourers1245573honourers
inhumers1364823_inhumers
insurers83710133_insurers
ionomers1038503ion_omers
monomers12311033mon_omers
monsters103314553mons_ters
nonconsumers1653023nonconsumers
nonskiers1345013nonskiers
nonsugars1043703nonsugars
nonusers8268003non_users
presumers1336373presumers
ransomers1146873ransomers
resumers1038083_resumers
tonsures869133tonsure_s

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411126.72022119.2
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.20224811.3
 
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.