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

179 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
mandrels113731(None) 
mandrel1038681mandrel_
mandrils1138491mandrils
gangrels1094972gangrels
handsels12317252handsels
langrels9106172langrels
madres93718182ma_dre_s
mandril1049352mandril_
mandrill1146612mandrill
mandrills1245452mandrills
mangels103614492man_gels
mantels94515042man_tels
manurers1037592manurers
manures9313352manure_s
mongrels1135332mongrels
spandrels1243252spandrels
address956103_address
ancress978613_ancress
andros7313303_andr_os
angels74416173_an_gels
antres65021003_antre_s
banderols1245953banderols
banders104324563band_ers
bandies104124863bandie_s
bandores11311603bandore_s
barrels94514363ba_rrels
cadres94017933ca_dre_s
cancels114113313can_cels
candela1089743cand_ela
candelas1139533cand_elas
candies104125613candie_s
candlers114214103candlers
candles104422343candle_s
cannels93413363can_nels
carrels95117303ca_rrels
danders93921183dand_ers
dandies94121443dandie_s
dandlers103912053dandlers
dandles94218533dandle_s
fardels11389893fard_els
gambrels1334213gambrels
ganders93521703gand_ers
gangrel996143gangrel_
handbell14114523handbell
handbells1594363handbells
handers114224333hand_ers
handfuls15115753handfuls
handheld1644463handheld
handhelds1743763handhelds
handlers124014143handlers
handles114020653handle_s
handless123512063handless
handpress1544033handpress
handrails1346513handrails
handsel11308723handsel_
handsets12258343handsets
hansels104011663han_sels
haverels14325753haverels
hundreds1344003hundreds
kindreds14274013kindreds
landers84026213land_ers
landlers94312833landlers
landless94011173landless
langrel8107033langrel_
laundress1042813laundress
laurels746663la_urels
machrees1545503machrees
mackerels1743083mackerels
maddens11359753ma_ddens
madders113513213ma_dders
madness10310073ma_dness
madras94316433ma_dr_as
madre85720173ma_dre__
maidens10349663maid_ens
manacles1239523manacles
managers112911003managers
manages103418963manage_s
manatees10310423manatees
manches143818623manche_s
manchets15269573manchets
mandala10310213mand_ala
mandalas1139443mandalas
mandamus1345523mandamus
mandarins12410393mandarins
mandates11314093mandates
mandible1337543mandible
mandibles1445543mandibles
mandola1039023mand_ola
mandolas1139133mandolas
mandrake1546003mandrake
mandrakes1646353mandrakes
maneges103612143manege_s
maneless102812343maneless
manes76648963man__e_s
mangel94017533man_gel_
mangers103521263man_gers
manges94628943man_ge_s
manglers113311903manglers
mangles104021463mangle_s
mangoes104316133mangoe_s
mangonels1294373mangonels
manholes13311183manholes
manilles102312603manilles
maniples12269423maniples
manless93012933man_less
mannerly1344983mannerly
manners93417833man_ners
manors84420883manor__s
manses84225513man_se_s
mantel84317973man_tel_
mantes84430783man_te_s
mantles94820703mantle_s
mantlets104611203mantlets
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantr_as
manuals9311223man_uals
manure8313653manure__
manured1039473manure_d
manurer938583manure_r
marcels113212373ma_rcels
mares76457633ma__re_s
marls75535163ma__r_ls
marrers93414313ma_rrers
marvels123810093ma_rvels
materiels1147833materiels
matres84522233ma_tre_s
mattress1036533mattress
maturely1344903maturely
maturers1037383maturers
matures9314313mature_s
maunderers1383753maunderers
maunders11348343maund_ers
maundies1137853maundie_s
mayoress1344383mayoress
meanderers1343803meanderers
meanders1168833meand_ers
meandrous1245013meandrous
menders103818803mend_ers
minarets1048843minarets
minders103720123mind_ers
mindless11319443mindless
mindsets1135683mindsets
minerals10311383minerals
minidress1243583minidress
minstrels1145693minstrels
models94216363m_od_els
mondes94322353mond_e_s
mongrel1036333mongrel_
morels84820023m__orels
padres95016983pa_dre_s
pancreas1235393pancreas
panderers12229153panderers
panders103423733pand_ers
pandies104224503pandie_s
pandores11312453pandore_s
panels84716523pan__els
pantdress1243363pantdress
parrels94713493pa_rrels
randies84225663randie_s
rondels82510053rond_els
sandals82715203sand_als
sanders84025943sand_ers
sandless93212343sandless
saurels749303sa_urels
spandrel1144063spandrel_
spandrils1244163spandrils
sundress936983sundress
tandems1037633tand_ems
tanrecs934823tan_recs
tendrils946443tendrils
undress838893_undress
vandals113211663vand_als
wadmels1334303wa_dmels
wanderers13228483wanderers
wanders114221333wand_ers
wardress12256163wardress
wastrels1136203wastrels
zanders173015793zand_ers

Search took 9 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.410435831.7
2DLD Change Limit1461621797.89018525.0
3Display Results1791790.0602983.3
 (SQL Overall)1786911798.36021374.5
 
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.