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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
divarication185590(None) 
divarications1955501divarications
divaricating1953592divaricating
covariation1646773covari_ation
demarcation1647023demar_cation
dilapidation1653363dilapidation
dimerization2449083dimerization
divagation15104373diva__gation
divaricate1644273divaricat__e
divaricated1853493divaricat_ed
divaricates1743873divaricat_es
divination14139233div__ination
imbrication1746463_imbrication
prevarication2055243prevarication
variation12312393__vari_ation
vivification2366343vivification
bifurcation1863374bifur_cation
cicatrization2675414cicatrization
citification1949154citification
civilisation1753944civilisation
civilization2647614civilization
covariations1745984covari_ations
curarization2348194curarization
darnation1039824d__ar_nation
deamination14411544d_eamination
debarkation1844244debar_kation
decapitation1748684decapitation
decortication1857534decortication
dedication14311964d__edication
defalcation1746224defa_lcation
deification17411664d_eification
delamination1548854delamination
demarcations1746124demar_cations
deprecation1648964d_eprecation
deprivation1788774d_eprivation
deracination1548864deracination
derivation14712784d__erivation
derivatization2755264derivatization
desalination13411134desalination
detoxication2246204detoxication
devaluation1547074deva_luation
devastation1546734deva_station
deviation13312394dev__i_ation
diffraction2053494diffrac_tion
digitization2347684digitization
dilapidations1753134dilapidations
dilatation1147394dila__tation
dimerizations2548544dimerizations
direction1289784di__rec_tion
disarticulation1863574disarticulation
dislocation14147504di_slocation
disrelation1248814di_srelation
dissipation1447214di_ssipation
dissociation1556644dissociation
distraction1449114distrac_tion
distribution1555364distribution
divagations16103834diva__gations
diversification24102784diversification
divinations15128414div__inations
duplication1647294d_uplication
edification1749354edi__fication
eradication14410114_eradication
evagination1546564_evagination
extrication2049794_extrication
fabrication1846604_fabrication
fiberization26136714fiberization
fimbriation1843554fimbri_ation
finalization2459924finalization
idealization22410274idealization
imagination1447194_imagination
imbrications1845684_imbrications
implication1747774_implication
imprecation1746544_imprecation
indication13312034_i_ndication
invagination1645644invagination
invalidation1646044invalidation
irrigation1147804_i_rrigation
irritation1048974_i_rritation
linearization2256364linearization
lubrication1546344_lubrication
marination12312814__marination
metrication15410654_metrication
nidification1847454nidification
notarization2149664notarization
polarization232010434polarization
prevarications2154744prevarications
privatization2755874privatization
revalidation1657944revalidation
rubrication1547124_rubrication
solarization211810174solarization
vacation131911894__va__cation
validation1448414__validation
variations13310774__vari_ations
variegation1543454__variegation
velarization2449904velarization
vilification2077124vilification
vindication1746354vi_ndication
vinification2068234vinification
vitalization24410974vitalization
vivifications2486124vivifications

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.390458182.1
2DLD Change Limit1247901006.50019198.5
3Display Results1001000.0631587.3
 (SQL Overall)1786911006.95325699.8
 
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.