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

194 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
brow9722844(None) 
blow95827191blow
bow87051901b_ow
braw94829561braw
brew95023561brew
bro56236601bro_
broo65129821broo
bros65635661bros
brown105619531brown
brows105425981brows
crow96428131crow
frow106425051frow
grow86127301grow
prow97030381prow
row67453671_row
trow78031421trow
vrow105817471vrow
alow75328592alow
arrow83414882arrow
avow107816462avow
barlow112911422barlow
baron78131242baron
barrow114512762barrow
below104617192below
bio57846072bio_
biog76122312biog
bios66335312bios
biro66131202biro_
biros75325132biros
blaw97026722blaw
blew94722432blew
blob86027092blob
bloc85023272bloc
blog75723822blog
blot65842322blot
blown105716672blown
blows105423832blows
blowy134315322blowy
bo410957572b_o_
boa56954032b_oa
bob76755662b_ob
bod67055542b_od
bog67852412b_og
boo58163662b_oo
boob85932582boob
book106836332book
boom87435672boom
boon67142172boon
boor66130682boor
boos67955032boos
boot67759372boot
bop77549482b_op
bora66141632bora
bore66051332bore
bork106933822bork
born67338412born
boron76727142boron
borrow114310722borrow
bort65960962bort
bos57966812b_os
bot59680402b_ot
bowl96827702b_owl
bows96242862b_ows
box1210142342b_ox
boy87753562b_oy
bra56339462br_a
brad75234342brad
brae65639112brae
brag75229722brag
bran65740382bran
bras65746452bras
brat66055542brat
brawl106217962brawl
brawn106018562brawn
braws106425192braws
bray95232902bray
bred75130972bred
bree67241262bree
bren65629562bren
brews105617072brews
brie65837902brie
brig76528032brig
brim85629372brim
brin67038192brin
brio65432492brio
brios74725722brios
bris65539612bris
brit66350152brit
broad84817692broad
brock136017072brock
broil74918222broil
broke116019782broke
brome94421972brome
bromo95217202bromo
bronc91714342bronc
brood84620242brood
brook114717762brook
broom95022212broom
broos75126412broos
brose75227032brose
brosy106115382brosy
broth106521092broth
browed125216392browed
browns116415632browns
browny144510042browny
browse115713852browse
brr56921922br_r
brrr65312292brrr
brut66537962brut
brux136315272brux
buoy95921782buoy
burrow114610802burrow
chow125820992chow
cow89856712_cow
craw97725262craw
crew96122672crew
croc85723732croc
crop87628632crop
crowd115815622crowd
crown105620082crown
crows105727312crows
dhow116614002dhow
dow76749972_dow
draw85623012draw
drew86221672drew
drop75324402drop
drown95515822drown
enow77819872enow
eros45238452eros
flow105924922flow
fro65530642fro_
froe75329992froe
frog85624362frog
from96923922from
frown115415972frown
frows116623102frows
glow85222522glow
grew85620262grew
grog65923342grog
grok95819682grok
grot55942052grot
growl96115822growl
grown95317352grown
grows95523922grows
how97252432_how
iron46728462iron
jow137639302_jow
know116115842know
low66051872_low
meow95117882meow
mow86650352_mow
now65950192_now
ow58950172__ow
plow95923232plow
pow87147282_pow
pro55837262pro_
proa66229962proa
prod76129502prod
prof96134662prof
prog75729002prog
prom87631692prom
prop85932812prop
pros65742782pros
prowl105615122prowl
prows106327012prows
raw67252252_raw
rob56754302_rob
roc520243252_roc
rod47953892_rod
roe36861072_roe
rom59855632_rom
rot37282952_rot
rows75941752_rows
scow96021422scow
serow86720442serow
show106229182show
slow77729492slow
snow76324792snow
sow66554762_sow
stow77325742stow
strow88920572strow
throw118719732throw
tow610557362_tow
trod57627952trod
trog57628212trog
trop66833302trop
trot46351312trot
trows88826182trows
troy77429682troy
vow96136312_vow
vrouw11507342vrouw
vrows116115262vrows
wow96643472_wow
yow96945292_yow

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298721940.87634100.5
3Display Results1941940.0464217.4
 (SQL Overall)1786911940.998179049.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.