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

165 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
deformational1912297(None) 
reformational18113421reformational
deformation1747662deformation__
deformations1846842deformation_s
informational1854342informational
conformational21153713conformational
perorational1446393peror_ational
reformation1648413reformation__
reformations1747603reformation_s
confirmational21153394confirmational
declinational1652924declinational
decoration13314424decor_ation__
decorations14312884decor_ation_s
defamation1646844def_amation__
defamations1745894def_amation_s
definitional1653034def_initional
defloration1547264deflor_ation__
deflorations1646064deflor_ation_s
defoliation1548314defoliation__
defoliations1647594defoliation_s
deformative2044974deformati__ve
denominational1752544denominational
deportation1449304deportation__
deportations1548464deportation_s
depositional1554624depo_sitional
derivational1654264de_rivational
dermatomal1552694de__rmat_omal
devotional1444674devo___tional
formation1439424__formation__
formations1538204__formation_s
generational1354824gener_ational
information16147714information__
informationally2362464informationally
informations17127034information_s
preformation1946474preformation__
preformations2045714preformation_s
recreational1455174re_creational
aberrational1453485_aberrational
affirmation1953685affirmation__
affirmations2053235affirmation_s
antirational1278495antir_ational
aspirational1455005aspir_ational
associational1552935associational
avocational1645185_avo_cational
conformation1947325conformation__
conformations2046725conformation_s
deaeration11313015deaer_ation__
deaerations12311675deaer_ation_s
debarkation1844245debarkation__
debarkations1943655debarkation_s
deceptional1654775de__ceptional
decimation15411625de_cimation__
decimations16410165de_cimation_s
declamation1646105declamation__
declamations1745305declamation_s
decollation1448195decollation__
decollations1547365decollation_s
decorating14312075decor_ati_n_g
defalcation1746225defalcation__
defalcations1845195defalcation_s
defecation1679805def_ecation__
defecations1779005def_ecation_s
deferential1554715deferenti__al
deflation13310655def__lation__
deflationary1952275def__lationary
deflations1439715def__lation_s
defoliating1645825defoliati_n_g
deforestation1754305deforestation__
deforestations1853965deforestation_s
deforesting1654795deforesti_n_g
deformalize2655275deformali__ze
deformalized2874575deformali_zed
deformalizes2754875deformali_zes
deformalizing2954225deformalizing
deforming1636705deform__i_n_g
deformities1744285deformiti__es
demarcation1647025demarcation__
demarcations1746125demarcation_s
demonstrational1862635demonstrational
denervation1567945denervation__
denervations1657095denervation_s
denominal1245695deno_m__i_nal
denotation11311085deno_tation__
denotations1239855deno_tation_s
derogation12410395dero_gation__
derogations1349395dero_gation_s
desolation11311405deso_lation__
desolations12310595deso_lation_s
desorption1346225desor_ption__
desorptions1445995desor_ption_s
detonation11310945deto_nation__
detonations1239375deto_nation_s
devotionals1552995devo___tionals
difunctional18123375dif_unctional
dilatational1352775d_ilatational
directional1445445d__irectional
dissertational1562575dissertational
distortional1353495distor__tional
dogmatical1674725d__ogmati_cal
educational1444875_e_ducational
emotional1146665_e___motional
equational1945605_e__quational
excavational2452765_excavational
explorational2252555explor_ational
foraminal1444265__for_ami_nal
foundational1652855__foundational
fractional1547135__f_ractional
frictional1546255__f_rictional
gestational1245115ge__stational
gyrational1444745__gyr_ational
hyperrational2153935hyperrational
ideational1146505ide____ational
innovational1553835inno_vational
international1357675international
intonational1256005into_national
invocational1754415invo_cational
irrational1047215___irrational
irrotational1254025irro_tational
levitational1553635le_vitational
librational1344555_libr_ational
locational1246595__lo_cational
malformation1953325malformation__
malformations2053075malformation_s
maturational1454185matur_ational
mediational1445645me__diational
migrational1444745_migr_ational
narrational1145445__narrational
negational1147155ne___gational
nonnational11107835__nonnational
nonrational11109125__nonrational
notational1048125__no_tational
observational1853185observational
operational1347525_oper_ational
ovational1246855___o_vational
perforation1649005perfor_ation__
perforations1747875perfor_ation_s
permutational1752695permutational
peroration12316005peror_ation__
perorations13314065peror_ation_s
perturbational1861205perturbational
preformationist2272225preformationist
prevocational2054015prevo_cational
probational1547085_pro_bational
promotional1555635_pro_motional
rational8412545____r_ational
recordation1449265recordation__
recordations1548645recordation_s
reflectional1753995ref_lectional
reformative1945675reformati__ve
reformatory19123445reformat_o_ry
reformatting1852705reformattin_g
reformulation1853975reformulation__
reformulations1953555reformulation_s
relational1047715re___lational
reputational1474585re_putational
rotational1048095__ro_tational
sensational1146385se__nsational
subrational1345495_subr_ational
summational1553685__summational
supernational1555615supernational
terminational1553485terminational
variational1444785__variational
vegetational1653375ve_getational
vibrational1644365_vibr_ational
vocational1546955__vo_cational

Search took 10 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 Limit1247901658.81314159.8
3Display Results1651650.1101500.0
 (SQL Overall)1786911659.32919154.4
 
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.