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

228 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
jean11662928(None) 
bean66443861bean
dean56039481dean
jeans126022111jeans
jeon116821441jeon
lean46345241lean
mean65538081mean
pean66147171pean
wean75734351wean
yean75834581yean
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
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
jab128444112j_ab
jag116542712j_ag
jam126942522j_am
jane115031472j_ane
japan14411232japan
jar107646152j_ar
jaw136237682j_aw
jawan15710382jawan
jay136242672j_ay
jeaned143813462jeaned
jee106648642je_e
jeed125428502jeed
jeep135624842jeep
jeer115426462jeer
jees115938542jees
jeez205622032jeez
jefe146516882jefe
jehad1637682jehad
jehu145614862jehu
jell117125872jell
jenny153811622jenny
jerk154920132jerk
jess116022032jess
jest116738502jest
jet106754822je_t
jete115927252jete
jeton124815402jeton
jets115834102jets
jeu105532072je_u
jeux184311272jeux
jew135129082je_w
jews145822082jews
jiao115017842jiao
jin106443932j_in
jinn115420242jinn
jnana12159042jnana
john145512902john
join116724832join
jun105932062j_un
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
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
yea66445752yea_
yeah106725412yeah
yeans86624882yeans
year76534252year
yearn86316432yearn
yeas78638422yeas
yen66847382ye_n
yuan76120012yuan
zeal135530332zeal
zein135620602zein

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 Filter178691298720.0632836365.1
2DLD Change Limit298722280.79637527.6
3Display Results2282280.0633619.0
 (SQL Overall)1786912280.922193808.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.