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

180 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
manmade123796(None) 
handmade1545962handmade
mammae94613222mamma_e
mammate104411272mammate
manage93818902man_age
mandate10315572mandate
mismade12129352mismade
unmade92911062_unmade
abrade9313053_abrade
alcade91111513_alcade
almude9399933_almude
amaze166016603_a_maze
amide86128493_a_mide
anadem939183_an_adem
animate91617213_animate
anlace82513923_anlace
anlage72514233_anlage
anode65021043_an_ode
ansae55720973_ansa_e
ansate64517863_ansate
antae56828293_anta_e
arcade91013643_arcade
armada938793_armada
aubade939223_aubade
ballade104012563ballade
bandage11311023bandage
bandmate1347973bandmate
canape10913523can_ape
cascade12118603cascade
chamade15138453chamade
comade114415323_comade
damage10410783da_mage
daymare1375633daymare
emanate9312473eman_ate
facade1238803fa_cade
fanfare1336673fanfare
gambade1336383gambade
ganymede1541613ganymede
hamada1239923ha_mada
hamate113319833ha_mate
hammada1545093hammada
imamate1138103ima_mate
inmate82917363_inmate
invade10157853_invade
lanate6421263lan_ate
macrame1338713macrame
madame1139853ma_dame
made75440253___made
madman113712393madma_n
maenad939413maenad_
maenades1137473maenades
maenads1037373maenads
magma104513583magma__
magmas115512513magma_s
magmata1237463magmata
magnate10512703magnate
maimed114812663maimed_
mainmast1245883mainmast
malady1237863ma_lady
malate84624563ma_late
maleate94117543maleate
maltase938903maltase
mama86231603ma_ma__
mamas95930783ma_ma_s
mamie95826003ma_m_ie
mamma86317923mamma__
mammal95112763mamma_l
mammals10389273mammals
mammary1335993mammary
mammas94616413mamma_s
mammati10398373mammati
mammee94417853ma_mmee
mammie94313783ma_mmie
mana65341963man_a__
manacle11310283manacle
managed113212603man_aged
manager103413583man_ager
manages103418963man_ages
manana84816073man_ana
manas76240433man_a_s
manat76039993man_a_t
manatee9317663manatee
manats84623463man_ats
manche133515103man_che
mandala10310213mandala
mandated12310293mandated
mandates11314093mandates
mandrake1546003mandrake
mane65052033man___e
maned86634103man_ed_
manege94113203man_ege
manga85026213manga__
mangabey1643463mangabey
mangaby1535353mangaby
mangas94122933manga_s
mange84930203man__ge
mangle93921333man_gle
mangled113615263mangled
manhandle1543753manhandle
manhole12311343manhole
mania75634153mania__
maniac103917973mania_c
maniacs114313063maniacs
manias84029033mania_s
manille92613273manille
maniple11249653maniple
manlike133012783manlike
manna75522543manna__
mannan85413623manna_n
mannans93611523mannans
mannas85019803manna_s
manned94418643manned_
mannite9312903mannite
mannose939243mannose
manpack1746063manpack
manque17259513man_que
manrope1138033manrope
mansard1049313mansard
mansarded1343993mansarded
mansards1148013mansards
manse75528233man__se
manta75629913manta__
mantas85725363manta_s
mantid93820383mantid_
mantids103113623mantids
mantle84420923man_tle
mantled104113393mantled
manual8313463manua_l
manuals9311223manuals
manuary1237773manuary
manure8313653man_ure
manured1039473manured
manward1349093manward
manwards1447613manwards
manwise1239183manwise
mapmaker1864373mapmaker
marinade11259383marinade
marmalade1443593marmalade
marmite112413993marmite
massage1039893massage
matchmade1942813matchmade
menace103216943men_ace
menad85918983men_ad_
menads95514383men_ads
menage93216543men_age
menhaden1444213menhaden
mensae84114053mensa_e
minae75627723min_a_e
mintage101110123mintage
mismake15139373mismake
mismate111415353mismate
monad85519473mon_ad_
monades103713823mon_ades
monads94515303mon_ads
monde85723143mon__de
montage101211713montage
montane91313623montane
mundane1038073mundane
palmate113215233palmate
panada94113053pan_ada
pancake1536673pancake
parade94720643pa_rade
parkade1437583parkade
passade1039233passade
pomade113611333_pomade
premade12311443premade
ramada9310183ra_mada
ramate83921693ra_mate
remade94316983_remade
saccade12107033saccade
tamale83717403ta_male
tankage12257773tankage
tannage8209583tannage
tannate71813523tannate
unlade72714153_unlade
unmake122811213_unmake
vanman1139803vanma_n
vantage11109893vantage
wannabe1234533wannabe
wantage11119623wantage

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 Filter1786911340270.410435831.7
2DLD Change Limit1340271806.29621287.6
3Display Results1801800.0603000.0
 (SQL Overall)1786911806.76626410.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.