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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
cedilla103634(None) 
cedillas1145741cedillas
cedula977642ced_ula
cella75420312ce__lla
medulla1044712medulla
megilla1036272megilla
perilla9311232perilla
sedilia847242sedilia
vexilla1744662vexilla
acedia9310393acedi__a
aedile73716653aedi_le
aediles83413903aediles
ancilla948603ancilla
armilla936993armilla
axilla13289573_axilla
barilla9310323barilla
bedell93610043bedell_
bedells10379363bedells
cabrilla1245833cabrilla
cadelle1039923cadelle
calla74827073c__alla
canella9310793canella
caudillo1144483caudillo
cavalla1257883cavalla
cecally1459393cecally
cedi74919273cedi___
ceding104014803cedi_ng
cedis84317083cedi__s
cedulas1058503cedulas
ceiba938703ce_i_ba
ceil65725063ce_i_l_
ceiled94114953ce_iled
ceiler84013963ce_iler
ceili75814793ce_i_li
ceilis85413743ce_ilis
ceils75019403ce_i_ls
cell65031723ce__ll_
cellae84915933ce__llae
cellar84514983ce__llar
celli76717693ce__lli
cello74919583ce__llo
cells75428063ce__lls
ceria75125353ceri__a
challa114014193c_halla
chenille1354593chenille
chill105619873c_hill_
chilli114312773c_hilli
chills114717703c_hills
chilly144113223c_hilly
chimla1337593c_himla
cholla113911023c_holla
cilia73016763c__ilia
civilly1535483civilly
corolla938623corolla
credible1346023credible
credibly1644713credibly
cuadrilla1243423cuadrilla
dill55239973__dill_
dills65530973__dills
dilly94923783__dilly
edible969353_edible
edile64819493_edi_le
ediles74016983_ediles
eidola737683_eidola
evilly1236593_evilly
fella84918653fe__lla
gorilla836973gorilla
guerilla943793guerilla
hemiola12107003hemiola
hydrilla1543473hydrilla
latilla737953latilla
manilla93012473manilla
maxilla16248193maxilla
media84721713medi__a
medial93819863medial_
medially14129323medially
medials103914733medials
medical12312513medical
medina94114093medi_na
medullae1143203medullae
medullar1143463medullar
medullas1144513medullas
megillah1443233megillah
megillas1145893megillas
oedipal1045173oedipal
papilla11127913papilla
pedicle1238973pedicle
perillas10310823perillas
predella1145393predella
rebill84713253rebill_
rebills93510623rebills
redia65524483redi__a
redial74923113redial_
redials84416883redials
redrill857893redrill_
redrills956083redrills
refill94514053refill_
refills103711423refills
scilla8310943_scilla
sedile73517233sedi_le
sensilla845623sensilla
squilla1635533squilla
vanilla10238743vanilla
vedalia1145683vedalia
vexillar1843463vexillar
villa85321233__villa
zorilla1646023zorilla

Search took 8 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.423422437.4
2DLD Change Limit1340271076.61020276.4
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.07925242.4
 
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.