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

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

120 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
avocationally2111369(None) 
vocationally20125001_vocationally
avocational1645182avocationa_l_
locationally17124712_locationally
educationally1963313educationally
navigationally2162233navigationally
probationally2054093probationally
valuationally1962523valuationally
variationally1953003variationally
vocational1546953_vocationa_l_
actinally1448234a__c_ti_nally
actionably17105514a__c_tionably
adaptationally2061994adaptationally
additionally1753314a_dditionally
affectionally2453014affectionally
aromatically19410664aromati_cally
avocation14168994avocation____
avocations15168684avocation___s
devotionally1953724devo__tionally
dictionally1755984_dic_tionally
emotionally1655304emo__tionally
equationally2453824_equationally
factionally1946394_fac_tionally
fictionally1956054_fic_tionally
fractionally2055294frac_tionally
frictionally2054924fric_tionally
functionally2054974func_tionally
gradationally1853264gradationally
gravitationally2271844gravitationally
ideationally1674884_ideationally
invocational1754414invocationa_l_
irrationally1555244_irrationally
locational1246594_locationa_l_
mutationally1754274_mutationally
nationally1348424___nationally
notionally1347084_no__tionally
occasionally1952754_occasionally
octagonally1752504__octagonally
operationally1854644operationally
optionally1545944__o_ptionally
positionally1754924_positionally
rationally1349424___rationally
relationally1555074_relationally
sectionally1646824_sec_tionally
sensationally1654304sensationally
situationally1653394situationally
vocalically2144804_vocali_cally
vocationalism2054414_vocationalism
vocationalist1855104_vocationalist
abolitionary1762235abolitiona_ry
aboriginally1851795aborigi_nally
acoustically1946545acousti_cally
acrobatically2255745acrobati_cally
actionable14116215a__c_tionable
advocation1645745advocation____
advocations1755415advocation___s
agitational1244845agitationa_l_
apolitically1948035apoliti_cally
aquatically2546315a_quati_cally
arctically17410375a_rc_ti_cally
ascetically1848405a_sceti_cally
associational1552935associationa_l_
atonally1148635____at_onally
autocratically2164835autocrati_cally
automatically2077445automati_cally
axiomatically2756095axiomati_cally
bisectionally2053155bisectionally
cathodally1953195___cathodally
cationically1956845___cationically
coeducationally23102355coeducationally
conditionally1954795conditionally
convocational2054475convocationa_l_
doctrinally1753555_doc_trinally
educational1444875educationa_l_
elocutionary1762375elocutiona_ry
erosionally1454665ero__sionally
evocation142010295evocation____
evocations15259875evocation___s
evocatively2253685evocati__vely
evolutionarily2092115evolutionarily
evolutionary1853325evolutiona_ry
exceptionally2753525exceptionally
foundationally2162345foundationally
generationally1883005generationally
informationally2362465informationally
intentionally1655985intentionally
isochronally2062015isoc_hronally
motivationally2262495motivationally
navigational1653295navigationa_l_
nocturnally1652425_noc_turnally
nonvocational1853705nonvocationa_l_
notational1048125_notationa_l_
nutritionally16103545nutritionally
occupationally2362125occupationally
ovational1246855__ovationa_l_
polytonally1953195_polyt_onally
prevocational2054015prevocationa_l_
probational1547085probationa_l_
probationary1953225probationa_ry
processionally2163135processionally
proportionally2163495proportionally
provisionally2163165provisionally
rotational1048095_rotationa_l_
somatically18411155_somati_cally
torsionally1453875_to_rsionally
traditionally1753805traditionally
unemotionally1853765unemotionally
vacationland186815_vacationland
vaginally1645235_v__agi_nally
valuational1444045valuationa_l_
variational1444775variationa_l_
visionally1644795_v__isionally
vocation132311985_vocation____
vocationalisms2163775_vocationalisms
vocationalists1964085_vocationalists
vocations141911425_vocation___s
vocatively2144465_vocati__vely
volcanically2253345_volcani_cally
volitional1345415_volitiona_l_
vortically1849195_vo_rti_cally

Search took 10 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 Filter1786911247900.403443402.0
2DLD Change Limit1247901208.84614106.9
3Display Results1201200.0761578.9
 (SQL Overall)1786911209.32519162.6
 
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.