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

147 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
machree143851(None) 
machrees1545501machrees
mache125925302mach__e
maches134827232mach_es
machete14310882machete
machine14313492machine
accrete1137843_accrete
accrue1035823_accrue
ache96829823_ach__e
ached119227833_ach_ed
achene11313813_achene
aches106132293_ach_es
achier113914263_achier
achieve1545023_achieve
ackee115825363_ac_kee
acre67330773_ac_r_e
acred87126353_ac_red
acres76327763_ac_res
adhere10310333_adhere
agree65226033_a_gree
bached145519893bach_ed
baches135426943bach_es
cache125122483cach__e
cached145419203cach_ed
caches137926913cach_es
cachet134526413cach_et
cicoree1149843cicoree
decree93117783dec_ree
euchre11137663euchr_e
euchred13106163euchred
euchres1288663euchres
hachure1545723hachure
hachured1744393hachured
hachures1645873hachures
hackee154921833hac_kee
laches116528343lach_es
laree56036293la__ree
lichee114017973lich_ee
lychee143710893lych_ee
macaber1336163macaber
macabre1335223macabre
macaque2044053macaque
macchie1647193macchie
mace87345783mac___e
maced108528693mac__ed
macer912126943mac__er
macerate122314073macerate
macers105321273macer_s
maces97139963mac__es
mach116134473mach___
machetes1539633machetes
machined1637303machined
machines15312883machines
macho126120153mach__o
machos135217493mach_os
machs125722563mach__s
machzor2344263machzor
mackerel1644863mackerel
mackle143716433mac_kle
mackled164111913mackled
mackles154415753mackles
macle96127003mac__le
macled116718113mac_led
macles107023223mac_les
macrame1338713macrame
macro94718173mac_r_o
macron103615673mac_ron
macros104017013mac_ros
maculae113412863maculae
macule104115273mac_ule
maculed123510053maculed
macules114015133macules
madre85720173ma_dr_e
madres93718183ma_dres
mahoe10315573ma_h_oe
mahoes11313103ma_hoes
maigre9309163maigr_e
maihem1366213maih_em
majored1735853majored
malgre9299303malgr_e
mallee84525593ma_llee
mammee94417853ma_mmee
manatee9317663manatee
manche133515103manch__e
manches143818623manch_es
manchet143317773manch_et
mandrel1038683mandrel
manhole12311343manhole
manure8313653manur_e
manured1039473manured
manurer938583manurer
manures9313353manures
marched153813403march_ed
marchen143312073march_en
marcher143912973march_er
marchers153710813marchers
marches143921173march_es
marchese15358913marchese
mare64759323ma__r_e
mares76457633ma__res
marge85328333ma__rge
marquee18218583marquee
marred95421043ma_rred
marrer83716673ma_rrer
marse76231153ma__rse
mashed125325043mash_ed
masher114123203mash_er
mashers124621053mashers
mashes115030003mash_es
mashie11315933mash_ie
mashies12318253mashies
matched153513963match_ed
matcher143214283match_er
matchers153012433matchers
matches143219783match_es
matinee92415613matinee
matres84522233ma_tres
mature8313463matur_e
matured10310033matured
maturer938973maturer
matures9314303matures
maugre9308973maugr_e
mayhem1644923mayh_em
miche126219243mich__e
miched143913393mich_ed
miches134320733mich_es
muches134718993much_es
naches114622413nach_es
nacre75715363nac_r_e
nacred95212493nac_red
nacres85614453nac_res
ochre103411593_ochr_e
ochrea11316643_ochrea
ochreae12295083_ochreae
ochred12328003_ochred
ochres113510833_ochres
rachet115028973rach_et
sachem134012223sach_em
sachet114725773sach_et
sacred94917103sac_red
saree55044663sa__ree
scree720031703_sc_ree
tache106222373tach__e
taches114224173tach_es
three87526913__three
yachted1634853yachted
yachter1534913yachter

Search took 8 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.1731032896.0
2DLD Change Limit1340271477.14018771.3
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.37624226.0
 
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.