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

211 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
vocation13231198(None) 
avocation14168991avocation
evocation142010291evocation
location102113911location
vacation131911891vacation
vocations141911421vocations
advocation1645742advocation
avocations15168682avocations
cation83925502__cation
coaction12310772coaction
conation101420882conation
donation91513782donation
dotation91412732dotation
evocations15259872evocations
invocation1547542invocation
iodation9310382iodation
lobation102110552lobation
locations112512742locations
locution10227662locution
notation81414602notation
novation111710012novation
oration71617712_oration
ovation101510022_ovation
potation101716782potation
revocation15410812revocation
rogation91612052rogation
rotation81615452rotation
solation8916152solation
vacations141910552vacations
venation11513502venation
vexation1838782vexation
violation1238442violation
vocational1546952vocational
vocative1637912vocative
volition1179172volition
volution1198602volution
zonation171410722zonation
ablation10312433ablation
action84719683_ac_tion
adnation9310783adnation
adoration10311313adoration
advocations1755413advocations
aeration8319933aeration
agnation9311723agnation
alation72920553_alation
allocation1248573allocation
arcuation11410583arcuation
auction93412933auc_tion
aviation11312743aviation
avocational1645183avocational
bilocation1446123bilocation
camion103917193__camion
caption113513693__caption
cations94524143__cations
caution93013523__caution
citation10314363citation
coactions1349743coactions
cocain101315013coca_i_n
cognation12310753cognation
coition9314313co_ition
collation11313993collation
conations111318903conations
connation11314263connation
convocation1847883convocation
cooption1288343cooption
copatron1246753copatron
creation102816513creation
delation92318083delation
dictation12810563dictation
diction102313053dic_tion
dilation92215463dilation
donations101112353donations
dotations101411633dotations
duration9312693duration
education12310203education
elation73620453_elation
elocution1145673elocution
enation73419233_enation
equation17310483equation
evacuation1547163evacuation
evection131910833evec_tion
eviction13228683evic_tion
evocative1746293evocative
evocator1346573evocat_or
evolution12117093evolution
exaction1738953exaction
faction122613333fac_tion
fetation11613143fetation
fiction122010733fic_tion
fixation1837073fixation
flotation1267813flotation
foliation121110793foliation
formation1439423formation
fraction1359483fraction
furcation1448353furcation
gelation93014433gelation
gyration1237763gyration
halation11313853halation
himation1339753himation
ideation9310493ideation
illation8311943illation
inaction1039623inaction
incaution1146583incaution
invocations1647063invocations
iodations1039113iodations
isolation9311643isolation
jactation1838143jactation
kation104315683__kation
lactation11310813lactation
lavation1139973lavation
laxation1538423laxation
lection92614863lec_tion
legation92412933legation
libation102411363libation
ligation92313093ligation
lobations11219613lobations
locating11311503locating
locational1246593locational
locative1338683locative
locator93110423locat_or
locutions11207063locutions
lotion65716523lo__tion
lunation8311923lunation
luxation1538233luxation
monition10311723monition
motion85217553mo__tion
mutation101412883mutation
natation81513933natation
nation64322803__nation
negation92913023negation
nictation1189273nictation
nidation9410583nidation
nonaction1149443nonaction
notations91512973notations
notion64516583no__tion
novations12139003novations
nutation81513103nutation
oblation1039863oblation
occasion1244213occasion
octagon1045243_octagon
option83612713_o_ption
orations81515803_orations
ovations11149263_ovations
ovulation1238983ovulation
ozonation1845673ozonation
paction112713963pac_tion
phonation1439393phonation
placation1339773placation
plication13311683plication
portion9615493po_rtion
position10912193position
potations111615073potations
potion84519573po__tion
proaction13410103proaction
probation13412183probation
pronation11415703pronation
proration11415983proration
provocation1847353provocation
pupation1269503pupation
quotation18146973quotation
ration64226013__ration
reaction10612603reaction
recaution1148093recaution
relation82619773relation
relocation12312113relocation
revocations16410313revocations
rogations101510823rogations
rotations91613843rotations
ruction93611613ruc_tion
sacaton938993sacat_on
section92515663sec_tion
sedation9312453sedation
solations9814623solations
solution889593solution
solvation1237773solvation
sonication12411183sonication
sorption1037513sorption
station72717243_station
suction93713043suc_tion
sudation9310803sudation
sulcation11710733sulcation
taction93213023tac_tion
taxation1537993taxation
traction10412683traction
unction9310663unc_tion
vacating14310353vacating
vacationed1643423vacationed
vacationer1543303vacationer
vallation1239743vallation
valuation1249973valuation
variation12312393variation
venations12311723venations
vernation12311083vernation
vexations1937753vexations
vibration14138203vibration
violations1337963violations
vitiation1239563vitiation
vocalic1446943vocali_c
vocalics1545593vocalics
vocalise131510813vocalise
vocalism15159043vocalism
vocalist131512123vocalist
vocality16137933vocality
vocalize221310153vocalize
vocatives1745883vocatives
volatile1146433volatile
volitions1288663volitions
volutin1098103voluti_n
volutions12108393volutions
zacaton1845633zacat_on
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 Filter1786911461620.420425454.8
2DLD Change Limit1461622117.17320376.7
3Display Results2112110.0932268.8
 (SQL Overall)1786912117.68623248.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.