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

103 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
ganache134622(None) 
ganaches1437431ganaches
panache1458431panache
apache134210782_apache
earache1239332earache
gauche1238562ga_uche
gouache1335042gouache
manacle11310282manacle
manche133515102man_che
panaches15310292panaches
panoche1456382panoche
ache96829823___ache
agnate73314883agna_te
ananke1038283_ananke
anarch11310393_anarch_
anarchs1237093_anarchs
anarchy1544933_anarchy
ancho104515303_an_cho
anlace82513923_anlac_e
apace94718383_apac_e
apaches143411843_apaches
attache12106693attache
babiche1644573babiche
backache21126063backache
barnacle1245943barnacle
cache125122483__cache
caleche14297953caleche
caliche14329963caliche
canape10913513cana_pe
cancha134411613can_cha
capuche1644433capuche
caroche1469243caroche
cenacle1139123cenacle
dance85223133dan_c_e
earaches13411313earaches
gainable1138933gainable
galah95917643gala_h_
galahs105512683gala_hs
galoshe1135413galoshe
gamashes1456953gamashes
gane55145303gan___e
gangue81310573gan_gue
ganjah17145503ganjah_
ganjahs18104003ganjahs
garage8314513gara_ge
gaucher1337243ga_ucher
gaucho1256223ga_ucho
gavage1137193gava_ge
gazpacho2551263gazpacho
glace87420163g_lac_e
glance94312313glan_c_e
gnash9449833g_nash_
gnashed12317523g_nashed
gnashes11419573g_nashes
gouaches1436203gouaches
grace85124543g_rac_e
guanaco1064583guanac_o
guanacos1163813guanacos
guanase836213guana_se
gynarchy2042103gynarchy
halacha15388023halacha
hance105424153han_c_e
headache1744703headache
huarache1644313huarache
lanate6421263lana_te
lance75126723lan_c_e
mache125925303__mache
manacled1336453manacled
manacles1239523manacles
manage93818903mana_ge
manatee9317663manatee
manches143818623man_ches
manchet143317783man_chet
menace103216943menac_e
menarche1545813menarche
naches114622413__naches
nacho105414383__nacho
nacre75715363__nacre
nance74721843nan_c_e
niche105016793__niche
orache114013593_orache
palace104516923palac_e
panacea1137793panacea
pancake1536673pancake
panicle11129983panicle
panocha1444983panocha
panoches1548123panoches
penoche1447043penoche
penuche1435943penuche
planche14299753plan_che
rance75028513ran_c_e
ranch105019793ran_ch_
ranched133113603ran_ched
rancher123013633ran_cher
ranches123620113ran_ches
rancho114310853ran_cho
sanicle91210263sanicle
shanachie1743533shanachie
snathe94415113_snathe
tache106222373__tache
takahe1335793taka_he
tenace82715693tenac_e
tranche123312223tran_che

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.436409841.7
2DLD Change Limit1340271037.08018930.4
3Display Results1031030.0303433.3
 (SQL Overall)1786911037.54623680.2
 
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.