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

423 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
tenails7371392(None) 
renails74917261renails
tenail64516111tenail_
toenails847211toenails
trenails869841trenails
agnails837002agnails
bewails1277552bewails
denials84114132denials
dentils84115582dentils
derails84216392derails
details84214042details
emails84412342_emails
entails7912822_entails
jezails2334162jezails
lentils73912972lentils
menials94015692menials
nails55730402__nails
pencils113011772pencils
pensils92811592pensils
remails94714562remails
renail65020762renail_
resails74616742resails
retails74718972retails
serails73318362serails
snails64816652_snails
stencils1046402stencils
tails55634192t__ails
teals56234132te_a_ls
tenable93214492tenable
tenably122210452tenably
tenaces92814512tenaces
tenaille846812tenaille
tenailles946322tenailles
tenants7311012tenants
tendrils946442tendrils
tenias64720072ten_ias
tennies73017972tennies
tennis64015302tenni_s
tenpins9410072tenpins
tensile72612732tensile
tenuis64213082tenui_s
tepals85415042tepa_ls
terais64023512terai_s
toenail738782toenail_
tonsils7310182tonsils
trails64622512t_rails
treenails945562treenails
trenail7410812trenail_
unnails738222unnails
utensils8124962utensils
ventails1139822ventails
aerials74017553aerials
agnail739533agnail_
ails45654723___ails
anils56326723_an_ils
annals66415923anna_ls
anvils9219713_anvils
assails769093assails
avails939693_avails
aventails1244993aventails
bails75933523__bails
beanies93821093beanies
bedrails1136293bedrails
befalls12349123befalls
begalls10319163begalls
benames112814603benames
bennies93917313bennies
bennis84314803benni_s
benzins1838693benzins
benzols1836673benzols
benzyls2133673benzyls
bewail1189583bewail_
bezils1711310603be_zils
brails84621293_brails
camails11311753camails
canals84421673cana_ls
ceils75019403ce__ils
cenacle1139123cenacle
cenacles1238023cenacles
centals94317053centals
centile94217183centile
centiles103615813centiles
deairs74013783de_airs
deals65435343de_a_ls
decals93717713deca_ls
deils65722863de__ils
denarius948813denarius
denars74621433dena_rs
denial74720513denial_
denies74729643den_ies
denims95214323den_ims
dentals83915393dentals
dentil74017883dentil_
dentins83419223dentins
derail74218813derail_
detail74516433detail_
detains83716093detains
devils104412813de_vils
drails74716953_drails
earls56127513_e_arls
elains64919853_elains
email74715103_email_
enable83318483_enable
enables92813123_enables
enacts84012973_enacts
enamels9128163_enamels
enates64026433_enates
engild8107613_engild
engilds974863_engilds
engrails945383_engrails
enols54718403_en_ols
enrols61213383_enrols
ensile62616473_ensile
ensiles72714833_ensiles
entail61114343_entail_
entoils7810733_entoils
entrails8310163_entrails
envies9314053_envies
ervils948773_ervils
eternals8238953eterna_ls
etnas54713933etna__s
evils84114263_e_vils
fails85631483__fails
fantails1139693fantails
fecials123510333fecials
fenagle11197153fenagle
fenagles12186083fenagles
fennels10387903fennels
ferals94216643fera_ls
fetials103711743fetials
finalis103313663finalis
finals94316163fina_ls
finials103210153finials
flails94313003_flails
frails93716473_frails
genial74917613genial_
genies75324943gen_ies
genips9469943gen_ips
genius74512923gen_ius
gentil74115123gentil_
gentile83515293gentile
gentiles93713523gentiles
gerbils1037303gerbils
gnarls74210773_gnarls
grails77518783_grails
hails85231643__hails
heals85733463he_a_ls
heils85222193he__ils
henbits12177003henbits
henries102718283henries
hobnails1343303hobnails
jails125422943__jails
jennies143511623jennies
jezail2234643jezail_
kails95525223__kails
kenafs1337113kena_fs
kennels11387193kennels
kevils13358333ke_vils
lanais6316793lanai_s
legals73412733lega_ls
lenis56326863len_i_s
lentil64315393lentil_
mails76037783__mails
meals75933383me_a_ls
meanies93620743meanies
medals94218063meda_ls
medials103914743medials
menaces112715523menaces
menads95514383mena_ds
menages103615393menages
menhirs1235913menhirs
menial84223033menial_
metals84520893meta_ls
naifs87617423__naifs
nail45838653__nail_
nils46132463__n_ils
noils55024333__noils
oxtails1436383oxtails
pails75833063__pails
peals75235493pe_a_ls
pearls84715393pe_arls
pedals94316033peda_ls
penal75228373pena_l_
penalise101013763penalise
penally121111773penally
penangs10268373penangs
penates93321603penates
pencels113610063pencels
pencil103712973pencil_
penial84120893penial_
penicils1247863penicils
penile82219603pen_ile
penis75129323pen_i_s
pennies94218813pennies
pennis84315743penni_s
pensil83013333pensil_
pensile92713543pensile
pentyls1236523pentyls
perils84121853pe_rils
petals84719813peta_ls
pintails10310163pintails
pontils9312213pontils
prevails1337663prevails
quails153412643_quails
rails55937403__rails
reals55038653re_a_ls
reavails1134853reavails
rebaits9312573rebaits
reboils94111723reboils
recalls92613623recalls
recoils93814873recoils
redials84416883redials
redtails968003redtails
refalls103312243refalls
regains84316583regains
remail85017123remail_
remains94117913remains
renailed92512803renailed
renal55929513rena_l_
renames92418053renames
renigs74314593ren_igs
renins64526453ren_ins
rennins74013413rennins
rentals74017483rentals
reoils64516873re_oils
repairs9319973repairs
resail64418733resail_
retail65522073retail_
retains74522253retains
sails55738103__sails
seals54839703se_a_ls
senarius8310103senarius
senates73322613senates
sendals81912273sendals
senile63420213sen_ile
seniles72618023sen_iles
sennits73811283sennits
sepals85217383sepa_ls
serail64222673serail_
serais64326133serai_s
serials73919753serials
snail57020203_snail_
snarls64016873_snarls
spails84817823_spails
steals64020063ste_a_ls
stencil946893stencil_
stunsails942883stunsails
swails94913123_swails
taels56822073t__aels
taenias7311283taen_ias
tahsils1035053tahsils
tail45443653t__ail_
tains54936323t__ains
talls55133433t__alls
tamals84116633tama_ls
tannins72813223tannins
tansies74521243tansies
teaks94222903te_a_ks
teal45546503te_a_l_
teams75726513te_a_ms
tearily10311153tearily
tears55436463te_a_rs
teas45851493te_a__s
teasels74311313teasels
teases65426273te_ases
teats55636813te_a_ts
teazels16406893teazels
teazle15329553te_azle
teazles16308923te_azles
techies12513603techies
techily1537123techily
teddies92711283teddies
teels55726373te__els
teiids736693te_iids
tekkies1035943tekkies
telial65815363telial_
tellies73820513tellies
tells55828943te__lls
tels46841693te___ls
tenace82715693tena_ce
tenacious1146423tenacious
tenacity1347113tenacity
tenacula1044493tenacula
tenancies1149173tenancies
tenancy1237503tenancy
tenant6322473tena_nt
tenches123515523tenches
tenders83719723tenders
tending94419163tending
tendons8311473tendons
tendril836783tendril_
tends65425583ten__ds
tendus75111183ten_dus
tenets65518953ten_ets
tenfold1145713tenfold
tenfolds1244413tenfolds
tenia55324483ten_i_a
teniae64517353ten_iae
teniases838623teniases
teniasis846063teniasis
tenners74014923tenners
tennises82810133tennises
tennist72813113tennist
tennists8297793tennists
tenons62916603ten_ons
tenors63217753ten_ors
tenours72610073tenours
tenpin8310583tenpi_n
tenrecs936033tenrecs
tens45647413ten___s
tensely1037363tensely
tenses64722553ten_ses
tensible1037243tensible
tensibly1345143tensibly
tensing84616653tensing
tension7311803tension
tensions8310223tensions
tensity1039103tensity
tensive10269913tensive
tensors72712373tensors
tentacle1037693tentacle
tentacles1146713tentacles
tentages91011043tentages
tenters73921113tenters
tenthly1335743tenthly
tenths94412663ten_ths
tentie62521183tenti_e
tentier73815923tentier
tentiest82115613tentiest
tenting84621153tenting
tents56434213ten__ts
tenues63816443ten_ues
tenuity1037453tenuity
tenuous738483tenuous
tenures7412013tenures
tenutos736623tenutos
tepal76319583tepa_l_
tepas76521683tepa__s
tequila1644583tequila
tequilas1743283tequilas
terai53525483terai__
terbias9310743terbias
tercels94110363tercels
ternaries9311643ternaries
terrains8410323terrains
terries73425633terries
territs72714503territs
tertials8510073tertials
testily102910803testily
testis64916713testi_s
tetanics10127373tetanics
tetanies8513553tetanies
tetanus737933tetanus
tetris62816293tetri_s
tetryls1034643tetryls
texas126514933texa__s
texases1437573texases
textile1437223textile
textiles1536833textiles
thenages12107483thenages
thenal92712433thena_l_
thenars10248523thena_rs
thralls10299043thralls
ticals83214713tica_ls
tils45739623t___ils
tincals93610653tincals
tineids8337873tineids
tinfoils1144323tinfoils
tinfuls1036593tinfuls
tinily94014433tin_ily
tinnily1047363tinnily
tinsels738373tinsels
toenailed1043483toenailed
toils54527493t__oils
tonal53724303tona_l_
tonally10311373tonally
tonics83617863ton_ics
tonsil6311873tonsil_
topsails1075093topsails
totals63115163tota_ls
traiks104013713t_raiks
trail55126773t_rail_
trains64725343t_rains
traits65121983t_raits
travails1146083travails
trawls94412393t_rawls
treenail846123treenail_
trefoils1145303trefoils
trendies9312213trendies
trendily1256443trendily
trials64319883tria_ls
trysails1144163trysails
tunable92511313tunable
tunably12218293tunably
tunas54224123tuna__s
tunics83811263tun_ics
tunnels7328723tunnels
tunnies73614263tunnies
twains95811183t_wains
twenties1137503twenties
twibils1253113twibils
unais53420773_unai_s
unnail6410583unnail_
utensil7125213utensil_
vails85825933__vails
veals84926193ve_a_ls
veils84918803ve__ils
venal85523213vena_l_
venally13119563venally
venial94218283venial_
venins93816703ven_ins
ventail10310453ventail_
vexils1647173ve_xils
vinals94716483vina_ls
wails86631483__wails
weals85428743we_a_ls
weevils1384683weevils
xenial133414903xenial_
xenias133712973xen_ias
zeals145320853ze_a_ls
zenaida17914783zenaida
zenaidas18513663zenaidas
zenanas16286233zenanas

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 Limit1340274236.59320328.7
3Display Results4234230.1403021.4
 (SQL Overall)1786914237.13925030.3
 
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.