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

266 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
amin6604225(None) 
agin56132711agin
ain37579101a_in
akin86328041akin
amain74922911amain
amen66733151amen
ami56646811ami_
amia66836901amia
amid77036361amid
amie66339851amie
amine75835381amine
amino75425501amino
amins75534321amins
amir65129751amir
amis66445321amis
ayin76331741ayin
gamin84423001gamin
main65345521main
acid77533402acid
acing87429152acing
acini75718982acini
acmic11312332acmic
actin74922552actin
adit56443662adit
adman84517912adman
admen84516182admen
admit8319492admit
admix1557732admix
aeon45634612aeon
again65218122again
aging77026352aging
agio57828452agio
agon56531882agon
ahi68040232ahi_
ahing98928352ahing
ahis76135382ahis
ai211288402a_i_
aid49269092a_id
ail37171052a_il
aim57858222a_im
aiming94320842aiming
aims67738192aims
ains46158892a_ins
air38058402a_ir
airn46433842airn
ais39083582a_is
ait38093912a_it
alan46844082alan
algin65718762algin
alien56425582alien
alif76242142alif
align65016502align
aline57243162aline
alit46155692alit
aloin55227422aloin
alumin8513542alumin
am411875562am__
ama510853312am_a
amah98927502amah
amas67746302amas
ambit94223712ambit
ambo88225142ambo
amend85717752amend
amens75624842amens
ament76036542ament
amias75831472amias
amice96122872amice
amici94217392amici
amide86128492amide
amidin94015672amidin
amido85720992amido
amids85627522amids
amies76837692amies
amiga85514812amiga
amigo86515472amigo
amines84727982amines
aminic104413512aminic
amirs75924922amirs
amiss75823072amiss
amity10416092amity
ammine10314492ammine
ammino1069882ammino
ammo85520132ammo
amnia75918642amnia
amnic95516242amnic
amnio75218052amnio
amnion84812052amnion
amok10217402amok
among85813302among
amp77541022am_p
amping114317572amping
amps86230342amps
amu58237322am_u
amus65529612amus
amyl95515102amyl
an211879082a__n
ani37751182ani_
anil46437432anil
anion55028812anion
anis45746472anis
anon46134852anon
apian75018332apian
aping87327232aping
aria46245432aria
arid57642722arid
aril45843022aril
arming94719802arming
atman75520152atman
auxin121411912auxin
avian84616052avian
avid88325972avid
avion84218342avion
awing96827322awing
awn68035912a_wn
axil116424452axil
axing138521372axing
axion1211316912axion
axis116127912axis
axman144813192axman
axmen145112272axmen
axon115524302axon
ayins85321612ayins
azan136521782azan
azine146721412azine
azon135725052azon
basin75026922basin
bin56658652_bin
blin67228172blin
brin67038192brin
cabin94820942cabin
cain65643912cain
camion103917192camion
chin96934742chin
coin66645352coin
cumin94616972cumin
daman84821172daman
damn75724322dam_n
diamin9312522diamin
din46459472_din
djin12911632djin
emic86422752emic
emir65918702emir
emit65438422emit
etamin81311852etamin
fagin9216572fagin
fain75840562fain
famine114318192famine
faming124922972faming
fin66458042_fin
foin77231562foin
gain56042162gain
gamic103916202gamic
gamine94620152gamine
gaming104622042gaming
gamins94420052gamins
gin46055762_gin
grin55733722grin
haemin113412662haemin
harmin113117402harmin
hemin103620932hemin
hin67559572_hin
imid76122302imid
imine75821062imine
imino74315232imino
in28150872__in
jasmin1538072jasmin
jin106443942_jin
join116724832join
kain85334302kain
kami105823662kami_
kamik105011562kamik
kamsin1238322kamsin
kin76353982_kin
lain46146282lain
lamia75324322lamia
lamina84920442lamina
laming94528362laming
lapin75222922lapin
layin84720332layin
limn66527702limn
lin37967382_lin
loin46838722loin
maid75537672maid
mail65543452mail
maim85831492maim
mains75635112mains
mair66133782mair
mamie95826002mamie
man57465872_man
matin75132852matin
maun65727212maun
mavin105722952mavin
mawn94424142mawn
men59252852_men
mi48249062_mi_
mib76946132_mib
mic77647652_mic
mid67354482_mid
mien65028372_mien
mig65646092_mig
mil55752122_mil
mim76048432_mim
mina65136932_mina
mind75434392_mind
mine67256182_mine
mini65634572_mini
mink106636542_mink
mint66758072_mint
minx137723362_minx
mir57046782_mir
mis58162632_mis
mix126138192_mix
mon57561582_mon
mun56143862_mun
naming93917892naming
omen66828182omen
omit65337372omit
pain65647242pain
patin76832852patin
pavin105623202pavin
pein65834942pein
pin57066732_pin
pyin96823232pyin
quin135823922quin
rain46251732rain
ramen75625192ramen
rami66034092rami_
ramie75027822ramie
ravin85624652ravin
rawin85521472rawin
rein46040892rein
rin36663192_rin
ruin47430512ruin
sabin74924952sabin
saimin8313662saimin
sain45551292sain
sarin55239252sarin
sasin54626572sasin
satin55935222satin
savin84625082savin
shin75634312shin
sin36265902_sin
skin85927542skin
smit65138412smit
spin66231302spin
tain45548072tain
takin94921302takin
tamein8313092tamein
taming94023432taming
tamis76728732tamis
thin76732392thin
tin36362182_tin
twin76023082twin
tyin76424002tyin
vain75233002vain
vein75625752vein
wain75840202wain
whin105225692whin
win66456302_win
yamen104115182yamen
yamun10419272yamun
yin67648742_yin
zamia165115212zamia
zayin174512042zayin
zein135620602zein
zin125643782_zin

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 Filter178691298720.296603685.8
2DLD Change Limit298722660.92032469.6
3Display Results2662660.0634222.2
 (SQL Overall)1786912661.279139711.5
 
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.