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

293 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
caroches1571069(None) 
caroaches1637791caroaches
caroche1469241caroche_
carroches1665891carroches
arches114822042_ar_ches
barouches1644972barouches
caboched1844042caboched
caches137926912ca__ches
caleches15269932caleches
caliches153812262caliches
capouches1843632capouches
capuches1735512capuches
carices114220952caric_es
caroch13911762caroch__
carouses10614502carouses
cartouches17112952cartouches
catches144320772ca_tches
cloches144113712c_loches
cooches143515832c_ooches
cranches153114542cranches
cratches153012542cratches
creches14313092c_reches
crochet143616662c_rochet
crochets15359832c_rochets
crotches153411302c_rotches
crouches153711292c_rouches
curches143512742cur_ches
earaches13411302earaches
larches124416442lar_ches
marches143921172mar_ches
panoches1548122panoches
parches143720002par_ches
soroches1338802soroches
troches123715342_troches
aches106132293_a__ches
aitches123014363_aitches
apaches143411833_apaches
arched125717323_ar_ched
archer115016243_ar_cher
archers124414573_ar_chers
arouses74921293_arouses
aurochs1245983auroch_s
aurochses1444143aurochses
avouches1634823_avouches
babiches1735253babiches
baches135426943ba__ches
baronies10315023baronies
baronnes1038553baronnes
baroques1934863baroques
barouche1544173barouche_
batches144019613ba_tches
birches143412323bir_ches
boches134618523__boches
borsches1536003borsches
braches144621223_braches
branches153613803branches
brioches15227253brioches
broaches153211623_broaches
broche133612103_broche_
brooches15288193brooches
cabochon1742763cabochon
cabochons1842793cabochons
cabooses1237863cabooses
caboshed1634393caboshed
cache125122483ca__che_
cached145419203ca__ched
cachet134526413ca__chet
cachets145014263ca__chets
cacoethes1643623cacoethes
cajoles163712103cajo_les
cajones163311333cajo_nes
calashes13310533calashes
calces104420053ca_lc_es
caleche14297943caleche_
calices114321693calic_es
caliche14329953caliche_
calicles123811433calicles
calicoes123911593calicoes
calories102919553calories
calottes10610083calottes
calyces14428803calyc_es
calycles15295693calycles
canchas143212403ca_nchas
canoes84725883cano__es
canopies12311853canopies
capotes11314643capo_tes
caprices1439893capric_es
caprocks1835943caproc_ks
capuche1644433capuche_
capuched1843743capuched
caracals12310743caracals
caracks152211563carac_ks
caracoles13310073caracoles
caracols12310413caracols
caraculs1238033caraculs
carafes125015703car_afes
carates95630613car_ates
carbides133111693carbides
carbines123617533carbines
carcase11312733car_case
carcases12313083carcases
carcass11310513car_cass
carcel105018673car_c_el
carcels114516063car_cels
cardcase1345963cardcase
cardcases1446493cardcases
cares77369183car___es
caresses10314063caresses
carfares13310323carfares
cargoes104415223car_goes
caribes113715643car_ibes
caries85147623car__ies
cariocas1239663carioc_as
carioles10817073carioles
carles85435083car__les
carlines103521643carlines
carmines123617863carmines
carnages11312213carnages
carnies94123963car_nies
caroach1488863caroach__
carobs104818103caro__bs
caroled103717683caro_led
caroler93816753caro_ler
carolers103314173carolers
carolled1138823carolled
caroller1039203caroller
carollers1137703carollers
carols85124983caro__ls
carolus94612603caro_lus
caroluses1157613caroluses
caromed123713623caro_med
caroms105619573caro__ms
carotenes11410203carotenes
carotids11229943carotids
carotins102315583carotins
carouse9614423carouse_
caroused1149253caroused
carousel1057313carousel
carousels1165343carousels
carouser1068843carouser
carousers1156733carousers
carries94328013car_ries
carritches1743083carritches
carroch1437093carroch__
carses85233653car__ses
cartages11313313cartages
cartes86239473car__tes
cartouche16122563cartouche_
caruncles1345003caruncles
carves115128453car__ves
carwashes1745773carwashes
caryopses1645043caryopses
cashes114729883ca__shes
catcher143115823ca_tcher
catchers153114063ca_tchers
catechus1544823catechus
ceviches1834843ceviches
chinches18369363chinches
chromes142914933chro_mes
churches1846433churches
cinches144215773c_inches
circles1139903cir_cles
claroes93113733claro__es
clenches152910953clenches
cliches144213743c_liches
clinches153910363clinches
cloche134312373c_loche_
clothes124513813c_lothes
clutches15307923clutches
coaches144018693c_oaches
cohoshes1635883cohoshes
conches144019813c_onches
coracles121811163coracles
corniches1666673corniches
corodies11313693corodies
coshes115022783c__oshes
couches144020473c_ouches
cranched163210413cranched
crashes124618403c_rashes
craunches1655723craunches
creche13310763c_reche_
crocked164014433c_rocked
crocket154615673c_rocket
crockets16339543c_rockets
crocks145118423c_roc_ks
crocs95722433c_roc__s
crocus104813173c_roc_us
crocuses1239023c_rocuses
crones84729243c_ro_nes
cronies9622503c_ronies
crores86121163c_ro_res
crosses94220793c_rosses
crotched16428593c_rotched
crotchet152711993c_rotchet
crotchets16396303c_rotchets
crouched16359143c_rouched
croupes114613103c_roupes
croutes94815653c_routes
crozes174417663c_ro_zes
cruces105117543c_ruc_es
crunches153711353crunches
crushes124215133c_rushes
crutches15359593crutches
culches143710743c_ulches
cultches15316533cultches
curacies12311763curacies
cutches143216463c_utches
earache1239323earache_
enriches1337263enriches
farces115223323far_c_es
farcies125317883far_cies
farouche1643053farouche_
galoshes1236893galoshes
ganaches1437413ganaches
garotes8614563garo_tes
garottes978283garottes
grouches14328213_grouches
hatches153420273ha_tches
haunches1656963haunches
hooches153812523_hooches
huaraches1744993huaraches
inarches1358043inar_ches
karosses1236493karosses
kirsches1743843kirsches
laches116528343la__ches
larchen12479623lar_chen
latches123320123la_tches
launches1387903launches
lurches123311663lur_ches
maches134827233ma__ches
manches143818623ma_nches
marched153813403mar_ched
marchen143312073mar_chen
marcher143912973mar_cher
marchers153710813mar_chers
marchesa15346883mar_chesa
marchese15358913mar_chese
marchesi15337323mar_chesi
marishes13512553marishes
marshes123615373mar_shes
matches143219783ma_tches
merches144013763mer_ches
mooches143714453_mooches
naches114622413na__ches
narcoses103910543narcoses
nautches1336083nautches
oraches124216473_oraches
painches1588913painches
panaches15310283panaches
panochas1545653panochas
panoche1456383panoche_
parched154013693par_ched
parchesi15358213par_chesi
parishes13314753parishes
parodies11313693parodies
parolees104313973parolees
paroles95025883paro_les
patches143320383pa_tches
paunches1568173paunches
penoches1538933penoches
perches143717953per_ches
pooches143214163_pooches
porches143815673por_ches
ranches123620113ra_nches
ratches123620463ra_tches
raunches1368053raunches
riches115022083__riches
roaches123616213__roaches
rochet115423003__rochet
rochets124213473__rochets
rotches123515703__rotches
rouches124217893__rouches
ruches114819583__ruches
sarodes84216143saro_des
saroses73619333saro_ses
scooches15188413scooches
scorches15189143scor_ches
scratches1647323scratches
scrooches1645703scrooches
searches132112903sear_ches
smooches15217263smooches
soroche1237183soroche_
starches131912913star_ches
strophes13310603strophes
taches114224173ta__ches
tarocs84615663taroc__s
torches123715433tor_ches
tranches132915513tranches
troche113112513_troche_
trochee122613883_trochee
trochees132510183_trochees
varices123313573varic_es
watches153017373wa_tches

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.1561145455.1
2DLD Change Limit1461622937.83018666.9
3Display Results2932930.1102663.6
 (SQL Overall)1786912938.09622071.5
 
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.