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

87 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
sternums104578(None) 
sternum947731sternum_
serums83916302s_er_ums
stannums1043802stannums
sterns64616762stern__s
stewbums1542102stewbums
strums84716452st_r_ums
asterisms11511063asterisms
atriums939043at_riums
ceriums1139473_ceriums
estrums9208603est_r_ums
eternals8238953eternals
ferrums1265983_ferrums
frenums1236203fre_nums
iterum837903iter_um_
plenums1136533ple_nums
sacrums11388043sacr_ums
scrums104614253s_cr_ums
sebums10369813s_e_bums
sedums93910483s_e_dums
septums1135743s_eptums
serous65023563s_erou_s
serum75223473s_er_um_
skellums1443003skellums
smeddums1441983smeddums
solanums1044433solanums
sperms102512603sper__ms
stadiums1145703stadiums
stannum944643stannum_
stardoms1136793stardoms
startups1033893startups
steams84916903ste__ams
steins64818343stein__s
stems75219953ste___ms
stenos63915773ste_n_os
stents65019453ste_n_ts
stereos74314973ster_eos
steres63929533ster__es
sterigma1144113sterigma
sterigmas1243563sterigmas
sterlets8169273sterlets
stern55319123stern___
sterna63712763stern__a
sternal73411913stern_al
sterner7411913stern_er
sternest8314433sternest
sternite8310543sternite
sternites9310073sternites
sternly1037853stern_ly
sternmost1144323sternmost
sternness946093sternness
sternpost1144233sternpost
sternson844843sternson
sternsons944663sternsons
sternway1443153sternway
sternways1542593sternways
steroids9911443steroids
sterols7313443ster_ols
stertors8310933stertors
stewbum1442943stewbum_
stibiums1244203stibiums
stickums1643943stickums
stirrups1042603stirrups
storms85814633stor__ms
stratums10266803stratums
streams94713373st_reams
strenuous944863strenuous
strouds837803st_rouds
strum75619453st_r_um_
struma84313273st_r_uma
strumas9419833st_r_umas
strunts7429543st_runts
struts65616803st_r_uts
stums75320083st___ums
tectums11306423_tectums
tediums10266973_tediums
tenues63816443_te_nues
tenuis64213083_te_nuis
terbiums1245423_terbiums
tergum937933_tergum_
terms75523473_ter__ms
ternes65422903_tern_es
terns55226873_tern__s
thrums11429123_thr_ums
turnups933893_turnups
uterus639203uter_u_s
yttriums1343233yttriums

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 Filter1786911461620.423422437.4
2DLD Change Limit146162877.81318707.5
3Display Results87870.0302900.0
 (SQL Overall)178691878.26621617.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.