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

120 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
ethnics123626(None) 
ethics11169281eth_ics
ethnic1148851ethnic_
atonics93613712atonics
ebonics1137192ebonics
ethic101511222eth_ic_
ethnical1346362ethnical
ethnos947052ethn_os
euthenics1466282euthenics
technics1585462technics
tetanics10127372tetanics
tonics83617862_tonics
tunics83811262_tunics
aphonics15259523aphonics
asthenics1486403asthenics
ataxics16196643ataxics
atomics113110853atomics
atonias73315993atonias
atonic83420473atonic_
atonies75320953atonies
attics84413283at_tics
bethinks1765043bethinks
betonies10413063betonies
bionics114310873bionics
chics123920943_ch_ics
clinics11338743clinics
conics103920593_conics
cynics13377363_cynics
ebonies9312883ebonies
echinus1236203echinus
echoic1339043echoic_
edenic9310223edenic_
emetics11610723emetics
enterics10312853enterics
epics95014283e__pics
erotics91914153erotics
esthetics14106963esthetics
etamins91511833etamins
etchings14396293etchings
ethanes103713513ethanes
ethanols1144333ethanols
ethenes103313873ethenes
etheric12311783etheric_
ethers94518413eth_ers
ethical1238443eth_ical
ethicals1345533eth_icals
ethicist1347893eth_icist
ethinyl1343433ethinyl
ethinyls1442873ethinyls
ethion938813eth_ion
ethions1038483ethions
ethmoids1444053ethmoids
ethnarch1642413ethnarch
ethnarchs1751773ethnarchs
ethnicity1744593ethnicity
ethnoses1146083ethnoses
ethos85514193eth__os
ethoses10311763ethoses
ethoxies1845703ethoxies
eths76619523eth___s
ethylic1546323ethylic_
ethyls1235903eth_yls
ethynes13377573ethynes
ethynyls1741873ethynyls
etic66123953et__ic_
etnas54713933et_n_as
etuis54013133et_ui_s
eugenics1146583eugenics
euphenics16115363euphenics
exonic153211413exonic_
exotics16229193exotics
gothics1336123goth_ics
hedonics1445903hedonics
ionics84214483_ionics
irenics937833irenics
italics936993italics
ketonic1349923ketonic_
manics103919933_manics
mechanics1845983mechanics
melanics1237733melanics
methinks1775193methinks
metrics11312363met_rics
nonethnics1553423nonethnics
ovonics12245553ovonics
panics103815363_panics
petunias1066013petunias
phonics143110723phonics
picnics13297343picnics
pyknics1842483pyknics
rethinks1576033rethinks
scenics1137773scenics
sonics84315633_sonics
statics93314533statics
sthenias1178163sthenias
sthenic1268903sthenic_
stoics8311113st_oics
technic1496903technic_
tectonics1345953tectonics
tenias64720073_tenias
tennies73017973tennies
tennis64015303tenni_s
tetanic9810133tetanic_
tetanies8513553tetanies
theins95015423_theins
theirs94610353_theirs
thick145613353_th_ick
thicks154511993_th_icks
things104914303_things
thinks134613363_thinks
thins85826333_th_ins
this76027383_th_i_s
thrice114311573_thrice
thrips11299013_thrips
tics65729633_t__ics
tonic74727653_tonic_
topics104714583_topics
torics85118353_torics
toxics153910203_toxics
tunic74018223_tunic_
tunica8379813_tunica

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.406440125.6
2DLD Change Limit1340271205.81323056.4
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.26528522.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.