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

150 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
macrames143895(None) 
macrame1338711macrame_
arames84622572_a_rames
macerates132113572macerates
madames12310062ma_dames
madrases112610002madrases
marrams11310122marram_s
abrades10312073_abrades
acmes96020653_ac__mes
acreages1138373_acreages
acres76327763_acr__es
aerates74627493_aerates
agrafes1137523_agrafes
amirates101114793amirates
arame75026623_a_rame_
arcades101113193_arcades
arrases71214543_arrases
asramas938303_asramas
barrages11711083barrages
becrimes1467073becrimes
cames97047313__c_ames
carafes125015703ca_rafes
caramel11310253ca_ramel
caramels1238803ca_ramels
carates95630613ca_rates
carcases12313083carcases
crakes124921813__crakes
crambes1339963__crambes
cramps125615563__cramps
crams96229153__cram_s
cranes84330753__cranes
crapes104727693__crapes
crases85532313__crases
crates85736063__crates
craves115825393__craves
crazes174720133__crazes
cremes104517993__cremes
crimes105521583__crimes
emaciates1347883emaciates
enframes1357453enframes
facades1339033fac_ades
frames115119863__frames
garages9314113ga_rages
jacales16310323jac_ales
karates115617473ka_rates
lacerates112413773lacerates
lactams1136953lactam_s
lactases1038513lactases
lactates10311223lactates
macaber1336163mac_aber
macacos1338083mac_acos
macadams1545093macadam_s
macaques2143953macaques
macaws1337023mac_a_ws
macerate122314073macerate_
macerated142010523macerated
macerater13259523macerater
maceraters14226633maceraters
maces97139963mac___es
maches134827233mac__hes
machetes1539633machetes
machines15312893machines
machrees1545503machrees
mackles154415753mac_kles
macles107023223mac__les
macromere1545293macromere
macromeres1645753macromeres
macromoles1645373macromoles
macrons113514893macr_ons
macros104017013macr__os
maculates132013723maculates
macules114015133mac_ules
madame1139853ma_dame_
madams11310943ma_dam_s
madras94316433madra__s
madrasas11317763madrasas
madres93718183madr__es
madrones112912283madrones
maenades1137473maenades
magnates11511613magnates
mainframes1752333mainframes
malates93522603ma_lates
maleates103316343maleates
maltases1039693maltases
manages103418963ma_nages
mandamus1345523mandamus
mandates11314093mandates
mandrakes1646353mandrakes
manropes1237913manropes
mantrams12288963mantram_s
maracas11313773ma_racas
maras75443293ma_ra__s
marasmus1244473ma_rasmus
marauds1037553ma_rauds
marbles114516653ma_rbles
marcatos1249163marcatos
marches143921173ma_rches
mares76457633ma_r__es
marges94525713ma_r_ges
margraves1544833margraves
marines93928013ma_rines
marques182610863ma_rques
marram10313883marram__
marranos1038423marranos
marriages1247383marriages
marries93825283ma_rries
marses84827113ma_r_ses
marshes123615373ma_rshes
massages1159883massages
matrass939403matra_ss
matrasses1157293matrasses
matres84522233matr__es
matrices12312083matrices
matrixes1738063matrixes
maturates11311763maturates
mesdames1346043mesdames
microbes1439403microbes
migrates111112853migrates
mirages102213533m_irages
misframes1646633misframes
misnames12119883misnames
misrates101318243misrates
moorages1139053moorages
morales93619403m_orales
muckrakes1642743muckrakes
mucrones1237603mucrones
nacres85614453nacr__es
narrates8312763narrates
packages17138733packages
parades104121463pa_rades
paramos113213513pa_ramos
picrates122013213picrates
racemes1139093rac_emes
reclames12310893reclames
recrates102420373recrates
reframes1338993reframes
saccades13137253saccades
sacrals93311793sacra_ls
sacrament1347943sacrament
sacraments1445853sacraments
sacrums11388043sacrum_s
sarapes94617743sa_rapes
scrams105216623_scram_s
scrapes116217663_scrapes
sucrases10310253sucrases
tacrines10310563tacrines
taramas9612703ta_ramas
uncrates10314563uncrates
vacates12312833vac_ates
wakames1635283wa_kames

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.436409841.7
2DLD Change Limit1461621507.69019006.8
3Display Results1501500.0602500.0
 (SQL Overall)1786911508.18621828.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.