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

133 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
kyanites1521668(None) 
cyanites132610161cyanites
kyanises15206391kyanises
kyanite14237311kyanite_
kyanizes24205281kyanizes
cyanates13238432cyanates
cyanides14258002cyanides
cyanines132710542cyanines
cyanite122710762cyanite_
granites92116362granites
hyalites14208832hyalites
kainites1238792kainites
kernites1269112kernites
khanates1535732khanates
kyanise14236142kyanise_
kyanised16214162kyanised
kyanize23265342kyanize_
kyanized25224552kyanized
syenites1138942syenites
uranites82514642uranites
aconites10314353aconites
alanines8314803alanines
allanites949803allanites
alunites8310703alunites
amanitas1048533amanitas
animes84719593__animes
anises64826693__anises
antes56334323__an_tes
apatites10311293apatites
aphanites1448263aphanites
arenites8917103arenites
axites134913833__axites
banties94324763_banties
barites94322333_barites
beanies93821093beani_es
bornites10310983bornites
braunites1146723braunites
byrnies12378573byrni_es
canines93724033_canines
canities101519263_canities
chanties132615803chanties
craniates11310653craniates
crinites10612763crinites
cyanate12259703cyanate_
cyanide13298843cyanide_
cyanided15254893cyanided
cyanids13297933cyani_ds
cyanine122911513cyanine_
cyanins122910013cyani_ns
cyanitic1566323cyanitic
cyanoses1337423cyanoses
dacites101114593_dacites
dunites8313593_dunites
dunnites947173dunnites
dynamites1544623dynamites
ebonites1039233ebonites
egalites9310503egalites
emanates10311333emanates
fayalites1546063fayalites
finites10315923_finites
gahnites1235703gahnites
granitas92610223granitas
granite82017083granite_
guanines989773guanines
gunites8313123_gunites
halites103221193_halites
hyalines14169333hyalines
hyalite13229473hyalite_
ichnites1345743ichnites
ignites81310583_ignites
inanities9312443inanities
kainite1149543kainite_
kainits1137763kainit_s
kamacites1744523kamacites
kanes95529373k_an__es
karates115617473k_arates
kentes105118643k_en_tes
kernite1159473kernite_
keynotes1543633keynotes
khanate1437073khanate_
kites95432543k___ites
knifes136210213k__nifes
knits93914743k__nit_s
knives13458553k__nives
kraits104912203kra_it_s
kryolites1643993kryolites
kunzites2143243kunzites
kyats125012443kya__t_s
kylikes1333583ky_likes
kyries133411373ky_ri_es
kytes125012913ky___tes
lenites7818443_lenites
lignites9129613lignites
lyddites1342583lyddites
manitos9314053_manitos
manitus9310923_manitus
mannites10312613mannites
mantes84430783_man_tes
meanies93620743meani_es
melanites11410723melanites
mylonites1446443mylonites
nites55736343___nites
panties94230933_panties
pinites9319533_pinites
pyrites12812203py_rites
ratites74920683_ratites
reunites8312473reunites
samites93118713_samites
sanies63031953_sani_es
sanities81219773_sanities
scanties103215423scanties
shanties113116583shanties
sienites8311913sienites
skywrites1952763skywrites
stanines85115673stanines
stannites947023stannites
sybarites1465933sybarites
syenite1039773syenite_
sylvanites1643283sylvanites
sylvites14225843sylvites
taxites1449673_taxites
titanites997413titanites
tympanites1743223tympanites
umangites1244483umangites
unakites1237543unakites
unites65024853__unites
uralites82112723uralites
uranides92211283uranides
uranite72515693uranite_
urbanites11105913urbanites
vanities111414493_vanities
yentes95517603_yen_tes
zanies153219673_zani_es

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621337.62319173.8
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.85922737.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.