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

234 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
pilaster103816(None) 
piaster93012881pi_aster
pilasters1138221pilasters
pinaster1037111pinaster
plaster93318691p_laster
blaster94017302_blaster
diaster82813312di_aster
dilater83515652dila_ter
disaster949942disaster
filister1137402filister
laster64830632__laster
paster85734372p__aster
piasters102912812pi_asters
piastre9307892pi_astre
pilsner935342pil_sner
pinasters1136822pinasters
plaister1068012p_laister
plaiter93615392p_laiter
planter94017802p_lanter
plasher124215032p_lasher
plasters103518132p_lasters
plastery13279702p_lastery
plater84427692p_la_ter
platter93917412p_latter
pollster1037102pollster
alastor739653_alastor
aster55434893___aster
ballaster1145973ballaster
baluster1037053baluster
baster85333593__baster
bilander1136673bilander
bilayer12347803bila_yer
billeter1037563billeter
bilsted1038033bil_sted
bimester1236163bimester
bister84922763bi__ster
blasted104213473_blasted
blasters104116143_blasters
blastier10249493_blastier
blatter94415653_blatter
blister94415313_blister
bluster94215313_bluster
boaster94616433_boaster
bolster93713423bol_ster
cadaster1136903cadaster
caster85232573__caster
chaster124718503_chaster
clasher124615513_clasher
clasper113811863_clasper
classer93614613_classer
clatter94014973_clatter
cluster94013333_cluster
clyster12317453_clyster
coaster94219043_coaster
cytaster1383863cytaster
deluster936903deluster
diastem10318043di_astem
diasters92913183di_asters
diester83013683di_ester
digester10258433digester
dilate73220693dila_te_
dilated93115823dila_ted
dilaters92513063dila_ters
dilates83220663dila_tes
dilator82712783dila_tor
diluter8319663dil_uter
disasters1039153disasters
easter65027983__easter
elater64724203_ela_ter
enlister847803enlister
epilate9314283epila_te_
epilated11310753epila_ted
epilates10313503epila_tes
epilator1049243epila_tor
faster94625773__faster
feaster10812983_feaster
fibster12146533fi_bster
filisters1237003filisters
fillister1244423fillister
filter94517633fil__ter
flasher133914063_flasher
flatter103815963_flatter
fluster103913063_fluster
gaster75027353__gaster
glister84013343_glister
hipster12288783hi_pster
holster103512213hol_ster
irater65218353_ira_ter
jilter133512513jil__ter
kiester11329973ki_ester
kilter103714343kil__ter
klister113410643_klister
lamster9109913__lamster
laser54633323__las_er
lasher94824533__lasher
lasted74323603__lasted
lasters75627693__lasters
later54843923__la_ter
latter65027893__latter
lister64527253__lister
luster64023673__luster
maltster1035303maltster
master84831343__master
milter84921233mil__ter
minister10410363minister
minster93914323mi_nster
misalter1038343misalter
mister84728563mi__ster
molester1099373molester
oldster896573_oldster
oleaster837263oleaster
palate84226783pala_te_
palates93624933pala_tes
palaver1238753pala_ver
palmister1345053palmister
palter84423263p__alter
passer84721033p__asser
paste74932953p__aste_
pasted94426903p__asted
pastel85918713p__astel
pastern94415063p__astern
pasters94531733p__asters
pastes85233913p__astes
pastier94320383p__astier
pastor84817483p__astor
pater74740723p__a_ter
patter84628263p__atter
paymaster1643873paymaster
pearter9412743p_earter
pelter83321623pel__ter
penster92811953p_enster
pester84827593p__ester
phatter123810203p_hatter
philander1544063philander
philter12108213phil__ter
piaffer15104443pi_affer
piastres10249303pi_astres
picante11310523picante_
picketer16187433picketer
pilar75221503pila___r
pileate93815923pileate_
pileated112711133pileated
pilfer1139163pil__fer
pilferer1344923pilferer
pillager11278553pillager
pilose84514243pilos_e_
piloted10310323pil_oted
pilsener1044753pilsener
pilsners1035533pil_sners
pipestem1443743pipestem
pirate82322883pira_te_
pirated102515613pira_ted
pirates93020333pira_tes
pisher114317753pi__sher
pisser84416383pi__sser
piste75824603pi__ste_
pistes85325633pi__stes
placater1238013p_lacater
placer105117743p_la_cer
plaguer10328273p_laguer
plainer93811983p_lainer
plaisters1137813p_laisters
plaited103713893p_laited
plaiters103512633p_laiters
planer84122653p_la_ner
plankter1435363p_lankter
planner93511623p_lanner
plantar9369993p_lantar
planted103516123p_lanted
planters102915323p_lanters
plashed133712643p_lashed
plashers133813453p_lashers
plashes124417393p_lashes
plashier1337613p_lashier
plastered1288893p_lastered
plasterer1178103p_lasterer
plastic112815063p_lastic
plastid102112523p_lastid
plate74635113p_la_te_
plated95225773p_la_ted
platen84518203p_la_ten
platers93924093p_la_ters
plates85432243p_la_tes
platier93716293p_latier
platted103614263p_latted
platters103415283p_latters
player115215213p_la_yer
pleaser93912343pleas_er
pleater93916333p_leater
plighter1476623plighter
plotter94113663p_lotter
plusher124010383p_lusher
poetaster1145673poetaster
polestar1047113polestar
polisher1388073polisher
politer92417073pol_iter
pollsters1137173pollsters
polluter1035403polluter
polyester1445353polyester
poster84129173p__oster
prater84825353p_ra_ter
prealter1048863prealter
prester93519623p_rester
privater13158533priva_ter
psalter9247813p_salter
pulsate9510233pulsate_
pulsated1136853pulsated
pulsates1048813pulsates
pulsator1085693pulsator
pulser84215193pul_s_er
punster92911103p_unster
raster64731443__raster
relater73723143rela_ter
remaster10311473remaster
replaster1136583replaster
rimester1037813rimester
roaster74116663_roaster
silenter838873silenter
sinister838583sinister
sister64421583si__ster
slasher104515333_slasher
slater64429183_sla_ter
spinster1036683spi_nster
splasher1335663splasher
splatter10348883splatter
spymaster1642583spymaster
taster64930573__taster
tilter63417693til__ter
tipster9299053ti_pster
toaster74414463_toaster
ulster63712103_ul_ster
vaster94521023__vaster
violater1137253viola_ter
waster95228943__waster

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 Limit1461622347.71618942.7
3Display Results2342340.0802925.0
 (SQL Overall)1786912348.20221786.3
 
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.