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

52 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
functionalities206270(None) 
fictionalities1963632f_ictionalities
functionalisms2163983functionali_sms
functionalistic2272293functionalisti_c
functionalists1964363functionali_sts
functionality2163533functionalit__y
functionaries1863013functiona__ries
nationalities1356913__nationalities
notionalities1355923__notionalities
emotionalities1673844_emotionalities
fictionalises1855834f_ictionali_ses
fictionalizes2774884f_ictionali_zes
fractionalizes28134774fractionali_zes
functionalism2064564functional__ism
functionalist1865264functional__ist
irrationalities1563124irrationalities
optionalities1574544__optionalities
punctualities1753464punct__ualities
rationalities1357284__rationalities
atonalities1148405___at_onalities
denationalizes24115525denationali_zes
ductilities1446205du_cti___lities
factionalisms20106365f_actionali_sms
factualities1754535f_act__ualities
farcicalities2053575farc_i_calities
fictionalise1756265f_ictionali_se_
fictionalised1964295f_ictionali_sed
fictionalising2062765f_ictionalising
fictionality2054615f_ictionalit__y
fictionalize2665125f_ictionali_ze_
fictionalized2864065f_ictionali_zed
fictionalizing2963265f_ictionalizing
finalities1349905f____i_nalities
fractionalize27115205fractionali_ze_
fractionalized29144115fractionali_zed
fractionalizing30112995fractionalizing
fractionates1754165fractiona__t_es
functional15116675functional_____
functionally2054975functional___ly
functionless1752415function_l__ess
fungibilities1964515fun_gi_bilities
futilities1348865fu__ti___lities
internalities1358635_in_ternalities
municipalities2062575munici_palities
nationalises122910365__nationali_ses
nationalizes21178615__nationali_zes
nuptialities1454785nu_pti__alities
polytonalities1982745polyt_onalities
practicalities2053565practi_calities
renationalizes23115905renationali_zes
tonalities101711735____t_onalities
unmoralities1485565_un__moralities

Search took 5 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 Filter178691658740.313570897.8
2DLD Change Limit65874523.65618018.1
3Display Results52520.0461130.4
 (SQL Overall)178691524.01544505.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.