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

182 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
pinaster103711(None) 
piaster93012881pi_aster
pilaster1038161pilaster
pinasters1136821pinasters
diaster82813312di_aster
disaster949942disaster
minister10410362minister
minster93914322min_ster
paster85734372p__aster
penster92811952pen_ster
piasters102912812pi_asters
piastre9307892pi_astre
pilasters1138222pilasters
plaster93318692p_laster
punster92911102pun_ster
sinister838582sinister
spinster1036682spin_ster
aster55434893___aster
banister10199973banister
baster85333593__baster
bimester1236163bimester
binate8419773bina_te_
bister84922763bi__ster
blaster94017303_blaster
boaster94616433_boaster
cadaster1136903cadaster
canister101710853canister
caster85232573__caster
chaster124718503_chaster
cineaste1045743cineaste_
cineastes1165563cineastes
coaster94219043_coaster
cytaster1383863cytaster
diastem10318043di_astem
diasters92913183di_asters
diester83013683di_ester
digester10258433digester
dilater83515653dila_ter
disasters1039153disasters
easter65027983__easter
epinastic1344953epinastic
epinasties1243793epinasties
epinasty1343133epinast_y
faster94625773__faster
feaster10812983_feaster
fibster12146533fi_bster
filister1137403filister
finagler12194953finagler
finisher1436303finisher
gangster10215773gangster
ganister9178993ganister
gaster75027353__gaster
hinter94021303hin__ter
hipster12288783hi_pster
honester1139713honester
inaner62213543_ina_ner
inciter93113773_inciter
inditer83514233_inditer
infester11239433_infester
insaner7310443_insaner
insister888783_insister
instar6310013_in_star
instep838193_in_step
inter55028493_in__ter
inviter104112313_inviter
irater65218353_ira_ter
kiester11329973ki_ester
kinase104210653kinas_e_
kinases113511123kinas_es
laster64830633__laster
linecaster1282913linecaster
linter64625343lin__ter
lister64527253li__ster
master84831343__master
ministers1139623ministers
minsters103813923min_sters
minter84425103min__ter
minuter93510413min_uter
misalter1038343misalter
mister84728563mi__ster
monastery1444373monastery
monster93214603mon_ster
munster93710523mun_ster
nastier74115293__nastier
natter64420743__natter
nester64124183__nester
oleaster837263oleaster
painter93814563pain__ter
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
penates93321603pena_tes
pensters103012123pen_sters
pester84827593p__ester
phatter123810203p_hatter
piaffer15104443pi_affer
piastres10249303pi_astres
picante11310523picante_
picketer16187433picketer
pilsner935343pi_lsner
pinafore1344513pinafore
pinas75434453pinas___
pinata83817223pina_t_a
pinatas93711503pina_tas
pincer104019173pin__cer
pincher143812713pin_cher
pinder94523453pin__der
pinger94324093pin__ger
pinier84024693pin__ier
pinite8321243pin_ite_
pinites9319533pin_ites
pinker125322443pin__ker
pinnate93613743pinnate_
pinnated11338553pinnated
pinner84521503pin__ner
pinscher1544813pinscher
pinsetter1145013pinsetter
pipestem1443743pipestem
pirate82322883pira_te_
pirated102515613pira_ted
pirates93020333pira_tes
pisher114317753pi__sher
pisser84416383pi__sser
piste75824603pi__ste_
pistes85325633pi__stes
plaister1068013plaister
plaiter93615393p_laiter
plankter1435363plankter
planter94017803p_lanter
plasher124215033p_lasher
plasters103518133p_lasters
plastery13279703p_lastery
plater84427693p_la_ter
platter93917413p_latter
pleaser93912343pleas_er
pleater93916333plea_ter
poetaster1145673poetaster
pointer93814933poin__ter
pollster1037103pollster
poster84129173p__oster
prankster1543183prankster
prater84825353p_ra_ter
prealter1048863prealter
prester93519623p_rester
printer93917303prin__ter
privater13158533priva_ter
psalter9247813p_salter
punisher1335773punisher
punsters103310583pun_sters
punter84320023pun__ter
raster64731443__raster
remaster10311473remaster
rimester1037813rimester
ringmaster13142983ringmaster
rinser64317213rin_s_er
roaster74116663_roaster
sinter63625923sin__ter
sister64421583si__ster
songster935793songster
spinate93114813spina_te_
spinsters1136613spin_sters
spymaster1642583spymaster
taster64930573__taster
tinter63923643tin__ter
tipster9299053ti_pster
toaster74414463_toaster
vaster94521023__vaster
vinasse1044513vinasse_
vinasses1135703vinasses
waster95228943__waster
winter94222803win__ter

Search took 7 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.420425454.8
2DLD Change Limit1461621826.39322862.8
3Display Results1821820.0632888.9
 (SQL Overall)1786911826.87625987.6
 
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.