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

46 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
fibrillations185310(None) 
fibrillation1753521fibrillation_
defibrillations2161692defibrillations
fibrillating1852702fibrillati_ng
defibrillation2061903defibrillation_
distillations1446943distillations
fabrications1945923fabri_cations
fiberizations27136363fiberi_zations
fibrillates1653143fibrillat__es
fimbriations1943343fimbri__ations
sibilations13127933sib_i_lations
titillations1244443ti_tillations
cantillations1545734cantillations
circulations1648484ci_rculations
defibrillating21111604defibrillati_ng
defibrillators2061214defibrillat_ors
defibrinations2053414defibri_nations
disrelations1348504disr_elations
distillation1347734distillation_
fabrication1846604fabri_cation_
fellations1338064f___ellations
fiberization26136714fiberi_zation_
fibrillate1563544fibrillat___e
fibrillated1762694fibrillat__ed
filiations13119094f___iliations
fimbriation1843554fimbri__ation_
finalizations2549254finalizations
flagellations1752234flagellations
floriations1476914flori__ations
formulations1745634f_ormulations
illations9311394____illations
imbrications1845684imbri_cations
instillations1344924instillations
irrigations1246944_irri_gations
irritations1147834_irri_tations
jubilations2045364jub_i_lations
librations12149064libr___ations
lubrications1645734lubri_cations
oscillations1445114_oscillations
pixilations2045334pi_xi_lations
rubrications1646264rubri_cations
scintillations1662754scintillations
sibilation12128774sib_i_lation_
titillation1145044ti_tillation_
vacillations1744874_vacillations
vibrations15157374vibr___ations

Search took 10 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 Limit95024468.95310613.6
3Display Results46460.0331393.9
 (SQL Overall)178691469.10919617.0
 
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.