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

129 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
malanders123702(None) 
balancers1345062balancers
bilanders1235962bilanders
calenders1237402calenders
colanders1238012colanders
glanders103811512_glanders
inlanders1036142inlanders
islanders1035282islanders
landers84026222__landers
mainlanders1462502mainlanders
malingers1285852malingers
marauders1244262marauders
maunders11348352ma_unders
meanders1168832m_eanders
slanders94014022_slanders
solanders1036962solanders
uplanders1234862uplanders
alands75418373_aland__s
alders74218423_al__ders
alexanders1842443_alexanders
aliners74717723_alin_ers
almners9399563_almn_ers
amenders11288353_amenders
auslanders1143363auslanders
awarders1245073_awarders
balancer1246603balancer_
balances1279973balance_s
banders104324563__banders
bilander1136673bilander_
bladders12397803_bladders
bladers104214683_bla_ders
blander103715173_blander_
blenders115211003_blenders
blinders113911153_blinders
blunders113911353_blunders
branders114313093_branders
calamanders1662913calamanders
calendars1244523calendars
calender1138273calender_
clangers114312343_clangers
colander1139033colander_
cylinders1543203cylinders
danders93921183__danders
daunders10278483da_unders
demanders13247573demanders
expanders19125093expanders
flangers123311373_flangers
flankers15349303_flankers
flatlanders1551983flatlanders
flinders12439273_flinders
ganders93521703__ganders
glancers11408003_glancers
glandes95413833_glande_s
handers114224333__handers
hazarders2243023hazarders
implanters1484153implanters
inlander937223inlander_
islander946103islander_
japanners1842813japanners
ladders94115173__ladders
laders74927763__la_ders
lancers93616643__lancers
lander74028493__lander_
landlers94312833__landlers
lanners73618333__lanners
larders83516943__larders
lauders84012893__lauders
launders9358753la_unders
lavenders1334753lavenders
lenders84419653__lenders
lowlanders1442693lowlanders
madders113513213m__adders
maenades1137473maenade_s
mainlander1352973mainlander_
maladies11311933mala_dies
malaises10312333malaise_s
malangas1136863malan_gas
malapert1249793mala_pert
malaperts1344053mala_perts
malarkeys1841963malarkeys
malars85020683mala___rs
malates93522613mala_te_s
maleness10312313malen_ess
maligners12104783maligners
malines93625623malin_e_s
malinger11116543malinger_
malodors1144973mal_odors
maltsters1135193maltsters
managers112911003mana_gers
mangers103521263m__angers
manners93417833m__anners
marauder1144553marauder_
mariners103113883marin_ers
matadors1156983mata_dors
maunder10328693ma_under_
meander1049973m_eander_
meaners94415243m_ean_ers
melanges1138613melange_s
melders103213913mel__ders
menders103818803m__enders
minders103720123m__inders
moaners92813553m_oan_ers
molders103315553mol__ders
oleanders1035573oleanders
outlanders1144273outlanders
palavers1337993pala_vers
panders103423743__panders
paraders113113123para_ders
phalangers1673763phalangers
philanders1644273philanders
planers94517953_plan_ers
planners10399943_planners
planters102915333_planters
plunders11329843_plunders
pomanders1436223pomanders
relaunders1153103relaunders
salamanders1462203salamanders
sanders84025943__sanders
slander84015453_slander_
solander948123solander_
squanders1934443squanders
standers93514303_standers
stranders10389943stranders
tailenders1143643tailenders
uitlanders1142833uitlanders
uplander1145543uplander_
valances1398763valance_s
wanders114221333__wanders
zanders173015793__zanders

Search took 10 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.470380193.6
2DLD Change Limit1486411298.94016626.5
3Display Results1291290.0462804.3
 (SQL Overall)1786911299.45618897.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.