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

140 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
sewers9471972(None) 
ewers86018821_ewers
hewers123715271hewers
sawers94620161sawers
seders74420281seders
seers55136381se_ers
severs94121121severs
sewars94018631sewars
sewer84426221sewer_
shewers134312051shewers
skewers14498381skewers
sowers94923441sowers
spewers124210661spewers
beers75628392be_ers
bowers115523702bowers
brewers123811062brewers
ceders93817672ceders
chewers154111142chewers
cowers114625532cowers
deers64930522de_ers
defers105116942defers
deters74724682deters
dewars105117072dewars
dowers104523292dowers
egers65120372_egers
eskers105312222eskers
esters64627732esters
ewer77523982_ewer_
ewes76328702_ewe_s
eyers86521332_eyers
fevers125414892fevers
fewer115216122fewer_
heders104119762heders
hewer115719932hewer_
hexers165612752hexers
jeers124818132je_ers
jewels16508612jewels
leers54828982le_ers
legers74518312legers
lepers84817322lepers
levers94621322levers
lowers94624922lowers
meters85625832meters
mewlers12288982mewlers
mowers113219402mowers
newels93710822newels
newer85717462newer_
pawers114818782pawers
peers75130272pe_ers
peters86624592peters
pewees11311392pewees
pewters124113352pewters
powers113822322powers
refers93921082refers
revers94529632revers
rewears102911042rewears
reweds104412302reweds
rewets94617212rewets
rowers94924572rowers
sabers85224732sabers
sakers104125432sakers
savers93825922savers
sawer85026212sawer_
sawyers13317532sawyers
sayers94221592sayers
screwers13358062screwers
sealers74323552sealers
seamers94719432seamers
sears54744912se_ars
seaters74028942seaters
secern81010222secern
secerns987732secerns
seder64826762seder_
seeders83017112seeders
seeds64330062se_eds
seekers113712332seekers
seeks94724642se_eks
seels55632822se_els
seemers93814332seemers
seems75525022se_ems
seeps74828752se_eps
seer45547042se_er_
sees45361052se_e_s
seiners74219272seiners
seisers73816392seisers
seizers164112502seizers
sellers73721322sellers
semens84616972semens
semes75731582seme_s
senders83022352senders
senors63620792senors
serer55935512serer_
seres55448892sere_s
sergers83815632sergers
sers45746652s__ers
servers103214832servers
setters73822062setters
sevens93813662sevens
sever85426052sever_
severe94016082severe
sewans95215902sewans
sewar85421102sewar_
sewed95325162sewe_d
sewered112911242sewered
sews75836022sew__s
sexes126126222sexe_s
sheers94322402sheers
shewer124515112shewer_
shiers94921752shiers
shoers94518332shoers
showers134612682showers
shyers124712202shyers
sivers95324152sivers
sizers155215812sizers
skewer13519612skewer_
skiers104713702skiers
sneers64016172sneers
sobers85218862sobers
sowars94318012sowars
sowens93613152sowens
sower85229312sower_
speers85019952speers
spewer115112152spewer_
spiers84421742spiers
steers63820982steers
strewers11409062strewers
subers85722642subers
suers55128482s_uers
supers84622402supers
swears94114072swears
sweeps114110512sweeps
sweer84918572sweer_
sweets94214432sweets
tawers94118602tawers
towers94423672towers
veers84521362ve_ers
vexers165210402vexers
viewers1337172viewers
vowers124317182vowers
webers11310942webers

Search took 4 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 Filter178691825510.346516448.0
2DLD Change Limit825511402.71630394.3
3Display Results1401400.0334242.4
 (SQL Overall)1786911403.09557735.4
 
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.