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

349 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
mains7563510(None) 
ains46158881_ains
amins75534321amins
cains75334301cains
gains65729511gains
kains96125641kains
maids86327141maids
mails76037781mails
maims96321791maims
main65345511main_
mairs76228301mairs
mans66354531ma_ns
matins84527781matins
mavins115119181mavins
pains75138281pains
rains55140231rains
sains55639971sains
tains54936321tains
wains86930861wains
aids57846352_aids
ails45654712_ails
aims67738182_aims
ain37579092_ain_
airns55521032_airns
airs46447422_airs
ais39083572_ai_s
aits46355532_aits
amain74922892amain_
amens75624842amens
amias75831472amias
amids85627512amids
amies76837692amies
amin66042252amin_
amine75835382amine
amines84727982amines
amino75425502amino
amirs75924922amirs
amis66445322ami_s
amiss75823072amiss
anis45746462_anis
awns75324432_awns
ayins85321612ayins
bails75933522bails
bairns86710872bairns
baits76630582baits
banns75321232banns
bans66555132ba_ns
barns76335142barns
basins85722762basins
bins66548252_bins
blains84516372blains
brains85125472brains
brins75533972brins
cabins104418922cabins
caids85226422caids
cain65643912cain_
cairns85313302cairns
cans65050842ca_ns
carns75937562carns
chains114819702chains
chins105631462chins
coins75834552coins
dais57040702dai_s
damns84916922damns
dans56748142da_ns
darns66927892darns
dawns95916592dawns
dins56652042_dins
djins1368452djins
domains10510872domains
drains73719402drains
earns55927562earns
elains64919852elains
emails84412342emails
fagins10513862fagins
fails85631482fails
fain75840562fain_
faint85837062faint
faints94818782faints
fairs85825442fairs
fans76247362fa_ns
fauns84516752fauns
fawns115914262fawns
fins75849092_fins
foins85523382foins
gain56042162gain_
gainst74914692gainst
gaits65726012gaits
gamins94420042gamins
gins55543952_gins
grains74223092grains
grins65427222grins
haiks125120932haiks
hails85231642hails
haint85436322haint
haints94417582haints
hairs86225172hairs
hins76447992_hins
ins35945602__ins
jails125422942jails
jins115635012_jins
joins125818412joins
kaifs125715642kaifs
kails95525212kails
kain85334292kain_
kaons95014852kaons
karns96624142karns
kins85747902_kins
laics76419252laics
lain46146282lain_
lairs55425872lairs
lapins84520682lapins
lawns85215422lawns
layins93817652layins
lins47059052_lins
loins56728422loins
maars74621632maars
mabes96331532mabes
maces97139962maces
machs125722562machs
macing114221552macing
macks135127602macks
macons104017242macons
macs86742502ma_cs
mads76845362ma_ds
maes66948392ma_es
mafias113913572mafias
mages85036022mages
magians10310752magians
magics115311612magics
mags75444522ma_gs
magus85318752magus
maid75537642mai_d
maidens10349662maidens
mail65543442mai_l
maile75232222maile
mailes84329112mailes
maill74420792maill
maills84215282maills
maim85831482mai_m
mainly11411492mainly
mair66133772mai_r
maist75535682maist
maists85817572maists
maize164618562maize
maizes175115732maizes
makes115336852makes
making134823842making
makings145413152makings
makos116518362makos
males75049792males
maligns1038132maligns
maline84529082maline
malines93625602malines
malkins133311802malkins
malls76233432malls
malms95021552malms
malts76331752malts
mamas95930772mamas
mamies104626242mamies
man57465852ma_n_
mana65341942ma_na
manas76240422manas
mane65052012ma_ne
manes76648952manes
mania75634142mania
manias84029032manias
manic94629432manic
manics103919932manics
manna75522532manna
mannas85019802mannas
mano66536792ma_no
manos74933612manos
manse75528222ma_nse
manus75924922manus
many95731842ma_ny
maps86141042ma_ps
maras75443282maras
marcs95726622marcs
mares76457632mares
margins103815192margins
marina84623412marina
marinas93519372marinas
marine84230402marine
marines93928012marines
marks115933482marks
marlins93420472marlins
marls75535162marls
mars66261862ma_rs
martins93322062martins
marts77442232marts
mas58175812ma__s
masas75630412masas
masks115320532masks
masons83916512masons
mass66044932ma_ss
masts77035762masts
mates75251362mates
maths105624022maths
matin75132852matin_
mating94832912mating
matings104516202matings
mats65460282ma_ts
mattins93316142mattins
matts76829182matts
mauds85519272mauds
mauls76524952mauls
maun65727202maun_
maund85515442maund
maunds9519652maunds
mauts75927192mauts
mavens114312972mavens
mavies114923192mavies
mavin105722952mavin_
mavis105622722mavis
mawing124020802mawing
mawn94424132mawn_
maws96437132ma_ws
maxes145629532maxes
maxims17399672maxims
maxing164817072maxing
maxis145721562maxis
mayas105924382mayas
maying124421152maying
mayings134410502mayings
mayos105521932mayos
mays96940022ma_ys
mayvins1535322mayvins
mazes165632172mazes
mazing184418972mazing
means75831222means
meiny104015412meiny
mibs85330482m_ibs
mics87435152m_ics
mids76541782m_ids
miens76118302miens
migs76935322m_igs
mils66045332m_ils
mina65136912m_ina
minas75434112m_inas
mind75434372m_ind
minds85427122m_inds
mine67256162m_ine
mines75651952m_ines
mini65634552m_ini
minis75432992m_inis
mink106636522m_ink
minks115829272m_inks
mint66758052m_int
mints76834042m_ints
minus75223932m_inus
minx137723342m_inx
mips85534082m_ips
mirins83918902mirins
mirs66940572m_irs
mis58162622m_i_s
miss65339422m_iss
moans74624362moans
moils76125752moils
mons68152252m_ons
moons75331002moons
morns75527442morns
mucins102712512mucins
munis75022002munis
muns65535912m_uns
muons75816172muons
naans55815252naans
naifs87617422naifs
nails55730402nails
nans46139392na_ns
paiks114719852paiks
pails75833062pails
pain65647242pain_
paint75443692paint
paints85921832paints
pairs75325832pairs
pans65855722pa_ns
patins87528782patins
pavins114919662pavins
pawns108818132pawns
peins76128062peins
pians75126962pians
pins65558452_pins
plains85019592plains
pyins105815862pyins
qaids156116312qaids
quins144819852quins
raias54631122raias
raids65827512raids
rails55937402rails
rain46251732rain_
rainy85921082rainy
rais45252622rai_s
ranis55235832ranis
ravins94622562ravins
rawins95617622rawins
reins56234562reins
remains94117892remains
rins46153192_rins
ruins55822032ruins
sabins85521982sabins
saids65328852saids
sails55738102sails
sain45551292sain_
saint55147072saint
saints65122422saints
sans45153352sa_ns
sarins63932622sarins
sasins64923102sasins
satins64930482satins
savins93923132savins
shins85131042shins
sins46755272_sins
skins94723462skins
spins75327982spins
stains64923652stains
swains94513952swains
tails55634192tails
tain45548072tain_
taint55542282taint
taints64520532taints
takins105117402takins
tans46154812ta_ns
tarns56433952tarns
thins85826322thins
tins45251302_tins
trains64725342trains
twains95811182twains
twins85118982twins
vails85825932vails
vain75233002vain_
vairs85019132vairs
vans76236722va_ns
veins84620492veins
waifs115719872waifs
wails86631482wails
wain75840192wain_
wairs86424062wairs
waits88333522waits
wans76452262wa_ns
warns87231002warns
whins114922332whins
wins75949172_wins
yarns85621792yarns
yawns114213272yawns
yins75335122_yins
zayins18409712zayins
zeins144715392zeins
zins135735002_zins

Search took 2 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.0961861364.6
2DLD Change Limit538003491.60633499.4
3Display Results3493490.0963635.4
 (SQL Overall)1786913491.79899383.2
 
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.