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

124 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
someones103906(None) 
someone938811someone_
comedones1446932comedones
ambones11312683_ambones
anemones10249473anemones
codeines113114523codeines
cojones163512103co_jones
colones96124433co_lones
combines142814623combines
comedies13311843comedies
commodes1539093commodes
commoner142710633commoner
commoners15339783commoners
commonest1549253commonest
commons13311043common_s
commoves1736963commoves
communes143411243communes
compone136517193compone_
composes145017113composes
compotes144716513compotes
condones112817393condones
cymenes1477413cyme_nes
daemones11209163daemones
demesnes1137083demesnes
doblones1136763doblones
doggones1135713doggones
domaines11611063domaines
domines102918973dom_ines
dominoes11349043dominoes
doyennes1244363doyennes
foments122912053fome_nts
foveoles1496643foveoles
hambones1539673hambones
homeowner1743483homeowner
homeowners1843373homeowners
homeyness1745013homeyness
homines123518643hom_ines
hommoses1538153hommoses
hormones13311163hormones
impones112712253_impones
ionones7313883io_nones
isogones9217993iso_gones
isotones82210433iso_tones
leones64417723__leones
lomeins969483lomein_s
loments93413473lome_nts
mesnes85216213__mesnes
modernes1138423modernes
moments113113123mome_nts
odeons739023_odeon_s
oleines7313393_oleines
omened93711003_ome_ned
omens75618963_ome_n_s
orgones81010793_orgones
osmoles9138363osm_oles
osmoses9138123osm_oses
osteoses839033osteoses
ozones1539393_o_zones
peones83821043__peones
pompons1338553pompon_s
romaines10512523romaines
romeos84013173romeo__s
rotenones956343rotenones
sameness102712683same_ness
sawbones13126643sawbones
scenes84520353s_ce_nes
scones84521303s__cones
seines65029903s__eines
sememes11109203seme_mes
semens84616973seme_n_s
semioses10611013semioses
semitones1148943semitones
serenes73222903sere_nes
shmoes114612103shm_o_es
shmoozes22254883shmoozes
simonies10311113sim_onies
simoons937943simoon_s
skeanes113610713s_keanes
skenes104616633s_ke_nes
smokes124814343s_m_okes
soberness1186463soberness
solemner1045053solemner
solemnest1148053solemnest
soleness8814263sole_ness
soleuses838073soleuses
solions7513753solion_s
solonets838233so_lonets
solons65120023so_lon_s
somans84619303som_an_s
somberness1443513somberness
somebodies1553123somebodies
somerset10411073somerset
somersets1144253somersets
sometimes1345993sometimes
someways1644823someways
somewhen1642283somewhen
somewise1345553somewise
somites94219123som_ites
somoni8310743som_on_i
sones55444143s___ones
sooner64220463so__oner
sooners73916643so__oners
soonest7415593so__onest
sorboses1038523sorboses
sordines92414073sordines
soreness8914793sore_ness
soroses73117483so_roses
soutanes8312933soutanes
sowens93613153sowe_n_s
sozines16611263so_zines
spadones1137253spadones
sphenes123013163sphe_nes
spumones1254953spumones
stones65130033s__tones
subtones10311383subtones
subzones1947223subzones
sulfones1147683sulfones
summoned1345723summoned
summoner1245533summoner
summoners1344733summoners
summons1158003summon_s
summonses1344543summonses
trombones1345363trombones
umbones1138013_umbones

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621247.42319690.4
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.88922650.7
 
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.