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

151 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
expectational245249(None) 
expectation2266482expectation__
expectations2365842expectation_s
explorational2252553explorational
speciational1654313_speciational
educational1444874e_duc_ational
examinational2252184examinational
excavational2452764ex_cavational
exceptional2254444ex__ceptional
execration1949834ex_ecration__
execrations2048924ex_ecration_s
expectative2553584expectati__ve
expectoration2452564expectoration__
expectorations2552194expectoration_s
exportation2047444exportation__
exportations2146654exportation_s
expositional2153944exp_ositional
gestational1245114__gestational
hyperrational2153934hyperrational
lactational1344654__lactational
operational1347524_ope_rational
orientational1353804orientational
repetitional1453724repe_titional
reputational1474584rep_utational
supernational1555614supernational
vegetational1653374vege_tational
aberrational1453485_aberrational
adaptational1572795_adaptational
affectation1943845affectation__
affectations2043435affectation_s
affectional1953895affec__tional
agitational1244845__agitational
annexational1953265anne_xational
aspirational1455005asp_irational
associational1552935associational
avocational1645185_avoc_ational
bisectional1554645bisec__tional
citational1266465___citational
compensational2073525compensational
computational1994575computational
connotational1554155connotational
deceptional1654775__deceptional
delectation1448555delectation__
delectations1547455delectation_s
dilatational1352775_dilatational
directional1445445direc__tional
dispensational1762505dispensational
dissertational1562575dissertational
effectuation2052285effectuation__
effectuations2151955effectuation_s
equational1945605___equational
eructation1248335e_ructation__
eructations1347235e_ructation_s
exaltation1748495ex_altation__
exaltations1847295ex_altation_s
excisional1953845ex__c_isional
excitation19410175ex_citation__
excitations2049005ex_citation_s
execrating2047885ex_ecrati_n_g
execution1846305ex_ec_ution__
executioner2072615ex_ec_utioner
executions1946395ex_ec_ution_s
exercitation2155385exercitation__
exercitations2254565exercitation_s
exhortation2145025exhortation__
exhortations2244455exhortation_s
expansional2052805exp__ansional
expatiation2046835expatiation__
expatiations2146135expatiation_s
expectance2363625expecta___nce
expectancy2692485expecta___ncy
expectant2045675expecta___n_t
expectantly2572425expecta___ntly
expectants2163585expecta___nts
expecting2146695expec__ti_n_g
expectorating2552065expectorati_n_g
expedition2044905expe_dition__
expeditionary2691605expe_ditionary
expeditions2144635expe_dition_s
expiation18710425exp__iation__
expiations1959665exp__iation_s
expiration19610715exp_iration__
expirations2069585exp_iration_s
explanation2045265explanation__
explanations2144625explanation_s
explantation2153975explantation__
explantations2253645explantation_s
explication2248455explication__
explications2347535explication_s
exploitation2154705exploitation__
exploitations2254215exploitation_s
exploration2066715exploration__
explorations2185615exploration_s
expressional2164215exp_ressional
expurgation2154555expurgation__
expurgations2274125expurgation_s
exsection1847495exsec__tion__
exsections1947635exsec__tion_s
exsiccation2243625exsiccation__
exsiccations2343265exsiccation_s
extensional1854185exte__nsional
extenuation1845185extenuation__
extenuations1945085extenuation_s
exultation1747535ex_ultation__
exultations1846525ex_ultation_s
fluctuational1861235_fluctuational
generational1354825gene_rational
gravitational1762555gravitational
ideational1146505_ide__ational
incantational1553565incantational
indicational1545755indic_ational
international1357675international
invitational1554905_invitational
invocational1754415invoc_ational
irrotational1254025_irrotational
levitational1553635_levitational
limitational1453545_limitational
locational1246595__loc_ational
mediational1445645__mediational
mutational1246515___mutational
negational1147155__ne_gational
notational1048125___notational
nutational1047045___nutational
observational1853185observational
peltation11312965__peltation__
peltations12311555__peltation_s
pentagonal1363565__penta_gonal
perceptional1854905__perceptional
permutational1752695permutational
perorational1446395__perorational
populational1654415pop_ulational
preoperational1853245preope_rational
presentational1673215presentational
probational1547085__probational
progestational1762755progestational
recreational1455175__recreational
reflectional1753995reflec__tional
relational1047715__re_lational
rotational1048095___rotational
salutational1253325_salutational
sectional1149425__sec__tional
sensational1146385__sensational
speciation1449395_speciation__
speciations1548485_speciation_s
spectating1546625_spectati_n_g
spectatorial1652665_spectatorial
stational948515____stational
supranational1552995supranational
suprarational1552925suprarational
unsensational1353665unsensational
vocational1546955__voc_ational

Search took 9 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.406440125.6
2DLD Change Limit1247901518.22015181.3
3Display Results1511510.1061424.5
 (SQL Overall)1786911518.73220463.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.