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

190 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
consume1151013(None) 
consumed1337921consumed
consumer1238501consumer
consumes12310411consumes
censure92310602censure
coassume12103972coassume
coinsure1046932coinsure
conduce12139232conduce
confuse1238852confuse
confute1239262confute
conium10415312conium_
coniums11311862coniums
conjure16109072conjure
console92715982console
consomme1445372consomme
consul82312302consu_l
consuls92412322consuls
consult92513632consult
consumers1337202consumers
contuse9311412contuse
costume1157852costume
tonsure758782tonsure
assume897563_assume
cangue91012453cangu_e
capsule1137343capsule
cense75121403cens__e
censual937663censual
censured11248913censured
censurer10228133censurer
censures102211623censures
census84310303censu_s
censused11184973censused
censuses10187543censuses
centime114513033centime
centum104012363centum_
centums11398783centums
cinque1736853cinqu_e
closure9278483closure
coassumed14112933coassumed
coassumes13103893coassumes
cocksure1645133cocksure
coelome1139693coelome
coendure1145463coendure
coenure968153coenure
coenzyme2442993coenzyme
coesite9713623coesite
cohune1189423co_hune
coinsured1245513coinsured
coinsurer1144773coinsurer
coinsures1136723coinsures
collude10337993collude
columel1136273co_lumel
column1038103co_lumn
colure8314163co_lure
come87547703co___me
commune13329363commune
commute134310443commute
compute134513663compute
comsymp1841153comsymp
concave1439373concave
concede12310103concede
conchae143911643conchae
conchie143312683conchie
concise11314473concise
conclude1344673conclude
concur10411103concu_r
concurs11311473concurs
concuss1138063concuss
condemn1237113condemn
condole102914953condole
condom114215363condom_
condoms124214083condoms
condone102616293condone
conduced14136963conduced
conducer13127373conducer
conduces13129783conduces
conduct121411593conduct
conduit10713083conduit
condyle13247053condyle
cone67256963con___e
confide13310203confide
confine12315583confine
confused1437033confused
confuses13310363confuses
confuted1437683confuted
confuter1338513confuter
confutes1339843confutes
conge85227593con__ge
congee96024473con_gee
coniine9316803coniine
conine84528553con_ine
conjured18117903conjured
conjurer17117683conjurer
conjures17119913conjures
connate9315753connate
connive1238993connive
connote9311613connote
conquer1838623conquer
cons66057693cons___
consent93723113consent
conserve1339933conserve
consider11310393consider
consign1038773consign
consist9316033consist
consol82614113cons_ol
consoled112911453consoled
consoler102812613consoler
consoles103216153consoles
consols92914073consols
consommes1545633consommes
consort91319903consort
conspire1257873conspire
construe1049053construe
consular1038813consular
consulate11612233consulate
consulted1277923consulted
consulter1198223consulter
consults10219983consults
consumable1645563consumable
consumedly1852753consumedly
consuming1437913consuming
consummate1654263consummate
conte76633203con__te
contemn1137803contemn
contumely1644243contumely
contused1138443contused
contuses10413453contuses
conus76726533con_u_s
convene123314323convene
convoke16207173convoke
convulse1345443convulse
copse95623933cops__e
corium10315723corium_
cornute939643cornute
corsage1039803corsage
corse75036183cors__e
cosie74728273co_s_ie
cosine83823513co_sine
costae85319683co_stae
costumed1365033costumed
costumer1275103costumer
costumes1258013costumes
costumey1563523costumey
coude85022633co__ude
coupe96023483co__upe
couture9310623couture
cundum1136513cundum_
cundums1235183cundums
cynosure1343553cynosure
donsie7613643dons_ie
dorsum947623dorsum_
ensue54013833_ensu_e
ensure63416003_ensure
fondue104510493fondu_e
gonium949803gonium_
inhume1196583_inhume
insure63416603_insure
ionium8610923ionium_
ioniums938313ioniums
lonesome1047473lonesome
longsome1145933longsome
monosome1299403monosome
neume74414403__neume
noisome947973noisome
nongame1038183nongame
nonheme1247133nonheme
nonhome1248833nonhome
nonsuch1244683nonsuch
nonsuit7811343nonsuit
nonuse63212253non_use
onium73115533_onium_
onside7511803_onside
possum1057953possum_
possums1145753possums
presume11310303presume
resume8313783_resume
rondure837313rondure
sensum849353sensum_
sonsie6614863sons_ie
subsume1146713subsume
toneme8312103ton_eme
tongue7410103tongu_e
tonsured976383tonsured
tonsures869133tonsures
unconsumed1543133unconsumed
unsure62815413_unsure
volume11358273vo_lume
winsome1237463winsome
woesome1246733woesome
zonule1577483zon_ule

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271907.48317910.9
3Display Results1901900.0633015.9
 (SQL Overall)1786911907.95222471.2
 
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.