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

85 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
functionality216353(None) 
fictionality2054612f_ictionality
functionalism2064562functionalism
functionalist1865262functionalist
functionalists1964362functionalists
functionally2054972functional_ly
functional15116673functional___
functionalisms2163983functionalisms
functionalistic2272293functionalistic
functionalities2062703functionalities
functionaries1863013functionaries
functionary1953753functiona__ry
nationality14147933__nationality
notionality14126233__notionality
conditionality20113434conditionality
directionality2062504directionality
emotionality17144184_emotionality
factionalism1987084f_actionalism
factionally1946394f_actional_ly
fictionalise1756264f_ictionalise
fictionalize2665124f_ictionalize
fictionally1956054f_ictional_ly
fractionalize27115204fractionalize
fractionally2055294fractional_ly
frictionally2054924frictional_ly
functioning1753244function__ing
functionless1752414function_less
irrationality1654004irrationality
junctional19105364junctional___
optionality1654544__optionality
punctuality1852964punct__uality
rationality1458094__rationality
affectionally2453015affectional_ly
atonality1247075___at_onality
bifunctional19132865bifunctional___
conventionality2393045conventionality
denationalize23115905denationalize
dictionally1755985_dictional_ly
difunctional18123375difunctional___
ductility1544845du_cti___lity
exceptionality2872115exceptionality
factional1478765f_actional___
factionalisms20106365f_actionalisms
factuality1843865f_act__uality
farcicality2153285farc_i_cality
fictional1477805f_ictional___
fictionalised1964295f_ictionalised
fictionalises1855835f_ictionalises
fictionalities1963635f_ictionalities
fictionalized2864065f_ictionalized
fictionalizes2774885f_ictionalizes
finality1448345f____i_nality
foundationally2162345foundational_ly
fractional1547135fractional___
fractionalized29144115fractionalized
fractionalizes28134775fractionalizes
fractionate1654265fractiona__te
fractionating1953085fractionating
fractionation1853205fractionation
frictional1546255frictional___
function1337845function_____
functioned1643995function___ed
functions1437745function____s
fungibility2053885fun_gi_bility
futility1446975fu__ti___lity
intentionality17113455intentionality
internality1448685_in_ternality
municipality2182115munici_pality
mutationally1754275mutational_ly
nationalise111910485__nationalise
nationalism131910375__nationalism
nationalist111412165__nationalist
nationalists122010335__nationalists
nationalize20169025__nationalize
nationally1348425__national_ly
notionally1347085__notional_ly
nuptiality1553685nu_pti__ality
polytonality2062345polyt_onality
practicality2153595practi_cality
renationalize22106385renationalize
sectionalism1657105_sectionalism
sectionally1646825_sectional_ly
suctional1147685su_ctional___
tonality1139795____t_onality
unmorality1554325_un__morality

Search took 9 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 Limit124790857.92315750.3
3Display Results85850.0631349.2
 (SQL Overall)178691858.37621333.7
 
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.