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

243 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
ciliates1041345(None) 
ciliate9514601ciliate_
ciliated11510951ciliated
filiates11412661filiates
califates14310112califates
celibates1358632celibates
ciliately1443962ciliately
cilices113814022cili_ces
citrates102315092citrates
climates12311972climates
collates103019142collates
dilates83220662dil_ates
filiate10414232filiate_
filiated12610082filiated
foliates11412752foliates
militates11310882militates
silicates11311522silicates
vitiates112311432vitiates
ablates92416903abl_ates
acclimates1645913acclimates
acierates11310813acierates
acylates1339743acyl_ates
affiliates1644893affiliates
airdates939723airdates
alates64833973_al_ates
aliases7914493_aliases
aplites9314933apli_tes
aviates10313063_aviates
blites84721213_bli_tes
calcites12313003calcites
calibrates1446963calibrates
calibres1237103calibres
calices114321693cali_ces
caliches153812273caliches
calicles123811433calicles
calicoes123911603calicoes
califate13310483califate_
calipees1247413calipees
caliphates1745133caliphates
calottes10610083calottes
capiases1239253capiases
carates95630613c_arates
caseates10313713caseates
cates75951893c___ates
caudates11310263caudates
caviares1337993caviares
cavitates14168963cavitates
celestes10310013celestes
celiacs11157893celia_cs
celibate1259313celibate_
cellmates1347513cellmates
cerates95428253c_erates
cerites94823433ceri_tes
chelates132713853chelates
chiliads1445853chilia_ds
chiliasms1693493chiliasms
chiliasts14134343chiliasts
chilies124218303chili__es
chlorates142512273chlorates
cholates132414763cholates
cilia73016763cilia___
ciliary1247923cilia_ry
ciliation111112493ciliation
ciliations121111003ciliations
cilice103213353cili_ce_
ciliolate1145973ciliolate_
cimices13279803cimi_ces
cineastes1165563cineastes
cirrate92413493cirrate_
cites74435593c__i_tes
cities84524853citi__es
citifies13310683citifies
citrate92216803citrate_
citrated112712253citrated
civies114116443civi__es
clades94920463c_l_ades
claves115020063c_l_aves
cleated103417843c_leated
cleats84919313c_leat_s
cleaves124111623c_leaves
cliches144213743c_liches
clifts11519153c_lift_s
climate11312833climate_
climaxes1944613climaxes
climes104720003c_li_mes
clines84926043c_li_nes
cliques18309203c_liques
cogitates1247863cogitates
cognates11311583cognates
coinmates1348343coinmates
colies84837053coli__es
colitis92617353coli_tis
collages113514243collages
collate92919683collate_
collated113615063collated
colligates1347713colligates
collimates1447973collimates
colocates13312853colocates
comates114123643c_omates
conciliates1546883conciliates
craniates11310653craniates
crates85736063c__rates
creates95225203c_reates
cremates124216003cremates
criminates1448003criminates
crinites10612763crini_tes
culices113713123culi_ces
culminates1447053culminates
culottes1076293culottes
cultivates1546513cultivates
curates95323833c_urates
curites93919863curi_tes
cyanates13238433cyanates
cylices14359283cyli_ces
delates83526283del_ates
delicates12314313delicates
deviates12312733deviates
dictates11311383dictates
dilate73220693dil_ate_
dilated93115823dil_ated
dilater83515653dil_ater
dilaters92513063dil_aters
dilutes82911973dil_utes
disrates91118153disrates
elates65032363_el_ates
elites66027123_eli_tes
eluates72014683_eluates
epilates10313503epil_ates
expiates17810213expiates
facilitates1644303facilitates
fellates11312753fellates
filister1137403filister
filisters1237003filisters
filtrates1247733filtrates
finites10315923fini_tes
fixates1737393fi_xates
flites95122443_fli_tes
folates103218453fol_ates
foliages1247623foliages
foliate10513533foliate_
foliated1249913foliated
gallates92815533gallates
gelates83219593gel_ates
goliaths1244223goliaths
halites103221193hali_tes
humiliates1544623humiliates
ideates8313733_ideates
iliads7448673_ilia_ds
illites72415013_illites
imitates10310503_imitates
ingates82716913_ingates
initiates9411183initiates
inmates92715783_inmates
iodates8312903_iodates
iolites73819483ioli_tes
kalifates1646133kalifates
labiates101011513labiates
lianes63819323__lianes
librates103412953librates
ligates82318383li_gates
lilies63021413lili__es
limites92915453limi_tes
liquates1737453liquates
litigates1048003litigates
malates93522613mal_ates
maleates103316343maleates
mediates112814063mediates
migrates111112853migrates
milages103114403mil_ages
mileages11249693mileages
militate10311673militate_
militated1248803militated
millages113212903millages
milliares1149403milliares
misdates111113633misdates
mismates121114563mismates
misrates101318243misrates
mitigates1248253mitigates
muriates10312083muriates
nictates1039593nictates
nidates8311893ni_dates
niobates1037283niobates
nitrates82516223nitrates
oblates91913243obl_ates
obligates12207853obligates
obviates1345153obviates
oleates7417833_oleates
oolites72817843ooli_tes
opiates9312143_opiates
oscillates1244773oscillates
palates93624943pal_ates
palliates11311033palliates
palpates122613063palpates
pelites93821993peli_tes
picrates122013213picrates
pileate93815923pileate_
pileated112711133pileated
pillages113012613pillages
pinites9319533pini_tes
pirates93020333pi_rates
plates85432243_pl_ates
pulsates1048813pulsates
radiates92415293radiates
relates73731433rel_ates
salivates1239293salivates
satiates8314633satiates
seriates82620673seriates
sibilates1148443sibilates
silages82514443sil_ages
silanes72517163sil_anes
silicate10312623silicate_
silicles1037073silicles
siliques1745353siliques
sinuates8310963sinuates
situates8310373situates
slates64934063_sl_ates
solates73523853sol_ates
solvates11249673solvates
spoliates1138543spoliates
striates83417083striates
sulfates11310793sulfates
tailgates1046533tailgates
tillages93011263tillages
tillites8312833tillites
titivates1246433titivates
titrates82314663titrates
toluates8138903toluates
unciliated1348053unciliated
vacillates1555723vacillates
validates1338243validates
valuates112811203valuates
variates111214983variates
velites103417303veli_tes
vibrates132210613vibrates
vilifies1439593vilifies
villages123010603villages
violates11311193violates
virgates1237923virgates
vitiate103412953vitiate_
vitiated12289223vitiated
vizirates2144663vizirates
vulgates12237233vulgates
zincates1937743zincates

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.423422437.4
2DLD Change Limit1461622437.51619446.8
3Display Results2432430.0932612.9
 (SQL Overall)1786912438.03222247.4
 
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.