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

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

182 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
expectations236584(None) 
expectation2266481expectation_
execrations2048922ex_ecrations
expectational2452492expectational
expectorations2552192expectorations
exportations2146652exportations
affectations2043433affectations
delectations1547453delectations
effectuations2151953effectuations
eructations1347233e_ructations
exaltations1847293ex_altations
excitations2049003ex_citations
execration1949833ex_ecration_
executions1946393ex_ec_utions
exercitations2254563exercitations
exhortations2244453exhortations
expatiations2146133expatiations
expectative2553583expectati_ve
expectoration2452563expectoration_
expeditions2144633expe_ditions
expiations1959663exp__iations
expirations2069583exp_irations
explanations2144623explanations
explantations2253643explantations
explications2347533explications
exploitations2254213exploitations
explorations2185613explorations
exportation2047443exportation_
expurgations2274123expurgations
exsections1947633exsec__tions
exsiccations2343263exsiccations
extenuations1945083extenuations
exultations1846523ex_ultations
peltations12311553__peltations
speciations1548483_speciations
acceptations1864504acceptations
affectation1943844affectation_
amputations1546444amp_utations
appellations1643534appellations
appreciations1964774appreciations
assentations1245844assentations
attestations1244464attestations
capacitations1953624capacitations
capitations1549854cap_itations
cementations1659014cementations
coarctations16114494coarctations
crepitations1647474crepitations
cunctations1576154_cunctations
cupellations1643804cupellations
defecations1779004defec_ations
delectation1448554delectation_
dentations11413634__dentations
deportations1548464deportations
deprecations1748564deprec_ations
depreciations1846584depreciations
deputations1448344dep_utations
desecrations1559214desecrations
desperations1559524despe_rations
detestations1347584detestations
dictations1389704__dictations
educations1339234e_duc_ations
effectuation2052284effectuation_
ejections18249964e_jec__tions
elections112414974e_lec__tions
elevations1338634e_le_vations
elicitations1446804elicitations
emaciations1548164e_maciations
emendations1446054e_mendations
enervations1478574e_nervations
enunciations1445094enunciations
epilations12311714e_p_ilations
equitations2047444e_quitations
erections112515214e_rec__tions
eructation1248334e_ructation_
evacuations1646304e_vacuations
evections142510694e_vec__tions
evocations15259874e_voc_ations
exacerbations2452504exacerbations
exactions1838924ex_ac__tions
exaltation1748494ex_altation_
examinations2167464examinations
exasperations2253694exaspe_rations
excavations2345084ex_cavations
exceptions2146864ex__ceptions
excerptions2244984exce_rptions
excitation19410174ex_citation_
exclamations23104104exclamations
excogitations2353834excogitations
excoriations2147524excoriations
excretions1946624ex__cretions
excruciations24112994excruciations
exculpations2344174exculpations
execrating2047884ex_ecrati_ng
execrators1946024ex_ecrat_ors
execution1846304ex_ec_ution_
exemptions2164834ex_e_mptions
exenterations2054484ex_enterations
exercitation2155384exercitation_
exertions1639764ex_e__rtions
exfoliations2244784exfoliations
exhalations2146024ex_halations
exhortation2145024exhortation_
exhumations2344084ex_humations
exonerations1947014exonerations
expatiation2046834expatiation_
expatriations2253764expatriations
expectances2493344expecta_nces
expectancies2562244expectancies
expectant2045674expecta___nt
expectants2163584expecta__nts
expecting2146694expec__ti_ng
expectorating2552064expectorati_ng
expedition2044904expe_dition_
expeditious2152534expe_ditious
expiation18710424exp__iation_
expiration19610714exp_iration_
explanation2045264explanation_
explantation2153974explantation_
explication2248454explication_
exploitation2154704exploitation_
exploration2066714exploration_
exponentiations2461734exponentiations
expositions2046844exp_ositions
expostulations2352304expostulations
expunctions2243634exp_unctions
expurgation2154554expurgation_
exsection1847494exsec__tion_
exsertions1746744exse__rtions
exsiccation2243624exsiccation_
extenuation1845184extenuation_
extirpations2174284extirpations
extrications2149054extrications
exudations18107074ex__udations
exultation1747534ex_ultation_
exuviations2195694ex_uviations
fermentations1856274fermentations
fetations12511384__fe_tations
fomentations1746794fomentations
forestations1546324forestations
gestations1139774__gestations
hebetations1656464hebe_tations
impartations16135434impartations
impetrations1645444impetrations
importations16156144importations
imprecations1846274imprec_ations
imputations1546354imp_utations
indentations1347884indentations
infestations1546624infestations
jactations1936894__jactations
lactations1239424__lactations
lamentations1495984lamentations
mentations12312584__mentations
molestations1475474molestations
nictations1278314__nictations
operations12312954_ope_rations
orientations1246914orientations
ostentations1246134ostentations
pectinations1649254__pectinations
peculations15310284__peculations
peltation11312964__peltation_
perpetrations1746374perpetrations
perpetuations1754984perpetuations
petitions11511084__pe_titions
potations111615074__p_otations
punctations1585354_punctations
recitations13314204__recitations
reexportations2352844reexportations
reluctations1446754reluctations
reoperations14410064reope_rations
repetitions1378024repe_titions
reputations13410734rep_utations
restations10315844__restations
segmentations1655594segmentations
sexploitations2352714sexploitations
speciation1449394_speciation_
spectating1546624_spectati_ng
spectators1444534_spectat_ors
speculations1646394_speculations
supernations14410874supernations
superstations15208144superstations
temptations1545414temp__tations
vegetations1547324vege_tations

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901826.59318927.7
3Display Results1821820.0931957.0
 (SQL Overall)1786911827.07625253.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.