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

126 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
yapocks1835472(None) 
yapock17365381yapock_
yapoks15346781yapo_ks
caprocks1835942caprocks
kapoks11347262kapo_ks
pocks135022962__pocks
yacks144419812ya__cks
yapok14468152yapo_k_
yapons114411772yapo_ns
yocks144418372y__ocks
acock132110213_acock_
amoks11413553_amo_ks
amucks1466003_amucks
apices104916263_apices
apods86316343_apo_ds
apos65433823_apo__s
backs135729623ba__cks
bannocks1644353bannocks
bawcocks21113443bawcocks
bemocks1735373bemocks
bipacks1745043bipacks
blocks144513943_blocks
bocks134526573__bocks
brocks145214153_brocks
calpacks18266523calpacks
capons104119503capo_ns
capos94826073capo__s
capotes11314643capotes
caprock1736813caprock_
caracks152211563caracks
cassocks1645033cassocks
chocks174815313_chocks
clocks144916233_clocks
cocks135227163__cocks
copecks1745873copecks
crocks145118423_crocks
daglocks1643993daglocks
docks126022313__docks
earlocks1435693earlocks
epochs1335813_epochs
flocks154713533_flocks
frocks154111213_frocks
gaposis1038423gaposis
hacks144928713ha__cks
haddocks1984903haddocks
hammocks2164343hammocks
hassocks1744693hassocks
havocs1435653havoc_s
haycocks2244113haycocks
hocks144925493__hocks
jacks185219833ja__cks
jocks185118083__jocks
kapok10448783kapo_k_
knocks11397443_knocks
kopecks1433073kopecks
kyacks14416063kya__cks
lacks116129203la__cks
lavrocks1743663lavrocks
locks115126923__locks
macks135127603ma__cks
mammocks1763893mammocks
mattocks1644983mattocks
mocks135023823__mocks
nocks115121013__nocks
oarlocks1445103oarlocks
packs135528933__packs
paddocks1894323paddocks
padlocks1755473padlocks
padouks1434873padouks
peacocks1844993peacocks
pecks135724433__pecks
picks135226143__picks
pock126129293__pock_
pocky165314603__pocky
porks115124143__porks
pucks134322103__pucks
racks115028853ra__cks
recocks154711463recocks
redocks14409933redocks
relocks134411293relocks
repacks15269543repacks
rocks114626413__rocks
sacks114228873sa__cks
sapors84118813sapo_rs
sapotas939613sapotas
sapotes9313943sapotes
sapours93610623sapours
seacocks1645643seacocks
shlocks16317183shlocks
shocks154414583_shocks
smocks145710013_smocks
socks114926083__socks
specks144312703_specks
spicks144814993_spicks
spooks124312933_spooks
stocks124715633_stocks
tacks115430133ta__cks
tapiocas1244783tapiocas
tarocs84615663taroc_s
taroks106115283taro_ks
traprocks1743213traprocks
trocks123614633_trocks
uncocks1537233uncocks
undocks1436163undocks
unlocks1337063unlocks
unpacks1576093unpacks
unpicks1545183unpicks
vapors113812693vapo_rs
vapours12277463vapours
wacks146626283wa__cks
warlocks1735363warlocks
yack135425973ya__ck_
yahoos12209243yaho_os
yaks116025203ya___ks
yanks125316573ya__nks
yapon104613583yapo__n
yappers144012253yappers
yaps95933523yap___s
yasmaks1633653yasmaks
yaupons12345683yaupo_ns
yock135924613y__ock_
yoicks15375933y_oicks
yoks116223743y__o_ks
yolks125412773y__olks
yucks144717193y__ucks
yupons11398353yupo_ns

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271265.79623124.1
3Display Results1261260.0333818.2
 (SQL Overall)1786911266.21928733.1
 
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.