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

125 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
servicer133526(None) 
service1239091service_
serviced1435611serviced
servicers1444661servicers
services1338571services
cervices1537132cervices
nervier10298842nervi_er
server94917712serv__er
servile10310642servile_
servitor1145062servitor
surviver1434682surviver
aerier64823163aer_i_er
brevier1237763brevi_er
cervical1546853cervical
cervine122610803cervine_
cervixes2054603cervixes
crevice1436153crevice_
creviced1634453creviced
crevices1536713crevices
curvier123110663curvi_er
deicer94114413de__icer
derider93214973der_ider
deriver114213913der_iver
dernier83011943derni_er
device124512163de_vice_
devices133212583de_vices
deviser114212393de_viser
eerier64320023eer_i_er
enticer91510423_enticer
envier939673_envi_er
eviler94811893_e_viler
fernier103110823ferni_er
germier10309543germi_er
heavier13429423heavi_er
herbier1239593herbi_er
jerkier18407273jerki_er
leavier10319993leavi_er
levier94013873le_vi_er
mercer105214203mer__cer
merrier92612303merri_er
nerdier83110363nerdi_er
nervine102510633nervine_
nervines112310463nervines
perkier133813123perki_er
pervader1444863pervader
pricer103918293_pr_icer
rejoicer17315343rejoicer
reservice1445273reservice_
reserviced1643753reserviced
reservices1544893reservices
reviler104314973re_viler
reviser104114663re_viser
reviver134411373re_viver
ricer74726613__r_icer
sarkier113413313sarki_er
savvier1335483savvi_er
scriber113910973scr_iber
scurvier13255883scurvi_er
seamier93114633seami_er
sedgier9399053sedgi_er
seducer1056503se_ducer
seedier83513633seedi_er
seepier92912013seepi_er
seiner64622483se__iner
seiser65318343se__iser
seizer154114573se__izer
serener73415763ser_ener
serer55935513ser___er
serger73819743ser__ger
sericin9312843ser_icin
series64540973ser_i_es
serifed11811463ser_ifed
serine65432673ser_ine_
serines74229543ser_ines
serried82513973serri_ed
serries73925353serri_es
serve85425963serv__e_
served104616813serv__ed
servers103214833serv__ers
serves94423653serv__es
serviceman1751883serviceman
servicemen1752333servicemen
servicing1545343servicing
servilely1543803servilely
serving113014983servi_ng
servings12249223servings
servitors1245213servitors
sever85426053se_v__er
severer103511563se_verer
seviche1545113se_viche
seviches1635803se_viches
sexier13310683se_xi_er
shelvier1464913shelvi_er
shriver134712193shr_iver
slicer84117603s__licer
sorrier72313733sorri_er
spicer104719313s__picer
splicer114710523s_plicer
sprier84119063spr_i_er
sprucer11317683spr_ucer
sprucier1254793sprucier
strainer8512223strainer
straiter8311783straiter
stricter1039423str_icter
strider84315723str_ider
striker113714173str_iker
striper94514793str_iper
striver104315203str_iver
subvicar1544583subvicar
sufficer16225823sufficer
surfacer1345663surfacer
surfier102613543surfi_er
surlier72915443surli_er
surmiser1036763surmiser
survive1335933survive_
survived1534073survived
survivers1543883survivers
survives1436333survives
survivor1442403survivor
swerver1365733swerv__er
terrier73414963terri_er
verditer1236223verditer
verier94620963ver_i_er
vernier102711273verni_er
vertices13612283vertices

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.440406115.9
2DLD Change Limit1461621258.40317394.0
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.88920102.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.