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

166 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
macrame133871(None) 
macrames1438951macrames
arame75026622_a_rame
macerate122314072macerate
madame1139852ma_dame
marram10313882marram_
marrams11310122marrams
abrade9313053_abrade
acerate92818913_acerate
acme86924323_ac__me
acre67330773_acr__e
acreage1037843_acreage
acuate8315633_acuate
aerate64830553_aerate
aflame1138723_aflame
agrafe1038093_agrafe
amirate91115953amirate
arames84622573_a_rames
arcade91013643_arcade
arcane81216743_arcane
asrama839193_asrama
aurae54128113_aura_e
aurate64426473_aurate
baccae12119703bacca_e
baccate131011263baccate
barrage10710853barrage
became123213163bec_ame
becrime1387053becrime
came87648753__c_ame
carafe115416163ca_rafe
caramel11310253ca_ramel
carate84734003ca_rate
carcase11312743carcase
crake114823523__crake
cram85635493__cram_
crambe1239073__crambe
cramp115120693__cramp
crams96229153__crams
crane75331603__crane
crape96128443__crape
crate76537403__crate
crave105626313__crave
craze165221463__craze
creme94319323__creme
crime94822693__crime
emaciate1248753emaciate
enframe1247363enframe
facade1238803fac_ade
faciae112913413facia_e
frame105821803__frame
garage8314513ga_rage
karate105320923ka_rate
lacerate102214713lacerate
lactam10310943lactam_
lactams1136953lactams
lactase937963lactase
lactate9312703lactate
laurae64011663laura_e
macaber1336163mac_aber
macabre1335223macabre
macaco1247853mac_aco
macadam1446853macadam_
macadams1545093macadams
macaque2044053macaque
macaw12311763mac_a_w
macaws1337023mac_aws
macchie1647193macchie
mace87345793mac___e
macerated142010533macerated
macerater13259523macerater
macerates132113573macerates
mache125925303mac__he
machete14310883machete
machine14313493machine
machree1438513machree
mackle143716433mac_kle
macle96127003mac__le
macro94718173macr__o
macromere1545293macromere
macromole1544933macromole
macron103615673macr_on
macrons113514893macrons
macros104017013macr_os
maculae113412863maculae
maculate122815623maculate
macule104115273mac_ule
madam10316223ma_dam_
madames12310063ma_dames
madams11310943ma_dams
madras94316433madra_s
madrasa10387883madrasa
madrases112610003madrases
madre85720173madr__e
madrone102812663madrone
magnate10512703magnate
mainframe1642063mainframe
malate84624563ma_late
maleate94117543maleate
maltase938903maltase
mammae94613213mamma_e
mammate104411273mammate
manage93818903ma_nage
mandate10315573mandate
mandrake1546003mandrake
manmade1237963manmade
manrope1138033manrope
mantram114011603mantram_
mantrams12288963mantrams
mara67444573ma_ra__
maraca10314153ma_raca
maras75443293ma_ra_s
maraud938943ma_raud
marble104219103ma_rble
marcato1139743marcato
mare64759333ma_r__e
maremme1054603maremme
marge85328333ma_r_ge
margrave1444793margrave
marine84230413ma_rine
marque172410503ma_rque
marrano939423marrano
marriage1147253marriage
marse76231153ma_r_se
massage1039893massage
matrass939403matrass
maturate10312623maturate
micra96214973micra__
microbe1338663microbe
migrate101314173migrate
mirage92313653m_irage
misframe1546973misframe
misname11119483misname
misrate91319143misrate
moorage1038743moorage
morae75831193m_ora_e
morale85220553m_orale
muckrake1542763muckrake
nacre75715363nacr__e
narrate7313493narrate
package16128013package
parade94720643pa_rade
parae76335703pa_ra_e
paramo102614643pa_ramo
picrate112014143picrate
raceme1039733rac_eme
reclame11411063reclame
recrate92621663recrate
reframe1239393reframe
saccade12107033saccade
saccate111311763saccate
sacra74516993sacra__
sacral83414413sacra_l
sacrals93311793sacrals
sacrament1347943sacrament
sacrum103910143sacrum_
sacrums11388043sacrums
sarape84817573sa_rape
scram910621623_scram_
scrams105216623_scrams
scrape105917573_scrape
sucrase9310343sucrase
tacrine9311293tacrine
tarama8412733ta_rama
uncrate9415953uncrate
vacate11314553vac_ate
wakame1535433wa_kame

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 Filter1786911340270.766233278.1
2DLD Change Limit1340271667.39018136.3
3Display Results1661660.0463608.7
 (SQL Overall)1786911668.20221786.3
 
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.