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 “sedilia” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
sedilia84724(None) 
cedilla1036342cedilla
sedile73517232sedil_e
sedilium1145752sedilium
vedalia1145682vedalia
aecidia1047283aecidia
aedile73716653aedil_e
aediles83413903aediles
cedillas1145743cedillas
cedula977643cedul_a
ceili75814793ce_ili_
ceilis85413743ce_ilis
cilia73016763__cilia
deliria868303deliria
dulia61014983__dulia
edile64819493_edil_e
ediles74016983_ediles
exilian1446963_exilian
exilic1597783_exilic
hemiolia1385993hemiolia
ilia46026823___ilia
indicia1046983indicia
media84721713med__ia
medii84513493medi_i_
medina94114093medi_na
medulla1044713medulla
megilla1036273megilla
milia72719573__milia
peculia1147133peculia
peridia10312363peridia
perilla9311223perilla
radialia946313radialia
realia6314593re_alia
redia65524483red__ia
regalia839223regalia
reptilia1045163reptilia
resilin72913973resilin
scholia1237833scholia
scilla8310943s_cilla
sedarim1047113sedarim
sedition939333sedition
sedulity1245843sedulity
seedily1178583seedil_y
seisin63715123se_isin
seizin153610853se_izin
selva83014273se__lva
semifit1249973semifit
semilog1046003semilog
semina8915563semi_na
semolina1047493semolina
senile63420213senil_e
seniles72618023seniles
senility1139683senility
seniti64317223seniti_
senopia949233senopia
sensilla845623sensilla
sepia75318673se__pia
sequoia1644233sequoia
sericin9312843sericin
seriema938403seriema
seringa83310743seringa
sexily1638853sexil_y
sheila969843sheil_a
silica8311243s__ilica
silva82714023s__ilva
squilla1635533squilla
sudaria847973sudaria
telia55821143te__lia
uredinia943483uredinia
vedalias1245153vedalias
vexilla1744663vexilla

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit134027716.53020524.8
3Display Results71710.0332151.5
 (SQL Overall)178691716.71926594.9
 
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.