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

73 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
macchia164589(None) 
macchie1647191macchie
bacchic1545812bacchic
bacchii1644532bacchii
acacia10311353_acacia
accidia1246993_accidia
acedia9310393_acedia
aecia73819283_aec_ia
archil11611573_archil
bacca111012183bacc__a
baccara1347143baccara
bacchius1744713bacchius
boccia12338793bocc_ia
brachia141910423brachia
branchia15217713branchia
cancha134411613canch_a
chia96026623___chia
dacha114812573da_ch_a
datcha1266563datch_a
facia103218463fa_c_ia
fascia1148703fasc_ia
ischia1136393_ischia
kachina1637663ka_china
katchina1745333katchina
lochia1158313_lochia
maccabaw1942003maccabaw
mach116134483ma_ch__
mache125925303ma_ch_e
maches134827233ma_ches
machine14313493ma_chine
macho126120153ma_ch_o
machos135217493ma_chos
machs125722563ma_ch_s
macula103013673ma_cula
macumba1573043macumba
maffia14327203ma_ffia
mafia104418033ma__fia
mahonia1238443mahonia
malaria9313693malaria
maltha1137503malth_a
manche133515103manch_e
manches143818623manches
manchet143317783manchet
mania75634153ma__nia
march125622893march__
marched153813403marched
marchen143312073marchen
marcher143912973marcher
marches143921173marches
marchesa15346883marchesa
marching164312193marching
maria75032883ma__ria
mascara1138023mascara
mashie11315933ma_shie
match125621103match__
matched153513963matched
matcher143214283matcher
matches143219783matches
matching163512393matching
matchup1643513matchup
mecca1139933mecc__a
milchig1543653milchig
mocha1249923m_och_a
mochila1446523m_ochila
morphia1447483morphia
mycelia1444843mycelia
pacha126518063pa_ch_a
rachial122012173ra_chial
rachis114017653ra_chis
raphia113511263ra_phia
vaccina1435303vaccina
vaccinia1543363vaccinia
zecchin2343703zecchin

Search took 7 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.390458182.1
2DLD Change Limit134027736.15621771.8
3Display Results73730.0332212.1
 (SQL Overall)178691736.57927160.8
 
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.