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

281 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
borrow11431072(None) 
barrow114512761barrow
borrows12349251borrows
burrow114610801burrow
morrow113510091morrow
sorrow9339441sorrow
arrow83414882_arrow
barlow112911422barlow
barrows123411682barrows
boron76727142bo_ron
borrowed1465042borrowed
borrower1384832borrower
borzoi1736622borzoi
bowwow1334462bowwow
brow97228442b__row
burro75018492burro_
burros85114992burros
burrows12399092burrows
cornrow1245602cornrow
farrow12309972farrow
furrow12427742furrow
harrow122610772harrow
horror988722horror
marrow112812602marrow
morro73216952morro_
morros83714672morros
morrows12318722morrows
narrow9269142narrow
sorrows10278402sorrows
yarrow12287932yarrow
arrows92813483_arrows
arrowy12288273_arrowy
barhop13319643barhop
barlows12259973barlows
baron78131243b_aron
barre75929543barr_e
barred95725793barred
barrel84517873barrel
barren85317613barren
barres84427543barres
barret84930483barret
barrio8312573barrio
barrios9310773barrios
barroom1139373barroom
baryon111211613baryon
becrowd1555173becrowd
bellow114213353bellow
below104617193b_elow
berry104521773berr_y
besnow1145713besnow
bestow1149463bestow
bestrow1237243bestrow
bicron103710773bicron
billow114111223billow
biotron937293biotron
biro66131213b_iro_
biros75325133b_iros
birr66022363birr__
birred94713203birred
birrs74917103birr_s
blow95827193b__low
boar66134293boar__
board85523003boar_d
boards94616933boards
boars75229603boar_s
boart78835933boar_t
boarts84716873boarts
boffo136010373boffo_
boffos14568193boffos
boho96923323bo_ho_
bohos105618253bo_hos
bolero8412093bolero_
boleros9310293boleros
bollox1548743bollox
bolo65535953bo_lo_
bolos75531373bo_los
bolson8410683bolson
bonbon10310073bonbon
bongo85720943bongo_
bongos95316653bongos
boo58163663bo__o_
boob85932583bo__ob
booboo1039463booboo
boocoo1039003boocoo
boohoo1148833boohoo
book106836333bo__ok
bookoo1248343bookoo
boom87435673bo__om
boon67142173bo__on
boor66130683bo__or
boors74325013boor_s
boos67955033bo__os
boot67759373bo__ot
bora66141633bo_r_a
borage93917013borage
boral75831703bo_ral
borals86721913borals
borane84620213borane
boras75938303bo_ras
borate85026153borate
borax145918723bo_rax
bordel94514573bordel
border94419973border
bore66051333bo_r_e
boreal84817213boreal
boreas85421733boreas
bored85034303bo_red
boredom1236943boredom
boreen8314313boreen
borer75131273bo_rer
borers85122683borers
bores76448253bo_res
boric98024223bo_ric
boride9415903boride
boring94724873boring
bork106933823bo_r_k
borked135117293borked
borks115727703bo_rks
born67338413bo_r_n
borne77926793bo_rne
borneol936823borneol
borons85520543borons
borrowers1474023borrowers
borrowing1544563borrowing
borsch1336133borsch
borsht11813503borsht
bort65960963bo_r_t
borts76735453bo_rts
borty105522833bo_rty
bortz165722203bo_rtz
borzois1835833borzois
bosom95516923bo_som
boson76019733bo_son
boston8513043boston
bottom1048723bottom
boubou1038433boubou
bourbon1135813bourbon
bourdon1036423bourdon
bourg84113843bour_g
bourgs9459993bourgs
bourn75518483bour_n
bourne83714093bourne
bourns84114063bourns
bourree91311343bourree
bourse84414333bourse
bouton8311533bouton
bow87051903b___ow
bowpot13410073bowpot
bowwows1454123bowwows
boyo96923843bo_yo_
boyos105418283bo_yos
bozo156821413bo_zo_
bozos165216863bo_zos
braw94829563b__raw
brew95023563b__rew
brio65432493b_rio_
brios74725723b_rios
bro56236603b__ro_
bromo95217203bromo_
bromos104213313bromos
broo65129823b__roo
brood84620243b_rood
brook114717763b_rook
broom95022213b_room
broos75126413b_roos
bros65635663b__ros
brown105619533b__rown
brows105425983b__rows
brr56921923b_rr__
brrr65312293b_rr_r
burbot10815653burbot
burgoo938933burgoo
burr65631233burr__
burred95820723burred
burrer83718473burrer
burrowed1444443burrowed
burrower1374263burrower
burrs74925653burr_s
burry105221563burr_y
burton8311273burton
carrom10513403carrom
carrot8423123carrot
cordon95017293cordon
cornrows1345313cornrows
corral83616253corral
corrie83621223corrie
corrode101310573corrode
corrody13136143corrody
crow96428133__crow
dobro84412213dobro_
dobros93910233dobros
dorr56627723dorr__
dorrs65520593dorr_s
error53712233_error
escrow1135913escrow
farrows13259783farrows
fogbow1544783fogbow
follow124010353follow
fordo97218653fordo_
forgo94418333forgo_
forgot104318133forgot
formol112910333formol
forrit91916623forrit
frow106425053__frow
furrows13327793furrows
furrowy16384473furrowy
garron73113493garron
gorgon8310243gorgon
grow86127303__grow
harrows132611033harrows
hollow124212663hollow
horrid10311563horrid
horrors1078693horrors
hotrod1048803hotrod
karroo10410013karroo
kotow12528713ko_tow
kouroi1036513kouroi
kouros1039183kouros
kowtow1643463kowtow
lorry86315673lorr_y
lowbrow1543273lowbrow
marron83717543marron
marrows122911823marrows
marrowy15236083marrowy
mirror848003mirror
morion86217733morion
moron76925423mo_ron
morrion959003morrion
morris83814733morris
narrows10258843narrows
nohow1137293no_how
ordo54622353_ordo_
ordos65216203_ordos
orlon5415003_orlon
orlop7410903_orlop
orra46120723_orr_a
orris54516553_orris
orzo134516783_orzo_
orzos143311253_orzos
outrow9311183outrow
oxbow1734443_oxbow
parrot8320663parrot
perron83216623perron
pogrom1138593pogrom
porno75120653porno_
pornos85015253pornos
powwow1342833powwow
prow97030383__prow
pyrrol1136273pyrrol
regrow10309883regrow
row67453673___row
serow86720443_serow
sordor7310223sordor
sorgo64719723sorgo_
sorgos74514663sorgos
sorrel6413553sorrel
sorrowed1264833sorrowed
sorrower1165043sorrower
sorry84618253sorr_y
sparrow1234263sparrow
strow88920573_strow
terror63811733terror
throw118719733_throw
tomorrow1342083tomorrow
torero6313203torero_
toreros7311343toreros
toro48045683to_ro_
toros54336193to_ros
torot56139943to_rot
torpor839193torpor
torr45630903torr__
torrid7311853torrid
torrs53923563torr_s
torso56922143torso_
torsos64815733torsos
trow78031423__trow
upgrow1234273upgrow
vrow105817473__vrow
worrit92313313worrit
worry116114333worr_y
yarrows13277853yarrows

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 Filter1786911127160.393454684.5
2DLD Change Limit1127162815.57620214.5
3Display Results2812810.0933021.5
 (SQL Overall)1786912816.06229477.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.