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

389 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
panniers1048885(None) 
paniers94717331pa_niers
panners93621271pann_ers
pannier93613351pannier_
banners94018712bann_ers
canners93822662cann_ers
cannier94014162cannier_
fanciers13358082fanciers
fanners103914652fann_ers
fannies103415642fannie_s
lanciers10308542lanciers
lanners73618332lann_ers
manners93417832mann_ers
nannies73015202nannie_s
painters103013022painters
panders103423732pa_nders
pandies104224502pandie_s
panier84425502pa_nier_
panner84224762pann_er_
pannes85522852pann_e_s
panniered1243852panniered
pansies94521982pansie_s
panthers13510782panthers
panties94230932pantie_s
panzers184012012pa_nzers
parriers103612902parriers
partiers103514242partiers
pawners124311072pawn_ers
penners93414182penn_ers
pennies94218812pennie_s
pinners93518602pinn_ers
pinnies93318442pinnie_s
planners10399932plann_ers
punners94114232punn_ers
punnier93511262punnier_
spanners103710772spann_ers
tanners74018392tann_ers
vanners103612842vann_ers
aliners74717723_aliners
angers75222543_a_ngers
anglers84014823_anglers
annoyers1185033_annoyers
answers1037043_answers
anthers103715203_anthers
antiars7314623_antiars
antlers74014743_antlers
appliers1235573appliers
banders104324563ba_nders
bandies104124863bandie_s
bangers104020353ba_ngers
bankers133919093ba_nkers
banner84421503bann_er_
bannets94013843bann_ets
bannisters1244323bannisters
banters94623113ba_nters
banties94324763bantie_s
barnier93213673barnier_
barriers104311883barriers
bennies93917313bennie_s
bonnier94711313bonnier_
branners104010923brann_ers
brannier10218933brannier_
bunnies94415003bunnie_s
cahiers123510673ca_hiers
cancers114018583ca_ncers
candies104125613candie_s
candlers114214103candlers
caners84629203ca_n_ers
canines93724033canine_s
cankers134418753ca_nkers
cannels93413363cann_els
canner84625983cann_er_
cannery123610013cann_ery
cannie83819363cannie__
canniest10313363canniest
canniness1138643canniness
cannings113710333cannings
cannisters1245013cannisters
canoers94318373ca_noers
canonizers2144413canonizers
canters94827733ca_nters
caponiers1345733caponiers
carnies94123963carnie_s
carriers103614203carriers
cashiers13318883cashiers
conners94023113conn_ers
connivers1436933connivers
crannies10313013crannie_s
cunners93913473cunn_ers
dalliers93610613dalliers
damners104112113damn_ers
dancers103413093da_ncers
danders93921183da_nders
dandier93714573dandier_
dandies94121443dandie_s
dandlers103912053dandlers
dangers94818213da_ngers
danglers103610593danglers
darners83815773darn_ers
daunders10278473daunders
daunters9329853daunters
deniers84515183_deniers
dinners83915443dinn_ers
donnikers1443443donnikers
earners74016453earn_ers
enviers1036993_enviers
fainters11349693fainters
fancier123412063fancier_
fancies124018783fancie_s
fanner94218183fann_er_
farriers113610743farriers
fawners13388493fawn_ers
fawnier13296363fawnier_
fennier10339253fennier_
finnier10319953finnier_
funnier103210173funnier_
funnies104113603funnie_s
gainers84214593gain_ers
gambiers13337073gambiers
ganders93521703ga_nders
gangers94418603ga_ngers
gannets83811443gann_ets
gannisters1153843gannisters
garners83815983garn_ers
ginners84314223ginn_ers
ginnier8298983ginnier_
grannies9312613grannie_s
gunners83111733gunn_ers
gunnies83413123gunnie_s
hanapers1346963hanapers
handers114224333ha_nders
handier113817443handier_
handlers124014143handlers
hangers113120813ha_ngers
hankers144218133ha_nkers
hankies143617763hankie_s
harriers113712433harriers
hauliers1176713hauliers
haunters11329543haunters
hinnies103615103hinnie_s
inliers73110743_inliers
inners63919353_inn_ers
janglers16319373janglers
japanners1842813japann_ers
jennies143511623jennie_s
lancers93616643la_ncers
landers84026213la_nders
landlers94312833landlers
lankier113711633lankier_
lanner64920603lann_er_
launders9358743launders
managers112911003managers
mangers103521263ma_ngers
mangier104114063mangier_
manglers113311903manglers
manlier92414023manlier_
manner84020513mann_er_
mannites10312613mannites
manurers1037593manurers
mariners103113863mariners
marriers103312473marriers
maunders11348343maunders
minnies93617363minnie_s
nancies93516843nancie_s
nannie63713223nannie__
ninnies73713613ninnie_s
pacers105124543pa__cers
pacier105018683pa_cier_
pacifiers1645463pacifiers
packers153818893pa_ckers
padders113312873pa_dders
paddies113715723paddie_s
paddlers12329153paddlers
paganizers2253713paganizers
pagers94423253pa__gers
painless10108343painless
painter93814563painter_
paintier1048793paintier_
pairs75325833pa__i_rs
palavers1337993palavers
palier85023563pa_lier_
pallier94417163pallier_
palmers113513623pa_lmers
palmier113312173palmier_
palsies94420273palsie_s
palters94021683pa_lters
pampers133615933pa_mpers
panaceas1236763panaceas
pancreas1235393pancreas
pander93725523pa_nder_
panderers12229153panderers
pandied113913443pandie_d
pandits103914213pandi_ts
pandoors11258983pandoors
pandores11312453pandores
pandours11317993pandours
paneless102611763paneless
panels84716523pa_n_els
panes76148693pa_n_e_s
panfries13149203panfrie_s
pangens103112063pa_ngens
panics103815363pa_ni_cs
panmixes1934913panmixes
panmixis1943303panmixis
panne76623653pann_e__
panned94123433pann_e_d
pannikin14194923pannikin
pannikins15204843pannikins
panning104019393panni_ng
panpipes1135173panpipes
panther12611443panther_
pantie84326473pantie__
pantiles103617153pantiles
pantries101817393pantrie_s
panzer174213233pa_nzer_
paperers122410453paperers
papers105125323pa__pers
pappier103511603pappier_
pappies103214833pappie_s
paraders113113113paraders
pardners11269193pardners
parers85530743pa__rers
paries84742513pa_rie_s
parkers133816873pa_rkers
parrier93717653parrier_
parries93925843parrie_s
parsers94118153pa_rsers
partier93520713partier_
parties93230863partie_s
partners102711133partners
partyers13277763partyers
passers94717753pa_ssers
pasters94531733pa_sters
pastier94320383pastier_
pasties94529813pastie_s
patchers153413303patchers
paters84935833pa__ters
patines95225763patine_s
patness92912283patn_ess
patsies93919483patsie_s
patters94825193pa_tters
patties93425143pattie_s
patzers184210573pa_tzers
paupers114311073pa_upers
pausers94113223pa_users
pavers115021823pa__vers
paviors1237603pa_viors
pavisers13387443pavisers
pawers114818783pa__wers
pawkier16236613pawkier_
pawnees12298173pawn_ees
pawner114212923pawn_er_
pawnors12297203pawn_ors
payers114621823pa__yers
paynims1434973payni_ms
pencilers1345643pencilers
penner84616663penn_er_
penniless1144013penniless
pennines103112043pennines
pennis84315743penni__s
pensters103012123pensters
peonies93620153peonie_s
phonier122710633phonier_
phonies123717513phonie_s
piers75926333p___iers
pincers113916503p_incers
pinchers153510613pinchers
pinders103720473p_inders
pingers104020743p_ingers
pinier84024693p_inier_
pinkers134118603p_inkers
pinkies133818263pinkie_s
pinner84521503pinn_er_
pinnipeds1441973pinnipeds
pioneers1035863pioneers
pitiers93812653p_itiers
planers94517943plan_ers
plankters1544583plankters
planner93511623plann_er_
plannings12325453plannings
planters102915323planters
pliers84715153p__liers
plinkers14309393plinkers
plunders11329833plunders
plungers11379403plungers
plunkers14328333plunkers
pointers103013723pointers
ponders103618843p_onders
ponies84833463p_onie_s
pontoniers1245323pontoniers
pornier93413133pornier_
pouncers12349203pouncers
pounders113113283pounders
prancers123210333prancers
prawners1346003prawn_ers
premiers122911653premiers
priers84521193p__riers
prinkers143010383prinkers
printers103214903printers
pruners93710723prun_ers
punchers152610073punchers
punier84519223p_unier_
puniness101610273puniness
punkers133714853p_unkers
punkier133512793punkier_
punkies134216803punkie_s
punner84918153punn_er_
punnets9409263punn_ets
punniest102511583punniest
punsters103310583punsters
punters93617043p_unters
punties94520783puntie_s
puttiers10288013puttiers
rainier71614263rainier_
ralliers84010833ralliers
ranchers133311793ranchers
randier83618473randier_
randies84225663randie_s
rangers83621043ra_ngers
rangier83714353rangier_
rankers113217463ra_nkers
ranters73323643ra_nters
rapiers95012873ra_piers
rentiers83311763rentiers
runners74212453runn_ers
runnier74010113runnier_
salliers83613343salliers
saltiers83411953saltiers
sanders84025943sa_nders
sandier84017843sandier_
sangers84421943sa_ngers
sanies63031953sa_nie_s
santirs7312963santi_rs
sauciers1076733sauciers
saunters82911753saunters
scanners10379703scann_ers
shannies113411263shannie_s
sinners74019023sinn_ers
sonnies7315223sonnie_s
spaniels1045963spa_niels
spankers14369863spa_nkers
spanner94312563spann_er_
spawners13396493spawn_ers
spinners103810863spinn_ers
spinnies103210543spinnie_s
sunnier73412153sunnier_
talliers83711373talliers
tanagers9259003tanagers
tangier83013903tangier_
tanglers92911973tanglers
tankers113416913ta_nkers
tanner63722283tann_er_
tannery10388663tann_ery
tannings9268633tannings
tannins72813223tanni_ns
tansies74521243tansie_s
tarriers83411713tarriers
tarsiers8298533tarsiers
taunters8259273taunters
tawnier10318463tawnier_
tawnies102812503tawnie_s
tenners74014923tenn_ers
tennies73017973tennie_s
tinners73717313tinn_ers
tinnier72910143tinnier_
tonners73816403tonn_ers
trannies8415013trannie_s
tunnies73614263tunnie_s
vanner94215843vann_er_
variers103712663va_riers
vaunters11327753vaunters
verniers11227843verniers
wanders114221333wa_nders
wanglers123310033wanglers
wanier93920683wa_nier_
wankers144514713wa_nkers
wanner94019623wann_er_
wanness102610683wann_ess
wanters104420093wa_nters
warners103315563warn_ers
wennier10318603wennier_
winners104316913winn_ers
wonners104312813wonn_ers
yarners104312203yarn_ers
yawners13367183yawn_ers
zanders173015793za_nders
zanier154314713za_nier_
zanies153219673za_nie_s
zaniness1738663zaniness

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.893200101.9
2DLD Change Limit1461623897.23320207.7
3Display Results3893890.1862091.4
 (SQL Overall)1786913898.31221498.0
 
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.