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

179 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
sewer8442622(None) 
ewer77523981_ewer
fewer115216121fewer
hewer115719931hewer
newer85717461newer
sawer85026211sawer
seder64826761seder
seer45547041se_er
serer55935511serer
sever85426051sever
sewar85421101sewar
sewed95325161sewed
sewers94719721sewers
shewer124515111shewer
skewer13519611skewer
sower85229311sower
spewer115112151spewer
sweer84918571sweer
beer65635992be_er
bower107328182bower
brewer114812552brewer
ceder85322242ceder
chewer145512622chewer
cower104531772cower
deer56739022de_er
defer94619752defer
deter65028042deter
dewar95817732dewar
dewed105020302dewed
dewier104013462dewier
dower95027702dower
eger55923572_eger
esker94412982esker
ester54727712ester
ever77027692_ever
ewe66630982_ewe_
ewers86018822_ewers
ewes76328702_ewes
eyer76127282_eyer
fever115617952fever
feyer115014522feyer
heder95623642heder
hewed125619432hewed
hewers123715272hewers
hexer155116682hexer
jeer115426462je_er
jewed165114832jewed
jewel156711702jewel
leer46239352le_er
leger65721512leger
leper74820742leper
lever85125162lever
lewder10479612lewder
lower85830412lower
merer75126232merer
meter75130322meter
mewed115218012mewed
mewler113510232mewler
mower104523452mower
never86218642never
newel86114132newel
pawer104422972pawer
peer66238352pe_er
peter74427592peter
pewee10319972pewee
pewter114013672pewter
power105325952power
rawer84623732rawer
refer84822142refer
rewear93012002rewear
rewed95425452rewed
rewet85135152rewet
rower85430492rower
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
saver84831252saver
sawed95628402sawed
sawers94620162sawers
sawyer12438042sawyer
sayer84926552sayer
screwer124410072screwer
sealer63928962sealer
seamer84223612seamer
sear47353842se_ar
searer65432022searer
seater64534162seater
secern81010222secern
seders74420282seders
see35772262se_e_
seed55549482se_ed
seeder74320772seeder
seek85935482se_ek
seeker103615362seeker
seel45042982se_el
seem65438562se_em
seemer84418042seemer
seen46943122se_en
seep66540342se_ep
seers55136382se_ers
sees45361052se_es
seiner64622482seiner
seiser65318342seiser
seizer154114572seizer
seller63824602seller
seme65836652seme_
semen75724102semen
semes75731582semes
sender73824412sender
sene46848052sene_
senor53822802senor
ser36752402s__er
sere46153472sere_
sered65737292sered
seres55448892seres
serger73819742serger
server94917712server
setter64023722setter
seven84118312seven
severe94016082severe
severs94121122severs
sew66247262sew__
sewan85921292sewan
sewars94018632sewars
sewered112911242sewered
sewn76124332sew_n
sews75836022sew_s
sexed136618542sexed
sexes126126222sexes
sexier13310682sexier
sheer84726892sheer
shewed134716182shewed
shewers134312052shewers
shier85428942shier
shoer84722162shoer
shower124315112shower
shyer114714782shyer
siker95326032siker
siver85728612siver
sizer145521812sizer
skewed145610232skewed
skewers14498382skewers
skier95119592skier
slewed104815522slewed
slier54827242slier
slower94016152slower
slyer85515122slyer
sneer54919952sneer
sober74822412sober
soever94412092soever
sorer56236592sorer
sowar85821342sowar
sowed94933862sowed
sowers94923442sowers
speer74623902speer
spewed125512332spewed
spewers124210662spewers
spier75728032spier
steer55423862steer
stewed104814242stewed
strewer104310412strewer
suber74924502suber
suer45334032s_uer
super74924482super
surer54833102surer
swear85316852swear
sweep104715722sweep
sweet85330522sweet
tawer85223442tawer
tewed94718532tewed
tower85729202tower
veer76229572ve_er
vexer155513522vexer
viewer1237212viewer
vower115220792vower
weber10313522weber
weer75535092we_er

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.310576422.6
2DLD Change Limit538001791.72031279.1
3Display Results1791790.0463891.3
 (SQL Overall)1786911792.07686074.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.