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 “citational” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

221 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
citational126646(None) 
agitational1244842agitational
binational1246372binational
citation10314362citation__
citations11312502citation_s
mutational1246512mutational
notational1048122notational
nutational1047042nutational
rotational1048092rotational
situational1144582situational
stational948512_stational
coitional1148693c_oitional
dictional1268613di_ctional
dilatational1352773dilatational
equational1945603equational
fictional1477803fi_ctional
gestational1245113gestational
gyrational1444743gyrational
ideational1146503ideational
invitational1554903invitational
irrational1047213irrational
lactational1344653lactational
levitational1553633levitational
librational1344553librational
limitational1453543limitational
locational1246593locational
migrational1444743migrational
national8311533__national
negational1147153negational
ovational1246853_ovational
rational8412543__rational
relational1047713relational
vibrational1644363vibrational
vocational1546953vocational
adaptational1572794adaptational
additional1244644additional
agitation10311224agitation__
agitations11310064agitation_s
antinational1297474antinational
antirational1278474antirational
arbitrational1553184arbitrational
aspirational1455004aspirational
atonal6514024___at_onal
attentional1154204attentional
attritional1154244attritional
avocational1645184avocational
bisectional1554644bisectional
cantonal1038904c__antonal
capitation14311364capitation__
capitations1549854capitation_s
carinal94318234c__ari_nal
catatonia1145474catat_onia
catatonias1255414catat_onias
catatonic1346094catat_onic
cathodal14155414c__athodal
cation83925504c__ation__
cationic12310014c__ationic
cations94524144c__ation_s
cavatina1347334cavati_na_
cavatinas1444784cavati_nas
cavitation1549134cavitation__
cavitations1647844cavitation_s
cicatricial1451764cicatricial
ciliation111112494ciliation__
ciliations121111004ciliation_s
cisternal11325744ci_sternal
citator9310124citat_o__r
citators10310254citat_o_rs
citatory1347214citat_o_ry
cogitation13410084cogitation__
cogitations1448904cogitation_s
cognitional1454274cognitional
combinational1984084combinational
computational1994574computational
conation101420884conation__
conations111318904conation_s
conditional1447114conditional
connotational1554154connotational
contractional1756064contractional
creation102816514creation__
creations112614544creation_s
declinational1652924declinational
derivational1654264derivational
devotional1444674devotional
diaconal1196134di_a_conal
diagonal1095654di_a_gonal
dictation12810564dictation__
dictations1389704dictation_s
dilation92215464dilation__
dilations102614454dilation_s
directional1445444directional
distortional1353484distortional
divisional1453954divisional
dotation91412734dotation__
dotations101411634dotation_s
educational1444874educational
emotional1146664_emotional
evasional1244294_evasional
excavational2452764excavational
excitation19410174excitation__
excitations2049004excitation_s
factional1478764_factional
fetation11613144fetation__
fetations12511384fetation_s
fissional1245124fi_ssional
fixation1837074fixation__
fixations1936354fixation_s
fractional1547134fractional
frictional1546254frictional
functional15116674functional
gradational1354474gradational
gravitational1762554gravitational
himation1339754himation__
himations1438804himation_s
imaginal1144904_imagi_nal
imitation11510854imitation__
imitations1259964imitation_s
incantational1553564incantational
incitation12312224incitation__
incitations13310884incitation_s
inclinational1553934inclinational
indicational1545754indicational
intentional11128844intentional
intonational1256004intonational
intuitional1155294intuitional
invitationals1652744invitationals
irrationals1154734irrationals
irrotational1254024irrotational
junctional19105364junctional
libation102411364libation__
libationary1672164libationary
libations112510444libation_s
ligation92313094ligation__
ligations102111994ligation_s
littoral845274lit_t_oral
matinal9312604__mati_nal
matronal1048114__matronal
maturational1454184maturational
matutinal1143184matuti_nal
mediational1445644mediational
missional1146064mi_ssional
motional1058674__motional
motivational1753914motivational
mutation101412884mutation__
mutationally1754274mutationally
mutations111211454mutation_s
narrational1145444narrational
natation81513934natation__
natations91412494natation_s
nationals948864__nationals
navigational1653294navigational
nictation1189274nictation__
nictations1278314nictation_s
nidation9410584nidation__
nidations1039214nidation_s
nitration9313444nitration__
nitrations10312034nitration_s
nonnational11107834nonnational
nonrational11109124nonrational
notation81414604notation__
notations91512974notation_s
notional849404__notional
nutation81513104nutation__
nutations91411764nutation_s
nutritional1154784nutritional
occasional1453374occasional
occupational1883004occupational
octagonal1242644octa_gonal
operational1347524operational
optional1047644__optional
orientational1353804orientational
oscillational1552224oscillational
patronal1048654__patronal
piratical1348654pirati_cal
positional1247904positional
potation101716784potation__
potations111615074potation_s
probational1547084probational
radiational1245954radiational
rationale949464__rationale
rationals949944__rationals
recitation12315944recitation__
recitations13314204recitation_s
recreational1455174recreational
redactional1454354redactional
reputational1474584reputational
rotation81615454rotation__
rotations91613844rotation_s
salutational1253324salutational
salvational1443714salvational
sectional1149424_sectional
sensational1146384sensational
siltation939214siltation__
siltations1038554siltation_s
situation949424situation__
situationally1653394situationally
situations1038434situation_s
speciational1654314speci_ational
staminal1046984_stami_nal
statical1039424_stati_cal
station72717244_station__
stationary1354154_stationary
stationed1046144_stationed
stationer946034_stationer
stations82415224_station_s
subnational1354574subnational
subrational1345494subrational
suctional1147684_suctional
summational1553684summational
titration9310544titration__
titrations1039174titration_s
tractional1248054tractional
tuitional946054_tuitional
valuational1444044valuational
variational1444774variational
vegetational1653374vegetational
viatical1347064vi_ati_cal
visional1146664vi__sional
vitiation1239564vitiation__
vitiations1338744vitiation_s
volitional1345414volitional

Search took 12 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 Filter1786911614500.436409841.7
2DLD Change Limit16145022111.14314488.9
3Display Results2212210.1102009.1
 (SQL Overall)17869122111.68915287.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.