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 “fictionalise” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
fictionalise175626(None) 
fictionalised1964291fictionalised
fictionalises1855831fictionalises
fictionalize2665121fictionalize
factionalism1987082factionalism
fictionality2054612fictionality
fictionalized2864062fictionalized
fictionalizes2774882fictionalizes
dictionaries1554783dictionaries
factionalisms20106363factionalisms
fictional1477803fictional___
fictionalising2062763fictionalising
fictionalities1963633fictionalities
fictionally1956053fictional_ly
fictionist1558023fiction__ist
fictionize2454203fiction__ize
fractionalize27115203fractionalize
functionalism2064563functionalism
functionalist1865263functionalist
nationalise111910483_nationalise
rationalise111910543_rationalise
sectionalism1657103sectionalism
dictional1268614dictional___
dictionally1755984dictional_ly
emotionalism16185754emotionalism
emotionalist14146874emotionalist
emotionalize2354784emotionalize
factional1478764factional___
factionally1946394factional_ly
fictionalizing2963264fictionalizing
fictioneers1652684fictioneers_
fictionists1655994fiction__ists
fictionized2653364fiction__ized
fictionizes2554104fiction__izes
fictionizing2753804fictionizing
fictions132410744fiction___s_
finalise113112574f___i_nalise
fractionalized29144114fractionalized
fractionalizes28134774fractionalizes
frictional1546254frictional___
frictionally2054924frictional_ly
frictionless1752554friction_less
functionalisms2163984functionalisms
functionalists1964364functionalists
functionality2163534functionality
functionaries1863014functionaries
internalise111510554_internalise
lectionaries1454774lectionaries
nationalised13197814_nationalised
nationalises122910364_nationalises
nationalism131910374_nationalism
nationalist111412164_nationalist
nationalize20169024_nationalize
rationalised13237724_rationalised
rationalises122010374_rationalises
rationalism131910234_rationalism
rationalist111812124_rationalist
rationalize20199754_rationalize
sectionalisms1756524sectionalisms
sectionals1247274sectional_s_
vocationalism2054414vocationalism
vocationalist1855104vocationalist

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 Filter1786911247900.406440125.6
2DLD Change Limit124790627.11017551.3
3Display Results62620.0302066.7
 (SQL Overall)178691627.54623680.2
 
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.