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

150 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
sweer8491857(None) 
seer45547041s_eer
sewer84426221sewer
sheer84726891sheer
sneer54919951sneer
speer74623901speer
steer55423861steer
swear85316851swear
sweep104715721sweep
sweet85330521sweet
weer75535091_weer
ameer75618982ameer
awee76336642awee_
beer65635992_beer
cheer105420382cheer
deer56739022_deer
dweeb1137742dweeb
emeer74815362emeer
ewer77523982ew_er
fewer115216122fewer
fleer86020772fleer
freer86021242freer
hewer115719932hewer
jeer115426462_jeer
leer46239352_leer
newer85717462newer
owner84613312owner
peer66238352_peer
queer143712812queer
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
saver84831252saver
sawer85026212sawer
sawyer12438042sawyer
sayer84926552sayer
sear47353842s_ear
seder64826762seder
see35772262s_ee_
seed55549482s_eed
seeder74320772seeder
seek85935482s_eek
seeker103615362seeker
seel45042982s_eel
seem65438562s_eem
seemer84418042seemer
seen46943122s_een
seep66540342s_eep
seers55136382s_eers
sees45361052s_ees
ser36752402s__er
sere46153472s_ere
serer55935512serer
sever85426052sever
sewar85421102sewar
sewed95325162sewed
sewers94719722sewers
shear85424832shear
sheen85023312sheen
sheep105321522sheep
sheers94322402sheers
sheet84836962sheet
shewer124515112shewer
shier85428942shier
shoer84722162shoer
shyer114714782shyer
sieur5911892sieur
siker95326032siker
siver85728612siver
sizer145521812sizer
skee85431472skee_
skeed105018982skeed
skeen94817402skeen
skees95023122skees
skeet95429182skeet
skewer13519612skewer
skier95119602skier
sleek94619042sleek
sleep74920182sleep
sleet55639132sleet
slier54827242slier
slyer85515122slyer
smear74416392smear
smeek114912352smeek
sneers64016172sneers
sneery93610412sneery
sober74822412sober
soever94412092soever
sorer56236592sorer
sower85229312sower
spear75821062spear
speed85526622speed
speel74420762speel
speers85019952speers
speir75315362speir
spewer115112152spewer
spier75728032spier
steed66024942steed
steek95418002steek
steel55721992steel
steep76020702steep
steers63820982steers
stere55328542stere
suber74924502suber
suer45334032s_uer
super74924482super
surer54833102surer
swager104013612swager
sware85828212sware
swayer125210972swayer
swearer10349952swearer
swears94114072swears
sweat85628402sweat
sweater103712722sweater
swede94413202swede
swedes102711892swedes
sweeny12358842sweeny
sweeper12329372sweeper
sweeps114110512sweeps
sweepy14447452sweepy
sweeter103212002sweeter
sweets94214432sweets
swell84815982swell
sweller103012472sweller
swelter103711172swelter
swept105720602swept
swerver1365732swerver
sweven1235982sweven
swore84920822swore
twee76827082twee_
tweed94915092tweed
tween84413742tween
tweet84823982tweet
twier84713292twier
twyer11558522twyer
veer76229572_veer
wear75836722_wear
weber10313522_weber
wee66760812_wee_
weed85637512_weed
week116428152_week
weel75834082_weel
ween75835462_ween
weep95131652_weep
wees76249122_wees
weet75254152_weet
weir76019922_weir
were76238332_were

Search took 3 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.343520965.0
2DLD Change Limit538001501.64032804.9
3Display Results1501500.0463260.9
 (SQL Overall)1786911502.02988068.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.