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

183 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
panders10342373(None) 
banders104324561banders
danders93921181danders
ganders93521701ganders
handers114224331handers
landers84026211landers
padders113312871padders
pander93725521pander_
paniers94717331paniers
panners93621271panners
panzers184012011panzers
pinders103720471pinders
ponders103618841ponders
sanders84025941sanders
wanders114221331wanders
zanders173015791zanders
adders84315702_adders
aiders74524632_aiders
alders74218422_alders
angers75222542_angers
bander93928222bander_
bangers104020352bangers
bankers133919092bankers
banners94018712banners
banters94623112banters
benders104021062benders
binders103920742binders
bonders104120662bonders
branders114313092branders
cancers114018582cancers
candlers114214102candlers
candors104216762candors
caners84629202can_ers
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
carders104820352carders
cinders104617762cinders
dancers103413092dancers
dander811222992dander_
dandlers103912052dandlers
dangers94818212dangers
daunders10278472daunders
enders74324052_enders
expanders19125092expanders
faders105117462fa_ders
fanners103914652fanners
fenders113717262fenders
finders113717872finders
funders113813932funders
gadders103611502gadders
gander84322762gander_
gangers94418602gangers
genders93616782genders
glanders103811502glanders
hander104526432hander_
handlers124014142handlers
hangers113120812hangers
hankers144218132hankers
hinders113718502hinders
ladders94115172ladders
laders74927762la_ders
lancers93616642lancers
lander74028482lander_
landlers94312832landlers
lanners73618332lanners
larders83516942larders
lauders84012892lauders
launders9358742launders
lenders84419642lenders
madders113513212madders
mangers103521262mangers
manners93417832manners
maunders11348342maunders
meanders1168832meanders
menders103818802menders
minders103720122minders
pacers105124542pa_cers
packers153818892packers
padder103415492padder_
paddlers12329152paddlers
padres95016982pa_dres
pagers94423252pa_gers
painters103013022painters
palmers113513622palmers
palters94021682palters
pampers133615932pampers
pandas95521962pand_as
pandect12310952pandect
pandects1335842pandects
pandered121812572pandered
panderer112210912panderer
panderers12229152panderers
pandies104224502pandies
pandits103914212pandits
pandoors11258982pandoors
pandora1039542pandora
pandoras11310052pandoras
pandore10411852pandore
pandores11312452pandores
pandours11317992pandours
pandura1037142pandura
panduras1136952panduras
panels84716522pan_els
panes76148692pan_e_s
pangens103112062pangens
panier84425502panier_
panner84224762panner_
pannes85522852panne_s
panniers10488852panniers
panthers13510782panthers
panzer174213232panzer_
papers105125322pa_pers
paraders113113112paraders
pardners11269192pardners
parers85530742pa_rers
parkers133816872parkers
parsers94118152parsers
passers94717752passers
pasters94531732pasters
paters84935832pa_ters
patters94825192patters
patzers184210572patzers
paupers114311072paupers
pausers94113222pausers
pavers115021822pa_vers
pawers114818782pa_wers
pawners124311072pawners
payers114621822pa_yers
penners93414182penners
pincers113916502pincers
pinder94523452pinder_
pingers104020742pingers
pinkers134118602pinkers
pinners93518602pinners
planers94517942plan_ers
planners10399932planners
planters102915322planters
plunders11329832plunders
polders103617372polders
pomanders1436222pomanders
ponder94521692ponder_
pounders113113282pounders
powders134111552powders
prancers123210332prancers
punkers133714852punkers
punners94114232punners
punters93617042punters
raiders84615142raiders
rangers83621042rangers
rankers113217462rankers
ranters73323642ranters
renders83821672renders
sander74828532sander_
sangers84421942sangers
senders83022352senders
slanders94014012slanders
sonders83820712sonders
spaders104214472spa_ders
spankers14369862spankers
spanners103710772spanners
spenders113211742spenders
standers93514302standers
sunders84120052sunders
tandems1037632tandems
tankers113416912tankers
tanners74018392tanners
tenders83719722tenders
tinders84219172tinders
uplanders1234852uplanders
vanners103612842vanners
venders113717002venders
wadders123812442wadders
waders109120642wa_ders
wander104423712wander_
wankers144514712wankers
wanters104420092wanters
warders113416812warders
winders113721262winders
wonders113315992wonders
yarders113211592yarders
zander163417112zander_

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 Filter1786911076710.376475242.0
2DLD Change Limit1076711833.36032044.9
3Display Results1831830.0762407.9
 (SQL Overall)1786911833.81246875.9
 
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.