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

107 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
hessian103585(None) 
hessians1145051hessians
cession939812cession
chessman1544822chessman
hessite1038992hessite
lesbian944462lesbian
mesian84315502me_sian
messan83912062mess_an
messiah1246792messiah
messman1137282messman
session739762session
thespian1343202thespian
aeolian738623aeolian
aeonian738353aeonian
assign736783_assign
bestial9311643bestial
cassia83714763cassia_
cassias93514343cassias
cassina94113163cassina
cesarian1048183cesarian
cessing103814813cessing
cessions1039853cessions
chessmen1544463chessmen
design8408933de_sign
deskman1444323deskman
desman9311693de_sman
destain8412083destain
elysian1065083elysian
ensign737523_ensign
eolian6312593_eolian
eonian6311833_eonian
eosin55220923_eosi_n
espial839543_espial
essay867623_ess_ay
essoin638193_essoin
etesian757853etesian
fessing113812863fessing
fission1038733fission
fustian1036903fustian
gentian8310103gentian
gossan747233goss_an
hassium1236133hassium
headman13229633headman
headsman1446353headsman
heliac111010893he_liac
hellion10311133hellion
helmsman1553503helmsman
hemin103620933he_mi_n
herdman13238423herdman
herdsman1465643herdsman
herein93717793herei_n
hernia9312293hernia_
herniae1039043herniae
hernial10310433hernial
hernias10310773hernias
heroin94420593heroi_n
hesitant1149083hesitant
hessites1138613hessites
hetman112510603he_tman
hexosan1744333hexosan
hissier103410503hissier
hissies103915823hissies
hissing114213143hissing
hussar9317283huss_ar
hussies103213293hussies
jessant1438443jess_ant
jessing153710623jessing
lensman937563lensman
lesbians1043603lesbians
lesion64715063le_sion
lessen64212433less_en
lesson64412043less_on
loessial843783loessial
median94117543me_dian
mesial84818083me_sial
messans92710463mess_ans
messiahs1343963messiahs
messianic1342953messianic
messier93412923messier
messily12298813messily
messing103916393messing
messmen1137393messmen
mission9312743mission
newsman1245503newsman
ossia53710403_ossia_
passion9310883passion
pension9412203pension
pepsin10310853pepsi_n
permian112612283permian
pressman1247153pressman
reassign955423reassign
resign74212583re_sign
resin54131053re_si_n
retsina74710603retsina
seisin63715123seisi_n
sessile739523sessile
sessions839723sessions
sestina72711973sestina
tension7311803tension
tertian7511193tertian
therian10311293the_rian
thespians1442843thespians
vermian12329713vermian
version10310923version
vesuvian1442593vesuvian
wessand1144833wess_and
yessing113210063yessing

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271075.95322514.2
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.40527898.7
 
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.