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

119 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
cyclase143661(None) 
cyclases1537131cyclases
cycas126513822cyc_as_
cycases1437532cyc_ases
cyclamen1763962cyclamen
cycle1239522cycl__e
cycles1339302cycles_
cyclist1438852cyclist
cyclize2345402cyclize
cyclone1437242cyclone
cyclos1338072cyclos_
cycloses1538182cycloses
euclase938932euclase
acylate12310533acy_late
amylase1237023amylase
beclasp1335263beclasp
blase75524233__blase
cacas95627983cac_as_
calash11312433c_alash
callas84526753callas_
callose9313663callose
carcase11312743carcase
case65848083__c_ase
casease939323casease
catalase1039223catalase
cease75227653__cease
cellae84915933cella_e
chase105127123__chase
chelae113614603chela_e
chelas113817203chelas_
chelate122914893chelate
cholas114818003cholas_
cholate122114933cholate
cicalas1139303cicalas_
cicale10314503cic_ale
clade85821013__clade
clash106219033__clash
clasp95517193__clasp
class75525483__class
clast76030583__clast
clause84311503__clause
clave105420153__clave
close76425223__close
coalas87418963coalas_
cocas95926573coc_as_
cockade1638133cockade
cocoas104915743cocoas_
colas75436773c_olas_
collage102813763collage
collapse1244273collapse
collate92919683collate
conclave1556403conclave
crease85519573c_rease
cutlas8313103cutlas_
cutlases1038033cutlases
cutlass938013cutlass
cyanate12259703cyanate
cycad13507273cyc_a_d
cycads14476213cyc_ads
cycasin1445903cyc_asin
cyclamate1843793cyclamate
cyclamens1863013cyclamens
cycled1436543cycl_ed
cycler1335913cycl_er
cyclers1435873cyclers
cyclery1763493cyclery
cyclic1238033cycl_ic
cyclin1339273cycl_in
cycling1537213cycling
cyclins1438303cyclins
cyclists1545713cyclists
cyclized2544943cyclized
cyclizes2445523cyclizes
cyclo1237703cycl__o
cycloid1539283cycloid
cyclones1537483cyclones
cyclopes1746263cyclopes
cyclops1635383cyclops
cyclosis1547473cyclosis
cymae126713013cy_ma_e
cymas126417883cy_mas_
cymose13429653cy_mose
decease1049523decease
declare10411223declare
declass1038733declass
declasse1165943declasse
encase83714363enc_ase
enchase1239463enchase
enclasp1145843enclasp
enclave1257533enclave
enclose999993enclose
enolase7310193enolase
euclases1039223euclases
exclave1945193exclave
eyelash1344563eyelash
gyrase10508773gy_rase
hydrase14287663hydrase
hylas114815903hy_las_
incase83615283inc_ase
inclasp1145303inclasp
inclose9910223inclose
inulase739413inulase
lactase937963lactase
lase46148513___lase
lyase85512413ly__ase
lycras11287253lycras_
nuclease1046213nuclease
nyalas936903nyalas_
pectase112410363pectase
reclame11411063reclame
reclasp1136643reclasp
recluse95210773recluse
sucrase9310343sucrase
uncase83817433unc_ase
unclasp1135963unclasp
unclose91111643unclose
xylose1636763xy_lose
yclad11246383_ycla_d
zymase201997483zy_mase

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 Limit1340271195.83022989.2
3Display Results1191190.0462587.0
 (SQL Overall)1786911196.28228444.9
 
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.