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

97 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
tortonis84874(None) 
tortoni738031tortoni_
tortoise847092torto_ise
boltonia1045513boltonia
boltonias1145123boltonias
boronic11311163bor_onic
borons85520543bor_on_s
borzois1835833borzo_is
bostons9312903boston_s
boutons9310783bouton_s
burtons9310853burton_s
cartons94122473carton_s
cordons104415763cordon_s
coronas93916913cor_onas
cortinas102212453cortinas
cortins92421333cortin_s
cottons9312193cotton_s
crotons93714373croton_s
fortis95418613fort__is
fortunes1158283fortunes
gorgons938853gorgon_s
hormones13311163hormones
hormonic1568153hormonic
kurtosis1294403kurtosis
lordosis944453lordosis
martinis103311613martinis
morions94014643morion_s
moronic11311863mor_onic
moronism1249323mor_onism
morons84919543mor_on_s
moutons9410313mouton_s
nontonic10410153nontonic
notornis845693no_tornis
orgones81010793_orgones
orlons6411013_orlon_s
ornis54616773_or__nis
orthosis1148193_orthosis
ostosis71310123_ostosis
partons94620513parton_s
pontons93315553ponton_s
porcinis1246953porcinis
portends11358963portends
portents103512823portents
portions10514413portion_s
protonic12314593protonic
protons93118003proton_s
sorosis72611973sor_osis
tarpons92612213tarpon_s
tartanas8258893tartanas
tartans72615823tartan_s
tectonic1248453tectonic
tectonics1345953tectonics
tectonism1346203tectonism
testons7313563teston_s
thorons104511913thor_on_s
thrones105715843thr_ones
throngs11508163thr_ongs
tontines82114733tontines
toonie63617993to__onie
toonies73719883to__onies
toons55027533to__on_s
topstones1147013topstones
torchons1337503torchon_s
torments10310453torments
toroid7416013tor_o_id
toroids8310643tor_oids
toros54336193tor_o__s
torous64319033tor_o_us
torpors939383torpo_rs
torrents838143torrents
torsions839183torsion_s
torsos64815733torso__s
tortas64918253tort__as
torten65314353torten__
tortes64826053tort__es
tortious839023tortious
tortoises947183tortoises
tortrix1444193tort_rix
torts56138123tort___s
tortuous845903tortuous
tortures838913tortures
towmonds1493493towmonds
towmonts1364283towmonts
toyons95512133to_yon_s
tritones83413443tritones
tritons73814883triton_s
trogons83410723trogon_s
trois57226093t_r_o_is
tronas63816903t_r_onas
trones65629283t_r_ones
troponin1047943troponin
troponins1147203troponins
turions7311573turion_s
turkois1135133turko_is
turnons737863turnon_s
tyronic1239313tyr_onic
wontons103310533wonton_s

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 Limit146162977.81318707.5
3Display Results97970.0332939.4
 (SQL Overall)178691978.28221575.8
 
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.