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

249 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
confuse123885(None) 
confused1437031confused
confuses13310361confuses
confute1239261confute
contuse9311411contuse
concise11314472concise
concuss1138062concuss
conduce12139232conduce
confess12399902confess
confide13310202confide
confine12315582confine
confuted1437682confuted
confuter1338512confuter
confutes1339842confutes
conjure16109072conjure
consume11510132consume
contused1138442contused
contuses10413452contuses
conus76726532con_us_
convulse1345442convulse
infuse93110572_infuse
nonuse63212252non_use
unconfuse1442982unconfuse
bonfire1287063bonfire
bonus75324323bon_us_
bonuses94212953bon_uses
bouse75931853bo__use
canful11610263canfu_l
canfuls1248423canfuls
cangue91012443cangu_e
cangues10611823cangues
cantus85117763cantus_
carouse9614423carouse
cause75225353c__ause
cayuse11207763c_ayuse
cense75121403cen__se
censure92310603censure
census84310303census_
censused11184973censused
censuses10187543censuses
ceruse83914523c_eruse
chouse116017563c_house
cinque1736853cinqu_e
cinques1837333cinques
clause84311503c_lause
clonus85212413clon_us_
clonuses1057133clon_uses
coarse84813903co_arse
coccus979283coccus_
codfish1637163codfish
coendure1145463coendure
coenure968153coenure
coffee144113743co_ffee
coffees15329573coffees
coffle14359043co_ffle
coffles152610003coffles
coffs134916303co_ffs_
cognise1059683cognise
cohune1189423co_hune
coiffe1447043coif_fe
coiffes1546803coiffes
coiffeuse1741613coiffeuse
coiffure1643123coiffure
coifs105718703coif_s_
coinsure1046933coinsure
coitus8511893coitus_
coituses1039623coituses
coleus86818273coleus_
coleuses1039723coleuses
collude10337993collude
colure8314163co_lure
combust1338363combust
commune13329363commune
commute134310443commute
comose105016843co_mose
comous10816503comous_
compose135716663compose
compute134513663compute
conatus9310463conatus_
concave1439373concave
concede12310103concede
conchae143911643conchae
conches144019813conches
conchie143312683conchie
conchs134714903conchs_
conciser12310243conciser
conclude1344673conclude
concourse1345803concourse
concur10411103concu_r
concurs11311473concurs
concussed1444753concussed
concusses1346343concusses
condense1179613condense
condoes104319203condoes
condole102914953condole
condone102616293condone
condos94322333condos_
conduced14136963conduced
conducer13127373conducer
conduces13129783conduces
conduct121411593conduct
conduit10713083conduit
condyle13247053condyle
cone67256963con___e
conenose1078593conenose
cones76457423con_es_
coneys115218423coneys_
confab1347063conf_ab
confabs1435393confabs
confect143614273confect
confer114018683conf_er
conferee13613733conferee
confers124120093confers
confessed1546053confessed
confesses1438623confesses
confided1537453confided
confider1438123confider
confides14310573confides
configure1544463configure
confined14310403confined
confiner13311193confiner
confines13315653confines
confirm1437363confirm
confit113316403conf_it
confits122811423confits
confiture1445953confiture
conflate13311173conflate
conflux1943003conflux
confluxes2143833confluxes
conform14310463conform
confound1445903confound
confrere1347563confrere
confusedly1952123confusedly
confusing1537333confusing
confusion1446473confusion
confuters1437793confuters
congas94417033congas_
conge85227593con__ge
congee96024473con_gee
congees103517923congees
conges94928173conges_
congest104618773congest
congius103210073congius_
congoes103617303congoes
congos94219883congos_
congous103615083congous_
conics103920593conics_
conies84338593conies_
coniine9316803coniine
conine84528553con_ine
conines93827793conines
conins84327233conins_
conioses10313313conioses
conium10415313coniu_m
coniums11311863coniums
conjured18117903conjured
conjurer17117683conjurer
conjures17119913conjures
conks115525703con_ks_
connate9315753connate
connive1238993connive
connote9311613connote
conns75024233con_ns_
conquer1838623conquer
conquest1939553conquest
cons66057693con__s_
consist9316033consist
console92715983console
consul82312303consu_l
consuls92412313consuls
consult92513633consult
consumed1337923consumed
consumer1238503consumer
consumes12310413consumes
conte76633203con__te
contes84432913contes_
contest93523233contest
contos84923233contos_
contusive1445783contusive
convene123314323convene
converse13310263converse
convoke16207173convoke
convulsed1544383convulsed
convulses1445503convulses
coofs105924713coof_s_
copse95623923co__pse
cornhusk1742043cornhusk
cornus84816563cornus_
cornuses10310033cornuses
cornute939643cornute
corpse104013403co_rpse
corpus106015293corpus_
corpuses12310063corpuses
corse75036183co__rse
costume1157853costume
coude85022633co__ude
coupe96023483co__upe
course85117783co_urse
couture9310623couture
cowfish1836433cowfish
coypus13389303coypus_
crouse84619363c_rouse
cruse75726103c__ruse
defuse105712723_defuse
diffuse1444373diffuse
doofus1036163doofus_
doofuses1244283doofuses
douse66329723do__use
effuse1234963_effuse
fondue104510493fondu_e
fondues11399313fondues
fondus105210943fondus_
fuse76429993___fuse
house89131423ho__use
incuse83513573_incuse
infused11329253_infused
infuser10298323_infuser
infuses102711873_infuses
ionise63516943ion_ise
louse56131013lo__use
mouse77133003mo__use
nonfuel1045733nonfuel
nonuser7299143non_user
nonuses73313863non_uses
obtuse8147483_obtuse
onrush935343_onrush
onus45826813_on_us_
onuses65616253_on_uses
perfuse1247663perfuse
profuse1237153profuse
refuse94817513_refuse
reinfuse1144783reinfuse
rondure837313rondure
rouse56634703ro__use
scouse84113633sco__use
souse56530773so__use
suffuse1335443suffuse
tofus86415423to_fus_
tongue7410093tongu_e
tongues879693tongues
tonsure758783tonsure
tonus56324303ton_us_
tonuses73612193ton_uses
touse55430673to__use
unconfused1642953unconfused
unconfuses1553213unconfuses
unfused11319513_unfused
youse85322233yo__use
zonule1577483zon_ule

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 Filter1786911340270.436409841.7
2DLD Change Limit1340272498.34316064.6
3Display Results2492490.1102263.6
 (SQL Overall)1786912498.88920102.5
 
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.