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

213 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
clops9592485(None) 
chops125019871chops
claps95626181claps
clips96018301clips
clods85320861clods
clogs85519551clogs
clomps125212231clomps
clons75228131clons
clop86929891clop_
clots75627641clots
cloys104916941cloys
coops96229641coops
cops86751371c_ops
crops96125231crops
flops105920141flops
glops85619551glops
lops66043351_lops
plops95920331plops
slops75026011slops
aloes54933672aloes
alps65529242al_ps
blips95615782blips
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
bloops106611342bloops
blots75626172blots
blows105423832blows
bops86037982_bops
calos74431902calo_s
camps116330262camps
capos94826072capos
caps87147892c_aps
carps96932252carps
celoms10412122celoms
ceps86125952c_eps
chaps125326062chaps
chips125721252chips
chomps155112222chomps
chop116024922chop_
chows135618202chows
cions75222852cions
clads85722732clads
clags85621122clags
clamps124515082clamps
clams95127672clams
clans75031012clans
clap86429042clap_
clapt98027172clapt
clasp95517192clasp
clasps104512092clasps
class75525482class
claws106020832claws
clays105521332clays
clefs106616242clefs
clepe94617382clepe
clepes104214622clepes
clept95725772clept
clews105516332clews
clip86924002clip_
clipt96324272clipt
cloak115214012cloak
cloaks124411262cloaks
clock134917982clock
clocks144916232clocks
clod76124612clo_d
clog76123242clo_g
clomb115714702clomb
clomp115615702clomp
clon66232482clo_n
clone75728162clone
clones84526562clones
clonk114417442clonk
clonks125013472clonks
clonus85212412clonus
cloot76127052cloot
cloots85113692cloots
close76425222close
closes85425592closes
clot66542422clo_t
cloth105817542cloth
cloths115512482cloths
cloud86716422cloud
clouds94612352clouds
clour76617282clour
clours85215092clours
clout75330462clout
clouts87017202clouts
clove105619442clove
cloves114918822cloves
clown105214732clown
clowns114810112clowns
cloy96623832clo_y
cloze165517542cloze
clozes174915562clozes
clubs95415102clubs
clues74623032clues
clumps1215314642clumps
cobs87043142c_obs
cods76848102c_ods
cogs77340032c_ogs
colas75436772colas
colds85726972colds
coles76055062coles
collops112611752collops
cologs96517352cologs
colons86028682colons
colors86622372colors
cols66553082c_ols
colts76633292colts
comps115526052comps
cons66057692c_ons
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coop87238652coop_
coopt95929852coopt
coopts105814582coopts
coos67456492c_oos
coots75636842coots
cop711162372c_op_
cope86847382c_ope
copes97747102c_opes
copse95623922c_opse
copy116229802c_opy
corps95927042corps
cors66656442c_ors
cos510270392c_o_s
coss66143492c_oss
cots68054842c_ots
coups95522472coups
cows97046642c_ows
coys97537242c_oys
craps95328642craps
crocs95722432crocs
crop87628632crop_
cross75124502cross
croups104312552croups
crows105727312crows
cups85430822c_ups
cusps94913672cusps
cyclops1635382cyclops
drops85719502drops
elope75219342elope
elopes85918162elopes
flaps105621382flaps
flips105117742flips
flocs105519232flocs
floes85528142floes
flogs95919962flogs
flop96925452flop_
floss85118262floss
flows115822362flows
fops96532682_fops
galops94712622galops
globs85616402globs
gloms85219782gloms
glop76724632glop_
gloss64319622gloss
glows95518032glows
goops86620962goops
hoops105621072hoops
hops97942632_hops
jalops15329592jalops
knops115911812knops
kops107031292_kops
laps66848872_laps
lips67141442_lips
lobs66441082_lobs
logs57343112_logs
loops75723962loops
loos49051122_loos
lop58255312_lop_
lope65941922_lope
lopes76437342_lopes
loss45337962_loss
lots47652092_lots
loups75319622_loups
lows75843012_lows
mops85940132_mops
oops65232672_oops
ops56641252__ops
orlops847302orlops
plods85719292plods
plop86625742plop_
plots75025672plots
plows105419902plows
ploys105816592ploys
poops94422412poops
pops86340952_pops
props95726882props
scoops105414362scoops
scops95820192scops
shops104222902shops
slaps76025712slaps
slips76023722slips
slobs74419872slobs
sloes54728872sloes
slogs64521842slogs
sloops85513622sloops
slop66533872slop_
slope75823562slope
slopes84820452slopes
slots54830532slots
slows85323462slows
sops65244562_sops
stops74827282stops
swops105913972swops
tops66248122_tops
whops135013932whops
woops104917522woops
wops96634152_wops

Search took 3 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.313570897.8
2DLD Change Limit538002131.75030742.9
3Display Results2132130.0633381.0
 (SQL Overall)1786912132.12684050.3
 
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.