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

141 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
consumed133792(None) 
consume11510131consume_
consumer1238501consumer
consumes12310411consumes
censured11248912censured
censused11184972censused
coassumed14112932coassumed
coinsured1245512coinsured
conduced14136962conduced
confused1437032confused
confuted1437682confuted
conjured18117902conjured
consoled112911452consoled
consulted1277922consulted
consumedly1852752consumedly
consumers1337202consumers
contused1138442contused
costumed1365032costumed
tonsured976382tonsured
unconsumed1543132unconsumed
assumed1065293_assumed
bosomed1238003bo_somed
capsuled1334533capsuled
censed94016323cens__ed
censored11197953censored
censure92310603censure_
censurer10228133censurer
censures102211623censures
censuses10187543censuses
chasmed154710173chas_med
closured11266353closured
coassume12103973coassume_
coassumes13103893coassumes
coasted104015953coas_ted
coendured1344093coendured
coinsure1046933coinsure_
coinsurer1144773coinsurer
coinsures1136723coinsures
colluded12296463colluded
coloured1148313coloured
columel1136273co_lumel
columned1334923co_lumned
communed15338213communed
commuted15288983commuted
computed154110953computed
concaved1636223concaved
conceded1438293conceded
concluded1544033concluded
concurred1445673concurred
concussed1444753concussed
condemned1545103condemned
condoled123110723condoled
condoned122612023condoned
conduce12139233conduce_
conducer13127373conducer
conduces13129783conduces
conducted1547313conducted
coned86040053con___ed
confided1537453confided
confined14310403confined
confirmed1745563confirmed
conformed1767463conformed
confuse1238853confuse_
confuses13310363confuses
confute1239263confute_
confuter1338513confuter
confutes1339843confutes
congaed11399743con_gaed
congeed113212313con_geed
conium10415313conium__
coniums11311863conium_s
conjure16109073conjure_
conjurer17117683conjurer
conjures17119913conjures
conked135019113con__ked
conned95119703con__ned
connived1436433connived
connoted1138863connoted
conquer1838623conqu_er
conquered2145463conquered
consented12311943consented
conserved1538853conserved
consider11310393consider
consigned1346323consigned
consisted1238503consisted
console92715983console_
consoler102812613consoler
consoles103216153consoles
consomme1445373consomme
consommes1545633consommes
consorted1239773consorted
conspired1445663conspired
construed1247313construed
consul82312303consu__l
consular1038813consular
consuls92412313consu_ls
consult92513633consu_lt
consulter1198223consulter
consults10219983consults
consuming1437913consuming
consummated1853493consummated
contemned1446793contemned
contoured1237303contoured
contumely1644243contumely
contuse9311413contuse_
contuses10413453contuses
convened143412223convened
conveyed17247923conveyed
convoked18236163convoked
convoyed17225553convoyed
convulsed1544383convulsed
cornuted1137473cornuted
corseted11311473corseted
coshed124217543co_s_hed
cosied94819883co_s_ied
cosmid11810643co_s_mid
cosseted1178343cosseted
costed95623113co_s_ted
costume1157853costume_
costumer1275103costumer
costumes1258013costumes
costumey1563523costumey
counseled1245053counseled
couped115019313co__uped
cowshed1637773cows_hed
ensued73610483_ensu_ed
ensured83512943_ensured
fondued12466363fondu_ed
honoured1236313honoured
inhumed1375573_inhumed
insured83714253_insured
nonsked1236233nons_ked
nonsuited1046573nonsuited
presumed1337973presumed
ransomed1146933ransomed
resumed10310623_resumed
subsumed1344943subsumed
tongued946323tongu_ed
tonsure758783tonsure_
tonsures869133tonsures
volumed13285683vo_lumed

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.423422437.4
2DLD Change Limit1461621416.51322441.6
3Display Results1411410.0632238.1
 (SQL Overall)1786911416.99925530.9
 
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.