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

149 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
bonfire128706(None) 
bonfires1367381bonfires
bonier84321992bon_ier
bonnie85314852bonni_e
bonnier94711312bonnier
confide13310202confide
confine12315582confine
confirm1437362confirm
foxfire2042562foxfire
gunfire1134742gunfire
afire86215913__afire
backfire1946003backfire
balefire1344663balefire
bandore10611633bandore
beefier12329093beefier
before11410153b_efore
bemire103312803b_emire
bendier103111413bendier
benefice1545003benefice
benzine1839343benzine
blondine1137153blondine
boccie123311453bocci_e
bodice11711423bo_dice
boffin14359053boffi_n
boffing16339983boffing
boffins15329073boffins
boggier113711583boggier
bogie89524103bo_gi_e
boite74426323bo__ite
bolide9515563bo_lide
bondage1138253bondage
bonder95324783bonder_
bonders104120663bonders
bonding113318433bonding
bone65949323bon___e
bonefish1646283bonefish
boner75133083bon_er_
boners84825433bon_ers
boneyer1237403boneyer
bonging113316373bonging
boniface1543863boniface
boning94223293bon_ing
bonita8312943bon_ita
bonito8313433bon_ito
bonkers134015303bonkers
bonking144116373bonking
bonne75124713bon__ne
bonnily1236873bonnily
bonze165119353bon__ze
bonzer175313673bonzer_
boobie104015293boobi_e
boobird1235233boobird
boogie93515993boogi_e
bookie123516003booki_e
boomier113312183boomier
bootie85421163booti_e
boozier18349013boozier
bordure1035783bordure
bore66051333bo___re
boride9415903bo_ride
bornite9311183bornite
boskier13309173boskier
bossier93712423bossier
bouffe14438313bouf_fe
bougie93613273bougi_e
bouncier1236033bouncier
bouvier1277433bouvier
bovine11712433bo_vine
bowfin14338353bowfi_n
bowfins15267703bowfins
bowlike16349473bowlike
bowline123613113bowline
boxfish2285543boxfish
boxier154311743bo_xier
boxlike20267073boxlike
bronzier1935633bronzier
buffier1568403buffier
bushfire1642603bushfire
comfier1439163comfier
concise11314473concise
confer114018683confer_
conferee13613733conferee
confers124120093confers
confided1537453confided
confider1438123confider
confides14310573confides
configure1544463configure
confined14310403confined
confiner13311193confiner
confines13315653confines
confirmed1745563confirmed
confirmer1665663confirmer
confirms1536303confirms
confit113316403confi_t
confits122811423confits
confiture1445953confiture
conform14310463conform
confrere1347563confrere
confuse1238853confuse
confute1239263confute
conifer123212643conifer
coniine9316803coniine
conine84528553con_ine
conjure16109073conjure
connive1238993connive
conspire1257873conspire
debonaire1242993debonaire
donsie7613643donsi_e
ebonise939613ebon_ise
ebonite9310293ebon_ite
ebonize1838153ebon_ize
entire61617703_entire
fanfare1336673fanfare
fire76245593___fire
foxfires2142813foxfires
goofier11339313goofier
gunfires1235063gunfires
hangfire1543763hangfire
honkie133011673honki_e
infare9313083_infare
infirm1137043_infirm
ionise63516943ion_ise
ionize154613873ion_ize
misfire12229893misfire
moire71017323mo__ire
monie75631653mon_i_e
noncore9411953noncore
nonfarm1246513nonfarm
nonlife1038553nonlife
office1435693_office
online6315843_online
onside7511803_onside
outfire1049713outfire
pontine92419053pontine
postfire1346273postfire
prefire124012813prefire
refire95419473_refire
rimfire1243793rimfire
rondure837313rondure
roofie93411173roofi_e
sonlike112110713sonlike
sonsie6614863sonsi_e
sonsier7711743sonsier
tonier65520713ton_ier
tonsure758783tonsure
tontine72316143tontine
unfired112212453_unfired
venire93513693ven_ire
wonkier1437423wonkier

Search took 7 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.406440125.6
2DLD Change Limit1340271496.03022226.7
3Display Results1491490.0632365.1
 (SQL Overall)1786911496.49927495.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.