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

185 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
churches184643(None) 
churched1934651churched
curches143512741c_urches
chinches18369372chinches
church1636482church__
churchier1944152churchier
churchiest2044052churchiest
churchless20112492churchless
churchly2142972churchly
churchmen2142922churchmen
churchy2044182church_y
clutches15307922clutches
couches144020472cou_ches
crunches153711352crunches
crutches15359592crutches
culches143710742c_ulches
cutches143216462c_utches
hunches153913462_hunches
hutches153613522_hutches
lurches123311662_lurches
unchurches2052382unchurches
arches114822043__arches
birches143412323_birches
brunches153710453brunches
bunches144116033_bunches
butches144315363_butches
caches137926913c__aches
caleches15269943caleches
caliches153812273caliches
capuches1735513capuches
caroches15710693caroches
carroches1665893carroches
catches144320773c_atches
ceviches1834843ceviches
chances145218093chanc_es
chancres15429363chancres
charades141310853charades
charases131312763charases
chares115631803char__es
charges134615983char_ges
charkhas20285023charkhas
charlies133414233charlies
chatchkes23174743chatchkes
cherishes1767563cherishes
cherries131812993cherries
chichis1737073ch_ichis
chicles143512503ch_icles
chirres123812253chir_res
choices142010613choic_es
chorales133712883chorales
chores114828023chor__es
chorines132917253chorines
chortles133611323chortles
choruses1339983choruses
choushes1637623choushes
chromes142914933ch_romes
chucked19469733chu_cked
chuckies1937703chuckies
chuckles1936803chuckles
chucks174812933chu_c_ks
churchgoer2151703churchgoer
churchgoers2251553churchgoers
churching2055083churching
churchings2162553churchings
churchlier2052263churchlier
churchliest2152363churchliest
churchman2153003churchman
churls115411073chur__ls
churned13358373chur_ned
churner12298343chur_ner
churners13316893churners
churns114910233chur__ns
churred13409173chur_red
churros12427583chur_ros
churrs115111513chur__rs
chutes114615773chu__tes
chutnees1343963chutnees
cinches144215773c_inches
circles1139903c_ircles
clenches152910953clenches
cliches144213743c_liches
clinches153910363clinches
cloches144113713c_loches
clutched16356033clutched
coaches144018693c_oaches
coerces11311943coerc_es
conches144019813c_onches
cooches143515833c_ooches
couched154115793cou_ched
coucher144515853cou_cher
couchers153513863cou_chers
courages11311393courages
courses94218893cour_ses
cranches153114543cranches
cratches153012543cratches
craunches1655723craunches
creches14313093c_reches
crotches153411303crotches
crouches153711293crouches
cruces105117543cru_c_es
crunched16328163crunched
cruncher15338073cruncher
crunchers16316243crunchers
crushes124215133cru_shes
crutched16307463crutched
cuishes122810823c_uishes
cultches15316533cultches
curacies12311763c_uracies
curares94916853c_urares
curates95323833c_urates
curch124415413c_urch__
curdles103814573c_urdles
cures75645433c_ur__es
curies84934023c_ur_ies
curites93919863c_urites
curries93723163c_urries
curses85328273c_ur_ses
curves114619283c_ur_ves
dhurries1255583dhurries
douches134315233dou_ches
dunches133312583_dunches
fourchee1645383fourchee
glunches1436263glunches
gouaches1436203gouaches
grutches14285853grutches
gulches13398113_gulches
gurshes112210033_gurshes
hatches153420273_hatches
haunches1656963haunches
hitches153616273_hitches
hooches153812523_hooches
hotches153814363_hotches
huaraches1744993_huaraches
hunched163710493_hunched
hurdies114015663_hurdies
hurdles113613373_hurdles
hurlies103315333_hurlies
hurries103919653_hurries
hurtles103913753_hurtles
hushes124718593_hu_shes
hutched16359883_hutched
inarches1358043inarches
larches124416453_larches
launches1387903launches
lunches124115443_lunches
lurched13358033_lurched
lurcher12338133_lurcher
lurchers13307153_lurchers
marches143921173_marches
merches144013763_merches
mouches143815963mou_ches
muches134718993_mu_ches
mulches143210673_mulches
munches144215793_munches
mutches143314283_mutches
nautches1336083nautches
ouches114322183_ou_ches
parches143720003_parches
paunches1568173paunches
perches143717953_perches
porches143815673_porches
pouches144116743pou_ches
punches144816133_punches
quiches2139333_quiches
qurshes19228573_qurshes
raunches1368053raunches
rouches124217893rou_ches
ruches114819583_ru_ches
scorches15189153scorches
scrunches1635403scrunches
sculches15176273sculches
scutches15168883scutches
searches132112903searches
shushes133510303shu_shes
smirches1535993smirches
smutches15177273smutches
sources9312173sourc_es
starches131912913starches
thatches1637513thatches
thrushes1436523thrushes
torches123715443_torches
touches125118343tou_ches
tusches1237903_tusches
unchurched2142443unchurched
vouches153914113vou_ches

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621857.45619603.3
3Display Results1851850.0762434.2
 (SQL Overall)1786911857.93522519.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.