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

236 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
yean7583458(None) 
bean66443861bean
dean56039481dean
jean116629281jean
lean46345241lean
mean65538081mean
pean66147171pean
wean75734351wean
yea66445751yea_
yeah106725411yeah
yeans86624881yeans
year76534251year
yearn86316431yearn
yeas78638421yeas
yen66847381ye_n
yuan76120011yuan
aeon45634612aeon
alan46844082alan
an211879072__an
azan136521782azan
ban58366832_ban
bead75937922bead
beak106534382beak
beam86939232beam
beano75421552beano
beans75734692beans
bear66844642bear
beat66168302beat
beau66137272beau
been65335782been
began86319572began
ben56554922be_n
bran65740382bran
can57760132_can
clan65633922clan
clean75420412clean
cyan96419622cyan
dan46859662_dan
dead65434242dead
deaf85838402deaf
deal56347412deal
deans66131392deans
dear55343602dear
den47554342de_n
dewan95718042dewan
ear36867882_ear
earn46737552_earn
eat36989052_eat
eau37450942_eau
elan46734242elan
en28052392_e_n
eon36052082_eon
ern35738352_ern
eyas76427432eyas
eyen76223662eyen
fan67158852_fan
feal713940422feal
fear75337792fear
feat76458222feat
fen66851352fe_n
fern76129322fern
flan76134182flan
gaen57329602gaen
gan48060122_gan
gear55934972gear
gen45950512ge_n
glean65818202glean
gran56335012gran
guan55325582guan
haen76229452haen
head87137172head
heal75645692heal
heap96432892heap
hear76143882hear
heat77061422heat
hen67555272he_n
hern76134892hern
hewn106719852hewn
hwan105716892hwan
hyena11810252hyena
jeans126022112jeans
jeon116821442jeon
kea76540912kea_
keas86337092keas
keen84830402keen
ken76343982ke_n
kern85326212kern
khan115819142khan
koan85425032koan
lea37660182lea_
lead56038852lead
leaf76441032leaf
leak86233712leak
leal46043272leal
leans55536252leans
leant56737782leant
leap66032682leap
lear47045952lear
learn55322662learn
leas45954182leas
leman75622602leman
loan47436452loan
man57465852_man
mead75531602mead
meal65643172meal
means75831222means
meant76537202meant
meany104620472meany
meat66359602meat
men59252842me_n
moan65832012moan
naan47621932naan
nan37854872_nan
neap66927012neap
near45236502near
neat46356782neat
neon47026422neon
ocean71212962ocean
paean77222722paean
pan58466442_pan
pea56657242pea_
peag75431342peag
peak106535202peak
peal68648102peal
peans75437642peans
pear69745232pear
peas65755062peas
peat65967932peat
pecan91919032pecan
peen65938082peen
pein65834942pein
pekan111613972pekan
pen56558842pe_n
peon65635242peon
pian66136092pian
plan65833942plan
pyran10514472pyran
quean143612842quean
ran38266612_ran
read55942532read
real45750292real
ream65841612ream
reap65934742reap
rear45644552rear
redan66125012redan
rein46040892rein
reman75730152reman
reran57329102reran
rewan85623662rewan
roan47234202roan
scan65530452scan
sea36161292sea_
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seat47575562seat
sedan65620422sedan
seen46943122seen
sen36058522se_n
sewan85921292sewan
sewn76124332sewn
skean94415622skean
span65234662span
spean74620512spean
swan76631312swan
tan37167562_tan
tea37353322tea_
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teat45963632teat
teen45938202teen
ten35856112te_n
tern46134802tern
than76128772than
ulan46527392ulan
van66246322_van
veal76936812veal
vegan95114152vegan
vein75625752vein
vena76126292vena
wan66761932_wan
weak117126302weak
weal75838682weal
weans85326742weans
wear75836722wear
ween75835462ween
wen66249602we_n
xylan1537462xylan
ya510251502y_a_
yag76947732y_ag
yah99046352y_ah
yak107038562y_ak
yam87448992y_am
yang85626062y_ang
yank115423662y_ank
yap85949822y_ap
yar67253832y_ar
yarn75230042yarn
yaw97145152y_aw
yawn106219092yawn
yay96948712y_ay
ye57650062ye__
yeahs115214552yeahs
yeaned103813902yeaned
yearns9509542yearns
years84527672years
yeast85327942yeast
yech127220532yech
yegg96511792yegg
yeh97135772ye_h
yeld811423872yeld
yelk115320002yelk
yell76028322yell
yelp95621352yelp
yens75832262yens
yeoman1138822yeoman
yep86638962ye_p
yeps95924402yeps
yerk116222082yerk
yes66250612ye_s
yet66960692ye_t
yeti75823212yeti
yett76434492yett
yeuk116015472yeuk
yew96436292ye_w
yews105323962yews
yin67648732y_in
yon67348952y_on
yuans84613322yuans
yulan8411492yulan
zeal135530332zeal
zein135620602zein

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.0802233637.5
2DLD Change Limit298722360.93631914.5
3Display Results2362360.0633746.0
 (SQL Overall)1786912361.079165608.0
 
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.