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

213 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
vocations14191142(None) 
avocations15168681avocations
evocations15259871evocations
locations112512741locations
vacations141910551vacations
vocation132311981vocation_
advocations1755412advocations
avocation14168992avocation_
cations94524142__cations
coactions1349732coactions
conations111318892conations
donations101112342donations
dotations101411622dotations
evocation142010292evocation_
invocations1647062invocations
iodations1039112iodations
lobations11219612lobations
location102113912location_
locutions11207052locutions
notations91512972notations
novations12139002novations
orations81515792_orations
ovations11149262_ovations
potations111615062potations
revocations16410302revocations
rogations101510822rogations
rotations91613842rotations
solations9814622solations
vacation131911892vacation_
venations12311722venations
vexations1937752vexations
violations1337962violations
vocational1546952vocational
vocatives1745882vocatives
volitions1288662volitions
volutions12108382volutions
zonations18139312zonations
ablations11311503ablations
actions94218513_ac_tions
adnations1039753adnations
adorations11310223adorations
advocation1645743advocation_
aerations9317903aerations
agnations10310033agnations
alations82518893_alations
allocations1347773allocations
arcuations1249333arcuations
auctions104012143auc_tions
aviations12311553aviations
avocational1645173avocational
bilocations1545293bilocations
camions113916133__camions
captions123813213__captions
cation83925503__cation_
cautions103313163__cautions
citations11312493citations
coaction12310763coaction_
cocains111313923coca_i_ns
cognations1339573cognations
coitions10312843co_itions
collations12312843collations
conation101420883conation_
connations12312933connations
convocations1947343convocations
cooptions13107733cooptions
copatrons1346333copatrons
creations112614533creations
delations102616593delations
dictations1389693dictations
dictions111812673dic_tions
dilations102614453dilations
donation91513783donation_
dotation91412733dotation_
durations10311463durations
educations1339223educations
elations83719123_elations
elocutions1245963elocutions
enations83316903_enations
equations1839493equations
evacuations1646303evacuations
evections142510693evec_tions
evictions14228623evic_tions
evocators1446693evocat_ors
evolutions13107043evolutions
exactions1838923exactions
factions133013063fac_tions
fetations12511383fetations
fictions132410743fic_tions
fixations1936353fixations
flotations1366873flotations
foliations1399943foliations
formations1538193formations
fractions1449103fractions
furcations1547533furcations
gelations102513093gelations
gyrations1336923gyrations
halations12312393halations
himations1438803himations
ideations1039903ideations
illations9311393illations
inactions1139323inactions
incautions1245973incautions
invocation1547543invocation_
iodation9310383iodation_
isolations10310683isolations
jactations1936893jactations
kations114013663__kations
lactations1239423lactations
lavations1238973lavations
laxations1637623laxations
lections102413843lec_tions
legations102711923legations
libations112510443libations
ligations102111983ligations
lobation102110553lobation_
locating11311503locati_ng
locational1246593locational
locatives1446563locatives
locators102910413locat_ors
locution10227663locution_
lotions74614763lo__tions
lunations9310723lunations
luxations1637273luxations
monitions11310883monitions
motions94215003mo__tions
mutations111211453mutations
natations91412493natations
nations74720563__nations
negations102811963negations
nictations1278313nictations
nidations1039213nidations
nonactions1248373nonactions
notation81414603notation_
notions74014483no__tions
novation111710013novation_
nutations91411763nutations
oblations1139363oblations
occasions1344053occasions
octagons1144493_octagons
options93810593_o_ptions
oration71617713_oration_
ovation101510023_ovation_
ovulations1337973ovulations
ozonations1945143ozonations
pactions122613503pac_tions
phonations1538303phonations
placations1438573placations
plications14310483plications
portions10514393po_rtions
positions11811493positions
potation101716783potation_
potions93417423po__tions
proactions1449333proactions
probations14311063probations
pronations12314033pronations
prorations12314433prorations
provocations1956843provocations
pupations1338123pupations
quotations19146283quotations
rations74123433__rations
reactions11711713reactions
recautions1247803recautions
relations92418333relations
relocations13311133relocations
revocation15410813revocation_
rogation91612053rogation_
rotation81615453rotation_
ructions102811673ruc_tions
sacatons1038973sacat_ons
sections102714703sec_tions
sedations10311253sedations
solation8916153solation_
solutions988873solutions
solvations1336833solvations
sonications1349943sonications
sorptions1137103sorptions
stations82415213_stations
suctions103012903suc_tions
sudations1039903sudations
sulcations1289583sulcations
tactions102912423tac_tions
taxations1636863taxations
tractions11511613tractions
unctions1039733unc_tions
vacating14310343vacati_ng
vacationed1643423vacationed
vacationer1543303vacationer
vacationers1652483vacationers
vacationist1655893vacationist
vallations1339083vallations
valuations1348783valuations
variations13310773variations
venation11513503venation_
vernations13310323vernations
vexation1838783vexation_
vexatious1944103vexatious
vibrations15157373vibrations
vicarious1445583vicarious
violation1238443violation_
vitiations1338743vitiations
vocalics1545593vocali_cs
vocalises141710323vocalises
vocalisms16138053vocalisms
vocalists14108893vocalists
vocalizes231610103vocalizes
vocative1637913vocati_ve
volatiles1246133volatiles
volition1179173volition_
volutins1188003voluti_ns
volution1198603volution_
voracious1445503voracious
zacatons1945703zacat_ons
zonation171410723zonation_

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.1561145455.1
2DLD Change Limit1486412137.70319296.5
3Display Results2132130.0932290.3
 (SQL Overall)1786912137.95222471.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.