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

127 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
perpends1322775(None) 
perpend12259351perpend_
perpents122312041perpents
depends11348992de_pends
expends17217082_expends
percents122713372percents
perpended1546082perpended
perpent112318812perpen_t
portends11358962portends
prebends13347882prebends
pretends11299112pretends
propends13249172propends
serpents102410372serpents
terpenes102111572terpenes
aperients1178253aperients
appends1236393_appends
arpens84814823_arpen_s
arpents93613083_arpents
bartends1136793bartends
befriends1542413befriends
compends15378253compends
deepens10307813deepen_s
defends12358773de_fends
depend103510923de_pend_
descends12266983descends
desponds1246243desponds
dispends12308533dispends
emends95711433_e_mends
errands847603_errands
expands17195733_expands
expend16247503_expend_
extends15227113_extends
ferments13311473ferments
forfends1544833forfends
friends11396743_friends
gerents82612923ger_ents
germens1078633germen_s
gerunds935183ger_unds
headends13326723headends
herpes115517323herpe__s
impends12376803_impends
jereeds15326393jer_eeds
jerreeds1653273jerreeds
legends936073le_gends
nereids838743ner_eids
operands1146813oper_ands
overlends13237523overlends
overspends1644443overspends
parents93418133par_ents
parvenus1335663parvenus
peahens12307573peahen_s
pectens11189203pecten_s
peens76428193pe__en_s
peeped113915393peepe_d_
peepers113713673peepe_rs
pendents1139413pendents
pends85527193___pends
pentenes10315633pentenes
pepinos1137693pe_pinos
pepped103113403peppe_d_
peppers103311443peppe_rs
peptids12239333pe_ptids
peracids13310073peracids
percent113520603percen_t
percepts14247643percepts
percoids1339663percoids
pereons92815003per_eons
peres76246643per_e__s
perfects15107353perfects
periods10312243per_iods
perked134617693perke_d_
permed115217353perme_d_
pernods1038483per_nods
peroxids1837453peroxids
perpending1646683perpending
perplexes2044683perplexes
perps95521483perp___s
perrons93115483perron_s
perses85428063perse__s
personas102511883personas
persons93717013person_s
perspexes2043843perspexes
pertness10310093pertness
perverts1337533perverts
pigpens1235503pigpen_s
portend103411193portend_
portents103512823portents
prebend12319443prebend_
prebinds13357733prebinds
precents123015043precents
preens85020113p_reen_s
prefunds1454703prefunds
premeds12389593preme_ds
prepense12238943prepense
presents103315643presents
pretend104011013pretend_
prevents133012293prevents
propend123311273propend_
propenes122816513propenes
protends113010353protends
pyrenes123511223pyr_enes
reblends1135293reblends
relends84013253re_lends
remends105013033re_mends
rends65129953__r_ends
reopens939373reopen_s
repents93717623re_pents
rereads81512293rer_eads
rerents73319423rer_ents
resends83513713re_sends
responds1136913responds
serenes73222903ser_enes
serpent92916283serpen_t
spends94714473__spends
stipends11304793stipends
suspends1145143suspends
terpene92310863terpen_e
terpenic1247213terpenic
terpenoids1353583terpenoids
terrenes82212603terrenes
trends75513543_tr_ends
upends9438763__upends
uptrends1142833uptr_ends
verbenas1345343verbenas
weekends1642733weekends
wergelds1342293wergelds
yearends12234483yearends

Search took 9 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 Limit1461621278.22017781.3
3Display Results1271270.0602116.7
 (SQL Overall)1786911278.70320532.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.