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

347 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
yep8663896(None) 
cep75736331cep
hep86644141hep
kep96437201kep
pep76447081pep
rep55847801rep
yap85949821yap
ye57650061ye_
yea66445751yea
yeh97135771yeh
yelp95621351yelp
yen66847381yen
yeps95924401yeps
yes66250611yes
yet66960691yet
yew96436291yew
yip87241171yip
yup86031701yup
zep147129141zep
ae212590292ae_
alp56641132alp
amp77541022amp
ape57251182ape
app76827602app
asp57235342asp
aye67151762aye_
ayes76543512ayes
bap76455842bap
be47948942be_
bed67950622bed
bee56262402bee
beep85931212beep
beg65944132beg
bel57148462bel
ben56554922ben
bes56557432bes
bet58376672bet
bey86645422bey
bop77549482bop
bye86134592bye_
byes95230532byes
cap76758982cap
cee55952702cee
cel56040552cel
cepe84926652cepe
ceps86125952ceps
cop711162372cop
cup76738242cup
dap66652452dap
de37049542de_
deb66342692deb
dee47665822dee
deep76031882deep
def76546722def
del46752752del
den47554342den
dev76033772dev
dew77139922dew
dex116936882dex
dey77243372dey
dip67848982dip
dup67637882dup
dye75334842dye_
dyed96720762dyed
dyer85522112dyer
dyes85331892dyes
ed38645182_ed
eek77935102eek
eel37946842eel
ef57345362_ef
eh58339962_eh
el26745292_el
em49445152_em
en28052392_en
er28345142_er
es29048222_es
et26964192_et
ex98835642_ex
eye65539772eye
eyed86623232eyed
eyen76223662eyen
eyer76127282eyer
eyes75837882eyes
fe57944742fe_
fed76548352fed
fee66862012fee
feh96136092feh
fem86040732fem
fen66851352fen
fer66646122fer
fes66551672fes
fet66471632fet
feu67843662feu
few95436962few
fey95940882fey
fez156236822fez
fop86743702fop
gap67055612gap
ged57044532ged
gee45359202gee
gel45642432gel
gem66840222gem
gen45950512gen
get47467462get
gey75738302gey
gip67645362gip
gyp98319012gyp
hap87360052hap
he58151952he_
heap96432892heap
heh96039622heh
help95328922help
hem86148732hem
hemp115725622hemp
hen67555272hen
her66547812her
hes66654202hes
het67674312het
hew97642722hew
hex137436172hex
hey96741062hey
hip86750432hip
hop87554592hop
hup86437812hup
hyp117822462hyp
hype125519812hype
imp76626962imp
jee106648642jee
jeep135624842jeep
jet106754822jet
jeu105532072jeu
jew135129082jew
kea76540912kea
keep106329812keep
kef105639662kef
keg86432532keg
kelp105322802kelp
kemp126418762kemp
ken76343982ken
kepi105315632kepi
keps106027302keps
kept106232942kept
kex146029582kex
key105833332key
kip97042132kip
kop97440202kop
kye107327272kye_
kyes115124932kyes
lap58565272lap
lea37660182lea
leap66032682leap
led46254552led
lee36068142lee
leg46446112leg
lei36846382lei
lek75640302lek
lept66440882lept
les35663072les
let36481472let
leu36047402leu
lev66139422lev
lex107943822lex
ley66246812ley
lez125541312lez
lip514755802lip
lop58255312lop
lye66533412lye_
lyes75530832lyes
map77255112map
me47748332me_
med66146742med
meg66040952meg
mel56047482mel
mem77943472mem
men59252842men
met56072432met
mew86137732mew
mop76950822mop
nap56753202nap
ne27045102ne_
neap66927012neap
neb57238622neb
nee36657782nee
neep65728312neep
neg47237342neg
net36670292net
new66237092new
nip56945982nip
oe28473062oe_
oes35866192oes
op45850162_op
ope56845242ope
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
pap76758402pap
pe47649032pe_
pea56657242pea
pec76744412pec
ped66751522ped
pee56066512pee
peep85833692peep
peg65843062peg
peh86740962peh
pen56558842pen
pepo87622152pepo
peps85134512peps
per56353092per
perp89029892perp
pes57259782pes
pet56477302pet
pew86442302pew
pip78051042pip
pop76252252pop
prep86427672prep
pup76339882pup
pye86432502pye_
pyes95528992pyes
rap56261962rap
re26153742re_
reap65934742reap
reb55844962reb
rec55645462rec
red46755802red
ree37974072ree
ref66053292ref
reg46146492reg
rei35647252rei
rem56150042rem
repo66027542repo
repp85418742repp
reps65937952reps
res35565042res
ret35982832ret
rev65336622rev
rex105740992rex
rip56851302rip
rye66032542rye_
ryes75529352ryes
sap56463232sap
sea36161292sea
sec55945322sec
see35772262see
seep66540342seep
seg45544882seg
sei36048932sei
sel38253322sel
sen36058522sen
sept65844362sept
ser36752402ser
set36681252set
sew66247262sew
sex107043222sex
sip57656012sip
skep105219352skep
sop57557862sop
step67126292step
sup57041942sup
tap57663872tap
tea37353322tea
ted46446562ted
tee38366872tee
teg45741622teg
tel35647902tel
temp85323332temp
ten35856112ten
tepa66021682tepa
tet39274982tet
tew66640152tew
tip56551222tip
top510560682top
tup56037542tup
tye65837442tye_
tyee75131422tyee
tyer75323392tyer
tyes76433372tyes
type96223742type
typp115812782typp
ump76130442ump
up47832822_up
urp56426392urp
vee65750182vee
veep95325092veep
veg76931062veg
vet65958522vet
vex136429172vex
wap86553372wap
we57043452we_
web85735562web
wed75843622wed
wee66760812wee
weep95131652weep
wen66249602wen
wept95635052wept
wet65966622wet
wop87145132wop
wye96331972wye_
wyes105727502wyes
ya510251502y_a
yag76947732yag
yah99046352yah
yak107038562yak
yam87448992yam
yaps95933522yaps
yar67253832yar
yaup96618482yaup
yaw97145152yaw
yawp125215582yawp
yay96948712yay
yeah106725412yeah
yean75834582yean
year76534252year
yeas78638422yeas
yech127220532yech
yegg96511792yegg
yeld811423872yeld
yelk115320002yelk
yell76028322yell
yelps105712992yelps
yens75832262yens
yerk116222082yerk
yeti75823212yeti
yett76434492yett
yeuk116015472yeuk
yews105323962yews
yid76640822yid
yin67648732yin
yipe96722172yipe
yips95226692yips
ylem9217892ylem
yo59748552y_o
yob87945272yob
yod77545502yod
yok107335242yok
yom88043442yom
yon67348952yon
you66641822you
yow96945292yow
yuk106725602yuk
yum86132822yum
yups96121602yups
zap145840692zap
zed135431172zed
zee126143232zee
zek167323162zek
zeps156019342zeps
zip146636222zip

Search took 1 second 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 Filter178691140840.0632836365.1
2DLD Change Limit140843470.40634689.7
3Display Results3473470.0635507.9
 (SQL Overall)1786913470.532335885.3
 
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.