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

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

89 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
fluctuational186123(None) 
fluctuation1653072fluctuation__
fluctuations1752562fluctuation_s
fluctuating1752603fluctuati_n_g
lactational1344653_lact_ational
educational1444874educ__ational
foundational1652854fou_ndational
illustrational1461554illustrational
locational1246594_loc__ational
mutational1246514_mu_t_ational
nutational1047044_nu_t_ational
salutational1253324salu_t_ational
situational1144584__situational
acculturational1971665acculturational
actuation11310335__actuation__
actuations1239295__actuation_s
adaptational1572795adapt_ational
agitational1244845_agit_ational
arbitrational1553185arbitrational
avocational1645185avoc__ational
calculational1752585calculational
citational1266465___citational
computational1994575computational
dilatational1352775dilat_ational
effectuation2052285effectuation__
effectuations2151955effectuation_s
elucidation1445015elucidation__
elucidations1544515elucidation_s
equational1945605___equational
eructation1248335eruct_ation__
eructations1347235eruct_ation_s
excavational2452765_excavational
expectational2452495expect_ational
factional1478765f_ac___tional
fictional1477805f_ic___tional
flirtation1354825flirt_ation__
flirtations14104265flirt_ation_s
floatation1344685float_ation__
floatations1444105float_ation_s
flocculation1952805flocculation__
flocculations2052475flocculation_s
flotation1267815fl_ot_ation__
flotations1366875fl_ot_ation_s
fluctuant1452285fluctua___n_t
fluctuate1443115fluctuat____e
fluctuated1642495fluctuat___ed
fluctuates1543075fluctuat___es
fluxional1952405fl___u_xional
fractional1547135frac___tional
frictional1546255fric___tional
frustration1444815frustration__
frustrations1544535frustration_s
functional15116675f_u__nctional
gestational1245115_gest_ational
intuitional1155295__intuitional
invitational1554905invit_ational
irrotational1254025irrot_ational
lactation11310815_lact_ation__
lactations1239425_lact_ation_s
levitational1553635_levitational
librational1344555_l_ibrational
limitational1453545_limitational
lustration1048355_lustration__
lustrations1147625_lustration_s
maturational1454185__maturational
multinational1553765multinational
notational1048125__not_ational
nutritional1154785_nu_tritional
occupational1883005_occupational
permutational1752695permutational
postulational1553915_postulational
punctuation1543485punctuation__
punctuations1643185punctuation_s
recreational1455175_recreational
reluctation1347965reluct_ation__
reluctations1446755reluct_ation_s
reputational1474585reput_ational
rotational1048095__rot_ational
speciational1654315spec_iational
stational948515___st_ational
subnational1354575_su_bnational
subrational1345495_su_brational
suctional1147685_suc___tional
summational1553685_su_mmational
tuitional946055____tuitional
ultrarational1363515ultrarational
valuational1444055__valuational
vegetational1653375veget_ational
vocational1546955_voc__ational

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.393454684.5
2DLD Change Limit124790898.28015071.3
3Display Results89890.0631412.7
 (SQL Overall)178691898.73620454.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.