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

179 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
exportations214665(None) 
exhortations2244451exhortations
exportation2047441exportation_
deportations1548452deportations
excoriations2147502excoriations
exhortation2145022exhortation_
expectations2365832expectations
expirations2069582expir_ations
exploitations2254212exploitations
explorations2185602explor_ations
expurgations2274122expurgations
importations16156142importations
reexportations2352842reexportations
deportation1449303deportation_
evaporations1744683evapor_ations
exaltations1847293ex_altations
excitations2049003ex_citations
excogitations2353823excogitations
excoriation2048423excoriation_
execrations2048903execr_ations
exfoliations2244783exfoliations
expatiations2146133expatiations
expatriations2253763expatriations
expectation2266483expectation_
expiations1959663exp__iations
expiration19610713expir_ation_
explanations2144623explanations
explantations2253643explantations
explications2347533explications
exploitation2154703exploitation_
exploration2066713explor_ation_
expositions2046823expo_sitions
expostulations2352303expostulations
expropriations2553323expropriations
expurgation2154553expurgation_
extirpations2174283extirpations
extortions1746463extor__tions
exultations1846523ex_ultations
impartations16135433impartations
importation15147123importation_
potations111615063__po_tations
reexportation2253143reexportation_
reimportations18113593reimportations
sexploitations2352713sexploitations
teleportations1651813teleportations
adorations11310224_ador_ations
amputations1546444amp_utations
annotations1146884anno_tations
apportions1446284appor__tions
approbations1854244approbations
aspirations1348994aspir_ations
autorotations1354544autorotations
bipartitions16152544bipartitions
capitations1549854cap_itations
colorations13911864color_ations
corotations1349744__corotations
corporations16129444corpor_ations
decorations14312854decor_ations
deflorations1646054deflor_ations
deformations1846834deformations
denotations1239844deno_tations
deputations1448344dep_utations
desperations1559504desper_ations
despoliations1646394despoliations
dotations101411634__do_tations
elaborations1444914elabor_ations
elicitations1446804elicitations
elongations1244664e_longations
elutriations1246024elutriations
embarkations2062254embarkations
embrocations1843984embrocations
emigrations14187154emigr_ations
enervations1478574e_nervations
epilations12311714e_p_ilations
epoxidations2243644e_poxidations
equitations2047444e_quitations
eructations1347224e_ructations
etiolations1147394etio_lations
evaporation1645554evapor_ation_
evocations15259874e_vo_cations
exacerbations2452504exacerbations
exaltation1748494ex_altation_
examinations2167464examinations
exasperations2253684exasper_ations
excavations2345084ex_cavations
excerptions2244984excer_ptions
excitation19410174ex_citation_
exclamations23104104exclamations
excogitation2254184excogitation_
excoriating2145474excoriati_ng
excretions1946624ex_cr_etions
exculpations2344174exculpations
execration1949824execr_ation_
exercitations2254554exercitations
exertions1639764ex_er__tions
exfoliation2145254exfoliation_
exhalations2146024ex_halations
exhortative2453054exhortati_ve
exhortatory2452204exhortat_ory
exhumations2344084ex_humations
exonerations1947004exonerations
expatiation2046834expatiation_
expatriation2154334expatriation_
expectational2452494expectational
expectorations2552174expectorations
expeditions2144634exp_editions
expiation18710424exp__iation_
explanation2045264explanation_
explantation2153974explantation_
explication2248454explication_
explorational2252544explor_ational
exponentiations2461724exponentiations
exporting1937324expor__ti_ng
exposition1947144expo_sition_
expostulation2262614expostulation_
expressions2086354exp_ressions
expropriation2453994expropriation_
expunctions2243634exp_unctions
expurgating2243274expurgati_ng
expurgators2152564expurgat_ors
exsertions1746744exser__tions
exsiccations2343264exsiccations
exsolutions1844014exso_lutions
extenuations1945074extenuations
extirpation2084924extirpation_
extortion1646724extor__tion_
extractions2077734ex_tractions
extrications2149044extrications
exudations18107074ex__udations
exultation1747534ex_ultation_
exuviations2195694ex_uviations
flirtations14104264_flirtations
floatations1444104_floatations
floriations1476914_floriations
flotations1366874_flo_tations
formations1538194__formations
impartation15156104impartation_
impetrations1645444impetrations
imputations1546354imp_utations
informations17127034informations
meliorations1466744melior_ations
notations91512974__no_tations
operations12312934_oper_ations
orations81515794___or_ations
partitions1248324__partitions
peltations12311554__peltations
perforations1747844perfor_ations
perorations13314034peror_ations
perpetrations1746354perpetrations
portions10514394__por__tions
potation101716784__po_tation_
probations14311064__probations
pronations12314034__pronations
prorations12314434__prorations
purgations1346744__purgations
quotations19146284_quo_tations
recordations1548624recordations
reformations1747594reformations
reimportation17114034reimportation_
reoperations14410044reoper_ations
reparations13611654repar_ations
repartitions1444964repartitions
reprobations1647774reprobations
reputations13410734rep_utations
respirations14410304respir_ations
restorations12410934restor_ations
rotations91613844__ro_tations
separations1369274separ_ations
sexploitation2252954sexploitation_
sortitions1046414__sortitions
spoliations1347694_spoliations
sporulations1445684_sporulations
subornations1446134subornations
supernations14410874supernations
superstations15208144superstations
teleportation1552124teleportation_
temporizations2785744temporizations
temptations1545394temp__tations
vaporizations2776964vaporizations

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.1401276364.3
2DLD Change Limit1247901798.11015387.2
3Display Results1791790.1101627.3
 (SQL Overall)1786911798.36021374.5
 
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.