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

349 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
servals10341074(None) 
serials73919741serials
serval93913411serval_
aerials74017552aerials
cereals9313172cereals
ervils948772_ervils
ferals94216642fer_als
herbals122710602herbals
seals54839692se__als
selvas93812912selva_s
sendals81912262sendals
sepals85217372se_pals
seracs84418572ser_acs
serails73318362serails
serais64326132ser_ais
seral56336382ser_al_
serdabs1035322serdabs
serial64625862serial_
serovars1145232serovars
servable13310082servable
servant10313622servant
servants1137992servants
servers103214832servers
serves94423652serv_es
servile10310642servile
servos93812722serv_os
verbals121910742verbals
aerial64625713aerial_
argals75517713_argals
arrivals1145933arrivals
arval86017013_arval_
astrals75515243astr_als
beryls11107883ber_yls
bevels113913983be_vels
borals86721913bor_als
burials93612083burials
carpals113414623carpals
carvels124914593carvels
centals94317053centals
ceramals1246513ceramals
cercal10314123cercal_
cereal8315833cereal_
cerias83321983ceria_s
cervelas1344673cervelas
chervils1644553chervils
coevals1237873coevals
corals85325143cor_als
corrals93713853corrals
craals84113303_craals
curtals93111623curtals
deals65435343de__als
decals93717713de_cals
decrials1137133decrials
denials84114133denials
dentals83915393dentals
deprivals1543533deprivals
derails84216393derails
derats74625063der_ats
derays105514253der_ays
dermal93614343dermal_
dermas94116813derma_s
devas96218883de_va_s
devels104313903de_vels
devils104412813de_vils
dorsals84110843dorsals
equals1538693_equals
eras45441503_er_a_s
ervil8310303_ervil_
espials937093espials
eternals8238953eternals
evils84114263_e_vils
farfals13268503farfals
fecials123510333fecials
feral85424653fer_al_
ferbams1435743ferbams
ferial94621253ferial_
ferias95020393feria_s
ferrels10248623ferrels
ferulas103110753ferulas
fervors1336233fervors
fetials103711743fetials
formals123312893formals
gerahs1039413ger_ahs
gerbils1037303gerbils
germans1079473germans
gorals76917653gor_als
graals74112913_graals
hartals10313023hartals
heals85733453he__als
herald10311343her_ald
heralds1137713her_alds
herbal112513493herbal_
herls85226433her__ls
intervals12810133intervals
kernels11417953kernels
kevels134410713ke_vels
kevils13358333ke_vils
keypals1634353keypals
kraals10378433_kraals
larval948503larval_
larvas9310233larva_s
legals73412733le_gals
lekvars1432693lekvars
lethals1038113lethals
levels94113283le_vels
marvels123810093marvels
meals75933373me__als
medals94218053me_dals
medials103914733medials
menials94015683menials
merls77423903mer__ls
mescals112911553mescals
metals84520883me_tals
mezcals20246533mezcals
morals85324633mor_als
mortals93914003mortals
murals84016753mur_als
narwals1036983narwals
nerols6914883ner_ols
nervate1039523nervate
nerves94216193nerv_es
nervily1336863nervily
nervous1037143nervous
nervule1044943nervule
nervules1145013nervules
normals92510903normals
orals55826483_or_als
ovals85413393__ovals
parrals94414573parrals
peals75235493pe__als
pedals94316033pe_dals
percale11314093percale
percales12313803percales
perhaps1446123perhaps
perils84121853per_ils
persalt9315413persalt
persalts1038193persalts
perusals1047143perusals
pervade1337023pervade
pervades1437353pervades
pervs105117373perv__s
petals84719813pe_tals
portals94015563portals
prevails1337663prevails
reals55038653__reals
reavails1134853reavails
recoals94214623recoals
redials84416883redials
removals1345643removals
rentals74017473rentals
repeals94014523repeals
reprovals1444883reprovals
rereads81512293rereads
rerolls739943rerolls
reseals73917663reseals
retrials8510823retrials
reveals103812723reveals
revels94220573re_vels
revivals1435433revivals
rials55026673__rials
rivals94213183_rivals
sabals84618863s_abals
sacrals93311793sacrals
salals65120083s_alals
sals46851673s___als
sambals115213483sambals
sandals82715203sandals
sarans64224433sar_ans
sardars83112903sardars
sarsars73512143sarsars
scrags95713803scr_ags
scrams105216623scr_ams
scraps106017243scr_aps
scrawls12177273scrawls
screaks13469353screaks
screams114810613screams
scrolls938063scrolls
seabags1037483seabags
seal45654373se__al_
seams75731663se__ams
sears54744913se__ars
seas45755273se__a_s
seats54844343se__ats
seawall1046203seawall
seawalls1145233seawalls
seawans10379943seawans
seaways13307513seaways
seconals1047053seconals
secpars1138413secpars
sedans74816093se_dans
seels55632823se__els
seesaws1034703seesaws
seggars9377783seggars
seidels838393seidels
seitans73312303seitans
selahs9313213se_lahs
sells55134433se__lls
sels46345983se___ls
selva83014273selva__
selvage1136553selvage
selvages1236513selvages
selves94119613selv_es
sendal73314993sendal_
sennas64214233senna_s
sepal77723003se_pal_
sepias83616103sepia_s
septal84513383septal_
sequels1665703sequels
sera46141393ser_a__
serac75925203ser_a_c
serai56830163ser_a_i
serail64222673ser_ail
serape84818413ser_ape
serapes95218103serapes
seraph114011163ser_aph
seraphs12408093seraphs
serdab937833serda_b
sereins73716113sereins
serenes73222903serenes
seres55448893ser__es
serfage1138403serfage
serfages1238233serfages
serfs84922013ser__fs
sergers83815633sergers
serges74225963ser_ges
serialise9912143serialise
serialism11811983serialism
serialist9715113serialist
serially11912843serially
seriate73722473seriate
seriates82620673seriates
series64540973ser_ies
serifs94017053ser_ifs
serines74229543serines
serins64029673ser_ins
serious73616283serious
sermons9311783sermons
serosal7311153serosal_
serosas7312663serosas
serous65023563ser_ous
serovar1046143serova_r
serows96016393ser_ows
serrano768463serrano
serranos857873serranos
serrate73017543serrate
serrates82617023serrates
serries73925353serries
sers45746653ser___s
serumal938783serumal_
serums83916303ser_ums
serve85425963serv__e
served104616813serv_ed
server94917713serv_er
service1239083service
services1338573services
serving113014983serving
servings12249223servings
servo84516683serv__o
setal56430903se_tal_
sevens93813663se_vens
severals1137593severals
severs94121123se_vers
sewans95215903se_wans
sewars94018623se_wars
sextans14349263sextans
sexual1338413sexual_
sheals94420643s_heals
sherpas1238093sherpa_s
shivahs16375723shivahs
shivas124512413shiva_s
shoals94215793s_hoals
shovels13378393shovels
shrills10389933shrills
shrivels14376443shrivels
sials54227243s__ials
sierras737863sierra_s
signals8359163signals
silvans10308333silvans
silvas92912183silva_s
sirdars8228213sirdars
sirrahs10377303sirrahs
sirras63814863sirra_s
sisals63013573s_isals
skoals10438243s_koals
snivels10336903snivels
socials999633socials
soras55041013sor_a_s
sorels63921163sor_els
sorrels7310723sorrels
sovrans1036483sovrans
specials1238033specials
spinals93911863spinals
spirals93212513spirals
spitals93011593spitals
sprags95715823spr_ags
sprats85819933spr_ats
sprawls12176373sprawls
sprays115913643spr_ays
spreads1039763spreads
squeals1636513squeals
steals64020063s_teals
sternal73411913sternal_
sterols7313443ster_ols
straps87721783str_aps
strass67117223str_ass
straws98718673str_aws
strays96417933str_ays
streaks114411273streaks
streams94713373streams
streels73811343streels
strolls739183strolls
surahs94515543sur_ahs
sural55931263sur_al_
suras55336323sur_a_s
surpass938283surpass
surras65919533surra_s
surveils1144523surveils
surveys13357573surveys
survivals1543013survivals
swervers1455213swervers
swerves1377533swerv_es
swivels13396773swivels
sylvans13235893sylvans
sylvas12288173sylva_s
tarsals72512603tarsals
teals56234133te__als
tepals85415043te_pals
terais64023513ter_ais
tercels94110363tercels
tergal72912833tergal_
terras63516973terra_s
tertials8510073tertials
thermals13518533thermals
trials64319883_trials
urials64415193_urials
veals84926193ve__als
verbal112513663verbal_
verglas1137813verglas
vernal93514213vernal_
versal93013753versal_
vervain1335563vervain
vervains1435293vervains
verves124617883verv_es
vervets13419753vervets
vestals104612333vestals
weals85428743we__als
weevils1384683weevils
yerbas11119293yerba_s
zeals145320853ze__als

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.1561145455.1
2DLD Change Limit1340273497.14018771.3
3Display Results3493490.1262769.8
 (SQL Overall)1786913497.42224075.9
 
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.