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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

163 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
macles10702322(None) 
maces97139961mac_es
maches134827231maches
mackles154415751mackles
macle96127001macle_
macled116718111macled
macules114015131macules
mailes84329111mailes
males75049791ma_les
maples104819421maples
ables75935542_ables
aces67645092_ac_es
aches106132292_aches
acmes96020652_acmes
acnes75922622_acnes
acres76327762_acres
ales47067102_a_les
ambles105121852ambles
amoles84122192amoles
arles56735742_arles
axles125219472_axles
baches135426942baches
bales76250082ba_les
cables104527552cables
caches137926912caches
cackles153717202cackles
calces104420052calces
carles85435082carles
caules85927252caules
cycles1339302cycles
daces85030682dac_es
dales66439742da_les
dalles74222062dalles
eagles73819162eagles
fables114921672fables
faces106439432fac_es
facies113921592facies
falces115216002falces
farles96025782farles
gables94222332gables
gales65442482ga_les
hackles162917062hackles
hales85449842ha_les
haoles94919802haoles
jacales16310322jacales
kales95730982ka_les
kayles134712002kayles
laces76141762lac_es
laches116528342laches
ladles74619542ladles
mabes96331532ma_bes
macaws1337022macaws
mace87345782mac_e_
maced108528692mac_ed
macer912126942mac_er
macers105321272macers
mache125925302mache_
machos135217492machos
machs125722562mac_hs
mackle143716432mackle_
mackled164111912mackled
macks135127602mac_ks
macons104017242macons
macros104017012macros
macs86742502mac__s
maculas113114012maculas
macule104115272macule_
maculed123510052maculed
madres93718182madres
maes66948392ma__es
mages85036022ma_ges
maglev1237022maglev
maglevs1334692maglevs
mahoes11313102mahoes
maile75232212maile_
mailed95326752mailed
mailer84724182mailer
mailers94420332mailers
maills84215282maills
mails76037772mail_s
maizes175115732maizes
makes115336852ma_kes
male66052292ma_le_
malled94626102malled
mallee84525592mallee
mallees93315972mallees
mallei84414632mallei
mallet84433052mallet
mallets93318492mallets
malleus92911312malleus
malls76233432ma_lls
malms95021552ma_lms
malts76331752ma_lts
mamies104626242mamies
manacles1239522manacles
manches143818622manches
manes76648952ma_nes
manges94628942manges
mangles104021462mangles
manless93012932manless
manses84225512manses
mantes84430782mantes
mantles94820702mantles
maple95521142maple_
marbles114516652marbles
marcels113212372marcels
marches143921172marches
mares76457632ma_res
marges94525712marges
marled95523162marled
marls75535162marl_s
marses84827112marses
mashes115030002mashes
masses85028712masses
matches143219782matches
mates75251362ma_tes
matless93014042matless
matres84522232matres
mattes85624532mattes
mauled94817822mauled
mauler84416712mauler
maulers94213302maulers
mauls76524952maul_s
mauves113811552mauves
mavies114923192mavies
maxes145629532ma_xes
maybes1339242maybes
mazes165632172ma_zes
measles92412752measles
merles85322762merles
miches134320732miches
mickles153415002mickles
miles74645072m_iles
milles84526562milles
miracles1238332miracles
moles74747922m_oles
muches134718992muches
muckles153413252muckles
mules75034292m_ules
muscles11310562muscles
myceles1435212myceles
naches114622412naches
nacres85614452nacres
oracles93212422oracles
paces96741112pac_es
padles95221112padles
pales75753802pa_les
parles86334392parles
races74943242rac_es
rales54947492ra_les
sables85026692sables
sales56055592sa_les
scales84529312scales
socles8418452socles
tables84524882tables
taces76237802tac_es
taches114224172taches
tackles133816522tackles
tales55451372ta_les
uncles8317162uncles
vales85434262va_les
wackes154717712wackes
wales86142832wa_les

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511632.61031628.7
3Display Results1631630.0463543.5
 (SQL Overall)1786911632.76664602.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.