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

291 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
askant1041271(None) 
aslant6317751aslant
alant55742292a_lant
alkane104313322alkane
alkanet113714432alkanet
arrant6623252arrant
asana5315482as_ana
ascent84519652ascent
askance1345922askance
asking116017232asking
assent65119952assent
avant86224662a_vant
passant9813942passant
savant9416042savant
scant79735072_scant
skank84415582_skank
skat87037902_ska_t
skint95629222_skint
slant55238702_slant
abaft10318063a_baft
abeyant1248083abeyant
ablaut8313263ablaut
absent84016993absent
absonant1047043absonant
abwatt11410673abwatt
accent105116263accent
adamant101110443adamant
adapt81218553a_dapt
adman84517903adman_
advent102613753advent
affiant1348433affiant
agent65829643a_gent
aghast105711373aghast
akene95818663a_kene
akin86328033a_kin_
alan46844083a_lan_
aland65526413a_land
alane56135613a_lane
alang66023513a_lang
alans55636173a_lans
alants67722023a_lants
alkali10127563alkali
alkanes113812933alkanes
alkanets12366233alkanets
alkene104114003alkene
alkine104916803alkine
alkyne13436863alkyne
ament76036543a_ment
amount8414483amount
andante8311273andante
anent54931843a_nent
anklet105618733anklet
anoint6423633anoint
ant37270793___ant
apart74330673a_part
apian75018333apian_
arcana8912583arcana
arcane81216743arcane
ardent73022613ardent
argent74023663argent
arhat8327093arha_t
aroint6328153aroint
aroynt9312893aroynt
arpent84822093arpent
asanas6514113as_anas
ascend9429733ascend
ascents93812553ascents
ascot76522513as_cot
asea46327183asea__
ashcan1135843ashcan_
ashcans1235183ashcans
ashen87818673ashen_
ashing107824093ashing
ashman1148383ashman_
ashplant1345413ashplant
ask77130703ask___
asked106919313ask_ed
asker96418783ask_er
askers105915403askers
askew12529413ask_ew
askings12519173askings
askoi9507803ask_oi
askos95011773ask_os
asks85721213ask__s
aspect10612823aspect
aspen75216093aspen_
aspens85013353aspens
asphalt1248083asphalt
aspirant1048863aspirant
asquint16208323asquint
asrama839193asrama
assai5711543assa_i
assail6610153assail
assais6711963assais
assault747413assault
assay8710283assa_y
assays977903assays
assents74512223assents
assert64922583assert
asset55932263as_set
assist6314603assist
assonant846803assonant
assort64916383assort
astony9510523astony
aswarm11107913aswarm
atman75520143atman_
atmans84413963atmans
attaint7313473attaint
attent62818323attent
auklet104216833auklet
aunt46553653a__unt
avast85519363a_vast
avaunt959603avaunt
avian84616053avian_
avians93711563avians
await85524493a_wait
axman144813183axman_
azan136521783a_zan_
azans146516883a_zans
basalt83519583bas_alt
basket125722913bask_et
basking144718613basking
bezant17814543bezant
brant74742173_brant
byzant2096813byzant
callant94121223callant
cant66362033__cant
casket124820993cask_et
casking144317353casking
castanet10416193castanet
chant105932693_chant
decant93524223decant
descant104315593descant
discant103017263discant
distant83519953distant
dopant9316133dopant
eluant6315093eluant
errant6618733errant
eskar9457453eska_r
eskars10357593eskars
extant132714753extant
gallant83517113gallant
gardant9314463gardant
gasket114417253gask_et
gaskin113610583gaskin_
gasking134415913gasking
gaskins123510773gaskins
gasman92911743gasman_
gelant72821673gelant
giant65430593_giant
grant64840023_grant
hant75461593__hant
ikat87626643_ika_t
incant82418513incant
infant92315133infant
instant7815353instant
island738533island
issuant748263issuant
jessant1438443jessant
jurant134216553jurant
kana85928533__kana
kane85133973__kane
kart86750803__kart
kat77468293__ka_t
kent86846963__kent
leant56737783_leant
levant9314493levant
masking145116613masking
meant76537213_meant
mutant8317693mutant
nascent9610523nascent
natant6318733natant
nauseant845743nauseant
nutant6316383nutant
octant81216553octant
pageant10312783pageant
pant66061263__pant
peasant9314923peas_ant
pedant9319493pedant
pekan111613973pekan_
pekans121710553pekans
pissant91012503pissant
plant75437113_plant
pliant83918823pliant
quant143624813_quant
radiant82817133radiant
rampant11312173rampant
rant45864683__rant
recant83228683recant
riant55833153_riant
saint55147073_saint
salt45758523_s_alt
saltant7316773saltant
sand55338473_s_and
sane45954343_s_ane
sang55441233_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
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
ska76925863_ska__
skag96321513_ska_g
skags104316073_skags
skald104210173_skald
skanks94710833_skanks
skanky12476963_skanky
skas85325713_ska_s
skate94721553_skate
skats94621543_skats
skean94415623_skean_
skeane104611373_skeane
skeans104512913_skeans
skeet95429183_skeet
skene96118123_skene
skin85927533_skin_
skink85916853_skink
skins94723463_skins
skirt95624663_skirt
skit85437533_sk_it
sklent103614353_sklent
skort94925643_skort
skunk85011763_skunk
slang66324023_slang
slank95822773_slank
slants64819083_slants
slanty95114843_slanty
slat46959023_sla_t
smalt74729333_smalt
smart75834093_smart
sonant6621953sonant
spait75631603_spait
span65234663_span_
spang84919733_spang
spank115919573_spank
spans74528733_spans
spat66548523_spa_t
spent75532833_spent
stand65923283_stand
stane55933003_stane
stang66424683_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
tasking124616323tasking
tenant6322473tenant
truant6315783truant
tsking114210423tsking
tyrant9315333tyrant
unkent103116053unkent
vacant11415133vacant
vagrant11410663vagrant
valiant10314623valiant
variant10316803variant
volant9316323volant
want76156173__want
warrant10614243warrant

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.483369960.7
2DLD Change Limit1127162915.34621084.2
3Display Results2912910.0933129.0
 (SQL Overall)1786912915.92230174.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.