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

137 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
perverse133610(None) 
permease1246502permease
perversely1852072perversely
perversive1844352perversive
pervert12315582perver_t
perverted1546072perverted
perverter1445552perverter
perverts1337522perverts
reverse103913742re_verse
servers103214832servers_
adverse1145953_adverse
averse95811183__averse
beavers124417323beavers_
berceuse1243433berceuse
bergere1068913berger_e
bergeres1189103bergeres
carvers124817533carvers_
converse13310263converse
delvers113411993delvers_
derivers123811363derivers_
diverse11429993_diverse
elvers93814983_elvers_
fervors1336233fervors_
fevers125414893fe_vers_
heavers133717193heavers_
herders113914123herders_
inverse10249643_inverse
jerkers18287083jerkers_
kermesse14303483kermesse
leavers103717783leavers_
levers94621323le_vers_
mercerise1356413mercerise
mercers114412773mercers_
mergers103813423mergers_
nerves94216193nerve_s_
nervure1034973nervur_e
nervures1135123nervures
obverse1234753_obverse
parers85530743par_ers_
parkers133816873parkers_
parsers94118153parsers_
parterre1036983parterre
parvenue1344913parvenue
parvise124211693parv_ise
pavers115021823p_avers_
pearlers1039023pearlers_
peaveys15324063peaveys_
peckers153312673peckers_
pedlers103013273pedlers_
peelers93615593peelers_
peepers113713673peepers_
peerie83617893pe__erie
peers75130273pe__ers_
peeves113814873peeve_s_
pelters93720313pelters_
pelves114514663pelve_s_
penners93414183penners_
peppers103311443peppers_
perceive1546963perceive
perchers153611523perchers_
perdure10379623perdur_e
perdures11289683perdures
peres76246643per_e_s_
perforce1544963perforce
perfuse1247663per_fuse
perjure16327963perjur_e
perjures17268083perjures
permeases1347093permeases
permeate12311603permeate
perse75429523p___erse
perses85428063perse_s_
persevere1443973persever_e
perseveres1543393perseveres
perter84422283perter__
pertest9317043perte_st
peruse84016843per__use
perusers10328803perusers_
pervade1337023perv_ade
pervaders1544433pervaders_
pervades1437343pervades
perversion1545843perversion
perversity1853463perversity
perverters1544943perverters
pervs105117373perv__s_
pesters93827093pesters_
peters86624593pe_ters_
petters93722363petters_
pewters124113353pewters_
piercers12316723piercers_
plovers123611833plovers_
porkers134314933porkers_
porters93722703porters_
preavers13910263preavers_
prefers123713333prefers_
premorse1237553premorse
prepense12238933prepense
prese75228383p_r_e_se
preserve13108793preserve
pretense10199813pretense
preverb14317063prever_b
preverbs15295303preverbs
previse123713793prev_ise
preyers124412363preyers_
priers84521193p_riers_
provers123817793provers_
pryers115012243p_ryers_
puerperae1342903puerperae
pulverise1445063pulverise
purgers104714003purgers_
pursers93916093pursers_
purveys15615903purveys_
reavers108320743reavers_
reivers105117083reivers_
revere94621253re_ver_e
reveres103621343re_veres
reverie103615163re_verie
revers94529633re_vers_
reversed122711613re_versed
reverser113010483re_verser
reverses112513513re_verses
reverso10367693re_verso
sergers83815633sergers_
server94917713server__
serves94423653serve_s_
severe94016083se_ver_e
severs94121123se_vers_
swervers1455213swervers_
termers95414503termers_
traverse1136213traverse
universe1145253universe
vergers114412623vergers_
verse84723583___verse
versers103813513versers_
verves124617883verve_s_
vervets13419743vervets_
weavers133714463weavers_
weevers13379993weevers_

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.1561145455.1
2DLD Change Limit1461621378.97016294.5
3Display Results1371370.0462978.3
 (SQL Overall)1786911379.17219482.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.