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

207 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
vacation13191189(None) 
vacations141910551vacations
vocation132311981vocation
action84719682_ac_tion
alation72920552_alation
aviation11312742aviation
avocation14168992avocation
cation83925502__cation
evacuation1547162evacuation
evocation142010292evocation
faction122613332fac_tion
halation11313852halation
jactation1838142jactation
lactation11310812lactation
lavation1139972lavation
laxation1538422laxation
location102113912location
natation81513932natation
paction112713962pac_tion
placation1339772placation
sacaton938992sacat_on
taction93213022tac_tion
taxation1537992taxation
vacating14310352vacating
vacationed1643422vacationed
vacationer1543302vacationer
vallation1239742vallation
valuation1249972valuation
variation12312392variation
venation11513502venation
vexation1838782vexation
vocations141911422vocations
zacaton1845632zacat_on
ablation10312433ablation
acetin8314693_aceti_n
actin74922553_ac_ti_n
actinon9459463_ac_tinon
actions94218513_ac_tions
actuation11310333_actuation
acylation1448653_acylation
adaption1145643_adaption
adnation9310783adnation
advocation1645743advocation
aeration8319933aeration
agnation9311723agnation
alations82518893_alations
amotion9710473_amotion
arcuation11410583arcuation
auction93412933_auction
aviations12311553aviations
avocations15168683avocations
bastion9312473ba_stion
camion103917193__camion
caption113513693ca_ption
carnation11312943carnation
caseation1199513caseation
cassation1197913cassation
cations94524143__cations
caudation1269993caudation
causation1199523causation
caution93013523ca_ution
citation10314363citation
clavation1447003clavation
coaction12310773coac_tion
conation101420883conation
creation102816513creation
damnation1238403damnation
darnation1039823darnation
dealation10313003dealation
delation92318083delation
dictation12810563dictation
diction102313053dic_tion
dilation92215463dilation
divagation15104373divagation
donation91513783donation
dotation91412733dotation
duration9312693duration
education12310203education
elation73620453_elation
emaciation1449283emaciation
emanation11910783emanation
enation73419233_enation
equation17310483equation
evacuations1646303evacuations
evaluation1358183evaluation
evection131910833evec_tion
eviction13228683evic_tion
evocations15259873evocations
exaction1738953exac_tion
factions133013063fac_tions
fasciation1546833fasciation
fetation11613143fetation
fiction122010733fic_tion
fixation1837073fixation
fraction1359483frac_tion
furcation1448353furcation
gelation93014433gelation
glaciation1346583glaciation
gradation11107713gradation
gyration1237763gyration
halations12312393halations
himation1339753himation
ideation9310493ideation
illation8311943illation
inaction1039623inac_tion
incaution1146583incaution
invocation1547543invocation
iodation9310383iodation
jactations1936893jactations
kation104315683__kation
laceration1249573laceration
lactations1239423lactations
lallation939493lallation
laudation1088133laudation
lavations1238973lavations
laxations1637623laxations
lection92614863lec_tion
legation92412933legation
libation102411363libation
ligation92313093ligation
lobation102110553lobation
locations112512743locations
locution10227663locution
lunation8311923lunation
luxation1538233luxation
macaroon1246343macaroon
maceration1449613maceration
maculation14510983maculation
malathion1444513malathion
marathon1346813marathon
mutation101412883mutation
narration9310063narration
natations91412493natations
nation64322803__nation
negation92913023negation
nictation1189273nictation
nidation9410583nidation
notation81414603notation
novation111710013novation
nutation81513103nutation
oblation1039863oblation
occasion1244213occasion
oration71617713_oration
ovation101510023_ovation
ovulation1238983ovulation
pactions122613503pac_tions
palmation13310223palmation
palpation1339073palpation
parathion1446173parathion
placations1438583placations
planation11310123planation
plication13311683plication
potation101716783potation
pupation1269503pupation
radiation10313393radiation
ration64226013__ration
reaction10612603reac_tion
recaution1148093recaution
relation82619773relation
revocation15410813revocation
rogation91612053rogation
rotation81615453rotation
ruction93611613ruc_tion
sabaton937713sabat_on
sacatons1038973sacat_ons
saltation9312003saltation
salvation1239293salvation
sanction1049533sanction
satiation9313433satiation
scalation11311073scalation
section92515663sec_tion
sedation9312453sedation
solation8916153solation
station72717243_station
suction93713043suc_tion
sudation9310803sudation
sulcation11710733sulcation
tactions102912423tac_tions
tarnation9310093tarnation
taxations1636863taxations
traction10412683trac_tion
unction9310663unc_tion
vacate11314553vacat__e
vacated1349353vacat_ed
vacates12312833vacat_es
vacationers1652483vacationers
vacationing1753043vacationing
vacationist1655903vacationist
vaccination1846463vaccination
vacillation1645313vacillation
vacuolation1644393vacuolation
validation1448413validation
vallations1339083vallations
valuations1348783valuations
variations13310773variations
venations12311723venations
vernation12311083vernation
vexations1937753vexations
vibration14138203vibration
violation1238443violation
vitiation1239563vitiation
vocational1546953vocational
vocative1637913vocative
volition1179173volition
volution1198603volution
zacatons1945703zacat_ons
zonation171410723zonation

Search took 7 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.410435831.7
2DLD Change Limit1461622076.23323449.7
3Display Results2072070.0932225.8
 (SQL Overall)1786912076.73626527.8
 
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.