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

128 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
plaster9331869(None) 
blaster94017301blaster
laster64830631_laster
paster85734371p_aster
piaster93012881piaster
pilaster1038161pilaster
plaister1068011plaister
plaiter93615391plaiter
planter94017811planter
plasher124215031plasher
plasters103518131plasters
plastery13279701plastery
plater84427691pla_ter
platter93917411platter
alastor739672alastor
aster55434892__aster
baster85333602_baster
blasted104213472blasted
blasters104116142blasters
blastier10249492blastier
blatter94415652blatter
blister94415312blister
bluster94215312bluster
boaster94616432boaster
caster85232572_caster
chaster124718502chaster
clasher124615512clasher
clasper113811862clasper
classer93614612classer
clatter94014972clatter
cluster94013332cluster
clyster12317452clyster
coaster94219042coaster
diaster82813312diaster
easter65027982_easter
elater64724202ela_ter
faster94625772_faster
feaster10812982feaster
flasher133914062flasher
flatter103815962flatter
fluster103913062fluster
gaster75027352_gaster
glister84013342glister
klister113410642klister
lamster9109912_lamster
laser54633322_las_er
lasher94824532_lasher
lasted74323602_lasted
lasters75627692_lasters
later54843922_la_ter
latter65027892_latter
lister64527252_lister
luster64023672_luster
master84831342_master
oldster896572oldster
oleaster837262oleaster
palter84423262p_alter
passer84721032p_asser
paste74932952p_aste_
pasted94426902p_asted
pastel85918712p_astel
pastern94415062p_astern
pasters94531732p_asters
pastes85233912p_astes
pastier94320382p_astier
pastor84817482p_astor
pater74740732p_a_ter
patter84628262p_atter
pearter9412742pearter
penster92811952penster
pester84827592p_ester
phatter123810202phatter
piasters102912812piasters
piastre9307892piastre
pilasters1138222pilasters
pinaster1037112pinaster
placater1238012placater
placer105117742pla_cer
plaguer10328272plaguer
plainer93811982plainer
plaisters1137812plaisters
plaited103713892plaited
plaiters103512632plaiters
planer84122662pla_ner
plankter1435362plankter
planner93511632planner
plantar9369992plantar
planted103516122planted
planters102915332planters
plashed133712642plashed
plashers133813452plashers
plashes124417392plashes
plashier1337612plashier
plastered1288912plastered
plasterer1178112plasterer
plastic112815062plastic
plastid102112522plastid
plate74635112pla_te_
plated95225772pla_ted
platen84518202pla_ten
platers93924092pla_ters
plates85432242pla_tes
platier93716292platier
platted103614262platted
platters103415282platters
player115215212pla_yer
pleaser93912342pleas_er
pleater93916332pleater
plotter94113662plotter
plusher124010392plusher
pollster1037102pollster
poster84129172p_oster
prater84825352pra_ter
prester93519622prester
psalter9247812psalter
punster92911102punster
raster64731442_raster
replaster1136582replaster
roaster74116662roaster
slasher104515332slasher
slater64429182sla_ter
splasher1335662splasher
splatter10348882splatter
taster64930572_taster
toaster74414462toaster
ulster63712102ul_ster
vaster94521022_vaster
waster95228942_waster

Search took 5 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.360496363.9
2DLD Change Limit1076711283.70329076.7
3Display Results1281280.0462782.6
 (SQL Overall)1786911284.10943487.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.