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

248 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
atwain93781(None) 
attain6311751attain
twain86313621_twain
again65218122a_gain
amain74922912a_main
atman75520142atma_n
attains7310982attains
attaint7313472attaint
atween9166612atween
await85524492a_wait
stain55727942st_ain
strain64919572strain
swain84919052_swain
tain45548072_t_ain
train56529112_train
twains95811182_twains
twin76023082_tw_in
wain75840202__wain
abstain947253abstain
abwatt11410673abwatt
acetin8314693acetin
acrasin9311223acrasin
actin74922553a_ctin
adjoin14107293adjoin
adman84517903adma_n
affair1234353affair
afraid1049723afraid
agin56132713a__gin
agnail739533agnail
ain37579103___ain
ajowan1634893ajowa_n
akin86328043a__kin
alan46844083a_la_n
alanin6317273alanin
alcaic1039983alcaic
aldrin7311243aldrin
alevin92511513alevin
alexin132311483alexin
algin65718763a_lgin
alkalin11178183alkalin
aloin55227423a_loin
alumin8513543alumin
alway116113923alwa_y
always12409133always
amidin94015673amidin
amin66042253a__min
anilin6417793anilin
antiair7310313antiair
antiarin8413913antiarin
apian75018333apia_n
arraign845063arraign
arshin9312173arshin
assai5711543assai_
assail6610153assail
assais6711963assais
aswarm11107913aswarm
aswoon947013aswoon
ataman81013063ataman
atap66722453at_a_p
ataps76414833at_aps
atavic11189293atavic
ataxia13179593ataxia
ataxic15169203ataxic
ataxy1537313at_axy
atelic8313703atelic
athwart1348683athwart
atlas55821583atla_s
atlatl637873atlatl
atma68121773atma__
atmans84413963atmans
atmas75721013atma_s
atomic104115603atomic
atonia63816513atonia
atonic83420473atonic
atoning83514873atoning
atopic103514143atopic
atrazine1748403atrazine
atria56022353at_ria
atrial65418943atrial
atrip75315753at_rip
atropin9311583atropin
attach11118393attach
attack12148153attack
attained997353attained
attainer8116913attainer
attaints846493attaints
attar56516693atta_r
attars64515313attars
attic75618353at_tic
attorn6310793attorn
attrit6315753attrit
atypic13337653atypic
auxin121411913a_uxin
avail8313883a_vail
avian84616053avia_n
avidin103510843avidin
awa611939673a_wa__
awaits96411953a_waits
awake125014783a_wake
awaken13468863a_waken
awaking1547813a_waking
award97118043a_ward
aware86420023a_ware
awash116613163a_wash
away108024223a_wa_y
aweing103911253a_weing
awing96827323a_w_ing
awn68035913a_w__n
awning105013393a_wning
axman144813183axma_n
ayin76331743a__yin
azan136521783a_za_n
bargain1079063bargain
batman105214063batma_n
batwing13509813batw_ing
bewail1189583bewail
blain75421793_blain
boatswain1451923boatswain
bowfin14338353bowfin
brain76229383_brain
cain65643913__cain
calpain11310413calpain
captain112111063captain
catkin123512383cat_kin
catlin83819083cat_lin
cattail939183cattail
catwalk1645323catwalk
chain105723673_chain
cocain101315013cocain
detain74617383detain
detrain8412253detrain
dewan95718043dewa_n
diwan95712553diwa_n
domain9511323domain
drain65222893_drain
elain55324703_elain
entrain7313073entrain
etamin81311853etamin
fain75840563__fain
fatwa1168063fatwa__
fatwas1249053fatwa_s
fusain958643fusain
gain56042163__gain
gowan95415743gowa_n
grain65126253_grain
hatpin112610613hat_pin
hwan105716893_hwa_n
jawan15710383jawa_n
kain85334303__kain
lain46146283__lain
lattin64316223lat_tin
main65345523__main
matin75132853mat__in
mattin84416633mat_tin
obtain839183obtain
ordain7810403ordain
outgain81010743outgain
outlain71212613outlain
outwait10411763outwait
pain65647243__pain
papain10313793papain
patin76832853pat__in
plain74823303_plain
pterin81014153pterin
ptomain1146963ptomain
ptyalin1274783ptyalin
quatrain1745833quatrain
rain46251733__rain
ratan53722663rat_a_n
ratlin64116523rat_lin
rattail737803rattail
rattan63613603ratta_n
rawin85521473raw_in
reattain846733reattain
regain74517763regain
remain85919863remain
retain64523283retain
retrain7615423retrain
rewan85623663rewa_n
rewin85623963rew_in
rowan85418733rowa_n
sain45551293__sain
satin55935223sat__in
seatrain847923seatrain
sewan85921293sewa_n
slain54923573_slain
sprain83614863sprain
staid66722083st_aid
staig65519643st_aig
stains64923653st_ains
stair54719943st_air
statin63921473statin
stearin7312003stearin
stein54620543st_ein
stoai55417873stoai_
stotin63215063stotin
strains74218153strains
strait64025893strait
swail86217163_swail
swains94513953_swains
swan76631313_swa_n
tail45443653_t_ail
tains54936323_t_ains
taint55542283_t_aint
takin94921303_takin
tamarin9311923tamarin
tamein8313093tamein
tan37167583_t_a_n
tannin62613933tannin
tarn46842723_t_arn
tawie84819813taw_ie
tawing104521553taw_ing
tawpie11339143tawpie
tawsing1138673tawsing
than76128773_tha_n
thein85919023_thein
thin76732393_t_hin
tin36362183_t__in
toxin124716713_toxin
traik95418203_traik
trail55126773_trail
trains64725343_trains
trait56940843_trait
twa67721643_twa__
twae74719573_twa_e
twaes86513663_twaes
twang94511863_twang
twas76824083_twa_s
twat75831513_twa_t
twats86616603_twats
tween84413743_tween
twig87615773_tw_ig
twine85822363_tw_ine
twins85118983_tw_ins
twiny116012813_tw_iny
twit76329063_tw_it
tyin76424003_t_yin
vain75233003__vain
vitrain1038943vitrain
waif105836753__waif
wail75238823__wail
wains86930873__wains
wair75830053__wair
wait75553693__wait
wan66761943__wa_n
warn75239323__warn
whin105225693__whin
win66456303__w_in

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 Limit1127162486.28317939.8
3Display Results2482480.0932666.7
 (SQL Overall)1786912486.76626410.1
 
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.