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
coassume12103962coassume
coinsure1046922coinsure
conduce12139222conduce
confuse1238852confuse
confute1239252confute
conium10415312conium_
coniums11311862coniums
conjure16109062conjure
console92715982console
consomme1445372consomme
consul82312302consu_l
consuls92412312consuls
consult92513632consult
consumers1337202consumers
contuse9311412contuse
costume1157852costume
tonsure758782tonsure
assume897563_assume
cangue91012443cangu_e
capsule1137343capsule
cense75121403cens__e
censual937663censual
censured11248913censured
censurer10228133censurer
censures102211623censures
census84310303censu_s
censused11184973censused
censuses10187543censuses
centime114513033centime
centum104012363centum_
centums11398783centums
cinque1736853cinqu_e
closure9278473closure
coassumed14112923coassumed
coassumes13103883coassumes
cocksure1645123cocksure
coelome1139683coelome
coendure1145453coendure
coenure968143coenure
coenzyme2442993coenzyme
coesite9713623coesite
cohune1189423co_hune
coinsured1245503coinsured
coinsurer1144763coinsurer
coinsures1136713coinsures
collude10337983collude
columel1136273co_lumel
column1038103co_lumn
colure8314153co_lure
come87547703co___me
commune13329353commune
commute134310423commute
compute134513653compute
comsymp1841153comsymp
concave1439373concave
concede12310093concede
conchae143911643conchae
conchie143312683conchie
concise11314473concise
conclude1344663conclude
concur10411093concu_r
concurs11311453concurs
concuss1138063concuss
condemn1237113condemn
condole102914953condole
condom114215363condom_
condoms124214083condoms
condone102616293condone
conduced14136953conduced
conducer13127363conducer
conduces13129773conduces
conduct121411583conduct
conduit10713073conduit
condyle13247053condyle
cone67256963con___e
confide13310203confide
confine12315583confine
confused1437033confused
confuses13310363confuses
confuted1437673confuted
confuter1338503confuter
confutes1339833confutes
conge85227593con__ge
congee96024463con_gee
coniine9316803coniine
conine84528553con_ine
conjured18117893conjured
conjurer17117673conjurer
conjures17119903conjures
connate9315753connate
connive1238993connive
connote9311613connote
conquer1838613conquer
cons66057693cons___
consent93723113consent
conserve1339923conserve
consider11310393consider
consign1038773consign
consist9316033consist
consol82614113cons_ol
consoled112911443consoled
consoler102812613consoler
consoles103216153consoles
consols92914073consols
consommes1545633consommes
consort91319903consort
conspire1257873conspire
construe1049043construe
consular1038813consular
consulate11612233consulate
consulted1277923consulted
consulter1198223consulter
consults10219983consults
consumable1645563consumable
consumedly1852753consumedly
consuming1437913consuming
consummate1654263consummate
conte76633203con__te
contemn1137803contemn
contumely1644243contumely
contused1138443contused
contuses10413453contuses
conus76726533con_u_s
convene123314323convene
convoke16207173convoke
convulse1345443convulse
copse95623923cops__e
corium10315723corium_
cornute939633cornute
corsage1039803corsage
corse75036183cors__e
cosie74728263co_s_ie
cosine83823513co_sine
costae85319683co_stae
costumed1365033costumed
costumer1275103costumer
costumes1258013costumes
costumey1563523costumey
coude85022633co__ude
coupe96023483co__upe
couture9310613couture
cundum1136513cundum_
cundums1235183cundums
cynosure1343543cynosure
donsie7613643dons_ie
dorsum947623dorsum_
ensue54013833_ensu_e
ensure63416003_ensure
fondue104510493fondu_e
gonium949803gonium_
inhume1196583_inhume
insure63416603_insure
ionium8610913ionium_
ioniums938303ioniums
lonesome1047473lonesome
longsome1145933longsome
monosome1299403monosome
neume74414403__neume
noisome947963noisome
nongame1038173nongame
nonheme1247133nonheme
nonhome1248833nonhome
nonsuch1244683nonsuch
nonsuit7811343nonsuit
nonuse63212253non_use
onium73115533_onium_
onside7511803_onside
possum1057953possum_
possums1145753possums
presume11310303presume
resume8313783_resume
rondure837293rondure
sensum849353sensum_
sonsie6614853sons_ie
subsume1146713subsume
toneme8312103ton_eme
tongue7410093tongu_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.1531167915.0
2DLD Change Limit1340271907.26618445.8
3Display Results1901900.0802375.0
 (SQL Overall)1786911907.49923828.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.