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

84 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
bidirectional1815249(None) 
bidirectionally2371512bidirectionally
directional1445442__directional
unidirectional1762122unidirectional
bisectional1554643b__isectional
nondirectional1763083nondirectional
omnidirectional20111113omnidirectional
vivisectional2162103vivisectional
bifunctional19132864bi_functional
bioregional1452184bi_ore_gional
codirection1644744codirection__
codirections1744704codirection_s
correctional1675324_correctional
dictional1268614__di__ctional
direction1289784__direction__
directions1379644__direction_s
ideational1146504_id__eational
indirection1456384indirection__
indirections1556194indirection_s
inflectional1754384_inflectional
misdirection1754164misdirection__
misdirections1854234misdirection_s
redirection1446054redirection__
redirections1546174redirection_s
abstractional1753265abstractional
additional1244645addi___tional
affectional1953895__affectional
antirational1278485antir_ational
aspirational1455005aspir_ational
biconditional1862245biconditional
bidialectal1661465bidialect___al
bijection20134795b__ijection__
bijections21134935b__ijection_s
bilection13156805b__ilection__
bilections14136505b__ilection_s
binational1246375b__i_national
bisection13136985b__isection__
bisectionally2053155b__isectionally
bisections14136735b__isection_s
codirecting1743645codirecti_n_g
connectional1646725_connectional
contractional1756065contractional
convectional1947045_convectional
deceptional1654775__deceptional
difunctional18123375di_functional
digressional1453175di_gressional
dimensional1453045__dimensional
directing1338825__directi_n_g
directionality2062505__directionality
directorial1453935__directorial
fictional1477805__fi__ctional
fractional1547135___fractional
frictional1546255___frictional
indicational1545755indi_cational
insertional1147465_i_nsertional
instructional1555095instructional
insurrectional1662605insurrectional
intentional11128845_i_ntentional
interactional1557005interactional
interjectional23195605interjectional
intersectional16146255intersectional
irrational1047215___irrational
librational1344555li_br_ational
limitational1453545limi_tational
mediational1445645medi__ational
midsection1544435mid_section__
midsections1644405mid_section_s
migrational1444745mi_gr_ational
misdirecting1853245misdirecti_n_g
projectional2355425_projectional
radiational1245955radi__ational
recreational1455175_recreational
redactional1454355red__actional
redirecting1545615redirecti_n_g
reductional1454595red__uctional
reflectional1753995_reflectional
resurrectional1661755resurrectional
sectional1149425____sectional
tractional1248055___tractional
tridimensional177845tridimensional
unidimensional1771305unidimensional
vibrational1644365vi_br_ational
vivisection1952705vivisection__
vivisections2052715vivisection_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 Filter1786911247900.390458182.1
2DLD Change Limit124790849.31313399.5
3Display Results84840.0631333.3
 (SQL Overall)178691849.76618297.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.