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

246 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
burrows1239909(None) 
barrows123411681barrows
borrows12349251borrows
burros85114991burro_s
burrow114610801burrow_
furrows13327791furrows
arrows92813482_arrows
barlows12259972barlows
barrow114512762barrow_
borrow114310722borrow_
brows105425982b__rows
burbots1168672burbots
burgoos1037122burgoos
burnous938822burnous
burrers93814492burrers
burro75018492burro__
burrowed1444442burrowed
burrower1374262burrower
burrowers1483492burrowers
burrs74925652burr__s
burtons9310852burtons
farrows13259782farrows
furrow12427742furrow_
furrowy16384472furrowy
harrows132611032harrows
marrows122911822marrows
morrows12318722morrows
narrows10258842narrows
outrows10311402outrows
sorrows10278402sorrows
yarrows13277852yarrows
arrow83414883_arrow_
arrowy12288273_arrowy
auroras7311703auroras
aurous64119263au_rous
barhops14288113barhops
barlow112911423barlow_
barons85025383b_arons
barrels94514363barrels
barrens94414323barrens
barres84427543barr_es
barrets94917103barrets
barrios9310773barrios
barroom1139373barroom
barrooms1237893barrooms
baryons121010473baryons
baudrons1135763baudrons
becrowd1555173becrowd
becrowds1683773becrowds
bellows124313303bellows
belows114614183b_elows
berries94423553berries
besnows1245153besnows
bestows1248863bestows
bestrows1337043bestrows
bicrons113410473bicrons
billows123611293billows
biros75325133b_iro_s
birrs74917103birr__s
blows105423833b__lows
borons85520543b_orons
borrowed1465043borrowed
borrower1384833borrower
borrowers1474023borrowers
borzois1835833borzois
bourbons1245343bourbons
bourdons1136433bourdons
bourrees10127643bourrees
bows96242863b___ows
bowwows1454123bowwows
braws106425193b__raws
brews105617073b__rews
brios74725723b_rio_s
broods95416383b_roods
brooks125813883b_rooks
brooms104915873b_rooms
broos75126413b__roos
bros65635663b__ro_s
brow97228443b__row_
brown105619533b__rown
browns116415633b__rowns
browse115713853b__rowse
brulots946223brulots
brumous11107443brumous
buboes104513993bu_boes
buckoes153810393buckoes
buckos143710893bucko_s
buffos14447853buffo_s
bugloss1035893bugloss
buhrs104811243buhr__s
bulbous1138293bulbous
bullous9311663bullous
buncos104011593bunco_s
bunions92210473bunions
bunkos124210323bunko_s
buoys104810633bu__oys
burans85019303bu_rans
buras74736303bu_r_as
burbles114916803burbles
burbot10815653burbo_t
burbs95423493bu_r_bs
burdens1039713burdens
burdies104117563burdies
burdock1644603burdock
burdocks1744033burdocks
burds84626063bu_r_ds
bureaus979293bureaus
burets84321263bu_rets
burgees104915893burgees
burgeons1146053burgeons
burgers103918573burgers
burgess10409343burgess
burghs12519923bu_rghs
burgles105615963burgles
burgoo938933burgo_o
burgout1049773burgout
burgouts1145123burgouts
burgs84924093bu_r_gs
burials93612083burials
buriers94017193buriers
buries84633273bu_ries
burins84221893bu_rins
burkas124513803bu_rkas
burkers133716623burkers
burkes124421313bu_rkes
burlaps1156253burlaps
burlers94120273burlers
burleys12479673burleys
burls74228853bu_r_ls
burners94115673burners
burnets93813263burnets
burnies94017823burnies
burnoose1043313burnoose
burnout9310453burnout
burnouts1045263burnouts
burns74926783bu_r_ns
burps94220173bu_r_ps
burqas174410903bu_rqas
burr65631233burr___
burred95820723burr_ed
burrer83718473burr_er
burrier93613553burrier
burriest102911213burriest
burring104016993burring
burrito936223burrito
burritos1044473burritos
burrowing1544473burrowing
burry105221563burr__y
burs65847423bu_r__s
bursars94510893bursars
bursas85318273bu_rsas
burses84425513bu_rses
bursts85116243bu_rsts
burton8311273burto_n
busboys14325023busboys
buteos84913413buteo_s
buttons9310333buttons
butyrous1345443butyrous
carroms11512403carroms
carrots9714623carrots
churros12427583churro_s
cirrous93111063cirrous
cornrows1345313cornrows
crows105727313__crows
cuprous1149743cuprous
curfews15294913curfews
curios83218333curio_s
curious93813563curious
curlews12387393curlews
currans9310613currans
curries93723163curries
currs75624393curr__s
cursors93910023cursors
durions839963durions
durocs9569703du_rocs
duros65422693du_ro_s
durras74713373durr_as
durries83817353durries
durrs65519993durr__s
errors63311313_errors
escrows1235803escrows
euros54920243eu_ro_s
farrow12309973farrow_
ferrous1049793ferrous
frows116623103__frows
furious103110633furious
furores10310033furores
furors9310953fu_rors
furrowed1563833furrowed
furrower1464033furrower
furrowers1563503furrowers
garrons82713463garrons
grows95523923__grows
guiros7389093guiro_s
gurries83515953gurries
harrow122610773harrow_
horrors1078693horrors
hurrahs13336773hurrahs
hurrays13386153hurrays
hurries103919653hurries
jurors1338283ju_rors
karroos1139313karroos
marrons93216973marrons
marrow112812603marrow_
marrowy15236083marrowy
mirrors938623mirrors
morros83714673morro_s
morrow113510093morrow_
murras84916013murr_as
murres85019043murr_es
murreys12367323murreys
murrhas12286173murrhas
murries94118673murries
murrs75521303murr__s
narrow9269143narrow_
outcrows1346653outcrows
outgrows1236283outgrows
outrow9311183outrow_
parrots9312743parrots
perrons93115483perrons
prows106327013__prows
purrs75320433purr__s
pyrrols1235403pyrrols
regrows11269153regrows
rows75941753___rows
serows96016393_serows
sorrow9339443sorrow_
sparrows1344803sparrows
strows96718273_strows
sunbows1236023sunbows
surras65919533surr_as
surreys10489443surreys
terrors73112213terrors
throws129715233_throws
trows88826183__trows
turbos8910783turbo_s
turbots988023turbots
turgors836833turgors
turions7311573turions
turkois1135133turkois
turnons737863turnons
turrets73010673turrets
upbows1384683_upbows
upgrows1334323upgrows
vrows116115263__vrows
yarrow12287933yarrow_

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 Limit1340272465.84622926.3
3Display Results2462460.0932645.2
 (SQL Overall)1786912466.34528162.5
 
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.