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

234 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
borrows1234925(None) 
barrows123411681barrows
borrow114310721borrow_
burrows12399091burrows
morrows12318721morrows
sorrows10278401sorrows
arrows92813482_arrows
barlows12259972barlows
barrow114512762barrow_
borons85520542bo_rons
borrowed1465042borrowed
borrower1384832borrower
borrowers1474022borrowers
borzois1835832borzois
bowwows1454122bowwows
brows105425982b__rows
burros85114992burro_s
burrow114610802burrow_
cornrows1345312cornrows
farrows13259782farrows
furrows13327792furrows
harrows132611032harrows
horrors1078692horrors
marrows122911822marrows
morros83714672morro_s
morrow113510092morrow_
narrows10258842narrows
sorrow9339442sorrow_
yarrows13277852yarrows
arrow83414883_arrow_
arrowy12288273_arrowy
barhops14288113barhops
barlow112911423barlow_
barons85025383b_arons
barrels94514363barrels
barrens94414323barrens
barres84427543barr_es
barrets94917103barrets
barrios9310773barrios
barroom1139373barroom
barrooms1237893barrooms
baryons121010473baryons
becrowd1555173becrowd
becrowds1683773becrowds
bellows124313303bellows
belows114614183b_elows
berries94423553berries
besnows1245153besnows
bestows1248863bestows
bestrows1337043bestrows
bicrons113410473bicrons
billows123611293billows
biotrons1037233biotrons
biros75325133b_iro_s
birrs74917103birr__s
blows105423833b__lows
boards94616933boar_ds
boars75229603boar__s
boarts84716873boar_ts
boffos14568193boffo_s
bohos105618253bo_ho_s
boleros9310293bolero_s
bolos75531373bo_lo_s
bolsons969483bolsons
bonbons1139333bonbons
bongoes104314113bongoes
bongos95316653bongo_s
booboos1138143booboos
boobs96221993bo__obs
boocoos1137753boocoos
boohoos1237993boohoos
bookoos1337503bookoos
books115729713bo__oks
booms95427123bo__oms
boons75031913bo__ons
boors74325013bo__ors
boos67955033bo__o_s
boots75837973bo__ots
boraces113716853boraces
borages103917163borages
borals86721913bo_rals
boranes93720403boranes
boras75938303bo_r_as
borates94823013borates
boraxes163511633boraxes
bordels103911973bordels
borders104317533borders
boreas85421733bo_reas
boredoms1346043boredoms
boreens9310403boreens
borers85122683bo_rers
bores76448253bo_r_es
borides10515153borides
borings103614243borings
borks115727703bo_r_ks
borneols1046343borneols
boron76727143bo_ro_n
borrowing1544563borrowing
borrowings1642143borrowings
borshts1266543borshts
borts76735453bo_r_ts
bortzes1838223bortzes
borzoi1736623borzo_i
bosoms104913053bo_soms
bosons85016653bo_sons
bostons9312903bostons
bottoms1136993bottoms
boubous1138693boubous
bourbons1245343bourbons
bourdons1136433bourdons
bourgs9459993bour_gs
bournes93615023bournes
bourns84114063bour_ns
bourrees10127643bourrees
bourses94014303bourses
boutons9310783boutons
bowpots1446023bowpots
bows96242863b___ows
bowwow1334463bowwow_
boyos105418283bo_yo_s
bozos165216863bo_zo_s
braws106425193b__raws
brews105617073b__rews
brios74725723b_rio_s
bromos104213313bromo_s
broods95416383b_roods
brooks125813883b_rooks
brooms104915873b_rooms
broos75126413b__roos
bros65635663b__ro_s
brow97228443b__row_
brown105619533b__rown
browns116415633b__rowns
browse115713853b__rowse
burbots1168673burbots
burgoos1037123burgoos
burnous938823burnous
burrers93814493burrers
burro75018493burro__
burrowed1444443burrowed
burrower1374263burrower
burrowers1483493burrowers
burrs74925653burr__s
burtons9310853burtons
carroms11512403carroms
carrots9714623carrots
cirrous93111063cirrous
cordons104415763cordons
cormous11312353cormous
cornrow1245603cornrow_
corrals93713853corrals
corries94026793corries
corrode101310573corrode
corrodes111310333corrodes
corrody13136143corrody
crows105727313__crows
dobros93910233dobro_s
dorrs65520593dorr__s
errors63311313_errors
escrows1235803escrows
farrow12309973farrow_
ferrous1049793ferrous
fogbows1643853fogbows
follows13409923follows
fordoes11311963fordoes
forgoes11311353forgoes
formols12299413formols
frows116623103__frows
furrow12427743furrow_
furrowy16384473furrowy
garrons82713463garrons
gorgons938853gorgons
grows95523923__grows
harrow122610773harrow_
hollows134412333hollows
horror988723horro_r
hotrods1148283hotrods
karroos1139313karroos
kotows13446523ko_tows
kouros1039183kouro_s
kowtows1742763kowtows
lorries74518343lorries
lowbrows1643483lowbrows
marrons93216973marrons
marrow112812603marrow_
marrowy15236083marrowy
mirrors938623mirrors
morions94014643morions
morons84919543mo_rons
morrions1077673morrions
morris83814733morr_is
morro73216953morro__
narrow9269143narrow_
ordos65216203_ordo_s
orlons6411013_orlons
orlops847303_orlops
orris54516553_orr_is
orzos143311253_orzo_s
outrows10311403outrows
oxbows1833713_oxbows
parrots9312743parrots
perrons93115483perrons
pogroms1237643pogroms
pornos85015253porno_s
porous84419483po_rous
powwows1442853powwows
prows106327013__prows
pyrrols1235403pyrrols
regrows11269153regrows
rows75941753___rows
serows96016393_serows
sordors8310003sordors
sorgos74514663sorgo_s
sorrels7310723sorrels
sorrowed1264833sorrowed
sorrower1165033sorrower
sorrowers1274753sorrowers
sparrows1344803sparrows
strows96718273_strows
terrors73112213terrors
throws129715233_throws
tomorrows1452243tomorrows
toreros7311343torero_s
toros54336193to_ro_s
torous64319033to_rous
torpors939383torpors
torrs53923563torr__s
torsos64815733torso_s
trows88826183__trows
upgrows1334323upgrows
vrows116115263__vrows
worries104117133worries
worrits10258683worrits
yarrow12287933yarrow_

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272347.26618445.8
3Display Results2342340.0763078.9
 (SQL Overall)1786912347.73223110.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.