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

244 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
confides1431057(None) 
confide13310201confide_
confided1537451confided
confider1438121confider
confiders1537481confiders
confines13315651confines
bonfires1367382bonfires
coincides1446432coincides
collides113214472collides
concedes13311062concedes
confident1549382confident
confine12315582confine_
confined14310402confined
confiner13311192confiner
confiners1439952confiners
confirms1536302confirms
confits122811422confi_ts
confuses13310362confuses
confutes1339842confutes
conies84338592con_i_es
coniines10415362coniines
conines93827792con_ines
connives1339722connives
conoids10813882conoid_s
consider11310392consider
considers1238932considers
cowhides1736012cowhides
aconites10314353acon_ites
bolides10515073bo_lides
bonfire1287063bonfire_
borides10515153bo_rides
candidas12338653candidas
candider1237343candider
candidest1346533candidest
candids113812693candid_s
candies104125613candi_es
canids95118133can_id_s
canines93724033can_ines
carbides133111693carbides
centiles103615813centiles
centimes124012613centimes
chides124620473c__hides
cocaines121314443cocaines
coccids11277213coccid_s
cockades1738433cockades
codeines113114523codeines
codes86247293co___des
codfishes1845643codfishes
codices12512583co_dices
codifies1439643codifies
codrives1437663codrives
coesites101313093coesites
coffees15329573co_ffees
coffined1735993coffined
coffins153110193coffi_ns
coffles152610003co_ffles
cognises11610043cognises
cognizes2058033cognizes
coiffes1546803coif_fes
coincide1346493coincide_
coincided1544023coincided
colies84837053co_li_es
collide103214793collide_
collided12309803collided
collider113410423collider
colliders12298073colliders
collies94326583colli_es
colludes11279223colludes
combines142814623combines
comedies13311843comedies
comfier1439163comfi_er
comfiest1539133comfi_est
comfiness1646953comfiness
comfits14328743comfi_ts
commies133718453commi_es
commixes2177353commixes
commodes1539093commodes
compiles14311983compiles
comrades13149773comrades
concaves1538913concaves
concede12310103concede_
conceded1438293conceded
conceder1338743conceder
conceders1437953conceders
conceives1639233conceives
conches144019813con_ches
conchies153214853conchies
concise11314473concise_
conciser12310243conciser
concisest1348253concisest
concludes1445143concludes
condoes104319203con_does
condoles113015803condoles
condones112817393condones
condores113315643condores
condos94322333con__dos
conduces13129783conduces
condyles14277463condyles
cones76457423con___es
confabs1435393conf_abs
confects153110873confects
confer114018683conf__er
conferee13613733conferee
conferees14610623conferees
confers124120093conf_ers
confess12399903conf_ess
confesses1438623confesses
confidant1547623confidant
confidantes1754143confidantes
confidants1644813confidants
confidence1847063confidence
confidences1946633confidences
confiding1638333confiding
configures1644213configures
confirm1437363confi_rm
confirmed1745563confirmed
confirmer1665663confirmer
confirmers1744963confirmers
confit113316403confi__t
confiteor1443873confiteor
confiteors1543823confiteors
confitures1545603confitures
conflates14311133conflates
conflicts1644793conflicts
confluxes2143833confluxes
conforms1538873conforms
confreres1448033confreres
confuse1238853confuse_
confused1437033confused
confute1239263confute_
confuted1437683confuted
confuter1338513confuter
confuters1437793confuters
congees103517923con_gees
conges94928173con__ges
congius103210073congi_us
congoes103617303con_goes
conics103920593con_i_cs
conidia1069303con_idia
conifer123212643con_ifer
conifers133611703conifers
coniine9316803coniine_
conine84528553con_ine_
conins84327233con_i_ns
conioses10313323conioses
coniums11311863con_iums
conjures17119913conjures
connive1238993connive_
connived1436433connived
conniver1337493conniver
connivers1436933connivers
connotes10311453connotes
conoid9818883conoid__
conoidal1149013conoidal
consigns1137533consigns
consists10310593consists
consoles103216153consoles
conspires1358483conspires
consumes12310413consumes
contes84432913con__tes
continues11310993continues
contrives14311703contrives
contuses10413453contuses
convenes132916913convenes
convexes20278273convexes
convicts15337713convicts
convinces1647833convinces
convokes17247703convokes
cookies133719273cooki_es
coolies93824963cooli_es
coonties10513803coonti_es
cooties93725733cooti_es
copies104130313co_pi_es
coppices1638243coppices
corbies113520123corbi_es
cordites11314633cordites
cornices12713303cornices
cornifies1439003cornifies
corodies11313693corodies
corrades111211263corrades
corridas1177323corridas
corries94026803corri_es
corrodes111310333corrodes
cortices12615023cortices
corvids1337683corvid_s
cosies84932163co_si_es
cosines94122673co_sines
cosmids1237633cosmid_s
counties10316283counti_es
couvades1435613couvades
cowfishes2045723cowfishes
cowhide1636143cowhide_
cowhided1843753cowhided
cowpies143314283cowpi_es
cowries124218013cowri_es
cowrites133011593cowrites
coxitides1945113coxitides
cozies174521413co_zi_es
cronies9622513cron_i_es
cuspides13306943cuspides
cyanides14258003cyanides
downsides1444813downsides
ecocides1346583eco_cides
foxfires2142813foxfires
gunfires1235063gunfires
hongies112716473hongi_es
honkies143015143honki_es
infidel1146043_infidel
infidels1244123_infidels
infixes17238133_infixes
insides8512653_insides
iodides93811613io_dides
ionises72916433ion_ises
ionizes162813343ion_izes
ironsides1045293ironsides
joyrides1943853joyrides
longies82916553longi_es
monades103713823mon_ades
mondes94322353mon__des
monies83233163mon_i_es
monodies11312503monodies
monoxides1946133monoxides
nides65229133__n_ides
nonlives1138363nonlives
noontides1075123noontides
offices1536243_offices
offsides1543393_offsides
onside7511803_onside_
oreides8312023_oreides
oroides8311973_oroides
oxides14109693_o_xides
ozonides1854293ozon_ides
pongids11347413pongid_s
ponies84833463pon_i_es
reconfines1546653reconfines
roofies103014413roofi_es
sondes74922873son__des
sonnies7315223sonni_es
sulfides1238053sulfides
toffies133210213toffi_es
toluides935553toluides
tontines82114733tontines
topsides1137203topsides
unfixes17238113_unfixes

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622447.79618748.3
3Display Results2442440.0932623.7
 (SQL Overall)1786912448.29521542.0
 
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.