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

115 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
gouache133503(None) 
gouaches1436191gouaches
douche124613222dou_che
ganache1346202ganache
gauche1238552gau_che
louche115212662lou_che
orache114013592_orache
rouche114714312rou_che
soutache1344982soutache
touche114916172tou_che
ache96829823___ache
apache134210773_apache
attache12106693attache
bobeche1643843bobeche
boche124216953bo__che
bouchee143313543bou_chee
boucle103712783bou_cle
bounce104014833bounc_e
cache125122483__cache
coach125919453co_ach_
coached153313843co_ached
coacher143714123co_acher
coaches144018693co_aches
coracle112011723coracle
couch125320113cou_ch_
couched154115793cou_ched
coucher144515853cou_cher
couches144020473cou_ches
douce85518423dou_c_e
douched144012113dou_ched
douches134315233dou_ches
earache1239323earache
fourchee1645383fourchee
ganaches1437413ganaches
gaucher1337233gau_cher
gaucho1256223gau_cho
glace87420153g_lac_e
glunch1255353glunch_
glunched1544263glunched
glunches1436263glunches
goalie7413163go_alie
goatee73219533go_atee
goloshe1134723goloshe
gotcha1234633go_tcha
gouge78220063gou__ge
goulash1164273goulash_
goulashes1343713goulashes
gourde8107933gou_rde
grace85124543g_rac_e
grouch12318473grou_ch_
grouched15356663grou_ched
grouches14328213grou_ches
grouchy16294243grou_chy
grutch12285563grutch_
grutched15284673grutched
grutches14285853grutches
guaco85012163g_uac_o
guacos94410313g_uacos
gulch113810603g_ulch_
gulches13398103g_ulches
jounce153310733jounc_e
loach105116363lo_ach_
loaches123613983lo_aches
loathe94211383lo_athe
mache125925303__mache
mouch124715803mou_ch_
mouched153612593mou_ched
mouches143815963mou_ches
moustache1663083moustache
orach105219233_orach_
oraches124216473_oraches
oracle84313293_oracle
ouch95724633_ou_ch_
ouched124316933_ou_ched
ouches114322183_ou_ches
ounce77019933_ounc_e
ouphe104413263_ou_phe
panache1458423panache
poach124917863po_ach_
poached154212403po_ached
poacher143912323po_acher
poaches144416943po_aches
poachy16388963po_achy
pomace123111913pomac_e
potiche1438043potiche
potlache15114283potlache
pouch124617083pou_ch_
pouched153612773pou_ched
pouches144116743pou_ches
pouchy16538663pou_chy
pounce105214093pounc_e
quiche2057903_quiche
roach105717003ro_ach_
roached133211833ro_ached
roaches123616213ro_aches
rotche114311983ro_tche
rouches124217893rou_ches
ruche104216763_ru_che
solace83415823solac_e
soroche1237183soroche
source8410673sourc_e
soutaches1446443soutaches
tache106222373__tache
touch106519393tou_ch_
touched134914963tou_ched
toucher124814353tou_cher
touches125118343tou_ches
touchy145010503tou_chy
tusche1136783_tusche
vouch134611903vou_ch_
vouched163910563vou_ched
vouchee153411263vou_chee
voucher154110263vou_cher
vouches153914113vou_ches
zouave1833573zoua_ve

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 Limit1340271156.48620664.0
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.92225814.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.