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 “maltster” 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
maltster103530(None) 
maltsters1135191maltsters
baluster1037052baluster
magister1136282magister
maltier93015482malt_ier
master84831342ma__ster
matter84325342ma_t_ter
molester1099372molester
alastor739653_alastor
alerter72111513_alerter
alter54828503_al__ter
alterer72713993_alterer
antsier7410773_antsier
artsier768943_artsier
aster55434893_a__ster
attester836503_attester
ballaster1145973ballaster
balloter1078893balloter
ballsier1036523ballsier
balusters1136633balusters
banister10199973banister
baster85333593ba__ster
batter84928873ba_t_ter
blaster94017303_blaster
blatter94415653blat_ter
blister94415313_blister
bluster94215313_bluster
bolster93713423bol_ster
cadaster1136893cadaster
calypter1544063calypter
canister101710853canister
caster85232573ca__ster
clatter94014973clat_ter
cluster94013323_cluster
clyster12317453_clyster
dabster1036703da_bster
deluster936903deluster
easter65027983ea__ster
enlister847803enlister
falser93912413fal_s_er
falter94519053fal__ter
falterer11239853falterer
faster94625773fa__ster
fatter94523213fa_t_ter
filister1137403filister
flatter103815963flat_ter
fluster103913063_fluster
gagster9317633ga_gster
gamester1137323gamester
gangster10215773gangster
ganister9178993ganister
gaster75027353ga__ster
glister84013343_glister
halter94420883hal__ter
hamster12810423ha_mster
hatter94724873ha_t_ter
holster103512213hol_ster
klister113410643_klister
lamister1037653lamister
lamster9109913la_mster
laster64830633__laster
latter65027893la_t_ter
lister64527253__lister
luster64023673__luster
magisters1235793magisters
malate84624553mal_ate_
malates93522603mal_ates
maleate94117543maleate_
maleates103316343maleates
maligner11115333maligner
malinger11116533malinger
malmier113611953mal_mier
malmsey1433623malms_ey
maltase938903maltase_
maltases1039693maltases
malted94819853mal__ted
maltose939783maltose_
maltoses1039853maltoses
maltreater12124743maltreater
malts76331753malts___
marketer1437383marketer
maser75029973ma__s_er
masher114123203ma__sher
masker124416103ma__sker
masseter1037063masseter
massier93615223ma_ssier
masted94025803ma__sted
masters94628923ma__sters
mastery124214323ma__stery
matcher143214283ma_tcher
mater74438863ma___ter
matier84321523ma_t_ier
matte75626843ma_t_te_
matted94521413ma_t_ted
matters94421753ma_t_ters
mattery123810713ma_t_tery
mattes85624533ma_t_tes
maturer938973ma_turer
meister93114163m_eister
melter83520113mel__ter
meltwater1443433meltwater
milter84921233mil__ter
miltier93214963milt_ier
minister10410363minister
minster93914323m_inster
mister84728563m__ister
mobster11299213m_obster
modester1197483modester
moister94015373m_oister
molested11178243molested
molesters1198873molesters
molter84119423mol__ter
monster93214593m_onster
muenster1043313muenster
multistep1344573multistep
munster93710523m_unster
muster84724523m__uster
mutter84418883m_ut_ter
natter64420743na_t_ter
oldster896573_oldster
palmister1345053palmister
palter84423263pal__ter
palterer102411273palterer
paltrier1037523paltrier
paster85734373pa__ster
patter84628263pa_t_ter
pilaster1038163pilaster
plaister1068013plaister
plaster93318693_plaster
platter93917413plat_ter
pollster1037103pollster
raster64731443ra__ster
ratter64326313ra_t_ter
salter64325083sal__ter
saltier74318633salt_ier
saltpeter1153163saltpeter
saltwater1244353saltwater
saluter73512453sal_uter
smaltite1046903smaltite_
smaltites1145743smaltites
smatter93613333sma_t_ter
tapster9299273ta_pster
taster64930573ta__ster
tatter64024573ta_t_ter
ulster63712103_ul_ster
vaster94521023va__ster
waister103812383wa_ister
waltzer1934383walt_zer
waster95228943wa__ster
watter93221983wa_t_ter
yatter94116213ya_t_ter

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621517.65619091.2
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.87522690.9
 
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.