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

256 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
confide1331020(None) 
confided1537451confided
confider1438121confider
confides14310571confides
confine12315581confine
bonfire1287062bonfire
coincide1346492coincide
collide103214792collide
concede12310102concede
concise11314472concise
confident1549382confident
confiders1537482confiders
confined14310402confined
confiner13311192confiner
confines13315652confines
confirm1437362confirm
confit113316402confi_t
confits122811422confits
confuse1238852confuse
confute1239262confute
coniine9316802coniine
conine84528552con_ine
connive1238992connive
conoid9818882conoid_
conoids10813882conoids
consider11310392consider
cowhide1636142cowhide
onside7511802_onside
aconite9315473acon_ite
bolide9515563bo_lide
bonfires1367383bonfires
bonnie85314853bonni_e
boride9415903bo_ride
candid104517853candid_
candida114110253candida
candider1237343candider
candids113812693candids
candied113816023candied
canid85526343can_id_
canids95118133can_ids
canine83826703can_ine
cannie83819363canni_e
carbide126112493carbide
centile94217183centile
centime114513033centime
chide115321013c__hide
cnida878953c_n_ida
cnidae978143c_n_idae
cocaine111315173cocaine
coccid102910743coccid_
coccids11277213coccids
cockade1638133cockade
code77347733co___de
codeine103815033codeine
codfish1637163codfish
codified1537403codified
codrive1337653codrive
coesite9713623coesite
coffee144113743co_ffee
coffin14339813coffi_n
coffined1735993coffined
coffing163811253coffing
coffins153110193coffins
coffle14359043co_ffle
coffled16297363coffled
cognise1059683cognise
cognize1957683cognize
coifed124113063coifed_
coiffe1447043coif_fe
coiffed1635413coiffed
coifing133213893coifing
coincided1544023coincided
coincides1446433coincides
collided12309803collided
collider113410423collider
collides113214473collides
collie83621993colli_e
collied103316673collied
collude10337993collude
comade114415323co_made
combine133014723combine
comfier1439163comfier
comfit133112423comfi_t
comfits14328743comfits
commie124215523commi_e
commode1438123commode
compile13312443compile
comrade12139213comrade
conative131214623conative
concave1439373concave
conceded1438293conceded
conceder1338743conceder
concedes13311063concedes
conceive1539233conceive
conchae143911643conchae
conchie143312683conchie
conciser12310243conciser
conclude1344673conclude
condign1147733condign
condo85322593con__do
condole102914953condole
condone102616293condone
conduce12139233conduce
condyle13247053condyle
cone67256963con___e
coned86040053con_ed_
confab1347063conf_ab
confabs1435393confabs
confect143614273confect
confer114018683conf_er
conferee13613733conferee
confers124120093confers
confess12399903confess
confidant1547623confidant
confidante1644883confidante
confidence1847063confidence
confiding1638333confiding
configure1544463configure
confiners1439953confiners
confirmed1745563confirmed
confirmer1665663confirmer
confirms1536303confirms
confiteor1443873confiteor
confiture1445953confiture
conflate13311173conflate
conflict1547753conflict
conflux1943003conflux
conform14310463conform
confrere1347563confrere
confused1437033confused
confuses13310363confuses
confuted1437683confuted
confuter1338513confuter
confutes1339843confutes
congaed11399743congaed
conge85227593con__ge
congee96024473con_gee
congeed113212313congeed
congii957363congi_i
congius103210073congius
coni65534803con_i__
conic95329793con_i_c
conics103920593con_ics
conidia1069303con_idia
conies84338593con_ies
conifer123212643conifer
coniines10415363coniines
conin76232723con_i_n
conines93827793con_ines
coning94331823con_ing
conins84327233con_ins
conium10415313con_ium
conjure16109073conjure
conked135019113conked_
conking143618453conking
connate9315753connate
conned95119703conned_
conning103718753conning
connived1436433connived
conniver1337493conniver
connives1339723connives
connote9311613connote
conoidal1149013conoidal
considers1238933considers
consign1038773consign
consist9316033consist
console92715983console
conspire1257873conspire
consume11510133consume
conte76633203con__te
continue10311123continue
contrite10318543contrite
contrive13311353contrive
contuse9311413contuse
convene123314323convene
convict143410983convict
convince1547363convince
convoke16207173convoke
cookie123716043cooki_e
coolie83821603cooli_e
coontie9311423coonti_e
cootie84223093cooti_e
copied114618563co_pied
coppice1537483coppice
corbie103618203corbi_e
cordite10315263cordite
cornfed1337383cornfed_
cornice11612933cornice
cornified1546623cornified
corrade101111043corrade
corrida1078503corrida
corrie83621223corri_e
corrode101310573corrode
corvid12310473corvid_
corvids1337683corvids
corvine122113643corvine
cosie74728263co_si_e
cosied94819883co_sied
cosine83823513co_sine
cosmid11810643cosmid_
cosmids1237633cosmids
costive12312843costive
coude85022633co__ude
couvade1335063couvade
cowfish1836433cowfish
cowhided1843753cowhided
cowhides1736013cowhides
cowpie133511513cowpi_e
cowrie113814283cowri_e
cowrite123612683cowrite
cozie163519133co_zi_e
cozied184112153co_zied
cyanide13298843cyanide
donsie7613643donsi_e
downside1345293downside
ecocide1246733eco_cide
foxfire2042563foxfire
gunfire1134743gunfire
hongied12308163hongied
honied104818393hon_ied
honkie133011673honki_e
infidel1146043_infidel
inside7613453_inside
iodide84812933io_dide
ionise63516943ion_ise
ionize154613873ion_ize
ironside945853ironside
joyride1853753joyride
monde85723143mon__de
monie75631653mon_i_e
monied94319463mon_ied
monoxide1846293monoxide
nide55535793__n_ide
nonlife1038553nonlife
noontide986133noontide
office1435693_office
offside1453693_offside
online6315843_online
oreide7311673_oreide
oroide7311703_oroide
oxide131210953_o_xide
ozonide1754963ozon_ide
pongid104111583pongid_
pongids11347413pongids
ponied94920703pon_ied
pontine92419053pontine
reconfine1448013reconfine
roofie93411173roofi_e
snide64318723_sn_ide
sonde64622833son__de
sonlike112110713sonlike
sonsie6614863sonsi_e
sulfide1138103sulfide
toluide835263toluide
tontine72316143tontine
topside1037733topside

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.440406115.9
2DLD Change Limit1340272567.07618941.1
3Display Results2562560.0932752.7
 (SQL Overall)1786912567.60923484.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.