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 “boron” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
boron7672714(None) 
baron78131241baron
boon67142171bo_on
born67338411bor_n
borons85520541borons
boson76019731boson
moron76925421moron
aboon74918702abo_on
apron7318832apron
bacon95620592bacon
barn66444642bar_n
barong96015822barong
barons85025382barons
barony115915302barony
baryon111211612baryon
baton75822422baton
belon73924112belon
beton76022062beton
bicron103710772bicron
biotron937292biotron
biro66131212biro_
biros75325132biros
bison75716982bison
bogan87519002bogan
boho96923322boho_
bohos105618252bohos
bolo65535952bolo_
bolos75531372bolos
bolson8410682bolson
bonbon10310072bonbon
boo58163662bo_o_
boob85932582bo_ob
book106836332bo_ok
boom87435672bo_om
boons75031912bo_ons
boor66130682bo_or
boors74325012boors
boos67955032bo_os
boot67759372bo_ot
bora66141632bor_a
boral75831702boral
borane84620212borane
boras75938302boras
borax145918722borax
bore66051332bor_e
bored85034302bored
boreen8314312boreen
borer75131272borer
bores76448252bores
boric98024222boric
boring94724872boring
bork106933822bor_k
borks115727702borks
borne77926792borne
boronic11311162boronic
borrow114310722borrow
bort65960962bor_t
borts76735452borts
borty105522832borty
bortz165722202bortz
borzoi1736622borzoi
bosom95516922bosom
bosons85016652bosons
boston8513042boston
bosun75113592bosun
bourbon1135812bourbon
bourdon1036422bourdon
bourn75518482bourn
bouton8311532bouton
boyo96923842boyo_
boyos105418282boyos
bozo156821412bozo_
bozos165216862bozos
bran65740382b_ran
bren65629562b_ren
brin67038192b_rin
bro56236602b_ro_
bronc91714342b_ronc
broo65129822b_roo
brood84620242brood
brook114717762brook
broom95022212broom
broos75126412broos
bros65635662b_ros
brow97228442b_row
brown105619532brown
buran75225302buran
burin75626062burin
burn65636432bur_n
burton8311272burton
codon86522852codon
cogon89120902cogon
colon78630192colon
coon67248942co_on
cordon95017292cordon
corn69945812cor_n
corona83817402corona
croon75522782croon
giron66118992giron
goon57236172go_on
gorgon8310242gorgon
gyron95314622gyron
heron85025502heron
horn76735612hor_n
iron46728462_iron
jomon14610082jomon
korun9411922korun
kroon94514482kroon
logon615922312logon
loon47344792lo_on
loran55925092loran
lorn46435252lor_n
moon67140812mo_on
morion86217732morion
morn66237562mor_n
morons84919542morons
noon47134622no_on
orlon5415002_orlon
poon67341262po_on
porn65636022por_n
porno75120652porno
solon55026132solon
soon46240502so_on
sorn46641062sor_n
thoron94713902thoron
toon47740632to_on
torn46044252tor_n
toro48045682toro_
toros54336192toros
torot56139942torot
toyon86715672toyon
worn75631752wor_n
zoon137326982zo_on

Search took 4 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 Filter178691538000.610292936.1
2DLD Change Limit538001333.23316640.9
3Display Results1331330.0801662.5
 (SQL Overall)1786911333.92345549.6
 
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.