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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
thous8601725(None) 
thou76722211thou_
thus76721471th_us
chops125019872chops
chorus115014762chorus
chouse116017562chouse
choush14549062choush
chows135618202chows
dhows125911222dhows
ethos85514192etho_s
ghoul959052ghoul
ghouls1036042ghouls
hobs97038982_hobs
hocus104715202_hocus
hods87239862_hods
hoes75755732_hoes
hogs87139662_hogs
hols76946292_hols
hons77350782_hons
hops97942632_hops
hos68364192_ho_s
hots78349322_hots
hour75827312_hour
hours85422382_hours
house89131422_house
hows106345602_hows
hoys107733932_hoys
khoum1476632khoum
khoums1594012khoums
meous76120062meous
mhos95517772mho_s
nous46136982_nous
phons105221142phons
phots105418492phots
pious74621272pious
rhos76319062rho_s
rhus75114052rh_us
shoes85429652shoes
shogs95319702shogs
shoos84226352shoos
shops104222892shops
shots84730832shots
shout85433162shout
shouts94017712shouts
shows115324572shows
shoyus1265992shoyus
sous46947212_sous
tabus74820922tabus
talus55423262talus
taos45541002tao_s
taus46342732t_aus
taxus125512482taxus
thaws116515462thaws
thens85921832thens
thews117416192thews
thins85826322thins
thiols95112762thiols
this76027382th_is
tho67433962tho__
thole85620842thole
tholes94919782tholes
tholos94213002tholos
thong95014172thong
thongs104611182thongs
thorn85318702thorn
thorns95314092thorns
thoro86217872thoro
thorp104414262thorp
thorps113610892thorps
those85218142those
thoued10429002thoued
though139410762though
throbs118311372throbs
throes97518672throes
throws129715232throws
thru76818942thru_
thrum104713632thrum
thrums11429122thrums
thrush12257482thrush
thrust91911892thrust
thud85613912th_ud
thuds95110132thuds
thug86415482th_ug
thugs95611992thugs
thymus14324732thymus
tods56141842t_ods
toes46956442t_oes
tofus86415422tofus
togs57242432t_ogs
tolus55024482tolus
toms68343492t_oms
tons46553052t_ons
tonus56324302tonus
tools55325242tools
toons55027532toons
toots55331872toots
tops66248122t_ops
torous64319022torous
tors46157382t_ors
torus54329762torus
toss45637972t_oss
tots46654122t_ots
tour45530372t_our
tours55325862t_ours
touse55430672t_ouse
tout46753822t_out
touts54830392t_outs
tows78545552t_ows
toys78036342t_oys
trogs67022602trogs
trois57226092trois
trots56629942trots
trout57332572trout
trouts66116622trouts
trows88826182trows
troys86418612troys
tutus55214812tutus
twos76718022two_s
typhous1566322typhous
whops135013932whops
yous76230652_yous

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.0931921408.6
2DLD Change Limit538001211.54634799.5
3Display Results1211210.0462630.4
 (SQL Overall)1786911211.685106048.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.