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

353 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
ethics1116928(None) 
ethic101511221ethic_
ethnics1236261ethnics
attics84413282attics
chics123920942_chics
epics95014282e_pics
ethers94518412ethers
ethical1238442ethical
ethicals1345532ethicals
ethicist1347892ethicist
ethion938812ethion
ethions1038482ethions
ethnic1148852ethnic_
ethnos947052ethnos
ethos85514192eth_os
eths76619522eth__s
ethyls1235902ethyls
etic66123952et_ic_
etuis54013132etui_s
gothics1336122gothics
metrics11312362metrics
stoics8311112stoics
thick145613352_thick
thicks154511992_thicks
thins85826332_thins
this76027382_thi_s
tics65729632_t_ics
aethers103614943aethers
ahis76135383_ahi_s
antics84621453antics
aphids125110843aphids
aphis105917133aphi_s
asdics9439863asdics
aspics104211563aspics
ataxics16196643ataxics
athirst1037873athirst
atomics113110853atomics
atonics93613713atonics
attic75618353attic_
basics104915123basics
benthic1437473benthic_
bethels1238533bethels
bethink1677203bethink
bethinks1765043bethinks
beths105519223beth__s
beylics1436183beylics
bioethics1643843bioethics
bothies12414783bothies
chias104625523_chias
chic115925203_chic_
chica125818263_chica
chicas135916473_chicas
chick165419133_chick
chicks175317593_chicks
chico124218253_chico
chicos134614833_chicos
chins105631463_chins
chips125721253_chips
chis95933313_chi_s
chits105424573_chits
civics13397823civics
colics104219903colics
comics124015563comics
conics103920593conics
cretics112911653cret_ics
cubics123810163cubics
cynics13377363cynics
darics94314113darics
details84214043details
detains83716093detains
detick1339383det_ick
deticks1437353det_icks
easies64126633easies
ebonics1137193ebonics
eches106322163ech_es
eching126315563eching
echini114710433echini
echinus1236203echinus
echoes114715523echoes
echoic1339043echoic_
echos105216463ech_os
eddies83313163eddies
edhs86212103edh__s
edict84722283e_dict
edicts94911703e_dicts
edits65819033e_dits
egis56520653e_gi_s
elains64919853elains
elfins94810943elfins
elhi7612403elhi__
eloins65419383eloins
emails84412343emails
emetics11610723emetics
emic86422753e_mic_
emirs76116163e_mirs
emits75421473e_mits
enrich1138943enrich
entails7912823entails
enterics10312853enterics
entice81316863entice
entices91616333entices
entoils7810733entoils
entries71523163entries
envies9314053envies
eosins64419163eosins
ephahs1435503ephahs
ephas10311543eph_as
ephods1238363ephods
ephors11311403ephors
epic86921303e_pic_
equids16439143equids
equips17387193equips
erethic1257723erethic_
erica7316543e_rica
ericas8315463e_ricas
erotics91914153erotics
ervils948773ervils
espies83716803espies
esthetics14106963esthetics
estrins7315853estrins
etamins91511833etamins
etapes85415293etapes
etas46432273et__as
etch95419143et__ch
etchers123411293etchers
etches114217763etches
etching134511843etching
etchings14396293etchings
eth66630983eth___
ethane94613243ethane
ethanes103713513ethanes
ethene93312923ethene
ethenes103313873ethenes
ether84518773eth_er
etheric12311783etheric_
ethician1346603ethician
ethicians1445283ethicians
ethicists1445443ethicists
ethicize2246283ethicize
ethicizes2345863ethicizes
ethinyl1343433ethinyl
ethinyls1442873ethinyls
ethmoids1444053ethmoids
ethnical1346363ethnical
ethoses10311763ethoses
ethoxies1845703ethoxies
ethoxy1933923ethoxy
ethyl1136513eth_yl
ethylic1546323ethylic_
ethyne12407153ethyne
ethynes13377573ethynes
etnas54713933et_nas
etoile6312263etoile
etoiles7411293etoiles
etudes73811603etudes
etui45416233etui__
etwees9348793etwees
euthenics1466283euthenics
evict104417143e_vict
evicts11368553e_victs
evils84114263e_vils
execs14539723e_xecs
exits125515913e_xits
exotics16229193exotics
eyries93816813eyries
fetich1479693fet_ich
flics105418363_flics
ghis85020163_ghi_s
gothic1237793gothic_
herdics13249523herdics
heroics122912003heroics
heths116317783heth__s
hic86540563__hic_
hick135530303__hick
hicks145322173__hicks
hies74842833__hies
hims95230973__hims
hins76447993__hins
hips96433703__hips
his66359503__hi_s
hiss75629213__hiss
hits75545133__hits
ionics84214483ionics
italics936993italics
jetties143613123jetties
khis117017983_khi_s
laics76419253_laics
lathis95516173lathi_s
lethals1038113lethals
lethes94818083leth_es
lithias1038823lithias
lithic1139493lithic_
logics95711123logics
luetics937323luet_ics
lyrics11357943lyrics
magics115311613magics
manics103919933manics
medics114115353medics
menhirs1235913menhirs
methinks1775193methinks
methods1338893methods
meths105320233meth__s
methyls1535453methyls
metis75025903met_i_s
metric10314683metric_
mics87435153__mics
mimics1289363mimics
musics103911783musics
mythic1637273mythic_
nihils937573nihils
ohias84415573_ohias
optics102810183optics
osmics1036463osmics
others93918003others
otic66624823ot_ic_
outhits102213503outhits
panics103815363panics
pelvics14245643pelvics
peptics132610243peptics
phis95724903_phi_s
pics85633913__pics
poetics11312073poet_ics
relics84517903relics
reships1239863reships
retails74718973retails
retains74522253retains
rethink1488883rethink
rethinks1576033rethinks
reties65436193ret_ies
retries74129073retries
retrims93612373retrims
sahibs1137083sahibs
septics112810433septics
shies86136553_shies
shims104422553_shims
shins85131043_shins
ships105123773_ships
shits84731173_shits
shivs115018803_shivs
shtick15308023shtick
shticks16356963shticks
shtiks13297833shtiks
sics65234093__sics
sonics84315633sonics
spics94123243_spics
staigs75414813staigs
stains64923653stains
stairs65416333stairs
statics93314533statics
steins64818343steins
stich104117923st_ich
stichs114511653st_ichs
stick115121563st_ick
sticks125118613st_icks
sties55132983st_ies
stirs55921623st_irs
stoic7317253stoic_
strick124813203strick
stricks134310693stricks
strict84821043strict
strips85719653strips
tails55634193_tails
tains54936323_tains
talcs74817183_talcs
techies12513603techies
technics1585463technics
teiids736693teiids
telic76019823telic_
tenias64720073tenias
tetanics10127373tetanics
tethers103815313tethers
teths85418513teth__s
tetris62816293tetri_s
thack144915173_thack
thacks154311923_thacks
thaws116515463_thaws
theca103311453_theca
theins95015423_theins
theirs94610353_theirs
thens85921833_thens
thews117416193_thews
thief114516303_thief
thigh12410123_thigh
thighs1346633_thighs
thill85918733_thill
thills95515383_thills
thin76732393_thi_n
thine85026863_thine
thing96622983_thing
things104914303_things
think125018803_think
thinks134613363_thinks
thio77225413_thi_o
thiol87616043_thiol
thiols95112763_thiols
thir76420543_thi_r
third95912493_third
thirds10438603_thirds
thirl85416823_thirl
thirls95012063_thirls
thirst9312253_thirst
thous86017263_thous
thrice114311573_thrice
thrips11299013_thrips
thuds95110133_thuds
thugs95611993_thugs
thus76721473_th_us
tic56343463_t_ic_
tick106231223_t_ick
ticks115823293_t_icks
ties45248313_t_ies
tils45739613_t_ils
tins45251303_t_ins
tips66436763_t_ips
tis37056643_t_i_s
tits46145043_t_its
toils54527493_toils
toits55327473_toits
tonics83617863tonics
topics104714583topics
torcs75123763_torcs
torics85118353torics
toxics153910203toxics
triacs83913223_triacs
trice75127493_trice
trices84826333_trices
trick115420693_trick
tricks125319013_tricks
tries55742813_tries
trigs65423063_trigs
trims75021473_trims
trios55528093_trios
trips74923363_trips
tuis44829643_tui_s
tunics83811263tunics
twice104711123_twice
twigs96911173_twigs
twins85118983_twins
twits86015793_twits
vitrics12198553vitrics
wethers135214693wethers
which163910083_which
whids125413983_whids
whigs125612643_whigs
whims134515333_whims
whins114922333_whins
whips134917083_whips
whirs115218093_whirs
whits115923823_whits
withies133913543withies
withins133511693withins
yetis85418393yet_i_s
zechins21137123zechins

Search took 8 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.373479064.3
2DLD Change Limit1127163537.22015611.6
3Display Results3533530.1232869.9
 (SQL Overall)1786913537.71623158.5
 
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.