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

210 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
akin8632803(None) 
agin56132711agin
ain37579091a_in
amin66042251amin
ayin76331741ayin
kain85334291kain
kin76353961_kin
skin85927531skin
takin94921301takin
acid77533392acid
acing87429152acing
acini75718982acini
actin74922552actin
adit56443652adit
aeon45634612aeon
again65218122again
aging77026352aging
agio57828452agio
agon56531882agon
ahi68040232ahi_
ahing98928352ahing
ahis76135382ahis
ai211288392a_i_
aid49269072a_id
ail37171042a_il
aim57858212a_im
ains46158882a_ins
air38058392a_ir
airn46433832airn
ais39083572a_is
ait38093902a_it
akee85936812akee
akene95818662akene
alan46844082alan
algin65718762algin
alien56425582alien
alif76242142alif
align65016502align
aline57243152aline
alit46155692alit
alkie95520032alkie
alkine104916802alkine
aloin55227422aloin
amain74922912amain
amen66733152amen
ami56646812ami_
amia66836902amia
amid77036352amid
amie66339852amie
amine75835382amine
amino75425502amino
amins75534322amins
amir65129752amir
amis66445322amis
an211879082a__n
ani37751182ani_
anil46437432anil
anion55028812anion
anis45746462anis
anon46134852anon
apian75018332apian
aping87327232aping
aria46245422aria
arid57642712arid
aril45843022aril
asking116017232asking
auxin121411912auxin
avian84616052avian
avid88325962avid
avion84218342avion
awing96827322awing
awn68035912a_wn
axil116424452axil
axing138521372axing
axion1211316912axion
axis116127912axis
axon115524302axon
ayins85321612ayins
azan136521782azan
azine146721412azine
azon135725052azon
baking135626622baking
basin75026922basin
bin56658642_bin
blin67228172blin
brin67038192brin
cabin94820942cabin
cain65643912cain
caking134624672caking
calkin123515492calkin
catkin123512382catkin
chin96934742chin
coin66645352coin
din46459462_din
djin12911632djin
eking106614982eking
fagin9216572fagin
fain75840562fain
faking145520982faking
fakir125111492fakir
fin66458032_fin
foin77231562foin
gain56042162gain
gamin84423002gamin
gaskin113610582gaskin
gin46055752_gin
grin55733722grin
hakim14311832hakim
hin67559562_hin
ikon85814952ikon
in28150862__in
jin106443932_jin
join116724832join
kaif116933932kaif
kail85131492kail
kains96125642kains
kaki76520912kaki_
kakis86116842kakis
kaon87521022kaon
karn86129412karn
ken76343982_ken
ki67537952_ki_
kid86540612_kid
kif105941182_kif
kiln85620972_kiln
kina85631992_kina
kind96128552_kind
kine85643422_kine
king95933652_king
kink76034392_kink
kino86233612_kino
kins85747902_kins
kip97042132_kip
kir76535672_kir
kirn87123432_kirn
kis78051472_kis
kit78559872_kit
lain46146282lain
laking115027042laking
lapin75222922lapin
layin84720332layin
lin37967372_lin
loin46838722loin
main65345522main
making134823852making
malkin122913152malkin
matin75132852matin
mavin105722952mavin
nankin1039672nankin
napkin1236902napkin
oaken95814382oaken
pain65647242pain
patin76832852patin
pavin105623202pavin
pein65834942pein
pekin111514422pekin
pin57066722_pin
pyin96823232pyin
quin135823922quin
rain46251732rain
raki87127832raki_
raking114728422raking
rakis95323442rakis
ravin85624652ravin
rawin85521472rawin
rein46040892rein
rin36663182_rin
ruin47430512ruin
sabin74924952sabin
sain45551292sain
saki85628482saki_
sakis95323672sakis
sarin55239252sarin
sasin54626572sasin
satin55935222satin
savin84625082savin
shin75634312shin
sin36265892_sin
skein94814412skein
ski74925692ski_
skid95720922skid
skim105322512skim
skink85916852skink
skins94723462skins
skint95629222skint
skip105421752skip
skis84825292skis
skit85437532skit
spin66231302spin
tain45548072tain
taken94819142taken
taking114725952taking
takins105117402takins
thin76732392thin
tin36362172_tin
twin76023082twin
tyin76424002tyin
unakin10310962unakin
vain75233002vain
vakil1259792vakil
vein75625752vein
wain75840202wain
waken124818472waken
waking144821382waking
whin105225692whin
win66456292_win
yin67648732_yin
zayin174512042zayin
zein135620602zein
zin125643772_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.266671770.7
2DLD Change Limit298722100.87634100.5
3Display Results2102100.0603500.0
 (SQL Overall)1786912101.202148661.4
 
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.