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

132 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
kyanises1520639(None) 
kyanise14236141kyanise_
kyanised16214161kyanised
kyanites15216681kyanites
kyanizes24205281kyanizes
anises64826692__anises
cyanides14258002cyanides
cyanines132710542cyanines
cyanites132610162cyanites
cyanoses1337422cyanoses
kyanite14237312kyanite_
kyanize23265342kyanize_
kyanized25224552kyanized
abatises10311013abatises
adonises92611433adonises
agonises92613163agonises
alanines8314803alanines
animes84719593__animes
anise55129703__anise_
anuses66218773__anuses
arises65233803__arises
axises134413993__axises
banishes131812463_banishes
beanies93821093beani_es
botanises1139163botanises
braises93818873bra_ises
byrnies12378573byrni_es
camises114218463_camises
canines93724033_canines
chaises124317493cha_ises
chamises153513313chamises
cognises11610043cognises
cyanates13238433cyanates
cyanide13298843cyanide_
cyanided15254893cyanided
cyanids13297933cyani_ds
cyanine122911513cyanine_
cyanins122910013cyani_ns
cyanite122710763cyanite_
cyanosed1444613cyanosed
cyanosis1346273cyanosis
daises74318983_da_ises
danishes121710493_danishes
ebonises1039223ebonises
evanishes1545603evanishes
eyases94513683eya__ses
eyasses10388023eya_sses
finises10312903_finises
fraises104215693fra_ises
glacises1138503glacises
granites92116363granites
guanases936233guanases
guanines989773guanines
hanses95022633_han_ses
humanises1448313humanises
hyalines14169333hyalines
hyalites14208833hyalites
hybrises1645423hybrises
hymnists1644903hymnists
hypnoses1646633hypnoses
ionises72916433_ionises
kainites1238793kainites
kaiser103610373k_a_iser
kaisers11369273k_a_isers
kanes95529373k_an__es
kermises14248313kermises
kernites1269113kernites
khanates1535733khanates
kinases113511123k_inases
kineses113111253k_ineses
knifes136210213k__nifes
knishes1438263k__nishes
knives13458553k__nives
koumises1444593koumises
krises105016083k__rises
kvases13467103kva__ses
kvasses14365503kva_sses
kyanising1743873kyanising
kylikes1333583ky_likes
kyphoses2045283kyphoses
kyries133411373ky_ri_es
lapises93513463_lapises
liaises7311053lia_ises
lionises8310313lionises
lyases95211873lya__ses
lychnises1743763lychnises
manses84225513_man_ses
mantises10317923_mantises
mavises122812993_mavises
meanies93620743meani_es
myases113711553mya__ses
nanisms938833_nanisms
onanisms1048063onanisms
onanists838413onanists
organises1048683organises
oxalises1538503oxalises
ozonises1776373ozonises
paganises1239723paganises
pansies94521983_pansies
parises94827183_parises
pavises125315493_pavises
penises9318193_penises
pianisms1249013pianisms
pianists1049013pianists
planishes14138523planishes
praises94121103pra_ises
praxises1739063praxises
pycnoses1554973pycnoses
pyknoses1783573pyknoses
pyranoses1445853pyranoses
raises64826543_ra_ises
realises82420183realises
romanises11311573romanises
sanies63031953_sani_es
stanines85115673stanines
syenites1138943syenites
synapses1344713synapses
tamises92715973_tamises
tanists7313653_tanists
tansies74521243_tansies
tapises92914013_tapises
tennises82810133tennises
tetanises979873tetanises
tyrannises1383973tyrannises
uranides92211283uranides
uranisms1099973uranisms
uranites82514643uranites
urbanises11106643urbanises
valises103516263_valises
vanishes141610753_vanishes
womanises1448063womanises
zanies153219673_zani_es

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621326.47022590.7
3Display Results1321320.0632095.2
 (SQL Overall)1786911326.95325699.8
 
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.