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

155 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
kopeck133342(None) 
copeck1636941copeck
kopecks1433071kopecks
kopek1037811kope_k
copecks1745872copecks
keck94920712k__eck
kopeks1134602kopeks
peck125730682__peck
speck135115652_speck
apeak115513453_apeak
apeek114711873_apeek
aspect10612823aspect
beck126226573__beck
bedeck1536213bedeck
bipack1636523bipack
bock126032513bo__ck
bopeep1236763bopeep
check164714713_check
cock126332903co__ck
codec107120343codec_
codecs115112933codecs
cope86847383cope__
coped105036843cope_d
copen94826433cope_n
copens106119963copens
coper95336093cope_r
copers104629843copers
copes97747103cope_s
cosec96320183cosec_
cosecs105015213cosecs
deck115827753__deck
dock116228743do__ck
dope76038893dope__
doped95326713dope_d
doper86128393dope_r
dopers95522483dopers
dopes84935043dope_s
dopey116020353dope_y
dorneck1444303dorneck
dreck124812803_dreck
expect1758903expect
feck134923433__feck
fleck148213593_fleck
geck115721993__geck
gopik1257533gop_ik
heck135826493__heck
henpeck1843083henpeck
hock136031303ho__ck
hoick145210683ho_ick
hope96639673hope__
hoped115628183hope_d
hoper105829143hope_r
hopers114222973hopers
hopes105835643hope_s
hopsack1845273hopsack
jock176522643jo__ck
kapok10448783kap_ok
kecks105416573k__ecks
keek75624963k__eek
kick96026063k__ick
klick105311433k_lick
knack104311043k_nack
knock10487963k_nock
koel84519943ko_e_l
koels94613903ko_els
kolacky1543203kolacky
konk79320613ko__nk
kook75822603ko__ok
kop97440203kop___
koph135816543kop__h
kophs145010933kop_hs
kopiyka154833kopiyka
kopje1835273kop_je
kopjes1935363kopjes
koppa13397293kop_pa
koppas14407603koppas
koppie14277873koppie
kops107031293kop__s
kore85834163kore__
kyack13468263k_yack
lock106134363lo__ck
lope65941923lope__
loped85128333lope_d
loper75129233lope_r
lopers84424143lopers
lopes76437343lope_s
mock126429443mo__ck
mope86838043mope__
moped105424733mope_d
mopeds11499663mopeds
moper94925923mope_r
mopers104220373mopers
mopery135210973mopery
mopes95134983mope_s
mopey124821823mope_y
neck105423663__neck
nock106127183no__ck
nonpeak1345473nonpeak
nope65934193nope__
ope56845243_ope__
oped76230153_ope_d
open66427003_ope_n
opens76118553_opens
opera7313573_opera
opes65942613_ope_s
pack125535443__pack
peak106535203__peak
pec76744413__pec_
pech116125453__pech
pecks135724433__pecks
pecky165515093__pecky
pecs84634103__pecs
peek106031433__peek
perk106232843__perk
pick125933813__pick
pock126129293__pock
pope85535613pope__
popery134511703popery
popes95933813pope_s
puck124927943__puck
rebeck14419913rebeck
reck106130563__reck
repack142412163repack
reperk122511773reperk
rock105735183ro__ck
rope65542913rope__
roped84630803rope_d
roper75431913rope_r
ropers84325903ropers
ropery114313873ropery
ropes75940063rope_s
ropey106021873rope_y
sneck114713663_sneck
sock105233213so__ck
speak114618673_speak
spec85821973_spec_
specks144312703_specks
specs96916673_specs
spick134519073_spick
tope65946383tope__
toped85631313tope_d
topee76029953tope_e
topees85519703topees
toper75231023tope_r
topers85025323topers
topes76941763tope_s
topic95721503topic_
topics104714583topics
topkick1443143topkick
unpack1457833unpack
unpick1446903unpick
wreck144611043_wreck
yapock17365383yapock
yock135924613yo__ck
zebeck23255203zebeck

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 Filter1786911127160.1701051123.5
2DLD Change Limit1127161556.19018209.4
3Display Results1551550.0602583.3
 (SQL Overall)1786911556.42027833.5
 
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.