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 “cervical” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
cervical154685(None) 
cercal10314122cer__cal
cervices1537132cervices
clerical1248232cler_ical
cortical12412212cortical
heroical13410022heroical
vertical13410432vertical
aerial64625713aer_i_al
berascal1244853berascal
caracal11312513car_acal
cardinal1139563cardinal
carinal94318233car_inal
carnival1345613carnival
cecal94619113ce___cal
centrical1348353centrical
ceramal1138843cer_amal
cereal8315833cer__eal
cerebral1266183cerebral
ceria75125353cer_i_a_
cerias83321983cer_i_as
ceric94023093cer_ic__
cervelas1344673cervelas
cervelat1345793cervelat
cerveza2142333cerveza_
cervezas2242013cervezas
cervid1239323cervi__d
cervine122610803cervi_ne
cervix1865163cervi__x
cervixes2054603cervixes
ceviche1744143ce_viche
chemical1748393chemical
chervil1534953chervi__l
clericals1345353cler_icals
clinical1247023clinical
comical13312223c_omical
conical11316203c_onical
cordial10312943cordi_al
corrival1346153corrival
corvina12229503corvina_
corvinas13238013corvinas
cosmical1448013cosmical
crevice1436153crevic_e
creviced1634453creviced
crevices1536713crevices
critical12310263critical
crucial1157893c_rucial
cubical1338463c_ubical
curial84019153cur_i_al
cyclical1445653cyclical
cynical1437873c_ynical
deifical1445543deifical
devisal1136913de_visal
epical10413393_e_pical
erica7316543_er_ica_
ericas8315463_er_icas
erotical101911983_erotical
ervil8310303_ervi__l
ethical1238443_ethical
farcical1546953farcical
ferial94621253fer_i_al
fornical1347793fornical
georgical1344023georgical
germinal1147253germinal
gestical1138983gestical
hectical1547933hectical
helical12311153he_lical
heretical1448633heretical
hernial10310433herni_al
icterical1347213icter_ical
irenical1048553irenical
jerrican1794123jerrican
lexical1637363le_xical
lyrical1236493lyr_ical
medical12312513me_dical
metical11315363me_tical
metrical12311593metrical
revisal1038263re_visal
revival1337033re_vival
scenical1247133sce_nical
sceptical1545343sceptical
septical1259363septical
serial64625863ser_i_al
serval93913413serv__al
service1239083servic_e
serviced1435613serviced
servicer1335263servicer
services1338573services
silvical1345223silvical
sterical10311253ster_ical
surgical1146253surgical
survival1443923survival
terminal1039733terminal
tertial7313863terti_al
turrical1046203turrical
veridical1545983veridical
verticals1457243verticals
verticil1366913verticil
vesical12159813ve_sical
vortical1348863vortical

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.250714764.0
2DLD Change Limit146162997.65619091.2
3Display Results99990.0462152.2
 (SQL Overall)178691997.95222471.2
 
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.