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

198 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
perverts133753(None) 
pervert12315581pervert_
everts94514892_e_verts
percents122713372percents
percepts14247642percepts
perfects15107352perfects
perpents122312032perpents
perverse1336102perverse
perverted1546092perverted
perverter1445562perverter
perverters1544962perverters
prevents133012292prevents
preverbs15295302preverbs
reverts104715042re_verts
servers103214832server_s
vervets13419752verve_ts
adverts11308513_adverts
aperients1178253aperients
averts95715243__averts
beavers124417323beaver_s
berberis1246603berberis
berets85822523ber_e_ts
bergeres1189113bergeres
berserks1433993berserks
brevets12519393breve_ts
carvers124817533carver_s
cermets1139713cerme_ts
cervelas1344673cervelas
cervelats1443493cervelats
cervezas2242013cervezas
converts133213553converts
corvets124715023corve_ts
coverts124813813_coverts
culverts13295323culverts
curvets12399913curve_ts
delvers113411993delver_s
derivers123811363deriver_s
deserts82513053de_serts
desserts9247923desserts
devests114410473de_vests
diverts114412033_diverts
elvers93814983_elver_s
erects84116183_er_ects
events94814073_e_vents
evert84929513_e_vert_
exerts133712293_e_xerts
experts1659063_experts
exserts1467013_exserts
ferments13311473ferments
ferrets103111393ferre_ts
fervent13310063fervent_
fervors1336233fervor_s
fevers125414893fe_ver_s
gerberas1144963gerberas
gerents82612923ger_ents
harvests14246173harvests
heavers133717193heaver_s
herders113914123herder_s
inverts103211953_inverts
jerkers18287083jerker_s
leavers103717783leaver_s
leverets11297603le_verets
levers94621323le_ver_s
mercers114412773mercer_s
mergers103813423merger_s
nerves94216193nerve__s
nervures1135123nervures
obverts1235403_obverts
parents93418123par_ents
parers85530743par_er_s
pargets105215193parge_ts
parkers133816873parker_s
parsers94118153parser_s
parvenus1335653parvenus
pavers115021823p_aver_s
pearlers1039033pearler_s
peaveys15324063peave_ys
peckers153312673pecker_s
pedlers103013273pedler_s
peelers93615593peeler_s
peepers113713673peeper_s
peers75130273pe__er_s
peeves113814873peeve__s
pellets94014783pelle_ts
pelmets11309693pelme_ts
pelters93720313pelter_s
pelves114514663pelve__s
pendents1139413pendents
penners93414183penner_s
peppers103311443pepper_s
percent113520603percent_
percept133112523percept_
perchers153611523percher_s
perdures11289683perdures
pereons92815003per_eons
peres76246643per_e__s
perfect141010833perfect_
perfecta15115203perfecta
perfectas16135073perfectas
perfecto15105743perfecto
perfectos16106073perfectos
performs1547483performs
periapts1237273periapts
periderms1444993periderms
peridots1138323peridots
perjures17268083perjures
permeate12311613permeate
permeates13311773permeates
permits11314003per_mits
perpends13227743perpends
perpent112318803perpent_
persalts1038193persalts
perses85428063perse__s
perseveres1543393perseveres
persists1049183persists
perter84422283perter__
pertest9317043pertest_
perturbs1244363perturbs
perusers10328803peruser_s
pervaders1544433pervader_s
pervades1437353pervades
perversity1853463perversity
perverting1646623perverting
pervious1337543pervious
pervs105117373perv___s
pesters93827093pester_s
peters86624593pe_ter_s
petters93722363petter_s
pewters124113353pewter_s
piercers12316723piercer_s
plovers123611833plover_s
porkers134314933porker_s
portents103512823portents
porters93722703porter_s
poverty1536433p_overty
preavers13910263preaver_s
precents123015043precents
precepts14268893precepts
prefects1598133prefects
prefers123713333prefer_s
preheats1339413preheats
prelects1299723prelects
presents103315643presents
presets94216423prese_ts
presorts105311683presorts
prests84021263p_r_ests
preterits11410963preterits
preterms1237223preterms
pretests10310013pretests
pretexts1735603pretexts
prevent124016553prevent_
preverb14317063prever_b
preyers124412363preyer_s
priers84521193p_rier_s
priests93810863p_riests
privets122910053prive_ts
proverbs15315583proverbs
provers123817793prover_s
pryers115012243p_ryer_s
purgers104714003purger_s
purports1265783purports
pursers93916093purser_s
purveys15615903purve_ys
reavers108320743reaver_s
reivers105117083reiver_s
rerents73319423rer_ents
reverbs12368863re_verbs
reveres103621343re_veres
revers94529633re_ver_s
revert93529113re_vert_
revests104413733re_vests
revets94022173re_ve_ts
sergers83815633serger_s
serpents102410373serpents
servants1137993servants
server94917713server__
serves94423653serve__s
severs94121123se_ver_s
sherberts1443593sherberts
sieverts1145713sieverts
subverts1336973subverts
swervers1455213swerver_s
tercets93512443terce_ts
termers95414503termer_s
terrets72913583terre_ts
trevets10499973treve_ts
velverets1543083velverets
velvets13326693velve_ts
vergers114412633verger_s
versers103813523verser_s
versets103913103verse_ts
verts85724733___verts
verves124617883verve__s
vervet124619063verve_t_
vetiverts1542343vetiverts
weavers133714463weaver_s
weevers13379993weever_s
wergelts1253413wergelts

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.1561145455.1
2DLD Change Limit1461621987.78318779.6
3Display Results1981980.0762605.3
 (SQL Overall)1786911988.01522294.6
 
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.