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

179 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
thanage1111794(None) 
thanages12107621thanages
thenage11107841thenage
apanage1036802apanage
change124116752chan_ge
chantage1446632chantage
khanate1437072khanate
manage93818902_manage
tanager83010942t_anager
tankage12257772t_ankage
tannage8209582tannage
teenage8108052teenage
thane86122532than__e
thenages12107482thenages
tonnage8168052tonnage
tunnage8166372tunnage
adage7414053__adage
anlage72514233__anlage
apanages1137013apanages
appanage1344083appanage
athanasy1442763athanasy
bandage11311023_bandage
bhang115512923bhan_g_
bhangs12449663bhan_gs
canape10913513_canape
carnage10311743carnage
chamade15138453chamade
chance134617093chan_ce
chancre14348783chancre
chang115418563chan_g_
changed144214143chan_ged
changer134215543chan_ger
changes134517583chan_ges
changs125215373chan_gs
chantages1546583chantages
charade13129913charade
charge125114213cha_rge
choanae1236863choana_e
coinage10310553coinage
comanage1346343comanage
cyanate12259703cyanate
damage10410773_damage
drainage1045783drainage
drayage1234423drayage
dunnage9175213dunnage
emanate9312473emanate
ethane94613243ethan__e
flange103411973flan_ge
garage8314513_garage
gavage1137193_gavage
grange83716203gran_ge
guanase836213guanase
hamate113319833_hamate
hanaper1237133_hanaper
hance105424153_han_ce
handle104219293_handle
hang85535553_han_g_
hangar104114513_hangar
hanged114222393_han_ged
hanger104023253_han_ger
hangs95726723_han_gs
hankie133915713_hankie
hanse85722793_han_se
hantle94318203_hantle
haulage1136913_haulage
haylage1436443_haylage
henge94819833_hen_ge
hinge95323453_hin_ge
homage121210603_homage
innage73011573_innage
khanates1535733khanates
lanate6421263_lanate
lavage1038263_lavage
leafage1194573leafage
leakage1235003leakage
linage7713403_linage
managed113212603_managed
manager103413583_manager
manages103418963_manages
manege94113203_manege
mange84930193_man_ge
menage93216543_menage
nonage7313683_nonage
ohmage1295063oh_mage
orange74016323oran_ge
orphanage1552143orphanage
pawnage1335873pawnage
peonage1048723peonage
phage115113673ph__age
phalange1465193phalange
phenate12412203phenate
phonate12411813phonate
planate9314573planate
quayage2044573quayage
range64728413_ran_ge
ravage1039303_ravage
savage10410173_savage
scalage103110533scalage
signage937773signage
soakage1236103soakage
spinage10289653spinage
stealage946583stealage
strange85416343stran_ge
stravage1245563stravage
takahe1335793t_akahe
tallage82712073tallage
tamale83717403t_amale
tanagers9259003t_anagers
tang56138673t_an_g_
tanga64923693t_an_ga
tanged84622493t_an_ged
tangle74019953t_angle
tango66921173t_an_go
tangs65028343t_an_gs
tangy94519933t_an_gy
tankages13217113t_ankages
tannages9228963tannages
tannate71813523tannate
targe65227093t_a_rge
teacake1335453teacake
teaware1048143teaware
teenaged10105133teenaged
teenager9115293teenager
tenace82715693t_enace
tenge65720443t_en_ge
tentage81010643tentage
ternate7415483ternate
thae76825563th__a_e
thalami1246083thalami
thalweg1442033thalweg
than76128773than___
thanatos1165123thanatos
thanes94918983than_es
thank125817803than__k
thanked15469153thanked
thanker14309593thanker
thanks134313133than_ks
thecae11299653theca_e
thecate123210023thecate
thenal92712423thena_l
thenar92610003thena_r
thenars10248523thenars
thence112010843then_ce
thine85026863thin__e
thing96622983thin_g_
things104914303thin_gs
thionate11137503thionate
thirlage1243823thirlage
thong95014183thon_g_
thonged12376843thon_ged
thongs104611193thon_gs
thrave126010273th_rave
tillage83111343tillage
tinge64626623t_in_ge
titanate897173titanate
tollage82610163tollage
tonnages9187873tonnages
towage1039833t_owage
trackage1545653trackage
trance84718763tran_ce
tranche123312223tranche
trangam1039353trangam
triage72812893t_riage
tunnages9195903tunnages
twang94511853twan_g_
twanged12387273twan_ged
twanger11327433twan_ger
twangle1145803twangle
twangs10358093twan_gs
twangy13386983twan_gy
twinge104210403twin_ge
vantage11109893_vantage
wantage11119623_wantage
whang124813383whan_g_
whanged15447613whan_ged
whangee14268613whangee
whangs13439723whan_gs
wharfage1842213wharfage
whinge134311543whin_ge

Search took 8 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.453394461.4
2DLD Change Limit1340271797.34318252.3
3Display Results1791790.0802237.5
 (SQL Overall)1786911797.87622688.0
 
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.