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

413 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
choush1454906(None) 
chough15699241chough
chouse116017561chouse
choose115116142choose
choosy14459102choosy
chops125019872chops_
chorus115014762chorus_
chose105925402cho_se
choughs16576622choughs
choused135012462choused
chouser125212942chouser
chouses125117812chouses
choushes1637622choushes
chows135618202chows_
chowse144711752chowse
clough12539132clough
cohosh14517122cohosh
cosh96127622c_o_sh
couch125320112c_ouch
cough115819642c_ough
couth106122482c_outh
crouch133910202crouch
crouse84619362crouse
crush106815992c_rush
house89131422_house
hush105224112_h_ush
shush113812542sh_ush
though139410762though
thous86017252thous_
thrush12257482thrush
whoosh15244352whoosh
ablush1147223ablush
ahorse9311513ahorse
ambush1336103ambush
ankush13114433ankush
arouse65019983arouse
avouch1434833avouch
blouse84714723blouse
blousy11459123blousy
blush105115313_blush
bosh96328973_bo_sh
bough115719313_bough
bouse75931853_bouse
bousy104917843_bousy
brush105917473_brush
bush96630713__bush
cachous14312563cachous_
cahows14399123cahows_
calash11312433calash
capouch1644413capouch
carouse9614423carouse
cash96636283c__ash
casus76419253casus_
cathouse1338843cathouse
cause75225353c_ause
cayuse11207763cayuse
cerous85821203cerous_
ceruse83914523ceruse
chads116122233chads_
chais107530313chais_
chaise114916413chaise
chalah143511653chalah
chaleh143711993chaleh
chams126028503chams_
chaos105622863chaos_
chaps125326063chaps_
chars105936633chars_
chase105127123ch_ase
chasm125518793ch_asm
chasse115114603chasse
chats105730093chats_
chaunt11613493chaunt
chaws135022463chaws_
chays135319743chays_
cheese113812763cheese
cheesy14419193cheesy
chefs136214663chefs_
cherish15310463cherish
chess105016923ch_ess
chest104926143ch_est
chetah14399583chetah
cheth135013823ch_eth
cheths14389823cheths
chews135418513chews_
chias104625513chias_
chiasm13449103chiasm
chiaus113611303chiaus_
chics123920943chics_
chinch163911223chinch
chins105631463chins_
chips125721253chips_
chirus114615693chirus_
chis95933313ch_is_
chits105424573chits_
choana1138443choana
chock164316613cho_ck
chocks174815313chocks
choice132010523choice
choir105313593cho_ir
choirs114911873choirs
choke145118023cho_ke
choked164914793choked
choker154314373choker
chokes154917383chokes
chokey184811713chokey
choky175711223cho_ky
chola104718033cho_la
cholas114817993cholas
choler113717153choler
cholla113911023cholla
cholo105217973cho_lo
cholos114716853cholos
chomp144815663cho_mp
chomps155112223chomps
chon96627793cho__n
chook146015043cho_ok
chooks155312793chooks
chooser124412963chooser
chooses125717413chooses
choosey15459233choosey
chop116024923cho__p
chopin132712183chopin
choppy18376293choppy
choral115118493choral
chord115917263cho_rd
chords125214633chords
chore105126763cho_re
chorea115216083chorea
chored125321883chored
chores114828023chores
choric133515893choric
chorused1446133chorused
choruses1339983choruses
chosen116014133chosen
choses115825123choses
chott103923923cho_tt
chotts113610983chotts
chousers134610183chousers
chousing14259423chousing
chow125820993cho__w
chowed154914643chowed
chowsed16478603chowsed
chowses155611283chowses
chrism13710673chrism
chub115516413ch_u_b
chubs125412623ch_ubs
chuck164814873ch_uck
chufa13489113ch_ufa
chuff164812493ch_uff
chug105914113ch_u_g
chugs115511943ch_ugs
chum116318003ch_u_m
chump145315443ch_ump
chums125015833ch_ums
chunk144812383ch_unk
church1636483church
churl105913883ch_url
churn105113103ch_urn
churr104512853ch_urr
chute104316463ch_ute
chylous15107263chylous_
chymous1775693chymous_
cions75222853cions_
clash106219033c_lash
clause84311503clause
clods85320863clods_
clogs85519553clogs_
clons75228133clons_
clonus85212413clonus_
clops95924853clops_
close76425223clo_se
cloth105817543clo_th
cloths115512483cloths
clots75627643clots_
cloud86716423clou_d
clouds94612353clouds
cloudy12517803cloudy
cloughs13517053cloughs
clour76617283clou_r
clours85215083clours
clout75330463clou_t
clouts87017203clouts
cloys104916943cloys_
coach125919453c_oach
coast75236263c_oast
cobs87043143c_obs_
cods76848103c_ods_
cogs77340033c_ogs_
cohogs125810273cohogs_
cohos105921853cohos_
cohost115217213cohost
cohune1189423cohune
cols66553083c_ols_
comous10816503comous_
conch124620073c_onch
cons66057693c_ons_
conus76726533conus_
cooch124916833c_ooch
coofs105924713coofs_
cooks115429143cooks_
coolish12312523coolish
cools75632633cools_
coolth1139513coolth
coons76737283coons_
coops96229643coops_
coos67456493c_oos_
coots75636843coots_
cops86751373c_ops_
copse95623923c_opse
cors66656443c_ors_
corse75036183c_orse
cos510270393c_o_s_
coss66143493c_o_ss
cost68057943c_o_st
cosy97232703c_o_sy
cots68054843c_ots_
coude85022633c_oude
coughs125514543c_oughs
could86517713c_ould
count74932053c_ount
coup86729793c_ou_p
coupe96023483c_oupe
coups95522473c_oups
course85117773c_ourse
court75532763c_ourt
cousin8517153c_ousin
couths115715393c_ouths
cows97046643c_ows_
coyish143710393coyish
coys97537243c_oys_
crash109120013c_rash
creesh11328333creesh
crocs95722433crocs_
crocus104813173crocus_
cronish12310863cronish
crops96125233crops_
cross75124503cro_ss
crosse85216303crosse
crotch133410083crotch
croup95616783crou_p
croupe105114433croupe
croups104312553croups
croupy13458733croupy
croute84617273croute
crows105727313crows_
crus65828483c_rus_
cruse75726103c_ruse
crust75827663c_rust
cuish10313173c_uish
cushy134412323c__ushy
cusk105521633c__usk
cusp86021063c__usp
cuss65430613c__uss
cymous1388403cymous_
dhows125911223dhows_
dough105217383_dough
douse66329723_douse
drouth104410103drouth
echoes114715523echoes_
echoism1447363echoism
echos105216463echo_s_
enough1045753enough
flush115116073_flush
frosh115713403fro_sh
ghost96318763gho_st
ghoul959053ghou_l
ghoulish1543543ghoulish
ghouls1036043ghouls
gosh86123423_go_sh
grouch12318473grouch
grouse74315023grouse
gush85424003__gush
harsh116418053_harsh
hash106936503_h_ash
haugh125114053_haugh
heuch135312333_heuch
heugh125410923_heugh
hobs97038983_hobs_
hocus104715203_hocus_
hods87239863_hods_
hoes75755733_hoes_
hogs87139663_hogs_
hoise85224773_hoise
hoist86433213_hoist
hols76946293_hols_
hons77350783_hons_
hooch135813703_hooch
hops97942633_hops_
horah117922043_horah
horse86132653_horse
horst85833513_horst
horsy116318393_horsy
hos68364193_ho_s_
hose76547243_ho_se
host77852833_ho_st
hotch136214723_hotch
hots78349323_hots_
houdah1335173_houdah
hound95016483_hound
hour75827313_hou_r
houri85915233_houri
hours85422383_hours
housed105624103_housed
housel95217043_housel
houser95322283_houser
houses96032273_houses
hows106345603_hows_
hoys107733933_hoys_
huh96432013_h_u_h
hunh106323733_h_unh
husk116021953_h_usk
icehouse1344753icehouse
ichors11310413ichors_
inrush936513inrush
josh145117613_jo_sh
joust125122293_joust
khoum1476633khou_m
khoums1594013khoums
lough95118483_lough
louse56131013_louse
lousy84617083_lousy
lush75327693__lush
meous76120063meous_
mhos95517773mho_s_
mosh95227603_mo_sh
mouch124715803_mouch
mouse77133003_mouse
mousy106716943_mousy
mouth105420293_mouth
mush94929123__mush
nosh76223543_no_sh
nous46136983_nous_
ochrous1237933ochrous_
onrush935343onrush
ouch95724633__ouch
ouph95618373__ouph
oust46747443__oust
phons105221143phons_
phots105418493phots_
pious74621273pious_
plough12577563plough
plush105614713_plush
posh95427323_po_sh
pouch124617083_pouch
push95526623__push
qurush1835503qurush
rehouse10311773rehouse
rhos76319063rho_s_
rhus75114053rh_us_
rough97819433_rough
rouse56634703_rouse
roust55532063_roust
routh86423073_routh
rush76628183__rush
schuss11186733sch_uss
scouse84113633scouse
scouth115011153scouth
shaugh13287433shaugh
sheesh1237813sheesh
sheuch14267043sheuch
sheugh13295883sheugh
shoes85429653shoes_
shogs95319703shogs_
shoos84226353shoos_
shops104222893shops_
shots84730833shots_
should1038023should
shout85433163shou_t
shouts94017713shouts
shows115324573shows_
shoyus1265993shoyus_
skosh12407263sko_sh
slosh84514483slo_sh
slouch11438523slouch
slough10539233slough
slush85316573_slush
smoosh11236733smoosh
smush104410583_smush
sough95320463_sough
sous46947213_sous_
souse56530773_souse
south85223573_south
spouse84112513spouse
squush1833993squush
swoosh12195213swoosh
those85218143tho_se
thou76722213thou__
thoued10429003thoued
thought14639133thought
thrash12258353thrash
thresh12276863thresh
through141647513through
thrust91911893thrust
thus76721473th_us_
tosh74826813_to_sh
touch106519393_touch
tough97321983_tough
touse55430673_touse
trough108512023trough
tush74523903__tush
unhouse1038923unhouse
uprush1135783uprush
vouch134611903_vouch
whish144512923wh_ish
whomso1434133whomso
whops135013933whops_
whorish1636603whorish
whose114914533who_se
whoso11509223who_so
woosh113710733_woosh
yous76230653_yous_
youse85322233_youse
youth115315043_youth

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.1231452772.4
2DLD Change Limit1127164135.87619182.4
3Display Results4134130.1402950.0
 (SQL Overall)1786914136.13929107.5
 
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.