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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
panzers18401201(None) 
panders103423741panders
paniers94717331paniers
panners93621271panners
panzer174213231panzer_
patzers184210571patzers
angers75222542_angers
banders104324562banders
bangers104020352bangers
bankers133919092bankers
banners94018712banners
banters94623122banters
cancers114018582cancers
caners84629202can_ers
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
dancers103413092dancers
danders93921182danders
dangers94818212dangers
fanners103914652fanners
ganders93521702ganders
gangers94418602gangers
gazers164516302ga_zers
handers114224332handers
hangers113120812hangers
hankers144218132hankers
hazers184615952ha_zers
jazzers22324762jazzers
lancers93616642lancers
landers84026222landers
lanners73618332lanners
mamzers20409162mamzers
mangers103521262mangers
manners93417832manners
mazers173917092ma_zers
pacers105124542pa_cers
packers153818892packers
padders113312872padders
pagers94423252pa_gers
painters103013032painters
palmers113513622palmers
palters94021682palters
pampers133615932pampers
pander93725532pander_
panels84716522pan_els
panes76148692pan_e_s
pangens103112072pangens
panier84425502panier_
panner84224762panner_
pannes85522852panne_s
panniers10488852panniers
panthers13510782panthers
papers105125322pa_pers
parers85530742pa_rers
parkers133816872parkers
parsers94118152parsers
passers94717752passers
pasters94531732pasters
paters84935842pa_ters
patters94825192patters
patzer173111642patzer_
paupers114311072paupers
pausers94113222pausers
pavers115021822pa_vers
pawers114818782pa_wers
pawners124311072pawners
payers114621822pa_yers
penners93414182penners
pincers113916502pincers
pinders103720482pinders
pingers104020742pingers
pinkers134118602pinkers
pinners93518602pinners
planers94517952plan_ers
planners10399942planners
planters102915332planters
ponders103618852ponders
potzers184010542potzers
prancers123210342prancers
prizers183911842prizers
punkers133714862punkers
punners94114242punners
punters93617052punters
rangers83621042rangers
rankers113217462rankers
ranters73323642ranters
razers154919612ra_zers
sanders84025942sanders
sangers84421942sangers
spankers14369862spankers
spanners103710772spanners
tankers113416912tankers
tanners74018392tanners
vanners103612842vanners
wanders114221332wanders
wankers144514712wankers
wanters104420092wanters
zanders173015792zanders

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.406440125.6
2DLD Change Limit1076711003.45331181.9
3Display Results1001000.0303333.3
 (SQL Overall)1786911003.88945947.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.