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

309 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
weer7553509(None) 
beer65635991beer
deer56739021deer
ewer77523981ewer
jeer115426461jeer
leer46239351leer
peer66238351peer
seer45547041seer
sweer84918571sweer
veer76229571veer
wear75836721wear
weber10313521weber
wee66760811wee_
weed85637511weed
week116428151week
weel75834081weel
ween75835461ween
weep95131651weep
wees76249121wees
weet75254151weet
weir76019921weir
were76238331were
ager55935842ager
ameer75618982ameer
aper66336232aper
aver75931882aver
awee76336642awee_
bear66844642bear
bee56262402bee_
beef96233682beef
been65335782been
beep85931212beep
beers75628392beers
beery105220122beery
bees65453382bees
beet66457542beet
bier65531832bier
ceder85322242ceder
cee55952702cee_
cees65941592cees
cere66741472cere
cheer105420382cheer
dear55343602dear
dee47665822dee_
deed65340902deed
deem75432892deem
deep76031882deep
deers64930522deers
dees56356632dees
deet57356582deet
defer94619752defer
dere56845902dere
deter65028042deter
doer57734702doer
dweeb1137742dweeb
dyer85522112dyer
ear36867882_ear
eek77935102_eek
eel37946842_eel
eery76129622_eery
eger55923572eger
emeer74815362emeer
er28345142__er
ere36352772_ere
err35626532_err
ever77027692ever
ewe66630982ewe_
ewers86018822ewers
ewes76328702ewes
eyer76127282eyer
fear75337792fear
fee66862012fee_
feeb96924542feeb
feed84538902feed
feel75233842feel
fees76450602fees
feet75352212feet
fer66646122_fer
fere76342232fere
fever115617952fever
fewer115216122fewer
feyer115014522feyer
fleer86020772fleer
freer86021242freer
gear55934972gear
gee45359202gee_
geed65435502geed
geek95327022geek
gees55647882gees
geez146424862geez
goer56827102goer
hear76143882hear
heder95623642heder
heed86437602heed
heel75034222heel
heir77523802heir
her66547812_her
here76447102here
hewer115719932hewer
hexer155116682hexer
hoer76533982hoer
jee106648642jee_
jeed125428502jeed
jeep135624842jeep
jeers124818132jeers
jees115938542jees
jeez205622032jeez
keef115830002keef
keek75624972keek
keel85729472keel
keen84830412keen
keep106329822keep
keet85347342keet
keir86217872keir
kier86526812kier
lear47045952lear
lee36068142lee_
leek85331732leek
leers54828982leers
leery85919132leery
lees45455882lees
leet45957902leet
leger65721512leger
lehr75514942lehr
leper74820742leper
lever85125162lever
lier45942462lier
meed74934702meed
meek105624832meek
meet65350552meet
mere67244442mere
merer75126232merer
meter75130322meter
near45236502near
nee36657782nee_
need54934152need
neem67328082neem
neep65728312neep
never86218642never
newer85717462newer
omer67028392omer
over77227342over
owner84613312owner
oyer75927652oyer
pear69745232pear
pee56066512pee_
peed76239182peed
peek106031432peek
peel65535612peel
peen65938082peen
peep85833692peep
peers75130272peers
peery105719442peery
pees65257372pees
per56353092_per
pere66450262pere
peter74427592peter
pier66035292pier
queer143712812queer
rear45644552rear
ree37974072ree_
reed55549622reed
reef74938212reef
reek85232522reek
reel45240532reel
rees45364192rees
refer84822142refer
ruer46127562ruer
sear47353842sear
seder64826762seder
see35772262see_
seed55549482seed
seek85935482seek
seel45042982seel
seem65438562seem
seen46943122seen
seep66540342seep
seers55136382seers
sees45361052sees
ser36752402_ser
sere46153472sere
serer55935512serer
sever85426052sever
sewer84426222sewer
sheer84726892sheer
sneer54919952sneer
speer74623902speer
steer55423862steer
suer45334032suer
swear85316852swear
sweep104715722sweep
sweet85330522sweet
tear45242882tear
tee38366872tee_
teed55439262teed
teel46335802teel
teem66132602teem
teen45938202teen
tees45353582tees
tier44936142tier
twee76827082twee_
tweed94915092tweed
tween84413742tween
tweet84823982tweet
twier84713292twier
twyer11558522twyer
tyer75323392tyer
user45023002user
vee65750182vee_
veep95325092veep
veers84521362veers
veery115816252veery
vees75439432vees
vexer155513522vexer
vier75428152vier
wader95325362wader
wae67556952wae_
waes76048602waes
wafer114417642wafer
wager95925052wager
wair75830052wair
waker125526592waker
waler84229262waler
war67262422w_ar
ware76254722ware
water84733312water
waur76819902waur
waver115025702waver
waxer154317482waxer
we57043452w_e_
weak117126302weak
weaker134015442weaker
weal75838682weal
wean75734352wean
weaner93816772weaner
wearer94319402wearer
wears86030302wears
weary115620612weary
weaver123916612weaver
web85735562w_eb
webers11310942webers
webs96622122webs
wed75843622w_ed
wedder113612302wedder
wedel94513962wedel
weds86628932weds
weeder103315512weeder
weeds95222212weeds
weedy125115002weedy
weeks125017862weeks
weens85224052weens
weeny115316162weeny
weeper114313302weeper
weeps104120562weeps
weepy134212592weepy
weest85026772weest
weets85427722weets
weever123811442weever
weft105435012weft
weiner94214132weiner
weird95111282weird
weirs84316492weirs
weka117013872weka
weld84727732weld
welder102914412welder
well75832042well
welt75547862welt
welter93417382welter
wen66249602w_en
wend85330452wend
wens76337932wens
went76051872went
wept95635052wept
wert79749822wert
west75748082west
wester94222892wester
wet65966622w_et
wether123315392wether
wets75940292wets
wetter93919442wetter
whee105429592whee
wheel115515332wheel
wheen115016052wheen
wheep136214352wheep
when105723042when
where117019422where
whet105133782whet
whew137618782whew
whey135018712whey
whir105519282whir
wider94826352wider
wiener94513542wiener
wiper105421292wiper
wire75839812wire
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
woe66651242woe_
woes76440662woes
wooer84316692wooer
wore77144672wore
wren78221682wren
wrier84521752wrier
wryer11489302wryer
wye96331972wye_
wyes105727502wyes
year76534252year
zee126143232zee_
zees136331892zees

Search took 5 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.656272394.8
2DLD Change Limit298723092.07614389.2
3Display Results3093090.406761.1
 (SQL Overall)1786913093.13856944.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.