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

128 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
someone93881(None) 
someones1039061someones
compone136517192compone
somoni8310742som_oni
anemone9119453anemone
codeine103815033codeine
colone85425003co_lone
combine133014723combine
comedones1446933comedones
commode1438123commode
common12310803common_
commoner142710633commoner
commons13311043commons
commove1635963commove
commune13329363commune
comose105016843com_ose
compony1613011913compony
compose135716663compose
compote135616463compote
condone102616293condone
cymene1377393cyme_ne
demesne1035573demesne
doggone1035683doggone
domaine10610503domaine
domine92918253dom_ine
doyenne1143883doyenne
eocene8311613eoce_ne
foment113718303fome_nt
fordone1149383fordone
foredone1249733foredone
foregone1238583foregone
forgone1139343forgone
foveole13106873foveole
hambone1439313hambone
homeowner1743483homeowner
hormone12410503hormone
impone103011863_impone
ionone6313443io_none
isogone8237913iso_gone
isotone7239983iso_tone
jomon14610083jom_on_
leone55018823__leone
lomein8410203lomein_
lomeins969473lomeins
loment84021473lome_nt
mesne75116293__mesne
moderne1037123moderne
moment103319683mome_nt
nomen75621623nome_n_
ochone11311293_ochone
odeon6411483_odeon_
odeons739023_odeons
oleine6313793_oleine
omen66828183_ome_n_
omened93711003_ome_ned
omens75618963_ome_ns
orgone71110913_orgone
osmole8128513osm_ole
osmose8108003osm_ose
ozone14310613_o_zone
pompon1238943pompon_
pompons1338553pompons
romaine9512123romaine
romeo73719703romeo__
romeos84013173romeo_s
rotenone847093rotenone
scene77220573s_ce_ne
scone74621833s__cone
seine55732873s__eine
sememe10129983seme_me
semen75724103seme_n_
semens84616963seme_ns
semitone1048973semitone
sene46848053s__e_ne
serene63522353sere_ne
shmooze21255263shmooze
shone83725983s__hone
simony1137903sim_ony
simoon858063simoon_
simoons937943simoons
skeane104611373s_keane
skene96118123s_ke_ne
smoke115015823s_m_oke
smote75820283s_m_ote
socmen1039193socme_n_
soigne74310033so_igne
sokemen1337053sokemen
solemn838643solemn_
solemner1045053solemner
solion6616383solion_
solions7513753solions
solon55026133so_lon_
solons65120023so_lons
soman75024903som_an_
somans84619303som_ans
sombre10729473som_bre
some66040383som___e
somebody1642923somebody
someday1345883someday
somehow1543663somehow
somerset10411073somerset
sometime1246753sometime
someway1545613someway
somewhen1642283somewhen
somewise1345553somewise
somite84519373som_ite
sone46649983s___one
soon46240503so__on_
sooner64220463so__oner
sorbose938983sorbose
sordine82515233sordine
soutane7312063soutane
sowens93613153sowe_ns
sozine15712353so_zine
sphene113412403sphe_ne
spumone1154383spumone
stone55431183s__tone
subtone9310343subtone
subzone1846993subzone
sulfone1037483sulfone
summon1037623summon_
summoned1345723summoned
summoner1245533summoner
summons1158003summons
trombone1245373trombone
vomerine1347683vomerine
wobegone1443003wobegone
women104619253wome_n_

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.406440125.6
2DLD Change Limit1340271286.62320236.6
3Display Results1281280.0502560.0
 (SQL Overall)1786911287.07925242.4
 
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.