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

130 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
sternites931007(None) 
sternite8310541sternite_
eternises9119452eternises
eternities1048062eternities
eternizes18118012eternizes
kernites1269112_kernites
sienites8311912sie_nites
stannites947022stannites
steatites939852steatites
stellites938132stellites
stibnites1144042stibnites
syenites1138942sye_nites
tergites9310542_tergites
termites10313692_termites
alternates1047893alternates
arenites8917133are_nites
attrites8311583attr_ites
austenites1044983auste_nites
bornites10310993_bornites
cerites94823433_cer_ites
eternise8119663eternise_
eternised10116273eternised
eternity1146683eternit_y
eternize17118363eternize_
eternized19116603eternized
ferrites112312833_ferrites
herniates1247343_herniates
iterates81317823iter_ates
kernite1159473_kernite_
laterites9715083later_ites
lenites7818443_le_nites
maternities1346013maternities
overbites14310983overbites
paternities1345793paternities
perlites10316363_perlites
preunites1138933preunites
retinites9313503retinites
reunites8312473_reunites
saponites1139943saponites
satellites1045433satellites
sclerites1139443scler_ites
selenites91312093selenites
senates73322613s_e_nates
seniles72618023s_e_niles
sennits73811283s_ennit_s
serenities10411073s_erenities
seriates82620683s_eriates
series64540973s_er_i_es
serines74229543s_er_ines
serrates82617023s_errates
serries73925353s_erri_es
services1338573s_ervices
sheenies111411543sheeni_es
sherries111812903sherri_es
sherrises12156873sherrises
siderites10410433sider_ites
sienite7312713sie_nite_
skerries12168673skerri_es
smectites1344623smectites
sorites73825243s_or_ites
spermines13310543spermines
sprites94220333s_pr_ites
stagnates1046733stagnates
stanines85115673st_anines
stannite847583stannite_
starnoses9157153starnoses
steadies9311123steadi_es
stearates939453stearates
stearines9311283stearines
steatite8310583steatite_
steelies8312553steeli_es
stellite839543stellite_
stenches132110293ste_nches
stenoses8310443ste_noses
stents65019453ste_n_t_s
steres63929533ster___es
sterile7316603ster_ile_
sterilises1048253sterilises
sterilities11129013sterilities
sterilizes1947643sterilizes
sterlets8169273sterlet_s
sterlings10308753sterlings
sterner7411913stern__er
sternest8314433stern__est
sternness946093sternness
sterns64616763stern___s
sternsons944663sternsons
sternums1045783stern_ums
sternways1542593sternways
steroids9911453steroi_ds
stibnite1044073stibnite_
stilbites1144833stilbites
stipites1039653st_ipites
stories7324273stor_i_es
straiten838613st_raiten
straitens946243st_raitens
straiter8311783st_raiter
straitest949173st_raitest
straits74916323st_rait_s
strengths1343563strengths
striates83417093st_riates
strides84520393st_r_ides
strifes104716583st_r_ifes
strikes114719093st_r_ikes
stripes95320573st_r_ipes
strives104119373st_r_ives
sturdies92110273sturdi_es
stylites11168693st_ylites
supernates12413263supernates
sweenies11148763sweeni_es
syenite1039773sye_nite_
tectites1039993_tectites
tektites1236613_tektites
tennies73017973_tenni_es
tennises82810133_tennises
tergite8311003_tergite_
termite9313893_termite_
ternate7415483_ternate_
ternes65422903_tern__es
ternions838813_ternions
terries73425633_terri_es
terrines82117553_terrines
territs72714503_territ_s
thermites1438043thermites
turgites937783_turgites
verites103822263_ver_ites
vernixes1836053_vernixes
westernises1444203westernises
westernizes2344123westernizes
yperites13310153yper_ites

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411307.73319221.6
3Display Results1301300.0632063.5
 (SQL Overall)1786911308.21921741.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.