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

109 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
sclerae93793(None) 
sclera838891sclera_
scleral937861scleral
scleras948221scleras
sclerite10410712sclerite
sclerose1046222sclerose
acerate92818913ac_erate
acierate10311813acierate
camerae11312063camerae
cellae84915933_cellae
cerate84829463_c_erate
cere66741473_c_er_e
chelae113614603_chelae
clean75420413_cle_an
clear76219053_cle_ar
cleared103612463_cleared
clearer93710823_clearer
clears84116563_clears
cleat76335063_cle_at
cleave114212513_cleave
cleome1039083_cleome
clepe94617383_cle_pe
clergy1234993_clergy
cleric10612133_cleric
clerid9312413_clerid
clerk115812453_cler_k
clerked14326653_clerked
clerks12458843_clerks
coerce10310403_coerce
florae94713883_florae
galeae74717453gale_ae
galere73716673galer_e
glebae9407613_glebae
ochreae12295083ochreae
ocreae83310273ocre_ae
paleae84820293pale_ae
pleurae945863_pleurae
salpae84614273sal_pae
scalare93311833scalar_e
scalene9310773scale_ne
scalepan1244513scalepan
scaler84321603scaler__
scalers93817263scaler_s
scarab10310063sc_arab
scarce104013633sc_arce
scare75334463sc_ar_e
scena74815783sc_ena_
scenas84114703sc_enas
scene77220573sc_e_ne
schema1388373schema_
schemas1468163schemas
scheme1379633sche_me
scherzi2143583scherzi
scherzo2153943scherzo
schliere1343843schlier_e
science1138783science
sclereid1145363sclereid
sclerites1139443sclerites
scleroid1147213scleroid
scleroma1274353scleroma
scleromas1364313scleromas
sclerosal1143163sclerosal
sclerosed1244013sclerosed
scleroses1146373scleroses
sclerous1047923sclerous
score75526743sc_or_e
scoriae9310903scoriae
scourge1035653scourge
scrag85916173sc__rag
scram910621623sc__ram
scrap97120403sc__rap
scrape105917573sc__rape
screak125311063scre_ak
scream104814253scre_am
scree720031713sc__ree
selenate81712533selenate
sera46141393s__era_
serac75925203s__erac
serai56830163s__erai
seral56336383s__eral
serape84818413s__erape
sere46153473s__er_e
serge64727473s__erge
serve85425963s__erve
setae56026223s__etae
several1039533several
severe94016083sever_e
sewerage1245513sewerage
silence9310213silence
silvae92811093sil_vae
sleave94714153s_leave
sleaze152611863s_leaze
sledge85011303s_ledge
sleeve93411593s_leeve
soleret7321233soleret
spheral1238423spheral
sphere113313663spher_e
splore81611303splor_e
splurge1044763splurge
steerage946833steerage
stelae63716483s_telae
stere55328543s_ter_e
swerve1256293s_werve
sylvae12236863syl_vae
synurae1044253synurae
teleran7510173teleran
tolerate8312323tolerate
ulcerate1039733ulcerate
valerate11311473valerate

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.420425454.8
2DLD Change Limit1340271096.65620136.3
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.12225090.0
 
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.