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

73 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
arsonist841201(None) 
arsonists947411arsonists
agonist82615402a_gonist
arborist10411612arborist
arsons63917212arson_s_
harmonist141310662harmonist
ironist7314842ir_onist
jargonist1746702jargonist
parsonish1446322parsonish
absonant1047043absonant
admonish1446033admonish
adonis7314063a_donis_
agonise83112693a_gonise
agonists9289833a_gonists
alienist8411993alienist
alpinist1059153alpinist
altoist7313393alto_ist
amongst1045363a_mongst
amorist9317643a_morist
aorist64827873a__orist
aphorist13412503aphorist
arbalist10313333arbalist
arborists1147453arborists
archaist1349863archaist
argonaut946773argonaut
argons75018203argon_s_
armonica1276863armonica
aroint6328153ar_o_int
aroints7313133ar_oints
arsenic939323arseni_c
arsenics1056763arsenics
arsenide9116333arsenide
arsenite8119663arsenite
arshins10312573arshins_
arsines73518813arsines_
arsis55722423ars__is_
arson55118833arson___
arsonous846393arsonous
artist64125543ar__tist
assist6314603a_s_sist
assonant846803assonant
astonish1148453astonish
atomist92915763a_tomist
bassoonist1253333bassoonist
canonist10513533canonist
cartoonist1257163cartoonist
colonist102617933colonist
crayonist1446253crayonist
cronish12310863cr_onish
demonist11413463demonist
dronish1138913dr_onish
fusionist1246073fusionist
harmonise14148763harmonise
harmonists15137123harmonists
hedonist1249553hedonist
ironists839293ir_onists
jargonish2043983jargonish
jargonists1844433jargonists
larcenist1147323larcenist
mammonist12227143mammonist
misoneist1147583misoneist
monist84324983__monist
organist9411543organist
parodist11412763par_odist
parsonic1239703parsoni_c
parsons93516873parson_s_
prosaist10611583prosaist
prosodist1248913prosodist
protist9320223pr_otist
sarodist9510923sar_odist
simonist10410723simonist
unionist8410353unionist
urbanist10109073urbanist

Search took 7 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.1561145455.1
2DLD Change Limit146162736.48622535.0
3Display Results73730.0302433.3
 (SQL Overall)178691736.67226782.2
 
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.