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

110 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
valuational144405(None) 
salutational1253322salutational
salvational1443712salvational
valuation1249972valuation__
valuationally1962532valuationally
valuations1348782valuation_s
variational1444782variational
avocational1645183avocational
calculational1752583calculational
equational1945603_equational
evaluation1358183evaluation__
evaluations1457323evaluation_s
lactational1344653lactational
maturational1454183maturational
narrational1145443narrational
radiational1245953radiational
relational1047713rel_ational
situational1144583situational
vallation1239753vallation__
vallations1339093vallation_s
valuating1338653valuati_n_g
vibrational1644363vibrational
vocational1546953v_ocational
volitional1345413vol_itional
adaptational1572794adaptational
additional1244644_additional
agitational1244844agitational
alation72920554_al_ation__
alations82518894_al_ation_s
binational1246374_binational
citational1266464_citational
delusional1153304delu_sional
devaluation1547074devaluation__
devaluations1646354devaluation_s
dilatational1352774dilatational
educational1444874educational
evacuation1547164evacuation__
evacuations1646304evacuation_s
evaluating1456024evaluati_n_g
factional1478764fa__ctional
fluxional1952404_flu_xional
gestational1245114gestational
gradational1354474gradational
gyrational1444744_gyrational
halation11313854hal_ation__
halations12312394hal_ation_s
ideational1146504_ideational
illusional1053404illu_sional
inhalational1553044inhal_ational
intuitional1155294intuitional
involutional1553574involu_tional
irrational1047214_irrational
lallation939494lallation__
lallations1038744lallation_s
librational1344554librational
locational1246594_locational
matutinal1143184matu_ti_nal
mediational1445644mediational
migrational1444744migrational
mutational1246514_mutational
national8311534___national
navigational1653294navigational
negational1147154_negational
nonnational11107834nonnational
nonrational11109124nonrational
notational1048124_notational
nutational1047044_nutational
occupational1883004occupational
operational1347524operational
ovational1246854__ovational
palatial10410624pal_ati__al
palmation13310224palmation__
palmations1438734palmation_s
palpation1339074palpation__
palpations1437654palpation_s
populational1654414populational
probational1547084probational
rational8412544___rational
reductional1454594reductional
reputational1474584reputational
revaluation1458144revaluation__
revaluations1557634revaluation_s
rotational1048094_rotational
saltation9312004saltation__
saltations10310624saltation_s
salutation1048904salutation__
salutations1147644salutation_s
salvation1239294salvation__
salvations1338134salvation_s
sensational1146384sensational
stational948514__stational
subnational1354574subnational
subrational1345494subrational
suctional1147684__suctional
summational1553684summational
tuitional946054__tuitional
vacation131911894va_cation__
vacationed1643424va_cationed
vacationer1543304va_cationer
vacations141910554va_cation_s
validation1448414validation__
validations1547244validation_s
valuator1196734valuat_o__r
valuators1286474valuat_o_rs
variation12312394variation__
variationally1953014variationally
variations13310774variation_s
vegetational1653374vegetational
volution1198604volu_tion__
volutions12108394volu_tion_s

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 Filter1786911488190.436409841.7
2DLD Change Limit1488191109.08016389.8
3Display Results1101100.0631746.0
 (SQL Overall)1786911109.57918654.5
 
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.