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

289 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
church163648(None) 
churchy2044181churchy
curch124415411c_urch
chinch163911222chinch
chuck164814872chu_ck
churched1934652churched
churches1846432churches
churchly2142972churchly
churl105913882chur_l
churls115411072churls
churn105113102chur_n
churns114910232churns
churr104512852chur_r
churro11448352churro
churrs115111512churrs
clutch13367752clutch
couch125320112cou_ch
crunch13349502crunch
crutch13408242crutch
culch124512832c_ulch
cutch125116192c_utch
hunch136416212_hunch
hutch135414092_hutch
lurch104814632_lurch
unchurch1842652unchurch
anarch11310393anarch
arch98628443__arch
birch124914023_birch
brunch13329353brunch
bunch125118603_bunch
burgh115216033_burgh
butch125416543_butch
caroch13911763caroch
carroch1437093carroch
catch125120373c_atch
cerci93716393c_erci
chalah143511653chalah
chaleh143711993chaleh
chance134617093chance
chancy164010863chancy
char95132153char__
charas114223593charas
chard116124743char_d
chards125119723chards
chare105231983char_e
chared125423693chared
chares115631803chares
charge125114213charge
chark144222713char_k
charka154011703charka
charkha19405153charkha
charks155219703charks
charm126124663char_m
charms135218833charms
charr104821783char_r
charro114212953charro
charrs115219183charrs
charry145012113charry
chars105936633char_s
chart105038283char_t
charts115823093charts
chary135023133char_y
check164714713ch_eck
cherish15310463cherish
cherry144810763cherry
chert105232103cher_t
cherts115617233cherts
cherty144612473cherty
cherub1337263cherub
chetah14399583chetah
cheth135013823ch_eth
chic115925203ch_ic_
chica125818263ch_ica
chichi1637093ch_ichi
chick165419133ch_ick
chico124218253ch_ico
chics123920943ch_ics
chinchy20335513chinchy
chiral114614413chiral
chirk144516183chir_k
chirks155414843chirks
chirm125317063chir_m
chirms135113983chirms
chiro105320343chir_o
chiros114617773chiros
chirp124717163chir_p
chirps135414003chirps
chirpy16498913chirpy
chirr105015903chir_r
chirre114111853chirre
chirrs114514983chirrs
chiru105317153chir_u
chirus114615693chirus
chock164316613ch_ock
choice132010523choice
choral115118493choral
chord115917263chor_d
chords125214633chords
chore105126763chor_e
chorea115216083chorea
chored125321883chored
chores114828023chores
choric133515893choric
chorus115014763chorus
chough15699243chough
choush14549063choush
chub115516413chu__b
chubby1844123chubby
chubs125412623chu_bs
chucks174812933chucks
chucky20418003chucky
chuddah17263253chuddah
chufa13489113chu_fa
chufas14397673chufas
chuff164812493chu_ff
chuffs17427783chuffs
chuffy20445863chuffy
chug105914113chu__g
chugs115511943chu_gs
chukar1534633chukar
chukka1433013chukka
chum116318003chu__m
chummy18385893chummy
chump145315443chu_mp
chumps154313823chumps
chums125015833chu_ms
chunk144812383chu_nk
chunks154210333chunks
chunky18468273chunky
chuppa1543973chuppa
chuppah1952453chuppah
churchier1944153churchier
churching2055083churching
churchman2153003churchman
churchmen2142923churchmen
churlish1644903churlish
churned13358373churned
churner12298343churner
churred13409173churred
churros12427583churros
chute104316463chu_te
chuted124611843chuted
chutes114615763chutes
cinch124516243c_inch
circa9311403c_irca
clach124617823c_lach
clench133910053clench
clinch133910353clinch
cluck134914893clu_ck
clutchy17323893clutchy
coach125919453c_oach
coerce10310403coerce
conch124620073c_onch
cooch124916833c_ooch
coprah133710603coprah
cough115819643cou_gh
course85117773course
court75532763cour_t
courts84216163courts
couth106122483cou_th
cranch133613533cranch
cratch134110793cratch
craunch1464443craunch
crotch133410083crotch
crouch133910203crouch
cruck135615323cru_ck
crunchy17324763crunchy
crura7312583crur_a
crural8610633crural
crush106815993cru_sh
cuish10313173c_uish
cultch13385953cultch
cur56841983c_ur__
curacy1339593c_uracy
curagh1236553c_uragh
curb86732223c_ur_b
curbs94821653c_urbs
curches143512743c_urches
curd77634983c_ur_d
curds85725613c_urds
curdy115916523c_urdy
cure66149123c_ur_e
cured85932133c_ured
curer75030753c_urer
cures75645433c_ures
curet75447643c_uret
curf97538783c_ur_f
curfs105122143c_urfs
curia74523763c_uria
curie74533033c_urie
curio74221203c_urio
curl66035053c_ur_l
curls74927103c_urls
curly105321233c_urly
curn66731883c_ur_n
curns74924273c_urns
curr65429653c_ur_r
currach1446453currach
currs75624393c_urrs
curry105920343c_urry
curs65645543c_ur_s
curse75829143c_urse
curst74931023c_urst
curt67051713c_ur_t
curve104920023c_urve
curvy136013373c_urvy
dhurna1043563dhurna
dourah10479813dourah
dunch115316263_dunch
dutch114713823_dutch
eparch13258423eparch
exarch18196173exarch
fourth12357443fourth
glunch1255353glunch
grutch12285563grutch
gulch113810603_gulch
gursh94512333_gursh
harsh116418053_harsh
hatch135719593_hatch
haunch14377343haunch
heuch135312333_heuch
hitch134515473_hitch
hooch135813703_hooch
horah117922043_horah
hotch136214723_hotch
huck135927633_hu_ck
huh96432013_hu__h
huic94818053_huic_
humph155712213_humph
hunh106323733_hu_nh
hurds95219073_hurds
hurl76029933_hur_l
hurls86522713_hurls
hurly115819293_hurly
hurrah12369183_hurrah
hurry114917183_hurry
hurst85527193_hurst
hurt77142573_hur_t
hurts86922823_hurts
hush105224113_hu_sh
inarch1139163inarch
larch105919793_larch
launch11368063launch
lunch104917243_lunch
march125622893_march
merch125417963_merch
mouch124715803mou_ch
much115224033_mu_ch
mulch124012973_mulch
munch124917103_munch
mutch125016173_mutch
nautch1144813nautch
nonchurch1952403nonchurch
ouch95724633_ou_ch
parch125123003_parch
paunch13369853paunch
perch124518833_perch
porch125918623_porch
pouch124617083pou_ch
prochurch2151913prochurch
punch125118423_punch
qursh174110843_qursh
raunch11358433raunch
sauch104918773sau_ch
scorch13198093scorch
scrunch1444033scrunch
sculch13226213sculch
scutch13247083scutch
search113312423search
sheuch14267043sheuch
shuck144314533shu_ck
shush113812543shu_sh
smirch1356463smirch
smutch13205843smutch
source8410673source
starch113013203starch
such96424813_su_ch
surah86823253_surah
teuch105214853teu_ch
thatch1435603thatch
thrush12257483thrush
thurl84912683thur_l
thurls9418713thurls
torch107420933_torch
touch106519393tou_ch
vouch134611903vou_ch
which163910083wh_ich
yucch15417433_yucch
yuch125818533_yu_ch

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 Filter1786911127160.1261418182.5
2DLD Change Limit1127162896.34317770.1
3Display Results2892890.0933107.5
 (SQL Overall)1786912896.56227231.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.