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 “tangp'” 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.

168 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
tang56138692tang__
tanga64923712tang_a
tanged84622512tanged
tangle74019972tangle
tangly104413932tangly
tango66921192tang_o
tangos74216322tangos
tangs65028362tang_s
tangy94519952tang_y
anga56831363_ang_a
angas65827993_angas
angel65019573_angel
anger66225883_anger
angle64528883_angle
anglo65215383_anglo
angry9310873_angry
angst6415503_angst
bang74837013bang__
banged104923733banged
banger94423643banger
bangle94018963bangle
bangs85627783bang_s
canape10913523canape
cangue91012453cangue
canopy1337733canopy
dang65131553dang__
danged94819493danged
danger83722833danger
dangle84119313dangle
dangly114212273dangly
dangs75623213dang_s
fang85432563fang__
fanga96119633fang_a
fangas105017203fangas
fanged114318233fanged
fangs96224083fang_s
gang66031983gang__
ganged94619203ganged
ganger83721473ganger
gangly113911593gangly
gangs76222583gang_s
gangue81310583gangue
hang85535563hang__
hangar104114523hangar
hanged114222403hanged
hanger104023263hanger
hangs95726733hang_s
hangul1049223hangul
hangup1277303hangup
hangups1364823hangups
jangle144416303jangle
jangly174310613jangly
lang56637393lang__
langue71012183langue
langur7109313langur
manga85026213mang_a
mangas94122933mangas
mange84930203mang_e
mangel94017543mangel
manger94325013manger
manges94628953manges
mangey123614533mangey
mangle93921333mangle
mango85724333mang_o
mangos94319343mangos
mangy115021253mang_y
pang75336303pang__
panga85323543pang_a
pangas99921113pangas
panged104722343panged
pangen94115923pangen
pangs84628673pang_s
rang56939173rang__
range64728423rang_e
ranged84824323ranged
ranger73925533ranger
ranges73826933ranges
rangy95320393rang_y
sang55441243sang__
sanga66023803sang_a
sangar73617693sangar
sangas75222663sangas
sanger74524573sanger
sangh95517463sang_h
sanghs105312073sanghs
stang66424693stang__
stanged94113853stanged
stangs75018173stang_s
tag47259503ta_g__
tagged93418133tagged
tagger84017713tagger
tags55545243ta_g_s
taiga64115673taig_a
taigas73712573taigas
tamp86133013ta_mp_
tamps95524093ta_mps
tan37167583tan___
tanager83010953tanager
tandem9311413tandem
tangelo837043tangelo
tangent8315003tangent
tangier83013913tangier
tanging93419533tanging
tangled94214643tangled
tangler83515083tangler
tangles83920053tangles
tangoed9318843tangoed
tangram1038083tangram
tanist6324603tanist
tank85134033tan__k
tanka93817493tan_ka
tankas104613773tankas
tanked113919303tanked
tanker104521133tanker
tanks94624743tan_ks
tanned75219963tanned
tanner63722293tanner
tannic82811483tannic
tannin62613933tannin
tannoy958363tannoy
tanrec837813tanrec
tans46154833tan__s
tansy84514943tan_sy
tanto55724953tan_to
tantra63713363tantra
tanuki1034923tanuki
tap57663883ta__p_
tapa65129153ta__pa
tape64538153ta__pe
taps66050683ta__ps
targe65227103targ_e
targes74524603targes
target75028913target
tarp66936423ta_rp_
tarps76527123ta_rps
taught104312243taught
taupe7314173ta_upe
tenge65720453teng_e
ting56139913ting__
tinge64626633ting_e
tinged84220813tinged
tinges74722343tinges
tingle74319073tingle
tingly103815983tingly
tings65329213ting_s
tong56434363tong__
tonga65619703tong_a
tongas74315533tongas
tonged86518913tonged
tonger74719693tonger
tongs65928473tong_s
tongue7410103tongue
trangam1039363trangam
tung55328173tung__
tungs65520633tung_s
twang94511863twang__
twanged12387283twanged
twanger11327443twanger
twangle1145813twangle
twangs10358103twang_s
twangy13386993twang_y
vang84926053vang__
vangs96319593vang_s
wangan10311233wangan
wangle103817513wangle
wangun1037113wangun
yang85626083yang__
yangs95618703yang_s

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161685.81319390.3
3Display Results1681680.0463652.2
 (SQL Overall)1786911686.24928595.1
 
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.