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 “tains” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

336 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
tains5493632(None) 
ains46158881_ains
cains75334301cains
gains65729511gains
kains96125641kains
mains75635111mains
pains75138281pains
rains55140231rains
sains55639971sains
stains64923651stains
tails55634191tails
tain45548071tain_
taint55542281taint
taints64520531taints
takins105117401takins
tans46154831ta_ns
tarns56433951tarns
thins85826331thins
tins45251301t_ins
trains64725341trains
twains95811181twains
twins85118981twins
wains86930871wains
aids57846362_aids
ails45654712_ails
aims67738182_aims
ain37579092_ain_
airns55521032_airns
airs46447422_airs
ais39083572_ai_s
aits46355532_aits
amins75534322amins
anis45746462_anis
attains7310982attains
awns75324432_awns
ayins85321612ayins
bails75933522bails
bairns86710872bairns
baits76630582baits
banns75321232banns
bans66555142ba_ns
barns76335142barns
basins85722762basins
bins66548252_bins
blains84516372blains
brains85125472brains
brins75533972brins
cabins104418922cabins
caids85226422caids
cain65643912cain_
cairns85313302cairns
cans65050852ca_ns
carns75937562carns
chains114819702chains
chins105631462chins
coins75834552coins
dais57040702dai_s
damns84916922damns
dans56748152da_ns
darns66927892darns
dawns95916592dawns
detains83716092detains
dins56652042_dins
djins1368452djins
drains73719402drains
earns55927562earns
elains64919852elains
etamins91511832etamins
fagins10513862fagins
fails85631482fails
fain75840562fain_
faint85837062faint
faints94818782faints
fairs85825442fairs
fans76247372fa_ns
fauns84516752fauns
fawns115914262fawns
fins75849092_fins
foins85523382foins
gain56042162gain_
gainst74914702gainst
gaits65726012gaits
gamins94420052gamins
gins55543952_gins
grains74223092grains
grins65427222grins
haiks125120932haiks
hails85231642hails
haint85436322haint
haints94417582haints
hairs86225172hairs
hins76447992_hins
ins35945602__ins
jails125422942jails
jins115635012_jins
joins125818412joins
kaifs125715642kaifs
kails95525212kails
kain85334292kain_
kaons95014852kaons
karns96624142karns
kins85747912_kins
laics76419252laics
lain46146282lain_
lairs55425872lairs
lapins84520682lapins
lawns85215422lawns
layins93817652layins
lins47059052_lins
loins56728422loins
maids86327142maids
mails76037782mails
maims96321792maims
main65345522main_
mairs76228302mairs
mans66354552ma_ns
matins84527782matins
mavins115119182mavins
naans55815252naans
naifs87617422naifs
nails55730402nails
nans46139402na_ns
obtains939162obtains
paiks114719852paiks
pails75833062pails
pain65647242pain_
paint75443692paint
paints85921832paints
pairs75325832pairs
pans65855732pa_ns
patins87528782patins
pavins114919662pavins
pawns108818132pawns
peins76128062peins
pians75126962pians
pins65558452_pins
plains85019592plains
pyins105815862pyins
qaids156116312qaids
quins144819852quins
raias54631122raias
raids65827512raids
rails55937402rails
rain46251732rain_
rainy85921082rainy
rais45252622rai_s
ranis55235832ranis
ravins94622562ravins
rawins95617622rawins
reins56234562reins
retains74522252retains
rins46153192_rins
ruins55822032ruins
sabins85521982sabins
saids65328852saids
sails55738102sails
sain45551292sain_
saint55147072saint
saints65122422saints
sans45153362sa_ns
sarins63932622sarins
sasins64923102sasins
satins64930482satins
savins93923132savins
shins85131042shins
sins46755272_sins
skins94723462skins
spins75327982spins
staigs75414812staigs
stain55727942stain_
stairs65416332stairs
statins73719772statins
steins64818342steins
strains74218152strains
swains94513952swains
tabes76033922tabes
tabs66842982ta_bs
tabuns8489222tabuns
tabus74820922tabus
taces76237802taces
tachs105820932tachs
tacks115430132tacks
tacos77023552tacos
tacts76524122tacts
tads57143942ta_ds
taels56822072taels
tafias93111962tafias
tags55545242ta_gs
tahini939892tahini
tahinis1048012tahinis
tahrs85412332tahrs
taiga64115672taiga
taigas73712572taigas
tail45443652tai_l
taipans9269552taipans
tajes124920692tajes
takas95520682takas
takes94437792takes
takin94921302takin_
taking114725952taking
takings124512572takings
talas55935892talas
talcs74817182talcs
tales55451372tales
talions7314112talions
talks94322692talks
talls55133432talls
talons64019442talons
talus55423262talus
tameins9311422tameins
tames75242012tames
taming94023432taming
tamis76728732tamis
tamps95524092tamps
tams67247932ta_ms
tan37167582ta_n_
tang56138692ta_ng
tangs65028362tangs
tanist6324602tanist
tank85134032ta_nk
tanks94624742tanks
tannins72813222tannins
tansy84514942ta_nsy
taos45541002ta_os
tapas74627712tapas
tapes75838602tapes
taping94222392taping
tapirs84113172tapirs
tapis75028862tapis
taps66050682ta_ps
tares57456562tares
taring73932282taring
tarn46842722tarn_
taros55640822taros
tarps76527122tarps
tars46763952ta_rs
tarts57242022tarts
tas38477102ta__s
tasks94917582tasks
tass45640572ta_ss
tates55444982tates
tats46858132ta_ts
taunt55532282taunt
taunts65715662taunts
tauons63412672tauons
taus46342732ta_us
tauts56125512tauts
tavs75630972ta_vs
tawing104521552tawing
tawny114713652tawny
taws75641592ta_ws
taxes124730822taxes
taxies135817332taxies
taxing143816712taxing
taxis126821972taxis
taxons134211502taxons
taxus125512482taxus
teens56227482teens
teind6213612teind
teinds738262teinds
tens45647412t_ens
terns55226872terns
theins95015422theins
thens85921832thens
thin76732392thin_
thine85026862thine
thing96622982thing
things104914302things
think125018802think
thinks134613362thinks
this76027382thi_s
tics65729632t_ics
ties45248312t_ies
tils45739612t_ils
tin36362172t_in_
tine45855132t_ine
tines54848422t_ines
ting56139912t_ing
tings65329212t_ings
tint46758862t_int
tints56030922t_ints
tiny76134632t_iny
tips66436762t_ips
tis37056642t_i_s
tits46145042t_its
toils54527492toils
toits55327472toits
tons46553052t_ons
toons55027532toons
towns86018882towns
toxins133314282toxins
traiks104013712traiks
trails64622512trails
train56529112train_
traits65121982traits
trans54933042trans
triens65417542triens
tries55742812tries
trigs65423062trigs
trims75021472trims
trine54734602trine
trines64132562trines
trios55528092trios
trips74923362trips
tuis44829642tui_s
tuns45138662t_uns
turns55623242turns
twain86313622twain_
twigs96911172twigs
twin76023082twin_
twine85822362twine
twines94717272twines
twiny116012812twiny
twits86015792twits
tyin76424002tyin_
tying96019842tying
vails85825932vails
vain75233002vain_
vairs85019132vairs
vans76236732va_ns
veins84620492veins
waifs115719872waifs
wails86631482wails
wain75840202wain_
wairs86424062wairs
waits88333522waits
wans76452272wa_ns
warns87231002warns
whins114922332whins
wins75949172_wins
yarns85621792yarns
yawns114213272yawns
yins75335122_yins
zayins18409712zayins
zeins144715392zeins
zins135735002_zins

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538003361.75030742.9
3Display Results3363360.0933612.9
 (SQL Overall)1786913362.13983539.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.