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

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

83 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
bidirectionally237151(None) 
bidirectional18152492bidirectiona_l_
bisectionally2053153b__isectionally
dictionally1755984__di__ctionally
directional1445444__directiona_l_
directionality2062504__directionality
ideationally1674884_id__eationally
inflectionally2262954_inflectionally
unidirectional1762124unidirectiona_l_
additionally1753315addi___tionally
affectionally2453015__affectionally
bisectional1554645b__isectiona_l_
dimensionally1962355__dimensionally
fictionally1956055__fi__ctionally
fractionally2055295___fractionally
frictionally2054925___frictionally
intentionally1655985_i_ntentionally
irrationally1555245___irrationally
nondirectional1763085nondirectiona_l_
omnidirectional20111115omnidirectiona_l_
sectionally1646825____sectionally
vivisectional2162105vivisectiona_l_
adaptationally2061996_adaptationally
adjectivally2851366_ad_jecti_vally
bifunctional19132866bi_functiona_l_
bioregional1452186bi_ore_giona_l_
biparentally1962196biparent___ally
codirection1644746codirection____
codirections1744706codirection___s
conditionally1954786condi___tionally
congressionally2172136congressionally
conjunctionally2972476conjunctionally
conventionally2254976_conventionally
correctional1675326_correctiona_l_
devotionally1953726__d_evotionally
dialectically2164176di_alecti_cally
dictional1268616__di__ctiona_l_
dictionary1654596__di__ctiona_ry
didactically2154416__didacti_cally
direction1289786__direction____
directionless1661936__directionless
directions1379646__direction___s
discretionary1962276discre_tiona_ry
diuretically18155706di_ure_ti_cally
educationally1963316_ed_ucationally
eidetically1768226eid__e_ti_cally
exceptionally2753526__exceptionally
factionally1946396____factionally
functionally2054976___functionally
generationally1883006gener_ationally
ideational1146506_id__eationa_l_
identically1748466_id__enti_cally
idiomatically2155556_idiomati_cally
idiotically1747526_idi__oti_cally
impractically2454366_impracti_cally
indirection1456386indirection____
indirections1556196indirection___s
inflectional1754386_inflectiona_l_
informationally2362466informationally
inspirationally2072546inspir_ationally
intensionally1654396_i_ntensionally
internationally1873716internationally
intestinally1556016_i_ntesti_nally
medicinally1953286medi__c_i_nally
microtonally1953576mi_cr_ot_onally
misdirection1754166misdirection____
misdirections1854236misdirection___s
motivationally2262496moti_vationally
navigationally2162236navi_gationally
nutritionally16103546_nutr_itionally
objectionably29132226__objectionably
observationally2371996observationally
operationally1854646_oper_ationally
positionally1754926posi___tionally
rationally1349426____r_ationally
redirection1446056redirection____
redirections1546176redirection___s
regionally1445536____re_gionally
relationally1555076____relationally
situationally1653396__situationally
traditionally1753806tradi___tionally
unintentionally1872746unintentionally
variationally1953006__variationally

Search took 8 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 Limit95024837.18613223.5
3Display Results83830.0501660.0
 (SQL Overall)178691837.59623524.4
 
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.