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

232 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
umbral103863(None) 
umbra948511umbra_
umbrae1038681umbrae
umbras1038641umbras
adumbral1342342adumbral
amoral8314632amoral
humeral1238572humeral
humoral1237982humoral
jumbal1758462jumb_al
moral75533432_moral
mural75225112_mural
numeral939082numeral
timbral11237192timbral
tumbrel11406852tumbrel
tumbril11256402tumbril
tumoral938132tumoral
umbel93612842umb_el
umbonal1144382umbonal
umbrage1236722umbrage
unmoral948692unmoral
aboral8314373aboral
admiral1046363admiral
ambari103012173ambari
ambary134010543ambary
ambry123512103ambr_y
amtrac10109133amtrac
antral65719413antral
anural65714743anural
astral66919283astral
augural856403augural
aural54428963_aural
auroral7310473auroral
austral73411513austral
baal67033113__baal
bal56662723__b_al
barbal104016673barbal
bharal1138893bharal
boral75831703_boral
bra56339463__bra_
brad75234343__brad
brae65639113__brae
brag75229723__brag
brail75525553__brail
bran65740383__bran
bras65746453__bras
brat66055543__brat
braw94829563__braw
brawl106217963__brawl
bray95232903__bray
bubal94218213bub_al
bumboat1349023bumboat
butyral1245713butyral
cabal95222153cab_al
cambial134010763cambial
cameral11311283cameral
chiral114614413chiral
choral115118493choral
citral81113893citral
cobra95214403cobra_
cobras104014193cobras
coral76033453_coral
corral83616253corral
crural8610633crural
cumbia12379893cumbia_
cumbias13338963cumbias
cymbal15236913cymb_al
dobra85013103dobra_
dobras94811913dobras
dural64923893_dural
embalm1236653emb_alm
embar94011603emb_ar
embark14458523embark
embars103812883embars
embay123410603emb_ay
embrace1388893embrace
embroil1146613embroil
embrue1036533embrue
embryo1363963embryo
emerald1046923emerald
estral64716513estral
femoral1238723femoral
feral85424653_feral
fibril1137163fibril
fimbrial1544193fimbrial
floral94313813floral
funeral1037623funeral
futural1037283futural
gambrel1235453gambrel
gimbal11228813gimb_al
gomeral1038843gomeral
gooral7310463gooral
goral65125753_goral
gumball1266833gumball
gumboil1244373gumboil
gyral94412783_gyral
herbal112513493herbal
horal86328683_horal
humerals1347183humerals
imbalm1246323imb_alm
imbark14347863imbark
imbrue1035153imbrue
immoral1146783immoral
jumbals18106533jumb_als
jural125120483_jural
labial84714343labial
labra75415463labra_
liberal9310193liberal
libra74712423libra_
librae84310173librae
libras83711703libras
loral55927823_loral
lumbar103610593lumb_ar
lumbars11289763lumbars
lumbrical15113383lumbrical
lumenal9307273lumenal
luminal93711003luminal
lustral7339653lustral
mara67444583_mara_
maras75443303_maras
marl66341623_mar_l
mbira977973_mbira_
mbiras1077153_mbiras
meal65643173_m_eal
medal86221333_medal
merl65830973_mer_l
metal75427383_metal
mitral81314323mitral
modal85919243_modal
molal75120343_molal
mora66641273_mora_
morae75831193_morae
morale85220553_morale
morals85324643_morals
moras76438783_moras
moray105423793_moray
morel75729093_morel
mortal84616853_mortal
mudra83912433mudra_
mudras94212263mudras
mughal1236273mughal
mura65633303_mura_
murals84016763_murals
muras75329583_muras
murra74519083murra_
murras84916013murras
mutual838503mutual
neural6311993neural
nombril1145103nombril
numbat10312083numb_at
numerals1047343numerals
ombre94111803ombr_e
ombres103911143ombres
oral47638123__oral
outbrag1036993outbrag
outbrawl1344823outbrawl
parral85517543parral
penumbral1552653penumbral
pibal95217323pib_al
plural839823plural
puberal1147773puberal
retral64419743retral
ruderal837373ruderal
rumba93612513rumb_a_
rumbas102512013rumb_as
ruminal9289993ruminal
rural55821173_rural
sabal75422483sab_al
sabra75317853sabra_
sabras85116363sabras
sacral83414413sacral
sambal105215183samb_al
seral56336383_seral
spiral83715343spiral
sporal82915453sporal
suboral92011993suboral
sudoral8148543sudoral
sural55931263_sural
sutural7310223sutural
tibial849843tibial
timbal102510753timb_al
timbrel11306563timbrel
tombal102311023tomb_al
tubal75517203tub_al
tumbrels12285733tumbrels
tumbrils12255373tumbrils
tymbal13236823tymb_al
ultra539363ultra_
ultras6310193ultras
umbels104510593umbels
umber94617593umb_er
umbered121510113umbered
umbers104215213umbers
umbles103817493umbles
umbo85516663umb__o
umbos94613073umb_os
umbrages1336623umbrages
umbrella1243273umbrella
umiac938963um_iac
umiak1137673um_iak
umiaq1656823um_iaq
unbale83616403unb_ale
unban72114333unb_an
unbar71913613unb_ar
unbars82113033unbars
unbear889163unbear
unbrace111910493unbrace
unbraid1037183unbraid
unbrake13239123unbrake
unbred92613303unbred
uncial83715223uncial
undraw1037813undraw
ungual738183ungual
unreal64414453unreal
unseal63315473unseal
unwrap11126323unwrap
upbear1096493upbear
upbeat10911513upbeat
upboil1096453upboil
upbraid1244973upbraid
urban72013863urb_an
urbia7311143urbia_
urbias839093urbias
ureal56722683u_real
urial54823023u_rial
urinal6614123urinal
usual5310183u_sual
uveal84411073u_veal
uxorial1446323uxorial
verbal112513663verbal
viral86419593_viral
zebra1637883zebra_
zebras1737853zebras

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162324.90622975.1
3Display Results2322320.0802900.0
 (SQL Overall)1786912325.37633238.7
 
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.