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

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

47 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
multifunctional2271501multifunctional_
multifunction2062053multifunction___
multinational1553764multi__national_
multinationals1662224multi__nationals
bifunctional19132865___bifunctional_
difunctional18123375___difunctional_
dysfunctional2261806__dysfunctional_
functional15116676_____functional_
hyperfunctional2881356hyperfunctional_
malfunction1852806mal__function___
malfunctioned2161346mal__function_ed
malfunctioning227856mal__functioning
malfunctions1952666mal__function__s
metafictional2071266m_etaf_ictional_
multidivisional2181006multidivisional_
multifactorial2191476multif_actorial_
multination1348976multi__nation___
multiregional1661856multi__regional_
multiunion1253596multi_un__ion___
nonfunctional1853766__nonfunctional_
antinational1297487_anti__national_
conjunctional2454167__conjunctional_
functionally2054977_____functionally
functionary1953757_____functionary
institutional1353507institu__tional_
instructional1555097inst_ru_ctional_
junctional19105367_____junctional_
jurisdictional2471197ju_risdictional_
maturational1454187m_at__urational_
misfunction1853947m__isfunction___
misfunctioned2161717m__isfunction_ed
misfunctioning2261237m__isfunctioning
misfunctions1953717m__isfunction__s
motivational1753917m_oti__vational_
multicultural1763407multicu_lt_ural_
multifactor1853237multif_act_o___r
multifocal1753667multif_____ocal_
multinomial1553157multi__nomi__al_
multinomials1662227multi__nomi__als
multiplication2063337multiplication___
multiplications2163187multiplication__s
multiracial1554507multi_rac_i__al_
multispectral1971307multispect__ral_
multiterminal1781827multi_termi_nal_
mutational1246517mu_t____ational_
substitutional1662047substitu__tional_
ultrarational1363517_ult_rarational_

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 Filter178691950240.703254183.5
2DLD Change Limit95024478.09311741.5
3Display Results47470.0301566.7
 (SQL Overall)178691478.82620246.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.