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

153 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
capuches173551(None) 
capouches1843631capouches
capuche1644431capuche_
capuched1843741capuched
apaches143411842_apaches
caches137926912ca__ches
caleches15269942caleches
caliches153812272caliches
capuchin1743672capuchin
capuchins1843372capuchins
caroches15710692caroches
catches144320772ca_tches
couches144020472c_ouches
crouches153711292crouches
aches106132293_a__ches
aitches123014363_aitches
apache134210783_apache_
apices104916263_apic_es
arches114822043_a_rches
avouches1634823avouches
babiches1735253babiches
baches135426943ba__ches
barouches1644973barouches
batches144019613ba_tches
caboched1844043caboched
cache125122483ca__che_
cached145419203ca__ched
cachet134526413ca__chet
cachets145014263ca__chets
cachuchas1851783cachuchas
caducei1243873caduc_ei
caduceus1342573caduceus
caducous1344383caducous
calashes13310543calashes
calces104420053ca_lc_es
caleche14297953caleche_
calices114321693calic_es
caliche14329963caliche_
calicles123811433calicles
calicoes123911603calicoes
calyces14428803calyc_es
calycles15295693calycles
campuses1437773campu_ses
canchas143212403ca_nchas
capes95441923cap___es
caphs124515373cap__h_s
capiases1239253capiases
capizes20410373cap_izes
capotes11314643cap_otes
capouch1644413capouch__
caprices1439893caprices
capsizes2147203capsizes
capsules1236623capsules
captives1538623captives
captures1239443captures
carices114220953caric_es
caroaches1637793caroaches
caroche1469243caroche_
carroches1665893carroches
cartouches17112963cartouches
caruncles1345003caruncles
cashes114729883ca__shes
catcher143115823ca_tcher
catchers153114063ca_tchers
catechus1544823catechus
caucus1039613ca_uc_us
caucuses1236783ca_ucuses
caudles103912813ca_udles
caules85927253ca_u_les
causes88026473ca_u_ses
cayuses12188403cayu_ses
ceviches1834843ceviches
chinches18369363chinches
choushes1637623choushes
churches1846433churches
cinches144215773c_inches
clenches152910953clenches
cliches144213743c_liches
clinches153910363clinches
cloches144113713c_loches
clutches15307923clutches
coaches144018693c_oaches
conches144019813c_onches
cooches143515833c_ooches
couched154115793c_ouched
coucher144515853c_oucher
couchers153513863c_ouchers
cranches153114543cranches
cratches153012543cratches
craunches1655723craunches
creches14313093c_reches
crotches153411303crotches
crouched16359143crouched
cruces105117543c_ruc_es
crunches153711353crunches
crushes124215133c_rushes
crutches15359593crutches
culches143710743c_ulches
cultches15316533cultches
cupules113210263cupu_les
curches143512743c_urches
cutches143216463c_utches
douches134315233_douches
earaches13411313earaches
fauces114916153fa_uc_es
ganaches1437433ganaches
gauche1238563ga_uche_
gaucher1337243ga_ucher
gauchest1436293ga_uchest
gauchos1345903ga_uchos
grouches14328213grouches
hatches153420273ha_tches
haunches1656963haunches
laches116528353la__ches
larches124416453la_rches
latches123320133la_tches
launches1387903launches
maches134827233ma__ches
manches143818623ma_nches
marches143921173ma_rches
matches143219783ma_tches
mouches143815963_mouches
muches134718993__muches
naches114622413na__ches
nautches1336083nautches
ouches114322183__ouches
painches1588913painches
panaches15310293panaches
panoches1548123panoches
papacies1439483papacies
papules112411573papu_les
parches143720003pa_rches
patches143320383pa_tches
paunches1568173paunches
penuches1536943penuches
pouches144116743_pouches
puces94924633__puc_es
punches144816133__punches
pushes114621663__pushes
ranches123620113ra_nches
raphes115117453rap__hes
ratches123620463ra_tches
raunches1368053raunches
rouches124217893_rouches
ruches114819583__ruches
sauces84919503sa_uc_es
sauchs115112233sa_uch_s
slouches13208073slouches
taches114224173ta__ches
touches125118343_touches
vouches153914113_vouches
watches153017373wa_tches
wauchts15285283wa_uchts

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.420425454.8
2DLD Change Limit1461621537.54619369.5
3Display Results1531530.0632428.6
 (SQL Overall)1786911538.02922255.7
 
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.