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 “showerer” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
showerer143616(None) 
showered1537011showered
showerers1545071showerers
flowerer1435452flowerer
hoverer13319822_hoverer
however1634512_however
sheerer103813842sh_eerer
shiverer14186662shiverer
shoveler14165582shoveler
shower124315112show__er
showers134612682shower_s
showery16437242shower_y
showier1339102show_ier
soberer93110352s_oberer
answerer1144273answerer
bowered133113043_bowered
cheerer123511753ch_eerer
chowder16387813chow_der
chowdered1944013chowdered
coherer122912783_coherer
coverer123113523_coverer
cowered133214653_cowered
dowered122811553_dowered
flowered1546013flowered
flowerers1544503flowerers
floweret1448083floweret
flowerier1544273flowerier
glowered1345753glowered
homered133212713_homered
honorer1039673_honorer
hovered143411573_hovered
hoverers14289023_hoverers
howler123514313_how_ler
lowered112711913_lowered
powderer14245593_powderer
powered132911643_powered
properer1259203properer
reshowered1752913reshowered
scorer84818263sco__rer
scourer93910433sco_urer
scowder13286873scow_der
scowdered1643743scowdered
scowler12248193scow_ler
serer55935513s___erer
severer103511563s_everer
sewered112911243s_ewered
sharer95025483sh__arer
shatterer12177203shatterer
shearer104414683sh_earer
sheer84726893sh__e_er
sheered113515453sh_eered
sheeter103814913sh_eeter
shelterer1245033shelterer
shewer124515113sh__ewer
shewers134312053shewer_s
shivered15177103shivered
shiverers15155773shiverers
shnorrer1143523shnorrer
shoaler102610083sho_aler
shoalier1137073shoalier
shocker163411433sho_cker
shoddier1334213shoddier
shoer84722163sho___er
shoers94518333sho_er_s
shoetree1146573shoetree
shooter103013993sho_oter
shopper143312633sho_pper
shore85432653sho__re_
shored105723653sho__red
shores94830413sho__res
shortener1245773shortener
shorter103515503sho_rter
shoulder1234753shoulder
shouter103213083sho_uter
shoveled15195353shoveled
shovelers15174943shovelers
shoveller15174543shoveller
shover124515993sho__ver
shovers134613003shover_s
showbread1842303showbread
showed135016973show__ed
showerhead2051953showerhead
showering1646403showering
showerless1642543showerless
showmen15227173show_men
shrewder1534403shrewder
shrieker15265653shrieker
silverer11216733silverer
simperer1237173simperer
sincerer1037203sincerer
skewered1634213skewered
slaverer11196993slaverer
sliverer11237633sliverer
slobberer13153443slobberer
slower94016153slow__er
smotherer1444633smotherer
sneerer73512313s_neerer
snorer64316763sno__rer
snowier1038793snow_ier
soarer64522243s_o_arer
sobered102912433s_obered
soever94412093s_o_ever
solderer947183solderer
soleret7321233s_oleret
sorcerer1036433sorcerer
sorer56236593s_o__rer
sourer63620213s_o_urer
sower85229313s_ow__er
sowers94923443s_ower_s
steerer73113633s_teerer
storer64721673sto__rer
sufferer1436063sufferer
sunderer9310523sunderer
swearer10349953s__wearer
sweer84918573s__we_er
swerver1365733s__werver
towered112911403_towered
towerier1137123_towerier
troweler11106063troweler
whoever1634103who_ever
whomever1942963whomever
whosever1742893whosever

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621227.51619446.8
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.98522378.3
 
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.