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

152 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
macle9612700(None) 
mace87345781mac_e
mache125925301mache
mackle143716431mackle
macled116718111macled
macles107023221macles
macule104115271macule
maile75232211maile
male66052291ma_le
maple95521141maple
able66340532_able
ace59656832_ac_e
ache96829822_ache
acme86924322_acme
acne66625872_acne
acre67330772_acre
ale36572342_a_le
amble95924632amble
amole75724592amole
ample94720302ample
axle116424602_axle
bale66353842ba_le
cable95329912cable
cache125122482cache
cackle143416922cackle
carle74535702carle
cycle1239522cycle
dace76934922dac_e
dale55643982da_le
eagle64219482eagle
fable105824752fable
face96140122fac_e
facile112514882facile
farle86929242farle
gable85325522gable
gale56347322ga_le
hackle154916812hackle
hale76052832ha_le
haole84820082haole
kale86533752ka_le
lace66848472lac_e
ladle66320442ladle
mabe85733342ma_be
mac78053922mac__
macaw12311762macaw
maced108528692maced
macer912126942macer
maces97139962maces
mach116134472mac_h
maches134827232maches
macho126120152macho
machs125722562machs
mack125733642mac_k
mackled164111912mackled
mackles154415752mackles
macks135127602macks
macon94519952macon
macro94718172macro
macs86742502mac_s
macula103013672macula
maculae113412862maculae
maculed123510052maculed
macules114015132macules
made75440232ma_de
madly115218132madly
madre85720172madre
mae57659102ma__e
mage75739122ma_ge
maglev1237022maglev
mahoe10315572mahoe
mail65543432mail_
mailed95326752mailed
mailer84724182mailer
mailes84329112mailes
maill74420782maill
mails76037772mails
maize164618552maize
make105537882ma_ke
males75049792ma_les
mall64639362ma_ll
malled94626102malled
mallee84525592mallee
mallei84414632mallei
mallet84433052mallet
malls76233432malls
malm85129972ma_lm
malt66254802ma_lt
mamie95826002mamie
manacle11310282manacle
manche133515102manche
mane65052012ma_ne
mange84930182mange
mangle93921322mangle
manly105022942manly
manse75528222manse
mantle84420922mantle
maples104819422maples
marble104219102marble
marcel103714852marcel
mare64759322ma_re
marge85328332marge
marl66341612marl_
marled95523162marled
marls75535162marls
marly106925612marly
marse76231152marse
masse75125292masse
mate65154212ma_te
matte75626842matte
maul64830712maul_
mauled94817822mauled
mauler84416712mauler
mauls76524952mauls
mauve104013272mauve
mavie104722562mavie
maybe12311122maybe
maze155434972ma_ze
measle83513222measle
merle75824372merle
mice87442222mic_e
miche126219242miche
mickle143715132mickle
mile66352562m_ile
mille75029132mille
miracle1138842miracle
mole66251832m_ole
muckle143413582muckle
mule65236972m_ule
muscle10310972muscle
mycele1335852mycele
nacre75715362nacre
oracle84313292oracle
pace86345772pac_e
padle84522342padle
pale66055012pa_le
parle75836162parle
race66746262rac_e
rackle123917292rackle
rale45050562ra_le
sable74732162sable
sale44959702sa_le
scale74629142scale
socle7419572socle
table75429602table
tace65342512tac_e
tache106222372tache
tackle123815732tackle
tale46154162ta_le
uncle7317052uncle
vale74937342va_le
wacke145918622wacke
wale74546432wa_le

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 Filter178691538000.0931921408.6
2DLD Change Limit538001522.17024792.6
3Display Results1521520.0334606.1
 (SQL Overall)1786911522.29677827.1
 
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.