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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
machrees154550(None) 
machree1438511machree_
maches134827232mach__es
machetes1539632machetes
machines15312892machines
accretes1238113_accretes
accrues1135323_accrues
achenes12313493_achenes
aches106132293_ach__es
achieves1645523_achieves
ackees124914583_ac_kees
acres76327763_ac_r_es
actress948533_actress
adheres11310163_adheres
agrees74915323_a_grees
baches135426943bach__es
caches137926913cach__es
cachets145014263cach_ets
cicorees1246413cicorees
decrees102513123dec_rees
euchres1288663euchr_es
hachures1645873hachures
hackees165014103hac_kees
laches116528343lach__es
larees65323113la__rees
lichees123512783lich_ees
lychees15516783lych_ees
macaques2143953macaques
macerates132113573macerates
macers105321273mac__ers
maces97139963mac___es
mache125925303mach__e_
machete14310883mach_ete
machine14313493machine_
machined1637303machined
machos135217493mach__os
machs125722563mach___s
machzors2444113machzors
mackerel1644863mackerel
mackerels1743083mackerels
mackles154415753mac_kles
macles107023223mac__les
macrames1438953macrames
macrons113514893mac_rons
macros104017013mac_r_os
macules114015133mac_ules
madres93718183ma_dr_es
mahoes11313103ma_h_oes
maihems1444303maih_ems
mallees93315973ma_llees
mammees104411143ma_mmees
manatees10310423manatees
manches143818623manch__es
manchets15269573manch_ets
mandrels1137313mandrels
manholes13311183manholes
manurers1037593manurers
manures9313353manur_es
marchers153710813march_ers
marches143921173march__es
marchese15358913march_ese
mares76457633ma__r_es
marges94525713ma__rges
marquees19206243marquees
marrers93414313ma_rrers
marries93825283ma_rries
marses84827113ma__rses
mashers124621053mash_ers
mashes115030003mash__es
mashies12318253mash_ies
matchers153012433match_ers
matches143219783match__es
matchless1644683matchless
matinees102110423matinees
matres84522233ma_tr_es
mattress1036533mattress
maturers1037373maturers
matures9314303matur_es
mayhems1763413mayh_ems
mayoress1344383mayoress
miches134320733mich__es
muches134718993much__es
muchness1534073muchness
naches114622413nach__es
nacres85614453nac_r_es
ochres113510833_ochr_es
rachets124516833rach_ets
rachides141511223rachides
rachises131412413rachises
sachems14348903sach_ems
sachets123914103sach_ets
sarees65329943sa__rees
screes85023973_sc_rees
taches114224173tach__es
threes97117323__threes
yachters1633883yachters

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.423422437.4
2DLD Change Limit146162968.04618165.8
3Display Results96960.0303200.0
 (SQL Overall)178691968.49921024.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.