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

123 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
paniers9471733(None) 
panders103423731panders
panier84425501panier_
panners93621271panners
panniers10488851panniers
panzers184012011panzers
angers75222542_angers
banders104324562banders
bangers104020352bangers
bankers133919092bankers
banners94018712banners
banters94623112banters
cahiers123510672cahiers
cancers114018582cancers
caners84629202can_ers
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
dancers103413092dancers
danders93921182danders
dangers94818212dangers
deniers84515182deniers
fanciers13358082fanciers
fanners103914652fanners
gainers84214592gainers
ganders93521702ganders
gangers94418602gangers
handers114224332handers
hangers113120812hangers
hankers144218132hankers
lancers93616642lancers
lanciers10308542lanciers
landers84026212landers
lanners73618332lanners
mangers103521262mangers
manners93417832manners
pacers105124542pa_cers
pacier105018682pacier_
packers153818892packers
padders113312872padders
pagers94423252pa_gers
painters103013022painters
pairs75325832pa_i_rs
palier85023562palier_
palmers113513622palmers
palters94021682palters
pampers133615932pampers
pander93725522pander_
pandies104224502pandie_s
panels84716522pan_els
panes76148692pan_e_s
pangens103112062pangens
panics103815362pani_cs
panner84224762panner_
pannes85522852panne_s
pannier93613352pannier_
pansies94521982pansie_s
panthers13510782panthers
panties94230932pantie_s
panzer174213232panzer_
papers105125322pa_pers
parers85530742pa_rers
paries84742512parie_s
parkers133816872parkers
parriers103612902parriers
parsers94118152parsers
partiers103514242partiers
passers94717752passers
pasters94531732pasters
paters84935832pa_ters
patters94825192patters
patzers184210572patzers
paupers114311072paupers
pausers94113222pausers
pavers115021822pa_vers
paviors1237602paviors
pavisers13387442pavisers
pawers114818782pa_wers
pawners124311072pawners
payers114621822pa_yers
penners93414182penners
piers75926332p__iers
pincers113916502pincers
pinders103720472pinders
pingers104020742pingers
pinier84024692pinier_
pinkers134118602pinkers
pinners93518602pinners
pitiers93812652pitiers
planers94517942plan_ers
planners10399932planners
planters102915322planters
pliers84715152p_liers
ponders103618842ponders
ponies84833462ponie_s
prancers123210332prancers
priers84521192p_riers
punier84519222punier_
punkers133714852punkers
punners94114232punners
punters93617042punters
rangers83621042rangers
rankers113217462rankers
ranters73323642ranters
rapiers95012872rapiers
sanders84025942sanders
sangers84421942sangers
sanies63031952sanie_s
spaniels1045962spaniels
spankers14369862spankers
spanners103710772spanners
tankers113416912tankers
tanners74018392tanners
vanners103612842vanners
variers103712662variers
wanders114221332wanders
wanier93920682wanier_
wankers144514712wankers
wanters104420092wanters
zanders173015792zanders
zanier154314712zanier_
zanies153219672zanie_s

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.1231452772.4
2DLD Change Limit1076711233.40631612.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911233.57549983.5
 
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.