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

106 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
plasters10351813(None) 
blasters104116141blasters
lasters75627691_lasters
pasters94531731p_asters
piasters102912801piasters
pilasters1138211pilasters
plaisters1137811plaisters
plaiters103512631plaiters
planters102915321planters
plashers133813451plashers
plaster93318691plaster_
plastery13279701plastery
platers93924081pla_ters
platters103415281platters
alastors8311192alastors
asters65631602__asters
basters94930302_basters
blaster94017302blaster_
blatters104414092blatters
blisters104015082blisters
blusters104413882blusters
boasters103915652boasters
casters94729892_casters
clashers134213992clashers
claspers124410912claspers
classers104111832classers
clatters103313902clatters
clusters102912392clusters
clysters13227822clysters
coasters104317302coasters
diasters92913172diasters
easters75125682_easters
elaters74420182ela_ters
feasters11511562feasters
flashers143912652flashers
flatters113814202flatters
flusters113811492flusters
gasters85624282_gasters
glisters93912602glisters
klisters123910482klisters
lamsters1099752_lamsters
lasers64925702_las_ers
lashers104121832_lashers
laster64830632_laster_
listers74026522_listers
lusters73921432_lusters
masters94628922_masters
oldsters996732oldsters
oleasters936732oleasters
palters94021682p_alters
passers94717752p_assers
pastels95215182p_astels
paster85734372p_aster_
pastern94415062p_astern
pasterns104112622p_asterns
pastes85233912p_aste_s
pastors94118992p_astors
paters84935822p_a_ters
patters94825192p_atters
pensters103012122pensters
pesters93827092p_esters
piaster93012882piaster_
piastres10249302piastres
pilaster1038162pilaster_
pinasters1136812pinasters
placaters1336462placaters
placers114515262pla_cers
plaguers11286502plaguers
plaister1068012plaister_
plaiter93615392plaiter_
planers94517942pla_ners
plankters1544582plankters
planners10399932planners
planter94017802planter_
plasher124215032plasher_
plashes124417392plashe_s
plastered1288892plastered
plasterer1178102plasterer
plasterers1286122plasterers
plastics122412322plastics
plastids11269202plastids
platens94213982pla_tens
plater84427692pla_ter_
plates85432242pla_te_s
platter93917412platter_
players124313762pla_yers
pleasers104010292pleas_ers
pleaters103613782pleaters
plotters104011552plotters
pollsters1137172pollsters
posters93927992p_osters
praters94921642pra_ters
presters103419002presters
psalters10227712psalters
punsters103310582punsters
rasters74629022_rasters
replasters1245522replasters
roasters83615912roasters
slashers113313602slashers
slaters73123722sla_ters
splashers1445272splashers
splatters11327542splatters
tasters74225642_tasters
toasters83912702toasters
ulsters72711982ul_sters
wasters104026592_wasters

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 Filter1786911210590.1401276364.3
2DLD Change Limit1210591064.17329010.1
3Display Results1061060.0462304.3
 (SQL Overall)1786911064.35940993.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.