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

339 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
coin6664535(None) 
cain65643911cain
chin96934741chin
cion613330911cion
coif96337901coif
coign85013911coign
coil66439651coil
coins75834551coins
coir66327241coir
colin76231691colin
con510268021co_n
coni65534801coni
conin76232721conin
conn66229131conn
coon67248941coon
corn69945811corn
covin105621121covin
foin77231561foin
join116724831join
loin46838721loin
acorn75616622acorn
actin74922552actin
agin56132712agin
ain37579092_ain
akin86328032akin
aloin55227412aloin
amin66042242amin
ayin76331742ayin
bin56658632_bin
blin67228172blin
boil66335182boil
boing84725552boing
boink115516332boink
boon67142172boon
born67338412born
brin67038192brin
cabin94820932cabin
caid77837532caid
cains75334302cains
cairn75717512cairn
can57760132c_an
carn66245432carn
ceil65725062ceil
chain105723672chain
chi86228652chi_
chia96026622chia
chic115925202chic
chid106626402chid
china105022472china
chine105231722chine
chink145321592chink
chino105823312chino
chins105631462chins
chip116726422chip
chis95933312chis
chit96937462chit
choir105313592choir
chon96627792chon
chopin132712182chopin
cig67036182c_ig
cine66242942c_ine
cions75222852cions
cis57748032c_is
clan65633922clan
cline76428532cline
cling86424672cling
clink115320042clink
clip86924002clip
clon66232482clon
clown105214732clown
coal66939252coal
coat67558342coat
coax136922972coax
cob710258752co_b
cobb106421992cobb
cobia94117502cobia
cobs87043142cobs
coca88030642coca
cocain101315012cocain
cochin131313192cochin
cock126332902cock
coco87330602coco
cod69660122co_d
coda77029342coda
code77347732code
codein94916712codein
coden86128542coden
coding104024792coding
codlin94516432codlin
codon86522852codon
cods76848102cods
coed77140542coed
coff126930782coff
coffin14339812coffin
coft97939682coft
cog69552902co_g
cogon89120902cogon
cogs77340032cogs
coho97524492coho
coifs105718702coifs
coigne94612192coigne
coigns94410062coigns
coils75030082coils
coined94523602coined
coiner84323782coiner
coirs75221052coirs
cojoin1539492cojoin
coke107038382coke
coking134523882coking
coky137526822coky
col59360352co_l
cola66541392cola
cold77338772cold
cole66956112cole
colic95726172colic
colins85229042colins
colon78630192colon
cols66553082cols
colt67158242colt
coly96940532coly
coma87134852coma
comb106632112comb
come87547702come
comic114721812comic
coming114225452coming
comix163513192comix
comp106731252comp
cone67256962cone
conic95329792conic
conine84528552conine
coning94331822coning
conins84327232conins
conk106531442conk
conns75024232conns
cons66057692cons
cony96537832cony
coo59566362co_o
coof96643272coof
cooing94024922cooing
cook107236932cook
cool66940492cool
coons76737282coons
coop87238652coop
coos67456492coos
coot67860382coot
cop711162372co_p
cope86847382cope
copen94826432copen
coping113927662coping
cops86751372cops
copy116229802copy
cor59960942co_r
cord76740922cord
core67263112core
corf95941482corf
coria75828302coria
coring94433962coring
cork106635692cork
corm85735372corm
corns76034762corns
cornu75921322cornu
corny106023272corny
cors66656442cors
cortin82423142cortin
cory96941512cory
cos510270392co_s
cosh96127622cosh
cosie74728262cosie
cosign958782cosign
cosine83823512cosine
coss66143492coss
cost68057942cost
cosy97232702cosy
cot510483222co_t
cotan71521782cotan
cote66648732cote
coting94629252coting
cots68054842cots
count74932052count
coup86729792coup
cousin8517152cousin
cove95837072cove
coven106925042coven
coving124321522coving
covins114618062covins
cow89856712co_w
cowing124526322cowing
cowl97530812cowl
cows97046642cows
cowy126427362cowy
cox1210346782co_x
coxa136922962coxa
coxing164218862coxing
coy810557552co_y
coying124021482coying
coys97537242coys
coz149345362co_z
cozen165019702cozen
cozie163519122cozie
cozy185823802cozy
crib86323572crib
cris66233432cris
crit65743712crit
croon75522782croon
crown105620082crown
cuif96529132cuif
cuing85420192cuing
cumin94616972cumin
curn66731882curn
cutin75022772cutin
cyan96419622cyan
din46459462_din
djin12911632djin
doing74923582doing
doit56347852doit
don46757652do_n
down86427492down
eloin55923202eloin
eon36052082eo_n
eosin55220922eosin
fain75840562fain
fin66458032_fin
fohn106116552fohn
foil76433912foil
foins85523382foins
fon66352272fo_n
gain56042162gain
gin46055752_gin
going75218492going
goon57236172goon
gown85724072gown
grin55733722grin
groin65521082groin
hin67559562_hin
hon67759382ho_n
horn76735612horn
icon66922042ico_n
in28150862__in
iodin64419342iodin
ion36051022io_n
jin106443932_jin
john145512902john
joins125818412joins
joint125227722joint
kain85334292kain
kin76353962_kin
koan85425032koan
koi77534742koi_
koine9516482koine
kois85129392kois
lain46146282lain
lin37967372_lin
lion46334442lion
loan47436452loan
login66025002login
loid55531482loid
loins56728422loins
loon47344792loon
lorn46435252lorn
lown76929292lown
main65345502main
moan65832012moan
moil65534082moil
mon57561572mo_n
moon67140812moon
morn66237562morn
mown95424442mown
noil46133242noil
noir46722432noir
noon47134622noon
noun45724182noun
oi29061482_oi_
oil37452052_oil
oink85429342_oink
on28057182_o_n
own66429702_own
pain65647242pain
pein65834942pein
pin57066722_pin
pion67235292pion
poi57244662poi_
poind84217912poind
point75338732point
pois66539042pois
poon67341262poon
porn65636022porn
pyin96823232pyin
quin135823922quin
quoin144012322quoin
rain46251732rain
recoin84320292recoin
rein46040892rein
rin36663182_rin
roan47234202roan
robin74820272robin
roil46235292roil
rosin55325312rosin
ruin47430512ruin
sain45551292sain
scion72214992scion
scorn75817442scorn
shin75634302shin
sin36265892_sin
skin85927522skin
soil46138822soil
son37761952so_n
soon46240502soon
sorn46641062sorn
sown75127452sown
sozin14514522sozin
spin66231302spin
tain45548072tain
thin76732382thin
tin36362172_tin
toil46536282toil
toit46353062toit
ton310265102to_n
toon47740632toon
torn46044252torn
town76928702town
toxin124716712toxin
twin76023082twin
tyin76424002tyin
vain75233002vain
vein75625752vein
void86220562void
wain75840192wain
whin105225692whin
win66456292_win
won66252062wo_n
worn75631752worn
yin67648732_yin
yogin98317742yogin
yon67348952yo_n
yoni77524392yoni
zein135620602zein
zin125643772_zin
zoic152316072zoic
zoon137326982zoon

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.0931921408.6
2DLD Change Limit298723391.29623049.4
3Display Results3393390.1432370.6
 (SQL Overall)1786913391.532116639.0
 
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.