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

124 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
clock13491798(None) 
block134917841block
chock164316611chock
clack134720171clack
click135217951click
cloak115214011cloak
clocks144916231clocks
clonk114417441clonk
cluck134914891cluck
cock126332901c_ock
crock135921991crock
flock144717421flock
lock106134361_lock
acock132110212acock
alack114820062alack
black134719072black
bloc85023272bloc_
blocks144513942blocks
blocky17388352blocky
blocs95219652blocs
bock126032512_bock
brock136017072brock
check164714712check
chick165419132chick
chocks174815312chocks
chook146015042chook
chuck164814872chuck
clach124617822clach
clacks144516342clacks
clank114719522clank
cleek115514912cleek
clerk115812452clerk
clicks145315112clicks
clink115320042clink
cloaca1037262cloaca
cloaks124411262cloaks
cloche134312372cloche
clocked164112832clocked
clocker153910872clocker
clod76124612clo_d
clods85320862clods
clog76123242clo_g
clogs85519552clogs
clomb115714702clomb
clomp115615702clomp
clon66232482clo_n
clone75728162clone
clonks125013472clonks
clons75228132clons
cloot76127052cloot
clop86929892clo_p
clops95924852clops
close76425222close
clot66542422clo_t
cloth105817542cloth
clots75627642clots
cloud86716422cloud
clour76617282clour
clout75330462clout
clove105619442clove
clown105214732clown
cloy96623832clo_y
cloys104916942cloys
cloze165517542cloze
clucks144512072clucks
clunk114215082clunk
coca88030642c_oca
cocks135227162c_ocks
cocky164215932c_ocky
coco87330602c_oco
conk106531442c_onk
cooch124916832cooch
cook107236932c_ook
cork106635692c_ork
crack134120532crack
crick135118752crick
croak115216632croak
croc85723732croc_
croci95818132croci
crocks145118422crocks
crocs95722432crocs
crook115217572crook
cruck135615322cruck
dock116228742_dock
flack144519412flack
fleck148213592fleck
flick145017212flick
floc95922122floc_
flocks154713532flocks
flocky18468422flocky
flocs105519232flocs
frock145314652frock
hock136031302_hock
jock176522642_jock
klick105311432klick
knock10487962knock
lack105837682_lack
lick106935072_lick
loca65527682_loca
loch95527132_loch
loci66126282_loci
locks115126922_locks
loco67030742_loco
look87333472_look
luck105329822_luck
mock126429442_mock
nock106127182_nock
plack135017842plack
plonk114613982plonk
pluck134212302pluck
pock126129292_pock
relock124713522relock
rock105735182_rock
schlock18235872schlock
shlock15378182shlock
shock144917022shock
slack115021762slack
slick115520522slick
smock135311672smock
sock105233212_sock
stock114417562stock
trock114817602trock
unlock1248532unlock
yock135924612_yock

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.0931921408.6
2DLD Change Limit538001241.78030224.7
3Display Results1241240.0333757.6
 (SQL Overall)1786911241.90693751.8
 
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.