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

255 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
plashier133761(None) 
flashier1437101flashier
plasher124215031plash_er
plushier1375191plushier
splashier1443591splashier
ashier94714832__ashier
blastier10249492blastier
brashier13389932brashier
cashier123713322_cashier
clasher124615512clash_er
classier10359082classier
dashier114311182_dashier
flasher133914062flash_er
fleshier1435602fleshier
glassier9289082glassier
lasher94824532_lash_er
lathier10310832_lathier
pastier94320382p_astier
peachier1548622peachier
plashed133712642plash_ed
plashers133813452plash_ers
plashes124417392plash_es
plashiest1478382plashiest
plashing143311062plashing
plaster93318692plas_ter
platier93716292pla_tier
plusher124010382plush_er
poachier1556822poachier
pushier123611092p_ushier
slasher104515332slash_er
sloshier1135282sloshier
slushier1135982slushier
splasher1335662splash_er
trashier113210102trashier
washier133611152_washier
achier113914263__achier
ashler9459973__ashler
basher115123813_bash_er
beachier1538803beachier
blaster94017303blas_ter
blastie92411393blastie_
blasties102113633blasties
blather125314213blath_er
blusher124113113blush_er
brasher124515243brash_er
brasier94516753bras_ier
brassier103310533brassier
brushier13306973brushier
bushier123712813_bushier
cahier113615773_ca_hier
cashiers13318883_cashiers
clammier1435843clammier
clankier14327083clankier
clashed133614013clash_ed
clashers134213993clash_ers
clashes124017283clash_es
clashing143812193clashing
clasper113811863clas_per
classer93614613clas_ser
clavier1239173cla_vier
clayier1248323cla_yier
clothier1335363clothier
crasher124616163crash_er
cushier123610833_cushier
dasher104318983_dash_er
dishier113613403_dishier
easier64218463_eas_ier
fishier13359853_fishier
flabbier1534093flabbier
flaggier13105203flaggier
flakier143910203fla_kier
flamier123112143fla_mier
flappier1544303flappier
flashed144112183flash_ed
flashers143912653flash_ers
flashes133916103flash_es
flashiest1557993flashiest
flashily1735473flashily
flashing153711553flashing
flashover1843133flashover
flawier13378733fla_wier
flaxier17337983fla_xier
flesher133610923flesh_er
fleshlier1542493fleshlier
flossier11326973flossier
flusher133012273flush_er
gasher104320373_gash_er
gassier83812573_gassier
glacier103911303gla_cier
gladier93810993gla_dier
gladlier1034343gladlier
glairier944843glairier
glarier84112213gla_rier
glassie8329493glassie_
glassies94012273glassies
glazier17409353gla_zier
glossier9358203glossier
grassier9349283grassier
gushier113110073_gushier
hastier103916623_hastier
heathier1438343heathier
kasher134915033_kash_er
lacier84020093_la_cier
lakier104716273_la_kier
lambier113611643_lambier
lankier113711633_lankier
lardier83518343_lardier
larkier113711523_larkier
laser54633323_las__er
lashed105625213_lash_ed
lashers104121833_lash_ers
lashes94831003_lash_es
lashing114422893_lashing
lashins103915153_lashins
lashkar1443703_lashkar
lassie64917743_lassie_
lassies74420103_lassies
lassoer7379383_lassoer
laster64830633_las_ter
lather95124363_lath_er
lazier154214613_la_zier
leachier1337253leachier
lusher93818763_lush_er
lustier73813503_lustier
luthier1038233_luthier
marshier1337593marshier
masher114123203_mash_er
mashie11315933_mashie_
mashies12318253_mashies
massier93615223_massier
measlier1036013measlier
meshier123410853_meshier
mushier123813593_mushier
nastier74115293_nastier
pacier105018683p_a_cier
palier85023563p_a_lier
pallier94417163p_allier
palmier113312173p_almier
palship1446843palshi_p
palships1546213palships
palsied102911303pals_ied
palsies94420273pals_ies
paltrier1037533paltrier
panier84425503p_a_nier
pannier93613353p_annier
pappier103511603p_appier
parrier93717653p_arrier
partier93520713p_artier
pashed125923143p_ash_ed
pashes115828393p_ash_es
pashing135120513p_ashing
passer84721033p_as_ser
paster85734373p_as_ter
pastie85525523p_astie_
pasties94529813p_asties
patchier15319663patchier
pawkier16236613p_awkier
peacher144216073peach_er
peakier134411443pea_kier
pearlier1037323pearlier
peatier94017233pea_tier
peskier13319113p_eskier
pestier94317403p_estier
piaster93012883pias_ter
pilaster1038163pilas_ter
pisher114317753p_ish_er
pitchier15368273pitchier
pithier123010293p_ithier
placater1238013placater
placer105117743pla__cer
plaguer10328273pla_guer
plainer93811983pla_iner
plaister1068013plaister
plaiter93615393pla_iter
planer84122653pla__ner
planisher1495853planish_er
plankter1435363plankter
planner93511623pla_nner
planter94017803pla_nter
plash104616563plash___
plashy14448873plash__y
plasmic13249113plasmi_c
plasmid12239553plasmi_d
plasmids13236553plasmids
plasmin112410033plasmi_n
plasmins12199413plasmins
plasterer1178113plasterer
plasters103518133plas_ters
plastery13279703plas_tery
plastic112815063plasti_c
plastics122412333plastics
plastid102112523plasti_d
plastids11269213plastids
plater84427693pla__ter
platies93722543pla_ties
platter93917413pla_tter
player115215213pla__yer
playgoer1443533playgoer
pleaser93912343pleas__er
pleather1356653pleath_er
plier75221283pl___ier
plighter1476623plighter
pliskie1394543pliskie_
pliskies1475973pliskies
plottier10327263plottier
pluckier16295073pluckier
plumier113510043pl_umier
plummier1434123plummier
plunkier14305323plunkier
plushes124313673plush_es
plushiest1466403plushiest
plushily1664423plushily
poacher143912323poach_er
polisher1388073polish_er
posher115018163p_osh_er
pouchier1546803pouchier
preachier1646923preachier
prissier10157873prissier
prosier93817483pros_ier
punchier1536413punchier
pursier94012753purs_ier
pusher114318283p_ush_er
pussier93711993p_ussier
quasher19198623quash_er
rasher95024123_rash_er
raspier93110643_raspier
rushier103411973_rushier
sassier73413233_sassier
shier85428943___shier
slaggier10126953slaggier
slangier9117933slangier
slashed114114853slash_ed
slashers113313613slash_ers
slashes103619113slash_es
slashing123713413slashing
slather103816083slath_er
slatier74016813sla_tier
smasher123911023smash_er
splashed1435593splash_ed
splashers1445283splash_ers
splashes1337503splash_es
splashiest1544473splashiest
splashily1742963splashily
splashing1535703splashing
squashier2143913squashier
swasher134011513swash_er
swishier1434563swishier
tastier711817093_tastier
toastier846893toastier
trasher104416133trash_er
vastier103613203_vastier
washer124720393_wash_er
waspier12259053_waspier
wrathier1435903wrathier
yeastier1135393yeastier

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.406440125.6
2DLD Change Limit1461622557.76618820.8
3Display Results2552550.0932741.9
 (SQL Overall)1786912558.26521620.2
 
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.