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

151 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
pinasters113682(None) 
piasters102912811pi_asters
pilasters1138221pilasters
pinaster1037111pinaster_
diasters92913182di_asters
disasters1039152disasters
ministers1139622ministers
minsters103813922min_sters
pasters94531732p__asters
pensters103012122pen_sters
piaster93012882pi_aster_
piastres10249302pi_astres
pilaster1038162pilaster_
plasters103518132p_lasters
punsters103310582pun_sters
spinsters1136612spin_sters
asters65631603___asters
banisters11189473banisters
basters94930303__basters
bimesters1336343bimesters
bisters93922613bi__sters
blasters104116143_blasters
boasters103915663_boasters
cadasters1236833cadasters
canisters112310193canisters
casters94729903__casters
cineastes1165563cineaste_s
coasters104317333_coasters
cytasters1483663cytasters
diastems11226523di_astems
diaster82813313di_aster_
diesters92513603di_esters
digesters11257883digesters
dilaters92513063dila_ters
disaster949943disaster_
easters75125683__easters
epinasties1243793epinasties
feasters11511563_feasters
fibsters13126413fi_bsters
filisters1237003filisters
finaglers13173893finaglers
finishers1545353finishers
gangsters11205733gangsters
ganisters10248313ganisters
gasters85624293__gasters
hinters103719583hin__ters
hipsters13268793hi_psters
inciters103210673_inciters
inditers93311053_inditers
infesters12237713_infesters
insisters997653_insisters
instars7411133_in_stars
insteps936573_in_steps
inters64328053_in__ters
inviters11359643_inviters
kiesters123310153ki_esters
kinases113511123kinas_e_s
lasters75627693__lasters
linecasters13102593linecasters
linters73822633lin__ters
listers74026533li__sters
masters94628923__masters
minister10410363minister_
minster93914323min_ster_
minters93822473min__ters
misalters1136913misalters
misters93927513mi__sters
monastery1444373monastery
monsters103314553mon_sters
munsters104010553mun_sters
natters73718063__natters
nesters74422793__nesters
oleasters936733oleasters
painters103013023pain__ters
palters94021683p__alters
passers94717753p__assers
pastels95215183p__astels
paster85734373p__aster_
pastern94415063p__astern
pasterns104112623p__asterns
pastes85233913p__aste_s
pastors94119003p__astors
paters84935833p__a_ters
patters94825193p__atters
paymasters1743843paymasters
penates93321593pena_te_s
penster92811953pen_ster_
pesters93827093p__esters
piaffers16114203pi_affers
piastre9307893pi_ast_re
picketers17196483picketers
pilsners1035533pi_lsners
pinafores1444503pinafores
pinatas93711503pina_t_as
pincers113916503pin__cers
pinchers153510613pin_chers
pinders103720473pin__ders
pingers104020743pin__gers
pinites9319533pin_ite_s
pinkers134118603pin__kers
pinners93518603pin__ners
pinschers1644373pinschers
pinsetters1244103pinsetters
pipestems1542833pipestems
pirates93020333pira_te_s
pishers123815753pi__shers
pissers95014753pi__ssers
pistes85325633pi__ste_s
plaisters1137813plaisters
plaiters103512633p_laiters
plankters1544583plankters
planters102915323p_lanters
plashers133813453p_lashers
plaster93318693p_laster_
plastery13279703p_lastery
platers93924093p_la_ters
platters103415283p_latters
pleasers104010293pleas_ers
pleaters103613793plea_ters
poetasters1245283poetasters
pointers103013723poin__ters
pollsters1137173pollsters
posters93928013p__osters
pranksters1653283pranksters
praters94921653p_ra_ters
prealters1147773prealters
presters103419003p_resters
printers103214903prin__ters
psalters10227713p_salters
punishers1434973punishers
punster92911103pun_ster_
punters93617043pun__ters
rasters74629023__rasters
remasters11310583remasters
rimesters1137483rimesters
ringmasters14132803ringmasters
rinsers73815743rin_s_ers
roasters83615933_roasters
sinister838583sinister_
sinters74024083sin__ters
sisters73721593si__sters
songsters1046113songsters
spinster1036683spin_ster_
spymasters1742803spymasters
tasters74225643__tasters
tinters74221113tin__ters
tipsters10278513ti_psters
toasters83912723_toasters
vinasses1135703vinasse_s
wasters104026593__wasters
winters103720483win__ters

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.1561145455.1
2DLD Change Limit1486411517.33020278.4
3Display Results1511510.0602516.7
 (SQL Overall)1786911517.54623680.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.