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

149 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
explorational225255(None) 
exploration2066712exploration__
explorations2185612exploration_s
expectational2452493expectational
expositional2153943exp_ositional
aspirational1455004asp_irational
collocational1753054collocational
examinational2252184examinational
excavational2452764ex_cavational
expiration19610714exp_iration__
expirations2069584exp_iration_s
explanation2045264explanation__
explanations2144624explanation_s
explication2248454explication__
explications2347534explication_s
exploitation2154704exploitation__
exploitations2254214exploitation_s
explorative2354244explorati__ve
exploratively2862424exploratively
exploratory2353134explorat_o_ry
exportation2047444exp_ortation__
exportations2146654exp_ortation_s
hyperrational2153934hyperrational
locational1246594___locational
operational1347524_op_erational
perorational1446394_perorational
probational1547084__probational
suprarational1552924suprarational
aberrational1453485_aberrational
antirational1278475_antirational
apparitional1652765_apparitional
appositional1683945_appositional
arbitrational1553185arbitrational
avocational1645185__avocational
coloration12913185_coloration__
colorations13911895_coloration_s
conformational21153715conformational
connotational1554155connotational
convocational2054475convocational
declinational1652925declinational
defloration1547265defloration__
deflorations1646065defloration_s
deformational19122975_deformational
depositional1554625dep_ositional
dilatational1352775_dilatational
distortional1353485distor_tional
educational1444875e__ducational
elaboration1345745elaboration__
elaborations1444925elaboration_s
emotional1146665e__mo__tional
equational1945605e___quational
evaporation1645555evaporation__
evaporations1744695evaporation_s
exaltation1748495exal_tation__
exaltations1847295exal_tation_s
exceptional2254445ex__ceptional
exclamation22104635exclamation__
exclamations23104105exclamation_s
excoriation2048435ex_coriation__
excoriations2147525ex_coriation_s
execration1949835ex_ecration__
execrations2048925ex_ecration_s
exfoliation2145255exfoliation__
exfoliations2244785exfoliation_s
exhilaration2252525exhilaration__
exhilarations2352415exhilaration_s
exhortation2145025ex_hortation__
exhortations2244455ex_hortation_s
exoneration1847655exoneration__
exonerations1947015exoneration_s
expansional2052805exp__ansional
expatiation2046835expatiation__
expatiations2146135expatiation_s
expatriation2154335expatriation__
expatriations2253765expatriation_s
expectation2266485expectation__
expectations2365845expectation_s
expectoration2452565expectoration__
expectorations2552195expectoration_s
expiation18710425exp__iation__
expiations1959665exp__iation_s
explantation2153975explantation__
explantations2253645explantation_s
explicating2356125explicati_n_g
exploiting2044895explo_iti_n_g
exploring1945545explor__i_n_g
explosion18115215explo__sion__
explosions19134665explo__sion_s
exporting1937325exp_or_ti_n_g
exposition1947165exp_osition__
expositions2046845exp_osition_s
expressional2164215exp_ressional
expropriation2453995expropriation__
expropriations2553325expropriation_s
expurgation2154555expurgation__
expurgations2274125expurgation_s
extortion1646725ex_tor_tion__
extortionary2262695ex_tor_tionary
extortionate1962935ex_tor_tionate
extortioner1852655ex_tor_tioner
extortions1746475ex_tor_tion_s
exultation1747535exul_tation__
exultations1846525exul_tation_s
generational1354825_generational
gyrational1444745___gyrational
immigrational1851935immigrational
inclinational1553935inclinational
informational1854345_informational
innovational1553835_innovational
inspirational1554415inspirational
intonational1256005_intonational
invocational1754415_invocational
irrational1047215___irrational
irrotational1254025_irrotational
librational1344555__librational
maturational1454185_maturational
migrational1444745__migrational
narrational1145445__narrational
nonrational11109125__nonrational
nonvocational1853705nonvocational
notational1048125___notational
oppositional1683845_oppositional
ovational1246855____ovational
populational1654415pop_ulational
positional1247905__p_ositional
preoperational1853245preop_erational
prevocational2054015prevocational
promotional1555635__promotional
proportional1655815propor_tional
proration11415985__proration__
prorations12314465__proration_s
rational8412545_____rational
reformational18113425_reformational
relational1047715_rel__ational
reputational1474585rep_utational
rotational1048095___rotational
salutational1253325_salutational
salvational1443715_sal_vational
sexploitation2252955sexploitation__
sexploitations2352715sexploitation_s
speciational1654315_speciational
subrational1345495__subrational
supernational1555615supernational
suppositional1763065suppositional
supranational1552995supranational
ultrarational1363515ultrarational
valuational1444045_val_uational
vibrational1644365__vibrational
vocational1546955___vocational

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.390458182.1
2DLD Change Limit1247901498.50014681.2
3Display Results1491490.1101354.5
 (SQL Overall)1786911499.00019854.6
 
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.