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

242 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
zechins2113712(None) 
zecchins2443531zecchins
zechin20137701zechin_
chins105631462__chins
cochins141413102cochins
eching126315562_eching
echini114710432_echini
echinus1236202_echinus
leching134613652leching
lectins92515002lectins
pechans14810502pechans
peching154513902peching
pectins112315232pectins
recoins94019242recoins
techies12513602techies
urchins1238862urchins
zeatins16311732zeatins
zecchin2343702zecchin_
zecchini2442382zecchini
zecchino2442662zecchino
zecchinos2541722zecchinos
zeins144715392ze__ins
acetins9313173acetins
aching126521973_aching
actins86321103_actins
archils12510533archils
archine125817053archine
archines133815253archines
arching136216693arching
archings14499863archings
archons12311583archons
arshins10312573arshins
baching156017753baching
beaching164114143beaching
becking164416073becking
beckons15279143beckons
beduins1039123beduins
begins94415303be_gins
behind1238063be_hind
behinds1335283be_hinds
belching16349153belching
benching163411343benching
benzins1838693benzins
berlins93216013berlins
bethink1677203bethink
bethinks1765043bethinks
brechans1547413brechans
caching156317503caching
cains75334303__cains
catechins1646643catechins
chains114819703__chains
chias104625523__chias
chics123920943__chics
chin96934743__chin_
china105022483__china
chinas115119403__chinas
chine105231723__chine
chines115029173__chines
chink145321593__chink
chinks155817573__chinks
chino105823313__chino
chinos115018693__chinos
chints115117833__chints
chips125721253__chips
chis95933313__chi_s
chits105424573__chits
cocains111313923cocains
cochin131313203cochin_
coins75834553__coins
cyclins1438303cyclins
deceits102810883deceits
decerns10119053decerns
decking153915593decking
deckings16346683deckings
decline103716613decline
declines113315803declines
decries103319813decries
dentins83419223dentins
detains83716093detains
deveins1138813deveins
duchies133312313duchies
eches106322163_ech_es
echidna1343723_echidna
echidnas1443383_echidnas
echoes114715523_echoes
echoing1358613_echoing
echos105216463_ech_os
elains64919853_elains
elfins94810943_elfins
eloins65419383_eloins
enchains1348523enchains
eosins64419163_eosins
etching134511843etching
etchings14396293etchings
ethics11169283_ethics
ethions1038483_ethions
fetching17298413fetching
ficins113513983fic_ins
fuchsins16104263fuchsins
gecking154111363gecking
hemins113417573he_mins
heroins103518013heroins
hins76447993___hins
inching134414323inching
itching134011683itching
itchings14386193itchings
jerkins18358253jerkins
kachina1637663kachina
kachinas1736343kachinas
kecking134111883kecking
kelvins14106563kelvins
kuchens1634713kuchens
lashins103915153lashins
leaching143012833leaching
lechers123313963lechers
leches115421313lech_es
lechwes1535063lechwes
lecithins1443983lecithins
lectin82515013lectin_
lections102413843lections
leeching14318373leeching
leggins9259473leggins
leptins92412693leptins
letching143810263letching
leucins938103leucins
levins94514653le_vins
lichens123510683lichens
lichis115212593lichi_s
lochans1248833lochans
lychnis1544383lychnis
machine14313493machine
machines15312893machines
menhirs1235913menhirs
merlins93015813merlins
meshing134513813meshing
methinks1775193methinks
miching152911803miching
mucins102712513muc_ins
necking143913893necking
neckings15346113neckings
niching133612433niching
orceins937743orceins
orchids1377213orchids
orchils1277703orchils
orchis11710773orchi_s
orcins83313433orc_ins
ouching134314903ouching
peaching163613643peaching
peahens12307573peahens
pecans101515833pec_ans
pechan13511543pechan_
pechs125516203pech__s
pecking164017783pecking
pectens11189203pectens
pectin102615533pectin_
pectines121914683pectines
peins76128063pe__ins
pekins121812233pe_kins
pepsins11310433pepsins
perching163711633perching
rachis114017653rachi_s
reaching143317203reaching
reagins84215643reagins
rechews1537293rechews
recits83621353rec_its
recking144319923recking
reckons13269653reckons
recline94020493recline
reclines103718543reclines
recoils93814873recoils
recoin84320293recoin_
recons84922993rec_ons
redfins1139923redfins
regains84316583regains
reins56234563re__ins
rejoins143111383rejoins
remains94117913remains
renins64526453re_nins
rennins74013413rennins
repins84924313re_pins
requins16310203requins
reshine102816943reshine
reshines112615443reshines
reships1239863reships
resins64528773re_sins
retains74522253retains
retching143412173retching
rethink1488883rethink
rethinks1576033rethinks
rewins95020823re_wins
richens12349733richens
ricins83618703ric_ins
ruching133612933ruching
ruchings14287073ruchings
secerns987733secerns
sections102714703sections
seisins73614393seisins
seizins164010133seizins
sequins1637863sequins
sereins73716123sereins
serins64029673se_rins
shins85131043__shins
teaching143612603teaching
teachings15296553teachings
techie11511723techi_e
techier1269243techier
techiest1359833techiest
techily1537123techily
technic1496903technic
technics1585463technics
techno1135953tech_no
technos1236183technos
techs106915833tech__s
tenpins9410073tenpins
thins85826333__thins
tocsins939963tocsins
tuchuns1233983tuchuns
unchains1338303unchains
urchin1138743urchin_
veins84620493ve__ins
venins93816703ve_nins
verdins112812333verdins
vichies15310623vichies
wechts1446253wech_ts
welching17287363welching
welkins1437173welkins
wenching17328863wenching
whins114922333__whins
withins133511693withins
yechs136112583yech__s
yeelins1038813yeelins
zayins18409713z_ayins
zeatin15412823zeatin_
zebrine1836463zebrine
zebrines1935883zebrines
zein135620603ze__in_
zephyrs2441943zephyrs
zeroing1738343zeroing
zesting174515333zesting
zins135735003z___ins
zucchini2442153zucchini
zucchinis2551563zucchinis

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272427.01319111.2
3Display Results2422420.0803025.0
 (SQL Overall)1786912427.48323879.6
 
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.