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

38 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
flagellations175223(None) 
flagellation1652891flagellation_
flagellating1772422flagellati_ng
fellations1338063f___ellations
flagellantisms208953flagellantisms
flagellates15133723flagellat__es
flagellins1453673flagell__i_ns
lallations1038743_la__llations
appellations1643534_appellations
blastulations1552264blastulations
cancellations1754394cancellations
coagulations1546514coag_ulations
compellations1954814compellations
congelations1549734conge_lations
crenellations1553574crenellations
cupellations1643804_cupellations
fellation1238844f___ellation_
fellatios1245504f___ellatio_s
fibrillations1853104fibrillations
flagellant1454344flagella___nt
flagellantism1971494flagellanti_sm
flagellants1553064flagella__nts
flagellate14114564flagellat___e
flagellated16133284flagellat__ed
flagellin1343824flagell__i_n_
flocculations2052474flocculations
fragmentations20213564fragmentations
gelations102513094___ge_lations
lacerations1348334_lace_rations
lallation939494_la__llation_
lamentations1495984_lamentations
legislations1343754_legislations
placentations17103634placentations
spallations1356104spa__llations
stagflations1652864stag_flations
tessellations1352614tessellations
vacillations1744874_vacillations
vallations1339084_va__llations

Search took 5 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.343520965.0
2DLD Change Limit95024384.39021645.6
3Display Results38380.0162375.0
 (SQL Overall)178691384.74937627.1
 
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.