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

217 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
panderer11221091(None) 
pandered121812571pandered
panderers12229151panderers
ponderer112410191ponderer
wanderer122210121wanderer
banterer102811772banterer
dandered112110962dandered
gandered112211172gandered
hankerer15248232hankerer
hinderer1238272hinderer
launderer1094512launderer
maunderer1294192maunderer
meanderer1244732meanderer
palterer102411272palterer
pamperer14228332pamperer
pander93725522pand__er
panders103423732pander_s
pandore10411852pandore_
pandores11312452pandores
paperer113111902pa_perer
patterer103112172patterer
plunderer1243752plunderer
pondered126411292pondered
ponderers12248452ponderers
powderer14245592powderer
renderer9239742renderer
slanderer1046672slanderer
sunderer9310522sunderer
tenderer9228732tenderer
wandered132110792wandered
wanderers13228482wanderers
wonderer12249182wonderer
adherer1137573_adherer
adorer74713453_a_dorer
alterer72713993_alterer
angered93013473_angered
answerer1144263_answerer
bandager1237703bandager
bander93928223band__er
banderol1145853banderol
banders104324563bander_s
bandore10611633bandore_
bandores11311603bandores
bannered11299323bannered
banneret102412473banneret
bantered113313633bantered
banterers112410003banterers
barterer102711633barterer
batterer102713213batterer
blunderer1244543blunderer
borderer1168103borderer
calenderer1342983calenderer
canceler12238913canceler
cancered132411553cancered
candider1237343candider
candler103516593cand_ler
cankered153010223cankered
cantered113415983cantered
caperer113013403ca_perer
careerer1038583careerer
caterer92815943ca_terer
cindered1239793cindered
dander811222993dand__er
danders93921183dander_s
dandier93714573dand_ier
dandler94414273dand_ler
dangered11248513dangered
dapperer1335763dapperer
daundered1294423daundered
dodderer1144203dodderer
eagerer8248823ea_gerer
endurer83210363_endurer
enterer72015633_enterer
falterer11239853falterer
fendered13258673fendered
fingerer12127223fingerer
gander84322763gand__er
ganders93521703gander_s
gardener1037103gardener
gatherer12147903gatherer
gendered11258873gendered
glandered1236333glandered
hammerer15278143hammerer
hamperer15379093hamperer
hander104526433hand__er
handers114224333hander_s
handier113817443hand_ier
handler113516163hand_ler
handover15126823handover
hankered16289443hankered
hankerers16226713hankerers
hardener1238883hardener
hindered1339453hindered
hinderers1337353hinderers
indexer15287253_indexer
jabberer1944023jabberer
laddered1136743laddered
lander74028483land__er
landers84026213lander_s
landler84113203land_ler
lanneret82512363lanneret
latherer111310443latherer
laundered1185023laundered
launderers1183873launderers
lingerer9118303lingerer
mandrel1038683mand_rel
mannered11249653mannered
manurer938583man_urer
maundered1394943maundered
maunderers1383753maunderers
meandered1346143meandered
meanderers1343803meanderers
murderer1145263murderer
orderer8127943_orderer
padder103415493pa_d_der
padders113312873padder_s
paddler113711553pa_ddler
padre86018163pa_d_re_
padres95016983pa_d_res
palaverer1443163palaverer
paltered113012483paltered
palterers11249533palterers
pampered15229223pampered
pamperers15236863pamperers
pandect12310953pande_ct
pandects1335843pandects
pandemic1545543pandemic
pandering133211963pandering
pandied113913443pand_ied
pandies104224503pand_ies
pandoor10358583pand_oor
pandora1039543pandor_a
pandoras11310053pandoras
pandour10408213pand_our
pandura1037143pandur_a
panduras1136953panduras
paneled10612573pan_eled
pangene102711963pangene_
pangenes112612823pangenes
panier84425503pan__ier
paniers94717333panier_s
panner84224763pan__ner
panners93621273panner_s
pannier93613353pan_nier
panniered1243853panniered
panther12611443pan_ther
panzer174213233pan__zer
panzers184012013panzer_s
papered122513163pa_pered
paperers122410453pa_perers
parcener1238473parcener
pardee93922023parde_e_
pardner10239473pard_ner
pardoner11189443pardoner
parer75839903pa___rer
parleyer1335623parleyer
parterre1036983parterre
pasturer1037523pasturer
pattered112714203pattered
patterers112410123patterers
paupered13216933paupered
pepperer1145273pepperer
pesterer102412703pesterer
pewterer13256313pewterer
philanderer1752093philanderer
pilferer1344923pilferer
pinder94523453pind__er
pinders103720473pinder_s
plasterer1178103plasterer
plundered1344313plundered
plunderers1343333plunderers
ponder94521693pond__er
ponders103618843ponder_s
potterer102310263potterer
powdered15256893powdered
powderers15214793powderers
properer1259203properer
puckerer1645793puckerer
putterer10209913putterer
randier83618473rand_ier
rendered102512263rendered
renderers10208093renderers
sander74828533sand__er
sanders84025943sander_s
sandier84017843sand_ier
saunterer945033saunterer
sincerer1037203sincerer
slandered1137473slandered
slanderers1145143slanderers
slenderer1044893slenderer
sneerer73512313_sneerer
solderer947183solderer
spandexes1943453spandexes
spandrel1144063spand_rel
squanderer2052153squanderer
sundered10312153sundered
sunderers1039073sunderers
tamperer12248893tamperer
taperer92511793ta_perer
tendered102510603tendered
tenderers10227803tenderers
thunderer1344253thunderer
tinkerer1286803tinkerer
veneerer1145033veneerer
verderer1245373verderer
wagerer11328493wa_gerer
wander104423713wand__er
wanderoo1245663wanderoo
wanders114221333wander_s
waterer103314073wa_terer
waverer13319523wa_verer
winterer112110443winterer
wondered13239943wondered
wonderers13217933wonderers
yammerer15225483yammerer
zander163417113zand__er
zanders173015793zander_s

Search took 9 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.1731032896.0
2DLD Change Limit1461622178.17017890.1
3Display Results2172170.0962260.4
 (SQL Overall)1786912178.43921174.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.