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

438 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
aslant631775(None) 
alant55742291a_lant
askant10412711askant
slant55238701_slant
ablaut8313262ablaut
alan46844082a_lan_
aland65526412a_land
alane56135612a_lane
alang66023512a_lang
alans55636172a_lans
alants67722022a_lants
arrant6623252arrant
asana5315482as_ana
ascent84519652ascent
ashplant1345412ashplant
assent65119952assent
avant86224662a_vant
callant94121222callant
gallant83517112gallant
gelant72821672gelant
island738532island
passant9813942passant
plant75437112_plant
saltant7316772saltant
savant9416042savant
scant79735072_scant
slang66324022_slang
slank95822772_slank
slants64819082_slants
slanty95114842_slanty
slat46959022_sla_t
volant9316322volant
abaft10318063a_baft
abeyant1248083abeyant
ablate82219213ablate
ablauts936083ablauts
ablaze17239833ablaze
ablest84721833ablest
ablins8316193ablins
abluent939623abluent
absent84016993absent
absonant1047043absonant
abwatt11410673abwatt
accent105116263accent
adamant101110443adamant
adapt81218553a_dapt
adman84517903adman_
advent102613753advent
affiant1348433affiant
aflame1138723aflame
afloat9315153afloat
agent65829643a_gent
aghast105711373aghast
aglare7312433aglare
aglet65534143agl_et
ailing74331013ailing
ailment9314233ailment
ala312463603a_la__
alack114820063a_lack
alae45643753a_la_e
alamo7418143a_lamo
alands75418373a_lands
alanin6317273a_lanin
alanyl955483a_lanyl
alar46340073a_la_r
alarm76621423a_larm
alary86123443a_lary
alas46358123a_la_s
alate55340333a_late
alert54740653a_lert
aline57243153a_line
alist56136783a_list
alit46155693a_l_it
alkane104313323alkane
alkanet113714433alkanet
allanite8411093allanite
allay85620393alla_y
allays94313743allays
allot54933873a_llot
aloft8423433a_loft
alone55732963a_lone
along65419493a_long
alt36467963a_l__t
ambulant1247163ambulant
ament76036543a_ment
amount8414483amount
andante8311273andante
anent54931843a_nent
anlace82513923anlace
anlage72514233anlage
anlas55626933anla_s
anoint6423633anoint
ant37270793___ant
apart74330673a_part
apian75018333apian_
aplenty1237173aplenty
arcana8912583arcana
arcane81216743arcane
ardent73022613ardent
argent74023663argent
arhat8327093arha_t
aroint6328153aroint
aroynt9312893aroynt
arpent84822093arpent
asanas6514113as_anas
ascend9429733ascend
ascents93812553ascents
ascot76522513as_cot
asea46327183asea__
ashcan1135843ashcan_
ashcans1235183ashcans
ashen87818673ashen_
ashing107824093ashing
ashlar9338193ashla_r
ashlars10297063ashlars
ashman1148383ashman_
ashplants1443533ashplants
askance1345923askance
asking116017233asking
asleep847283asleep
aslope839013aslope
aslosh966233aslosh
aspect10612823aspect
aspen75216093aspen_
aspens85013353aspens
asphalt1248083asphalt
aspirant1048863aspirant
asquint16208323asquint
asrama839193asrama
assai5711543assa_i
assail6610153assail
assailant944383assailant
assais6711963assais
assault747413assault
assay8710283assa_y
assays977903assays
assents74512223assents
assert64922583assert
asset55932263as_set
assist6314603assist
assonant846803assonant
assort64916383assort
astony9510523astony
aswarm11107913aswarm
asyla839333asyla__
atlantes838553atlantes
atlas55821583atla_s
atlatl637873atlatl
atman75520143atman_
atmans84413963atmans
attaint7313473attaint
attent62818323attent
aunt46553653a__unt
avast85519363a_vast
avaunt959603avaunt
avian84616053avian_
avians93711563avians
await85524493a_wait
axman144813183axman_
azan136521783a_zan_
azans146516883a_zans
azlon144312873azlon_
azlons154110423azlons
badland1147653badland
ballast9313993ballast
basalt83519583bas_alt
bezant17814543bezant
bland85320453_bland
blank115418553_blank
blast76532573_blast
blat66550953_bla_t
blent76230953_blent
blunt75525023_blunt
brant74742173_brant
byzant2096813byzant
callan83619603callan_
callans94518473callans
callants104112143callants
cant66362033__cant
castanet10416193castanet
chant105932693_chant
clan65633923_clan_
clang86019313_clang
clank114719523_clank
clans75031013_clans
clapt98027173_clapt
clast76030583_clast
coolant9316463coolant
decant93524223decant
descant104315593descant
discant103017263discant
displant11412223displant
distant83519953distant
dopant9316133dopant
eclat7523603ecla_t
elan46734243_elan_
eland65820393_eland
elans55527753_elans
elint55436473_elint
eluant6315093eluant
errant6618733errant
explant16310133explant
extant132714753extant
flan76134183_flan_
flank124618093_flank
flans85327973_flans
flat77147823_fla_t
flaunt9712913_flaunt
flint87333503_flint
gallants93310373gallants
gardant9314463gardant
garland948703garland
gaslit7513503gasl_it
gasman92911743gasman_
gelants82611443gelants
gellant83214053gellant
giant65430593_giant
gland75217713_gland
glans65125833_glans
glint66830183_glint
grant64840023_grant
hant75461593__hant
haplont12412563haplont
haslet93222713hasl_et
implant11311333implant
incant82418513incant
infant92315133infant
inland7310313inland
instant7815353instant
insulant849883insulant
islands837323islands
islet54527553isl_et
isling71213883isling
issuant748263issuant
jessant1438443jessant
jurant134216553jurant
lallan63414183lallan_
lalland83810193lalland
lallans74113543lallans
land56337313__land
lane45153333__lane
lang56637393__lang
lank84734453__lank
last46260323__last
lat37593403__la_t
leant56737783_leant
lent46360533__lent
levant9314493levant
lint416266233__lint
llano5910603_llano
lunt46148843__lunt
meant76537213_meant
misplant12410763misplant
mutant8317693mutant
nascent9610523nascent
natant6318733natant
nauseant845743nauseant
nutant6316383nutant
oblast8613663oblast
octant81216553octant
osculant1046953osculant
pageant10312783pageant
pant66061263__pant
parlante1039693parlante
peasant9314923peas_ant
pedant9319493pedant
pissant91012503pissant
plaint85323203_plaint
plait75631573_plait
plan65833943_plan_
plane74929143_plane
planet84228353_planet
plank115221143_plank
plans75731273_plans
plants84921803_plants
plat66048873_pla_t
pliant83918823pliant
pulsant9310563pulsant
quant143624813_quant
radiant82817133radiant
raglan73711503raglan_
raglans82410133raglans
rampant11312173rampant
rant45864683__rant
recant83228683recant
reland75920433reland
relent64431853relent
reliant7319243reliant
replant93318533replant
riant55833153_riant
saint55147073_saint
salaam8711013salaam
salad65321833sala_d
salads75316963salads
salal55425703sala_l
salals65120083salals
salami8313103salami
salary9515213salary
salient7419763salient
salina64221123salina
saline65132703saline
sallet63734543sallet
salon55228553salon_
salons63823693salons
salt45758523_s_alt
sand55338473_s_and
sane45954343_s_ane
sang55441243_s_ang
sank85236833_s_ank
sans45153363_s_ans
santo56227283_s_anto
saran53730303saran_
sarans64224433sarans
sat36288483_s_a_t
satang75711563satang
savants1038653savants
scan65530453_scan_
scans74625103_scans
scants85219723_scants
scanty114014663_scanty
scart76139773_scart
scat65848373_sca_t
scatt76030093_scatt
scent75831623_scent
sealant73118303sealant
seat47575563_sea_t
secant84023293secant
sejant133114483sejant
sent46963013_s_ent
shaft115725273_shaft
shalt85534493_shalt
shank125422193_shank
shanti94014093_shanti
shanty124715123_shanty
shat76456603_sha_t
shent85933503_shent
shunt85226513_shunt
silane62718053silane
silent64125843silent
skank84415583_skank
skat87037903_ska_t
skint95629223_skint
sklent103614353sklent
slab67133763_sla_b
slabs75322643_slabs
slack115021763_slack
slag55934353_sla_g
slags66525903_slags
slain54923573_slain
slainte738543_slainte
slake93724053_slake
slam67737973_sla_m
slams74927903_slams
slangs75615343_slangs
slangy105411393_slangy
slanted83514743_slanted
slantly10399323_slantly
slap66434043_sla_p
slaps76025713_slaps
slash84719683_slash
slate55438283_slate
slats55436903_slats
slaty86523153_slaty
slave84224033_slave
slaw77930713_sla_w
slaws85222713_slaws
slay76436383_sla_y
slays85723683_slays
sleet55639133_sleet
slept75728103_slept
sling66028803_sling
slink95422913_slink
slipt76627483_slipt
slit46250103_sl_it
slot46049833_sl_ot
slung65117833_slung
slunk95016303_slunk
slut45040593_sl_ut
smalt74729333_smalt
smart75834093_smart
solan55328153solan_
soland75115043soland
solano65314183solano
solans64122493solans
sonant6621953sonant
spait75631603_spait
span65234663_span_
spang84919733_spang
spank115919573_spank
spans74528733_spans
spat66548523_spa_t
spent75532833_spent
splat76129343spla_t
splent84720193splent
splint85223283splint
stand65923283_stand
stane55933003_stane
stang66424693_stang
stank95823303_stank
start55642313_start
stat47352693_sta_t
stent55634513_stent
stint57037663_stint
stunt55328173_stunt
suint55638183_suint
swan76631313_swan_
swang95519723_swang
swank125318233_swank
swans84625013_swans
swart86234643_swart
swat77244443_swa_t
taggant9310223taggant
talent6323323talent
tenant6322473tenant
tolan55124013tolan_
tolane64316583tolane
tolans64319273tolans
truant6315783truant
tyrant9315333tyrant
uhlan849113uhlan_
uhlans937573uhlans
ulan46527393_ulan_
ulans54921303_ulans
ululant747693ululant
umlaut838033umlaut
upland938863upland
vacant11415133vacant
vagrant11410663vagrant
valiant10314623valiant
variant10316803variant
volante1038513volante
want76156173__want
warrant10614243warrant
waxplant20144603waxplant
xylan1537463xylan_
xylans1635883xylans
yulan8411493yulan_
yulans958673yulans

Search took 7 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.376475242.0
2DLD Change Limit1127164385.70319764.3
3Display Results4384380.1403128.6
 (SQL Overall)1786914386.21928733.1
 
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.