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

103 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
officiations205350(None) 
officiation1943831officiation_
affiliations1844182affiliations
officiating2052922officiati_ng
affectations2043433affectations
affiliation1744853affiliation_
affirmations2053233affirmations
affixations2443853affi_xations
fasciations1646263_fasciations
filiations13119093__filiations
officialdoms237843officialdoms
officialisms2262313officialisms
officiaries1952503officiari_es
officiates1843693officiat__es
abdications1657654abdic_ations
affectation1943844affectation_
affections1845894affec__tions
affiliating1844164affiliati_ng
affirmation1953684affirmation_
affixation2344394affi_xation_
afflictions1943404aff_lictions
anticipations1757484anticipations
associations1445744associations
beneficiations21182214beneficiations
brecciations1844274brecciations
ciliations121110994__ciliations
codifications21127624codific_ations
conciliations1747194conciliations
confirmations2055674confirmations
confiscations2044954confiscations
consociations1747504consociations
dedications15310864dedic_ations
defecations1778994defec_ations
definitions1545604defini_tions
defoliations1647584defoliations
deifications18410654deific_ations
desiccations1755644desiccations
dictations1389694__dictations
edifications1848694edific_ations
effectuations2151944effectuations
efficacious2151614effic_acious
elicitations1446804_elicitations
emaciations1548154_emaciations
enunciations1445094enunciations
exfoliations2244784exfoliations
exsiccations2343264exsiccations
fasciation1546834_fasciation_
fascinations1746354_fascinations
felicitations1874584felicitations
fictions132410744__fic__tions
filiation121110244__filiation_
fixations1936354__fi_xations
flirtations14104264_flirtations
floriations1476894_floriations
foliations1399944__foliations
fornications1755394fornic_ations
frictions1448034_fric__tions
furcations1547534_furc_ations
glaciations1445964_glaciations
humiliations1784554humiliations
indications14310974indic_ations
infixations2146694infi_xations
infuriations1547444infuriations
initiations11410724_initiations
laciniations1445914laciniations
laicizations2347414_laicizations
lixiviations2252764lixiviations
medications1649924medic_ations
modifications21106984modific_ations
nictations1278314__nictations
nonfictions1645934nonfic__tions
notifications1848224notific_ations
obfuscations1951894obfuscations
obligations1446144obli_gations
obviations1545464o__bviations
officialdom2261084officialdo_m
officialeses2061144officialeses
officialism2152574officiali_sm
officials1743404officia___ls
officiant1745064officia___nt
officiants1853424officia__nts
officiate1744164officiat___e
officiated1943254officiat__ed
officious1763874offic___ious
olfactions1563874olfac__tions
optimisations17153444optimisations
optimizations26155694optimizations
ordinations1247974ordi_nations
originations13106164o_riginations
oscillations1445114oscillations
ossifications18176144ossifications
oxidations1845444o_xi_dations
plications14310484_plic_ations
reifications17411824reific_ations
solicitations1544884solicitations
sonications1349944sonic_ations
speciations1548474_speciations
suffixations2562544suffi_xations
suffocations2053094suffoc_ations
unifications1748044unific_ations
urtications1348034urtic_ations
vaticinations1845024vaticinations
vitiations1338744__vitiations

Search took 7 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.1431249587.4
2DLD Change Limit1247901036.50019198.5
3Display Results1031030.0601716.7
 (SQL Overall)1786911036.70326658.4
 
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.