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

159 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
solonets83823(None) 
solonetz1744851solonetz
boloneys1334502boloneys
colonels104210452colonels
colones96124432colone_s
coronets103814362coronets
soleness8814262soleness
solerets839692solerets
soloists869152soloists
solonetses1043672solonetses
solonetzes1942692solonetzes
solons65120022solon__s
solvents1136762solvents
sonnets74211992so_nnets
sooners73916642so_oners
soonest7415592so_onest
ballonets1146723ballonets
baloneys1334663baloneys
baronets101410903baronets
bayonets13135583bayonets
boldness1136973boldness
boloney1247763bolone_y
bonnets94812803bo_nnets
cloners94514823_cloners
clones84526563_clone_s
closets94611603_closets
coconuts1246333coconuts
cojones163512103cojone_s
coldness1137953coldness
collets93517903col_lets
colognes11310603cologne_s
colone85425003colone__
colonel94213283colone_l
colonics123711613colonics
colonies103620013colonies
colonist102617933colonist
colonists112512503colonists
colonitis1148763colonitis
colons86028683colon__s
colonus94413443colon_us
coloreds1138093coloreds
colorers10312183colorers
coolness1037743coolness
cornets94820573co_rnets
coronels104012143coronels
coroners104016223coroners
coronet94227173coronet_
doblones1136763doblone_s
falconets1444813falconets
florets1039853_florets
gillnets934733gillnets
gooneys11407073go_oneys
holiness112512503holiness
hornets104113553ho_rnets
ionones7313883ionone_s
isogones9217993isogone_s
isolines8312303isoline_s
isotones82210433isotone_s
jaconets1745613jaconets
loners64225813__loners
looneys10487013lo_oneys
lunets66914763__lunets
mooners94015343mo_oners
moonlets10247473mo_onlets
moonsets10216413mo_onsets
nonets64118703__nonets
oldness836403_oldness
oolongs845953oolon_gs
ozones1539393_ozone_s
planets93914083_planets
poloists10910523poloists
salients839563salients
salines74029413saline_s
sallets73719653sal_lets
salons63823693salon__s
saltness82610243saltness
sarsnets836783sarsnets
satinets8311733satinets
scones84521303s_cone_s
selfness1135153selfness
sennets73712583s_ennets
signets83311503s_ignets
silanes72517163silane_s
silents73514493silen_ts
sklents11348163sklen_ts
slants64819083s_lan_ts
sleets64318873s_l_eets
sloes54728873s_lo_e_s
slopers94213093s_lopers
slopes84820453s_lope_s
slots54830533s_lo__ts
slovens10316573s_lovens
slowest10168713s_lowest
slowness1135013slowness
slyness1035263s_lyness
sockets134012983so_ckets
softness1136433softness
solacers10268893solacers
solaces93116133solace_s
solanders1036963solanders
solands84412343solan_ds
solanins8310513solanins
solanos74412853solan_os
solans64122493solan__s
solanums1044433solanums
solates73523853solate_s
solders83517773sol_ders
soldiers9277773soldiers
soleless8910033soleless
solemnest1148053solemnest
soleret7321233soleret_
soles55547923sol__e_s
soleus64615613sol__eus
solicits10311023solicits
solidest9310383solidest
solidness1036903solidness
solions7513753solion__s
sollerets945263sollerets
soloed74515743solo_e_d
soloist7915893soloist_
solon55026133solon___
solonetzic2151973solonetzic
solos54830793solo___s
solutes73515263solute_s
solvates11249673solvates
solvent10310833solvent_
solvers104414253sol_vers
solves95018223sol_ve_s
someones1039063someone_s
sonants7511233sonan_ts
sones55444143s__one_s
sonnet65923503so_nnet_
sooner64220463so_one_r
soots55536213so_o__ts
sorbents10279133sorbents
sorbets93012513so_rbets
soreness8914793soreness
sorners73416873so_rners
soroses73117483sorose_s
sourness839543sourness
soviets1087293so_viets
sozines16611263sozine_s
spinets94714813s_pinets
splents93912133splen_ts
splines94718893spline_s
splints94511743splin_ts
splores91910953splore_s
spooneys13314583spooneys
stolonate944833stolonate
stolons73410243stolon__s
stoners74817953s_toners
stones65130033s_tone_s
subnets92512083s_ubnets
sulfones1147683sulfone_s
swooners11336863swooners
telnets738373tel_nets
tolanes74216313tolane_s
violones1137383violone_s
volosts1036563volo_sts

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.436409841.7
2DLD Change Limit1461621597.19020328.5
3Display Results1591590.0602650.0
 (SQL Overall)1786911597.68623248.9
 
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.