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

50 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
directionality206250(None) 
dimensionality2071523dimensionality
directional1445443directional___
fictionality2054613fi__ctionality
irrationality1654003_irrationality
bidirectionally2371514bidirectional_ly
bisectionally2053154bisectional_ly
dictionally1755984di__ctional_ly
directionless1661934direction_less
directivity2054094directi___vity
exceptionality2872114exceptionality
functionality2163534_functionality
intentionality17113454intentionality
rationality1458094__r_ationality
affectionally2453015affectional_ly
antirationality1872595antir_ationality
bidirectional18152495bidirectional___
bisectional1554645bisectional___
conditionality20113435conditionality
conventionality2393045conventionality
dictional1268615di__ctional___
dictionaries1554785di__ctionaries
dictionary1654595di__ctiona__ry
digestibility2053725digesti_bility
dimensionally1962355dimensional_ly
direction1289785direction_____
directions1379645direction____s
directorate1453265direct_ora__te
emotionality17144185__emotionality
erectility1546265_erecti___lity
extensionality2461985extensionality
fictionalise1756265fi__ctionalise
fictionalize2665125fi__ctionalize
fictionally1956055fi__ctional_ly
fractionalize27115205_fractionalize
fractionally2055295_fractional_ly
frictionally2054925_frictional_ly
ideationally1674885_ideational_ly
intensionality17152955intensionality
irrationalism1555115_irrationalism
irrationalist1355815_irrationalist
irrationalists1464735_irrationalists
irrationally1555245_irrational_ly
microtonality2063155microt_onality
nationality14147935___nationality
notionality14126235___notionality
optionality1654545___optionality
practicality2153595_practi_cality
sectionalism1657105__sectionalism
sectionally1646825__sectional_ly

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.343520965.0
2DLD Change Limit95024506.62314347.6
3Display Results50500.0331515.2
 (SQL Overall)178691506.99925530.9
 
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.