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

313 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
attains731098(None) 
attain6311751attain_
attaint7313471attaint
attaints846491attaints
abstains1047322abstains
actins86321102act_ins
atmans84413962atma_ns
attacks13126942attacks
attained997352attained
attainer8116912attainer
attainers9115592attainers
attars64515312atta_rs
attics84413282att_ics
attorns738432attorns
attrits7310612attrits
atwain937812atwain_
captains121810572captains
cattails1038552cattails
detains83716092detains
lattins74115482latt_ins
mattins93316142matt_ins
obtains939162obtains
rattails837132rattails
rattans73411952ratta_ns
reattains946442reattains
retains74522252retains
stains64923652_stains
statins73719772statins
strains74218152strains
tains54936322__tains
trains64725342_trains
twains95811182_twains
abating10413973abating
abatis84317933abati_s
ablins8316193a_blins
abstain947253abstain_
acetins9313173acetins
acrasins1039973acrasins
actin74922553act_in_
acting95920983act_ing
actings104512463act_ings
actions94218513actions
adjoins1585983adjoins
affairs1334163affairs
again65218113a_gain_
against838383a_gainst
agnails837003agnails
aiblins9311473aiblins
ains46158883___ains
alanins7315803alanins
alans55636173a_la_ns
alations82518893alations
alcaics1137023alcaics
aldrins8310203aldrins
alevins102110573alevins
alexins141910663alexins
algins74816433a_lgins
aloins65022203a_loins
altars64518153alta_rs
alumins9512983alumins
amain74922893a_main_
amidins103713093amidins
amins75534323a__mins
anilins7416793anilins
antacids1148323antacids
antas55432033anta__s
anteing8312813anteing
antiarins9413873antiarins
antiars7314623antiars
antics84621453ant_ics
anting75827023ant_ing
antings85015583ant_ings
antis55033313ant_i_s
antlions839193antlions
arraigns944343arraigns
arshins10312573arshins
assails769093assails
assais6711963assai_s
astasias8410143astasias
astatine8313533astatine
astatines9310343astatines
atamans9710433atamans
ataps76414833a_ta_ps
ataxias14189343ataxias
ataxics16196643ataxics
ataxies142410013ataxies
atlas55821583atla__s
atlases72410643atlases
atlatls744773atlatls
atman75520143atma_n_
atmas75721013atma__s
atomics113110853atomics
atomies93918363atomies
atonias73315993atonias
atonics93613713atonics
atonies75320953atonies
atoning83514873atoning
atopies92816433atopies
atrazine1748403atrazine
atrazines1846683atrazines
atropins10410493atropins
attaboy1264303attaboy
attach11118393atta_ch
attache12106693attache
attaches13137723attaches
attaching1545433attaching
attack12148153atta_ck
attacking1635323attacking
attagirl942033attagirl
attainder10103393attainder
attainders11112773attainders
attaining1047213attaining
attainted1044693attainted
attar56516693atta__r
attend7258973att_end
attends8257593attends
attent62818323att_ent
attests7278813attests
attic75618353att_i_c
attire62412383att_ire
attires72312953attires
attiring939483attiring
attorn6310793attorn_
attracts1047793attracts
attrit6315743attri_t
attrite7311833attrite
attrites8311563attrites
attune637983att_une
attunes737823attunes
attuning935903attuning
autoing8314043autoing
autumns943763autumns
auxins13129813a_uxins
avails939693a_vails
avians93711563avia_ns
avidins11349003avidins
awaits96411953a_waits
ayins85321613a__yins
azans146516883a_za_ns
bargains1178643bargains
battalias1144803battalias
battalions1242893battalions
battens95313263batt_ens
battiks1337143batt_iks
batting104422273batt_ing
battings114010573batt_ings
battling113110493battling
betaine9413783betaine
betaines10313293betaines
blains84516373_blains
brains85125473_brains
caftans12179443cafta_ns
cains75334303__cains
calpains1239763calpains
captain112111053captain_
captans111612053capta_ns
catkins133012563catkins
catlins93818843catlins
cattail939173cattai_l
cattalos1037933cattalos
catties94023053catt_ies
catting103922643catt_ing
chains114819703_chains
citrins92614363citrins
coattails1144843coattails
cocains111313923cocains
contains10316533contains
cotans81317923cota_ns
curtains10259703curtains
cutins83919983cut_ins
destains9311813destains
details84214043details
detain74617383detain_
detrains9411753detrains
distains9413603distains
domains10510873domains
drains73719403_drains
elains64919853_elains
entails7912823entails
entrains8312963entrains
estrins7315853estrins
etamins91511833etamins
fantails1139693fantails
fattens105111713fatt_ens
fatties103018203fatt_ies
fatting113818703fatt_ing
fusains1038363fusains
gains65729513__gains
gastrins9310123gastrins
grains74223093_grains
gratins84119183gratins
hatpins123410643hatpins
hatting113920233hatt_ing
isatins7310773isatins
kaftans14185353kafta_ns
kains96125643__kains
lattens75014673latt_ens
lattin64316223latt_in_
luteins7310103luteins
mains75635103__mains
maintains1167093maintains
martians103111613martians
martins93322063mart_ins
matins84527783mat_ins
mattin84416633matt_in_
matting103620143matt_ing
mattings11369673matt_ings
mattoids1196183mattoids
natations91412493natations
obtain839183obtain_
octans81411143octa_ns
ordains879653ordains
ottars64112223otta_rs
ottavas1093483ottavas
outgains9810163outgains
outsins73417863outsins
oxtails1436383oxtails
pains75138283__pains
papains11312363papains
partans94418283parta_ns
patins87528783pat_ins
pattens95414923patt_ens
patterns10439943patterns
patties93425143patt_ies
patting103722343patt_ing
pertains102113413pertains
plains85019593_plains
plantains1147493plantains
pterins9812993pterins
ptomains1246053ptomains
ptyalins1364693ptyalins
quatrains1845583quatrains
rains55140233__rains
ratans63819373rata_ns
ratlins73615583ratlins
rattail737793rattai_l
rattan63613603ratta_n_
ratteens8256053ratteens
rattens74213403ratt_ens
ratting83822363ratt_ing
rattling92510873rattling
rattlings10235513rattlings
rattons73815323ratt_ons
rattoons8327513rattoons
reattain846733reattain_
regains84316583regains
remains94117893remains
retails74718973retails
retain64523283retain_
retrains8314523retrains
rutins63818393rut_ins
sains55639973__sains
satins64930483sat_ins
seatrains947603seatrains
sextains15246813sextains
sprains93013593sprains
staigs75414813_staigs
stain55727933_stain_
stairs65416333_stairs
statics93314533statics
statin63921463statin_
stating83725163stating
stations82415213stations
stearins8312143stearins
steins64818343_steins
stotins73213863stotins
strain64919573strain_
straits74916323straits
sustains838553sustains
swains94513953_swains
tails55634193__tails
tain45548073__tain_
taint55542283__taint
taints64520533__taints
takins105117403_takins
tamarins10310833tamarins
tameins9311413tameins
tannins72813223tannins
tans46154813__ta_ns
tarns56433953__tarns
tartans72615823tarta_ns
tatamis939713tatamis
tatars64619793tata_rs
tatties74120343tatties
tatting84019523tatting
tattings9408823tattings
tattling9259463tattling
theins95015423_theins
thins85826323__thins
tins45251303__t_ins
titans63414913tita_ns
titians72710453titians
toxins133314283_toxins
traiks104013713_traiks
trails64622513_trails
train56529113_train_
traits65121983_traits
trans54933043_tra_ns
twain86313623_twain_
twins85118983__twins
vatting113614853vatt_ing
vitamins1347083vitamins
vitrains1138283vitrains
wagtails1244443wagtails
wains86930863__wains
wattages12106783wattages
wattapes1395253wattapes
wattling12258783wattling
witans93412933wita_ns
withins133511693withins
xanthins1846943xanthins
yttrias1044513yttrias
zeatins16311733zeatins

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273136.90619407.3
3Display Results3133130.1102845.5
 (SQL Overall)1786913137.17224915.1
 
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.