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 “silesia” 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
silesia73908(None) 
silesias848521silesias
milesian1046472milesian
siesta639502si_esta
sileni63312142sileni_
splenia948312splenia
akinesia1284073akinesia
alexia132910463_alexia
amnesia938293amnesia
aplasia92510803aplasia
atresia7310223atresia
babesia1146623babesia
biles75542143biles__
calesa8412473cales_a
celesta947643celesta
celosia939463celosia
cilia73016763cil__ia
diesis74013493di_esis
dilemma1243063dilemma
diluvia11225243diluvia
diplegia1244053diplegia
ecclesia1244103ecclesia
esthesia1147503esthesia
fiesta938123fi_esta
filaria1039653filaria
files85441273files__
freesia1046323freesia
ilea45931463_ile__a
ilia46026823_il__ia
isles54220563isles__
kinesic13257023kinesic
kinesis11259593kinesis
miles74645073miles__
milesimo1253563milesimo
milia72719573mil__ia
militia949733militia
mimesis1137323mimesis
pilea75123953pile__a
pilei74021783pile_i_
piles74742613piles__
psilosis1045123psilosis
riles55343643riles__
sales56055593sales__
salesman1047353salesman
salsa56718923sal_s_a
salvia93310753sal_via
sclera838893scle_ra
selenic9410663selenic
sepia75318673s__epia
sices75637273sices__
sicklemia1751823sicklemia
sides65838363sides__
sideslip1143333sideslip
sidespin1143943sidespin
sidles74721153sidles__
sienna647193si_enna
sierra637313si_erra
siestas738813si_estas
sikes96236083sikes__
silds65520523silds__
silence9310213silence
silent64125843sile_nt
silents73514493silents
silenus7369693silenus
silex123417413sile__x
silexes1438653silexes
silica8311243sil_ica
silicic1147603silicic
siliqua1643983siliqua
silkie103313403sil_kie
silks94620683silks__
sills55135993sills__
silos56029433silos__
silts55330823silts__
silurian846293silurian
silurid837013silurid
silva82714023sil__va
sines55954823sines__
sinless73014213sinles_s
sinopia947743sinopia
sipes76036953sipes__
sirenian845783sirenian
sires55945373sires__
sises55233833sises__
sites56045433sites__
sixes124526363sixes__
sizes146727763sizes__
sliest66621963slies_t
smiles84522293smiles__
solaria7312493solaria
solatia7312253solatia
solei55624343sole_i_
soles55547923soles__
spiles84227913spiles__
splenial1047183splenial
splenic1148663splenic
splenii945543splenii
sthenia1058503sthenia
stiles64328773stiles__
stokesia1243963stokesia
synesis1039163synesis
telesis7310793telesis
tilapia945553tilapia
tiles55542103tiles__
vilest9416843viles_t
viremia1246083viremia
wiles85437873wiles__

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.406440125.6
2DLD Change Limit1340271076.44020811.6
3Display Results1071070.0303566.7
 (SQL Overall)1786911076.87625987.6
 
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.