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

419 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
parriers10361290(None) 
barriers104311891barriers
carriers103614201carriers
farriers113610741farriers
harriers113712431harriers
marriers103312471marriers
parrier93717651parrier_
parries93925841parrie_s
partiers103514241partiers
tarriers83411711tarriers
arrivers11137002_arrivers
barrier94017752barrier_
carrier93619582carrier_
carries94328012carrie_s
curriers103410752curriers
farrier103514892farrier_
farriery14295402farriery
furriers11369492furriers
harrier104417762harrier_
harries103525502harrie_s
hurriers11358892hurriers
marrers93414312marr_ers
marrieds11288072marrieds
marrier93817522marrier_
marries93825282marrie_s
paniers94717332pa_niers
panniers10488852panniers
paraders113113112paraders
pardners11269192pardners
parers85530742pa_r_ers
paries84742512pa_rie_s
parkers133816872pa_rkers
parrels94713492parr_els
parried103615722parrie_d
parroters1156772parroters
parsers94118152pa_rsers
partier93520712partier_
parties93230862partie_s
partners102711132partners
partyers13277762partyers
perries93226602perrie_s
priers84521192p__riers
quarriers1845192quarriers
sparrier10329142sparrier_
spurriers11245062spurriers
tarrier74323172tarrier_
tarries73324262tarrie_s
tarsiers8298532tarsiers
terriers84210822terriers
variers103712662va_riers
warriors1135362warriors
worriers11257812worriers
aerier64823163_aerier_
aeries64737783_aerie_s
airers64922313_air_ers
airier64619363_airier_
aperies9423203aperie_s
appliers1235573appliers
apprisers1345053apprisers
apprizers2243833apprizers
arbiters1038853_arbiters
archers124414573_archers
arguers8489033_arguers
ariels65119373_a_riels
armers85520273_a_rmers
armies85123693_armie_s
armigers1135703_armigers
arrayers11125853_arrayers
arrears738843_arrears
arris56824683_arri__s
arrises71617583_arrises
arriver10117793_arriver_
arrives101311513_arrives
artier63419733_artier_
barbers114317503ba_rbers
barbies114519593barbie_s
barkers134318513ba_rkers
barkier133814483barkier_
barmier114313043barmier_
barnier93213673barnier_
barraters1138043barraters
barrels94514363barr_els
barrens94414323barr_ens
barres84427553barr_e_s
barrets94917103barr_ets
barrios9310773barri_os
barristers1244733barristers
barters94223053ba_rters
berries94423553berrie_s
brasiers103710513brasiers
braziers19397193braziers
briers85319733__briers
buriers94017193_buriers
burrers93814493burr_ers
burrier93613553burrier_
cahiers123510673ca_hiers
carders104820353ca_rders
careers95218783ca_reers
carers85133963ca_r_ers
caries85147623ca_rie_s
carnies94123963carnie_s
carolers103314173carolers
carpers114521253ca_rpers
carrels95117303carr_els
carried103717153carrie_d
carrions10312453carrions
carters95327263ca_rters
carvers124817543ca_rvers
cashiers13318883cashiers
catbriers1344153catbriers
charrier1378693charrier_
corries94026803corrie_s
couriers103213173couriers
criers83918583__criers
currier93316703currier_
curriery13326163curriery
curries93723163currie_s
dairies84217733dairie_s
dalliers93610613dalliers
darbies104216983darbie_s
darers75921873da_r_ers
darkies124015753darkie_s
darners83815773da_rners
darters84017613da_rters
decriers11299733decriers
derriere936043derriere
derrieres1044813derrieres
derries83124623derrie_s
driers74516733__driers
durries83817353durrie_s
earlier72612743earlier_
earners74016453ea_rners
earrings9299633earrings
faeries104118993faerie_s
fairies103516043fairie_s
fanciers13358083fanciers
farcers124713443fa_rcers
farcies125317883farcie_s
farers95924053fa_r_ers
farmers124315263fa_rmers
farrieries1344353farrieries
ferries103521083ferrie_s
firrier103410133firrier_
friers94718933__friers
furrier103513663furrier_
furriery14395683furriery
furriners12316323furriners
gambiers13337073gambiers
garblers113810283garblers
garglers10418263garglers
garners83815993ga_rners
garrets84413623garr_ets
garroters1055823garroters
garters84218253ga_rters
gharries12318223gharrie_s
graziers18387123graziers
gurries83515953gurrie_s
hagriders1443553hagriders
hairier103111053hairier_
hardier114721543hardier_
hardies114923233hardie_s
harmers124116593ha_rmers
harpers124916203ha_rpers
harpies123818323harpie_s
harried113815543harrie_d
harrowers1555693harrowers
hauliers1176713hauliers
herries104025083herrie_s
hurrier103412943hurrier_
hurries103919653hurrie_s
jerries143817513jerrie_s
kauries113613193kaurie_s
kerries113317913kerrie_s
lanciers10308543lanciers
larders83516943la_rders
lardier83518343lardier_
larkers113014513la_rkers
larkier113711523larkier_
larrupers1142523larrupers
lorries74518353lorrie_s
marblers12319233marblers
marchers153710813marchers
mariners103113863mariners
markers133516103ma_rkers
marlier92614783marlier_
marrer83716673marr_er_
married104715303marrie_d
merrier92612303merrier_
murries94118673murrie_s
narraters946703narraters
pacers105124543pa__cers
pacier105018683pa_cier_
pacifiers1645463pacifiers
packers153818893pa_ckers
padders113312873pa_dders
paddies113715723paddie_s
paddlers12329153paddlers
padres95016983padr_e_s
pagers94423253pa__gers
painters103013023painters
pairings11398313pairings
pairs75325833pa__i_rs
palavers1337993palavers
palier85023563pa_lier_
pallier94417163pallier_
palmers113513623pa_lmers
palmier113312173palmier_
palsies94420273palsie_s
palters94021683pa_lters
paltrier1037543paltrier_
pampers133615933pa_mpers
panders103423733pa_nders
pandies104224503pandie_s
panfries13149203panfrie_s
panier84425503pa_nier_
panners93621273pa_nners
pannier93613353pannier_
pansies94521983pansie_s
panthers13510783panthers
panties94230933pantie_s
pantries101817393pantrie_s
panzers184012013pa_nzers
paperers122410453paperers
papers105125323pa__pers
pappier103511603pappier_
pappies103214833pappie_s
papricas1447053papricas
paprikas1643853paprikas
parader103914863parader_
parades104121463parade_s
paradors113411903paradors
parapets1239763parapets
parcels113712663pa_rcels
parceners1337463parceners
parches143720003parche_s
pardie96021443pardie__
pardner10239473pardner_
pardoners12208213pardoners
pareira937543parei_ra
pareiras1038183pareiras
pareos87023773pa_r_eos
parer75839903pa_r_er_
pares77164483pa_r_e_s
pareses94718883parese_s
pareus85420743pa_r_eus
parges94529543pa_rge_s
pargets105215193pa_rgets
pargings123410163pargings
pariahs123812343pa_riahs
parians93519733pa_rians
parietes10714543pa_rietes
parings104219213pa_rings
paris75145943pa_ri__s
parises94827183pa_rises
parities10522973paritie_s
parker124121373pa_rker_
parkings153610683parkings
parles86334403pa_rle_s
parleyers1444703parleyers
parleys125212373pa_rleys
parlors9312913pa_rlors
parlours1036153parlours
parodies11313693parodie_s
parolees104313983parolees
paroles95025883parole_s
parquets1936413parquets
parrals94414573parr_als
parred95024073parr_e_d
parrel84515983parr_e_l
parridge1254333parridge
parridges1384553parridges
parring103222063parri_ng
parritch1543543parritch
parrokets1543923parrokets
parroter1058213parroter_
parrots9312743parr_ots
parrs75928673pa_r__rs
parsecs11429923pa_rsecs
parser84822373pa_rser_
parses85534703pa_rse_s
parsleys1335083parsleys
partakers1536563partakers
partials101911963partials
partied103516553partie_d
partings113513733partings
partitas10310253partitas
partlets102811513partlets
partner92811393partner_
partyer12337873partyer_
parures9512693parure_s
parvis116114803parvi__s
parvises133911913parvises
passers94717753pa_ssers
pasters94531733pa_sters
pastier94320383pastier_
pasties94529813pastie_s
pastries101517423pastrie_s
patchers153413303patchers
paters84935833pa__ters
patriots1038053patriots
patsies93919483patsie_s
patters94825193pa_tters
patties93425143pattie_s
patzers184210573pa_tzers
paupers114311073pa_upers
pausers94113223pa_users
pavers115021823pa__vers
paviors1237603pa_viors
pavisers13387443pavisers
pawers114818783pa__wers
pawkier16236613pawkier_
pawners124311073pa_wners
payers114621823pa__yers
pearlers1039033pearlers
pearlier1037323pearlier_
peeries93623023peerie_s
perchers153611523perchers
perkier133813123perkier_
perusers10328803perusers
piercers12316723piercers
piers75926333p___iers
pitiers93812653p_itiers
pliers84715153p__liers
porgies103017003porgie_s
porkers134314933p_orkers
porkier133712343porkier_
porkies133416493porkie_s
pornier93413133pornier_
porringers1343743porringers
porters93722703p_orters
portiere1038773portiere
portieres1138223portieres
pourers93513673pour_ers
prairies10411453prairie_s
praisers103410833praisers
prancers123210333prancers
praters94921653p_raters
prawners1346003prawners
prayers124212853p_rayers
prefers123713333p_refers
premiers122911653premiers
preyers124412363p_reyers
pricers113915063p_ricers
prier75027763p__rier_
pries74339533p__rie_s
primers114215673p_rimers
priors83914483p__riors
prizers183911843p_rizers
probers113514583p_robers
propers113619033p_ropers
prosers94219643p_rosers
provers123817793p_rovers
pruners93710723p_runers
pryers115012243p__ryers
purflers13216963purflers
purgers104714003p_urgers
purifiers1435873purifiers
purlieus1034633purlieus
pursers93916093p_ursers
pursier94012753pursier_
pursuers10376523pursuers
purtier93214093purtier_
purviews1642533purviews
puttiers10288013puttiers
quarrier1736853quarrier_
quarries1749953quarrie_s
quartiers1845193quartiers
queriers1736973queriers
ralliers84010833ralliers
rapiers95012873ra_piers
rarefiers1244023rarefiers
salliers83613343salliers
saltiers83411953saltiers
sarkier113413313sarkier_
sauciers1076733sauciers
sauries72821623saurie_s
scarrier10298453scarrier_
serries73925353serrie_s
sorrier72313733sorrier_
sparers94519613spa_r_ers
spargers11389733spa_rgers
sparkers144111313spa_rkers
sparkier14298033sparkier_
sparklers15315643sparklers
sparriest11198793sparriest
spurrers10338463spurr_ers
spurrier10297693spurrier_
spurries102311323spurrie_s
starrier8279463starrier_
talliers83711373talliers
tardier859719993tardier_
tardies84225863tardie_s
tarres64723043tarr_e_s
tarried83914133tarrie_d
tarriest83215003tarriest
tarriness9229243tarriness
tarsier74119253tarsier_
tartier74123263tartier_
terrier73414963terrier_
terries73425633terrie_s
triers64321523__triers
varier94619353va_rier_
varies94330873va_rie_s
verniers11227843verniers
warblers13319103warblers
warders113416813wa_rders
warier93722893wa_rier_
warmers124514293wa_rmers
warners103315563wa_rners
warpers123413583wa_rpers
warreners1236203warreners
warrens103810893warr_ens
warrior1045363warrior_
warslers11328073warslers
wartier103413913wartier_
worrier102311683worrier_
worries104117133worrie_s
yarders113211593ya_rders
yarners104312203ya_rners

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.420425454.8
2DLD Change Limit1461624197.45319611.2
3Display Results4194190.1732422.0
 (SQL Overall)1786914198.04622208.7
 
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.