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

183 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
shews11592471(None) 
chews135418511chews
hews105631571_hews
sews75836021s_ews
shaws116226261shaws
sheas86331791sheas
sheds96122701sheds
shes75734351she_s
shew108030761shew_
shewn115715701shewn
shows115324571shows
shrews129313911shrews
skews125413801skews
slews86220351slews
smews104612291smews
spews105015921spews
stews85519141stews
thews117416191thews
whews145114491whews
ashes86230612ashe_s
brews105617072brews
cashews15428602cashews
chaws135022462chaws
chefs136214662chefs
chess105016922chess
chew126622132chew_
chewy165011902chewy
chows135618202chows
clews105516332clews
crews105917492crews
dews86230602_dews
dhows125911222dhows
eschews1534552eschews
flews115316442flews
ghees95215552ghees
haws106439442_haws
hehs106723962_hehs
hems95534942_hems
hens75642572_hens
hers75844872_hers
hes66654202_he_s
hets75547202_hets
hew97642722_hew_
hewn106719852_hewn
hows106345602_hows
jews145822082_jews
khets124913432khets
mews96629332_mews
news76127372_news
pews95731532_pews
phew128417112phew_
plews105415352plews
pshaws14435702pshaws
rheas84816952rheas
saws75839482s_aws
scows106617802scows
screws115513882screws
seas45755272s_eas
secs65033892s_ecs
seeds64330062seeds
seeks94724642seeks
seels55632822seels
seems75525022seems
seeps74828752seeps
seers55136382seers
sees45361052s_ees
segs54933882s_egs
seis45542392s_eis
sels46345982s_els
sers45746652s_ers
sets45549502s_ets
sew66247262s_ew_
sewn76124332s_ewn
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shaw108132552shaw_
shawl116217572shawl
shawls125411972shawls
shawm135316142shawm
shawms14579562shawms
shawn116417612shawn
shays116021432shays
she66837692she__
shea76031572she_a
sheaf115424122sheaf
sheafs124912882sheafs
sheal84927702sheal
sheals94420642sheals
shear85424832shear
shears93820902shears
shed86536152she_d
sheen85023312sheen
sheens95116992sheens
sheep105321522sheep
sheer84726892sheer
sheers94322402sheers
sheesh1237812sheesh
sheet84836952sheet
sheets93918492sheets
sheik122514652sheik
sheiks132510012sheiks
shelf115221112shelf
shell84424122shell
shells94319522shells
shend94719972shend
shends105313772shends
shent85933492shent
sheol84318362sheol
sheols94614152sheols
sherd96321152sherd
sherds105614722sherds
shewed134716182shewed
shewer124515102shewer
shewers134312042shewers
shiels95418922shiels
shiers94921752shiers
shies86136552shies
shims104422542shims
shins85131042shins
ships105123772ships
shits84731162shits
shivs115018802shivs
shleps114710332shleps
shoers94518322shoers
shoes85429652shoes
shogs95319702shogs
shoos84226352shoos
shops104222892shops
shots84730832shots
show106229182show_
shown115216472shown
showy145714002showy
shreds105613052shreds
shrew119720162shrew_
shrewd136810772shrewd
shris84221442shris
shuls85319712shuls
shuns85018142shuns
shuts85622472shuts
shwa106014962sh_wa
shwas116415102shwas
shyers124712202shyers
sinews94210622sinews
skees95023122skees
skegs105011232skegs
skeps115614252skeps
skew116218762skew_
slaws85222712slaws
sleds64418852sleds
slew76228232slew_
slows85323462slows
smew95017732smew_
snaws86116362snaws
sneds65715352sneds
snows84719882snows
sows75342492s_ows
specs96916672specs
spew95421872spew_
stems75219952stems
steps76619882steps
stets55423912stets
stew77525462stew_
stewy116112062stewy
stows86622702stows
strews96817092strews
suers55128482suers
sues46247652sue_s
suets55126102suets
tews76431642_tews
thaws116515462thaws
thens85921832thens
thew108226232thew_
thewy146311852thewy
trews86118892trews
ushers94415532ushers
views11489642views
whens114618762whens
whets115019612whets
whew137618782whew_
wheys145911552wheys
yews105323962_yews

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 Filter178691538000.0931921408.6
2DLD Change Limit538001831.62633087.3
3Display Results1831830.0463978.3
 (SQL Overall)1786911831.765101241.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.