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

263 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
amins7553432(None) 
ains46158881a_ins
amens75624841amens
amias75831471amias
amids85627511amids
amies76837691amies
amin66042251amin_
amine75835381amine
amines84727981amines
amino75425501amino
amirs75924921amirs
amis66445321ami_s
amiss75823071amiss
ayins85321611ayins
gamins94420041gamins
mains75635101mains
ablins8316192ablins
acids87121002acids
acing87429152acing
acini75718982acini
acinus8311252acinus
actins86321102actins
adios65822862adios
adits66523712adits
admits9411412admits
aeons57624652aeons
agin56132712agin_
aging77026352aging
agings86312672agings
agios65919862agios
agons66423782agons
ahing98928342ahing
ahis76135382ahi_s
aids57846352a_ids
ails45654712a_ils
aiming94320842aiming
aims67738182a_ims
ain37579092a_in_
airns55521032airns
airs46447422a_irs
ais39083572a_i_s
aits46355532a_its
akin86328032akin_
alans55636172alans
algins74816432algins
alias55834602alias
aliens65619212aliens
alifs86121262alifs
aligns75312952aligns
aline57243152aline
alines65735222alines
aloins65022202aloins
alumins9512982alumins
amahs107819062amahs
amain74922892amain_
amas67746292am_as
amass77119682amass
ambits103713412ambits
ambos95321252ambos
amen66733152amen_
amend85717752amend
amends94713282amends
ament76036542ament
aments85219802aments
ami56646812ami__
amia66836902ami_a
amice96122872amice
amices105018012amices
amici94217392amici
amicus10389992amicus
amid77036342ami_d
amide86128482amide
amides95722662amides
amidins103713092amidins
amido85720972amido
amidst94913232amidst
amie66339852ami_e
amiga85514802amiga
amigas95912162amigas
amigo86515462amigo
amigos94511202amigos
aminic104413512aminic
amir65129752ami_r
amity10416092amity
ammine10314492ammine
ammines11312672ammines
ammino1069882ammino
ammos94815822ammos
amnia75918642amnia
amnic95516242amnic
amnio75218052amnio
amnions93710912amnions
amnios84912522amnios
amoks11413552amoks
among85813302among
amping114317572amping
amps86230342am_ps
amus65529612am_us
amyls104512682amyls
anils56326722anils
anions64123032anions
anis45746462ani_s
aping87327232aping
arias55438022arias
arils58732202arils
armies85123692armies
arming94719802arming
armings103811492armings
atmans84413962atmans
auxins13129812auxins
avens86419332avens
avians93711562avians
avions94114392avions
awing96827322awing
awns75324432a_wns
axils127217502axils
axing138521372axing
axions134713482axions
axis116127912axi_s
axons125517932axons
ayin76331742ayin_
azans146516882azans
azine146721412azine
azines155517072azines
azons146518252azons
basins85722762basins
bins66548252_bins
brins75533972brins
cabins104418922cabins
cains75334302cains
camions113916132camions
chins105631462chins
coins75834552coins
cumins103314932cumins
damans94715982damans
damns84916922dam_ns
diamins10312202diamins
dins56652042_dins
djins1368452djins
emirs76116162emirs
emits75421472emits
etamins91511832etamins
fagins10513862fagins
famine114318192famine
famines123216262famines
faming124922972faming
fins75849092_fins
foins85523382foins
gains65729512gains
gamin84422992gamin_
gamine94620152gamine
gamines103618462gamines
gaming104622042gaming
gamings114610912gamings
gins55543952_gins
grins65427222grins
haemins122811392haemins
harmins123716712harmins
hemins113417562hemins
hins76447992_hins
imids86015142imids
imine75821062imine
imines84918352imines
imino74315232imino
ins35945602__ins
jasmins1637082jasmins
jins115635012_jins
joins125818412joins
kains96125642kains
kamiks11387912kamiks
kamsins1346962kamsins
kins85747902_kins
lamias85020612lamias
lamina84920442lamina
laminas93615872laminas
laming94528362laming
lapins84520682lapins
layins93817652layins
limns75718392limns
lins47059052_lins
loins56728422loins
maids86327142maids
mails76037782mails
maims96321792maims
main65345512main_
mairs76228302mairs
mamies104626242mamies
mans66354532_mans
matins84527782matins
mavins115119182mavins
mibs85330482_mibs
mics87435152_mics
mids76541782_mids
miens76118302_miens
migs76935322_migs
mils66045332_mils
mina65136912_mina
minas75434112_minas
mind75434372_mind
minds85427122_minds
mine67256162_mine
mines75651952_mines
mini65634552_mini
minis75432992_minis
mink106636522_mink
minks115829272_minks
mint66758052_mint
mints76834042_mints
minus75223932_minus
minx137723342_minx
mips85534082_mips
mirs66940572_mirs
mis58162622_mi_s
miss65339422_miss
mons68152252_mons
muns65535912_muns
naming93917892naming
omens75618962omens
omits75018262omits
pains75138282pains
patins87528782patins
pavins114919662pavins
peins76128062peins
pins65558452_pins
pyins105815862pyins
quins144819852quins
rains55140232rains
ramies84630462ramies
ravins94622562ravins
rawins95617622rawins
reins56234562reins
rins46153192_rins
ruins55822032ruins
sabins85521982sabins
saimins9312112saimins
sains55639972sains
sarins63932622sarins
sasins64923102sasins
satins64930482satins
savins93923132savins
shins85131042shins
sins46755272_sins
skins94723462skins
spins75327982spins
tains54936322tains
takins105117402takins
tameins9311412tameins
taming94023432taming
tamis76728722tami_s
thins85826322thins
tins45251302_tins
twins85118982twins
veins84620492veins
wains86930862wains
whins114922332whins
wins75949172_wins
yamens114010822yamens
yamuns11336512yamuns
yins75335122_yins
zamias174212922zamias
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.0931921408.6
2DLD Change Limit538002631.76630464.3
3Display Results2632630.0803287.5
 (SQL Overall)1786912631.93992156.3
 
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.