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

138 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
apanage103680(None) 
apanages1137011apanages
appanage1344081appanage
apagoge11164682apagoge
appanages1443992appanages
manage93818902_manage
pawnage1335872pawnage
spinage10289652spinage
thanage11117942thanage
acreage1037843acreage
adage7414053__adage
adnate72913483a_dnate
advantage1452183advantage
agapae9388043agapa_e
agnate73314883a_gnate
alane56135613alan__e
alang66023513alan_g_
alanine7316863alanine
alienage945583alienage
ambage11510603a_mbage
amperage1347743amperage
anagoge9166643anagoge
ananke1038283anan_ke
anatase738943anatase
anlage72514233a_nlage
apace94718383ap__ace
apache134210773apa_che
apagoges12144693apagoges
apatite9312963apatite
aphanite1348773aphanite
aping87327233apin_g_
appease1137913appease
appendage1553343appendage
apyrase1236363apyrase
arrange838683arran_ge
asana5315483asana__
asanas6514113asana_s
assuage835683assuage
asswage1144673asswage
avenge1087553aven_ge
average1158853average
badinage1294923badinage
bandage11311023_bandage
baronage1147073baronage
canape10913513_canape
carnage10311743carnage
change124116753chan_ge
chantage1446633chantage
coinage10310553coinage
comanage1346343comanage
cyanate12259703cyanate
damage10410773_damage
drainage1045783drainage
drayage1234423drayage
dunnage9175213dunnage
emanate9312473emanate
flange103411973flan_ge
garage8314513_garage
gavage1137193_gavage
grange83716203gran_ge
guanase836213guanase
innage73011573_innage
japanize2645283japanize
khanate1437073khanate
lanate6421263_lanate
lavage1038263_lavage
leafage1194573leafage
leakage1235003leakage
linage7713403_linage
managed113212603_managed
manager103413583_manager
manages103418963_manages
manege94113203_manege
mange84930193_man_ge
menage93216543_menage
nonage7313683_nonage
orange74016323oran_ge
orphanage1552143orphanage
package16128013package
padnag1036073padnag_
padnags1135083padnags
page76036103_p__age
palace104516913_palace
palate84226783_palate
panacea1137783_panacea
panache1458423_panache
panada94113053_panada
panama104213353_panama
pancake1536673_pancake
pane64950293_pan__e
pang75336293_pan_g_
panga85323533_pan_ga
pangas99921103_pangas
panged104722333_pan_ged
pangen94115913_pan_gen
pangs84628663_pan_gs
panne76623653_pan_ne
pantie84326473_pantie
parade94720643_parade
parae76335703_para_e
parge85831853_pa_rge
passage1039803passage
pavane114113443_pavane
pawnages1435313pawnages
peage84723573_p_eage
pelage9515363_pelage
peonage1048723peonage
phage115113673_p_hage
pipage1199143_pipage
plage84520403_p_lage
planate9314573planate
potage92715903_potage
quayage2044573quayage
range64728413_ran_ge
ravage1039303_ravage
savage10410173_savage
scalage103110533scalage
signage937773signage
soakage1236103soakage
spang84919733span_g_
spangle1038403spangle
sparge94216053spa_rge
spinages11289293spinages
spinate93114813spinate
sponge939663spon_ge
tanager83010943_tanager
tankage12257773_tankage
tannage8209583tannage
tapenade1145003tapenade
teenage8108053teenage
thanages12107623thanages
thenage11107843thenage
tonnage8168053tonnage
tunnage8166373tunnage
upstage10167443upstage
vantage11109893_vantage
wagonage1343293wagonage
wantage11119623_wantage

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.440406115.9
2DLD Change Limit1340271386.06322105.7
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.54927285.2
 
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.