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

106 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
gestical113899(None) 
aestival1145482aestival
bestial9311642besti_al
deistical1246672deistical
estival1036322_estival
festival1444712festival
genetical1247582genetical
gestic9312772gestic__
gestural946032gestural
gnostical1246202gnostical
hectical1547932hectical
metical11315362me_tical
mystical1546932mystical
rustical1048392rustical
septical1259362septical
vertical13410432vertical
vesical12159812ves_ical
agential958153agenti_al
agentival1353663agentival
agnatical1246163agnatical
bestowal1344513bestowal
biotical1248863biotical
centrical1348353centrical
cervical1546853cervical
cortical12412213cortical
cosmical1448013cosmical
critical12310263critical
deifical1445543deifical
dentinal939503dentinal
despisal1144673despisal
distichal1544833distichal
egoistical1354333egoistical
ekistical1544803ekistical
epical10413393_e_pical
eristical1148433eristical
erotical101911983erotical
espial839543_espi_al
estral64716513_est_ral
estrual7367933_estrual
ethical1238443_ethical
festal94213563fest__al
festivals1543373festivals
fetial95716193fe_ti_al
gastral8329553gast_ral
geminal10109913ge_minal
generical1247003generical
genial74917613ge_ni_al
genital849793ge_nital
genitival1343293genitival
gentian8310103genti_an
gentil74115123genti__l
geodetical1454443geodetical
geoidal936713ge_oidal
georgical1344023georgical
germinal1147263germinal
gestalt8411173gest__alt
gnomical1346683gnomical
haptical1547343haptical
helical12311153he_lical
heretical1448633heretical
heroical13410023heroical
identical1246313identical
jesuitical1952493jesuitical
lenticel1066123lenticel
lexical1637363le_xical
logistical1355043logistical
medical12312513me_dical
mescal104113493mes__cal
mesial84818083mes_i_al
mestiza1835383mestiza_
mestizas1944703mestizas
meticals12310763me_ticals
metrical12311593metrical
musical1139553mus_ical
nautical1057703nautical
optical1149863_optical
poetical12311533poetical
restoral8810983restoral
retial64724993re_ti_al
retinal75318353re_tinal
rusticals1145353rusticals
sceptical1545343sceptical
seismical1344643seismical
sestina72711973sestina_
sestinas8249133sestinas
skeptical1743963skeptical
statical1039423statical
stoical9310283__stoical
tactical1248843tactical
tertial7313863terti_al
testicle1037443testicle
theistical1545133theistical
thetical1349123thetical
tical76021493___tical
vatical1239983_vatical
venatical1446793venatical
verticals1457243verticals
verticil1366913verticil
vesica11157913ves_ica_
vesicae12177703ves_icae
vestal94615573vest__al
vestigial1343773vestigial
vestral104111013vest_ral
vestural1156473vestural
viatical1347063viatical
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.406440125.6
2DLD Change Limit1461621066.65621959.4
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.10825139.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.