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

264 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
deticks143735(None) 
detick1339381detick_
anticks134612252anticks
bedticks1774162bedticks
decks124822192de__cks
deices94119372de_ices
delicts104012252delicts
depicts12358462depicts
derricks1544432derricks
detects104011092detects
deticked1635692deticked
deticker1545282deticker
detickers1634422detickers
devices133212582devices
dicks125824692d__icks
medicks16368412medicks
retacks132210712retacks
shticks16356962shticks
sticks125118612_sticks
ticks115823292__ticks
upticks1535152upticks
antick124814583antick_
antics84621453antic_s
attacks13126943attacks
attics84413283attic_s
batiks1239373bati_ks
becks135522013be__cks
bedecks1635793bedecks
bedtick1645233bedtick_
bemocks1735373bemocks
bethinks1765043bethinks
betides104915263betides
betimes115114413betimes
betises94816123betises
blueticks1743003blueticks
bricks144614623_bricks
chicks175317593_chicks
clicks145315113_clicks
cretics112911653cretic_s
cricks144316053_cricks
darics94314113daric_s
datives11310073datives
deairs74013783deai_rs
debarks14388493debarks
debeaks1436103debeaks
debits94214503debi_ts
debunks1433763debunks
decides114217653decides
deciles104417723deciles
deck115827753de__ck_
decocts1237833decocts
decos85522123de__cos
deduces1168793deduces
deducts1166593deducts
defaces133213403defaces
defects134511523defects
deficit1339673deficit
deficits1447273deficits
defiers113913993defiers
defies104624053defi_es
defiles114016843defiles
defines114118683defines
defis96717503defi__s
defocus1335283defocus
defrocks1844113defrocks
dehisces1464713dehisces
deice84320033de_ic_e
deiced104214483de_iced
deicer94114413de_icer
deicers103612733de_icers
deictics1345563deictic_s
deigns8389983de_igns
deils65722863de_i_ls
deisms94411043de_isms
deists74916433de_ists
deities82621923deities
deixis1437243de_ixis
dejects17389223dejects
delict94320333delic_t
delimes10314193delimes
delis64928543deli__s
delists84414173delists
deltic9312503deltic__
demarks14339233demarks
demic105119193demic__
demies94825803demi_es
demises103719563demises
demits94918073demi_ts
demotics1338753demotic_s
denials84114133denials
deniers84515183deniers
denies74729643deni_es
denims95214323deni_ms
denticle1137773denticle
denticles1237753denticles
dentils84115583denti_ls
dentines93418403dentines
dentins83419223denti_ns
dentists939263dentists
depict113514793depic_t
derides93420853derides
derives114017813derives
derrick1435803derrick_
designs9328313designs
desires81316133desires
desists83611723desists
desks105913073de__sks
destines93619663destines
detach12310413detac_h
detaches1439653detaches
details84214043details
detains83716093detains
detect94217403detec_t
detents83615153detents
deters74724683det_ers
detests83711743detests
deticking1736043deticking
detinue85010033detinue
detinues9569823detinues
detours858043detours
detoxes1538803detoxes
detracts11138833detracts
detritus945473detritus
deuces94015513de_uces
device124512163devic_e
devils104412813devi_ls
devious1138523devious
devises114116763devises
devoices14307413devoices
dexies145018343dexi_es
dezincs1933753dezincs
dices86434243d__ices
dick116432383d__ick_
dicky154816243d__icky
diebacks1745963diebacks
diestocks1644383diestocks
dinks105927953d__inks
dipsticks1864213dipsticks
dirks105619523d__irks
disks105417473d__isks
distichs1447633distichs
docks126022313d__ocks
dornicks1544403dornicks
downticks1942963downticks
drecks13459203d_recks
drinks116810713d_rinks
ducks124823213d__ucks
duties74921903duti_es
edicts94911703_edicts
emetics11610723emetic_s
entices91616333entices
epics95014283_epic_s
ericas8315463_ericas
ethics11169283_ethic_s
etic66123953_etic__
evicts11368553_evicts
fecks145417853fe__cks
fetials103711743fetials
fetich1479693fetic_h
fetiches1636953fetiches
fetlocks1744713fetlocks
flicks154512993_flicks
gecks125117093ge__cks
hecks145220653he__cks
helices12313723helices
hicks145322173__hicks
hoicks15378283_hoicks
kecks105416573ke__cks
kicks104420083__kicks
klicks11468723_klicks
latices9313763latices
lentisks1244413lentisks
licks115325393__licks
luetics937323luetic_s
medick154010133medick_
medicos12339833medicos
medics114115353medic_s
methinks1775193methinks
meticais1248183meticais
metical11315363metical
meticals12310763meticals
metiers93312843metiers
metis75025903meti__s
metrics11312363metric_s
micks135525373__micks
musicks15297053musicks
necks115119333ne__cks
nicks114920493__nicks
nitpicks1643183nitpicks
notices9312283notices
nutpicks1643423nutpicks
optics102810183optic_s
outkicks1344603outkicks
pecks135724433pe__cks
peptics132610243peptic_s
petcocks1844583petcocks
petites93820203petites
picks135226143__picks
poetics11312073poetic_s
pricks144414263_pricks
quicks21389303_quicks
rebecks15288013rebecks
recks115625133re__cks
recocks154711463recocks
redocks14409933redocks
reinks105012153re_inks
relics84517903relic_s
relicts94414593relicts
relinks114510223relinks
relocks134411293relocks
repacks15269543repacks
reracks132310533reracks
restacks1438093restacks
restocks1437503restocks
retack122612823retack_
rethinks1576033rethinks
reticle94112623reticle
reticles103912483reticles
reties65436193reti_es
retiles74426993retiles
retimes95020173retimes
retinas74819353retinas
retines75134673retines
retints74717013retints
retires74726213retires
retracks14149103retracks
ricks115126133__ricks
schticks19193953schticks
septics112810433septic_s
setbacks1686303setbacks
shtick15308023shtick_
shticky19344473shticky
shtiks13297833shti_ks
sicks115127623__sicks
sidekicks1542393sidekicks
slicks124816113_slicks
snicks124312473_snicks
spicks144814993_spicks
stacks124317263_stacks
stichs114511653_stichs
stick115121563_stick_
sticky154711343_sticky
stinks105616833_stinks
stirks104914243_stirks
stocks124715633_stocks
stricks134310693stricks
tacks115430133__tacks
thicks154511993_thicks
tick106231223__tick_
tics65729633__tic_s
tricks125319013_tricks
tucks114721123__tucks
unpicks1545183unpicks
unsticks1436233unsticks
untacks1357503untacks
untucks1334673untucks
uptick1436763uptick_
vertices13612283vertices
wetbacks1974983wetbacks
wicks144619363__wicks
wricks154610623_wricks
yetis85418393yeti__s
yoicks15375933_yoicks
zebecks24274193zebecks

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 Limit1340272645.98322401.3
3Display Results2642640.1102400.0
 (SQL Overall)1786912646.48327563.0
 
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.