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

162 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
trapnest1031092(None) 
trapnests1144431trapnests
grapiest112211922grapiest
tannest72617852t_annest
trampiest13227892trampiest
trapes85024462trap_es_
trapnested1343282trapnested
anapaest1046023anapaest
anapest9311553anap_est
aptest82917513__aptest
braggest1296533braggest
brainiest11209723brainiest
brakiest143912243brakiest
branniest11199383branniest
brashest133511763brashest
bravest124211753bra_vest
brawest123810483bra_west
brawniest14197103brawniest
brownest1398893brownest
crampiest15268613crampiest
cranes84330753cra_nes_
crankest1438143crankest
crapes104727693crap_es_
crappiest15267263crappiest
crassest103411523crassest
craziest19319923craziest
crepiest12310383crepiest
drabbest13295663drabbest
drabness1135803drabness
dragnet91211433dragne_t
dragnets10136563dragnets
drapes95419653drap_es_
earnest7318733_earnest
fainest10417703_fainest
frailest1139493frailest
frankest1536963frankest
frappes14328383frappes_
grainiest10188993grainiest
grandest10311573grandest
grapes95123123grap_es_
grapiness1238253grapiness
grapnel1035603grapne_l
grapnels1134393grapnels
gravest114011633gra_vest
grayest11489363gra_yest
grayness1235933grayness
greenest9312623greenest
gripiest11289633gripiest
inanest72115363ina_nest
iratest7312483ira_test
leanest7415863lea_nest
meanest9315703mea_nest
plainest10313613plainest
raciest92820013_raciest
rainiest81214923_rainiest
rankest112713813_rankest
rapes75740723_rap_es_
raphes115117453_raphes_
rapidest1138543_rapidest
rapines95120863_rapines_
rapist82520673_rap_ist
raptness1046733_raptness
rarest65725483_ra_rest
rashest103916873_rashest
raspiest10311273_raspiest
rawest93615063_ra_west
rawness1038153_rawness
renest64529713_r_enest
ripest84317943_rip_est
ropiest93317773_ropiest
sanest64426693_sa_nest
soapiest102412843soapiest
straitest949173straitest
strangest103210843strangest
strapless1135793strapless
strappiest1444373strappiest
strawiest1237213strawiest
stripiest1138013stripiest
tallest7317093t_allest
tamest85721293t_a_mest
tanist6324593t_a_nist
tapes75838603t_ap_es_
tappet103820113t_appe_t
tappets113610013t_appets
tardiest93515243tardiest
tarriest83215003tarriest
tartest72517533t_artest
tartiest82718313tartiest
tartness82210133tartness
tautest72612443t_autest
tawniest11279343t_awniest
teariest82417263teariest
tempest1139223temp_est
thanes94918983tha_nes_
thinnest11248893thinnest
tippiest122310013tippiest
traces85329933tra_ces_
trades75724503tra_des_
trained84117203traine_d
trainee72817793traine_e
trainees82712063trainees
trainer73316793traine_r
trainers83114643trainers
trains64725343train_s_
traipses1036873traipses_
traject1637043tra_ject
tramless1037503tramless
tramples122610203tramples_
trances93919643trances_
tranks104017763tra_nks_
trannies8415013trannies_
tranqs155210313tra_nqs_
trans54933043tra_n_s_
transect10410053transect
transept1048633transept
transit7317163tra_nsit
trapans92812463trapans_
trapesed1136473trap_esed
trapeses1039153trap_eses
trapeze1836253trap_eze
trapezes1936543trapezes_
trapezist2044343trapezist
traplines11310373traplines_
trapnesting1453153trapnesting
trappean1244393trappean
trapped124512213trappe_d
trapper113912803trappe_r
trappers123711043trappers
trappose1245813trappose
traps75727483trap__s_
trapt76433393trap___t
trashes104119263trashes_
trashiest123110633trashiest
trasses74819323trasses_
traves94222743tra_ves_
travesty1444483tra_vesty
trawlnet1146583trawlne_t
trawlnets1242843trawlnets
trienes74118413trienes_
triggest1036923triggest
trigness968403trigness
trimmest12227023trimmest
trimness1067563trimness
trines64132563tr_ines_
tripes85324873trip_es_
triples94616873triples_
triplet94319213triple_t
triplets103510263triplets
trippet113714113trippe_t
trippets12357423trippets
trippiest1336583trippiest
tritest7315273tr_itest
triunes74311383triunes_
trones65629283tr_ones_
tropes84824353trop_es_
tropines102214923tropines_
trueness838693trueness
truest64816193tr__uest
typiest1238203t_ypiest
urbanest10117533urbanest
vainest10315763_vainest
wannest103915003_wannest

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621626.46622604.7
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.95225703.5
 
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.