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

56 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
flagellated1613328(None) 
flagellate14114561flagellate_
flagellates15133721flagellates
flabellate15104312flabellate_
biflagellate1871633biflagellate_
fellated1239563f___ellated
flagella1244563flagella___
flagellant1454343flagella_nt
flagellants1553063flagellants
flagellar1343813flagella__r
flagellating1772433flagellating
flagellation1652893flagellation
labellate11126923_labellate_
lamellate11116703_lamellate_
areolated1089714__areolated
castellated1443274castellated
coagulated1496534coag_ulated
crenellated1452524crenellated
fabulated1546324f_a_bulated
facelifted1952174f_acelifted
faceplate1645224f_aceplate_
faceplates1744614f_aceplates
falcated1438484f_a__lcated
faveolate15104624f_aveolate_
fellate10313434f___ellate_
fellates11312754f___ellates
fibrillated1762694fibrillated
flabella1344964flabella___
flagellantism1971494flagellantism
flagellations1752234flagellations
flagellin1343824flagell__in
flagellins1453674flagell_ins
flagellum1572654flagell__um
flagellums1692184flagell_ums
flageolet1355644flageol__et
flageolets1452854flageolet_s
flannelled1442844flannell__ed
flocculated1952304flocculated
floreated1346574flore__ated
fragmentated1962024fragmentated
gelated93615644___ge_lated
glabellae1243744glabella_e_
labelled11278294_labell__ed
lacerated122210684_lace_rated
lamellae10117034_lamella_e_
lamellately1651534_lamellately
lapelled11227084_lapell__ed
legislated1263584_legislated
ligulated11247364_lig_ulated
ocellated1245454__ocellated
patellate1147484_patellate_
regelated1139724_rege_lated
scutellated1461624scutellated
stellated1046804__stellated
tessellated1252184tessellated
vacillated1654634_vacillated

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 Filter1786911488190.436409841.7
2DLD Change Limit148819569.44015764.7
3Display Results56560.0301866.7
 (SQL Overall)178691569.90618038.7
 
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.