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

227 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
citations1131250(None) 
citation10314361citation_
agitations11310062agitations
capitations1549852capitations
cations94524142c__ations
cavitations1647842cavitations
ciliations121111002ciliations
citational1266462citational
citators10310252citat_ors
cogitations1448902cogitations
conations111318902conations
creations112614542creations
dictations1389702dictations
dilations102614452dilations
dotations101411632dotations
excitations2049002excitations
fetations12511382fetations
fixations1936352fixations
himations1438802himations
imitations1259962imitations
incitations13310882incitations
libations112510442libations
ligations102111992ligations
mutations111211452mutations
natations91412492natations
nictations1278312nictations
nidations1039212nidations
nitrations10312032nitrations
notations91512972notations
nutations91411762nutations
potations111615072potations
recitations13314202recitations
rotations91613842rotations
siltations1038552siltations
situations1038432situations
stations82415222_stations
titrations1039172titrations
vitiations1338742vitiations
ablations11311513ablations
activations1669263activations
actuations1239293actuations
acylations1547603acylations
adnations1039753adnations
aerations9317903aerations
agitation10311223agitation_
agnations10310033agnations
alations82518893_alations
animations12312193animations
aviations12311563aviations
betatrons1145083betatrons
camions113916133c__amions
capitation14311363capitation_
captions123813223c_aptions
carnations12311353carnations
caseations1258303caseations
cassations1276873cassations
castrations13410073castrations
catenations1348363catenations
cation83925503c__ation_
caudations13108223caudations
causations1268143causations
cautions103313183c_autions
cavitation1549133cavitation_
ceratins102818733cerati_ns
cessations1256473cessations
chelations1539083chelations
ciliation111112493ciliation_
cistrons102710643ci_strons
citator9310123citat_o_r
citatory1347213citat_ory
citrins92614363cit_ri_ns
citrons92913223ci__trons
citterns10318123cit_terns
clarions10310493c_larions
clavations1546183clavations
coactions1349743coactions
coaptations1547543coaptations
cogitation13410083cogitation_
cognations1339593cognations
coitions10312853c_oitions
collations12312853collations
conation101420883conation_
connations12312943connations
contagions1346603contagions
cooptions13107763cooptions
copatrons1346333copatrons
corotations1349773corotations
cottons9312193cot_t_ons
cratons94316033c_rat_ons
creatins103617513creati_ns
creation102816513creation_
cremations14410713cremations
crenations12511693crenations
crepitations1647473crepitations
criterions1244773criterions
cunctations1576153cunctations
decimations16410163decimations
delations102616593delations
dentations11413633dentations
diatrons939623di_atrons
dictation12810563dictation_
dictions111812673di_ctions
dilatations1246413dilatations
dilation92215463dilation_
dilutions10248583dilutions
donations101112353donations
dotation91412733dotation_
dubitations1456673dubitations
durations10311463durations
elations83719123_elations
elicitations1446803elicitations
enations83316903_enations
epilations12311713epilations
equations1839493equations
equitations2047443equitations
excitation19410173excitation_
fetation11613143fetation_
fictions132410743fi_ctions
filiations13119093filiations
filtrations1445623filtrations
fixation1837073fixation_
flirtations14104263flirtations
flotations1366873flotations
gelations102513093gelations
gestations1139773gestations
gigatons1046053gigat_ons
gustations1147233gustations
guttations1145593guttations
gyrations1336923gyrations
habitations1646883habitations
halations12312393halations
hesitations1448543hesitations
himation1339753himation_
ideations1039903ideations
illations9311393illations
imitation11510853imitation_
inactions1139323_inactions
incitation12312223incitation_
initiations11410723initiations
invitations1449053invitations
iodations1039113iodations
irritations1147833irritations
isatins7310773_isati_ns
iterations10413823_iterations
jactations1936893jactations
jactitations2145013jactitations
kations114013663__kations
lactations1239423lactations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
levitations1448293levitations
libation102411363libation_
librations12149063librations
ligation92313093ligation_
limitations1348183limitations
lineations1039543lineations
liquations1945623liquations
literations11610583literations
litigations1247333litigations
lobations11219613lobations
locations112512743locations
lunations9310723lunations
luxations1637273luxations
meditations1449333meditations
mentations12312583mentations
migrations13168683migrations
miscitations1647053miscitations
mitigations1447623mitigations
mutation101412883mutation_
natation81513933natation_
nations74720563__nations
negations102811963negations
nictation1189273nictation_
nidation9410583nidation_
nitration9313443nitration_
notation81414603notation_
novations12139003novations
nutation81513103nutation_
oblations1139373oblations
orations81515803_orations
ovations11149263_ovations
oxidations1845443oxidations
peltations12311553peltations
petitions11511083petitions
pinnations1236883pinnations
plications14310493plications
potation101716783potation_
privations15310103privations
pupations1338123pupations
quotations19146283quotations
rations74123433__rations
recitation12315943recitation_
relations92418333relations
restations10315843restations
rogations101510823rogations
rotation81615453rotation_
ruinations1039603ruinations
saltations10310623saltations
sanitations11410843sanitations
satiations10312113satiations
scalations1239783scalations
sedations10311253sedations
siltation939213siltation_
sinuations1039413sinuations
situation949423situation_
solations9814623solations
statins73719773_stati_ns
station72717243_station_
stictions1148353stictions
sudations1039903sudations
tactions102912423__tactions
talions7314113__talions
taxations1636863taxations
titivations1446263titivations
titration9310543titration_
urinations10310693urinations
vacations141910553vacations
venations12311723venations
vexations1937753vexations
vibrations15157373vibrations
violations1337963violations
visitations1447673visitations
vitamins1347083vitami_ns
vitiation1239563vitiation_
vocations141911423vocations
zonations18139313zonations

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486412277.26620457.1
3Display Results2272270.0932440.9
 (SQL Overall)1786912277.78222962.1
 
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.