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

86 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
generational135482(None) 
generation11312422generation__
generationally1883002generationally
generations12311422generation_s
annexational1953263annexational
generating12310383generati_n_g
gestational1245113ge_stational
gyrational1444743g__yrational
negational1147153__negational
nonrational11109123non_rational
operational1347523_operational
perorational1446393perorational
recreational1455173recreational
sensational1146383sen_sational
vegetational1653373vegetational
veneration13412343veneration__
venerations14411313veneration_s
aberrational1453484aberrational
aggregational1662224aggregational
antirational1278494antirational
aspirational1455004aspirational
binational1246374bin__ational
cogeneration1546444cogeneration__
cogenerations1655914cogeneration_s
conservational1955344conservational
contractional1756064contractional
conversational1954164conversational
deaeration11313014deaeration__
deaerations12311674deaeration_s
deceptional1654774dece_ptional
deformational19122974deformational
degeneration1447284degeneration__
degenerations1546354degeneration_s
denegation1249414denegation__
denegations1348544denegation_s
denervation1567944denervation__
denervations1657094denervation_s
derivational1654264derivational
educational1444874_educational
enervation1369474_enervation__
enervations1478574_enervation_s
equational1945604_e_quational
federation1449574federation__
federations1548884federation_s
generative1458564generati__ve
generator1067594generat_o__r
generators1147534generat_o_rs
generical1247004gener__i_cal
genetical1247584gene__ti_cal
gradational1354474g_radational
hyperrational2153934hyperrational
ideational1146504_ide_ational
innovational1553834innovational
insertional1147464inser_tional
interactional1557004interactional
international1357674international
irrational1047214__irrational
levitational1553634levitational
librational1344554_librational
maturational1454184maturational
mediational1445644me_diational
migrational1444744_migrational
narrational1145444_narrational
national8311534__n__ational
nonemotional1453784nonemotional
nonnational11107834non_national
nonoperational1663774nonoperational
notational1048124__notational
nutational1047044__nutational
observational1853184observational
penetration1349894penetration__
penetrations1448854penetration_s
preoperational1853244preoperational
rational8412544____rational
reformational18113424reformational
regeneration1348194regeneration__
regenerations1447144regeneration_s
relational1047714__relational
repetitional1453724repetitional
reputational1474584reputational
reversional1454034rever_sional
subrational1345494_subrational
supernational1555614supernational
unemotional1353494_unemotional
venerating14410054venerati_n_g
vibrational1644364_vibrational

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 Limit124790868.95313938.3
3Display Results86860.0631365.1
 (SQL Overall)178691869.42218965.3
 
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.