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

274 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
deperms123660(None) 
degerms1135621degerms
deperm1139361deperm_
decerns10119052decerns
deems85421772de_e_ms
deers64930522de_er_s
defers105116942defer_s
deforms1337802deforms
degerm1037892degerm_
departs104310682departs
depends11348992depends
depermed1436452depermed
deports105012882deports
depress10239872depress
derms85022892d__erms
deserts82513052deserts
deters74724682deter_s
deworms1338032deworms
dopers95522482doper_s
dupers94615602duper_s
lepers84817322leper_s
perms95524512__perms
reperks13298092reperks
sperms102512602_sperms
adeems946333ade_e_ms
amperes11313983amperes
apers76629133_aper_s
aspers86220313asper_s
beepers113612383beeper_s
beers75628393be_er_s
berms95323663__berms
beseems1175913beseems
beworms1437933beworms
capers105428143caper_s
ceders93817673ceder_s
cepes94424463cepe__s
copers104629843coper_s
dampers123915693damper_s
darers75921873darer_s
daters74827373dater_s
deairs74013783deair_s
dealers84118613dealer_s
dears65736883de_ar_s
debarks14388493debarks
debars94218043debar_s
debeaks1436103debeaks
debeards1235503debeards
debris93311493de_bris
decares102818533decares
deceits102810883deceits
decern91310953decer_n
deckers144413833decker_s
decors94017773decor_s
decorums1344993decorums
decrees102513123decrees
deeds75423763de_e_ds
deem75432893de_e_m_
deepens10307813deepens
deeper93613503deeper__
deeps84921773de_e_ps
deer56739023de_er__
dees56356633de_e__s
deets65330243de_e_ts
defeats113511233defeats
defects134511523defects
defends12358773defends
defer94619753defer__
defiers113913993defier_s
defoams1336193defoams
deform1259623deform_
degermed1335453degermed
degrees92810723degrees
degums10438623de_gums
dehorns11428363dehorns
dehorts11379773dehorts
deicers103612733deicer_s
deisms94411043de_isms
dejects17389223dejects
dekares122710873dekares
dekes105224453deke__s
deleads9379703deleads
deles65139253dele__s
deletes83117933deletes
delvers113411993delver_s
demarks14339233demarks
demeans1039723demeans
dements103016623dements
demerge11168023demerge
demerges12129503demerges
demerit10314993demerit
demerits11310763demerits
demes86032693deme__s
demurs939773demur_s
denars74621433denar_s
denes65639723dene__s
deniers84515183denier_s
denims95214323de_nims
depart94720563depar_t
depend103510923depe_nd
deperming1537113deperming
depicts12358463depicts
depletes112810643depletes
deplores1139533deplores
deploys1336523deploys
deplume1255063deplume
deplumes1334943deplumes
depones103717093depones
deport94922393depor_t
deposers11359243deposer_s
deposes103117213deposes
depots94716343dep_ots
depths12428573dep_ths
deputes104911783deputes
derm76031893d__erm_
derma84918513d__erma
dermas94116813d__ermas
dermis94717163d__ermis
derris73615273de_rris
desert72725493deser_t
deserve11108703deserve
deserves12109893deserves
desexes1537833desexes
desires81316133desires
desorbs10437713desorbs
desserts9247923desserts
detects104011093detects
detents83615153detents
deter65028043deter__
deterge9118463deterge
deterges101510093deterges
detests83711743detests
deveins1138813deveins
devels104313903deve_ls
devests114410473devests
dewars105117073dewar_s
deworm1249533deworm_
dexes135224513dexe__s
diapers104713913diaper_s
dicers94720743dicer_s
dieters83216433dieter_s
dikers114418793diker_s
dimers94321093dimer_s
dineros83812333dineros
diners75525953diner_s
dippers123615183dipper_s
disarms1039043disarms
divers105024963diver_s
diverts114412033diverts
doers65225713d_oer_s
doper86128393doper__
dopes84935043dope__s
dorms85723843d__orms
dorpers104113173dorper_s
dosers75723633doser_s
doters74423913doter_s
dowers104523293dower_s
dozers164815423dozer_s
drapers105313353draper_s
dreams94513983d_reams
driers74516733drier_s
dryers10449273dryer_s
duelers83412053dueler_s
dumpers123412663dumper_s
duper85519003duper__
duperies11312813duperies
dupery12378743duper_y
dupes86425933dupe__s
dyers96617133d_yer_s
edgers84413923edger_s
egers65120373_eger_s
epees75219833_epe_es
epiderms1345043_epiderms
everts94514893_everts
ewers86018823_ewer_s
exerts133712293_exerts
experts1659063experts
eyers86521333_eyer_s
fevers125414893fever_s
gapers94520473gaper_s
germs85118873__germs
heapers123616673heaper_s
heders104119763heder_s
helpers123311853helper_s
herms105626433__herms
heteros10312683heteros
hewers123715273hewer_s
hexers165612753hexer_s
hopers114222973hoper_s
hypers144811913hyper_s
japers154616173japer_s
jeepers16399193jeeper_s
jeers124818133je_er_s
keepers133410983keeper_s
leapers93716663leaper_s
leers54828983le_er_s
legers74518313leger_s
leper74820743leper__
levers94621323lever_s
lopers84424143loper_s
meseems1165603meseems
meters85625833meter_s
mopers104220373moper_s
neems77316293ne_e_ms
nepetas935943nepetas
oosperms1243793oosperms
operas8312453_operas
papers105125323paper_s
peepers113713673peeper_s
peers75130273pe_er_s
peplums13145503peplums
peppers103311443pepper_s
peres76246643__peres
peris75537073__peris
perks115325803__perks
perm85834633__perm_
perps95521483__perps
pervs105117373__pervs
peters86624593peter_s
pipers104318663piper_s
preterms1237223preterms
rapers84327183raper_s
reapers93520453reaper_s
rearms85114653re_arms
redeems1037163redeems
refers93921083refer_s
reforms1239823reforms
rehems113410983rehe_ms
reparks13249513reparks
repeals94014523repeals
repeats94316053repeats
repegs93311943repe_gs
repels84318763repe_ls
repents93717623repents
reperk122511773reper_k
reports94916213reports
repress92712683repress
repros84216003rep_ros
reteams9339563reteams
retems83914573rete_ms
reverbs12368863reverbs
reveres103621343reveres
revers94529633rever_s
reverts104715043reverts
rewarms12439603rewarms
rezeros1647453rezeros
ropers84325903roper_s
secerns987733secerns
seders74420283seder_s
seems75525023se_e_ms
seers55136383se_er_s
septums1135743septums
severs94121123sever_s
sewers94719723sewer_s
speers85019953speer_s
sperm93216023_sperm_
supers84622403super_s
tapers84025813taper_s
teems76019783te_e_ms
temperas12278233temperas
tempers113513013temper_s
tepees84215243tepe_es
tephras1236283tephras
terms75523473__terms
therms115914873_therms
topers85025323toper_s
uppers102912293upper_s
veers84521363ve_er_s
vespers1239033vesper_s
vexers165210403vexer_s
vipers114914533viper_s
webers11310943weber_s
weepers123511973weeper_s
wipers115416083wiper_s
yelpers12348203yelper_s

Search took 8 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 Filter1786911340270.500357382.0
2DLD Change Limit1340272746.48620664.0
3Display Results2742740.0932946.2
 (SQL Overall)1786912747.07925242.4
 
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.