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

216 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
lethals103811(None) 
lethal939801lethal_
bethels1238532bethels
ethyls1235902_ethyls
fetials103711742fetials
legals73412732le_gals
lethally1445922lethally
lethes94818082leth_es
metals84520882met_als
methyls1535452methyls
petals84719812pet_als
abettals1054723abettals
acetals93411353acet_als
aerials74017553aerials
aethers103614943aethers
anethols1145843anethols
astrals75515243astrals
bechalk1845803bechalk
bechalks1944793bechalks
behalf14310953be_half
benthal1247953benthal_
berthas12398763bertha_s
betas75528763bet_a_s
betels84515063bet_els
bethank1666273bethank
bethanks1765313bethanks
bethel1169643bethel_
beths105519223beth__s
betrays12127823betrays
bettas84913923betta_s
blethers13429613blethers
buttals938503buttals
centals94317053centals
centrals102712033centrals
cereals9313173cereals
citrals91111673citrals
deals65435343de__als
decals93717713de_cals
denials84114133denials
dentals83915393dentals
details84214043details
dhals95415443__dhals
enhalo987563_enhalo
enhalos1087533_enhalos
enthrals11278903enthrals
ephahs1435503_ephahs
ephas10311543_epha_s
equals1538693_equals
etas46432273_et_a_s
ethane94613243_ethane
ethanes103713513_ethanes
ethanols1144333_ethanols
ethers94518413_ethers
ethicals1345533_ethicals
ethics11169283_ethics
ethnos947053_ethnos
ethos85514193_eth_os
eths76619523_eth__s
ethyl1136513_ethyl_
etnas54713933_etna_s
exhale1636873_exhale
exhales1737143_exhales
fecials123510333fecials
ferals94216643fe_rals
fetal85623373fet_al_
fetas85624403fet_a_s
fetial95716193fetial_
fetiales11319613fetiales
fetialis11358663fetialis
getas65421483get_a_s
heals85733453he__als
heehaws1643343heehaws
herbals122710603herbals
heths116317783heth__s
hetmans12187593hetmans
inthrals11258503inthrals
jehads1735833je_hads
jetlags1533863jetlags
jetsams16124103jetsams
jetways2094053jetways
ketols104210763ket_ols
keypals1634353keypals
labials9299873labials
lacteals1095663lacteals
lahars94013163l_ahars
laterals8312753laterals
lathers104321883lathers
lathes95127503lath_es
lathis95516173lath_is
laths86022403lath__s
leads66028493le__ads
leafs85721183le__afs
leaks95923913le__aks
leal46043273le__al_
leans55536253le__ans
leaps75522933le__aps
lears55938733le__ars
leas45954183le__a_s
leathers114215083leathers
lechers123313963lechers
leches115421313lech_es
lechwes1535063lechwes
leeways1354453leeways
legal65715943le_gal_
lehrs86111133le_h_rs
lehuas935943le_huas
lekvars1432693lekvars
lemans85316393le_mans
lemmas10349163lemma_s
lentils73912973lentils
letches124015483letches
lethality1545113lethality
lethargy1542203lethargy
lethe85717303leth__e
lethean1037093lethean
lets47147943let___s
letters73819853letters
letups8317683let_ups
levels94113283le_vels
litas54923773lit_a_s
literals8312293literals
lithely1356643lithely
lithias1038823lithias
lithops12307253lithops
lithos94212553lith_os
locals83714503l_ocals
lochans1248833lochans
lotahs9479873lot_ahs
lotas55926303lot_a_s
luteal64411483luteal_
lyttas985073lytta_s
meals75933373me__als
medals94218053me_dals
medials103914733medials
menials94015683menials
menthols1347043menthols
mescals112911563mescals
metal75427383met_al_
methane123211793methane
methanes133812163methanes
methanols1444873methanols
methods1338893methods
meths105320233meth__s
methyl1436403methyl_
methylals1743683methylals
meticals12310763meticals
metols84115773met_ols
mezcals20246533mezcals
mughals1355763mughals
mutuals937123mutuals
neutrals846283neutrals
nuchals12216933nuchals
outhauls1137223outhauls
peals75235493pe__als
pechans14810503pechans
pedals94316033pe_dals
perhaps1446123perhaps
petal76526893pet_al_
petnaps1145033petnaps
petrale9312623petrale
petrales10312983petrales
petrels9279373petrels
petrols92913083petrols
petsais938433petsais
peytrals1355493peytrals
quetzals2642583quetzals
ratals64219583rat_als
reals55038653re__als
recoals94214623recoals
redials84416883redials
rehabs1139023re_habs
rentals74017473rentals
repeals94014523repeals
reseals73917663reseals
retags73414303ret_ags
retails74718973retails
reteams9339563reteams
retears72814923retears
retells73211523retells
retial64724993retial_
retinals85612963retinals
retools73411023retools
retotals838463retotals
retral64419743retral_
retrials8510823retrials
reveals103812723reveals
rituals738353rituals
seals54839693se__als
sendals81912263sendals
sepals85217373se_pals
serials73919743serials
servals103410743servals
setal56430903set_al_
steals64020063_steals
teals56234133__teals
tepals85415043te_pals
tertials8510073tertials
tethers103815313tethers
teths85418513teth__s
tetrads82910193tetrads
tetras63017623tetra_s
tetryls1034643tetryls
thaws116515463__thaws
totals63115163tot_als
unlethal1143623unlethal_
urethans1145243urethans
veals84926193ve__als
ventrals112910003ventrals
verbals121910743verbals
vestals104612333vestals
vitals94514303vit_als
weals85428743we__als
wethers135214693wethers
withal1238933withal_
zeals145320853ze__als
zetas145018163zet_a_s

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 Limit1340272166.67320085.0
3Display Results2162160.0633428.6
 (SQL Overall)1786912167.14225019.7
 
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.