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

215 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
eschar113652(None) 
escar74011991esc_ar
eschars1237171eschars
char95132152__char
echard1249222e_chard
escarp10449002esc_arp
escars83913132esc_ars
escheat12410402escheat
eschew1436332eschew
escolar946052escolar
eskar9457452es_kar
etcher113912942etcher
scar66434202_sc_ar
schav1338312_schav
secpar1037922secpar
anchor113911973anchor
archer115016243archer
ashcan1135843ashcan
ashlar9338193ashlar
becharm1636843becharm
bedchair1642793bedchair
belcher143511493belcher
bencher144113483bencher
bescour1145203bescour
besmear1134833besmear
car59165563__c_ar
chad105525503__chad
chai95929903__chai
chair105519633__chair
cham115532313__cham
chao95727313__chao
chap114928493__chap
chard116124743__chard
chare105231983__chare
chark144222713__chark
charm126124663__charm
charr104821783__charr
chars105936633__chars
chart105038283__chart
chary135023133__chary
chat95546133__chat
chaw126224633__chaw
chay124924873__chay
cochair1446313cochair
czar156013133__czar
dacha114812573dacha_
dachas124113253dachas
desugar944033desugar
each95530583each__
ear36867883e___ar
echards1337963e_chards
eche97520283e_ch_e
eched116919223e_ched
eches106322163e_ches
echo96615953e_ch_o
echoer114011103e_choer
echos105216463e_chos
echt95722903e_ch_t
eclair836813e_clair
eclat7523603e_clat
eggar7458883e_ggar
either94517423either
embar94011593e_mbar
enchain1248853enchain
enchant12313103enchant
enchase1239453enchase
enchaser1346693enchaser
endear74110013endear
epha9310053e_pha_
ephah1337063e_phah
ephas10311543e_phas
ephor10310013e_phor
epochal1445243epochal
escape103811663escape
escaper11368843escaper
escarps11397373esc_arps
eschalot1346213eschalot
escheator1464143escheator
escheats1346253escheats
eschewal1643133eschewal
eschewer1643163eschewer
eschews1534553eschews
escolars1045343escolars
escort84616483escort
escot75320083esc_ot
escots84211743escots
escrow1135913escrow
escuage1035113escuage
escudo943373escudo
eskars10357593es_kars
esker94412983es_ker
espial839543espial
essay867623es_say
ester54727713es_ter
estral64716513estral
estray95713333estray
estuary1034683estuary
etch95419143etch__
etchant1249813etchant
etched123613703etched
etchers123411293etchers
etches114217763etches
ether84518773e_ther
eucharis1347443eucharis
euchre11137663euchre
eyebar1135323eyebar
fetcher153510393fetcher
ichor1039473_ichor
incher114114033incher
ischia1136393ischia
ischial1246423ischial
isobar836143isobar
isochor1244743isochor
lahar83114263_lahar
lascar868573lasc_ar
leacher124014843leacher
lecher113415853lecher
lochan1139093lochan
mescal104113483mesc_al
mocha1249923mocha_
mochas13310653mochas
nachas114914193nachas
nectar838853nectar
nucha10229793nucha_
nuchae11218513nuchae
nuchal11218873nuchal
ocher104516103_ocher
orchard1346933orchard
osar46820953os__ar
oscular937933oscular
pacha126518063pacha_
pachas135017143pachas
paschal14157243paschal
peacher144216073peacher
pechan13511543pechan
percher143313423percher
pochard1537363pochard
pshaw13447513ps_haw
psywar1443323psywar
reacher123718293reacher
rechart12314323rechart
rescuer939033rescuer
richer114015043richer
scab85926713_sc_ab
scad75725763_sc_ad
scag76626893_sc_ag
scalar83612433_scalar
scam85932353_sc_am
scan65530453_sc_an
scare75334463_sc_are
scarf105427143_sc_arf
scarp95724103_sc_arp
scars75433533_sc_ars
scart76139773_sc_art
scary105222593_sc_ary
scat65848373_sc_at
scaur75814903_scaur
schavs1436493_schavs
schmear1484043_schmear
schmo124510203_schmo
scholar1236943_scholar
schorl1179803_schorl
schul102510413_schul
schwa13426843_schwa
schwas14396983_schwas
scour75315533_scour
scrag85916173_scrag
scram910621613_scram
scrap97120403_scrap
sear47353843_s_ear
secpars1138413secpars
sectary1238273sectary
sector83415923sector
secular92211533secular
seggar8357813seggar
senhor93010803senhor
sewar85421093_sewar
sha69837783_s_ha_
shad86230913_s_had
shag86430563_s_hag
shah105627783_s_hah
sham96436353_s_ham
shard96125963_s_hard
share86437083_s_hare
shark126225023_s_hark
sharn84823703_s_harn
sharp104922533_s_harp
shat76456593_s_hat
shaw108132553_s_haw
shay107133343_s_hay
shear85424833_shear
simar74920813_simar
sitar54820543_sitar
sizar145214993_sizar
smear74416393_smear
soar46838673_s_oar
sofar86115493_sofar
solar55927343_solar
sonar56523423_sonar
sowar85821343_sowar
spar65433303_s_par
spear75821063_spear
star48037763_s_tar
sugar6312913_sugar
swear85316853_swear
teacher123714833teacher
tocher114014913tocher
trochar1257063trochar
tsar47819803ts__ar
unchair1236163unchair
unchary1537263unchary
usher84517763us_her
vicar10513863vic_ar
welcher15319393welcher
wencher153811133wencher

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.1401276364.3
2DLD Change Limit1127162155.65619928.6
3Display Results2152150.0802687.5
 (SQL Overall)1786912155.87630410.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.