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

222 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
sterlets816927(None) 
starlets81610081starlets
sterlet71318471sterlet_
overlets112312362overlets
scarlets10178572scarlets
sherbets1335212sherbets
starets73515922star_ets
starless81610842starless
starlet71620122starlet_
stealers83412212stealers
steles63725662ste_le_s
stemless1036652stemless
stereos74314972ster_eos
steres63929532ster_e_s
sternest8314432sternest
streets73312612st_reets
stylets10369212st_ylets
tercets93512442_tercets
terrets72913582_terrets
berets85822523_ber_ets
cermets1139713_cermets
coverlets1437053coverlets
craterlets1243503craterlets
eyelets1057523eye_lets
ferrets103111393_ferrets
iterates81317823iterates
lusterless1043693lusterless
merles85322763_merle_s
merlots92710123_merlots
omelets938333ome_lets
overbets132510683overbets
overlet102619033overlet_
oversets113114173oversets
overwets14219953overwets
peerless1037513peerless
pellets94014783_pellets
reflets103513153_reflets
reglets83512983_reglets
relets64025673_re_lets
sallets73719653s_allets
samlets93813553s_amlets
scarless10189053scarless
scarlet91516943scarlet_
sealers74323553s_ealers
secrets9311773s_ecrets
seedless9319513seedless
seeress7311573seer_ess
selects91912143s_e_lects
sellers73721323s_ellers
selles64426983s_elle_s
sennets73712583s_ennets
septets998953s_eptets
seres55448893s_er_e_s
serest64831613s_er_est
sergers83815633s_ergers
serges74225973s_erge_s
series64540973s_erie_s
serpents102410373s_erpents
servers103214833s_ervers
serves94423653s_erve_s
sestets7911473s_estets
settlers8289023settlers
settles73916003settle_s
sewerless1244303sewerless
sexless1467243s_exless
sextets1497143s_extets
shearlegs1342493shearlegs
sheerlegs1343293sheerlegs
sheets93918503she__ets
shellers112812583shellers
sherberts1443593sherberts
sherbet12311383sherbet_
shereefs1433863shereefs
sheroots1137863sheroots
singlets93611473singlets
skeets104513253ske__ets
skillets12226823skillets
skirrets12244013skirrets
sleets64318873sle__ets
smellers10329773smellers
smelts85412773sme_l_ts
snarlers8298753snarlers
snellest839493snellest
sniglets9276813sniglets
solerets839693soler_ets
somersets1144253somersets
sorbets93012513s_orbets
sparklets15275843sparklets
spellers102812763spellers
spelts84614643spe_l_ts
stablers103611153stablers
stables93219073stable_s
stablest103312943stablest
stairless9185623stairless
stales65538293st_ale_s
stalest73720173st_alest
staplers103111203staplers
staples93617213staple_s
starers74522313star_ers
stares66038753star_e_s
starkers123712393starkers
starkest1239723starkest
starlit71512913starlit_
starters83714773starters
startlers9236743startlers
startles82111963startle_s
starts65423123star__ts
starvers11459643starvers
starves104614553starve_s
stealer72913983steale_r
steals64020063steal__s
stealth1096453steal_th
stealths11104123stealths
steamers103410873steamers
stearates939453stearates
steeds73814883ste__eds
steeks103613703ste__eks
steeled83513223steele_d
steelies8312553steelies
steeliest939643steeliest
steels64117983ste__els
steepens10277113steepens
steepers103011373steepers
steepest1038123steepest
steeples1038013steeple_s
steeps85215193ste__eps
steerers82511353steerers
steers63820983ste__ers
steeves103410903steeve_s
stele55026843ste_le__
stelene7310253ste_lene
stellas72813043ste_llas
stellate8310503stellate
stellite839533stellite
stellites938123stellites
stemmers12378443stemmers
stents65019453ste__nts
steppers12289283steppers
steppes113110693steppe_s
stere55328543ster_e__
stereo65317913ster_e_o
sterilants1044073sterilants
sterile7316603sterile__
sterilely1244633sterilely
sterility1247763sterility
sterling93615553sterling
sterlings10308753sterlings
sterner7411913sterne_r
sternite8310543sternite
sternites9310073sternites
sternness946093sternness
sterns64616763ster__ns
sternums1045783sternums
steroids9911443steroids
sterols7313443ster_ols
stertors8310933stertors
stets55423913st___ets
stiflers11238833stiflers
stifles103013393stifle_s
stiles64328773st_ile_s
stillest8311073stillest
stilts67915313st_il_ts
stirpes95011293stirpe_s
stirrers8266943stirrers
stoles63927673st_ole_s
stollens835293stollens
storers75018683stor_ers
stores65533663stor_e_s
storeys10559653stor_eys
stories7324273storie_s
straits74916323st_raits
streamlets1243073streamlets
streeks11378713st_reeks
streels73811343st_reels
street64125773st_reet_
streps86218063st_r_eps
stress66616673st_r_ess
strewers11409063strewers
strews96817103st_r_ews
strunts7429543st_runts
struts65616803st_r_uts
sturts63915143stur__ts
stylers10359353st_ylers
styles94418653st_yle_s
stylet94018573st_ylet_
sublets92616703s_ublets
superjets1848013superjets
sweets94214433swe__ets
swellest1137663swellest
swervers1455213swervers
swerves1377533swerve_s
tablets94714383_tablets
targets84314223_targets
tartlets8289663_tartlets
tearless848713_tearless
teles54536003_te_le_s
tellers73717603_tellers
telnets738373_telnets
templets12226143_templets
tenets65518953_te_nets
tercelets1144813_tercelets
tercels94110363_tercels
terces83921413_terce_s
tercet83624913_tercet_
terete6319333_ter_ete
termers95414503_termers
termless1036233_termless
ternes65422903_terne_s
terret63425623_terret_
territs72714503_territs
tersest71713993_tersest
toilets74112913_toilets
tonlets73212503_tonlets
trets55928023_t_r_ets
trevets10499973_trevets
turrets73010673_turrets
underlets10158893underlets
varlets10411573_varlets
versets103913103_versets
vervets13419753_vervets
waterjets1944463waterjets
waterless1238013waterless

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.406440125.6
2DLD Change Limit1461622226.53022383.2
3Display Results2222220.0802775.0
 (SQL Overall)1786912227.01625469.1
 
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.