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

355 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
doer5773470(None) 
deer56739021deer
doe47361951doe_
doers65225711doers
does56554471does
door56928511door
doper86128391doper
dor47253921do_r
dore56353301dore
dorr56627721dorr
doser66228561doser
doter65428621doter
dour56330431dour
dower95027701dower
dozer158419271dozer
dyer85522111dyer
goer56827101goer
hoer76533981hoer
adder75419592adder
adore65723662adore
adorer74713442adorer
ager55935842ager
aper66336232aper
aver75931882aver
beer65635992beer
bier65531832bier
boar66134292boar
boner75133082boner
boor66130682boor
bore66051332bore
borer75131272borer
bower107328182bower
boxer145016522boxer
coder86134212coder
coed77140542coed
coir66327242coir
comer95832692comer
cooer74831012cooer
coper95336092coper
cor59960942co_r
core67263112core
corer75538872corer
cover105430772cover
cower104531772cower
coyer105222842coyer
dare55848862dare
darer65230792darer
dater65332312dater
de37049542d_e_
dear55343602dear
deb66342692d_eb
dee47665822d_ee
deed65340902deed
deem75432892deem
deep76031882deep
deers64930522deers
dees56356632dees
deet57356582deet
def76546722d_ef
defer94619752defer
del46752752d_el
den47554342d_en
dere56845902d_ere
derm76031892d_erm
deter65028042deter
dev76033772d_ev
dew77139922d_ew
dex116936882d_ex
dey77243372d_ey
dicer85426422dicer
die46759652die_
died66137852died
diel59034602diel
dies55653522dies
diet57357532diet
diker105524552diker
dimer85625602dimer
diner65632902diner
dire56644142dire
direr64927072direr
diver94827802diver
do310155252do__
doat56947672doat
dobber114015412dobber
dobra85013102dobra
dobro84412212dobro
doby106022162doby
doc66841512do_c
dock116228742dock
docker134417652docker
docs75631152docs
dodder94712912dodder
dodger95817042dodger
dodo66024912dodo
doest65829522doest
doeth9411982doeth
doff116225782doff
doffer133911352doffer
dog57449752do_g
doge66233802doge
dogear838192dogear
doges75630162doges
dogey105719512dogey
dogger95216782dogger
dogs66440152dogs
dogy96126492dogy
doit56347852doit
dojo126016142dojo
dol47150652do_l
dole56550002dole
doled75430912doled
doles67843752doles
doll56632492doll
dolor67617962dolor
dols56943052dols
dolt56649422dolt
dom69752442do_m
dome77240732dome
domed95423262domed
domes85735562domes
doms76239572doms
don46757652do_n
dona55529632dona
done55747912done
donee66931012donee
dong66031652dong
donor64418192donor
dons56048702dons
doom76430072doom
doors65022132doors
doozer163910462doozer
dopa77220902dopa
dope76038892dope
doped95326712doped
dopers95522482dopers
dopes84935042dopes
dopey116020352dopey
dopier93515922dopier
dopy106224152dopy
dork96531462dork
dorm76834622dorm
dormer94415892dormer
dorp76028052dorp
dorper94314562dorper
dorrs65520592dorrs
dors56747602dors
dorser74819172dorser
dory85836232dory
dos48062312do_s
dose56442432dose
dosed76626912dosed
dosers75723632dosers
doses65938502doses
doss56235042doss
dosser74417972dosser
dost57248352dost
dot47573182do_t
dote55442882dote
doted75227072doted
doters74423912doters
dotes65836692dotes
doth86225712doth
dotier73917032dotier
dots55647662dots
dotter74419342dotter
doty86128222doty
doum76226672doum
doura66518662doura
dourer74215272dourer
douser75621632douser
doux125817982doux
dove85131562dove
doven94718552doven
doves94728152doves
dow76749972do_w
dowed104632612dowed
dowel95618192dowel
dowers104523292dowers
dowery134311662dowery
down86427492down
downer104414922downer
dowry126312482dowry
dows85941052dows
dowser104716082dowser
doxy156419952doxy
doyen95014412doyen
doze145829082doze
dozed165619352dozed
dozen155017472dozen
dozers164815422dozers
dozes155226302dozes
dozier163611632dozier
dozy175920322dozy
drear65016902drear
dree56638322dree
dreg66821652dreg
drek96321082drek
drew86221672drew
drier64423962drier
droner74717672droner
drover104614592drover
dryer95111462dryer
due45249862due_
duel56729702duel
dues56045502dues
duet56446262duet
duper85519002duper
dure56341812dure
durr55624352durr
dye75334842dye_
dyed96720762dyed
dyers96617132dyers
dyes85331892dyes
edger75215932edger
eger55923562eger
er28345142__er
ever77027692ever
ewer77523982ewer
eyer76127282eyer
fer66646122_fer
foe66350812foe_
foes76543442foes
for66952072fo_r
fore78351472fore
four76226862four
foyer116416552foyer
goers65520252goers
goes55644092goes
gofer94814282gofer
gomer85220652gomer
goner66025162goner
gor47848262go_r
gore55744962gore
her66547812_her
hoar76729162hoar
hoe67562722hoe_
hoed87837982hoed
hoers85724922hoers
hoes75755732hoes
homer105828452homer
honer85332092honer
hoper105829142hoper
hoser811529762hoser
hour75827312hour
hover115524132hover
idler65015662idler
jeer115426462jeer
joe106642352joe_
joes116635892joes
joey145719332joey
joker165715892joker
kier86526802kier
koel84519942koel
kor76538892ko_r
kore85834162kore
leer46239352leer
lier45942462lier
loner55431042loner
loper75129232loper
lore45850352lore
loser54728672loser
lour45430682lour
lover85526452lover
lower85830412lower
moor66628552moor
moper94925922moper
mor56855002mo_r
more67154522more
mover104220862mover
mower104523452mower
noel45226552noel
noes45845392noes
noir46722432noir
nor38048822no_r
noter55025642noter
oar37057952_oar
odder74515392odder
ode47446582ode_
odea56224572odea
odes57243242odes
odor55718092odor
odour64710472odour
oe28473062_oe_
oes35866192_oes
omer67028392omer
or27354732_o_r
ore36661832_ore
our36042892_our
over77227342over
oyer75927652oyer
peer66238352peer
per56353092_per
pier66035292pier
poem86225772poem
poet65552902poet
poker115122882poker
poler74431792poler
poor65630222poor
pore66451262pore
poser75128772poser
pour611527472pour
power105325952power
roar46328572roar
roe36861072roe_
roes45954132roes
roger64521412roger
roper75431912roper
rover85527372rover
rower85430492rower
ruer46127562ruer
seer45547042seer
ser36752402_ser
shoer84722152shoer
soar46838672soar
sober74822402sober
sore47059532sore
sorer56236572sorer
sour45935892sour
sower85229312sower
suer45334032suer
tier44936142tier
toe310166852toe_
toea46732332toea
toed56137042toed
toes46956442toes
toker95924912toker
toner55336242toner
toper75231022toper
tor39261682to_r
tore47359322tore
torr45630902torr
toter55932132toter
tour45530372tour
tower85729202tower
toyer84521552toyer
tyer75323392tyer
udder76314282udder
undoer73113042undoer
user45023002user
veer76229572veer
vier75428152vier
voe67739052voe_
voes75432822voes
vomer105517382vomer
voter85121052voter
vower115220792vower
weer75535092weer
woe66651242woe_
woes76440662woes
wooer84316692wooer
wore77144672wore
yore76335942yore
your78623432your
zoea137118422zoea
zoner144520342zoner

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 Limit298723550.81336742.9
3Display Results3553550.0933817.2
 (SQL Overall)1786913550.982181966.4
 
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.