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 “marplot” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
marplot114967(None) 
marplots1245631marplots
harlot94422802har_lot
maillot9312172maillot
marmot10318742mar_mot
martlet93419152martlet
matelot9411572matelot
merlot83217602mer_lot
allot54933873_a_llot
applet105917433_applet
argot67728653_ar_got
armlet84118193_armlet
arpent84822093_arpent
ballot84624093ba_llot
barlow112911423bar_low
brulot8912213_brulot
caplet104226813ca_plet
carpet104530093carp_et
carpool1139223carpool
carport11316033carport
carrot8423123car_rot
complot13310683complot
coplot10518273_coplot
drylot1037403_drylot
earplug1042853earplug
earshot10410823earshot
hallot95426783ha_llot
haplont12412563ha_plont
haricot12311963haricot
harlots103413293har_lots
harpist12312353harpist
harpoon1238313harpoon
harslet10315653harslet
magalog1144913magalog
maggot10311713ma_ggot
magot8326393ma__got
maillots1037473maillots
mallet84433053ma_llet
mallow114014743ma_llow
maloti8313213ma__loti
malt66254813ma__l_t
manihot121112053manihot
mantlet93620993mantlet
maple95521143ma_pl_e
maples104819423ma_ples
marabou1147493marabou
marabout1249103marabout
marble104219103marbl_e
marbled123212113marbled
marbler113511673marbler
marbles114516653marbles
marbly134111933marbl_y
marcato1139743marcato
margent10316693margent
market123226043mar_ket
markhor1635463markhor
marl66341623mar_l__
marled95523163mar_led
marlin84220903mar_lin
marlite92917073mar_lite
marls75535163mar_l_s
marly106925613mar_l_y
marmots11311513mar_mots
maroon83118203mar_oon
marron83717543mar_ron
marrow112812603mar_row
mart66865983mar___t
martlets103310483martlets
mascot104016073ma_scot
matelote1047603matelote
matelots1047533matelots
matzot17710983ma_tzot
maypole1446383maypole
maypop1565143mayp_op
melilot9311083melilot
merlon83012353mer_lon
merlots92710123mer_lots
morpho13158443morpho_
morphos14159083morphos
outplot9109483outplot
overplot1338543overplot
parlor8312673par_lor
parrot8320663par_rot
partlet92720363partlet
plot66141233___plot
replot83818593_replot
sandlot8311693sandlot
subplot1158133subplot
taproot9412673taproot
tarot55943933tar__ot
tarpon82812803tarp_on
tartlet72218483tartlet
varlet9423503var_let

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 Filter1786911340270.403443402.0
2DLD Change Limit134027936.56320421.6
3Display Results93930.0332818.2
 (SQL Overall)178691936.99925530.9
 
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.