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

275 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
trendies931221(None) 
trendier937911trendier
trendiest1038421trendiest
brandies11714562brandies
frenzies2037712frenzies
randies84225662_randies
readies83324702_readies
teddies92711282t_eddies
tennies73017972t_ennies
threnodies1443922threnodies
trannies8415012trannies
treadles939692treadles
treaties8316982treaties
treddles1036262treddles
trenails869842trenails
trenches133512602trenches
trended94011762trend_ed
trendily1256442trendily
trendiness1146222trendiness
trending103012832trending
trendoids1143932trendoids
trends75513542trend__s
trindles93211682trindles
trundles9278472trundles
twenties1137502twenties
agencies1138743agencies
ardencies1247853ardencies
arenes64928393aren__es
arenites8917103arenites
arsenides1095613arsenides
attendees1044053attendees
bandies104124863_bandies
beedies10314203_beedies
bendees103913863_bendees
bendier103111413_bendier
bendiest112311983_bendiest
bennies93917313_bennies
blendes104713683blend_es
blennies1056933blennies
brandied1259113brandied
bredes94818473bre_d_es
brindles113710223brindles
brinies93317913brin_ies
candies104125613_candies
crannies10313013crannies
credits1039973cre_dits
creepies1239613creepies
cronies9622503cron_ies
crowdies1437543crowdies
dandies94121443_dandies
denies74729643_den_ies
drearies92313413drearies
dredges10379343dre_dges
drenches14309803drenches
duendes938193duend_es
eddies83313163__eddies
endites83717063__endites
endives113710693__endives
endues73813903__endues
envies9314053__envies
freebies1337873freebies
frenches163311633frenches
frenzied2144043frenzied
friendlies1442933friendlies
genies75324943_gen_ies
grandees103211283grandees
grannies9312613grannies
greedier1036083greedier
greediest1147553greediest
greenies9312673greenies
gremmies1355993gremmies
grenades1038433grenades
grenadier1144093grenadier
grenadiers1242583grenadiers
grenadines1245163grenadines
henries102718283_henries
indies73822773__indies
irenics937833iren_ics
ironies7517423iron_ies
jennies143511623_jennies
lindies8416583_lindies
maundies1137853maundies
neddies92710703_neddies
oreides8312023oreid_es
organdies1187213organdies
pandies104224503_pandies
pennies94218813_pennies
phrensies1445743phrensies
plenties10314693plenties
predries112714383predries
preedits1168763preedits
preemies12512193preemies
premies113823063pre_mies
prenames12311633prenames
prentices131111903prentices
preppies1149673preppies
presides11414913presides
pretties10615133pretties
prexies163415003pre_xies
randier83618473_randier
randiest93418773_randiest
readied93316623_readied
readier83117423_readier
readiest93719043_readiest
rebodies1139153_rebodies
reddles93315773_reddles
redes65139123_re_d_es
redias74523603_re_dias
redips93713843_re_dips
redoes74623753_re_does
redries83721713_redries
redyes104214083_re_dyes
reedier83815303_reedier
reediest92815423_reediest
reedits8511743_reedits
reflies104418533_reflies
refries104419733_refries
reifies104218283_reifies
relies65036423_re_lies
remedies11310553_remedies
renails74917263_renails
renames92418053_renames
rended84524103_rend_ed
render74024143_rend_er
renders83821673_renders
rending93924263_rending
rends65129953_rend__s
reneges82513593_reneges
renigs74314593_ren_igs
renins64526453_ren_ins
rennins74013413_rennins
rentes65431193_ren_tes
rentier73618223_rentier
rentiers83311763_rentiers
replies94521043_replies
resides84523283_resides
reties65436193_re_ties
retries74129073_retries
roadies83317433_roadies
rowdies113112693_rowdies
rundles83214713_rundles
shandies122714103shandies
shindies122610503shindies
shrewdies1643733shrewdies
spendier1147143spendier
spendiest1237523spendiest
steadies9311123steadies
taenias7311283taen_ias
tansies74521243t_ansies
tardies84225863t_ardies
tawnies102812503tawn_ies
techies12513603t_echies
teenier72611143teen_ier
teeniest82112413teen_iest
teensier835573teensier
teensiest945823teensiest
tekkies1035943t_ekkies
tellies73820503t_ellies
tenaces92814513t_enaces
tenails73713923t_enails
tenches123515523t_enches
tended83819483t_end_ed
tender74121843t_end_er
tenders83719723t_enders
tending94419163t_ending
tendons8311473t_endons
tendrils946443t_endrils
tends65425583t_end__s
tendus75111183t_end_us
tenias64720073t_en_ias
tennis64015303t_enni_s
tennises82810133t_ennises
tenpins9410073t_enpins
tenses64722553t_en_ses
tentie62521183t_entie_
tentier73815923t_entier
tentiest82115613t_entiest
tenues63816443t_en_ues
tenuis64213083t_enui_s
tenures7412013t_enures
teredines1049453teredines
ternaries9311623ternaries
ternes65422903tern__es
terries73425613t_erries
thenages12107473thenages
theories11311593theories
threadier1354473threadier
threadiest1444283threadiest
threnodes1354963threnodes
tidies74721833t__idies
toadies82914853t_oadies
toddies93011993t_oddies
todies74223553t__odies
toenails847213toenails
toonies73719883toon_ies
townies103113623town_ies
trades75724493tr_ad_es
tragedies1146523tragedies
trances93919643tran_ces
tranches132915513tranches
transits8313493transits
treacles1039703treacles
treaded95014283tread_ed
treader84113823tread_er
treaders93311833treaders
treading103515333treading
treadle8310103treadle_
treadled1067123treadled
treadler936853treadler
treadlers1045883treadlers
treadless1035993treadless
treads74817913tread__s
treatise8311103treatise
treatises9310373treatises
trebles9311443tre_bles
treddle936433treddle_
treddled1134473treddled
treenails945563treenails
trees55835763tre___es
trefoils1145303trefoils
trellis739873trelli_s
trellises947023trellises
trembles1237353trembles
trenail7410803trenai_l
trenched14289853trenched
trencher13279313trencher
trenchers14288073trenchers
trend64817453trend___
trendoid1045443trendoid
trendy10469603trend__y
trephines1448483trephines
tresses73719543tre_sses
tressier847963tressier
tressiest937883tressiest
trestles83012553trestles
triadics1146123triadics
trienes74118413trien__es
trientes82812123trien_tes
tries55742813tr___ies
trilbies1037693trilbies
trindle83311363trindle_
trindled10388693trindled
trines64132563trin__es
trinities9313333trinities
triodes84012503triod_es
tripodies1246573tripodies
trollies8310233trollies
trones65629283tron__es
trophies13413673trophies
truancies1146873truancies
trudges9339983tr_udges
trundle8307873trundle_
trundled10306393trundled
trundler9256143trundler
trundlers10214993trundlers
trusties82712853trusties
tunnies73614263t_unnies
turgencies1345513turgencies
turneries948493turneries
twankies1535893twankies
tweedier1253623tweedier
tweediest1344273tweediest
tweedles1234113tweedles
tweenies11146393tweenies
twinkies1535983twinkies
tyrannies1255533tyrannies
undies73821963__undies
uranides92211283uranides
ureides8311103ureid_es
urgencies1256643urgencies
vendees114011453_vendees
vendues11318623_vendues
weenies102915093ween_ies
wienies102213683wien_ies
wrenches163210233wrenches

Search took 10 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.1701051123.5
2DLD Change Limit1461622759.30015716.3
3Display Results2752750.1232235.8
 (SQL Overall)1786912759.59318627.2
 
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.