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

264 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
aswarm1110791(None) 
swarm106218841_swarm
alarm76621422a_larm
asarum84610912as_arum
ashram1139052ashram
aswirl935092aswirl
award97118042a_ward
aware86420022a_ware
beswarm1445782beswarm
rewarm115913492rewarm
smarm95517602_smarm
swam96329982_swa_m
sward94221462_sward
sware85828212_sware
swarf115324652_swarf
swarms116112172_swarms
swart86234642_swart
warm95935672__warm
abeam9316533abea_m
aboard9312613aboard
abwatt11410673abwatt
acari75020283a_cari
afar76720783a_far_
afars85716513a_fars
afeard1058263afeard
affirm1435523affirm
agar58726413a_gar_
agars66120643a_gars
aglare7312433aglare
airward1148133airward
ajar116217703a_jar_
alar46340073a_lar_
alarms85913053a_larms
alarum85411983a_larum
alary86123443a_lary
altar55520643altar_
altars64518153altars
alway116113923alwa_y
always12409133always
ambari103012173ambari
ambary134010543ambary
anear55420323anear_
anears63717183anears
angary10311323angary
answer936893answer_
answers1037043answers
apart74330673a_part
apiary113910383apiary
ariary94114203ariary
arm58449623___arm
asana5315483as_ana
asarums9467613as_arums
ascared10399523ascared
ascarid103910723ascarid
ascaris93613323ascaris
asea46327183asea__
ashlar9338193ashlar_
ashlars10297063ashlars
ashore9414613ashore
ashrams1236653ashrams
askant10412713askant
asker96418783asker_
askers105915403askers
aslant6317753aslant
asper75520433asper_
aspers86220313aspers
aspire8612123aspire
asrama839193asrama
assai5711543assa_i
assail6610153assail
assais6711963assais
assay8710283assa_y
assays977903assays
assert64922583assert
assort64916383assort
assure6610773assure
asswage1144673asswage
aster55434893aster_
astern64815813astern
asters65631603asters
astir55517093astir_
astral66919283astral
astray95615543astray
aswoon947013aswoon
asylum1144893asylum
athwart1348683athwart
attar56516693attar_
attars64515313attars
atwain937813atwain
aurar54420253aurar_
ausform1245233ausform
aviary12338413aviary
awa611939673a_wa__
await85524493a_wait
awake125014783a_wake
awards107113453a_wards
awash116613163a_wash
away108024223a_wa_y
aweary1237303aweary
awkward1843183awkward
awry107619683a_w_ry
bagworm1566353bagworm
barm86739603__barm
barware12610703barware
bastard103012423bastard
beswarms1544323beswarms
beware11313713beware
beworm1339993beworm
cascara1138313cascara
caseworm1546163caseworm
charm126124663_charm
coward12411673coward
dastard9279703dastard
dewar95817733dewar_
dewars105117073dewars
deworm1249533deworm
disarm9310473disarm
dwarf126015243_dwarf
earworm1238743earworm
eastward1244993eastward
escar74011993escar_
escarp10449003escarp
escars83913133escars
eskar9457453eskar_
eskars10357593eskars
farm95934533__farm
harm95637793__harm
hayward1736413hayward
inarm7314423_inarm
inward10310333inward
jowar155211433jowar_
jowars16369653jowars
lascar868573lascar_
lascars979013lascars
manward1349093manward
mascara1138023mascara
onward1039053onward
osar46820953os_ar_
prearm104512353prearm
prewarm14479613prewarm
psalm949273ps_alm
psywar1443323psywar_
psywars1533673psywars
rearm75923573_rearm
reward106017643reward
rewarms12439603rewarms
safari91110223safari
salaam8711013salaam
salary9515213salary
samara8313853samara
sard55344243_s_ard
sari45444043_s_ari
sark84938973_s_ark
satara6315533satara
sawer85026213sawer_
sawers94620163sawers
scam85932353_sca_m
scar66434203_scar_
scare75334463_scare
scarf105427143_scarf
scarp95724103_scarp
scars75433533_scars
scart76139773_scart
scary105222593_scary
scram910621623_scram
seam66645973_sea_m
sear47353843_sear_
sears54744913_sears
sewar85421103sewar_
sewars94018633sewars
sham96436363_sha_m
shard96125963_shard
share86437083_share
shark126225023_shark
sharn84823703_sharn
sharp104922533_sharp
shawm135316153_shawm
slam67737973_sla_m
smarms105712533_smarms
smarmy13629353_smarmy
smart75834093_smart
snare54429983_snare
snarf86525423_snarf
snark95419943_snark
snarl54921083_snarl
soar46838673_soar_
soars54732513_soars
sowar85821343sowar_
sowars94318013sowars
spam85930043_spa_m
spar65433303_spar_
spare75135563_spare
spark114920893_spark
spars75431543_spars
spasm94514173_spasm
sperm93216023_sperm
star48037763_star_
stare54440263_stare
stark95425623_stark
stars55836573_stars
start55642313_start
storm76520403_storm
swab96825313_swa_b
swabs105817273_swabs
swag87526733_swa_g
swage94919563_swage
swags94921253_swags
swail86217163_swail
swain84919053_swain
swale85221593_swale
swami105614523_swami
swamp125015323_swamp
swamy136714403_swamy
swan76631313_swa_n
swang95519723_swang
swank125318233_swank
swans84625013_swans
swap95925433_swa_p
swaps104819203_swaps
swaraj1636023_swaraj
swards105415133_swards
swarfs125612063_swarfs
swarmed1367483_swarmed
swarmer1247803_swarmer
swarth126012083_swarth
swarty125812383_swarty
swash116316753_swash
swat77244443_swa_t
swath115920383_swath
swats85726863_swats
sway107128233_swa_y
sways115518463_sways
swear85316853_swear_
swears94114073_swears
swim96221403_sw_im
swirl84514143_swirl
sword95214123_sword
swore84920823_swore
sworn86115313_sworn
swum96416823_sw_um
tharm105916643_tharm
thwart12311683thwart
toward10311063toward
tsar47819803ts_ar_
tsars56717113ts_ars
unarm7314453_unarm
unwary1239823unwary
upward12147163upward
vanward1456943vanward
vaward13498723vaward
war67262423__war_
ward86542253__ward
ware76254723__ware
wark115737773__wark
warms107726853__warms
warn75239323__warn
warp95635003__warp
wars78659803__wars
wart77866083__wart
wary106740013__wary
waxworm2264573waxworm
wayward1736053wayward
worm96129493__worm
yardarm13114533yardarm

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.390458182.1
2DLD Change Limit1127162645.90619085.0
3Display Results2642640.0932838.7
 (SQL Overall)1786912646.38927968.5
 
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.