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

246 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
services133857(None) 
cervices1537131cervices
service1239091service_
serviced1435611serviced
servicer1335261servicer
servicers1444661servicers
cervixes2054602cervixes
crevices1536722crevices
devices133212582de_vices
nervines112310462nervines
reservices1544892reservices
series64540972ser_i_es
serines74229542ser_ines
serries73925352serri_es
serves94423652serv__es
servile10310642servile_
servings12249222servings
seviches1635802se_viches
survives1436332survives
vertices13612282vertices
advices13136933_advices
aeries64737783aer_i_es
berimes115216643ber_imes
berlines102315453berlines
bernicles1345403bernicles
berries94423553berri_es
bevies114017313be_vi_es
carices114220953car_ices
cercises12410933cercises
cerises94722253cer_ises
cerites94823433cer_ites
cervical1546853cervical
cervine122610803cervine_
ceviches1834843ce_viches
cornices12713303cornices
cortices12615023cortices
crevice1436153crevice_
creviced1634453creviced
deices94119373de__ices
derbies103016053derbi_es
derides93420853der_ides
derives114017813der_ives
dermises112512023dermises
derricks1544433derricks
derries83124623derri_es
derrises93012783derrises
dervishes1644933dervishes
device124512163de_vice_
devises114116763de_vises
devoices14307413devoices
disservices17122993disservices
entices91616333_entices
envies9314053_envi_es
ericas8315463_er_icas
ermines9416673_ermines
ervils948773_ervi_ls
eserines8413743eser_ines
evicts11368563_e_victs
evinces1237803_e_vinces
evites94916483_e_vites
ferlies103216693ferli_es
ferries103521083ferri_es
ferrites112312833ferrites
fornices1369103fornices
heavies132713873heavi_es
helices12313723he_lices
herdics13249523herdic_s
heroics122912003heroic_s
heroines112916573heroines
heroizes202610983heroizes
herries104025083herri_es
jerkies183411583jerki_es
jerries143817513jerri_es
kermises14248313kermises
kernites1269113kernites
kerries113317913kerri_es
levies93919863le_vi_es
merces105720743mer__ces
mercies113817563merci_es
merises93421423mer_ises
mortices12711573mortices
murices112612283mur_ices
nereides938503nereides
nerves94216193nerv__es
nervier10298843nervi_er
nerviest11188833nervi_est
nervine102510633nervine_
nerviness12226873nerviness
nervings12256323nervings
nervules1145013nervules
nervures1135123nervures
novices1238223_novices
orrices9129363_orrices
parvises133911923parvises
peavies122213403peavi_es
pelvics14245643pelvic_s
pelvises1337273pelvises
perlites10316363perlites
perries93226603perri_es
pervades1437353pervades
pervious1337543pervious
previses133814293previses
prices104524543_pr_ices
rejoices17287663rejoices
reprices122913353reprices
reraises8415643reraises
rerises73525883rer_ises
reservice1445273reservice_
reserviced1643753reserviced
reviles104421363re_viles
revises104220543re_vises
revives134715553re_vives
revoices13278993revoices
rices75536153__r_ices
saices84221803s__aices
sardines92815583sardines
savines104417633s_avines
savvies1337603savvi_es
scolices1238733scolices
scraichs1543993scraichs
scribes113713203scr_ibes
scries85226823scr_i_es
scrives124414273scr_ives
scurvies13248123scurvi_es
seances93015343se_ances
seapieces1344123seapieces
seasides938743seasides
secrecies1346923secrecies
seduces1069283se_duces
seiches12513813se__iches
seines65029903se__ines
seises64026713se__ises
seizes154317533se__izes
selkies113513353selki_es
selvages1236513selvages
selves94119613selv__es
semises93916553se_mises
seniles72618023se_niles
septics112810433septic_s
septimes1238303septimes
seracs84418573ser_ac_s
serails73318363serai_ls
serais64326133serai__s
serapes95218103ser_apes
sereins73716123serei_ns
serenes73222903ser_enes
seres55448893ser___es
serfages1238233serfages
serges74225973ser__ges
sergings10299213sergings
serials73919753ser_ials
seriates82620683seriates
sericeous1146343ser_iceous
sericin9312843ser_icin
sericins10312463ser_icins
serifed11811463ser_ifed
serifs94017053ser_i_fs
serine65432673ser_ine_
serins64029673ser_i_ns
serious73616283ser_ious
serotines9312073serotines
serpigoes1243783serpigoes
serpigos1143843serpigos
serrates82617023serrates
serried82513973serri_ed
servals103410753serv_als
servants1138003servants
serve85425963serv__e_
served104616813serv__ed
server94917713serv__er
servers103214833serv_ers
serviceman1751883serviceman
servicemen1752333servicemen
servicing1545343servicing
serviettes1342903serviettes
servilely1543803servilely
serving113014983servi_ng
servitor1145073servitor
servitors1245223servitors
servitudes1443143servitudes
servos93812723serv__os
sestines82717243sestines
setlines8312743setlines
seviche1545113se_viche
sextiles1537643sextiles
sferics1236133sfer_ic_s
shavies134213213shavi_es
sherries111812903sherri_es
sherrises12156873sherrises
shrikes144412393shr_ikes
shrines104618693shr_ines
shrives134416173shr_ives
sices75637273s___ices
silvics1235563silvic_s
skerries12168673skerri_es
slices84022853s__lices
sluices959073s_luices
sordines92414073sordines
sorites73825243sor_ites
sorties74126403sorti_es
spadices1336093spadices
spavies123012953spavi_es
spermines13310543spermines
spices104326033s__pices
splices113914383s_plices
sprites94220333spr_ites
spruces113810503spr_uces
statices102712343statices
sternites9310073sternites
stricks134310693str_icks
strides84520393str_ides
strifes104716583str_ifes
strikes114719093str_ikes
stripes95320573str_ipes
strives104119373str_ives
suffices16208183suffices
supervises1549073supervises
surfaces1338673surfaces
surmises10310643surmises
surplices1346043surplices
survive1335933survive_
survived1534073survived
surviver1434683surviver
survivers1543883survivers
swerves1377533swerv__es
sylvines14215903sylvines
sylvites14225843sylvites
terces83921413ter__ces
tergites9310543tergites
termites10313693termites
terraces102712253terraces
terries73425633terri_es
terrines82117553terrines
trices84826333_tr_ices
varices123313573var_ices
verbiles1338923verbiles
verdicts1446013verdicts
verites103822263ver_ites
verjuices2142563verjuices
vernicles1446133vernicles
vernixes1836053vernixes
versicles1446353versicles
versines112213823versines
verves124617883verv__es
vices105725533___vices
vortices1369133vortices

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622467.04620744.0
3Display Results2462460.1102236.4
 (SQL Overall)1786912467.57623586.5
 
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.