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

191 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
pilasters113822(None) 
piasters102912811pi_asters
pilaster1038161pilaster_
pinasters1136821pinasters
plasters103518131p_lasters
blasters104116142_blasters
diasters92913182di_asters
dilaters92513062dila_ters
disasters1039152disasters
filisters1237002filisters
lasters75627692__lasters
pasters94531732p__asters
piaster93012882pi_aster_
piastres10249302pi_astres
pilsners1035532pil_sners
pinaster1037112pinaster_
plaisters1137812p_laisters
plaiters103512632p_laiters
planters102915322p_lanters
plashers133813452p_lashers
plaster93318692p_laster_
plastery13279702p_lastery
platers93924092p_la_ters
platters103415282p_latters
pollsters1137172pollsters
alastors8311223_alastors
asters65631603___asters
ballasters1245093ballasters
balusters1136643balusters
basters94930303__basters
bilanders1235963bilanders
bilayers13296923bila_yers
billeters1136873billeters
bilsteds1134273bil_steds
bimesters1336343bimesters
bisters93922613bi__sters
blaster94017303_blaster_
blatters104414093_blatters
blisters104015083_blisters
blusters104413893_blusters
boasters103915663_boasters
bolsters103712453bol_sters
cadasters1236833cadasters
casters94729903__casters
clashers134213993_clashers
claspers124410913_claspers
classers104111833_classers
clatters103313913_clatters
clusters102912403_clusters
clysters13227843_clysters
coasters104317333_coasters
cytasters1483663cytasters
delusters1035983delusters
diastems11226523di_astems
diaster82813313di_aster_
diesters92513603di_esters
digesters11257883digesters
dilater83515653dila_ter_
dilates83220663dila_te_s
dilators93213203dila_tors
diluters9288113dil_uters
disaster949943disaster_
easters75125683__easters
elaters74420193_ela_ters
enlisters937113enlisters
epilates10313503epila_te_s
epilators1149433epila_tors
feasters11511563_feasters
fibsters13126413fi_bsters
filister1137403filister_
fillisters1343873fillisters
filters103816553fil__ters
flashers143912653_flashers
flatters113814203_flatters
flusters113811503_flusters
gasters85624293__gasters
glisters93912603_glisters
hipsters13268793hi_psters
holsters113211943hol_sters
jilters144211963jil__ters
kiesters123310153ki_esters
kilters113813603kil__ters
klisters123910483_klisters
lamsters1099753__lamsters
lasers64925703__las_ers
lashers104121833__lashers
laster64830633__laster_
listers74026533__listers
lusters73921443__lusters
maltsters1135193maltsters
masters94628923__masters
milters93619093mil__ters
ministers1139623ministers
minsters103813923mi_nsters
misalters1136913misalters
misters93927513mi__sters
molesters1198873molesters
oldsters996733_oldsters
oleasters936733oleasters
palates93624943pala_te_s
palavers1337993pala_vers
palmisters1444673palmisters
palters94021683p__alters
passers94717753p__assers
pastels95215183p__astels
paster85734373p__aster_
pastern94415063p__astern
pasterns104112623p__asterns
pastes85233913p__aste_s
pastors94119003p__astors
paters84935833p__a_ters
patters94825193p__atters
paymasters1743843paymasters
pelters93720313pel__ters
pensters103012123p_ensters
pesters93827093p__esters
philanders1644273philanders
philters1398173phil__ters
piaffers16114203pi_affers
piastre9307893pi_ast_re
picketers17196483picketers
pilferers1444583pilferers
pilfers1238963pil__fers
pillagers12276923pillagers
pilseners1144943pilseners
pilsner935343pil_sner_
pipestems1542833pipestems
pirates93020333pira_te_s
pishers123815753pi__shers
pissers95014753pi__ssers
pistes85325633pi__ste_s
placaters1336473p_lacaters
placers114515263p_la_cers
plaguers11286503p_laguers
plaister1068013p_laister_
plaiter93615393p_laiter_
planers94517943p_la_ners
plankters1544583p_lankters
planners10399933p_lanners
planter94017803p_lanter_
plasher124215033p_lasher_
plashes124417393p_lashe_s
plastered1288903p_lastered
plasterer1178113p_lasterer
plasterers1286123p_lasterers
plastics122412333p_lastics
plastids11269213p_lastids
platens94213983p_la_tens
plater84427693p_la_ter_
plates85432243p_la_te_s
platter93917413p_latter_
players124313763p_la_yers
pleasers104010293pleas_ers
pleaters103613793p_leaters
plighters1545533plighters
plotters104011553p_lotters
poetasters1245283poetasters
polestars1157283polestars
polishers1477603polishers
pollster1037103pollster_
polluters1135033polluters
polyesters1545233polyesters
posters93928013p__osters
praters94921653p_ra_ters
prealters1147773prealters
presters103419003p_resters
psalters10227713p_salters
pulsates1048813pulsate_s
pulsators1175373pulsators
pulsers94213153pul_s_ers
punsters103310583p_unsters
rasters74629023__rasters
relaters83218153rela_ters
remasters11310583remasters
replasters1245533replasters
rimesters1137483rimesters
roasters83615933_roasters
sisters73721593si__sters
slashers113313613_slashers
slaters73123733_sla_ters
spinsters1136613spi_nsters
splashers1445283splashers
splatters11327543splatters
spymasters1742803spymasters
tasters74225643__tasters
tilters73315953til__ters
tipsters10278513ti_psters
toasters83912723_toasters
ulsters72711983_ul_sters
violaters1245963viola_ters
wasters104026593__wasters

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411916.98621277.0
3Display Results1911910.0762513.2
 (SQL Overall)1786911917.48223882.8
 
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.