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

127 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
serviced143561(None) 
service1239081service_
servicer1335261servicer
services1338571services
cervices1537132cervices
creviced1634452creviced
reserviced1643752reserviced
serifed11811462ser_ifed
serried82513962serri_ed
served104616812serv__ed
servicers1444662servicers
servile10310642servile_
survived1534072survived
aeried74221863aer_i_ed
berimed124912283ber_imed
berried103714043berri_ed
cervical1546853cervical
cervid1239323cervi__d
cervine122610803cervine_
cervixes2054603cervixes
corniced1368593corniced
crevice1436153crevice_
crevices1536713crevices
deiced104214483de__iced
derailed102410403derailed
derided102914253der_ided
derived123912763der_ived
device124512163de_vice_
devices133212583de_vices
deviled124112183de_viled
devised123712563de_vised
devoiced15276063devoiced
enticed101411193_enticed
envied1038833_envi_ed
ermined10410603_ermined
evicted1337243_e_victed
evinced1335403_e_vinced
evited104013143_e_vited
ferried113411523ferri_ed
fervid1337513fervi__d
heroized21298453heroized
herried113514453herri_ed
levied104111433le_vi_ed
merited10313853mer_ited
morticed1377163morticed
nerved104111683nerv__ed
nervier10298833nervi_er
nervine102510623nervine_
nervines112310463nervines
periled10316323per_iled
pervaded1535373pervaded
prevised143611073prevised
priced115018883_pr_iced
rejoiced18296923rejoiced
repriced132610543repriced
reraised9312353reraised
reservice1445263reservice_
reservices1544893reservices
reviled114417923re_viled
revised113815483re_vised
revived144211653re_vived
revoiced14317873revoiced
riced85825543__r_iced
sardined10268663sardined
savvied1433803savvi_ed
scraiched1744203scraiched
scribed124510643scr_ibed
scried95817303scr_i_ed
scrived134511113scr_ived
seduced1186753se_duced
seined74023063se__ined
seised74218123se__ised
seized164313653se__ized
selvaged1334343selvaged
sequined18105653sequined
sered65737293ser___ed
serged84118773ser__ged
seriated92717023seriated
sericin9312843ser_icin
series64540973ser_i_es
seriffed1594973seriffed
serine65432673ser_ine_
serines74229543ser_ines
serrated92513433serrated
serries73925353serri_es
serve85425963serv__e_
server94917713serv__er
serves94423653serv__es
serviceman1751883serviceman
servicemen1752333servicemen
servicing1545343servicing
servilely1543803servilely
serving113014983servi_ng
servings12249223servings
servitor1145063servitor
servitude1343083servitude
severed113513863se_vered
seviche1545113se_viche
seviches1635803se_viches
shrined114112413shr_ined
shrived144712183shr_ived
sliced94416313s__liced
sluiced1046053s_luiced
sortied83314103sorti_ed
spavined1434333spavined
spiced115218313s__piced
spliced124310593s_pliced
sprained1138433sprained
spruced12307533spr_uced
strained9412253strained
striped105214363str_iped
strived114713663str_ived
sufficed17205663sufficed
supervised1646663supervised
surfaced1436063surfaced
surmised1136863surmised
surpliced1444153surpliced
surveyed1544233surveyed
survive1335933survive_
surviver1434683surviver
survives1436333survives
swerved1455703swerv__ed
terraced11318123terraced
triced95518673_tr_iced
vertices13612283vertices
viced115118183___viced
weeviled1533143weeviled

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.423422437.4
2DLD Change Limit1461621278.31317582.3
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.78220347.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.