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

181 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
etchings1439629(None) 
etching134511841etching_
itchings14386191itchings
archings14499862archings
eching126315562e_ching_
echinus1236202e_chinus
etchants1346022etchants
fetching17298412fetching_
fletchings19282862fletchings
hatchings18225672hatchings
itching134011682itching_
letching143810262letching_
retching143412172retching_
ruchings14287072ruchings
teachings15296552teachings
things104914302_t_hings
vetchlings1951702vetchlings
witchings18325302witchings
aching126521973_aching_
actings104512463_actings
archines133815253archines
arching136216693arching_
baching156017753baching_
backings174012213backings
bashings144311243bashings
batching163712093batching_
beaching164114143beaching_
belching16349153belching_
benching163411343benching_
bethinks1765043bet_hinks
bitching163610623bitching_
botching16359703botching_
breechings18273723breechings
bushings14348793bushings
caching156317503caching_
catching163712773catching_
changs125215373__changs
chinas115119403__chinas
chines115029173__chines
chinks155817573__chinks
chinos115018693__chinos
chins105631463__chin_s
chints115117833__chints
clings95716213__clings
cochins141413103cochin_s
couchings17285763couchings
cyclings1635373cyclings
deckings16346683deckings
detaching1637263detaching_
ditching15349943ditching_
ductings12346673ductings
eanlings9128473eanlings
earings84517713e_arings
earnings9419333earnings
earrings9299633earrings
eastings93412953eastings
eatings84616443e_atings
echidnas1443383e_chidnas
echini114710433e_chin_i
echoing1358613e_choing_
edgings10256243e_dgings
emptings1364823emptings
enchains1348523enchain_s
enchants1347833enchants
encinas938723enc_inas
endings92910443e_ndings
erlkings1333563erlkings
errhines1136413errhines
etamines101611813etamines
etamins91511833etamin_s
etchant1249823etchan_t
etchers123411293etch_ers
etches114217763etch__es
ethanes103713513et_hanes
ethenes103313873et_henes
ethics11169283et_hi_cs
ethinyl1343433et_hinyl
ethinyls1442873et_hinyls
ethions1038483et_hions
ethnics1236263et_hnics
ethnos947053et_h_nos
ethynes13377573et_hynes
eucaines1038513eucaines
euchring1436613euchring_
evenings1234383evenings
exchange21124323exchange
exchanges22124613exchanges
facings134511263fac_ings
fencings14225663fenc_ings
fetchingly2242723fetchingly
fettlings1353753fettlings
fishings15307693fishings
fletching18256143fletching_
hatching173312213hatching_
hatchlings1943033hatchlings
hitching173310523hitching_
hotching17309313hotching_
hutching17318643hutching_
icings9428453_ic_ings
inching134414323inching_
itchiness1444753itchiness
kachinas1736343kachinas
katchinas1843923katchinas
kvetching2242903kvetching_
lacings105013653lac_ings
lashings124412253lashings
latching143712023latching_
lathings12469853lathings
leaching143012833leaching_
leching134613653leching_
leeching14318373leeching_
lickings15298143lickings
lynchings18233503lynchings
machines15312893machines
matching163512393matching_
methinks1775193met_hinks
miching152911803miching_
moshings14367333moshings
naethings1343873naet_hings
neckings15346113neckings
nettings9288103net_tings
niching133612433niching_
notching14288583notching_
nothings12266683nothings
ouching134314903ouching_
packings174310063packings
patching163212753patching_
peaching163613643peaching_
peching154513903peching_
perching163711633perching_
pettings11349703pet_tings
pickings17359383pickings
pitching163411113pitching_
racings105015133rac_ings
reaching143317203reaching_
rethinks1576033ret_hinks
ruching133612933ruching_
rushings12387843rushings
sackings15389633sackings
sacrings11278923sacrings
settings93810073set_tings
settlings1054683settlings
sketching1935083sketching_
stagings10378343stagings
stings76220183st__ings
stockings16296093stockings
strings84617133st_rings
stylings12276233stylings
tahinis1048013_tahinis
takings124512573_takings
teaching143612603teaching_
techies12513603techi_es
technics1585463technics
technos1236183tech_nos
teethings1344233teethings
tetchiness1543583tetchiness
thatchings1942483thatchings
thing96622983_t_hing_
thinks134613363_t_hinks
thins85826333_t_hin_s
thongs104611193_t_hongs
tickings15368583tickings
tidings93810263_tidings
tilings84212793_tilings
timings10279303_timings
tings65329203_t__ings
tithings12327693tithings
tubings10336483_tubings
urchins1238863urchin_s
vetchling1843593vetchling_
washings15419273washings
watching173011173watching_
welching17287363welching_
wenching17328863wenching_
wettings12348403wet_tings
wickings18357183wickings
witching173410633witching_
yachtings1842663yachtings
zecchinos2541723zecchinos
zecchins2443533zecchin_s
zechins21137123zechin_s

Search took 9 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 Filter1786911461620.826216332.9
2DLD Change Limit1461621817.72018932.9
3Display Results1811810.0762381.6
 (SQL Overall)1786911818.62220725.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.