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

267 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
coops9622964(None) 
chops125019871chops
clops95924851clops
comps115526051comps
coofs105924711coofs
cooks115429141cooks
cools75632631cools
coons76737281coons
coop87238651coop_
coopt95929851coopt
coopts105814581coopts
coos67456491coo_s
coots75636841coots
cops86751371c_ops
corps95927041corps
coups95522471coups
crops96125231crops
goops86620961goops
hoops105621071hoops
loops75723961loops
oops65232671_oops
poops94422411poops
scoops105414361scoops
woops104917521woops
bloops106611342bloops
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032boo_s
boots75837972boots
bops86037982_bops
camps116330262camps
capos94826072capos
caps87147892c_aps
carps96932252carps
ceps86125952c_eps
chaps125326062chaps
chips125721252chips
chomps155112222chomps
chooks155312792chooks
chop116024922chop_
chows135618202chows
cions75222852cions
claps95626182claps
clips96018302clips
clods85320862clods
clogs85519552clogs
clomps125212232clomps
clons75228132clons
cloots85113692cloots
clop86929892clop_
clots75627642clots
cloys104916942cloys
coals76129602coals
coapt96131532coapt
coapts104614012coapts
coats75635002coats
cobbs115013992cobbs
cobs87043142c_obs
cocas95926572cocas
cocks135227162cocks
cocoas104915742cocoas
cocos95624692cocos
codas84724242codas
codes86247292codes
codons96119462codons
cods76848102c_ods
coeds85920162coeds
coffs134916302coffs
cogons96818112cogons
cogs77340032c_ogs
cohogs125810272cohogs
cohos105921852cohos
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
cokes115537192cokes
colas75436772colas
colds85726972colds
coles76055062coles
collops112611752collops
cologs96517352cologs
colons86028682colons
colors86622372colors
cols66553082c_ols
colts76633292colts
comas95833002comas
combs116122962combs
comes97246992comes
comous10816502comous
comp106731252comp_
compas125817062compas
compo115318572compo
compos124818802compos
compt116328222compt
compts125216652compts
cones76457422cones
conks115525702conks
conns75024232conns
cons66057692c_ons
conus76726532conus
coo59566362coo__
cooch124916832cooch
cooed84534342cooed
cooee74531022cooee
cooees85621892cooees
cooer74831012cooer
cooers84324562cooers
cooey105828222cooey
cooeys114914482cooeys
coof96643272coo_f
cook107236932coo_k
cooky145321362cooky
cool66940492coo_l
cooly105525422cooly
coomb115615702coomb
coombs124210192coombs
coon67248942coo_n
cooped114821602cooped
cooper104221122cooper
coopers114019482coopers
coot67860382coo_t
cop711162372c_op_
cope86847382c_ope
copes97747102copes
copse95623922c_opse
copy116229802c_opy
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corpse104013402corpse
corpus106015292corpus
cors66656442c_ors
cos510270392c_o_s
coses76949492coses
coss66143492c_oss
costs77231142costs
cotes76347842cotes
cots68054842c_ots
coup86729792coup_
coupe96023482coupe
coupes105022522coupes
coves105539172coves
cowls106922212cowls
cows97046642c_ows
coxes145430862coxes
coypu12349872coypu
coypus13389302coypus
coys97537242c_oys
cozes166033242cozes
craps95328642craps
crocs95722432crocs
crooks124914412crooks
croons85418422croons
crop87628632crop_
cross75124502cross
croups104312552croups
crows105727312crows
cups85430822c_ups
cusps94913672cusps
dooms85321342dooms
doors65022132doors
dorps85419222dorps
droops95110962droops
drops85719502drops
flops105920142flops
foods95924162foods
fools86824202fools
foots85528282foots
fops96532682_fops
glops85619552glops
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goop75829482goop_
goopy115816622goopy
goos57644912goo_s
gorps85316992gorps
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hoop96129982hoop_
hoots84830252hoots
hops97942632_hops
knops115911812knops
kooks85217262kooks
kops107031292_kops
loofs85623782loofs
looks95124862looks
looms75124642looms
loons55731722loons
loop67835012loop_
loopy105316642loopy
loos49051122loo_s
loots55431422loots
lops66043352_lops
loups75319622loups
moods85224622moods
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302moo_s
moots75831662moots
mops85940132_mops
nooks95420392nooks
noons54125282noons
oohs75220692_oohs
oots46446442_oots
ops56641252__ops
plops95920332plops
pomps115316192pomps
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poop86532812poop_
poos65949112poo_s
pops86340952_pops
props95726882props
romps94617542romps
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
roups75118902roups
scoop95617162scoop_
scoots85315942scoots
scops95820192scops
scroops11288242scroops
shops104222902shops
sloops85513622sloops
slops75026012slops
snoops84314172snoops
soaps75120712soaps
sooks94425452sooks
soots55536212soots
sops65244562_sops
soups75322942soups
stoops85917892stoops
stops74827282stops
swoops114910922swoops
swops105913972swops
tools55325242tools
toons55027532toons
toots55331872toots
topos75726392topos
tops66248122_tops
troops85712782troops
whoops14487862whoops
whops135013932whops
woods95723032woods
woofs114918002woofs
wools84421462wools
woos76238802woo_s
wops96634152_wops
zooks184716942zooks
zooms164415522zooms
zoons144919692zoons
zoos135828802zoo_s

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.0802233637.5
2DLD Change Limit538002671.75030742.9
3Display Results2672670.0604450.0
 (SQL Overall)1786912671.89094545.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.