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

328 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
recock14511272(None) 
recocks154711461recocks
recook125513921recook
recork126315481recork
redock134311541redock
relock124713521relock
acock132110212_acock
bemock1636172bemock
cock126332902__cock
decoct11313782decoct
peacock1745142peacock
petcock1744602petcock
precook1577802precook
prerock1536722prerock
rebeck14419912rebeck
rebook125213202rebook
recce9514562rec_ce
recheck1835612recheck
reck106130562re__ck
recoal84117972recoal
recoat84024272recoat
recocked17248472recocked
recode93618712recode
recoil84016722recoil
recoin84320292recoin
recomb1238872recomb
recon75624242reco_n
recons84922992recons
recooks134711232recooks
recopy1339042recopy
record96117422record
recorks134813022recorks
recoup10810372recoup
redocks14409932redocks
relocks134411292relocks
relook104813742relook
repack142412162repack
rerack122513162rerack
resoak10311092resoak
restock1338672restock
retack122612822retack
retook104313442retook
rework136619782rework
rock105735182r__ock
rococo1036812rococo
seacock1545572seacock
uncock1438562uncock
armlock1544313armlock
bawcock20144033bawcock
beck126226573be__ck
becloak1545043becloak
become123312593become
bedeck1536213bedeck
bedrock1645643bedrock
bemocks1735373bemocks
betook12439603betook
bibcock1943533bibcock
block134917843_block
bock126032513__bock
brock136017073_brock
chock164316613_chock
clock134917983_clock
coca88030643__coca
cocks135227163__cocks
cocky164215933__cocky
coco87330603__coco
conk106531443__conk
cook107236933__cook
cork106635693__cork
crock135921993_crock
deck115827753de__ck
deco76125973deco__
decocts1237833decocts
decode104414743decode
decor84717573deco_r
decors94017773decors
decos85522123deco_s
decoy115716313deco_y
decoys123911283decoys
defrock1744643defrock
detick1339383detick
dock116228743__dock
dreck124812803dre__ck
ebook114510803_ebook
epoch1248203_epoch
feck134923433fe__ck
fetlock1645323fetlock
firelock1744823firelock
flock144717423_flock
forelock1745593forelock
frock145314653_frock
gamecock1942353gamecock
geck115721993ge__ck
gorcock1643653gorcock
haycock2144313haycock
heck135826493he__ck
hemlock1845633hemlock
hock136031303__hock
jock176522643__jock
kebbock1643613kebbock
keck94920713ke__ck
knock10487963_knock
lock106134363__lock
mecca1139933mec_ca
medick154010133medick
mock126429443__mock
neck105423663ne__ck
nock106127183__nock
peacocks1844993peacocks
peacocky2142453peacocky
peck125730683pe__ck
petcocks1844583petcocks
pock126129293__pock
prebook1557523prebook
precheck2144153precheck
precode12311853precode
precooks1656763precooks
precool1139013precool
precoup1336123precoup
prepack1757643prepack
presoak1348453presoak
prework164210903prework
princock1842833princock
rack106234883r__ack
racon75422143raco_n
racons84319343racons
racoon83814473racoon
reach105123883re_ach
react74634333re_act
rebec94416543rebec_
rebecks15288013rebecks
rebecs103913673rebecs
rebody1238153rebody
reboil83814683reboil
rebooks134010513rebooks
reboot84119333reboot
rebop9313283rebo_p
rebops10311423rebops
rebore86625643rebore
reborn810016953reborn
rebozo1737323rebozo
rec55645463re__c_
recall83815723recall
recane83022873recane
recant83228683recant
recap95718023rec_ap
recaps103615733recaps
recast83422773recast
recces10614913recces
recede95515533recede
recency1438623recency
recent83630853recent
recept103319073recept
recess8314263recess
rechecks1944553rechecks
rechew14310213rechew
rechose121312043rechose
recipe103414893recipe
recit75235103rec_it
recite83625113recite
recits83621353recits
recked134821803recked
reckon123010543reckon
reckons13269653reckons
recks115625133rec_ks
reclad9311873reclad
recoals94214623recoals
recoats92616643recoats
recocking18138373recocking
recoded113115033recoded
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recolor978693recolor
recombs1336753recombs
recooked15268243recooked
records105213923records
recorked15239853recorked
recount9315173recount
recoupe11109933recoupe
recoups1188843recoups
recover124312623recover
recross989833recross
recrown12257573recrown
recs65734183re__cs
recta74220263rec_ta
rectal84418133rectal
recti73619623rec_ti
recto74520803rec_to
rector84019743rector
rectors93520513rectors
rectory123512723rectory
rectos85718783rectos
rectum103411283rectum
rectus83314633rectus
recur74116843rec_ur
recurs83315803recurs
recuse85519163recuse
recut74729243rec_ut
recuts83817373recuts
recycle1445343recycle
redact9419043redact
redcoat10410883redcoat
redneck1445113redneck
redo56029363redo__
redocked16206823redocked
redoes74623753redoes
redon65424883redo_n
redone74820053redone
redons75222183redons
redos65126763redo_s
redout71820253redout
redowa1038453redowa
redox134714233redo_x
reduce9713253reduce
reek85232523re__ek
reface113616353reface
refect114319333refect
refocus1236973refocus
refold103812113refold
reform11312703reform
reink95518093re_ink
reject154116283reject
rejoice16287453rejoice
rejoin134012243rejoin
relace83122153relace
relic74623363relic_
relics84517903relics
relict83623903relict
relink104415923relink
reload7413893reload
reloan6415693reloan
relocked15217743relocked
relooks114010723relooks
reluct83916113reluct
remark123512373remark
remold93412973remold
remora8414583remora
remote84222603remote
remove116115573remove
renown9369983renown
reoccur1143353reoccur
reoil55321183re_oil
repacks15269543repacks
repark123511713repark
reperk122511773reperk
repo66027543repo__
repoll8410793repoll
report85326013report
repos74725793repo_s
repose84121413repose
repot75132623repo_t
repots85621003repots
repour8310993repour
reracks132310533reracks
reroll6412683reroll
reroof9315003reroof
rerose63320843rerose
rescore95616193rescore
resect84424703resect
reseek103813133reseek
resoaks1148973resoaks
resod64720053reso_d
resods74116303resods
resold73915363resold
resole64624183resole
resorb84914343resorb
resort65728613resort
resow88217243reso_w
resown94112923resown
resows93915353resows
restack1339433restack
restocks1437503restocks
retacks132210713retacks
retch104818303re_tch
retold73013753retold
retool63914483retool
retore67630763retore
retorn610923423retorn
retort66831143retort
retouch1235853retouch
retrack131310723retrack
revoice12319183revoice
revoke135216243revoke
revolt9316223revolt
revote94917453revote
rewoke1339521213rewoke
rewon86920573rewo_n
reword106321403reword
rewore938030153rewore
reworks145113593reworks
reworn98122193reworn
rewove126420073rewove
rezone153814783rezone
rhebok1534613rhebo_k
rick107334653r__ick
rimrock1544383rimrock
roc520243253r__oc_
rocks114626413r__ocks
rocky144513853r__ocky
rococos1145903rococos
rocs65533663r__ocs
roebuck1544603roebuck
rook85532033r__ook
rowlock1654783rowlock
ruck104728333r__uck
ruddock1543133ruddock
seacocks1645643seacocks
secco9312423sec_co
seccos1039923seccos
second9411153second
shlock15378183shlock
shock144917023_shock
smock135311673_smock
sock105233213__sock
stock114417563_stock
trock114817603_trock
uncocks1537233uncocks
uncork1239043uncork
undock1337703undock
unlock1248533unlock
veloce11310133veloce
wedlock1744553wedlock
wreck144611043wre__ck
yapock17365383yapock
yecch15558093yec_ch
yock135924613__yock
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.1231452772.4
2DLD Change Limit1127163286.31317854.6
3Display Results3283280.0933526.9
 (SQL Overall)1786913286.52927368.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.