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

167 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
confided153745(None) 
confide13310201confide_
confider1438121confider
confides14310571confides
confined14310401confined
coffined1735992coffined
coincided1544022coincided
collided12309802collided
conceded1438292conceded
confident1549382confident
confiders1537482confiders
confine12315582confine_
confiner13311192confiner
confines13315652confines
confirmed1745562confirmed
confused1437032confused
confuted1437682confuted
connived1436432connived
consider11310392consider
cowhided1843752cowhided
bonded104719953bon__ded
bonfire1287063bonfire_
bonfires1367383bonfires
candider1237343candider
candied113816023candi_ed
canfield1444333canfield
chided135113963c__hided
cockaded1836393cockaded
codded114515303co__dded
coded95433183co___ded
codified1537403codified
coedited1237833coedited
coffered1737673coffered
coffled16297363co_ffled
cognised1256313cognised
cognized2136293cognized
coheaded1536603coheaded
coifed124113063co__ifed
coiffed1635413coif_fed
coiled95123943co__iled
coincide1346493coincide_
coincides1446433coincides
coined94523603co__ined
cojoined1856293cojoined
collide103214793collide_
collider113410423collider
collides113214473collides
collied103316673colli_ed
colluded12296463colluded
combined15269183combined
comfier1439163comfi_er
commixed2264743commixed
compiled1537813compiled
concaved1636223concaved
concede12310103concede_
conceder1338743conceder
concedes13311063concedes
conceited14310423conceited
conceived1746713conceived
concise11314473concise_
conciser12310243conciser
concluded1544033concluded
condoled123110723condoled
condoned122612023condoned
conduced14136963conduced
coned86040053con___ed
confabbed1942463confabbed
confected1739073confected
confer114018683conf__er
conferee13613733conferee
conferred1537753conferred
confessed1546053confessed
confidant1547623confidant
confidence1847063confidence
confiding1638333confiding
configured1743323configured
confiners1439953confiners
confirm1437363confi_rm
confirmer1665663confirmer
confirms1536303confirms
confit113316403confi__t
confiteor1443873confiteor
confits122811423confi_ts
conflated1539333conflated
conflicted1844053conflicted
conformed1767463conformed
confound1445903confound
confounded1743293confounded
confuse1238853confuse_
confuses13310363confuses
confute1239263confute_
confuter1338513confuter
confutes1339843confutes
congaed11399743con_gaed
congeed113212313con_geed
conidia1069303con_idia
conies84338593con_i_es
conifer123212643con_ifer
coniine9316803coniine_
coniines10415363coniines
conine84528553con_ine_
conines93827793con_ines
conjoined1965463conjoined
conjured18117903conjured
conked135019113con__ked
conned95119703con__ned
connive1238993connive_
conniver1337493conniver
connives1339723connives
connoted1138863connoted
conoid9818883conoi__d
conoidal1149013conoidal
conoids10813883conoid_s
considered1444283considered
considers1238933considers
consigned1346323consigned
consisted1238503consisted
consoled112911453consoled
conspired1445663conspired
consumed1337923consumed
contained12310893contained
contended1339273contended
continued1248483continued
contrived1547993contrived
contused1138443contused
convened143412223convened
conveyed17247923conveyed
convicted1746313convicted
convinced1745363convinced
convoked18236163convoked
convoyed17225553convoyed
copied114618563co_pi_ed
coppiced1734823coppiced
corded105923353co__rded
cornfed1337383cornf__ed
cornfield1542853cornfield
corniced1368593corniced
cornified1546623cornified
corraded12128293corraded
corroded12147513corroded
cosied94819883co_si_ed
cowhide1636143cowhide_
cowhides1736013cowhides
cozied184112153co_zi_ed
cyanided15254893cyanided
fonded115717043fon__ded
hongied12308163hongi_ed
honied104818393hon_i_ed
infidel1146043_infidel
infixed18206563_infixed
ionised82911493ion_ised
ionized172611293ion_ized
loided83414023lo__ided
lopsided1244253lopsided
monied94319463mon_i_ed
nided75920873__n_ided
nonfunded1443383nonfunded
onside7511803_onside_
ponded105218773pon__ded
ponied94920703pon_i_ed
reconfined1645683reconfined
unaided92414603_unaided
unconfined1644433unconfined
unfaded123111733_unfaded
unfired112212453_unfired
unfixed18218563_unfixed
voided114011133vo__ided

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621676.59622159.2
3Display Results1671670.0762197.4
 (SQL Overall)1786911677.09225196.1
 
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.