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

103 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
powderer1424559(None) 
ponderer112410191ponderer
powdered15256891powdered
powderers15214791powderers
borderer1168102borderer
dodderer1144202dodderer
orderer8127942_orderer
panderer112210912panderer
pewterer13256312pewterer
pondered126411292pondered
ponderers12248452ponderers
potterer102310262potterer
powder123611902powd__er
powders134111552powder_s
powdery16396122powder_y
powered132911642pow_ered
solderer947182solderer
wonderer12249182wonderer
bordered1248933bordered
borderers1276333borderers
boulderer1244403boulderer
bowered133113043bow_ered
broiderer1244353broiderer
chowdered1944013chowdered
coherer122912783co_herer
coverer123113523co_verer
cowered133214653cow_ered
doddered1234943doddered
dodderers1243803dodderers
dowdier12328573dowd_ier
dowered122811553dow_ered
flowerer1435453flow_erer
foddered1434553foddered
fosterer11239523fosterer
goldener1045403goldener
hinderer1238273hinderer
hoverer13319823ho_verer
however1634513how_ever
loiterer837083loiterer
lowered112711913low_ered
modeler1039293mo_deler
moderner1145523mo_derner
moldered1237173moldered
murderer1145263murderer
nowhere1337213nowhere_
nowheres1437513nowheres
offerer1335543_offerer
ordered9108533_ordered
orderers9116563_orderers
palterer102411273palterer
pamperer14228333pamperer
pandered121812573pandered
panderers12229153panderers
paperer113111903p_aperer
patterer103112173patterer
pepperer1145283pepperer
pesterer102412703pesterer
pewterers14216043pewterers
pilferer1344923pilferer
plunderer1243753plunderer
pocketer16157373pocketer
podgier11338723po_dgier
polder94019253pold__er
polders103617373polder_s
ponder94521693pond__er
ponders103618843ponder_s
poorer82613993po__orer
portered112311543portered
posturer1038923posturer
pothered142311043pothered
pottered112311663pottered
potterers11218663potterers
poulterer1145423poulterer
pourer84516043po__urer
powdering16246503powdering
powderless1642593powderless
power105325953pow___er
powers113822323pow_er_s
powter114116033pow__ter
powters124015663powter_s
profferer1742933profferer
properer1259203properer
puckerer1645793puckerer
putterer10209913putterer
renderer9239743renderer
rowdier11348593rowd_ier
scowdered1643743scowdered
showerer1436163show_erer
soberer93110353so_berer
soldered1038153soldered
solderers1066533solderers
sorcerer1036433sorcerer
sunderer9310523sunderer
tenderer9228733tenderer
totterer8217793totterer
towered112911403tow_ered
towerier1137123tow_erier
verderer1245373verderer
wanderer122210123wanderer
wondered13239943wondered
wonderers13217933wonderers
woodener1245763woodener
yodeler1136343yo_deler

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.406440125.6
2DLD Change Limit1461621037.09320606.5
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.54523683.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.