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

81 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
fluorinations1610395(None) 
fluoridations1783201fluoridations
fluorination1594691fluorination_
floriations1476892fl_ori_ations
fluoridation1673622fluoridation_
fluorinating1653632fluorinati_ng
chlorinations1855503chlorinations
elutriations1246023elutri_ations
floriation1367783fl_ori_ation_
fluidizations2663413fluidizations
fluoridating1752683fluoridati_ng
fluorinates1464613fluorinat__es
fulminations1745033f_ulminations
lubrications1645733_lubrications
urinations10310683__u_rinations
abominations1646604_abominations
aldolizations2346334aldolizations
alternations1246774alter_nations
arborizations2447404arborizations
bloviations1643754bl_ovi_ations
brominations1646734_brominations
chlorination1756224chlorination_
colorizations241410324colorizations
coordinations1684974_coordinations
coronations13410674__coronations
culminations1646534_culminations
denominations16117844denominations
dominations14611034__dominations
eliminations1447604el_iminations
elucidations1544514elu_cidations
elutriation1146714elutri_ation_
eluviations14115794elu_vi_ations
excoriations2147494excori_ations
fabrications1945924f_abrications
factorizations2855744factorizations
fascinations1746354f_ascinations
fiberizations27136344fiberizations
fimbriations1943324fimbri_ations
flirtations14104264fl_ir_tations
floatations1444104fl_o_atations
flotations1366874fl_o__tations
fluctuations1752564flu_ctuations
fluidization2553604fluidization_
fluoridates1573924fluoridat__es
fluorinate1365104fluorinat___e
fluorinated1563884fluorinat__ed
fluorocarbons2012994fluorocarbons
foliations1399944f__oli_ations
foreordinations19102064foreordinations
formations1538194f__or_mations
fornications1755394f__ornications
fulmination1655884f_ulmination_
fumigations1744924f_u_migations
furcations1547534f_u_r_cations
fustigations1644764f_ustigations
glamorizations2664574glamorizations
illuminations1554444illuminations
iodinations1268834__iodinations
lacrimations1645704_lacrimations
laminations1339794_l_aminations
lionizations2147104_lionizations
lubrication1546344_lubrication_
lunations9310724_lu___nations
marinations13411264__marinations
memorizations2649504memorizations
motorizations2449084motorizations
nominations13410524__nominations
ordinations1247974___ordinations
preordinations1765694preordinations
relubrications1854194relubrications
renominations15108294renominations
rubrications1646264_rubrications
ruinations1039604_ru__inations
ruminations1349394_ru_minations
subordinations1753984subordinations
subornations1446124subor_nations
supinations1348824_su_pinations
theorizations2576124theorizations
urination9312174__u_rination_
valorizations2597774valorizations
vaporizations2776944vaporizations

Search took 6 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.1261418182.5
2DLD Change Limit95024815.64016848.2
3Display Results81810.0461760.9
 (SQL Overall)178691815.81230745.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.