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

87 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
functionalistic227229(None) 
functionalist1865262functionalist__
functionalists1964362functionalist_s
functionalism2064563functionalis__m
functionalisms2163983functionalis_ms
functionalities2062703functionali_ties
functionality2163533functionali_t_y
nationalistic1595553__nationalistic
emotionalistic1862834_emotionalistic
irrationalistic1772714irrationalistic
rationalistic15125454__rationalistic
factionalism1987085f_actionalis__m
factionalisms20106365f_actionalis_ms
fictionalise1756265f_ictionalis__e
fictionalised1964295f_ictionalis_ed
fictionalises1855835f_ictionalis_es
fictionalising2062765f_ictionalising
fictionalities1963635f_ictionali_ties
fictionality2054615f_ictionali_t_y
functional15116665functional_____
functionally2054975functional___ly
functionaries1863015functionari__es
functionless1752415function_les__s
nationalist111412165__nationalist__
nationalists122010335__nationalist_s
nominalistic1653815__nomi_nalistic
regionalistic1663095__regionalistic
animalistic1555296_an__i_malistic
annalistic1276446_an____nalistic
cannibalistic1992156can_ni_balistic
centralistic1655116cen_t__ralistic
colonialistic1773186___colonialistic
conceptualistic2072816conceptualistic
educationalist1763286educationalist__
educationalists1892726educationalist_s
emotionalist14146876_emotionalist__
emotionalists15155826_emotionalist_s
fatalistic1546716f__at___alistic
fictionalize2665126f_ictionali__ze
fictionalized2864066f_ictionali_zed
fictionalizes2774886f_ictionali_zes
fictionalizing2963266f_ictionalizing
fictionist1558026f_iction__ist__
fictionists1655996f_iction__ist_s
fractionalize27115206fractionali__ze
fractionalized29144116fractionali_zed
fractionalizes28134776fractionali_zes
fractionalizing30112996fractionalizing
functionary1953756functiona____ry
functioning1753246function__i__ng
functions1437746function___s___
irrationalist1355816irrationalist__
irrationalists1464736irrationalist_s
junctional19105356junctional_____
mentalistic1555986men_t___alistic
mutualistic1553346mu__t__ualistic
nationalise111910486__nationalis__e
nationalised13197816__nationalis_ed
nationalises122910366__nationalis_es
nationalising1454726__nationalising
nationalism131910376__nationalis__m
nationalisms14259796__nationalis_ms
nationalities1356916__nationali_ties
nationality14147936__nationali_t_y
naturalistic1484546__nat_uralistic
notionalities1355926__notionali_ties
notionality14126236__notionali_t_y
paternalistic1753266__paternalistic
personalistic1763646__personalistic
racialistic1554676_rac_i__alistic
rationalist111812126__rationalist__
rationalists121910066__rationalist_s
reductionistic1962126reduction__istic
reunionistic1452716reun__ion__istic
sciolistic1446596__sc_io__listic
sectionalism1657106_sectionalis__m
sectionalisms1756526_sectionalis_ms
sensationalist14235296sensationalist__
sensationalists15244616sensationalist_s
socialistic1565816_soc_i__alistic
specialistic1854186spec_i__alistic
synchronistic2363446synchron__istic
totalistic1246596____t_otalistic
universalistic1971746_universalistic
unrealistic1353986_un___realistic
vocationalist1855106vocationalist__
vocationalists1964086vocationalist_s

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.1231452772.4
2DLD Change Limit95024877.45612744.6
3Display Results87870.0601450.0
 (SQL Overall)178691877.63923391.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.