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

58 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
flagellates1513372(None) 
flagellate14114561flagellate_
flagellated16133281flagellated
flabellate15104312flabellate_
flagellants1553062flagellants
biflagellate1871633biflagellate_
faceplates1744613f_aceplates
fellates11312753f___ellates
flagella1244563flagella___
flagellant1454343flagella_nt
flagellantism1971493flagellantism
flagellar1343813flagella__r
flagellating1772433flagellating
flagellation1652893flagellation
flagellations1752233flagellations
flagellins1453673flagell_ins
flagellums1692183flagell_ums
flageolets1452853flageolet_s
labellate11126923_labellate_
lamellate11116703_lamellate_
agemates111110024__age_mates
baseplates14114404_baseplates
coagulates13137454coag_ulates
dinoflagellates20191294dinoflagellates
fabulates1447734f_a_bulates
faceplate1645224f_aceplate_
favellas1446164f_avella__s
faveolate15104624f_aveolate_
fellate10313434f___ellate_
fellated1239564f___ellated
fibrillates1653144fibrillates
flabella1344964flabella___
flagellantisms208954flagellantisms
flagellin1343824flagell__in
flagellum1572654flagell__um
flageolet1355644flageol__et
flagpoles1543414flagpol__es
flagstaves1751974flag_staves
flannelettes1561364flannelettes
flatmates1446194fla__tmates
flocculates1852744flocculates
fragmentates1852584fragmentates
gallates92815534___gallates
gelates83219594___ge_lates
glabellae1243744glabella_e_
hemoflagellates2481214hemoflagellates
lacerates112413784_lace_rates
lamellae10117034_lamella_e_
lamellas1098164_lamella__s
lamellately1651534_lamellately
legislates1164414_legislates
nameplates1444114_nameplates
patellate1147484_patellate_
regelates10311114_rege_lates
satellites1045424_satellites
tessellates1162474tessellates
vacillates1555724_vacillates
wavellites1642964_wavellites

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.453394461.4
2DLD Change Limit148819589.14016282.2
3Display Results58580.0301933.3
 (SQL Overall)178691589.62318569.2
 
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.