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

98 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
starnose813669(None) 
starnoses9157151starnoses
scariose1037592scariose
acarbose1244683acarbose
agarose838673agar_ose
arenose7311383__arenose
ariose64818733__ariose
arkose104911343__arkose
arose55832083__ar_ose
diagnose1045123diagnose
eternise8119663eternise
farinose1136463_farinose
furanose1144753furanose
hardnose1245723_hardnose
lanose6313593_la_nose
mannose939243_mannose
narcose95910393_narcose
pyranose1344923pyranose
rhamnose13103463rhamnose
sargos74318273s_argos_
sarode75317513s_ar_ode
saros55238063s_ar_os_
saroses73619333s_ar_oses
scapose1147753sca_pose
sharns95516983sharn_s_
sorbose938983s_orbose
sparse84516343spar__se
spathose1345633spathose
spinose937943s_pinose
squarrose1842403squarrose
stagnate947243stagnate
stains64923653stain_s_
staircase1143213staircase
staminode1242653staminode
stance84316913sta_n_ce
stances93715963sta_nces
standee83514513sta_ndee
stands75118053sta_nds_
stane55933003sta_n__e
stanes64933403sta_nes_
stangs75018173sta_ngs_
stanhope1344273stanhope
stanine73417073sta_nine
stanks104917703sta_nks_
stannite847583stannite
stannous846443stannous
stanol6310723sta_no_l
stanols739733sta_nols
starches131912913starches
stardom1037763stardo_m
stardoms1136793stardoms
stardust946093stardust
stare54440263star___e
starers74522313starers_
stares66038753star_es_
starets73515923starets_
starfish1438083starfish
stargaze1844553stargaze
starkest1239723starkest
starkness1335963starkness
starless81610843starless
starlike1238813starlike
stars55836573star__s_
startle72511123star_tle
startles82111963startles
starts65423123star_ts_
startsy10536703star_tsy
starve94613743star__ve
starves104614553starves_
starwort1198683starwort
stenos63915773st_enos_
stenosed946343st_enosed
stenoses8310443st_enoses
stereos74314973stereos_
sternest8314433sternest
sternite8310543sternite
sternmost1144323sternmost
sternpost1144233sternpost
sterns64616763stern_s_
sternson844843sternson
strands83711953strands_
strange85416343stran_ge
stranges94516763stranges
strangle98411503strangle
strigose945583strigose
strobe84513813st_r_obe
strode75215973st_r_ode
stroke105116173st_r_oke
strove95014793st_r_ove
strumose1044303strumose
sucrose939313sucr_ose
tacnode1045093_tacnode
talcose938143_talcose
tarnish101611883_tarnish
tarns56433953_tarn_s_
taros55640823_tar_os_
torose64317693_tor_ose
triose64715383_t_riose

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.436409841.7
2DLD Change Limit146162987.70318974.7
3Display Results98980.0462130.4
 (SQL Overall)178691988.18521831.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.