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

135 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
magisters123580(None) 
magister1136281magister_
banisters11189472banisters
canisters112310192canisters
gagsters10317082gag_sters
ganisters10248312ganisters
lamisters1157122lamisters
maltsters1135192maltsters
masters94628922ma__sters
meisters103313842m_eisters
ministers1139622ministers
misters93927512m__isters
registers1038892registers
waisters113811522wa_isters
aginners954623_aginners
agisted938203_agiste_d
agists75713173_agist__s
assisters936353assisters
asters65631603_a__sters
baiters94619303ba_i_ters
balusters1136643balusters
banishers14258053banishers
banister10199973banister_
bannisters1244323bannisters
barristers1244723barristers
basters94930303ba__sters
batistes1039713batiste_s
bisters93922613__bisters
blisters104015083_blisters
cadasters1236833cadasters
canistels11205393canistels
canister101710853canister_
cannisters1245013cannisters
casters94729903ca__sters
cloisters1137433cloisters
dabsters1137053da_bsters
demisters1249203demisters
digesters11257883digesters
dragsters1134333drag_sters
easters75125683ea__sters
enlisters937113enlisters
fagoters1234863fag_oters
fainters11349693fa_inters
filisters1237003filisters
gagster9317633gag_ster_
gaiters83516543ga_i_ters
gamesters1236733gamesters
gangsters11205733gangsters
ganister9178993ganister_
gannisters1153843gannisters
gasters85624293__gasters
glisters93912603_glisters
gristers94013403_gristers
hamsters13710423ha_msters
heisters113413133_heisters
hoisters113513483_hoisters
imaginers1243693imagi_ners
imagists1175113imagist__s
insisters997653insisters
kaisers11369273ka_is_ers
keisters123212043_keisters
klisters123910483_klisters
lamister1037653lamister_
lamsters1099753la_msters
lasters75627693la__sters
lavishers1564643lavishers
leisters83312823_leisters
listers74026533__listers
magisterial1452743magisterial
magisterium1652263magisterium
magisteriums1751463magisteriums
magistral1243623magistral
magnates11511613magnate_s
magnifiers1643813magnifiers
mailers94420333ma_i_lers
maimers113813043ma_i_mers
maists85817573ma_ist__s
maligners12104783maligners
malingers1285853malingers
maltster1035303maltster_
manifesters1652753manifesters
mariners103113863mari_ners
marishes13512553marishe_s
marketers1545983marketers
masers84623453ma__s_ers
mashers124621053ma__shers
maskers133913843ma__skers
masseters1136283masseters
master84831343ma__ster_
mastery124214323ma__stery
maters85032393ma___ters
matters94421753ma__tters
mavises122812993mavis_e_s
megastars1243653megastars
meister93114163m_eister_
meristems1343553meristems
milters93619093m__ilters
minister10410363minister_
minsters103813923m_insters
minters93822473m__inters
misers85025703m__is_ers
misinters1138183misinters
mister84728563m__ister_
misterm114314513m__isterm
misterms123711353m__isterms
miters84328783m__i_ters
mobsters12359063m_obsters
modistes1138643modiste_s
moistens10268773m_oistens
moister94015373m_oister_
molesters1198873molesters
monsters103314553m_onsters
muensters1143253muensters
munsters104010553m_unsters
musters94522513m__usters
painters103013023pa_inters
palmisters1444673palmisters
pasters94531733pa__sters
pavisers13387443pavis_ers
plaisters1137813plaisters
raisers73617393ra_is_ers
rasters74629023ra__sters
ravishers1564783ravishers
register939553register_
resisters9310453resisters
roisters83615553_roisters
sisters73721593__sisters
tapsters10318803ta_psters
tasters74225643ta__sters
twisters11268173_twisters
vanishers15186613vanishers
varistors1246533varistors
waister103812383wa_ister_
waiters104218623wa_i_ters
wasters104026593wa__sters

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.423422437.4
2DLD Change Limit1486411356.53322752.3
3Display Results1351350.0602250.0
 (SQL Overall)1786911357.01625469.1
 
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.