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 “corks” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

292 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
corks11602827(None) 
borks115727701borks
carks115534211carks
cocks135227161cocks
conks115525701conks
cooks115429141cooks
cords86030621cords
cores76361851cores
cork106635691cork_
corky145221151corky
corms95626221corms
corns76034761corns
corps95927041corps
cors66656441cor_s
dorks105724441dorks
forks125324681forks
porks115124141porks
works125621901works
acorns85013012acorns
arks85936872_arks
barks115735812barks
berks115423122berks
birks114920302birks
bocks134526572bocks
bonks116326462bonks
books115729712books
boras75938302boras
bores76448252bores
bork106933822bork_
borts76735452borts
bosks115218852bosks
calks115421602calks
carbs96031462carbs
cards85137932cards
cares77369182cares
cark105539272cark_
carls77037422carls
carns75937562carns
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
casks115720062casks
ceorls848162ceorls
ceres75540012ceres
ceros74726072ceros
charks155219702charks
chirks155414842chirks
chocks174815312chocks
chooks155312792chooks
chords125214632chords
chores114828022chores
chorus115014772chorus
cires74932912cires
clerks12458842clerks
cloaks124411262cloaks
clocks144916232clocks
clonks125013472clonks
coals76129602coals
coats75635002coats
cobbs115013992cobbs
cobras104014192cobras
cobs87043142co_bs
cocas95926572cocas
cock126332902cock_
cocky164215932cocky
cocos95624692cocos
codas84724242codas
codes86247292codes
cods76848102co_ds
coeds85920162coeds
coffs134916302coffs
cogs77340032co_gs
cohos105921852cohos
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
coke107038382co_ke
cokes115537192cokes
coky137526822co_ky
colas75436772colas
colds85726972colds
coles76055062coles
cols66553082co_ls
colts76633292colts
comas95833002comas
combs116122962combs
comes97246992comes
comps115526052comps
cones76457422cones
conk106531442conk_
conky145818742conky
conns75024232conns
cons66057692co_ns
conus76726532conus
coofs105924712coofs
cook107236932cook_
cooky145321362cooky
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492co_os
coots75636842coots
copes97747102copes
copras103517152copras
cops86751372co_ps
cor59960942cor__
coral76033452coral
corals85325142corals
corby125018532corby
cord76740922cor_d
core67263112cor_e
cored85044222cored
corer75538872corer
corers85231072corers
corf95941482cor_f
corgi8316082corgi
corgis9314412corgis
coria75828322coria
corked135020782corked
corker124720852corker
corkers134118852corkers
corm85735382cor_m
corn69945812cor_n
cornu75921322cornu
cornus84816562cornus
corny106023272corny
corpse104013402corpse
corpus106015292corpus
corse75036182corse
corses84433462corses
corves115122522corves
cory96941512cor_y
cos510270392co__s
coses76949492coses
coss66143492co_ss
costs77231142costs
cotes76347842cotes
cots68054842co_ts
coups95522472coups
courts84216172courts
coves105539172coves
cowls106922212cowls
cows97046642co_ws
coxes145430862coxes
coys97537242co_ys
cozes166033242cozes
cris66233432c_ris
croaks125812982croaks
crocks145118422crocks
crocs95722432crocs
crooks124914412crooks
crops96125232crops
crores86121162crores
cross75124502cross
crows105727312crows
crus65828482c_rus
curbs94821652curbs
curds85725612curds
cures75645432cures
curfs105122142curfs
curls74927102curls
curns74924282curns
currs75624392currs
curs65645542cur_s
cusks114916052cusks
darks106727872darks
dirks105619522dirks
docks126022312docks
dork96531462dork_
dorky135518742dorky
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
folks126017122folks
forbs105720802forbs
fords95328182fords
fores85847102fores
fork115930942fork_
forky156119642forky
forms105327052forms
forts86034452forts
gooks105422882gooks
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gowks136011952gowks
groks105716122groks
harks126333432harks
hocks144925492hocks
holks124720562holks
honks125124522honks
hooks125027122hooks
horas86333102horas
horns86125332horns
howks155016852howks
irks86220132_irks
jerks166514892jerks
jocks185118082jocks
jouks165612342jouks
kirks84915262kirks
konks84917112konks
kooks85217262kooks
koras95927112koras
kors85933012kor_s
larks95227812larks
locks115126922locks
looks95124862looks
lords64923502lords
lores55045402lores
loris55329152loris
lurks95218742lurks
marks115933482marks
merks114722402merks
mirks115122142mirks
mocks135023822mocks
monks116123392monks
moras76438782moras
mores76249642mores
morns75527442morns
mors65950062mor_s
morts75533562morts
mosks116117002mosks
murks114821732murks
narks96026032narks
nocks115121012nocks
nooks95420392nooks
noris54928272noris
norms76019312norms
oaks86527902_oaks
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ors35750112_or_s
orts46538332_orts
parks116134462parks
perks115325802perks
pocks135022962pocks
pores75849032pores
pork106929682pork_
porky145019332porky
porns75527342porns
ports75934592ports
recorks134813022recorks
rocks114626412rocks
rooks95325042rooks
sarks96632462sarks
scores84725922scores
scorns85713022scorns
soaks95220292soaks
socks114926082socks
sooks94425452sooks
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028422sorns
sorts54536662sorts
sorus54527582sorus
souks94820522souks
storks106115952storks
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torsk94915772torsk
torsks10549122torsks
torts56138122torts
torus54329762torus
turks95320822turks
uncorks1337442uncorks
warks127932402warks
woks116224902wo_ks
wonks124818342wonks
words95425072words
work115528842work_
worms105320762worms
worts88631182worts
yerks125416562yerks
yocks144418372yocks
yoks116223742yo_ks
yolks125412772yolks
yores85031322yores
zerks185113822zerks
zonks184815172zonks
zooks184716942zooks
zoris145320012zoris
zouks184410502zouks

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538002921.47036598.6
3Display Results2922920.0763842.1
 (SQL Overall)1786912921.85696277.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.