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

82 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
generationally188300(None) 
generational1354822generationa_l_
operationally1854643_operationally
sensationally1654303sen_sationally
educationally1963314_educationally
equationally2453824_e_quationally
generation11312424generation____
generations12311424generation___s
generically1747394gener__i_cally
genetically1759204gene__ti_cally
gradationally1853264g_radationally
ideationally1674884_ide_ationally
internationally1873714internationally
irrationally1555244__irrationally
nationally1348424__n__ationally
observationally2371994observationally
rationally1349424____rationally
relationally1555074__relationally
unemotionally1853764_unemotionally
adaptationally2061995adaptationally
affectionally2453015affe_ctionally
annexational1953265annexationa_l_
avocationally21113695_avocationally
bisectionally2053155bise_ctionally
cinematically2265755cinemati_cally
coeducationally23102355coeducationally
conditionally1954795con_ditionally
conjugationally2862355conjugationally
conventionally2254985conventionally
devotionally1953725__devotionally
emotionally1655305___emotionally
energetically1985275_energeti_cally
erosionally1454665___erosionally
erratically16410125_e_rrati_cally
exceptionally2753525_exceptionally
foundationally2162345foundationally
fractionally2055295___fractionally
functionally2054975fun__ctionally
generalizable2561645generali_zable
generally1347345gener_____ally
generating12310385generati_n___g
genitivally1853515gen__iti_vally
geostationary1781445geostationa_ry
germinally1655255g__er_mi_nally
gestational1245115ge_stationa_l_
gravitationally2271845gravitationally
gyrational1444745g__yrationa_l_
hieratically2048175_hierati_cally
inertially1349335_iner_ti__ally
informationally2362465informationally
inspirationally2072545inspirationally
intentionally1655985_intentionally
kinematically2454725kinemati_cally
locationally17124715__locationally
meridionally1852855__meridionally
motivationally2262495motivationally
mutationally1754275__mutationally
navigationally2162235navigationally
negational1147155__negationa_l_
nonrational11109125non_rationa_l_
notionally1347085__n__otionally
nutritionally16103545_nutritionally
occupationally2362125occupationally
operatically1949325_operati_cally
operational1347525_operationa_l_
orientationally1872055orientationally
penetratingly1961845penetrati_n_gly
pentagonally1862085pen_ta_gonally
perorational1446395perorationa_l_
probationally2054095_probationally
recreational1455175recreationa_l_
sectionally1646825__se_ctionally
sensational1146385sen_sationa_l_
situationally1653395_situationally
tetragonally1662595te_tra_gonally
untraditionally1982835_untraditionally
valuationally1962535_valuationally
variationally1953015_variationally
vegetational1653375vegetationa_l_
veneration13412345veneration____
venerations14411315veneration___s
vocationally20125005__vocationally

Search took 7 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 Filter178691950240.360496363.9
2DLD Change Limit95024826.15615436.0
3Display Results82820.0631301.6
 (SQL Overall)178691826.57927160.8
 
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.