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 “ethos” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

64 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
ethos8551419(None) 
echos105216461echos
ethnos947051ethnos
eths76619521eth_s
bathos116215632bathos
benthos1238372benthos
beths105519222beth_s
bohos105618252bohos
cohos105921852cohos
eches106322162eches
echo96615952echo_
echoes114715522echoes
edhs86212102edh_s
egos55821652e_gos
eidos65817762eidos
ephas10311542ephas
ephod1139122ephod
ephods1238362ephods
ephor10310012ephor
ephors11311402ephors
epos66723732e_pos
eros45238452e_ros
etas46432272et_as
etches114217762etches
eth66630982eth__
ether84518772ether
ethers94518412ethers
ethic101511222ethic
ethics11169282ethics
ethion938812ethion
ethions1038482ethions
ethoses10311762ethoses
ethoxy1933922ethoxy
ethyl1136512ethyl
ethyls1235902ethyls
etnas54713932etnas
etuis54013132etuis
euros54920242euros
expos1449202expos
heths116317782heth_s
hos68364192__hos
lethes94818082lethes
lithos94212552lithos
method1239032method
methods1338892methods
meths105320232meth_s
metros84217802metros
mhos95517772_mhos
mythos14398472mythos
ottos54714322ottos
pathos115516692pathos
pothos114214692pothos
retros63820192retros
rhos76319062_rhos
taos45541002_taos
telos55424522telos
teths85418512teth_s
this76027382_this
tho67433962_tho_
those85218142_those
thou76722212_thou
thous86017262_thous
thus76721472_thus
twos76718022_twos

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit53800641.48636204.6
3Display Results64640.0164000.0
 (SQL Overall)178691641.79899383.2
 
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.