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

157 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
panderers1222915(None) 
panderer112210911panderer_
ponderers12248451ponderers
wanderers13228481wanderers
banterers112410002banterers
hankerers16226712hankerers
hinderers1337352hinderers
launderers1183872launderers
maunderers1383752maunderers
meanderers1343802meanderers
palterers11249532palterers
pamperers15236862pamperers
pandered121812572pandere_d
panders103423732pand__ers
pandores11312452pandore_s
paperers122410452pa_perers
patterers112410122patterers
plunderers1343332plunderers
ponderer112410192ponderer_
powderers15214792powderers
renderers10208092renderers
slanderers1145142slanderers
sunderers1039072sunderers
tenderers10227802tenderers
wanderer122210122wanderer_
wonderers13217932wonderers
adherers1296923_adherers
adorers84411733_a_dorers
alterers82512493_alterers
answerers1243743_answerers
bandagers1335883bandagers
banderols1245953banderols
banders104324563band__ers
bandores11311603bandore_s
bannerets11205463bannerets
banterer102811773banterer_
barterers11269633barterers
batterers113110713batterers
blunderers1343943blunderers
borderers1276333borderers
calenderers1452213calenderers
cancelers13247863cancelers
candlers114214103cand_lers
caperers122611723ca_perers
careerers1137243careerers
caterers102814403ca_terers
dandered112110963dandere_d
danders93921183dand__ers
dandlers103912053dand_lers
dodderers1243803dodderers
endurers9317953_endurers
enterers82214153_enterers
falterers12238033falterers
fingerers13136303fingerers
gandered112211173gandere_d
ganders93521703gand__ers
gardeners1136603gardeners
gatherers13156883gatherers
hammerers16216563hammerers
hamperers16287533hamperers
handers114224333hand__ers
handlers124014143hand_lers
handovers16136183handovers
handpress1544033handpress
hankerer15248233hankerer_
hardeners1338083hardeners
hinderer1238273hinderer_
indexers16326373_indexers
jabberers2043553jabberers
landers84026213land__ers
landlers94312833land_lers
lannerets9225483lannerets
latherers12158853latherers
launderer1094513launderer_
lingerers10126923lingerers
mandrels1137313mand_rels
manurers1037593man_urers
maunderer1294193maunderer_
meanderer1244733meanderer_
murderers1244593murderers
orderers9116563_orderers
padders113312873pa_d_ders
paddlers12329153pa_ddlers
padres95016983pa_d_re_s
palaverers1542713palaverers
palterer102411283palterer_
pamperer14228333pamperer_
pancreas1235393pan_creas
pandects1335843pande_cts
pandemics1643933pandemics
pander93725523pand__er_
pandering133211963pandering
pandies104224503pand_ie_s
pandoors11258983pand_oors
pandoras11310053pandor_as
pandore10411853pandore__
pandours11317993pand_ours
panduras1136953pandur_as
paneless102611763pan_eless
pangenes112612823pangene_s
paniers94717333pan__iers
panners93621273pan__ners
panniers10488853pan_niers
pantdress1243363pantdress
panthers13510783pan_thers
panzers184012013pan__zers
paperer113111903pa_perer_
parceners1337453parceners
pardners11269193pard_ners
pardoners12208213pardoners
parers85530743pa___rers
parleyers1444703parleyers
parterres1148063parterres
pasturers1136393pasturers
patterer103112173patterer_
pepperers1244903pepperers
pesterers112510463pesterers
pewterers14216043pewterers
philanderers1851673philanderers
pilferers1444583pilferers
pinders103720473pind__ers
plasterers1286123plasterers
plunderer1243753plunderer_
pondered126411293pondere_d
ponderous1267273ponderous
ponders103618843pond__ers
potterers11218663potterers
powderer14245593powderer_
puckerers1744513puckerers
putterers11238363putterers
renderer9239743renderer_
sanders84025943sand__ers
saunterers1044383saunterers
slanderer1046673slanderer_
sneerers8309803_sneerers
solderers1066533solderers
spandexes1943453spandexe_s
spandrels1243253spand_rels
squanderers2151423squanderers
sunderer9310523sunderer_
tamperers13227313tamperers
taperers10269773ta_perers
tenderer9228733tenderer_
thunderers1443973thunderers
tinkerers1395423tinkerers
veneerers1244523veneerers
verderers1344843verderers
wagerers12247613wa_gerers
wandered132110793wandere_d
wanderoos1345553wanderoos
wanders114221333wand__ers
waterers112312783wa_terers
waverers14318613wa_verers
winterers12209723winterers
wonderer12249183wonderer_
yammerers16214453yammerers
zanders173015793zand__ers

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411577.78019105.5
3Display Results1571570.0632492.1
 (SQL Overall)1786911578.24921662.1
 
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.