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

238 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
ciliated1151095(None) 
ciliate9514601ciliate_
ciliates10413451ciliates
filiated12610081filiated
ciliately1443962ciliately
citrated112712252citrated
cleated103417852c_leated
collated113615062collated
dilated93115822dil_ated
filiate10414232filiate_
filiates11412662filiates
foliated1249912foliated
militated1248802militated
pileated112711132pileated
unciliated1348052unciliated
vitiated12289222vitiated
ablated102513443abl_ated
acclimated1745153acclimated
acierated1238303acierated
aculeated1247733aculeated
acylated1437883acyl_ated
affiliated1744193affiliated
airlifted1343193airlifted
alated75625153_al_ated
aviated11310263_aviated
belated103520013bel_ated
billeted1137643billeted
bilobated1444973bilobated
bilsted1038033bil_sted
bleated104015973_bleated
bloated104513433_bloated
calibrated1545653calibrated
calibred1335053calibred
califate13310483califate_
califates14310113califates
capitated14159043capitated
carinated123414273carinated
caseated11310723caseated
caudated1238063caudated
caveated1439143caveated
cavitated15177353cavitated
ceilinged1342373ceilinged
celibate1259313celibate_
celibates1358633celibates
cellared11398803cellared
cerated103922473c_erated
cheated134416353c_heated
chelated142610493chelated
chiliad1337563chilia__d
cilia73016763cilia___
ciliary1247923cilia_ry
ciliation111112493ciliation
cilice103213353cili_ce_
cilices113814023cili_ces
ciliolate1145973ciliolate_
cirrate92413493cirrate_
cisted95217523c__isted
cited84421953c__i_ted
citied94014143citi__ed
citified1438253citified
citrate92216803citrate_
citrates102315093citrates
claimed12298833c_laimed
clawed125115073c_l_awed
clayed125013043c_l_ayed
cleaned103512003c_leaned
cleared103612463c_leared
cleaved134010483c_leaved
clefted13326763c_lefted
cliched153711023c_liched
clicked164112453c_licked
climate11312833climate_
climates12311973climates
climaxed2043113climaxed
climbed14336983c_limbed
clinged113310093c_linged
clinked144011643c_linked
clipped14439833c_lipped
cliqued19266683c_liqued
cloaked14368543c_loaked
clotted104011823c_lotted
clouted104212163c_louted
coated94927043c__oated
cogitated1346323cogitated
collaged12279973collaged
collared113211143collared
collate92919683collate_
collates103019143collates
colleted113011663colleted
colligated1446273colligated
collimated1556083collimated
colocated1439613colocated
combated1539823combated
conciliated1645643conciliated
crated94827773c__rated
created104323463c_reated
cremated133412963cremated
crenated113013913crenated
criminated1546823criminated
crispated1445023crispated
cristated1247423cristated
culminated1546103culminated
cultivated1645673cultivated
cultrated1248233cultrated
cuneated11310103cuneated
curated104717583c_urated
cuspated1335913cuspated
delated93722873del_ated
delisted10310563delisted
deviated13311043deviated
dictated1239203dictated
digitated1286963digitated
dilate73220693dil_ate_
dilater83515653dil_ater
dilates83220663dil_ates
diluted9248933dil_uted
disrated10915573disrated
elated74725823_el_ated
enlisted978193enlisted
epilated11310753epil_ated
expiated18168523expiated
facilitated1753643facilitated
falcated1438483falcated
fellated1239563fellated
fileted1159093fil_eted
filister1137403filister
filleted1236603filleted
filtrated1345963filtrated
finialed1255503finialed
fixated1835533fi_xated
flinted114411893_flinted
flirted11428673_flirted
flited104616583_fli_ted
flitted114011643_flitted
floated113312703_floated
foliaged1344673foliaged
foliate10513533foliate_
foliates11412753foliates
galeated104111583galeated
gelated93615643gel_ated
glinted9399373_glinted
gloated93511533_gloated
hilted104016043hil__ted
humiliated1643983humiliated
ideated9310973_ideated
iliad64613463_ilia__d
imitated1138263_imitated
initiated10510113initiated
iodated9310023_iodated
jilted144111353jil__ted
kilted113613833kil__ted
labiated11109303labiated
lariated91212063lariated
lated65240673__l_ated
librated113110313librated
lifted104413523__lifted
ligated92414143li_gated
lilied73913213lili__ed
lilted73715373__lilted
limited102310233limi_ted
lineated9711063lineated
linted74021823__linted
liquated1835493liquated
listed74322833__listed
litigated1146563litigated
mediated123011873mediated
migrated121110513migrated
militate10311673militate_
militates11310883militates
milted93919943mil__ted
misdated121211123misdated
mismated131111333mismated
misrated111315383misrated
mitigated1347083mitigated
muriated1139793muriated
nictated1137793nictated
nidated939863ni_dated
nitrated92213153nitrated
obligated13186903obligated
obviated1444563obviated
ocellated1245453ocellated
opiated1039483_opiated
oscillated1343853oscillated
palliated1238503palliated
palmated132511003palmated
palpated13249763palpated
picrated132110113picrated
pileate93815923pileate_
pillaged12298093pillaged
pillared11228093pillared
piloted10310323pil_oted
pinnated11338553pinnated
pirated102515613pi_rated
pixilated1944543pixilated
plaited103713893_plaited
plated95225773_pl_ated
pleated103816633_pleated
plicated13310643plicated
pulsated1136853pulsated
radiated102512593radiated
related83327573rel_ated
relisted9312623relisted
salivated1337473salivated
satiated9311603satiated
seriated92717023seriated
sibilated1246713sibilated
silicate10312623silicate_
silicates11311523silicates
silted74020013sil__ted
sinuated938413sinuated
situated938033situated
slated75028313_sl_ated
slitted83513313_slitted
solated83618023sol_ated
solvated12237443solvated
splinted11369253splinted
spoliated1246913spoliated
striated93414153striated
sulcated11310373sulcated
sulfated1238833sulfated
tailgated1145133tailgated
tilted74616863til__ted
titivated1345443titivated
titrated92611683titrated
tritiated1047523tritiated
unlisted9311153unlisted
uplifted1454423uplifted
vacillated1654633vacillated
validated1446493validated
valuated12239203valuated
variated121211393variated
vibrated14228393vibrated
vilified1547243vilified
violated1237883violated
visited1168773visi_ted
vitiate103412953vitiate_
vitiates112311433vitiates
wilted103915713wil__ted

Search took 10 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 Limit1461622388.51617163.2
3Display Results2382380.1102163.6
 (SQL Overall)1786912389.04619753.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.