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

149 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
benthal124796(None) 
benthic1437472benthic
benthon1237692benthon
benthos1238372benthos
benzal1739642ben_zal
bertha11429172bertha_
berthas12398762berthas
bestial9311642bestial
bethel1169642be_thel
canthal12410052canthal
cental84420962cent_al
central93114472central
dental74319172dent_al
enthral103410932_enthral
lethal939802le_thal
mental84521602ment_al
menthol1236732menthol
rental63922032rent_al
ventral103612172ventral
zenithal2093342zenithal
abettal946073abe_ttal
agential958153agential
anethol1045383anethol
antral65719413_antral
banal75925993ban__al
bantam10314063bant_am
bathyal1544823b_athyal
bechalk1845813be_chalk
behalf14310953be__half
beltway1564373beltway
bench125619503bench__
benched154713943benched
bencher144113483bencher
benches143918603benches
benday123810813ben_day
benomyl1443453benomyl
bent67759913bent___
benthons1337973benthons
bento75922953bent__o
bentos86218313bent_os
bents76033693bent__s
benzol1756993ben_zol
benzoyl2143363benzoyl
benzyl2034163ben_zyl
berth104917883berth__
berthed13259123berthed
berths114712423berth_s
bestead10389123bestead
bestowal1344513bestowal
beta66234133be_t_a_
betas75528763be_t_as
betel74419903be_t_el
beth96629233be_th__
bethank1666273be_thank
bethels1238533be_thels
beths105519223be_th_s
betray111511443be_tray
betrothal1453473betrothal
betta74916843be_tta_
bettas84913923be_ttas
bidental1146593bident_al
biennial1065103biennial
binal75323823bin__al
brothel12318193brothel
brutal859383brut_al
burghal1335073burghal
cantal84122033cant_al
censual937663censual
centai84814783cent_ai
centals94317053cent_als
centas85020703cent_as
centra84113883centra_
centrals102712033centrals
conchal144211593conchal
denial74720513den_ial
dentals83915393dent_als
dentil74017883dent_il
dentinal939503dentinal
dentural948083dentural
dextral1577003dextral
enhalo987573_en_halo
entail61114343_entail
enteral73516453_enteral
enthalpy1642563_enthalpy
enthrall11266833_enthrall
enthrals11278903_enthrals
entia5318203_entia_
entoil6912493_entoil
entrap8710563_entrap
estral64716513_estral
ethyl1136513_e_thyl
eventual1144883eventual
festal94213563fest_al
fetal85623373fe_t_al
fetial95716193fe_tial
fontal9313143font_al
general81010943general
genial74917613gen_ial
genital849793genital
genteel836753genteel
gentian8310103gentian
gentil74115123gent_il
gnathal1144353gnathal
inthral10249463_inthral
lentil64315393lent_il
lethals1038113le_thals
meatal84114733meat_al
menial84223033men_ial
mensal84615663men_sal
menta74424423ment_a_
menthols1347043menthols
metal75427383me_t_al
methyl1436403me_thyl
neutral737923neutral
omental93210423oment_al
penal75228373pen__al
penial84120893pen_ial
pentad9313763pent_ad
pentyl1138813pent_yl
petal76526893pe_t_al
peytral1287503peytral
rectal84418143rect_al
renal55929513ren__al
renewal1038713renewal
rentals74017483rent_als
retial64724993re_tial
retral64419743re_tral
sendal73314993sen_dal
sensual738053sensual
septal84513383sept_al
setal56430903se_t_al
spathal1236263spathal
tectal83713253tect_al
tenth85421833tenth__
tenthly1335743tenthly
tenths94412663tenth_s
tertial7313863tertial
textual1444603textual
venal85523213ven__al
venial94218283ven_ial
ventail10310453ventail
ventrals112910003ventrals
vestal94615573vest_al
vestral104111013vestral
withal1238933_withal
xanthan1736013xanthan
xenial133414903xen_ial
yenta83917043yent_a_
yentas94614213yent_as

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271496.68620045.9
3Display Results1491490.0463239.1
 (SQL Overall)1786911497.13825033.8
 
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.